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

Credit Card Reconciliation

Hello.  

 

Thanks in advance for any help provided.  I have very limited accounting skills so if possible please provide detailed instructions.  

 

The year end is Dec 31.  The credit card account period ending Dec 28, 2019 was reconciled.  The 2019 year end accounting was completed. 

 

There were a few credit card charges on Dec 29, 30, 31 that are to be reconciled for the period ending Jan 28, 2020. (see attached reconciliation detail marked in red) 

 

The opening account balance for the period ending Jan 28, 2020 matches the closing balance for period ending Dec 28, 2019.  However, the 4 charges (see attached reconciliation detail marked in red)  are not listed as charges when reconciling the period ending Jan 28.  

 

I'm not sure why, but the transactions show as cleared/reconciled in the register (see attached screen shot).  I can't unclear them as this will change the Jan 28, 2020 opening balance. I also don't want to muck up the complete 2019 year end.  

 

What can I do to add these missing charges to the period ending Jan 28, 2020 without changing the opening/closing balance so that I can reconcile?

 

Thanks again for any help.

 

 

 

Credit Card Register.jpgReconciliation Period Ending Dec 28, 2019.jpg    

 

4 Comments 4
CharleneMaeF
QuickBooks Team

Credit Card Reconciliation

I'm here to help you get you back in working order, INTRAD.

 

Thanks for sharing the detailed process you've done during the reconciliation. 

 

Let's perform a special reconciliation to resolve the issue. I'll guide you how:

 

  1. Go to the Banking menu and then select Reconcile.
  2. Choose the credit card account with the transactions you need to reconcile.
  3. In the Date of Statement field, enter the date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
  4. From the Ending Balance field, enter the balance of your last successful reconciliation. 
  5. Select Continue.
  6. On the Reconcile window, check off the transactions you are fixing and re-reconciling.
  7. Make sure the Difference field shows $0.00.
  8. When everything looks good, select Reconcile Now.

 

Once done, QuickBooks will ask if you want to create a Payment Check or Create a Bill to Pay Later.

  1. Select Create a Bill to Pay later.
  2. If you need to, print your Reconciliation Report for your records.
  3. After you print the report, a bill appears on the screen. The bill amount will be the balance you just reconciled.
  4. Select Clear. This removes all info from the bill.
  5. Close the bill.

This balances the account. QuickBooks won't create a bill so your credit card balance isn't affected.

 

I'd recommend consulting an accountant to guide you with the process.

 

I've also included these articles that'll help you resolve common errors when reconciling an account:

 

Additionally, to keep your downloaded bank feed transactions in QuickBooks are accurate, please ensure to add and match them.

 

I'll be around if there's anything that I can help with your reconciliation. Please add the details in the comment section.

CharleneMaeF
QuickBooks Team

Credit Card Reconciliation

Hi INTRAD,

 

Hope you’re doing great. I wanted to see how everything about fixing your credit card reconciliation. Was it successful? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.

 

Looking forward to your reply. Have a pleasant day ahead!

INTRAD
Level 1

Credit Card Reconciliation

Hi CharleneMae

 

Thanks for your response.  I'm still having difficulty. I've included your solution below and added my comment in red.  

 

  1. Go to the Banking menu and then select Reconcile.
  2. Choose the credit card account with the transactions you need to reconcile.
  3. In the Date of Statement field, enter the date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
  4. From the Ending Balance field, enter the balance of your last successful reconciliation. 
  5. Select Continue.
  6. On the Reconcile window, check off the transactions you are fixing and re-reconciling.  Even though the transactions in question show as New Transactions in the Reconciliation Report ending Dec 28, 2019 (refer to reconciliation report image previous posted) they do not appear  as uncleared in the register.   (refer to acct register image previously posted)   Therefore these charges do not show up when reconciling any period after the Dec 28, 2019.  
  7. Make sure the Difference field shows $0.00.
  8. When everything looks good, select Reconcile Now.
Candice C
QuickBooks Team

Credit Card Reconciliation

Good morning, @INTRAD

 

Thanks for reaching back out to the Community. I appreciate the added information that you provided us. 

 

Since you're still having issues with the reconcile, I suggest contacting our Customer Support Team. They'll be able to use a screen share to help walk you through some additional steps to resolve this problem. Here's how: 

 

  1. Go to the Help menu. 
  2. Click the QuickBooks Desktop Help option. 
  3. Press the Contact Us hyperlink. 
  4. Give a brief description of the problem and hit Let's talk
  5. Scroll down and choose to Get a callback

 

That's all there is to it! 

 

Let me know how it goes. It's my priority that you're able to get back on track. Should you need any further assistance, feel free to ask. Have a nice day! 

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

Need to get in touch?

Contact us