How To Do Bank Reconciliation and QBO Undo Reconciliation

How to do bank reconciliation QuickBooks Online

Bank Reconciliation is the first step of checking the accuracy of the book. If we are using QuickBooks Online to complete the client’s books. We have to reconcile the books before we say to the customer, your job is complete.

What is Bank Reconciliation?

You may have heard the term bank reconciliation, but do you know what it means? Bank reconciliation is a process that reconciles the balance in your account with the ledger. It’s document-heavy and can be time-consuming, but it’s important to have an accurate record of your funds.

The two main processes for bank reconciliations are QBO undo reconciliation and manual accounting. This blog post will teach you how to reconcile your account using both methods so that you can easily keep track of all transactions.

Here is a bank reconciliation example.

Steps for Bank Reconciliation

It’s always a relief when you receive your bank statement, with the balance higher than expected. For those living paycheck to paycheck, it’s a huge weight off our shoulders. But what do we do if that balance is lower than anticipated? How do we reconcile the difference between our account and what was in the bank statement?

Collect all Your Transaction Records

Gather bank records for your finances. Such data is obtainable from a statement, online banking, or by having your accountant request it through an application to receive updates into their software system about all current transactions on behalf of the business and its customers. You will also need to get your business records in order. Open up that ledger of income and outgoings – it could be a logbook or spreadsheet, but either way, all the data should have been captured automatically through input tools like bills and receipts.

Check On the Deposit and Expenses

The next step is to go through each transaction on your statement, checking for anything that doesn’t make sense, like an ATM withdrawal or debit card purchase where there were no funds available at the time of the transaction (e.g., overdraft). The business records and bank statement should be able to agree on balance.

  • In the First step, we have to check Opening Balance is correct.
  • The second thing we have to check is the ending balance
  • The third one is checking the total deposits. If these are equal to Bank Statement deposits. We are ok with that.
  • The Fourth one is total Payments and withdrawals.
  • The last one is Difference If the Difference is 0. It means that we are good with Bank Reconciliation

Next, prepare a cashbook by recording the transaction in both columns, including deposits, withdrawals, and checks written but not yet presented for payment, as they occur with each entry stating the date of occurrence next to the corresponding transaction. As you compare amounts from one column against another, make sure that every amount agrees. Here is a typical bank reconciliation example.

Adjust Your Bank Statement

When balancing the bank statements, make sure to add deposits in transit. In addition, make deductions for outstanding checks and additions/deductions from errors on your account. A business must wait to record the deposit with deposits in transit until their bank has officially processed it. Until then, if an error occurs with this money (e.g., giving someone too much or not enough), there’s nothing you can do about it as they’re still waiting for final processing at your financial institution. Only once that happens will it be available for transactions such as withdrawals due to mistakes on either side of the transaction!

Deposits in transit refer to available amounts however not yet input in the banking system. Hence, all changes/additions need to occur before these funds arrive into one’s account because after they reach yours, something like accidentally adding more than a fair share could result in. Here is a typical bank reconciliation example.

Make Adjustments On the Cash Account

After adjusting your bank statement, you will also need to check your cash balance. There are three main things you need to take into account when adjusting the balance:

  • Interest rates
  • Monthly charges and overdraft fees
  • NSF checks and errors in accounting

Keeping track of these factors can help ensure that each dollar is working hard for your business! A bank reconciliation example will guide you on this.

Compare the Balances

The balances should be equal for account reconciliation. If they are not, repeat the process of reconciliation until you get it right! Once your two sets of numbers match up and align perfectly with one another, prepare journal entries to adjust for any differences in accounting books that may have skewed initial balance sheets/figures.

Why do a QBO Undo Reconciliation?

The bank reconciliation process offers many advantages for businesses, including tracking and adding in any pending fees or penalties. This could help detect errors such as missing payments or double transactions that a business may not be aware of without reconciling an account with their financial institution. Fraudulent activity can also easily be spotted if you are on top of your book which is vital for running a successful company!

How do you Undo Reconciliation in QuickBooks Online?

An important part of managing your business is reconciling the transactions in your accounting system. This would be done monthly or quarterly to reconcile with bank statements and balance sheets in a traditional debt-based company. But if you use online banking, then it can happen automatically! Or even better: If there are errors on either side, such as not enough money coming through checks but too much going out from deposits – don’t worry because they’re easy to fix just by clicking ‘undo’. The only time when reconciliation becomes difficult is if one account doesn’t match up entirely with another.

These are the steps you need to take when you want to qbo undo reconciliation (account reconciliation).

  • Start with opening up the program, then go to Banking > Registers and select Register Name from the drop-down menu.
  • Next, find your desired transaction on this list of transactions that need reconciling (you may have a lot more than one).
  • Once you’ve found it hit enter R delete “R” letter for its state to Unreconciled.

Why the Need to Undo Reconciliation?

Undoing reconciliation in QuickBooks can be done for several reasons. Some are listed below:

  • The payment was documented incorrectly and should have been recorded on the correct date.
  • A transaction is unclear to you, so it needs more investigation before moving forward with reconciling it properly.
  • Your bank statement may have incorrect dates or information about what transactions were processed when they weren’t (such as recording an ATM withdrawal from being at night instead of morning). This could lead to accidentally double-counting some transactions!

Final Thoughts

Bank reconciliation or account reconciliation is an important part of your work as a bank teller. It accounts for the money that goes in and out, keeping everyone on top of their game. You’ll come across some mystery transactions now and again; they might not enter records with one account or another. Don’t panic when you find these discrepancies! They’re why we do reconciliations – there’s often a straightforward explanation like someone being confused about which checking account to use at checkout time (say if it says “debit” vs “credit”). In addition, you can always undo reconciliation in QBO in case you encounter any of the errors, such as incorrect statement date.

Abdul Ghaffar
Abdul Ghaffar

Graduated Cum Laude Major in Bachelor of Science in Accountancy. My Accounting Degree leads me to become a bookkeeper as a profession.

All Posts