PERMISSIONS REQUIRED: You must have Billing Permissions.
The system provides a Billing Report that is specifically formatted for uploading into QuickBooks Online. You'll want to adjust your import settings on the QuickBooks side to accommodate the export before importing.
Export
- Click Billing tab in primary navigation bar.
- Click Export Transactions in side menu.
- To match QuickBooks formatting, you can select a Date Range and either Transaction Method, Client ID Number, Transaction Notes, or Payment Number to appear as a column in the Report. The Transaction Date and Amount will pull to the report automatically.
- Click the Export Transactions to .CSV button.
NOTE: Transactions are available for export for up to 15 months back. The Gross Transaction amount is exported for credit card transactions. We recommend you limit your date range to one month or less, as accounting software often limits the number of transactions that can be imported at once.