Start your business
Start your business
Run your business
Run your business
Grow your business
Grow your business
Accountants and Bookkeepers
Accountants and Bookkeepers
- Accountants and Bookkeepers
  Learn how accountants and bookkeepers can be productive in these articles & guides
- Learning and Development
  A range of informative content to enhance your QuickBooks experience.
Updates
Updates
- Product Updates
  Watch this space for monthly product updates.
- Intuit News
  Latest news, articles & guides

Need help choosing a plan?

1800 917 771 Schedule a call

Schedule call

Bank reconciliation on QuickBooks: new look, new feel

January 30, 20174 min read

With the new-look Bank Reconciliation program now available, it’s a great time to refresh your memory on how to reconcile your bank accounts.

Of course, as mentioned in our earlier blog post, the reason it’s so important to process your bank reconciliation remains the same:

“ The transactions in QuickBooks Online should mirror your business bank account. This is a significant part of the process of bookkeeping. If you do not take the time to reconcile correctly, you may find that you have missed some very important transactions that are not entered or transactions that are entered twice. These errors could cause serious discrepancies in your file.”

So, let’s delve into the refreshed look and explain the new way to process your bank reconcilation. But don’t panic, it’s not all that different.

Before we begin, it’s important to note that the old look shows payments and deposits in columns on the left and right respectively (Cheques and Payments on the left and Deposits and Other Credits on the right).

The new look is more streamlined, with the payments and deposits sitting side by side. It also allows you to filter by dates, payments and deposits. All you need to do is click on the headings in the top row, as outlined below.

1. Total payments and deposits that have been selected for the bank reconciliation

2. Difference in the bank reconciliation

3. Edit info – where you can change your Ending Balance or Ending date

4. Save for Later can be selected to continue at a later time, or choose Finish now or Close without saving

5. The Filter funnel – find an amount or filter as required

6. If only Payments OR Deposits are required, select either or ALL to view all deposits and payments

7. Payment and Deposit Amounts to be selected

8. Print button

9. Settings gear icon – which allows you to choose your columns

The reconciliation page is found when clicking the Gear Icon; under Tools choose Reconcile.

Taking you to the new Reconcile an account page, you can choose your bank account, ending balance and ending date. Then select Start reconciling.

If a manual reconciliation is required

Choose the transactions that have gone through the bank statement on the right hand side, by ticking the appropriate circle icons. This will then allow your bank to reconcile. Note the $0.00 difference; this is what you’re aiming for.

If your bank account syncs with QuickBooks Online

Choose your bank account, the ending balance and ending date, and click on Start reconciling.

This will take you to the reconciliation window, which will have automatically reconciled for you.

By syncing your bank feeds with QuickBooks Online, every transaction that has been added will already be selected in the bank reconciliation window, as shown below.

View history and reports

From the reconcile window, there is the option to view History and Reports. If you select this option, you need to choose your bank account and date range before selecting View Report from the Action column.

The reconciliation report for that period will be generated, with the option to print.

Hints and tips

On the odd occasion that you don’t quite balance, make sure you check that your ending date and balance have been added correctly. It could even be down to processing something twice.

Here are some handy tips to help your reconcile if something goes wrong.

1. As you can see in the image below, the Payments & Deposits amounts should equal what is on your bank statement.

Total Payments (debits on the bank statement) $17,944.92
Total Deposits ( credits on the bank statement) $15,172.02

If these do not match, this is where you can filter by either credits or debits, depending on which is out to find the problem.

2. Using the Undo Button: if you are logged into a file as an accountant user and you need to undo a bank reconciliation, the undo button is now found under History and Reports > Action > Undo.

The Changes and Auto Adjustment columns are also found in the History and Reports section.

** Please note: ONLY an accountant user has access to the undo button.

3. What happens if your opening statement balances don’t match? As seen below, QuickBooks Online already recognises something has gone wrong. Click on the Let’s resolve this discrepancy.

This will take you to a Reconciliation Discrepancy Report, which will help you find the problem.

If you click on View, it will take you to the audit trail of this transaction and the culprit will be found. To fix, click Unmatch and delete the transaction. Then, navigate back to the online bank feed and rectify the transaction.

Back in the reconcile window, you now need to re-reconcile your bank account to the last date that it was reconciled, as below.

4. Remember to choose the statement ending date or you may find that ALL transactions after the closing date will be chosen and you will have problems reconciling.

5. Before thinking of commencing the reconciliation process, make sure that all transactions from the online bank feeds window have been matched and added for the correct period.

6. Ensure you have entered the correct ending balance and date on your bank statement.

The new look Bank Reconciliation is found under the QuickBooks Labs. Just switch it on (as below) to experience the new look and feel.

To read more articles related to product updates, visit here.

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

See how it works

Help Me Choose

Use our product selector to find the best accounting software for you.

Choose your product

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.

Start learning

Stay up-to-date with the latest small business insights and trends!

Want more? Visit our tools and templates!

First Name*

Email*

What best describes you?*

By signing up you are agreeing to our terms and privacy policy.

- - QuickBooks reserves the right to change pricing, features, support and service at any time. Prices are in AUD and include GST. See our Terms of Service for further information.
  - Pricing: All prices are in AUD and include GST.
  - ProAdvisor Program: Please find the terms of our ProAdvisor program here.
  - 75% off for 3 months: For new subscribers, enjoy a 75% discount off the current monthly retail price for QuickBooks Self-Employed, QuickBooks Online Simple Start, QuickBooks Online Essentials or QuickBooks Online Plus for the first 3 months of your subscription (Offer). The discount will applied from the date of your enrolment and will continue for 3 months. From month 4, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - 50% off for 12 months: For new subscribers, enjoy a 50% discount off the current monthly retail price for QuickBooks Self-Employed, QuickBooks Online Simple Start, QuickBooks Online Essentials or QuickBooks Online Plus for the first 12 months of your subscription (Offer). The discount will applied from the date of your enrolment and will continue for 12 months. From month 13, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - 30% off for 3 months: For existing QuickBooks subscribers who book and attend an online support session by 30 November 2023. Enjoy a 30% discount off the current monthly retail price for QuickBooks Online Simple Start, QuickBooks Online Essentials or QuickBooks Online Plus for 3 months of your subscription (Offer). The discount will be redeemed over the phone with an expert during your support session and will continue for 3 months. From month 4, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time services and prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - Free Trial: First thirty (30) days of subscription to QuickBooks Online, QuickBooks Self-Employed and QuickBooks Payroll (including QuickBooks Advanced Payroll), starting from the date of enrolment, is free. During the free trial, you may pay any number of employees using QuickBooks Payroll free of charge. To continue using QuickBooks after your 30-day trial, you'll be asked to present a valid credit card for authorisation and you'll be charged monthly at the then-current fee for the service(s) you've selected.
  - QuickBooks Payroll powered by Employment Hero: Payroll services are offered by a third party, Employment Hero. QuickBooks Payroll is only accessible via QuickBooks Online subscriptions. You will be charged $5.00 (incl. GST) per month for each ‘active employee’ paid using QuickBooks Payroll. An ‘active employee’ is one who has been paid at least once in the billing month. For Advanced Payroll, there is an additional monthly subscription fee of $10 (incl GST). Pricing, terms and conditions, including service options, are subject to change.
  * Employment Hero was voted the leading payroll solution for SMBs <50 employees (Australian Payroll Association 2021 Payroll Benchmarking Study)
  - Customer support: Call or chat to an expert for QuickBooks Online Accountant, QuickBooks Simple Start, Essential and Plus, or use in-product QB Assistant and chat for QuickBooks Self-Employed. You'll also find useful resources in the QuickBooks Community.
  - Compatible Devices: QuickBooks Online, QuickBooks Self-Employed and QuickBooks Payroll require a computer with Internet Explorer 10, Firefox, Chrome, or Safari 6 and an Internet connection (a high-speed connection is recommended). The QuickBooks Online mobile app works with iPhone, iPad, and Android phones and tablets. QuickBooks Online and QuickBooks Payroll are accessible on mobile browsers on iOS, Android, and Blackberry mobile devices. Devices sold separately; data plan required. QuickBooks Payroll cannot be used on the mobile apps. Not all features are available on the mobile apps and mobile browser. QuickBooks Online mobile access is included with your QuickBooks Online subscription at no additional cost. Data access is subject to cellular/internet provider network availability and occasional downtime due to system and server maintenance and events beyond your control. Product registration required.
  - Get paid faster: Get paid 2.5x faster invoicing with PayPal
  * PayPal and QuickBooks customers get paid on average in less than 5 days, which is over 7 days faster than the average for invoices that get paid with other payment methods. Data is for paid invoices that were created in QuickBooks in Australia between 23.05.22 and 23.11.22
  - Tax deductions: Tax deductions not guaranteed due to being subject to user data entry errors. Mileage calculation provided by the Australia Taxation Office - 78 cents per kilometre from 1 July 2022 for the 2022-2023 income year. To a maximum of 5,000 business kilometres per car (Deductions are only applicable to cars)
  - Customer Service Awards: Excellence in Customer Service Award at the CX Australia Awards 2022
  - Multiple file discount: Multiple file discount applies to QuickBooks Australia customers only and valid when signing up for more than one QuickBooks Online subscription in one order. Further terms and conditions available here. Not applicable to QuickBooks Self Employed.
  - Reviews: Trustpilot, GetApp, Capterra, Google Play Store, Apple App Store reviews as at date 23/08/22.
  - Cost per day claim: Based on a QuickBooks Simple Start Plan at its regular retail price of $25 per month and a 31 day month.
  - Cost per day claim (annual): Based on a QuickBooks Simple Start Plan at its regular retail price of $270 per year and a 365 day year.
  - Annual Billing: You may pay for your QuickBooks Online subscription on an annual, upfront basis to enjoy a discount on the current fees. If you use QuickBooks Payroll powered by Employment Hero, your payroll costs will still be charged monthly to your nominated payment method in accordance with your usage as set out here. If you cancel your QuickBooks Online subscription within the pre-paid 12 month period, you will not be eligible for a refund, but will retain full access to your QuickBooks Online subscription for the remainder of the 12-month period. Unless cancelled by you prior, your annual subscription will auto-renew on the 12 month anniversary of your sign-up date using the billing details you have given us. Discounts, prices, terms and conditions are subject to change.
  - Over 7 million customers: Based on number of global QB customers (ecosystem) (7.1m) worldwide as of October 2022.
  - Free Onboarding: Applicable to Buy Now subscriptions on QuickBooks Simple Start, Essentials and Plus plans. Not available for QuickBooks Self-Employed.
  - Save Hours: Save up to an average of 29 hours per month with QuickBooks.
  - * Based on a survey conducted by Intuit Australia Pty Ltd in September 2022. Time saving is in comparison to previous accounting method, based on 184 responses from customers that saw time savings.
  - Sales 70% Offer: For new customers, receive up to 70% discount off the current monthly price of QuickBooks Online Simple Start, QuickBooks Online Essentials or QuickBooks Online Plus for the first 3 months of service, starting from the date of enrolment; from month 4 of enrolment, the price will then change to the then current monthly price. Or, purchase on an Annual Billing plan for 70% off for 12 months; from month 13 of enrolment, the price will then change to the then current annual price. See current prices here. This offer is only applicable if you call Sales on 1800 917 771. QuickBooks Payroll and QuickBooks Time prices are not eligible for this discount.
  - Get access to QuickBooks Tax: ***Access QuickBooks Tax, powered by LodgeiT, by becoming a member of the QuickBooks ProAdvisor Program (it’s free to join). Find out more about the ProAdvisor Program here, including the terms of the QuickBooks Tax offer in the Program here.
  - QuickBooks Time Disclaimers & Offers for Australia: For Important pricing offers and disclaimers with further information, please see here.
  - Our Terms of Service apply to all QuickBooks Online subscriptions. Please review them carefully.