You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Support > Ventures > Loan Analysis > Consolidating Financials with Different Periods
Consolidating Financials with Different Periods
print icon

The Consolidated Analysis Type option within Loan Analysis > Financial Statements is intended to combine each financial line item from all selected entities with the same periods/number of months.  If you wish to consolidate and account for entities with different number of months and/or unlike periods you may still do so by following the steps below.  

 

Step One

Enter the entities financial statements as desired and make sure each of those are marked Include in Forms & Reports so that they flow to the credit memo.

 

Step Two

Determine which entity(s) you are going to add an additional statement which will then match the others in terms of number of months (ex. Changing a 3-month interim to a 6-month to match the other entities interim).   In other words you are going to annualize statements for all or calculate up to match the one with the largest number of months or prorate to the statement with the lowest number of months.  You will then add a new statement with the matching Period End date and # of months.  But do NOT mark the Include in Forms and Reports.  This means that this year will not print on the credit memo but will be allowed to be used on the Consolidated Manage Period screen.  You may also want to consider duplicating the balance sheet information for the interim, so that it will flow to the consolidated spreadsheet.   

 

 

Step Three

Within the income statement line items apply the appropriate calculation based on your purpose.  In the example below it is taking a 3 month statement and making it a 6 month to match the other company’s 6/30/17 statement.  You have the ability to do the calculations within the cell as shown, =75/3*6 then provides 150.

 

Step Four

After applying the calculations to each line item you are now ready to go to the Consolidated statement, Manage Periods.  Make the selection for which statements you want to consolidate.  The below example shows all FY2017 is 6 months but the Affiliate One actual’s statement is only a 3 month.  Therefore, you would exclude the 3 month, instead opting for the 6 month one which we created in step 2.

Step Five
From Loan Analysis > Credit Memo select your Content (don't forget to add your consolidated to the Other field): Generate your Credit Memo you should have each entity’s financials as originally entered as well as your consolidated statement. 

 

 

Feedback
0 out of 0 found this helpful

scroll to top icon