Overview
All your cleared transactions from Extend virtual cards can be easily synced with your accounting software through an integration.
The Owner and Admin roles have permission to connect and manage an integration for the organization. If your organization is already connected to an integration, you can view it on the Integrations tab of the Organizations Settings page.
As the Owner, Admin, or Bookkeeper (who can sync transactions, but cannot manage the integration), you can review each transaction prior to syncing. This allows you to categorize transactions appropriately with the expense category options.
When you sync a transaction, the transaction data will map to the expense categories in your accounting software. Additionally, each cleared transaction will import receipt attachments and virtual card metadata, including virtual card name, last 4 digits of the virtual card, RCN name, last 4 digits of the RCN, transaction reference ID, and any notes added to virtual cards and transactions in Extend.
How to sync transactions to QuickBooks
- Once the integration with your accounting software has been established, navigate to the Card Transactions from the main navigation.
- You will notice the default view of transactions is by Transaction Date. Use the filters to broaden or narrow your resulting transactions
- Select one or more transactions that you would like to sync using the checkbox to the left of each transaction. You can also “bulk select” transactions by selecting the box at the top of the column, next to Date. A modal will appear at the bottom of the page once a transaction has been checked. The modal states how many transactions have been selected.
- Click Sync to QuickBooks to start the transaction sync.
Notes:
- You may only sync transactions that have cleared and that have not already been synced.
- If one or more of your selected transactions does not have a required expense account defined, you will receive an error message directing you to add an expense account before attempting the sync again.
As your transactions are syncing, you can monitor the status from the column on the far right of the Transactions list.
- The hourglass icon indicates the transaction sync is in progress.
- The QuickBooks logo icon indicates the transaction successfully synced.
- The failure/exclamation icon indicates the transaction failed to sync.
Congratulations, your connected accounting software should now reflect the recent synced transactions!
FAQs
-
What accounting integrations are offered?
Extend offers Quickbooks and NetSuite integrations. More integrations will be available soon! -
Are the expense categories required in order to sync transactions?
Yes, a an Account expense category is required in order to push the transaction to a connected accounting software. If this information is missing at a transaction level, the transaction list screen will indicate the item is missing. -
Will I be able to edit all expense categories at the transaction level?
You will have an opportunity to add or edit the expense categories at the transaction level prior to pushing the transaction data to your connected accounting software. Each transaction must have an expense category before you can start the sync process. -
If I add notes to a virtual card or transaction in Extend, will those notes push to my connected accounting software?
Any information added in the Notes field within Extend will also push to your connected accounting software and will display in the Memo field. -
If a transaction has receipts attached, will those push to my connected accounting software?
Yes, you can push attachments to your accounting software when you push your transactions or individually. To learn more please see, Sync transaction attachments to your accounting software. -
If the user is connected to a bank feed for physical card transactions, will the transactions tied to the funding account also push to my connected accounting software?
Yes, if you are connected to to a physical card bank feed, you can also push physical card transactions into your accounting software. -
How does Extend push transactions where the date is in a closed period?
If you attempt to push a transaction with a clearing date tied to a closed period, Extend will push the transaction to the latest open period, without altering the date.