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. I want to explore some 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.
Using the Report Center is a PC resource hog. Meaning it will such up your computers resources to open and use, I recommend that when you find/get your reports that you use regularly, memorize those, and open them this way.
The 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.
The 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:
- Accounts Receivable
- Accounts Payable
- Other Liabilities, such as lines of credit or short term loans
The 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.
- How much cash you’ve taken in from sales and spent on expenses
- 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.
The Collections Report: Rough 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. 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. 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.
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. As with most reports in QuickBooks, you double-click on amounts to ultimately drill down to the original transaction.
The A/P Aging Summary helps you determine when bills are slipping into overdue status.
The 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.
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.
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!
The Voided/Deleted Transactions Summary enables you to find transactions that appear to have vanished.
The 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. 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.
The audit trail shows every transaction-including modifications-in QuickBooks.
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.
Transaction History: Think of this as a ‘report within a report’, as you can only run it in certain circumstances. 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. QuickBooks will display a report that shows the entire history for a given transaction.
© 2012, Bruce Mc. All rights reserved.