How to Reconcile in QuickBooks or Navigating Account Reconciliations in QuickBooks

However, to ensure that your accounts are accurate and to prevent tampering with the data, I strongly advise getting help from your accountant. They’ll be able to offer more knowledgeable solutions for handling this circumstance. Use our Find an Accountant tool to find a Pro-Advisor in your neighborhood if you’re not already connected to one.

  • After entering all information, click the Continue button at the bottom of the screen.
  • They’ll be able to provide more expert ways of dealing with this situation.
  • If you need to edit or get more details on a transaction, select it for further action.
  • Transactions added or matched from online banking are usually pre-selected for convenience.

Once they are matched and categorized, they will appear in your bank register. After adjusting the balances according to both the bank and the books, the adjusted amounts should then be similar. However; if for some reason, they’re still not equal, you will have to repeat the entire bank reconciliation process until both are accurate. That’s why the business needs to identify the reason for the discrepancy and reconcile the differences.


This level of convenience will allow you to match and categorize a large number of transactions at a mere click of a button. Not only is it convenient but it will also make the entire bank reconciliation process controllable and more efficient. The basic way to reconcile your credit card in QuickBooks is to enter the ending statement balance to match your transactions to the transactions on the statement in your account. If you would like to streamline your reconciliation process in QuickBooks, Synder is the answer. Be careful not to reconcile transactions that are not yet cleared or present on your bank statement.

  • It is possible that the negative balance is caused by an incorrect opening balance or a discrepancy in your record transactions and reconciliation.
  • If changes are made, having a backup copy makes it possible to reverse the changes.
  • In cases where an opening balance wasn’t entered previously, QuickBooks Online provides the option to add it retrospectively.
  • If you forgot to enter an opening balance in QuickBooks in the past, don’t worry.
  • In the reconcile window, select the credit card account you wish to reconcile and enter the ending date and ending balance shown on your credit card statement.

The process works well by matching the payment in Quickbooks. My problem is when the funds are deposited in to our bank account (Wells Fargo) there is no way to identify the customer or the invoice number. To correct transactions that have already been reconciled, locate the transaction in question and remove the reconciliation marker, such as a checkmark, to un-reconcile it.

Why is credit card reconciliation important?

However, I’d still recommend consulting an accounting professional on other ways to fix this. They can share expert advice on how to deal with this situation to make sure everything is accurate. After you reconcile, you can select Display to view the Reconciliation report or Print to print it. If your beginning balance doesn’t match your statement, don’t worry. Before you start with reconciliation, make sure to back up your company file. When you’re finished setting up your payment or have decided to wait until later, hit the green Done button (not shown in the image above).

How to reconcile accounts in QuickBooks Online

Sign up for Synder today or book a seat at a Weekly Public Demo to experience firsthand how Synder automates bookkeeping and accounting tasks for online transactions. Once the matching is complete, and the difference between your bank statement and QuickBooks Desktop shows $0.00, proceed to finalize the reconciliation by selecting Reconcile now. After completing the reconciliation, you have the option to display or print the Reconciliation report for record-keeping. In your first reconciliation, ensure that the opening balance in QuickBooks Desktop is in sync with the balance of your real-life bank account as of your chosen start date. Proceed to enter the ending balance and date from your statement.

Purpose of Bank Reconciliation

A bank reconciliation is a piece of document that shows a direct comparison between a company’s cash balance sheet and the corresponding amount that reflects on its bank statement. The information you get in this document will let you reconcile your accounts and make sure they are accurate and balanced. By reconciling both accounts, you can identify any issues that would prompt you to change the difference between financial and managerial accounting your accounting. Knowing how to reconcile credit cards in QuickBooks is a crucial step for good bookkeeping. Through reconciling the credit cards, users can ensure that the activity of their credit card matches the activity of its statements in their QuickBooks account. Today we are going to show you how to make that reconciliation process become easier with step-by-step instructions.

Step 1: Setting up for reconciliation in QuickBooks Desktop

In this example, the master card account administrator is Maya. Each person’s card purchases flow through to the individual card account. Payments on the card, however, only flow through to Maya’s card. You will see a negative balance begin to develop on Maya’s card since that card is getting credit for all the payments. You can either edit the payment to spread it to the various accounts, or do a journal entry to reallocate the individual card balances.

Before starting the process, make sure to create a backup copy of your company file. If changes occur, having a backup copy allows you to restore it to undo the changes. Do this until all of the subaccounts have been unreconciled. If nothing comes up still, we can run the Verify and Rebuild Data tool. A negative balance in the Accounts Payable indicates that there is an outstanding bill.

Choose the account you’ve reconciled and select the type of report you need, whether it’s detailed, summary, or both. For non-connected accounts, you follow the same path however, reconciliation requires manual entry and matching of transactions. Once cleared credits and card charges in QuickBooks agree to the card statement, you can complete the reconciliation.

This entry was posted in Bookkeeping. Bookmark the permalink.

Comments are closed.