Sign in

Exporting records and transactions from using .CSV files


If you use accounting software that doesn't sync with, use .CSV files to export transactions (bills and payments) from your account, and import them into your accounting software.   


  1. Hover over the gear icon, and then click Settings
  2. Under Sync, click "Import/Export"
  3. Click "Setup Account Preferences"
  4. Click the notepad icon to edit
  5. Enter the accounts to use from your accounting system
  6. Click Save 


  1. Click Reports
  2. Under "Export Reports", click "Cash Detail Report" (paid bills)
  3. Select the dates of the transactions you're exporting
  4. Click Download
  5. Save the downloaded .CSV file
  6. In, on the "Cash Detail Report" page, click Back
  7. Click "Unpaid Accrual Summary Report" (unpaid bills)
  8. Select an End Date that matches your Cash Detail Report
  9. Click Download
  10. Save the downloaded .CSV file
  11. In your accounting software, import the two .CSV files.

The transactions you import from your account will appear in your accounting software as Journal Entries in your General Ledger.

The following reports are also helpful as you work to keep your accounting system in sync with your Accounts Payable activity:

  • Accrual Summary Report
  • Accrual Detail Report
  • Cash Summary Report
  • Unpaid Accrual Detail Report 

To export Accounts Receivable transactions, use the Open Invoices and Received Payments reports.


You can also use the Export function to export records from within To use Export:

  1. Hover over the gear icon, and then click Settings
  2. Under Import / Export, click "Import / Export".
  3. In the column titled "Export Records to .csv Files", choose how you'd like to export:
    • Export All
      • Your export report will contain a complete list of all records for this entity. Simply click "Export All", and your export will begin immediately.
    • Customize
      • Here you can apply various filters to your reports, in order to get exactly the information you need, without having to manually manipulate a complete list of all records.
      • After applying filters, click "Export with filters". If you change your mind, and want to export a complete report of all records, click "Export all". Your export will begin immediately.
  4. Depending on the number of records, it may take several minutes to process your report; you can continue working, and return to the Export History page later to check its progress.
Have more questions? Submit a request