QuickBooks Training, Accounting and Business Administration Services
for Professionals and Small Businesses.
The QuickBooks Client newsletter
Helping you grow your business with QuickBooks software
We hope you enjoy this month’s newsletter on reporting and if you would like more information on this or any of our previous topics please give our office a call and we would be happy to help.
June is a busy month for us at Proficient Accounting Solutions (PAS). Not only are we preparing for the end of the 2nd quarter, but we’re also getting ready to attend Scaling New Heights 2014 in San Antonio, TX! The team will be joining nearly 1,000 other attendees at the conference hosted by Joe Woodard’s – National Advisors Network. This is an advanced training conference for Intuit Advisors. We will be out of the office and attending day long classes from 6/15 – 6/19. We will be back and ready to share that we’ve learned on Friday, June 20th!
Please note that during the conference access to our email and voice mail will be extremely limited. If its an emergency situation please shoot us email and we will try to get back to you as soon as possible. Otherwise we will get back to you when we return to the office on June 20th.
PAS June 2014 Newsletter
8 QuickBooks Reports That You Should Be Running Regularly
QuickBooks provides dozens of customizable report templates. You know when you need some of them, but which are musts?
You send invoices because you sold products and/or services. Purchase orders go out when you’re running low on inventory, and there are always bills to pay, it seems like. All of this activity is, of course, important in itself, but all of your conscientious bookkeeping culminates in what’s probably the most critical element of QuickBooks: your reports.
Reports can tell you how many navy blue sweatshirts you sold in March, what you paid for health insurance premiums in the first quarter, and how much you bought from your favorite vendor last month. They’re very good at drilling down to get the precise set of numbers you need.
But reports – carefully customized and properly analyzed – can do more than tell you how many golf clubs to order and when it’s time to switch phone services. They can help you make the business decisions that will help you take your growing company to the next level. There are several that you should be looking at regularly, some of which you can interpret easily and use in your daily workflow. We’ll help you with the interpretation of the more complex financial reports.
Who Owes Money?
That’s probably a question you ask yourself every day. You don’t necessarily have to run the A/R Aging Detail report every day, but you’ll want to run it frequently. It tells you who owes you money and whether they’ve missed the due date (and by how many days).
Figure 1: By running the A/R Aging Detail report, you can see whether you need to follow up with customers who have past due invoices.
As with any report, you can modify it to include the columns, data set and date range you want by clicking the Customize button. When you create a report in a format that you think you might want to run again, click the Memorize button. Enter a name that you’ll remember, and assign it to a Memorized Report Group.
There are two ways to find the reports you want to see. You can open the Reports menu and move your cursor down to the category you want, like Customers & Receivables, which will open a slide-out menu of options there.
Or you can open the Report Center, which lets you explore reports in more depth. Each is represented by a small graphic with four icons under it. You can:
Run the report with your own data in it
Open a small informational window
Designate it as a Favorite, and
View QuickBooks help.
Figure 2: If you access QuickBooks reports through the Report Center, you’ll have several related options.
Other accounts receivable reports that you should consult periodically include Open Invoices and Average Days to Pay.
Tracking What You Owe
Reports can also keep you up-to-date on money that you owe to other people and companies. An important one is Unpaid Bills Detail, accessible through the Vendors & Payables menu item. Though you can modify its columns, this report basically tells you who is expecting money from you, the date the bill was issued and its due date, any number assigned to it, the balance due, and relevant aging information.
Vendor Balance Detail is critical, too. This report displays every transaction (invoices, payments, etc.) that contribute to the balance you have with each vendor.
Standard Financial Reports
Figure 3: We hope you’ll let us help you by running and interpreting these standard financial reports.
QuickBooks report categories include one labeled Company & Financial. These are reports that you can run yourself, but they’re critical for understanding your company’s financial status. We can customize and analyze these for you on a regular basis so you’ll know where you stand. They include:
Balance Sheet. What is the value of your company? The balance sheet breaks out this information by account (under the umbrella of assets, liabilities and equity).
Income Statement. Often referred to as Profit & Loss, this shows you how much money your business made or lost over a specific time period.
Statement of Cash Flows. How much money came in and went out during a specified time range?
Reports can only generate information about what you’ve entered in QuickBooks and exactly where it’s been entered. So it’s crucial that you follow standard accounting practice as you proceed through your daily workflow. We’re always available to answer questions you have about QuickBooks’ structure and your activity there. Your reports – and your critical business decisions – depend on it.
If you have any question regarding this article or anything else related to QuickBooks, bookkeeping or your business, don’t hesitate to call us at 732-870-8884.