The Trial Balance Worksheet lists the prior-period balance, unadjusted balance, all journal entries, and the adjusted balance for each account. You may also optionally include such information as tickmarks, separate debit / credit columns, zero balance accounts, and workpaper reference.
Open the File > Print Reports dialog by using one of the following methods: (1) clicking the Print button on the toolbar, (2) clicking the Print Reports icon on the shortcut bar, (3) choosing Print Reports from the File menu, or (4) pressing the CTRL+P shortcut keys. On the Reports tab in the Print dialog, double-click Trial Balance Worksheet to move this report to the Selected pane. With Trial Balance Worksheet still highlighted, click the Options button to open the print options dialog for this report.
Note: The Trial Balance Worksheet report prints in portrait format until the number of columns selected to print exceeds the page width, and then the report will automatically switch to landscape format.
Special information
- For consolidated clients, the subsidiary ID is displayed in the column heading of the Trial Balance Worksheet.
- For clients with locations or departments present in the Chart of Accounts mask, column headers in the Trial Balance Worksheet reflect the location or department description.
- For clients with locations and departments present in the Chart of Accounts mask, column headers in the Trial Balance Worksheet display the location description in the first row and the department description in the second row of the header.
- If the Trial Balance Worksheet is printed with a page break after each location and/or department, the location and/or department description is displayed at the top of the page.
Print options
Print options for a report may be saved as part of a report profile. Otherwise, print options automatically revert to their default settings when you unselect a report for printing or exit the Print dialog (unless the Save report options checkbox is marked in the Print tab of the Setup > User Preferences dialog).
General tab
Select the desired sort order from the drop-down list.
Select the basis for this report from the drop-down list. Your selection affects which options are available on the rest of the dialog.
- Unadjusted (default selection)
The Unadjusted worksheet prints with year to date balances and part-year balances (if selected) and then adds blank columns for you to fill in.
- Adjusted
The Adjusted worksheet includes any transactions that were entered as adjusting transactions in the current period.
- Report
The Report worksheet includes reclassifying journal entries. When rounding for financial statements, this basis is the only one that can be used with assurance of an in-balance, properly footed financial statement.
- Tax
The Tax worksheet includes any transactions that were entered as tax adjustments in the current period.
- Other
The Other worksheet may include such items as, Cash vs. Accrual or an State tax basis.
- Budget
The Budget worksheet includes any journal entries that were entered as budget adjustments in the current period.
Select one of the following options from the drop-down list:
- All (default selection)
- R & E (Revenue and Expenses only)
- A & L (Assets and Liabilities only)
This date, which determines what the program uses as the current period for the report, must equal an existing period end date. (Defaults to current period end date.)
Enter the number of blank lines to print after each account. (Defaults to zero.)
Print zero balance(Default = OFF)
To include accounts with zero balances, mark this checkbox and also choose one of the following options:
- Accounts with activity (default selection)
- All accounts
The following optional information may be included in this report. Mark the checkbox for each item that you want to include.
- Print combining accounts
Available only if the Chart of Accounts mask (on the General Ledger tab or the Trial Balance tab of the File > Client Properties dialog) is set up to accommodate locations and/or departments.
Note: If this checkbox is marked, the Include AJE description checkbox becomes unavailable (grayed). Journal entries cannot be displayed when printing combining accounts as they can be posted to location/department accounts only.
- Include grid lines
Not available if the Alternate background color on reports option is currently marked in the Print tab of the Setup > User Preferences dialog
- Include prior year balances
- Separate P&L and B/S columns
Available only if the basis is unadjusted.
- Include AJE description
Available only if the basis chosen is something other than unadjusted.
- Separate debit/credit columns
If you have chosen to separate the P&L and B/S columns, then separate debit/credit columns will not apply to prior-year balances. There are three options to choose from if this checkbox is marked:
- Default presentation (all columns display separately as debit and credit)
- Print net debit/credit amount
- Separate Adjustment columns only
Loc/Dept Selection tab
(available only when the Chart of Accounts mask includes locations and/or departments)
You may choose to include either all or selected locations/departments in this report. The Available (left pane) and the Selected (right pane) sections of this dialog are enabled only if the Print selected locations/departments option is marked.
This pane is enabled only if the Print selected locations/departments option is marked at the top of this tab.
All locations and/or departments in the client's database are listed here (except those already listed in the Selected pane). Double-click a department and/or location to select it for inclusion in this report.
You may choose one or more of the following options for this report:
- Combine location/department accounts
Location and department accounts are grouped together on the report.
- Page break after each location/department
A page break is inserted in the report after the accounts for each selected location and/or department.
Note: This option is available only if the sort order is set to Account number on the General tab of the Trial Balance Worksheet Options dialog.
- Print locations/departments in separate columns
This option is available only if the sort order is set to Loc/Dept grouped by combining accounts and both the Print Combining Accounts checkbox and the Print Combining Accounts Only checkbox are selected on the General tab of the Trial Balance Worksheet Options dialog.
Font tab
Typeface/Size
Page Layout tab
Page Layout and Page Orientation
See also: Trial Balance CS reports