cancel
Showing results for 
Search instead for 
Did you mean: 
AlpineArtisanStudios
Level 2

How to reconcile negative credit card statement

For reconciling a credit card - we have 5 different cards on the account.  usually I reconcile then enter the bill for each one which totals to the payment to be made.  This time 4 cards have a positive and the 5th has a negative balance.   The negative balance doesn't show up when I go to pay the bill so I can't make the payment match what is on auto pay.  Example:  credit card payment balance = $30,791.28.   Four of the cards add up to this much in charges $30,850.19.   One card has a negative balance of $58.91.   The bills show up so I can select them to pay but the total is $30,850.19.  The negative $58.91 doesn't show up in the to be paid so the credit isn't applied (I want it to show up and not do a journal entry because next month we won't have a credit so I need the balance to be this negative $58.91).   Without the negative $58.91 though I can't get it to the credit card payment  - instead when I select all to be paid it is overstated by $58.91.   Clear as mud:)   I have seen others with the issue but have not seen an answer on this - any help is appreciated!

3 Comments 3
Pete_Mc
Community Champion

How to reconcile negative credit card statement

Is the negative balance due to a credit or an over payment?  And is that transaction(s) correctly shown in the CC Register within the period of the statement?

 

If everything Reconciles, then the balance of all the accounts should match the payment due.  So if it doesn't, I'd recheck the Reconciliation.

AlpineArtisanStudios
Level 2

How to reconcile negative credit card statement

The negative is due to a partial return.  The statement reconciles.   Usually I reconcile each card and then it creates a bill to be paid later.   When done with all cards I go to pay bills and select each one and that totals the bill payment for the month.  All of the positives show up just like usual but the negative doesn't show up.  QB chat wanted me to do a vendor credit but then that wouldn't go against the right credit card and next month I would be off because I added this credit when actually the credit will bee that the person's cc still has a negative balance.   I could force a credit then manually reverse it next month but that seems messy.  Any thoughts?

Giovann_G
Moderator

How to reconcile negative credit card statement

I can share a method to show a negative balance, AlpineArtisanStudios.

 

You can write a check affecting your credit card account. Ensure the correct credit card account is selected so that the negative amount is displayed when you pay your bills.

 

Here's how:

 

  1. Go to + New icon.
  2. Click Check.
  3. Choose a Payee from the dropdown.
  4. Ensure to select the correct bank account.
  5. Fill in the necessary information such as the Payment date.
  6. In the Category details, choose the credit card account under the Category column.
  7. Enter the amount as positive 58.91.
  8. Once done, hit Save and close.

 

For future reference, check out this article to learn about tracking bills and recording the payments: Enter bills and record bill payments in QuickBooks Online.

 

Let me know if you need further assistance with the reconciliation. I'll be here to help you.

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

Need to get in touch?

Contact us