cancel
Showing results for 
Search instead for 
Did you mean: 
awrig19
Level 1

How do I link 1 Bank payment to 2 Credit Card payments

I frequently make payments of over $100,000 from my bank account to my credit card. However, my credit card and bank record the charges differently:

Bank: $110,000.00
Credit Card: $99,999.99 + $10,000.01

 

I can't split the bank transaction into two credit card charges, and I can't add them to an AP clearing account to cancel out. How do I get these to match up?

7 Comments 7
ShiellaGraceA
QuickBooks Team

How do I link 1 Bank payment to 2 Credit Card payments

Hi @awrig19,

 

You'll want to create two credit card credits so you can match it with your bank payment. Let me walk you through how.

 

  1. Go to +New, then Credit card credit.
  2. Select your credit card account from the Bank/Credit account drop-down.
  3. Under Category details, choose your bank account. Then, enter the credit card charge.
  4. Repeat steps 1-3 for the second charge. Make sure these transactions will equal to your bank payment.
  5. Click Save and close.

Once done, match these transactions in the banking section with your downloaded bank transaction. You can learn about matching your downloaded transactions at this link here: Categorise and match online bank transactions in QuickBooks Online.

 

We also have a guide on reconciling an account that I'm sure you'll find helpful. It has steps and information to keep your accounts balanced and accurate.

 

Please know that we're always here to lend a hand if you have other questions or concerns. Don't hesitate to reach out. Thanks for dropping by and have a great weekend ahead.

awrig19
Level 1

How do I link 1 Bank payment to 2 Credit Card payments

Hi Shiella,


I don't want to create two credit card credits. I have my credit card and bank accounts both linked to Quickbooks and I want to match the transactions. Why do I need to create new credit card charges if they are already there and just need to be matched?

 

Thank you!

CharleneMaeF
QuickBooks Team

How do I link 1 Bank payment to 2 Credit Card payments

Allow me to jump in on this thread, @awrig19.

 

We're unable to match the transactions on the Banking page. You'll have to mark as cleared and exclude them manually.

 

Here's how to clear the transactions:

  1. From the Accounting menu, select Chart of Accounts.
  2. Find the account.
  3. Click View register.
  4. Double click on the Check (✓ ) column to change the status to Cleared (C).
  5. Select Save.

 

Once done, you'll have to exclude the payments. You may follow these steps:

  1. Go to the Banking menu and then select the Banking tab.
  2. From the For Review tab, place a checkmark on the transactions.
  3. Click Exclude.

 

Also, here's a quick guide on how to review and categorize your downloaded transactions in QuickBooks.

 

Once you reconcile your accounts, you may want to consider printing or exporting your reconciliation report. This helps have a handy copy of your data.

 

Stay in touch with us if you have other banking concerns, awrig19. We're always here to help.

af67
Level 1

How do I link 1 Bank payment to 2 Credit Card payments

I pay 4 credit card accounts from the checking account.  I write one check for all four payments.  When I receive the credit card statement I transfer the payment over to the checking account, however when I receive the checking account statement I reconcile the cleared check for the payment of the four credit cards.  I do I remove the transfers from the register since I have already reconciled the 1 check?  When I delete it from the checking account bank register it throws it back into the credit card account for review. Thanks.  Amanda

 

Angelyn_T
Moderator

How do I link 1 Bank payment to 2 Credit Card payments

Thank you for joining the thread, Amanda.

 

Since you've reconciled the check for the credit card payment, you can exclude the transfer transaction from your record. I'll guide you how.

 

  1. Delete the transaction from your checking account bank register (if you haven't yet).
  2. Remove the amount from your credit card account.
    1. Click on Banking at the left pane, then go to the Banking page.
    2. Choose your account, then go to the For Review tab.
    3. Select the transaction, then click on Exclude.

 

For more hints about reviewing your transactions from the Banking page, you can open this link: Categorize and match online bank transactions in QuickBooks Online.

 

Moreover, you can open the topics from our help articles for additional resources about banking and reconciliation: Find help with bank feeds and reconciling accounts.

 

If you have any other questions about your credit card payment and other bank transactions, let me know by adding a comment below. I'm always here to help. Have a good one!

af67
Level 1

How do I link 1 Bank payment to 2 Credit Card payments

If I exclude the payment for the credit card account then I can't reconcile the credit card statement.  There is an error that my beginning balance is off.  

Jovychris_A
Moderator

How do I link 1 Bank payment to 2 Credit Card payments

Hello @af67.

 

If you made payments for 4 credit card accounts using your checking account, you're right to record it in QuickBooks by creating a check. After you receive the credit card statement, you transfer them over to a correct checking account.

 

Each credit card transaction should have a bill to match it with the check transaction.

 

By doing this can help remove the off beginning balance.

 

For more details, you can reference this article on ways and methods to record payments you make to your credit cards: Record your payments to credit cards.

 

Please let me know if you have additional questions about recording and reconciling credit card transactions. I'll make sure to help. Take care!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us