Auto spreading mapping configuration

Q2 Origination is enhanced to support the auto spreading of financial statements. The default templates are created for the following two financial statements:

• 1040 Individual tax form (US Region Only)

• Schedule C - of 1040 (US Region Only) - Schedule C is typically for borrowers who operate sole proprietorships or single-member LLCs. A Schedule C is the profit and loss statement for each business entity owned by the borrower. For example, John Doe owns Doe Toy Stores and Doe Toy Supplies. John Doe will have to submit the following forms every year:

  • Form1040

  • Schedule C for Doe Toy Stores

  • Schedule C for Doe Toy Supplies

  Financial data from Schedule C is captured to determine the overall cash flow from each business owned by the borrower. 

The financial data of these documents should be extracted and mapped into yearly financial statements for the borrower on the Financial Spreads page. To perform the mapping of these details, perform the following steps: 

1. Log in to your Salesforce account.

2. Go to  (App Launcher) > Origination Configuration > Financial Spread Mapping.

   

   The following templates are configured for the income statement and are available post-installation of Spring'22 packages:

   • Personal Statement and Tax Return

   • Sole Prop Schedule C

   • S-Corp Schedule E

   • Rents & Royalties Schedule E

   • Farming Schedule F

   • Partnerships Schedule E

   • Estates and Trust Schedule E

3. Select New.

4. To define a new mapping, perform the following actions as described in the following table, and then select Save:

   

   Field Name	Action and Information
   Financial Spread Mapping
   From Object	Select Tax Form 1040 for Form 1040 and Schedule C Tax Form 1040 for Schedule C.
   Financial Statement Template	Select the search icon to select Personal Statement and Tax Return for Form 1040 and the following for Schedule C: Sole Prop Schedule C S-Corp Schedule E Rents & Royalties Schedule E Farming Schedule F Partnerships Schedule E Estates and Trust Schedule E
   Additional Schedules Mapping
   Parent Template	Select the search icon to select Personal Statement and Tax Return. This section is displayed if you are defining the mapping for any Schedule C template.
   Financial Spread Mapping Details (Select to add new mapping)
   From Field	Select the field from the integration object that you want to map with the financial statement template details. This drop-down lists all the fields stored in the integration object.
   Financial Template Details	Select the financial statement template details to which you want to map the selected field of the integration object. This drop-down lists all the line items configured for the financial statement template.

   A message is displayed on successful mapping of integration object and financial statement template details, Success: Saved Successfully.

5. To edit a mapping, for the financial spread mapping, select and then select Edit. You can add/edit/delete the mapping details and then select Save.

   Note:

   The modifications to the mapping must apply to the new financial statement creation and must not impact the financial statements created prior to modification.