Credit Cards from US Bank duplicate transactions

joecool99 · ‎September 02, 2021

We use US Bank for all our banking, including our company credit cards.

The way US Bank sends the credit information over to Quickbooks, there is a Central Credit account, which has every single transaction from all the credit cards, and each individual's credit card, I'll just say Joe's Card and Bob's Card for example, that has all those same transactions again, but divided by which card it was made with.

The issue is, if I buy something with Joe's or Bob's card, it shows up in Quickbooks under Joe's or Bob's Card as well as Central Credit. Same date, amount, everything. But unfortunately, we aren't able to match the identical transactions. So that makes it look like we have double the amount of credit card expenses, since every single transaction is imported to Quickbooks twice.

So we end up having to void all the transactions on the individual cards, then only adding the transactions from the Central Credit account. It's pretty annoying, and so far we haven't found any way around it. There's no way to make Quickbooks disregard some of the credit accounts, because removing one removes all of them.

I was wondering if any US Bank users had found a workaround for this. Thank you!

JoesemM · ‎September 02, 2021

Thank you for sharing detailed information about your concern, @joecool99.

You'll want to ensure that only one credit card sub-account is connected to your bank to prevent duplicates. QuickBooks Online (QBO) will only depend on the transactions shared by your bank, and you need to know how your bank sends the downloaded transactions.

If Joe's or Bob's credit card accounts are set up as a sub-account that links to the bank. You can unlink one of those accounts to avoid duplicate transactions. Before doing so, make sure to categorize first the transactions needed.

To unlink the sub-account, here's how:

Go to the Accounting menu and select Chart of Accounts.
Find the account and select the small arrow ▼ in the Action column. Then select Edit.
Unmark the box beside the Is sub-account.
Select Save and Close.

For the duplicate transactions, you can Exclude them, and they will not appear in any account registers or financial reports.

Go to the Banking menu or Transactions menu, then select the Banking tab.
Choose the For Review tab.
Select the checkbox of the transactions to exclude.
Click Exclude.

The transaction moves to the Excluded tab of the Banking page. From there, you can click the Delete button to permanently remove the transactions. See this article for detailed steps: Exclude a bank transaction you downloaded into QuickBooks Online.

You might also want to check out these articles to know more about how to reconcile and match credit card transactions:

Get back here at any time if you need additional assistance in doing any of the steps above or other concerns. I'd be delighted to help you more.

Topics

Training

Community

Resources

Credit Cards from US Bank duplicate transactions

Credit Cards from US Bank duplicate transactions

Need to get in touch?