Printing Financial Reports

Overview

Use this job aid to create an income statement and/or balance sheet for the current period. Printing a financial report is part of your month end procedures after you have balanced your trial balance to the subsidiaries like ACP, ACR, INV, etc. When creating this report employees can still be logged into the V9 system. The assumption is that all of the chart of accounts are set up correctly to pull information across to an income statement. It is also important to remember that your financial report will only be as good as the last time you calculated account balances; therefore, you may consider this a two part process, 1) calculate account balances, 2) generate a financial report.

To create an income statement for the current period:

Part 1: Calculate Account Balances

1. From the Toolbar, click LDG for General Ledger.

2. From the General Ledger menu, select Financial Reporting, and then select Calculate Account Balances.

   Open

   

    

3. In the Option box, choose #3 for Calculate Current Information Only. This option extracts information for a single period. The period may be limited to a single journal period or to a range of consecutively numbered journal periods.

   Open

   

    

4. In the Beginning and Ending boxes, type the journal period numbers to create the work file for.

5. Click OK.

    

Part 2: Print the Financial Statement

1. From the LDG General Ledger main menu, choose Financial Reporting, then select Financial Reports.

    

2. The next window shows the current period selected for the financial report.

3. Click OK.

    

4. Choose Option 1, Print Financial Reports.

    

5. Select the Standard Report you want to run, in this case it will be INCOME STATEMENT - CURRENT ONLY, or BALANCE SHEET - CURRENT ONLY.

6. Click Select.

    

7. In the Range Selection Criteria window, enter any limiting criteria for the report parameters relative to Detail Code, Profit Center, and G/L Location.  Date and Ledger Period are pre-determined by when you last calculated account balances. You can leave the criteria limiting fields blank. For this job aid these fields will be left blank.

8. Click OK.

    

9. From the additional options window, you may type 3 description lines that will display on the top left of the report.

10. In the Apply Conversion Factors To Amounts? box, type a Y to open separate input fields for specifying a division factor for amounts and quantities fields. These fields can be used to convert to a different currency or unit of measure.

11. In the Print Lines With Zero Values? box, type a Y to include accounts with a zero balance in the report. Type a N to exclude zero balance accounts from the report.

12. In the Print Total Information Only? box, type a Y to exclude posting accounts from the report. An input field is opened for specifiying the format level for summarizing totals. An N in this box means the report will include both posting and format accounts on the report.

13. In the Summarize Each Detail Print Line By? box, type a 1 for Account Code, 2 for Detail Code, 3 for Profit Center.

14. For this job aid no line descriptions have been entered, the yes/no boxes have been left at the default N, and summarizing detail is to 1 for Account Code.

15. Click OK.

     

16. In the Printer box, type the print location for the report. Option 5, print to spool enables you to readily reprint the report. For this job aid, print option 6 has been selected.

17. You may also change the print type, number of copies, and/or specify specific pages to print.

18. Click OK.  

     

19. Once you have completed the printing the V9 will return you to the main General Ledger menu where you may run a new report, calculate account balances for different period, etc.

Learn more about Financial Reporting feature: