This article is part of a series of Knowledge Base articles covering Custom Financial Statement Templates.
This article is also available as a video:
- Click on the loan you would like to add a custom template to. You will need to be on the main page of the loan to begin. Once you are on the General page for the loan click on the Loan Analysis menu option, it will be to the left of the screen then click Financial Statements from the sub menu that appears.
- When the financial statements page loads, click the green add button. A pop up will appear.
- The first field in the pop up is the Analysis Type field. Select which of the four types the analysis is for. Remember only Company and Personal types can have a custom template.
- If there is a specified default template it will populate the Template field after you make your selection. If there is a different template you want to use or do not have a default set, select a template from the Template drop down menu. All relevant active custom templates in the system will appear, simply click on the template you would like to use to choose it.
- Next select the name of the company or the name of the individual, the field will change based on whether this is a Company or Personal Analysis type.
- If needed you can select a prior loan to incorporate historical periods from said prior loan into this statement.
- After selecting a Company or Contact, the Description field will prepopulate with the same value. You can edit this if you would like.
- Review what you have filled in and click save.
- Once you click save the pop up will disappear and you will be on the statement page. The statement layout should reflect the layout of the custom template. Now you have to fill out the template and this part is essentially the same as it used to be.
We will focus on new features of this page. This is not a complete guide to filling out a statement.
- The first step is to add a period and that is the first place we can see some additions. To add a period, click the green add period button, you can find on the left side of the screen. A drop down menu will appear in which you can fill out details for the period you are adding.
- We can see a new addition here. The Analyst field. You can assign who entered the data for the specific period. It pre populates with the user that is logged in, but you can edit the field by clicking the X button next to it. You can leave the field blank or add another user.
- The check box labeled Include in Forms and Reports is checked by default, unless the loan is in funded status. If the loan Is in funded status and you want to include the period in Forms and Reports, make sure you check the box.
- When you finish filling out the information you would like to add to the period, click the Add Button. The menu will disappear and you should see the period added to the sheet on the screen.
- The columns headings have icons that can give you some information at a glance:
- The star icon indicated the period is used in Proforma calculations.
- The lock icon indicates the period is locked to prevent data overwrites on import. The system locks once the loan has a status of approved, but can be unlocked.
- The icon that looks like a page of paper indicates that the period is set to appear in forms and reports.
- If you click on the view button ,you will notice a new option added to the Percentages section for trend analysis.
- The common size percentage tells you the percentage value of that row in relation to the total. For example if the asset total is 100 and the data in the row is 10, the common size percentage would be 10%.
- The trend analysis percentage will display the percentage change from one period to the next for each row. For example, for the period 2020 the Total Current Assets was 100. In 2021 it increased to 150. With the trend analysis percentage option selected, the system will calculate that this represents a 50% Increase.
- Only one percentage option can be selected at a time. If one is selected that will be the one used when printing or exporting from the financial area. When generating the credit memo for SBA it will default to common size as that is what SBA requires.
- Once you finish entering data and selecting options as needed, click save.
There is a change to the COGS section that you should be aware of:
- If we take a look at a Financial statement before the update, We can see that the COGS breakdown is in its own tab. Entries made in the COGS tab are linked to the income statement tab.
- Now let’s take a look at it after the update. The COGS data is now included directly in the income statement itself. Notice there is no COGS tab anymore, but if we look at the Income Statement, there is a new Cost of Good section where you can add the COGS data.
There are some changes to the income statement that you should be aware of:
- The sales rows have been updated. The total sales row has been updated to Total Revenue, and you can now include a breakdown of where the revenue comes from.
- If you scroll further down the Income Statement, you can find two new calculations: EBIT - Earnings Before Interest and Taxes and EBITDA - Earnings Before Interest, Taxes, Depreciation and Amortization.