All Collections
Sending Invoices to QuickBooks (via CSV)
Sending Invoices to QuickBooks (via CSV)

This article will show you how to send invoice information from Rabbet to QuickBooks

Derek Foresman avatar
Written by Derek Foresman
Updated over a week ago

Once all documents in your draw have been reviewed and assigned properly to the budget line items, and you are ready to finalize the draw, the last step is to send invoice payments to your accounts payable system, QuickBooks.

Setup Your QuickBooks Account for CSV Import

Using the QuickBooks Import from CSV Manual as a guide, you will be able to map fields from a Rabbet-generated CSV to import to relevant QuickBooks fields. The mapping in Quickbooks is a one- time set up that you can re-use as long as you maintain the same import format.

Create your Rabbet CSV Export

Navigate to Reports > Invoice Summary within your portfolio to view your payable documents:

Create & save a custom view to ensure that your columns in Rabbet match exactly your columns needed for import into QuickBooks. Again, mapping in QuickBooks is a one-time set up that you can re-use as long as you maintain the same import format. See below for creating this custom view:

We would recommend filtering by Project & Draw to ensure you are only sending the current batch of payable documents, but you can customize this default view as necessary:

Sending Payments

Once you've verified that each document to be posted to accounts payable looks correct, click 'Export to CSV' to automatically download a CSV for import into QuickBooks:

After Posting Payments

After successfully uploading your CSV into QuickBooks, all posted payable documents will be automatically pushed into your company's connected QuickBooks inbox. Those with access to QuickBooks will be able to confirm and review the documents that have been posted within this inbox.

Do you have questions or feedback? Please email us at

Did this answer your question?