Print Annual Trial Balance

Print Annual Trial Balance

This report was designed to export several periods to an Excel file so the data can be viewed in separate columns for analysis. Paper output yields multiple pages wide and tall. (Please Note: Excel exported reports will not total at the end of each column, so you will need to use Excel functionality to create formulas in columns needing totals.) When you enter this report module, the screen will appear as follows:



The cursor will be positioned at the Company ID (1) prompt. If applicable, use the drop-down menu to select a different Company. The Period (2) field will default to the first period of the current year in order to include all periods on the export/report. Type a different period if applicable. The default for the Select (3) box fields is This Year. You can click Next Year if that period is not open in the current year, or click the Previous Year (4) option and the system will display an FYE drop-down menu so you can select a prior year. If you click the Print Accounts with zero Balance (5) option, the report will exclude any accounts with zero detail. Click the Excel icon (6) to export to the data, or click the Print (6) button to print to paper or screen. To exit without printing, click the Cancel button.



    • Related Articles

    • Print Trial Balance

      This report prints a standard Trial Balance. It does not need to be formatted in the system like the other financial reports. The report includes a list of all G/L Account Numbers, descriptions, and the current balance of each account in either a ...

    • Balance Sheet

      This report must be formatted in the Report Format Maintenance module prior to printing. It will produce a Balance Sheet in the format most people are used to seeing. In one column, it will list all asset accounts with the current balance and place ...

    • Print A/P form 1099

      This report module will produce a Form 1099 for all Vendors that have a Social Security number entered in that field in the Vendor Maintenance module. The system will prompt only amounts paid to a 1099 Vendor in a year and will not include any ...

    • Vendor History by GL Account Report

      This report allows you to view Vendor activity broken down by G/L Account Number and will also give you additional data for each entry such as Posting Period, G/L Sequence, Invoice number, Check number, Checking Account, Paid Date and the Debit or ...

    • Account Maintenance Inquiry

      Initial set-up of your system Chart of Accounts has been completed for you. You will only utilize this module to add or edit G/L accounts and also to view archived data for closed periods/years for existing accounts numbers. You will also access this ...