Create a Cash Trial Balance Report

The Cash Trial Balance Report is used by accountants to get a listing of all the transactions for a period, including the GST. 

A Cash Trial Balance Report can be printed in a variety of formats. When sending data to your accountant, it is sound practice to send a copy of at least the Totals Report and one of the more detailed reports. 

Options include a list of outstanding transactions at the beginning and end of the period. 

Please note: The options displayed on the report screen will vary between Cash and Accruals files.

How to create a Cash Trial Balance Report 

  1. From the Home Page, click Cashbook 
  1. Click Report  

(You can to Step 3 by clicking on Cash Book Reports from the Home screen or the central menu of other screens). 

  1. Click Cash Book Reports 
  1. Click Accounting Reports 
  1. Click Cash Trial Balance  
  1. Select the options required as listed below as needed and then click the green tick

    The Cash Trial Balance report will be generated. The report will look different depending on the options you have selected. See the Cash Trial Balance Report Type Options section below for the different types of Cash Trial Balance reports that can be generated. 


Cash Trial Balance Report Type Options 

Totals: This will report only code totals and is generally only 1 or 2 pages. Print this report to give your accountant a summary of the period. 

Transactions only: Will list all transactions under their code headings with the total for the particular code but will not show splits details. 

Transactions and Splits: Provides a full report of all transactions for the period and bank accounts selected. Printing this option for a full year may be 20 to 30 pages. The transactions are printed in code order so that if your accountant wishes to check the transactions which make up a code total in the totals report, the details of the code are all in one place.

If you do not want the Allocation Name, Enterprise Name or Code Name included, check the appropriate box(es) shown below. 

Splits only: This will report the codes used within the period and list each split line for the code. This report is quite detailed. 

Outstandings only: This report lists only your outstanding transactions for the bank account and months selected. The date, codes and GST amounts are included in this report. 

Check for errors: This report will check for reconciliation errors. Please not that it its quite normal to see an error on a month that has not yet been reconciled. 

Creditor/Debtor Summary: This will report the codes used within the period and list each split line that contains the code. This report is quite detailed. 

These reports can be prepared for any period and any selection of bank accounts. 

Code Set Options

You can create these reports using either your own set of codes (Standard) or your accountant’s codes. 

Basis Options

Depending on what GST option is selected in your file, you will have different Basis options available. Select the Cash Book Date unless otherwise advised by your accountant. 

Below is a sample Cash Trial Balance report.

Was this article helpful?
3 out of 4 found this helpful
Have more questions? Submit a request