The Trial Balance report shows the total debits and total credits to each account for the selected period, as well as Year To Date amounts.
The report is set to be generated in PFD format. It also defaults to the following which all can be changed.following default filters are set:
Hides Zero Balances
Summarise Trade Receivables/Payables
Hide Zero Balances (Trade Receivables / Payables only)
Exclude Year End Journals
...
Run the report using the required filters in ACAS.
Click on the Export To button and select the CSV option.
Save the report in the required location and with the correct name.
Open Excel (a new or existing file).
Click on the Data menu and select the From Text/CSV button.
Navigate to the saved CSV file.
The import wizard will automatically detect that it is a tab or comma delimited text file and show an example of the data. Click the Load button.
The data will be added to a new sheet as a query and can be manipulated as desired.