All your cleared transactions from Extend virtual cards can be easily synced with your accounting service through an integration.
The org owner, admin, and bookkeeper 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 org owner, admin, or bookkeeper, you can review each transaction prior to syncing. This allows you to categorize transactions appropriately with the expense category options and select which expense account the transaction belongs to.
When you sync a transaction, the expense category will be pushed into your accounting service connection and each cleared transaction will also import 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.
Note: Currently, integrations do not support importing attachments associated with a transaction. But this functionality will be available in early 2024!
How to sync transactions
- Once the integration with your accounting service has been established, navigate to the Transactions section from the main navigation.
- You will notice the default view of transactions is by Transaction Date. Best practice is to change your view to Clear Date because the clearing/posting date is the date that will push to your connected accounting service.
- If you would like to edit any of the expense categories attached to a transaction before you sync the transactions, you can select the transaction to review the details on the Transaction flyout on the right and update any of the expense categories defined within your Org.
- 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 the Sync with {name of integration} button on the modal 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 an 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 integration logo icon indicates the transaction successfully synced.
- The failure/exclamation icon indicates the transaction failed to sync.
Congratulations, your connected accounting service should now reflect the recent synced transactions!
FAQs
What accounting integrations are offered?
Today, Extend offers Quickbooks and NetSuite integrations. More integrations will be available soon!
Are the expense categories required in order to sync transactions?
Yes, a defined expense category is required in order to push the transaction to a connected accounting service. 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 service. Each transaction must have an expense category before you can start the sync process.
Where is the merchant name passed in Netsuite?
Today, the merchant name is passed to the Memo field in Netsuite. You will have the opportunity to edit the Vendor within Netsuite and tie the transaction to the appropriate vendor defined in your Netsuite instance.
Where is the merchant name passed in Quickbooks?
Today, the merchant name is passed to the Description field in Quickbooks. You will have the opportunity to edit the Vendor within Quickbooks and tie the transaction to the appropriate vendor defined in your Quickbooks instance.
Why do all of the items in my accounting service show a supplier of Extend?
Today all transactions are tied to one generic supplier of Extend but vendor matching is coming soon!
If I add notes to a virtual card or transaction in Extend, will those notes push to my connected accounting service?
Any information added in the Notes field within Extend will also push to your connected accounting service and will display in the Memo field.
If a transaction has receipts attached, will those push to my connected accounting service?
Today, the attachment will not push into your connected accounting service, but this functionality will be available soon.
If the user is connected to a bank feed for physical card transactions (Plaid integration), will the transactions tied to the funding account also push to my connected accounting service?
Yes, if you are connected to Plaid, you can also push transactions at the RCN level into your accounting service.
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.
What happens to my transactions if I disconnect from my accounting service?
Once the transactions are sent to your connected accounting service, they cannot be sent to another account. If you would like to push transactions to a different account, you will need to download them to a .csv file and manually add them to a different account within your accounting instance.