The G/L Direct Trial Balance grid provides two summary views of your trial balance. The Tax Code view displays the totals for each tax code. The Accounts view displays the totals for each account.
To display the Trial Balance grid views, do the following:
Open Return Manager.
Open a return that has been set up for G/L Direct processing.
Click
Trial Balance in the
Account Maintenance group on the G/L Direct ribbon.
If needed, do either of the following to display the desired view:
Click Tax Codes in the Trial Balance group on the ribbon, or press Alt-T to display the Tax Codes view of the grid.
Click Accounts in the Trial Balance group on the ribbon, or press Alt-S to display the Accounts view of the grid.
Drilling Down in the Grid
Direct editing of amounts in the grid is not allowed. A drill-down feature allows you to look through and edit the entries that make up the displayed totals.
Do any of the following to activate the drill-down feature:
In Tax Codes view, select a row and click Tax Code Balances on the ribbon or press Alt+X.
In Accounts view, select a row and click Account Balances on the ribbon or press Alt+B.
In either view, double-click a blank area in the desired row, or select a cell containing an amount and press Enter.
Finds the specified word, words, or value in any column. Enter the complete criteria to search for specific records or partial information to search for similar matches.
Copy
Makes the highlighted information available for pasting to another location without removing the highlighted information.
Column Display Options
Allows you to select the columns to hide or display in the grid. Your selections only affect the current return and are saved when you save the return. See Selecting Trial Balance Grid Columns for more information.
Tax Codes
Displays the Tax Codes view.
Accounts
Displays the Accounts view.
Tax Code Balances
Activates the drill-down feature that allows you to examine and edit the individual entries that make up the balance in the tax code.
Account Balances
Activates the drill-down feature that allows you to examine and edit the individual entries that make up the balance in the account.
Trial Balance Report
Displays the Print window, allowing you to select your options to print the report.
Report Preview
Displays the Trial Balance Workpapers report in the View G/L Direct Report window.
Grid Options
Allows you to edit the Trial Balance display options.
Quiklink
Takes you to the line on the tax return input that corresponds to a selected tax code (Tax Codes view) or the tax code assigned to a selected account (Accounts view).
In both views, the first three lines in the grid display the total debits, total credits, and any differences.
Cells can be selected to be copied, but cannot be edited directly on the grid.
Tax Code Summary rows are used if you have multiple suffixes (the last 4 characters of a tax code) attached to a single prefix (the first 5 characters of a tax code). These rows are displayed in red and the only values associated with them are current and prior year tax trial balances. System-generated tax code suffixes and entity or property numbers can also generate a Tax Code Summary row.
Column
Description
Tax Code
Displays the tax code.
Entity/Property Number
Displays the entity or property number if there is an entity or property associated with the tax code. Examples of entities or properties include rentals and farms.
Description
Displays the description of the tax code. If the description is wider than the column in which it is displayed, hover your mouse over the description to reveal the entire description.
Sch.
Displays the tax return schedule that is associated with the tax code.
Line
Displays the line on the tax return schedule that is associated with the tax code.
Current Year Unadjusted T/B Debit/-Credit
Displays the current year unadjusted trial balance amount.
Current Year AJEs Debit/-Credit
Displays the total of the current year adjusting journal entries.
Current Year Adjusted T/B Debit/-Credit
Displays the current year adjusted trial balance amount.
Current Year Temporary Differences Debit/-Credit
Displays the current year temporary differences of the tax code. This column is only applicable if a Corporation, S Corporation, or Partnership return is open. For applicable rows, the sum of the temporary differences and the permanent differences equal the tax journal entries.
Current Year Permanent Differences Debit/-Credit
Displays the current year permanent differences of the tax code. This column is only applicable if a Corporation, S Corporation, or Partnership return is open. For applicable rows, the sum of the temporary differences and the permanent differences equal the tax journal entries.
Current Year TJEs Debit/-Credit
Displays the total of the current year tax journal entries. For applicable rows, the sum of the temporary differences and the permanent differences equal the tax journal entries.
Current Year Tax Return T/B Debit/-Credit
Displays the current year tax return trial balance. This amount is the sum of the adjusted trial balance and the tax journal entries.
In both views, the first three lines in the grid display the total debits, total credits, and any differences.
Cells can be selected to be copied, but cannot be edited directly on the grid.
Column
Description
Account Number
Displays the account number.
Description
Displays the description of the account number. If the description is wider than the column in which it is displayed, hover your mouse over the description to reveal the entire description.
Acct. Type
Displays the type of account. The following account types are used:
A = Asset
E = Equity
L = Liability
M = Memo
R = Revenue
X = Expense
Blank = None or unassigned
Tax Code
Displays the tax code assigned to the account number.
Important: If this column is blank, there is not a valid G/L Direct tax code assigned to the account number and the account's balance will not be included in tax calculations.
Entity/Property Number
Displays the entity or property number (if any) associated with the tax code assigned to the account.
Current Year Unadjusted T/B Debit/-Credit
Displays the current year unadjusted trial balance amount.
Current Year AJEs Debit/-Credit
Displays the total of the adjusting journal entries for the account.
Current Year Adjusted T/B Debit/-Credit
Displays the current year adjusted trial balance amount.
Current Year Temporary Differences Debit/-Credit
Displays the current year temporary differences. This field is only applicable if a Corporation, S Corporation, or Partnership return is open. For applicable rows, the sum of the temporary differences and the permanent differences equal the tax journal entries.
Current Year Permanent Differences Debit/-Credit
Displays the current year permanent differences. This field is only applicable if a Corporation, S Corporation, or Partnership return is open. For applicable rows, the sum of the temporary differences and the permanent differences equal the tax journal entries.
Current Year TJEs Debit/-Credit
Displays the total of the current year tax journal entries for the account. For applicable rows, the sum of the temporary differences and the permanent differences equal the tax journal entries.
Current Year Tax Return T/B Debit/-Credit
Displays the total of the current year tax return trial balance for the account. This amount is the sum of the adjusted trial balance and the tax journal entries.
Prior Year Tax Return T/B Debit/-Credit
Displays the prior year tax return trial balance amount for the account.
In the Tax Codes view, Net Income Per Books does not appear on the Trial Balance grid for a Corporation, Partnership, or S Corporation return. For those tax products, this tax code is automatically calculated by the system. Including it on the Trial Balance grid would cause the totals to be out of balance.
For an Exempt Organization return, tax code 10700.0000 appears on the Trial Balance grid and is treated the same as any other tax code. It is not calculated by the system and does not cause an out-of-balance condition.
Explain the commands on the Trial Balance grid ribbon.