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

Export/Import Process

Update Preferences

1. Click Settings
2. Click Preferences under Import/Export
3. Click the edit icon
4. Enter the accounts from your accounting system
5. Click Save

Run Cash Detail Report

1. Click Reports in the left navigation menu
2. Click Cash Detail Report under Export Reports
3. Enter the date range of the transactions to export
4. Click Download
5. Toggle radio button to Save file
6. Click OK

Run Unpaid Accrual Summary Report

2. Under Export Reports, click Unpaid Accrual Summary Report
3. Enter the date range to match the Cash Detail Report
4. Click Download
5. Toggle radio button to Save file
6. Click OK

Import Reports into your accounting software

In your accounting software, import the two .CSV files.

Things to know

The transactions imported 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 to keep your accounting system in sync with the Bill.com Accounts Payable activity:

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

Export Account Receivable transactions

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

You can also use the export function to export records from Bill.com:

1. Click Settings
2. Under Import/Export, click Import/Export
3. Click Export in the column titled Export Records to .CSV Files of the entity you are exporting
4. Select the data export option:

• Export All
  • The export report will contain a complete list of all records for this entity
  • Click Export All and your export will begin immediately
• Custom Export
  • Filters are available to export exactly the information you need without having to manually manipulate a complete list of records
  • Click Export with Filters and manage the fields and values you'd like to filter
  • If you change your mind and want to export a complete list of records, click Export All
  • The export will begin immediately.

Depending on the number of records, it may take several minutes to process the requested report. Continue working and return to the Export History page to check the status.

Things to know

• The user permissions required for exporting data is Sync with Accounting System plus the corresponding permission for the object