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

Reconciliation issues due to credit card auto payment. Both checking and credit card reconciliation

We recently changed our credit card to autopay to pay the balance each month. Despite asking Chase to pay the printed statement balance, they pay the statement balance less any credits that come from returns. When I go to reconcile our checking account, the payment amount in QB is different from the bank statement due to the credit that Chase applied. 

 

If I undo the credit card reconciliation to match the bank statement, the credit card statement New Balance does not match the QB beginning balance since the credit that Chase took when making the payment is on the next month's statement, but I had to apply it to the previous month's statement to reconcile the checking account. I cannot figure out the best solution other than to stop auto payment.

 

Simple problem, yet complicated at the same time. Thank you!

3 Comments 3
GlinetteC
Moderator

Reconciliation issues due to credit card auto payment. Both checking and credit card reconciliation

I appreciate the steps you've taken, Karen B3. I'm here to help you resolve these reconciliation issues.

 

You don't need to undo the reconciliation but create a bill instead. Here's how:

 

  1. Go to the Vendors menu and select Enter Bills.
  2. Choose the vendor's name and fill out the required fields.
  3. Select the type of bill you want to record.
  4. Click Save to record the bill.

Right after, record the payment with credit. Here are the steps:

 

  1. Go to the Vendors menu, then select Pay Bills.
  2. Select the correct accounts payable account from the drop-down.
  3. Select the checkboxes of the bills you want to pay from the table.
  4. Set credit that you want to apply to the bills.
    Credit - Select this if you received a credit from your vendor, and you used it to reduce your total bill amount.
  5. Enter the date you paid the bill.
  6. Select the payment method.
  7. Select Pay Selected Bills.
  8. Select Done.

I've got you these articles that provide steps on how to fix issues when reconciling in QBDT:

 

 

I'd appreciate it if you'd update me on how it goes. I want to make sure everything is taken care of  for you.

mindyp321
Level 1

Reconciliation issues due to credit card auto payment. Both checking and credit card reconciliation

I am having the same problem.  Karen, you described the situation very well.  Because the credit cards are reconciled, the system does not seem to allow me to pay an amount different from the bill.  If I enter the credits, I cannot apply them until the bill is created for the following month.  There has to be a better solution to this problem.  Anyone??

RCV
QuickBooks Team
QuickBooks Team

Reconciliation issues due to credit card auto payment. Both checking and credit card reconciliation

Thanks for checking in with us, mindyp321.

 

After reconciling the credit card account, there are two options to pay a portion of the outstanding balance. We can write a Check to pay expenses that are to be paid immediately or enter a bill for vendor bills to be paid at a future date. In your case, we can delete the bill and enter a check to pay expenses immediately.

 

Before doing this one, create a backup company file just in case if you ever run into problems, we can use your backup to restore your data. Here's how to enter a check:

  1. Go to the Banking menu and select Write Checks.
  2. In the Bank Account field, enter the account where the money will be taken from.
  3. Enter the balance of the given bank account as of the date of writing the checks in the Ending Balance field. 
  4. For the Pay to the Order of, it should be the Payee Name or whoever the check was issued for.
  5. Enter the Date when you issue the check.
  6. For the Amount, it should be check amount in numbers. Below the Pay to the order field will automatically show the Dollar amount in words.
  7. Press Save & Close.

 

I'd still suggest consulting your accountant. They can guide you on how to handle this one to ensure your book is accurate. In case you encounter some issues upon reconciling in the future, here's an article you can refer to for more details on fixing reconciliation issues in QuickBooks Desktop

 

I'll address any other concerns you might have regarding reconciling your accounts. If you'd like to take care of your reports and transactions, lay down the details below and I'll help you out.

Need to get in touch?

Contact us