Sign in

Exporting records and transactions from Bill.com using .CSV files

Avatar
Zendesk API
Follow

OVERVIEW

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

IMPORT/EXPORT SET UP

  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 

EXPORT TRANSACTIONS WITH REPORTS

  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 Bill.com, 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 Bill.com account will appear in your accounting software as Journal Entries in your General Ledger.

The following Bill.com reports are also helpful as you work to keep your accounting system in sync with your Bill.com 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.

EXPORT TRANSACTIONS WITH IMPORT/EXPORT

You can also use the Export function to export records from within Bill.com. 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.