Skip to main content
September 23, 2024
Question

Pairing credit cards payment to the related transaction on bank account

  • September 23, 2024
  • 1 reply
  • 0 views

Hello,

 

I am having troubles pairing certain credit cards payments to the related transaction on bank account. I usually use the "Record as credit card payment" option and the system automatically pairs the 2 transactions 1) one on the bank account side and the other 2) on the credit card side. However I am having issues with 3 transaction because the system sees them only on the credit card side, but there's nothing showing up on the bank side. However in the actual bank statements I see the transactions to pay off the credit card. It is something that happened only on those 3 transactions. Can somebody help please?

1 reply

September 23, 2024

Hi there, great_acc0unt1ng. Pairing certain credit card payments to the related transactions on your bank account is indeed challenging, especially if the system does not automatically match these specific transactions on both the bank account and credit card sides, as expected.

 

Here are some reasons why QuickBooks can't find their match from the existing record automatically:
 

  • The amounts or dates don’t match.
  • The transaction is older than 6 months.
  • The bank account on the payment isn't the same as the bank where the match is located.
  • The payment has been reconciled.
  • The record is already matched to another transaction.
  • The system will look for transaction(s) that fall within a 10% range of the bank transaction dollar amount when trying to match foreign currencies.
  • There are multiple currencies involved, and the exchange rate has shifted significantly, making the amounts very different.

 

To address this, you can manually match the transactions on the bank account side to correspond with the credit card payments. By cross-referencing the dates and amounts of the transactions on both ends, we can ensure that they align correctly. Here's how:
 

  1. Go to Transactions menu, then Bank transactions 
  2. Find a downloaded record. If you're in Business view: look for “matches found” in the Assign to column. Otherwise, if you're in Accountant view: look for “matches found” in the Category or match column.
  3. Choose the downloaded record to expand the view. Note the date, Description (or Bank detail), and amount spent or received.
  4. Check the Suggested matches for any possible matching transactions already entered in QuickBooks.
  5. Click the link next to each match to get more details. Suggested matches will be the same amount as and from a similar date range as the downloaded transaction. Make sure that the match is correct. If the suggested matches are not correct, select Find other matches to look for other transactions.
  6. Select a match if it's correct, then hit Match to match it.

 

You can check out this article for other ways to match transactions: Match online bank transactions in QuickBooks Online.

 

In case you need a complete guide on reconciling your accounts, I've also included this link for future reference: Learn the reconcile workflow in QuickBooks.

 

Let me know in the comment section if you still need further help or have other banking concerns. I'd be glad to help.