The Cash Book Reports can be exported to a .csv format to allow you to import data into an Excel spreadsheet. This function will allow you or your accountant to access and manipulate the data.
- Start at the Home Page.
- Click on Cashbook Reports.
- Click on Accounting Reports.
- Click on Cash Trial Balance.
- Choose the months and bank accounts you wish to report on. The report filters are:
Click on the green tick to display the report.
- Click on the Excel button to save this report in .csv format.
- Click on the save button.
Open your Excel program and navigate to the folder where you saved this file.
In this case, it was C:\Users\agrimaster.support\Desktop\Cash Trial Balance – Splits 29 Nov 2018.xls.