Revised: 09/24/2015
Go to Reports>>Trial Balance
This program will generate a general ledger trial balance based on the selections entered. Notations will be displayed on the report to show the selection criteria used to generate the report.
At the top of the view are the following functions:
General ledger account numbers may be printed in different segment order based on standard and User Defined Ordering setup in the General Ledger Settings file.
Standard is the default sort order and prints out the trial balance with general ledger accounts in the order shown under General Ledger Settings>>Account Control.
Other sort orders may be defined and named by the user in General Ledger Settings under the User Defined Ordering tab. Up to five different sort orders may be entered.
Sort order may be left at the default order of standard or changed to a user defined order.
Depending upon account setup there may be one to nine segments available for summarization.
Segments that are checked, beginning with the last segment, will be summarized up to the preceding segment. No detail will print for the checked segment.
All segments are dimmed, except the segment that is available to select.
As segments are checked, the preceding segment will become available.
Enter or select an account to begin the trial balance with, or leave the field blank to default to the first account.
Enter or select an account to end the trial balance range with, or leave the field blank to default to the last account.
Select one of the following:
All
This Month
Last Month
This Quarter
Last Quarter
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
This Year
This Year to Date
Last Year
Last Year to Date
Custom (allows you to select your own dates)
Based on the date criteria selected, the start and end date will automatically fill in with a date range with the following exceptions:
If Custom is selected the start and end dates will be blank allowing the user to enter a "custom" date range.
Displayed date ranges may be changed
Enter or remove a check mark by clicking in the box. When the box is checked, monthly totals will print on the trial balance.
Enter or select a general ledger account segment value, into the appropriate segment field, to generate a trial balance with all occurrences of the segment value within the other options selected.
For example:
If your first segment had numerical values in the general ledger account structure of 01 - 99. You could choose to enter the numerical value of 22 in the first segment filter field. All account numbers that began with 22 would print on the report.
Select one of the following levels for the trial balance:
Summary - The trial balance will only print the balances for each account number listed.
Detail (Memo)- When the source is AP the report will show the accounts payable distribution reference information.
Detail (Desc) - When the source is AP the report will show the accounts payable vendor.
Detail (Both) - When the source is AP the report will show both the accounts payable distribution reference information, the accounts payable vendor, vendor number and line number.. (Note: The report will have more pages as each AP source will show two lines of information)
Detail (No Sub)
Expanded - For compressed mode of posting, expanded will print out a line for every entry posted to an account.
Place a check mark in this field if you want accounts that have no activity for the date range selected to print on the report.
When this field is checked, memo closing entries will be included on the report.
When this field is checked, allocation detail will not be included on the trial balance.
When Only Print Accounts Marked F/S is checked, the trial balance will only show information for accounts that have the Print on Financial Statements Only box checked.
When this box is checked, the Trial Balance will treat the Start Date as if it is the beginning of the fiscal year.
For Balance Sheet accounts, this will have no effect.
Profit and Loss accounts will have beginning balances of zero. Debits and Credits for the reporting period will be shown. The Net Change and Ending Balance will be the difference between the Debits and Credits in the reporting period.
The last reported balance on the report will be Outside Period Net Income. This is the net income or loss for the period between your actual end of year and the start of this report.
Note: It is recommended that the Trial Balance not be run with both the Include Memo Closing Entries and the Treat Dates Entered as Fiscal Year boxes checked.