Why am I Seeing Duplicate Payment Information?

Commerce Sync transfers the payments and the sales information (double-entry accounting) from your Point of Sale system.

If you are using the accounting solution's Online Banking or automatic deposit feature you will see your bank deposits as well as the Commerce Sync payments.

Some merchants confuse this, thinking that these are duplicate entries. These numbers will be similar, they are complementary to each other. The bank transfers what was deposited into your bank, Commerce Sync transfers what was tendered as payments in your POS. You will reconcile or "match" these numbers in your accounting solution so they are only counted once and not twice.

  • Within QuickBooks Online there is a Banking Transactions screen that will show a list of the transactions downloaded from the bank. Next to each transaction there will be a button that says "add" or "match" - clicking on "match" will bring up any payments that are not already matched to a banking transaction. The payments associated with your invoices created by Commerce Sync will be included in that list.
  • If you have a bank rule in place with your feed, this will prevent you from matching the deposit from the feed with the payment from Commerce Sync because QuickBooks will use the rule to auto-categorize it and you can not match with already categorized deposits. You will need to undo the categorization in order to have the match feature apply to the information in the For Review section. 

Intuit / QuickBooks Online has a tutorial on this topic: How to match your bank deposits with payments
Intuit / QuickBooks Desktop has a tutorial on this topic: Add and match Bank Feed transactions in QuickBooks Desktop
For Xero users, you can view their help site: Find transactions to match to bank statement lines

Updated 8/4/2021

Was this article helpful?
2 out of 5 found this helpful