Trial Balance

Top  Previous  Next

The Trial Balance report is a summary of account balances based on a specific period. The report includes the account numbers and descriptions, along with the totals for the prior year's balance, month-to-date activity, the year-to-date activity, and the current account balances. A subtotal is also printed for each group of accounts as defined in the Chart of Accounts.  A net profit/loss is calculated and displayed for the current month and current year columns.

 

Hint: Each of the four column totals at the bottom of the trial balance should always be zero indicating that the total debit entries equal the total credit entries in the general ledger. If any of these totals are not zero, then refer to the General Ledger Reconciliation Worksheet in this training manual for more troubleshooting assistance.

 

Button

Trial Balance - Current Year

Button

Trial Balance - Future Year

Button

Trial Balance - Future Year - Consolidated

Button

Trial Balance - Date Range

Button

Trial Balance - Prior Year vs Current Year

 

 

Trial Balance - Current Year (Class Code 656)


This report may only be printed as of the end of any month in the current fiscal year.  Drill down on the amounts to view detail transactions.  Warnings are displayed if the Trail Balance activity does not agree to the drill down detail.  If this occurs, perform the Ledger > Integrity Test > Update Gl Master option to correct the error.  

 

Note:  If you have not closed your fiscal year, then you may get a 'Balance Error' message on one or more g/l accounts if you are using the 'Current Report Totals' option to print the report.  This option will include activity in the new year in the drill down detail, however, the Current Year and Current Balance columns on this report will reflect the last day of the fiscal year that is currently opened in AB.  For example, if your December 2012 fiscal year has not yet been closed, then the 'Current Report Totals' option will include 2013 activity in the drill down activity but the 'Current Balance' will be as of the 12/31/2012.

 

 

Monthly Activity Totals - Current Fiscal Year Only (Class Code 656)


This report is very similar to the Monthly Balances Report in that it gives you the total activity for each month for each account in the Current Fiscal Year.  Unlike the Monthly Balances Report, this report is designed in MAR and has drill down capability to see the activity behind the summary.  

 

IMPORTANT NOTE: This Report should ONLY be generated with the CURRENT FISCAL YEAR option and the Fiscal Year End Date as the cutoff date.

 

 

Trial Balance - Future Year (Class Code 657)


This report may be printed for any future date - not just the end of a month.  Drill down on the amounts to view detail transactions based on the report cutoff date.  Columns include Prior Year Balance, Current Fiscal Year Activity, Current Fiscal Year Balance, Future Year Activity and Future Year Balance.

 

 

Trial Balance - Future Year - Consolidated (Class Code 659)


** This report is not yet available.  

 

 

Trial Balance - Date Range (Class Code 669)


The report may be printed for any date range - prior, current or future.  

 

Drill down on the amounts to view detail transactions based on the report date range.  If the detail drill down transaction record contains any additional supporting records, you may click on that transaction record to show those supporting records when applicable.  

 

Important Note: These secondary transactions are simply transactions that relate to the batch number and will NOT necessarily foot to the parent transaction record amount but rather serve for reference purposes only.

 

Columns include: Opening Balance as of Report Starting Date; Monthly Activity (based on report ending date); Total Activity for Report Date Range, Ending Balance (opening balance plus total report activity).

 

Note:  If the report date range does not include the first month of the fiscal year, then the 'Opening Balance' column will include amounts on the Income Statement type accounts and there will be an amount in the 'Report Totals' field which represents the net income or loss for the months preceding the report beginning date.  

 

 Example:  

 Fiscal Year End Date is 12/31/2022

Report Date Range is 01/01/2022 through 03/01//2022

o'Opening Balance' column report total will be zero.

       Report Date Range is 03/01/2022 through 03/31/2022;

o'Opening Balance' column report total will be the combined profit or loss for January and February

 

 

Trial Balance - Prior Year vs Current Year (Class Code 658)


Available in Traditional Version only.