New Business Direction LLC|
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.
|
|
Getting There
|
|
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:
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
|
||
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:
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. |
Intuit Field Service Management simplifies your business and gives you more control over your technicians, customers, cash flow and costs. It eliminates paperwork from work orders to invoices – so you can get paid faster.
Field Service Management is web-based software that integrates with QuickBooks® Pro, Premier and Enterprise to schedule Work Orders and dispatch Field Technicians via a Dashboard and Mobile devices. It integrates with Google Maps to locate job-sites and minimize travel time and allows for Mobile Billing and Payments. 
The Intuit Service Provider training courses are designed to enhance the consultants’ knowledge of the product for configuration, deployment, integration and training on Field Service Management.
Rhonda Rosand, CPA is the owner of New Business Directions. She specializes in QuickBooks consulting and training services, coaching small business owners, and providing innovative business solutions.
The two major ways entrepreneurs can take money from their business is through draws or by receiving a paycheck. The type of entity in which their business is set up will determine which method can be used. In either case, entrepreneurs need to be careful not to shortchange themselves.
Especially if you’re running a service business, it’s easy to initially think you can do well with a similar hourly rate that you earned as an employee. Here’s a quick list of five elements that should be included in the compensation of every entrepreneur:
|
1. Competitive Pay
|
|
|
If you were doing the same work for a company that hired you, what would your pay be? Are you making at least market equivalent or better? A lot of times, as entrepreneurs, we tend to focus only on this piece of our compensation when we set our pricing, and that’s a big mistake. It’s only 75 percent of what our total pay needs to be.|
2. Profit
|
|
|
As an entrepreneur, you take extra risk when you own your own company, and you should be compensated accordingly. Your capital is tied up in your business and should be earning a good return in addition to your reasonable compensation. |
3. Benefits
|
|
Employees get vacations, health insurance, and bonuses; and you should too. This should be part of your compensation package as an entrepreneur. |
|
4. Taxes
|
|
|
Although our individual taxes are not deductible as business expenses, we need to compensate for them so that we’ll have enough cash for our living expenses. It’s a huge chunk too. We work about three and a half months every year, just to pay for our taxes. |
5. Retirement Plan
|
|
|
When you work for yourself, no one is going to fund your retirement for you. Although the Social Security program helps a lot of seniors, it’s up to you to set additional money aside for a comfortable future. |
Complete Compensation
|
|
Your compensation should include all of these components. If it doesn’t and you feel like you can’t afford to pay yourself that much, then your pricing might not be reflecting all of these items correctly, you might have a volume problem, or your business model may need some adjusting.
It’s normal to take a smaller paycheck the first few years as we’re building our businesses, but if you’re still doing it after several years or constantly having cash flow issues, then something may be wrong.
If you’d like our help in this area of your business, please reach out and let us know.
Make sure your future is bright and financially secure by including all five components in your entrepreneur compensation. |
Watching the cash balance is one of the most frequent activities of a small business owner. Besides making sure you have enough cash for payroll and bills, there is another huge opportunity you can benefit from: lowering the cost of processing your bills. It can be expensive and time-consuming to process bills and handle the paperwork involved. We’ll take a look at a couple of the many ways you can streamline your accounts payable processing costs in this article.
|
Opportunity #1: Go Digital
|
|
The Intuit Payment Network (IPN) is a best-kept secret when it comes to sending and receiving money. It’s free to set up your account, and it’s also free for your receiver to set up an account. All you do is add your bank account, and you can easily transfer funds between the two accounts just by knowing the receiver’s email address.
Another way to go digital is via PayPal. Fees vary, and are usually paid by the receiver. |
|
Opportunity #2: Get Control
|
|
When it comes to finances, it’s never a good idea to mix business and personal, especially when it’s coming out of the same bank account. Keep separate accounts for business and personal, and your bookkeeping costs will go way down. Do the same thing for credit cards as well.
|
|
Opportunity #3: Automate
|
|
|
|
Opportunity #4: Verify
|
|
We hope you never pay bills that aren’t yours, but it can happen. To avoid it as much as possible, implement a three-way matching process on all your payables, especially those related to inventory. The three-way part refers to the three documents involved in accounts payable:
Before any invoice is paid, these three documents should be matched line by line – for quantity, price, and description — to ensure you ordered and received what you paid for. Only then should your bill be approved. This will ensure that you don’t pay a fraudulent bill, you don’t pay for out-of-stock that didn’t ship and that you paid the correct price you agreed to in the first place.
Please feel free to reach out and ask us about this if you’d like to know more. |
|
Opportunity #5: Tell Yourself a Little White Lie
|
|
Reduce all that by telling yourself a little white lie about your bank balance. If your bank balance is $10,000, tell yourself it’s only $5,000 (or whatever amount makes sense for you). That way, you’ll always have a cushion in your account that will help you reduce transfers. There are several ways to set this “little white lie” up in your books. |
There’s an old saying: “robbing Peter to pay Paul.” If you’re always moving money around from one checking account to another to cover bills and payroll, you’re not the only small business owner who juggles funds. It takes up valuable time to make all these transactions, and then it costs to record them and track them. |
More A/P Ideas
|
|
These are only five of many ways you can reduce your processing costs and save time on accounts payable processing. Give these five accounts payable ideas a try, and if you’d like to know more, please reach out and let us know. |
I’m honored to have just earned my QuickBooks Cloud ProAdvisor designation from Intuit. We are excited to continue our strong relationship with Intuit in the QuickBooks ProAdvisor program where we receive outstanding access to higher-level software support, multiple software products including third-party add-ons, and additional training and certification options that help us increase our proficiency in the Intuit QuickBooks product line.
For you, my new certification means I’ve achieved a level of competence recognized by Intuit that demonstrates my knowledge of QuickBooks Online. With this knowledge, I will be able to answer your questions about QuickBooks Online, help you assess whether this product will better meet your business needs compared to other QuickBooks products, and provide you with productivity-boosting training filled with all the tips I’ve just learned.
If you’re interested in finding out more about whether QuickBooks Online can better serve your business’s needs or anything about QuickBooks Online, then please reach out and give us a call.
To learn more about New Business Directions and QuickBooks®, or to schedule an appointment, please call (603)356-2914, email rhonda@newbusinessdirections.com or visit the website at www.newbusinessdirections.com.
Sign up for our FREE newsletter
Tips & Tricks in QuickBooks®
