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:
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 email@example.com