QuickBooks Tips

16 Bank Reconciliation Tips and Tricks

10/14/2020

Although it may seem like drudgery, reconciling your bank account is a critical accounting task that you should carry out each month. Doing so helps ensure the integrity of your financial reports, since most of your accounting transactions ultimately affect cash in some fashion.

Further, QuickBooks is a much more powerful tool for your business if you use it to its fullest extent. Most likely you’ve been reconciling your bank account all along, so in this article we’ll discuss the tricks and techniques you need to know to streamline the process.

If you’re new to QuickBooks, you start the bank reconciliation process by having your bank statement in hand, and then choose Banking, and then Reconcile. The Reconciliation screen shown in Figure 1 appears. In most cases, you enter the ending balance from your bank statement, add any interest or fees, and then click Continue.

You mark transactions as cleared, as shown in Figure 2, and then click Reconcile Now. However, it’s not always that simple, so read on to learn how to sail over any hurdles that may appear.

Bank Reconciliation Tips And Tricks

Figure 1: The QuickBooks Begin Reconciliation window.

Bank Reconciliation Tips And Tricks

Figure 2: The QuickBooks Reconcile window.

1. Locate discrepancies

As shown in Figure 1, click the Locate Discrepancies button to display the Locate Discrepancies window shown in Figure 3.

From there, click the Discrepancy Report button to display the report, as shown in Figure 4. This identifies any edited or deleted transactions that may affect your reconciliation.

Bank Reconciliation Tips And Tricks

Figure 3: QuickBooks can help you identify edited transactions that may disrupt your reconciliation.

Bank Reconciliation Tips And Tricks

Figure 4: Ideally your discrepancy report should never have any transactions listed.

2. Confirm your beginning balance

Your beginning balance should always tie to your bank statement, but if it doesn’t, click the Undo Last Reconciliation button until you reach a point where the beginning balance matches your bank statement. You must then redo the reconciliations to bring your books current and resolve the discrepancy.

3. Don’t forget interest and fees

Be sure to record any interest and fees in the window shown in Figure 1. Alternatively you can record deposit and check transactions to record interest and fees, or the very savvy can use journal entries.

If you go this route, be sure to debit cash and credit interest income for interest earnings or credit cash and debit bank charges for any fees incurred.

4. Double-check your ending balance

Always double-check your ending balance input when you start the reconciliation. A simple transposition or other error here can make it appear that you’ve missed a transaction.

5. Look for transpositions

Sometimes you’ll mark all transactions as cleared, but still have a difference. In such cases, divide the difference by 9. If it divides out evenly, then there’s a good chance that you transposed a number on a transaction.

For instance, a $63 dollar difference divided by 9 returns 7 could mean that a transaction was entered incorrectly. As shown in Figure 5, you can right-click on an amount, and then choose Edit Transaction to fix the error.

Bank Reconciliation Tips And Tricks

Figure 5: Right-click on an amount and choose Edit Transaction to correct a mistake.

6. Pick a side, any side

Don’t mix and match deposits and withdrawals. Reconcile your Deposits and Other Credits first, and then confirm that the total items you marked cleared ties to the amount shown on the Reconcile window.

Then reconcile Checks and Payments – doing one side a time limits your search area for missing or misposted transactions.

7. Clear the decks

If you get tangled up in a reconciliation, click the Unmark All button shown in Figure 2 to start over.

8. Enter missing transactions

You can add missing transactions without closing the reconciliation window. Simply choose a command from the menu across the top or from the Home screen. Saved transactions will instantly appear in the reconciliation window.

9. Check undeposited funds

Choose Banking, and then Make Deposits. If the window shown in Figure 6 appears, you must complete the deposit process for these transactions.

Bank Reconciliation Tips And Tricks

Figure 6: Undeposited funds can pose problems with your reconciliation.

10. Hide unnecessary transactions

Click the Hide Transactions after the Statement’s End Date check box shown in Figure 2 to have fewer transactions to sift through.

11. Void old transactions

Old, uncleared transactions can linger on forever – locate such transactions within your register, choose Edit, and then Void. The banking system generally considers checks to be stale after six months.

Such lingering transactions are often duplicates of a transaction that cleared.

12. Clear voided transactions

Always clear transactions with a zero balance as these won’t affect your reconciliation, but do clutter up the Reconcile window.

13. Bank online

Some institutions allow you to synchronize your records with your online statement. This involves a matching process that automatically clears transactions that match, and makes it easy to quickly post new transactions.

14. Use your keyboard

Rather than using your mouse to click on each transaction that you wish to clear, use the arrow keys on your keyboard to move up and down. Press the spacebar to toggle a transaction as cleared or uncleared.

15. Walk away and come back later

If you just can’t seem to get the unreconciled difference down to zero, the best thing to do is click the Leave button shown in Figure 2, and then resume the reconciliation tomorrow. A fresh eye can do wonders.

16. Reconcile More Frequently

If you can access your bank account online, you can reconcile your bank statement as often as you wish. Consider reconciling accounts with heavy volume weekly or twice a month.

Ask a Question

Find comfort in knowing an Expert in accounting is only an email or phone-call away.

We Are Here to Help

We will happily offer you a free consultation to determine how we can best serve you.

Blog

Attestation Services: Compilations, Reviews, and Audits CPAs offer attestation services as unbiased options

frequently asked questions

  • What Is A Virtual CFO & How Can It Transform My Business?
    • a. A Virtual CFO can be a much-needed sounding board, coach, and guide. Outsourced Virtual CFO is generally not just one person, but an experienced team of professionals providing a full-stack Accounting and Finance Department at a fraction of the cost that it would otherwise cost a business to hire even just one full-time CFO internally. The right virtual CFO service team, such as the one at Perpetual CPA, can deliver timely, detailed, comprehensive financial reporting, interpret the financial data, prioritize recommendations, give expert guidance on how to execute those recommendations, and ultimately give a better path to business success.
  • How can a Virtual Accounting Department help small businesses scale and grow?
    • a. A growing number of small businesses are opting to outsource services such as IT, human resources, or accounting. The benefit of a Virtual Accounting Department is that the company can reduce or increase services to accommodate current business needs. Because the service provider has multiple clients they can absorb fluctuations in workflow more easily than the average small/medium business can on its own.

      b. A Virtual Accounting Department can integrate with a company’s own accounting department to create a blended solution or provide a full-stack accounting department, including Accounting Staff, Manager, Controller, and Virtual CFO. By using a Virtual Accounting Department Small business owners don’t have to worry about hiring, training, figuring out compensation, and payroll compliance for the internal accounting team. Also as the business grows and new and more complex accounting and tax issues come up, the outsourced Virtual Accounting Department can provide all the needed expertise to facilitate continued business success.
  • What are the benefits of hiring a CPA firm?
    • a. Certified Public Accountants (CPAs) do a lot more than just crunch numbers and prepare taxes. They provide valuable expertise and strategies to help businesses and individuals achieve their business and financial goals. A CPA firm can help small businesses with management financial reporting, tax compliance, strategic business advice, and much more. Firms like Perpetual CPA, that specialize in helping small and medium-sized businesses achieve growth, can also provide Virtual CFO services, that help the business owners have the foresight into the short-term future cashflows and be able to more successfully navigate their business performance.
  • What are the best strategies for small business growth?
    • a. A business growth strategy is, simply, a plan of how a business gets from where it is today to where it wants to be in the future.

      b. Some of the questions to consider when coming up with a growth strategy are:
      i. Where will the business get new customers from?
      ii. How will the business expand into new markets?
      iii. What new products could the business offer?

      c. In reality, what happens with many small businesses, is that they generally achieve a specific level of business activity or sales and then the business growth trend flattens. In those cases, working with a firm like Perpetual CPA, which provides Virtual CFO services, can help small businesses avoid stagnation. Virtual CFO services, aside from providing timely accounting and tax reporting, can also provide valuable insight into the current performance of the business, as well as, foresight into the future cash flows for the business. Perpetual CPA Virtual CFO team helps small businesses interpret their financial information and come up with business strategies to help improve business performance and achieve growth.
  • What are the best strategies for small business risk management?
    • a. A risk management plan helps a business develop a detailed strategy to deal with certain risks that are particularly important for the businesses’ success.

      b. For many small and medium-sized businesses, the easiest way to develop and implement a business risk management plan is to work with a reputable CPA firm, such as Perpetual CPA. Large corporations invest a lot of resources and time into managing risk, which is a material factor that allows those large corporations to continue to generate billions of dollars in revenue every year. Small businesses, however, almost never manage any business risks, which is the major reason that over half of all the small businesses do not survive for more than 5 years. Generally, small business owners are not experienced corporate business professionals and lack the needed business knowledge, yet they often have to wear many hats while trying to get their businesses off the ground. In those situations, a CPA firm such as Perpetual CPA, can help small businesses better manage tax compliance risks, cash flow, internal controls, business administration, financial reporting, and much more.
  • What is Strategic Advisory and Virtual CFO? / How do Strategic Advisory and Virtual CFO services work?
    • a. When small businesses start spinning wheels, it is a good time to consider hiring a reputable CPA firm, such as Perpetual CPA, which can provide both Strategic Advice and Virtual CFO services.

      b. As a strategic advisor, the CPA firm will work with business management to improve the effectiveness and profitability of the business. They will look holistically at the business and find ways to operate the business more efficiently, increase customers through additional or improved marketing or improve customer touchpoints and service.

      c. As a Virtual CFO, the CPA firm is like a part-time version of a traditional CFO or Chief Financial Officer plus a full Accounting support team. They perform the tasks that in a larger organization would be performed by the CFO, Controller, and Accounting Staff such as preparing and overseeing the budget process, identifying and analyzing current and future trends, and developing strategies for the business growth.
  • How can timely financial visibility and management reporting help with better business decisions and growth?
    • a. A simple way to a successful business is to prioritize the timely financial visibility and management reporting as it means:
      i. Timely financial information and analysis are essential for making informed decisions, evaluating your company’s results, improving financial performance, and ensuring you are on the path to meet your strategic goals.
      ii. Management reporting is a source of business intelligence that helps business leaders make more accurate, data-driven decisions. But, these reports are most useful if they are available timely and the management receives proper interpretation of the business financial information.

free initial 30-minute consultation

    © Perpetual CPA 2023   •   Privacy Policy   •   Disclaimer   •   Accessibility Statement   •   Powered By   Designed by Dot Com Media Moguls