Printing Journal Entry Reports - Trial Balance

Overview

Use this job aid to print the Trial Balance for the month end process. Before you run income statements, the Trial Balance should be run and reconciled with the subsidiary ledger accounts.

To print the Trial Balance:

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

2. Select Report Manager, then Select Journal Entry Reports.

   Open

   

    

3. For this job aid we are using standard reports, so choose option 1, Print Journal Entry Report and click Select.

   Open

   

    

4. From the list of Journal Entry Reports, highlight Trial Balance Report and click Select.

    

5. On the Range Selection Criteria window the Ledger Period will default to the current period. To select a different period, type Prev for the previous period, Next for the next period. Any field with a lookup button is a searchable criteria field and any field with a calendar button will allow you to set date parameters. After criteria has been entered Cick OK.

    

6. In the Value Selection Criteria window, there are two columns. These columns enable control of comparison criteria. Acceptable values for the option column are listed on the right hand side of the window. For example, to produce a report limited to accounts with a debit amount equal to or greater than $5,000 you would enter option 4 in the option box for Debit Amount and type a value of 5000 in the value box. Because we are preparing a month end we will not enter any selection limiting criteria.

7. Click OK.

    

8. In the Subtotal & Other Options window, type option 1 to subtotal this level. The different options are listed in the top right of the window.

9. In the Legend Line you can type a comment that will display in the upper left corner of the report.

10. In the Print Journal Entry Detail? box, type a Y to include the General Ledger distribution lines on the report. For this job aid we are using the default N to exclude that detail.

11. In the Print Grand Total Information? box, type Y to accumulate numeric value fields for grand totals and indicates the total number of records on the report. For this job aid we are using the value of Y in this box.

12. Click OK.

     

13. In the Print Account Balance Information? box, type a Y to calculate and print the beginning and ending balance for the journal period for each account. For this job aid we have selected a value of Y.

14. Click OK.

     

15. Choose printer output, print type, copies, and/or pages to print and click OK. For demonstration purposes we chose option 6. A more common response is 5 to print to spool.

     

     

Learn more about Financial Reporting feature: