QuickBooks

You should be running reports in QuickBooks Online on a weekly—if not daily—basis. Here’s what you need to know.

You can do a lot of your accounting work in QuickBooks Online by generating reports. You can maintain your customer and vendor profiles. Create and send transactions like invoices and sales receipts, and record payments. Enter and pay bills. Create time records and coordinate projects. Track your mileage and, if you have employees, process payroll.

These activities help you document your daily financial workflow. But if you’re not using QuickBooks Online’s reports, you can’t know how individual elements of your business like sales and purchases are doing. And you don’t know how all of those individual pieces fit together to create a comprehensive picture of how your business is performing.

QuickBooks Online’s reports are plentiful. They’re customizable. They’re easy to create. And they’re critical to your understanding of your company’s financial state. They answer the small questions, like, How many widgets do I need to order?, and the larger, all-encompassing questions like, Will my business make a profit this year?

Getting the Lay of the Land

Let’s look at how reports are organized in QuickBooks Online. Click Reports in the toolbar. You’ll see they are divided into three areas that you can access by clicking the labeled tabs. Standard refers to the comprehensive list of reports that QuickBooks Online offers, displayed in related groups. Custom reports are reports that you’ve customized and saved so you can use the same format later. And Management reports are very flexible, specialized reports that can be used by company owners and managers.

Standard Reports

The Standard Reports area is where you’ll do most—if not all—of your reporting work. The list of available reports is divided into 10 categories. You’re most likely to spend most of your time in just a few of them, including:

• Favorites. You’ll be able to designate reports that you run often as Favorites and access them here, at the top of the list.
• Who owes you. These are your receivables reports. You’ll come here when you need to know, for example, who is behind on making payments to you, how much individual customers owe you, and what billable charges and time haven’t been billed.
• Sales and customers. What’s selling and what’s not? What have individual customers been buying? Which customers have accumulated billable time?
• What you owe. These are your payables reports. They tell you, for example, which bills you haven’t paid, the total amount of your unpaid bills (grouped by days past due), and your balances with individual vendors.
• Expenses and vendors. What have I purchased (grouped by vendor, product, or class)? What expenses have individual vendors incurred? Do I have any open purchase orders?

The Business Overview contains advanced financial reports that we can run and analyze for you. The same goes for the For my accountant reports. Sales tax, Employees, and Payroll will be important to you if they’re applicable for your company.

Working with Individual Reports

To open any report, you just click its title. If you want more information before you do that, just hover your cursor over the label. Click the question mark to see a brief description of the report. If you want to make the report a Favorite, click the star so it turns green. And clicking the three vertical dots opens the Customize link.

When you click the Customize link, a vertical panel slides out from the right, and the actual report is behind it, grayed out. Customization options vary from report to report. Some are quite complex, and others offer fewer options. The Sales by Customer Detail report, for example, provides a number of ways for you to modify the content of your report so it represents exactly the “slice” of data you want. So you can indicate your preferences in areas like:

• Report period
• Accounting method (cash or accrual)
• Rows/columns (you can select which columns should appear and in what order, and group them by Account, Customer, Day, etc.)
• Filter (choose the data group you want represented from several options, including Transaction Type, Product/Service, Payment Method, and Sales Rep)

Once you’ve run the report, you can click Save customization in the upper right corner and complete the fields in the window that opens. Your modification options will then be available when you click Custom reports, so you can run it again anytime with fresh data.

We’ll go into more depth about report customization in a future issue. For now, we encourage you to explore QuickBooks Online’s reports and their modification options so that you’re familiar with them and can put them to use anytime. Let us know if you have any questions about the site’s reports, or if you need help making your use of QuickBooks Online more effective and productive.

There are numerous QuickBooks Online reports that you should be consulting at regular intervals. But you need these five at least every week.

QuickBooks Online’s Dashboard, the first screen you see when you log in, provides an effective overview of your company’s finances. It contains at-a-glance information about your recent expenses, your sales, and the status of your invoices. It displays a simple Profit and Loss graph and a list of your account balances. Scroll down and click the See all activity button in the lower right and your Audit Log opens, a list of everything that’s been done on the site and by whom.

You can actually get a lot of work done from this page. Click the bar on the Invoices graph, for example, and a list view opens, allowing you access to individual transactions. Click Expenses to see the related Transaction Report. Below the list of account balances, you can Go to registers and connect new accounts.

Other Pressing Questions

The Dashboard supplies enough information that you can spot potential problems with expenses and sales, accounts, and overdue invoices. But you’re likely to have other tasks that require attention. How’s your inventory holding up? Are you staying within your budget? How about your accounts payable – will you owe money to anyone soon?

QuickBooks Online offers dozens of report templates that answer these questions and many more. If you’ve never explored the list, we suggest that you do so. It’s impossible to make plans for your company’s future without understanding its financial history and current state.

QuickBooks Online has many reports that can provide real-time, in-depth insight into your company’s financial health.

Comprehensive and Customizable

When you click Reports in your QuickBooks Online toolbar, the view defaults to All. The site divides its report content into 10 different sections, including Business Overview, Sales and Customers, Expenses and Vendors, and Payroll. Each has two buttons to the right of its name.

Click the star, and that report’s title will appear in your Favorites list at the top of the page. This will save time since you’ll be able to quickly find your most often-used reports. Click the three vertical dots and then Customize to view your customization options for that report (you’ll have access to this tool from the reports themselves).

Necessary Knowledge

You can, of course, run any report you’d like as often as you’d like. Most small businesses, though, don’t require this frequent intense scrutiny. But there are five reports that you do want to consult on a regular basis. They are:

Warning: Some reports let you choose between cash and accrual basis. Do you know the difference and which you should choose? Ask us.

You can customize QuickBooks Online reports in several ways.

Customization, Complex Reports

Note that there’s a category of reports in QuickBooks Online named For My Accountant. That’s where we come in. The site includes templates for reports that you can run yourself, but that you’d have difficulty customizing and analyzing. These standard financial reports—which, by the way, you’ll need if you create a business plan or try to get funding for your business—include Balance Sheet, Statement of Cash Flows, and Trial Balance.

You don’t need to have these reports generated frequently, but you should be learning from the insight they provide monthly or quarterly. We can handle this part of your accounting tasks for you, as well as any other aspect of financial management where you need assistance. Contact us, and we’ll see where we might help provide the feedback and bookkeeping expertise that can help you make better decisions for the future of your business.

Social media posts

QuickBooks Online reports pick up where the Dashboard leaves off, providing dozens of templates ready for your company data. Do you know how to best use them?

You can create some QuickBooks Online reports using either cash or accrual basis. Do you know the difference? Ask us if you don’t.

Overwhelmed by the number of reports QuickBooks Online offers? Click the star next to the ones you run most often, and they’ll appear in Favorites.

QuickBooks Online contains several reports in a section titled For My Accountant. These are complex financial reports that we can run and analyze for you.

Sometimes, you have to spend money on your customers. Make sure you’re billing them for it.

Usually, money flows from your customers to your business. But there may be times when you have to purchase items for a job whose costs will eventually be reimbursed. Or you, or an employee, might spend time providing services for customers and get paid for those hours by your company before you receive payment from the responsible party. If you’re a sole proprietor with no payroll and no reserves, of course, you just have to wait to be paid for your work.

In the first two cases, you’re spending money upfront that will eventually be paid back. In all three cases, QuickBooks Online calls these billable expenses and billable time, and it does a good job of tracking these transactions – much better than if you were scribbling notes on a receipt or a paper timecard.

Obviously, you want to be paid for these expenditures as soon as possible to minimize their impact on your own cash flow. So QuickBooks Online “reminds” you that they need to be billed when you create an invoice for a customer. It also offers reports that help you track unbilled time and expenses. Here’s a look at how it works.

Tracking Billable Time

It’s easy to create a billable time activity. Click +New, then Single time activity. Fill in the blanks and select items from drop-down lists until you’ve completed a form. The critical section of this screen is pictured below:

In this example, the employee will receive $50/hour for the work done (Cost rate). Because the Service being provided will be billed back to the customer, you click in the box in front of Billable to create a checkmark. You’re charging the customer $65/hour (a $15/hour markup), so you enter that number in the Billable field. You don’t have to worry about remembering that. QuickBooks Online, as it does with all of your other company information, retains that and makes it available to you.

Tracking Expenses

You probably already know how to record expenses in QuickBooks Online. You can either click the +New button and then Expense, or you can click the Expenses link in the toolbar and the New transaction | Expense. Just as you did in recording time activities, you complete the fields and place a checkmark in the Billable column and select the Customer/Project from the drop-down list.

Once you’ve saved a billable expense, it will appear in the table on the Expense Transactions page. To display is again, click View/Edit at the end of the corresponding row. The transaction will open, and you’ll notice that there’s a small View link in the Billable column. Click it, and you’ll see this:

In this example, there’s been no markup applied to the transaction. If you want to add markup costs to all billable expenses, click the gear icon in the upper right and go to Account and settings | Expenses. Click the pencil icon to the far right of the Bills and expenses block of options. Click the box in front of Markup with a default rate of to create a checkmark and enter a percentage. All of your billable expenses will now include a markup of that percentage.

Invoicing Time and Expenses

The next time you invoice a customer who has outstanding time and expenses, QuickBooks Online will remind you that they’re pending. Open an invoice form and select a customer who you know has billables. The right vertical pane will contain a box containing information like this:

Click Open if you want to see the original expense record. Clicking Add will, of course, include that transaction on the invoice.

QuickBooks Online offers another way to see your pending billables. Click the Reports link in the toolbar and scroll down to the Who owes you section. You’ll see two related reports here: Unbilled charges and Unbilled time.

We want you to make sure that you’re getting reimbursed for all of the time and expenses you incur on behalf of your clients. So please let us know if you have further questions on this topic or if you have other QuickBooks Online issues.

SOCIAL MEDIA POSTS

Do you ever spend money on behalf of your customers? QuickBooks Online calls these billable expenses, and it can track them. Here’s how.

If you provide services for customers, you’ll have to invoice those hours as billable time. Did you know you can record this activity in QuickBooks Online? Here’s how.

Did you know when you invoice customers with outstanding time and expense charges, QuickBooks Online reminds you about them? Find out more here.

Confused about which customers owe you for billable time and expenses? QuickBooks Online provides specific reports for that. Find out more here.

Request your consultation today by calling us at 801-553-1120. As a thank you gift for scheduling your consultation, we’ll provide a free book, The Great Tax Escape.

New year, new challenges, and the potential for new successes. Here are five ways you can improve your financial management in 2021.

A painful year is drawing to a close. We’ll still be dealing with COVID-19 and a struggling economy in early 2021, but there’s hope on the horizon. There’s a lot you can’t control about the difficulties facing our country, but you can take control of your corner of it, especially in terms of how you manage your finances.

If you’re already using QuickBooks Online, you know how it’s solved the paperwork confusion of the past. But are you taking advantage of all of its capabilities? As you turn your digital calendar to January, consider expanding your use of the website to set yourself up for success in the new year. Here are five features to explore if you haven’t already.

Practice Proactive Reconciliation

QuickBooks Online’s Banking screen display registers for the bank and credit card transactions that have been posted by your banks. Do you review these frequently? It’s easy, and it’s important. It will save time when you do your monthly reconciliations with your bank statements. Hover over Transactions in the toolbar and select Banking. You can see some of your transaction management options in the image below.

When your statement comes and you’re ready to reconcile, you can use QuickBooks Online’s tools that take you step by step through the process. Hover over Accounting in the toolbar and select Reconcile. Let us know if you need help with reconciliation or with managing downloaded transactions.

Start Accepting Online Payments

This is probably the #1 way to encourage customers to pay you faster. When you set up a merchant account through QuickBooks Payments, you’re be able to accept credit cards, debit cards, and ACH bank transfers. Your invoices will include a Pay Now button and will contain the information your customers need to pay electronically. Their funds will go into your bank account.

There are other ways they can pay you directly. You can take their card numbers over the phone. You can also get a free card reader from Intuit and swipe their cards on your mobile device. And you can set up recurring payments that will occur automatically. There are no base fees – you just pay per transaction.

Set Weekly and Monthly Report Schedules

You may just run reports in QuickBooks Online as you need them. Some reports, though, should be created every week at a minimum, like Accounts receivable aging (detail or summary), Accounts Payable Aging, Open invoices, and Unpaid Bills. There are many others, but you need to keep a close watch on what you owe and who owes you.

It’s important to run some other reports on a monthly (or, sometimes, quarterly) basis, including Balance Sheet, Profit and Loss, and Statement of Cash Flows. Rather than just providing snapshots of where you stand with money coming in and going out, they give you a more comprehensive view of your finances that can help you make better business decisions. They’re complex and often difficult to analyze, though, which is why QuickBooks Online categorizes them as For my accountant. We can create and interpret these for you.

Expand QuickBooks Online’s Features by Using Apps

QuickBooks Online is generic enough that it can be used by a wide variety of small businesses. But that flexibility may mean that it’s not quite robust enough in one area or another, like inventory management or time tracking. There are hundreds of apps that you can integrate with QuickBooks Online to fill in the gaps. Some are free. Click on Apps in the toolbar. Again, we’re available to help if you need assistance.

Evaluate the Cost-effectiveness of Your Vendors

It’s easy to stick with the same old suppliers because it’s a hassle to change. But so many companies are hurting because of the pandemic that you may find you can get what you need for less. To go over your whole list, hover over Expenses in the toolbar and click on Vendors. You might clean up your list while you’re at it. Click the down arrow at the end of each row and select Make inactive if you haven’t ordered from specific suppliers over the last year.

As we said earlier, we’re available to meet with you and explain any of the concepts discussed here in more depth. It’s still a hard time for so many small businesses, and we want to be of help wherever we can.

SOCIAL MEDIA POSTS

Don’t have a budget set for your business? QuickBooks Online has tools that can simplify the process of creating one.

When you’re creating a budget, it’s helpful to distinguish between essential and non-essential expenses. QuickBooks Online has tools that can help you, including budgeting for necessities first.

When was the last time you shopped for new suppliers? Now is a good time to see if you could save some money and help with your budget. QuickBooks Online has many tools that can help both you and your business budget.

Did you know QuickBooks Online allows you to use existing income and expense data to create a budget? Here is how this is done.

…and how QuickBooks Online can help you with the mechanics.

If you already have a budget, it’s probably been difficult for you to stick with it for the last several months. Unless you provide products and/or services that have been in great demand since the COVID-19 pandemic took hold, you’ve had to adjust your budget significantly.

Better days are ahead, though, and now is a good time to start doing some planning for 2021. While there are still likely to be uncertainties next year, creating a budget will give you a starting point. A budget increases your awareness of all of your projected income and expenses, which may make it less likely that you’ll find yourself constantly running short on funds.

Here are some ways you can make your budgeting process more effective and realistic.

Use what you already know. Unless you’re starting a brand-new business, you already have the best resource possible: a record of your past income and expenses. Use this as the basis for your projections.

Be aware of your sales cycle. Even if you’re not a seasonal business, you’ve probably learned that some months or quarters are better than others. Budget conservatively for the slower months.

Distinguish between essential and non-essential expenses. Enter your budget items for the bills and other expenses that must be covered before you add optional categories.

You can use data from a previous year to create a new budget in QuickBooks Online.

Keep it simple. Don’t budget down to the last paper clip. You risk budget burnout, and your reports will be unwieldy.

Build in some backup funding. Just as you’re supposed to have an emergency fund in your personal life, try to create one for your business.

Make your employees part of the process. You shouldn’t be secretive about the expense element of your budget. Try to get input from staff in areas where they have knowledge.

Overestimate your expenses, a little. This can help prevent “borrowing” from one budget category to make up for a shortfall in another.

Consider using excess funds to pay down debt. Debt costs you money. The sooner you pay it off, the sooner you can use those payments for some non-essential items.

Look for areas where you can change vendors. As you’re creating your budget think carefully about each supplier of products and services. Can you find less costly alternatives?

Revisit your budget frequently. You should evaluate your progress at least once a month. In fact, you could even start by budgeting for only a couple of months at a time. You’ll learn a lot about your spending and sales patterns that you can use for future periods.

How QuickBooks Online Can Help

QuickBooks Online offers built-in tools to help you create a budget. Click the gear icon in the upper right corner and select Budgeting under Tools. Click Add budget. At the top of the screen, give your budget a Name and select the Fiscal Year it should cover from the drop-down list by that field. Choose an Interval (monthly, quarterly, or yearly) and indicate whether you want to Pre-fill data from an existing year.

QuickBooks Online supplies a budget template that already contains commonly used small business items.

The final field is labeled Subdivide by, which is optional. You can set up budgets that only include selected Customers or Classes, for example. Select the desired divider in that field, then choose who or what you want included in the next. Click Next or Create Budget in the lower right corner (depending on whether you used pre-filled data) to open your budget template. If you subdivided the budget, you’ll see a field marked View budget for. Click the down arrow and select from the options listed there.

To create your budget, you simply enter numbers in the small boxes supplied. Columns are divided by months or quarters, depending on what you specified, and rows are labeled with budget items (Advertising, Gross Receipts, Legal & Professional Fees, etc.). You simply enter numbers in the boxes that apply. When you click in a box, a small arrow appears pointing right. Click on this, and your number will automatically appear in the rest of that row’s boxes. When you’re done, click Save in the lower right. You can edit your budget at any time.

QuickBooks Online provides two related reports. Budget Overview displays all of the data in your budget(s). Budget vs. Actuals shows you how you’re adhering to your budget.

We know creating a budget can be challenging, but it’s so important – especially right now. We’d be happy to look at your company’s financial situation and see how QuickBooks’ budgeting tools—and its other accounting features—can help you get a better understanding of your finances.

SOCIAL MEDIA POSTS

Don’t have a budget set for your business? QuickBooks Online has tools that can simplify the process of creating one.

When you’re creating a budget, it’s helpful to distinguish between essential and non-essential expenses. QuickBooks Online has tools that can help you, including budgeting for necessities first.

When was the last time you shopped for new suppliers? Now is a good time to see if you could save some money and help with your budget. QuickBooks Online has many tools that can help both you and your business budget.

Did you know QuickBooks Online allows you to use existing income and expense data to create a budget? Here is how this is done.

The most important thing you need to know about sales tax is that administering it correctly can be challenging.

If you sold only one type of product to customers in one city, collecting and paying sales tax would be easy. But most businesses have a wider reach than that.

QuickBooks Online offers tools that allow you to set up sales tax rates and include sales tax on sales forms. Further, it calculates how much you must pay to state and local taxing agencies.

This is one of the most complicated areas in QuickBooks Online because you may have to deal with numerous taxing agencies. If you’re not already working with sales taxes, we strongly recommend you let us help you get everything set up correctly from the start. Taxing agencies can audit your recordkeeping and you want to make sure it is set up correctly.

That said, here are five things we think you should know.

QuickBooks Online calculates sales tax rates based on:

• Where you sell. Every state is different. If your business is located in Florida and you sell to a customer in Minnesota, you’ll be charging any sales tax levied by the state of Minnesota and possibly the city and county and other taxing authorities – if you have a connection, a “nexus” in that state (a physical location, active salesperson, etc.).
• What you sell.
• To whom you sell. Some customers (like nonprofit organizations) do not have to pay sales tax. You’ll need to edit their customer records to reflect this in QBO. Open a customer record and click the Edit link in the upper right. Click the Tax info tab and make sure there’s no checkmark in the box that says This customer is taxable. The Default tax code will be grayed out, and you can enter Exemption details in that field.

Customer records for exempt organizations should contain details for that exemption. You’ll need to see their exemption certificate or at least know its official number.

Intuit now offers a revamped version of QuickBooks Online’s sales tax features.

At some point, you’ll be asked if you want to switch to the new, more automated system. The actual mechanics of the process are simple, but you’ll be moving historical and in-process data to a new structure. If you have sales tax set up right now and your situation is at all complicated, you’re going to want our help with the transition.

This enhanced feature only supports accrual accounting.

You can combine individual tax rates.

If you are required to pay city, county, and state sales tax rates for a particular customer, for example, you can create a Combined tax rate that contains all of the individual components. The customer will only see the total on an invoice or sales receipt, but QuickBooks Online will track each one accordingly for payment and reporting purposes.

You can combine sales tax rates in QuickBooks Online (image above from current Sales Tax Center in QuickBooks Online, not the enhanced one).

Product and service records should contain sales tax information.

This is another area that will require some research. Just as some services are subject to tax, some products are not (like groceries in Arizona). So, you’ll need to find out what the rules are for what you sell. You can find this information on the website of the state’s Department of Revenue (sometimes called the Department of Taxation).

Once you know, you can record that status in QuickBooks Online. Open a product record by going to Sales | Products and Services and clicking Edit in the Action column or create a new one by clicking New in the upper right. Scroll down to Sales tax category in the record. You can choose between Taxable – standard rate and Nontaxable.

There’s a third option here: special category. This gets complicated. We can help you determine whether it applies to you.

QuickBooks Online tracks the sales tax you owe.

You can see what you owe to each agency by running the Sales Tax Liability Report, and record payments when you’ve made them. Summary and detail versions of the Taxable Sales report are also available.

Once you get sales taxes set up in QuickBooks Online, it’s easy to add them to the relevant sales forms. Getting to that point, though, takes time, study, and careful attention to detail. If you’re getting ready to sell, or you’re already selling and struggling with sales taxes, let us know. We can schedule an initial consultation to see how we can be of assistance.

SOCIAL MEDIA POSTS

Did you know that QuickBooks Online can calculate and apply sales taxes to transactions? However, setup requires some upfront research. Here are a few things to get started.

Does your business have to charge multiple levels of sales taxes? QuickBooks Online allows you to combine them. Here’s how.

QuickBooks Online calculates sales taxes based on where and what you sell, and to whom. It’s a bit complicated and here is why. We can help you get through setup.

Did you know that Intuit has released an enhanced version of QuickBooks Online’s Sales Tax Center? Here are the details and we can help you make the transition

Request your free consultation today by calling us at 801-553-1120. As a thank you gift for scheduling your consultation, we’ll provide a free book, The Great Tax Escape.