Skip to main content
November 5, 2024
Solved

problem reconciling credit card account

  • November 5, 2024
  • 2 replies
  • 0 views

Hi All,

I am having a problem with reconciling my credit card account, when the money comes into the bank from the credit card account I create a bank deposit.

In the account field, I put my bank account

In the "Add funds to this account",  in the account field I put the credit card account and after filling in all relevant information I click save and when reconciling my bank all is good. However, when I try to reconcile my credit card the entries are showing as payments and not Deposits, how do I correct this?

Best Regards,

Noel

Best answer by Rainflurry

Thank you yet again for your quick reply and apologies for wrecking your head, my understanding is that in the bank deposit screen the first entry I put in is under the heading, "Account", I am assuming this means the account that the moment has come from which is the CC. Then on the "Add funds to this account", the "account " signifies where the money is going too which is the bank. I will have to watch some videos for clarification on this whole procedure

Best Regards,

Noel


@TUSSU 

 

There's the issue.  The 'Account" in the heading is where the deposit is going to and you can only choose a bank account so I'm not sure why you see a cc there.  The other account is the reason for the deposit.  Choose income if the deposit is income to you.    

2 replies

November 5, 2024

I appreciate you for sharing this with us, Noel. I'll be helping you in locating the deposits in your QuickBooks Online (QBO) account.

 

To start, we need to understand the credit card reconciliation process.

 

Credit card reconciliation typically involves reviewing charges (payments) made on the credit card. Deposits are not usually expected unless you're receiving credits or adjustments.

 

You can navigate it from the Chart of Accounts (COA). Here's how:

 

  1. Go to Gear icon ⚙️
  2. Hit the Chart of accounts, and review the transactions you made.

     
     

 

Verify that all entries related to the credit card are recorded as expenses or purchases, not as deposits. If a deposit is incorrectly entered, it would not typically reflect in credit card reconciliation.

 

It is essential to review all the transactions to ensure that all the records are aligned. These are the ways to view all of the records:
 

  1. Review Credit Card Statements:
    • Compare your QuickBooks transactions with your credit card statement to ensure all entries are captured accurately.
  2. Re-run the Reconciliation:
    • Go to the "Accounting" menu and select "Reconcile."
    • Choose the appropriate credit card account you wish to reconcile.
    • Verify that the transactions are now showing correctly.
  3. Check for Duplicate Transactions:
    • Ensure there are no duplicate entries that might be inflating either the payments or the balance recorded.

 

Lastly, On your bank deposit page, below the "Add funds to this deposit." The account indicated should be "Credit Card."

 

 

Following these steps, you should be able to identify why deposits are not showing and rectify any misclassified transactions in your QuickBooks system.

 

You can read this article to guide you in resolving reconciliation issues: Fix issues at the end of a reconciliation in QuickBooks Online.

 

I'll be adding these articles for future reference if you start reconciling again:
 

 

If there is anything else I can help you with. Aside from reconciliation, please let me know by leaving a comment below. I'd be more than willing to lend you a hand, Noel.

 

TUSSUAuthor
November 5, 2024

Hi,

thank you for your quick response, we do not purchase with our credit card so there is no expenses, this is money that customers have tapped our credit card machine to make a purchase from us.

My bank reconciliation is correct. But, when I try to reconcile my credit card account the items are showing as "Payment", but, no payments were made by us

Best Regards,

Noel 

Rainflurry
November 5, 2024

@TUSSU 

 

I think we were typing responses at the same time.  

 

"we do not purchase with our credit card so there is no expenses, this is money that customers have tapped our credit card machine to make a purchase from us."

 

This transaction has nothing to do with your credit card.  Your credit card is only used when you make purchases with it.  Are you not using a sales receipt?  That is the proper way to record cc transactions when customers purchase from you in person.  If you're not using a sales receipt, assign the deposit to the appropriate income account.    

Rainflurry
November 5, 2024

@TUSSU 

 

"when the money comes into the bank from the credit card account"

 

Is this a cash advance?  I'm confused as to why you're creating a bank deposit from your credit card.  That would be depositing cash to your bank account and creating a charge to your credit card.  

 

"However, when I try to reconcile my credit card the entries are showing as payments and not Deposits, how do I correct this?"

 

If you assign your cc account to a bank deposit in QB as you described, the deposit will show as a "Deposit" when you reconcile your bank account and as a "Charge" when you reconcile your cc account.  There's no "Deposit" column when you reconcile a cc.  You can only create a charge or make a payment.  A bank deposit will not create a cc payment as you described.  Can you post a screenshot of the bank deposit and the cc account reconciliation?