Avoiding Duplicate Card Transactions & Expenses Between Adaptive and QuickBooks
Learn the most common causes of duplicate expense entries and how to prevent them. Duplicates occur when the same transaction is created in two places, typically once in Adaptive and once QuickBooks. This article covers the three most common scenarios that cause duplicates, how to prevent each one, and the steps to resolve duplicates that have already been synced.
1. Why Duplicates Happen
Duplicates typically occur when the same expense gets entered in both Adaptive and Quickbooks. The most frequent cause is pushing a receipt to QuickBooks before the card transaction has posted and linked in Adaptive.
Card transactions can take several days to post, and syncing a receipt without a linked transaction is one of the most common ways duplicates are created.
2. Expense Synced Before Card Transaction Posts
When a receipt is uploaded to Adaptive, approved and synced to QuickBooks before the matching card transaction appears in Adaptive's card feed, the card transaction will still get create an expense in Adaptive upon posting.
When this happens it'll reappear in your unmatched Card Transactions, and often a new expense will get created from this unmatched transaction, and that additional copy will then be synced to Quickbooks.
What happens: Adaptive auto-creates a draft expense when a card transaction comes in. If the receipt was already synced, there are now two expense records in QuickBooks for the same purchase. If this additional expense is then completed and approved, it will also be synced to Quickbooks.
How to prevent it:
Before syncing an expense to QuickBooks, ensure it is matched to a card transaction when possible.
If a warning banner appears indicating that a receipt has no linked card transaction, pause before syncing — especially if the payment account is tied to a linked card. Wait for the transaction to post and match it first.
3. Receipt and Bill Created for the Same Invoice
When a vendor invoice is paid by credit card and the receipt is also uploaded separately, or an invoice is imported from QuickBooks and also uploaded as a bill, two entries are created for the same cost.
Common example: An invoice comes in from email and is auto-created as a bill, but the same document was also scanned as a receipt.
How to prevent it:
Check the Inbox before uploading. If a bill already exists for the same vendor, amount, and date, do not create a new receipt.
Use the "Has Duplicates" filter on the Expenses page to identify items flagged as potential duplicates.
Confirm whether an invoice should live as a bill (vendor invoice for later payment) or a receipt (already paid by card).
4. Mismatched Payment Accounts
If you have your Bank Feed linked to the same card account in Quickbooks make sure that the Payment Account matches in both systems. If payment accounts between Quickbooks and Adaptive do not match for the same transactions they will not be matchable once synced to Quickbooks. This may lead to duplicate expenses being created.
How to prevent it:
When uploading a receipt, double-check that the payment account selected matches the card the purchase was made on.
To confirm which payment account a card is linked to, go to Settings → Cards.
Ensure Payment Account set on Quickbooks Bank Feed and Adaptive Linked Cards match.
If you have the same card account linked in Quickbooks Bank Feed and Adaptive Linked Cards, make sure that all expenses are matched to a card transaction before approval. DO NOT create expenses from Bank Feed in Quickbooks, this will lead to duplicates.
5. Best Practices to Avoid Duplicates
Always wait for the card transaction to post before syncing a receipt to QuickBooks — card transactions typically take 1–6 business days to appear.
Match receipts to card transactions before approving. A matched receipt is much less likely to produce a duplicate.
Do not create both a bill and a receipt for the same purchase. If a vendor invoice was paid by card, match the card transaction to the bill and do not create an expense.
Review the Unmatched Expenses list regularly. Use the Expenses page filters to find unmatched items before your monthly close.
Use the "Has Duplicates" filter on the Expenses page to surface flagged items and resolve them before syncing.
Avoid making edits in both Adaptive and QuickBooks at the same time. Simultaneous changes in both systems can conflict and create mismatched records.
Use Adaptive card transactions as the 'Source of Truth'. Creating expense in Adaptive and Quickbooks will cause duplicates.
6. How to Check for Duplicates in Adaptive
Navigate to Expenses in Adaptive.
Apply the "Has Duplicates" filter to see flagged records.
Review each flagged item — check if there is a matching bill, receipt, or card transaction for the same amount, vendor, and date.
Merge or archive the duplicate as appropriate. If you are unsure which to keep, keep the one that is already synced to QuickBooks.
Note
Archived bills and expenses are not considered duplicates. If a duplicate is already archived, the active record is safe to proceed with.
7. What to Do If a Duplicate Already Exists in QuickBooks
Identify which record in Adaptive is the correct one — typically the one linked to the card transaction.
Archive or delete the duplicate in Adaptive. When an expense with a QuickBooks ID is deleted in Adaptive, Adaptive will automatically send a deletion to QuickBooks as well.
Verify in QuickBooks that the duplicate has been removed after the next sync.
If the duplicate persists in QuickBooks, manually delete it there and ensure the correct record is still linked to Adaptive.
Still Need Help?
Please reach out to our support team at [email protected] for further assistance.