SALE EXTENDED 70% OFF QuickBooks for 3 months*   Ends 12/8

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
klassykreationsc
Level 2

Credit Card register Not Reconciling

 

Hello,

I'm trying to reconcile the transactions in my credit card register. I have reviewed the ending balance for each month within the register and it matches the credit card statement, however when I click on the reconcile button, the balance is not reconciling. I have checked the edit window to ensure beginning and ending balances are correct. Any suggestions on how to resolve this? Thank you in advance for your assistance.

4 Comments 4
CamelleT
Moderator

Credit Card register Not Reconciling

I appreciate the detailed information, Klassykreationsc. Let me assist you in resolving the discrepancy and completing this reconciliation.

 

To start, since you've confirmed that the beginning and ending balances are accurate but are facing issues during the reconciliation process, I recommend carefully reviewing your credit card register and comparing it against your credit card statement to identify missing or duplicate transactions.

 

Then, if you find duplicate transactions in your credit card register, you can delete duplicates that were manually added. Here's how:

 

  1. Go to the Gear icon and select Chart of accounts.
    CamelleT_0-1739673175183.png 
     

     


  2. Find the credit card account and click the View register button.
    CamelleT_1-1739673175072.png

     


  3. Locate the transaction and hit the Delete button.
  4. Select Yes to confirm.

 
Furthermore, for downloaded transactions, you have the option to exclude duplicates. If you notice any missing transactions, you can easily enter them manually to ensure your records remain complete and accurate.

 

However, if the transactions from your credit card register and statement match, I recommend performing basic troubleshooting steps to rule out the possibility of a browser-related problem. 

 

Start by logging in to your QuickBooks Online (QBO) account using a private or incognito window. You can utilize the keyboard shortcuts below:

 

  • Google Chrome: Ctrl + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P
  • Microsoft Edge: Ctrl + Shift + N
  • Safari: Command + Shift + N

 

After doing so, attempt to reconcile again. If this resolves the problem, return to your default browser and clear its cache so the system can restart and start with a clean slate. Alternatively, you may use other supported browsers.

 

Finally, I'll provide a resource to help you verify which transactions were cleared and which remained uncleared after the reconciliation: View, print, or export a reconciliation report.

 

If you have other questions about reconciling credit cards in QuickBooks Online (QBO), feel free to comment below. We're always eager to help you.

klassykreationsc
Level 2

Credit Card register Not Reconciling

Good morning,

 

Thank you so much for responding. So I followed your instructions and I deleted the duplicate transaction but it is now showing a difference of $300 for the record deleted (see attachment screenshot). How do I resolve it?

klassykreationsc
Level 2

Credit Card register Not Reconciling

QB_Error.JPG

KiazzymaeC
QuickBooks Team

Credit Card register Not Reconciling

Thank you for getting back to us, @klassykreationsc.

 

You deleted the reconciled transaction instead of the duplicate one, which is why there's a difference in your reconciliation. We can correct this by manually changing the status of the remaining account from categorized (C) to reconciled (R). This will remove the discrepancy on your report and correct your reconciliation.

 

To do so, here's how:

 

  1. Go to the Transaction menu.
  2. Select the Chart of Accounts.
  3. Choose the account of the duplicate transaction, then click View Register under the Action column.
  4. Click the duplicate transaction and change the status to R in the Check icon.
  5. Once done, hit Save.

 

After that, you can check if the discrepancy is gone so you can now proceed in reconciling.

 

Additionally, you can use the audit log if you'd like to view the details of the deleted transactions.

 

Moreover, you may want to view, print, or export a reconciliation report to verify which transactions were cleared and which remained uncleared after the reconciliation process.

 

To further improve your financial management and maintain precise, up-to-date records, consider using QuickBooks Live Bookkeeping. This service can significantly reduce the stress of managing finances on your own. The experts from QuickBooks Live will help you categorize transactions, reconcile accounts, and generate accurate financial reports, allowing you to dedicate more time to expanding your business. 

 

If you still have trouble reconciling your credit card register, you can always get back to us by commenting down below. I'll reply to you as quickly as possible.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us