Skip to main content
April 16, 2022
Question

Credit card payment transactions are increasing the balance. How do I fix this issue?

  • April 16, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

April 16, 2022

Hi @goldenkrustgarne. Help has arrived.

 

To verify, are these transactions imported into QuickBooks? If so, we can correct the formatting of the credit card accounts or entries by following these rules:

 

  • CSV files for credit card accounts may display transactions in reverse. For example, deposits/income may appear as negative amounts because paying your credit card reduces your balance.
  • To ensure these transactions are imported correctly, select the corresponding credit card account (not a bank account) when you upload the file into QuickBooks Online (QBO).

 

However, if your transactions are downloaded from your credit card account that is connected to QBO, ensure that the account type is Credit Card. Increasing balance may be seen as an error when a credit card account is added as a bank account in your chart of accounts.

 

If this is the case, you can edit the account type to change it to Credit Card, here's how:

 

  1. Go to the Gear icon and then select Chart of accounts.
  2. Find the account in question.
  3. Click the triangle button beside View register.
  4. Select Edit.
  5. From the Account Type drop-down, choose Credit Card.
  6. Click Save.
  7. Hit Yes to bypass the changes.

 

That's it. I'm adding these articles for the detailed steps on how to connect credit card accounts and how to tune imported credit card transactions:

 

 

Once the credit card transactions are in the correct balance, you can then categorize and match them with existing records in QBO.

 

Let me know if you have other concerns about handling your credit card transactions in QuickBooks. I'm always ready to help you more. Stay safe and well!

April 17, 2022

Hi, thanks for your quick reply. The CC account which is downloaded from bank was setup as CC in thee Charts of Account. I compared the setting to the article and another company I have which was setup in 2020.

 

What else can I check to see why the data is not treated correctly in QBO?

April 17, 2022

Thank you for getting back to us and providing additional information, @goldenkrustgarne.

 

Let's review your credit card payments to ensure it's treated correctly.

 

Before we start, please know that credit card payment is a liability, and it does reduce your liability balance in the Balance Sheet report. 

 

Since your credit card account is connected to QuickBooks, you'll need to ensure you categorize the credit card transactions to the correct account. If you aren't sure what account to use, I encourage seeking help from your accountant for more guidance. This way, your credit card payment will be posted correctly.

 

Also, may I know which part or report did you see the increase in credit card payments? Any additional information would be greatly appreciated.

 

I'm adding this article to learn more about recording credit card payments: Record your payments to credit cards.

 

Our doors are always open to help you again if you have any other concerns or follow-up questions about how credit card payments are reported. Have a pleasant day ahead, @goldenkrustgarne.