QuickBooks Tips

Ten Overlooked QuickBooks Reports That You Should Use

10/14/2020

Just about every QuickBooks user relies on the Report Center and Reports menu, but if you’re like most, you have a small handful of reports that you tend to rely on. In this article we’ll go off the beaten path and explore ten reports that many users overlook. Even if you are using some of these reports, we’re sure you’ll find a few more to add to your repertoire.

1. Profit & Loss Summary Prev Year Comparison: To access this report, choose Reports, Company and Financial, and then Profit & Loss Summary Prev Year Comparison. Most business owners rely on the Profit & Loss Summary report, but comparing your results to last year can provide quick insight into whether your revenue is growing or contracting-as well as how fast expenses are rising.

2. Balance Sheet Prev Year Comparison: You’ll find this report also within the Company and Financial section of the Reports menu. As with your income statement, it’s important to compare where certain balances stand now versus last year:

  1. Cash
  2. Accounts Receivable
  3. Inventory
  4. Accounts Payable
  5. Other Liabilities, such as lines of credit or short term loans

3. Statement of Cash Flows: As with the two preceding reports, you’ll find the Statement of Cash Flows in the Company & Financial section of the Reports menu. Profit & Loss reports enable you to see what you earned, while Balance Sheet reports help you determine what you have-as well as what you owe. However, neither report necessarily provides a clear picture of where cash is coming from, or going to. As shown in Figure 1, you’ll be able to see:

  1. How much cash you’ve taken in from sales and spent on expenses
  2. Cash inflows or outflows from borrowing, repayment, or investing activities

In short, this report shows you exactly what caused your bank balance to increase or decrease during a given report period.

Ten Overlooked QuickBooks Reports That You Should Use

Figure 1: The Statement of Cash Flows report explains changes in your bank account balance.

4. Collections Report: Tricky economic times mean it is more important than ever to keep track of your collections. Fortunately QuickBooks makes it easy to contact customers with overdue invoices: choose Reports, Customers & Receivables, and then Collections Report. As shown in Figure 2, the report provides a phone list and shows all overdue invoices. However, you can also use this report to quickly e-mail copies of overdue invoices to your customers. To do so, double-click on a transaction within the Collections report to view the invoice, and then click the Send button at the top of the invoice form to display the Send Invoice form shown in Figure 3. You can modify the wording shown to be more direct, such as a subject line of “Overdue Invoice” or perhaps e-mail text along the lines of “I’ve attached a copy of your overdue invoice. If there’s a problem with our products or services, please let me know immediately, otherwise I trust that you’ll remit payment promptly.” To change the default e-mail text, choose Edit, Preferences, and then choose Send Forms. Select Invoice from the Change Default For list, make your changes, and then click OK.

Ten Overlooked QuickBooks Reports That You Should Use 2

Figure 2: The Collections Report gives you a jump start on dunning overdue customers.

Ten Overlooked QuickBooks Reports That You Should Use 3

Figure 3: You can adjust the wording of an overdue invoice e-mail for one customer at a time or change the default text.

5. A/P Aging Summary: Although it’s key to make sure that your customers are paying in a timely fashion, it’s just as important to pay your vendors, too. Unpaid bills can result in phone calls, e-mails, and other unnecessary interruptions. Choose Reports, Vendors & Payables, and then A/P Aging Summary to display the report shown in Figure 4. As with most reports in QuickBooks, you double-click on amounts to ultimately drill down to the original transaction.

Ten Overlooked QuickBooks Reports That You Should Use 4

Figure 4: The A/P Aging Summary helps you determine when bills are slipping into overdue status.

6. Trial Balance: Many business owners overlook the Trial Balance report, since it’s one of the few reports in QuickBooks that uses the terms Debit and Credit. However, it’s a helpful report, as it shows you all account balances in a concise format. If anything looks out of order, simply double-click on the amount to view the underlying detail. Choose Reports, Accountant & Taxes, and then Trial Balance to view this report.

7. Voided/Deleted Transactions Summary: It’s no surprise that small businesses are much more prone to fraud than large businesses. Small business employees usually wear multiple hats, so it’s often impossible to separate financial duties (bigger businesses can do this with ease). Fortunately QuickBooks makes it hard for perpetrators to cover their tracks: choose Reports, Accountant & Taxes, and then Voided/Deleted Transactions Summary. As shown in Figure 5, you’ll be able quickly identify any transactions that have been deleted from QuickBooks. Granted, this isn’t an end-all solution by any means, but it is a helpful management tool. Plus, if a transaction ends up “vanishing” from QuickBooks, you can use this report to see who deleted it!

Ten Overlooked QuickBooks Reports That You Should Use 5

Figure 5: The Voided/Deleted Transactions Summary enables you to find transactions that appear to have vanished.

8. Audit Trail: The audit trail was an optional feature in earlier versions of QuickBooks, but is permanently enabled in recent versions of QuickBooks. This provides a complete record of every entry made in QuickBooks, as shown in Figure 6. The downside to that is that you can end up with a massive report. Don’t worry, as it’s easy to filter this report and narrow your search. To do so, choose Reports, Accountant & Taxes, and then Audit Trail. Once the report appears, click the Modify button, and then click on the Filters tab. You can filter by date range, amount, or dozens more fields.

Ten Overlooked QuickBooks Reports That You Should Use 6

Figure 6: The audit trail shows every transaction-including modifications-in QuickBooks.

9. Previous Reconciliation: It’s a good practice to always print at least the summary report once you’ve reconciled a bank or credit card account. Someone else could edit a reconciled transaction, which could cause the reconciliation to be out of balance. A printed copy of the report shows that the account reconciled as of the report date, although you will still have to untangle the edited transaction. However, if you close out the reconciliation screen, you have a second chance to print your report: choose Reports, Banking, and then Previous Reconciliation. As shown in Figure 7, you can choose from multiple reports.

Ten Overlooked QuickBooks Reports That You Should Use 7

Figure 7: The Previous Reconciliation report option allows you to reprint missing account reconciliation reports.

10. Transaction History: Think of this as a “report within a report”, as you can only run it in certain circumstances. As shown in Figure 6, you must have a transaction open on the screen or single-click on a transaction within a report. You can then choose Reports, and then Transaction History. As shown in Figure 8, QuickBooks will display a report that shows the entire history for a given transaction.

Ten Overlooked QuickBooks Reports That You Should Use 8

Figure 8: The Transaction History report provides shows all activity related to a given transaction.

Did You Know?

The Microsoft web site offers hundreds of free spreadsheet and word processing templates. Options range from timesheets to analysis tools to contract documents. Visit http://office.microsoft.com/templates, and then search for a template by use (home, office, school), collection (real estate, small business, wedding), or keyword. Indeed, if you’ve created a template that you rely on, you can submit it to the site and share your work with others!

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 2020   •   Site Map   •   Privacy Policy   •   Disclaimer   •   Powered By   Designed by Dot Com Media Moguls