Follow

Exportation of Cash Trial balance Reports to CSV Format (Excel)

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.

 

  1. Start at the Home 
  2. Click on Cash Book Reports image001.png
  3. Click on Accounting Reports image002.png
  4. Click on Cash Trial Balance image003.png
  5. Choose the months and bank accounts you wish to report on.  The report filters are: image004.jpg
    • Report types

      Totals

      Transactions only

      Transactions and Splits

      Splits only

      Outstandings only

      Notes only

      Check for Error

      Creditor/Debtor Summary

    • Code Set

      Standard – from your code list

      Accountant’s – your accountant’s code set

    • Basis

      Cash Book Date – date of transactions

      Bank Statement Date – as at the bank statement date

    • Print Transaction Outstanding

      At beginning of period

      At end of period
  6. Click on the green tick to display the report.Capture2.JPG

  7. Click on the Excel button excel.png to save this report in .csv format image005.png image006.jpg
  8. Click on the save button image007.jpg
  9. 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

    image008.jpg

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

Comments