Refreshing Balance Sheets and Income/Expense Spreads with Tax Form Data

Tax form data added to Lending Cloud can be imported into balance sheets and income/expense spreads. This tax form data maps to the corresponding accounts on the balance sheet or income/expense spread. After importing, it is recommended that you verify whether the applicable data has mapped correctly. Accounts with pre-existing schedule data are not overwritten when refreshing.

To import tax form information on individual balance sheets and income/expense spreads

1.    On Balance Sheet or Actual Inc/Exp screens, in the Tax Form drop-down list near the top of the screen, select the appropriate tax package.

2.    Click Refresh.

To import tax form information for multiple balance sheets and income/expense spreads at one time

1.    On Balance Sheet Trends or Income / Expense Trends screens, click the Page Actions button, then click the Refresh from Tax Form(s) option.

2.    For any balance sheet or income/expense spread appearing on the Refresh from Tax Forms dialog box, select the appropriate tax package in a drop-down list to the right. Up to six periods can be refreshed at one time.

3.    Click the Refresh button at the top of the dialog box.

Note  When adding new balance sheets and/or Income/Expense statements in Trends Manager, you can select the tax form that is used to populate a spread during it's creation. See Populating Spreads from Tax Forms in Trends Manager for information about designating tax forms to populate spreads.