Create, edit, and print financial reports

Note: The following procedure describes how to create a consolidated company financial report. If you are creating branch-specific reports, see Create branch specific financial reports

1. Go to Accounting > General Ledger > Financial Reporting.

   

2. Click New.
3. In the Report box, type a name for the report you are creating, and then press the Tab key.

   Note: If a report of the same name already exists, Inform ERP will open that report.

4. Click the Set Up tab.

   

5. From here you can add columns to your reports and set report options to customize your report:
   • Column Settings: Use this tab to select report headings. Under Available Headings in the left column, click the report heading you want to include. Drag and drop that heading into the right column under the Selected Report Headings area.

     Note: If you want to include the revenue percentage column–%REV–some additional configuration is required. See Add "percentage of revenue" calculation to financial reports.

   • Report Settings: Use this tab to enter the General Ledger groups, totals, and comment lines that will be included in the report. To add a line to the report, first select the type of line from the drop down menu in the Operator field.
     Options include:

     • Add: Adds the values in the selected G/L Group to the report. Choose this option, then enter the group in the GL Group field and press Tab.
     • Subtract: Subtracts the values in the selected G/L Group from the report. Choose this option, then enter the group in the GL Group field and press Tab.
     • Subtotal Group: Totals the values for any groups listed directly above this line. Including another Subtotal Group line after the first will subtotal only groups listed between the first and second subtotal on the report. ¹
     • Grand Total: Totals the values for all Subtotal and Totals listed above this line. If you want to insert multiple Grand Total lines into a report, use a Zero/Reset Total line directly after the Grand Total. ¹
     • Totals 1-9: Totals the values for any Subtotal Groups listed directly above the line. Including another Total line after the first will total only subtotals listed between the first and second total on the report. ¹
     • Zero/Reset Total 1-9: Resets the running total to zero. This line should be inserted directly following a Grand Total line if you would like to include multiple Grand Totals on the report.
     • Comment Line: A blank line that can be used to enter a heading or break in the report. After selecting Comment Line, enter your text in the "Comment/Group" field.¹

     ¹These totals and subtotals can have descriptions entered for them in the Comment/Group field after they have been selected.

6. Click Save.

Standard reports include the Balance Sheet and Income Statement.

• The Balance Sheet provides a snapshot of your company's standing with regards to assets, liability and equity. When reviewing a Balance Sheet, your total assets must equal the sum of the total liability and total equity.
• The Income Statement reflects your company's profit or loss for the year. It should include every account with a number below the P & L Break Account. If you have multiple branches, you may have an Income Statement report for each branch, as well as a Consolidated Income Statement including all branches. See Create branch specific financial reports.

The net incomes shown on your Balance Sheet, Income Statement, and Trial Balance should match. For more information on comparing your reports, see Validate financial reports.

Custom reports include any reports created using the procedure above.

1. Go to Accounting > General Ledger > Financial Reporting.
2. In the Report box, type or search for the name of the report you want to print, and then press the Tab key.
3. On the Criteria tab choose the period on which you want to report from the Calendar Period or Fiscal Period, and then press the Tab key. Inform ERP will fill in the corresponding period. For example, if you enter Fiscal Period 1218, the corresponding Calendar Period will autipopulate.

   

4. Select the check box beside each G/L Suffix that you want to include in the report, or leave them all cleared to include them all.
5. Select the type of report: Summary or Detail. If you choose Detail, then you can also choose to show the individual General Ledger accounts by checking the Show G/L Account check box.
6. Click Run.
   • Running the report will create an Exceptions tab. This tab displays any ungrouped General Ledger accounts. If there are accounts listed under your Exceptions tab, your report figures may not match your Trial Balance. Click on the account number hyperlink to open the G/L Account screen and link the account. You can then re-run the report.
     
   • To view the report, click the Report tab.
     
     To view transaction details in the G/L Inquiry screen, click on any of the hyperlinked groups or accounts. From the G/L inquiry screen, you can return to the report by clicking the Exit button.
   • To print the report, click the Print button. On the Print Document pop-up that appears, you may choose to Print, View, Send, or Save the document, depending on your needs.
     

1. Go to Accounting > General Ledger > Financial Reporting.
2. In the Report box, type or search for the name of the report you want to print, and then press the Tab key.

   

3. Click Edit.
4. Modify the report as described above.
5. To save your changes to the existing report, click Save . To save the changes as a new report, click Save As and give it a new name.

1. Go to Accounting > General Ledger > Financial Reporting.
2. In the Report box, type or search for the name of the report you want to print, and then press the Tab key.
3. Click Edit.
4. Click Delete.

   

5. On the confirmation message that appears, click OK.