Skip to content

Top Tip: Exporting Transactions From Bill.com Using CSV Files

July 24, 2012

How do I export Bill.com transactions using CSV files?

Bill.com integrates with popular accounting packages, such as QuickBooks, Sage 50, Intacct, Thomson Reuters, and Netsuite, so all your data is accurate and synchronized, and all your existing financial precesses and reports carry on as usual. However, if you don't use an accounting software that we integrate with, you will export your transactional data (bills and payments) from Bill.com into your accounting software, using CSV files.  

As a one-time setup, you will enter in these accounting preferences:

  1. In the upper right, mouse over Image. Then click Settings > Overview.
  2. On the Overview page, under Sync, click Import/Export.
  3. On the Sync page, click Setup account preferences.
  4. Click Edit.
  5. Select the proper account fields and click Save.

 

You'll use reports to export your payables transactions. These export reports can be downloaded in .csv format. You will then import them into your accounting software, and then will show up as Journal Entries in your GL.

  • In Bill.com, under the Export Reports section you will see the following reports, which are relevant:

    a. Accrual Summary Report
    b. Accrual Detail Report

    c. Cash Summary Report
    d. Cash Detail Report

    e. Unpaid Accrual Summary Report
    f. Unpaid Accrual Detail Report

  • The most popular option is to use the Cash Detail report, which gets details of all the payments for a certain period (e.g. Feb 2012), and then separately accrue for Unpaid Bills at the summary level, using the "Unpaid Accrual Summary Report".
  • You can also export your Accounts Receivables transactions, using the Open Invoices and Received Payments reports.

 

Have Questions? Visit answers.bill.com.

 

Advertisements
One Comment
  1. It`s a good way to store our bills and receipts by uploading in CSV files. From this we can give security and can save our documents from any damage or natural damage. Services like these are mostly used these days and these make a great impact on business decisions.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: