QuickBooks Online integration
04. Sync transaction data

Push transaction data to your QuickBooks general ledger

1 min read

Key takeaways: Syncing transactions to QuickBooks Online

  • Push coded transactions from Extend directly into your QuickBooks Online general ledger
  • Automatically include receipts, attachments, and enriched transaction metadata not found in bank feeds
  • Ensure seamless reconciliation with data mapped to the correct accounting fields

Once transactions clear in Extend and have been coded to an account expense category you can push them to your QuickBooks Online general ledger. Extend also syncs receipt attachments and transaction metadata to your QuickBooks general ledger. This data will not show up on your credit card statement, but having it documented in QuickBooks Online can provide key supplemental information regarding your transactions. Transaction data will automatically map to the appropriate fields, making reconciliation totally seamless.

Transactions pushed to QuickBooks Online through the integration includes:

  • Merchant detail, transaction date, and amount
  • Any expense category coding (Account, Location, Customer/Project, Class, Vendor) 
  • Metadata—including virtual card name, virtual card holder, last 4 digits of the virtual card, funding source name, transaction reference ID (issuer dependent), and any notes—populate the Memo field
  • Any transaction attachments or receipts

How it works

In the Extend web app, navigate to the Accounting or Card Transactions from the main menu.

  • Select the transaction(s) you wish to sync to your general ledger using the checkboxes on the left side of the list. Be sure each transaction has a tagged account expense category.
  • After you’ve selected the transactions, click “Sync with QuickBooks” at the bottom of the page.

A QuickBooks logo will appear on each successfully synced transaction.

In the Extend web app, QuickBooks logo will appear on each successfully synced transaction.

Note: Transactions must have an account expense category assigned before they can be synced to QuickBooks Online.