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.

Expand QuickBooks Online’s Features: Use Integrated Apps

Are you finding that you need more flexibility in an area of QuickBooks Online? Maybe it’s time to try an integrated app.

When you first started using QuickBooks Online, you probably found that it supplied the tools you needed to manage your accounting – and then some. But if your business has grown or become more complex, you may need more functionality and flexibility in one or more areas, like time tracking and billing.

There are hundreds of add-on applications that integrate well with QuickBooks Online in the QuickBooks Apps store, which you can find here. Many of these apps are free, but most have subscription fees. They’re designed to amplify the power of QuickBooks Online’s own features. The site will remain your home base, but you’ll have to learn enough about the add-on apps to understand how they work and how they integrate with QuickBooks Online.

Here are some of the most popular add-on solutions from the QuickBooks Apps site.

Expensify

QuickBooks Online allows you to record expenses. Its thorough form templates ask you for numerous details, like the vendor, product or service, amount, and billable status. Completed expenses appear in a table. You can run any of several related reports, like Expenses by Vendor Summary. If you use the QuickBooks Online mobile app, you can snap photos of receipts that are turned into expense forms by QuickBooks Online and partially completed with the receipt data.

Using the QuickBooks Online mobile app, you can snap photos of receipts and complete the expense forms provided.

But Expensify ($5-9 per month for one user) does more. It’s a robust expense management system that handles everything from receipt processing to next-day reimbursement. Where QuickBooks Online only supports basic expense tracking, Expensify allows you to create expense reports and follow them through multi-level approvals. It features automatic credit card reconciliation and expense policy enforcement, as well as bill pay and invoices/payments. Two-way synchronization with QuickBooks Online means you can work in either application and your data will be replicated in the other, as is the case with all of these integrated solutions.

QuickBooks Time

Formerly known as TSheets, this powerful time-tracking application builds on QuickBooks Online’s time management and payroll features. QuickBooks Time ($8-10 per user per month plus $20-40 monthly base fee) is now owned by Intuit, so it’s embedded directly in QuickBooks Online.

Your employees can track their hours on any device, from any location, and they will instantly be available in QuickBooks Online so managers can review, edit, and approve timesheets. That data can then be used in areas like invoicing, job costing, and payroll. Advanced features include scheduling capabilities, overtime monitoring, GPS tracking, and real-time reports. The Who’s Working window shows you where your staff members are working and what they’re doing, in real time.

Method:CRM

QuickBooks Online does a good job of helping you create profiles of customers and storing them for quick retrieval. But some businesses need more than that. They need true Customer Relationship Management (CRM). Method:CRM ($28-49 per month per user; discounts for annual subscriptions) is an excellent partner for QuickBooks Online in this area.

You can record and store customer details in QuickBooks Online, but Method:CRM adds true Customer Relationship management to the site.

When you integrate Method:CRM with QuickBooks Online, you no longer have to do duplicate data entry to keep track of your customers and their sales profiles and histories. You get a shared lead list and activity tracking (emails and phone calls), and your customer records contain the information a sales team needs, like customer details, interaction, transactions, and services performed. Leads are stored in Method:CRM until they’re customers, and you can track sales opportunities from a customer’s initial interest through the final sale.

Two More Advanced Integrated Apps

QuickBooks Online provides basic inventory-tracking capabilities, but if your business has more complex needs, an integrated application like SOS Inventory ($49.95-149.95 per user per month) should be able to meet them. Built for QuickBooks Online from the ground up, the application offers advanced features like sales orders and order management, assemblies, serial inventory, and multiple locations. And if you need more sophisticated bill pay, invoicing, and payment processing (with multiple automated approval levels) than QuickBooks Online offers, you might look into the highly-regarded Bill.com ($39-69 per user per month).

Growth Is Good, But Challenging

We wanted to introduce you to a few of the hundreds of integrated apps available for QuickBooks Online because you should know that there are options for expanding on the site’s built-in capabilities. As your business grows, so does your need for more sophisticated accounting. QuickBooks Online may still be able to serve you well with the help of one or more of these add-ons.

You may also want to explore the possibility of upgrading your version of QuickBooks Online. We encourage you to consult with us if you’re outgrowing QuickBooks Online. We can help you explore the options so you can spend your time planning for your company’s future instead of wrestling with your accounting application.

There are many ways to encourage delinquent customers to pay. QuickBooks Online’s statements may be effective for you.

After the year-plus you’ve just experienced, the last thing your small business needs is customers who are behind on their payments to you. You may have been giving them a break because you know that they’re struggling, too, but things have been looking up for many companies in the past few months. It’s time for you to be more proactive about calling in your debts.

There are numerous ways you can accomplish this. One of the best is to send statements in QuickBooks Online, which are detailed reminder forms that contain multiple transactions. These can be especially helpful if you’ve sent multiple invoices with no response. There are three different types you can send, depending on your needs. Here’s how you create them.

Before You Start

QuickBooks Online offers a couple of options for formatting your statements. To see these, click the gear icon in the upper right corner and select Your Company | Account and Settings. Click the Sales tab and scroll down to the Statements section. Click the pencil icon over to the far right to make any changes needed. You can:

• List each transaction as a single line or include all of the detail lines.
• Display an aging table at the bottom of each statement.

Click the buttons to specify your preference and then click Save and Done.

Three Statement Types

You can choose from among three different types of statements in QuickBooks Online: Balance Forward includes invoices with outstanding balances for a specified range of dates. Open Item statements contain information about all unpaid (open) invoices from the last 365 days. And Transaction Statements show every transaction in a date range that you specify. We’ll describe how to create them so you can decide which makes the most sense for a particular situation.

One Way to Create Statements

Like it does for many other actions, QuickBooks Online offers two ways to create statements. The first is easier. Click the New button in the upper left and select Statement (under Other). Click the down arrow in the field under Statement Type to see the three options there.

If you select Balance Forward, you’ll need to define three criteria (there will be similar options for the other two types):<.p>

• Statement Date
• Customer Balance Status (Open, Overdue, or All)
• Start Date and End Date

When you’re satisfied with your statement parameters, click Apply. QuickBooks Online will display a list of the transactions that meet your criteria, along with the number of them that will be generated. Each row in the list will display the recipient’s name, email address, and balance. In the upper right corner, you’ll see the number of statements again and the total balance these customers represent.

If you want to exclude any of these customers, click in the box in front of each to unselect them and delete the checkmark. When you’re satisfied with your list, click Save, Save and send, or Save and close. If you click Save and send, a window will open containing a preview of your statements. Thumbnails of each will appear in the left pane. Click on any to see their previews. When you’re ready, you can download, print, or send them.

If you click Save or Save and close, you’ll still be able to see the statements you’ve just generated. Click the Sales tab in the toolbar, then All Sales. Click the down arrow next to Filter and open the drop-down list under Type. Select Statements, and your list will appear. You can print or send one by selecting the correct option in the Action column. If you want to dispatch multiple statements, click in the box in front of each, and then click the down arrow next to Batch actions.

Another Method

There’s an alternate way to create statements. Click the Sales tab in the toolbar, then Customers. Select any or all of the customers in the list, then click the down arrow next to Batch actions and select Create statements. QuickBooks Online will open the Create Statements window again so you can select the type and process your statements like you did using the previous method.

We don’t expect that you’ll have much trouble working with statements, though you may want to consult with us on when they’re appropriate. We can also suggest other ways to bring your accounts receivable up to date. As always, we’re available to help you maximize and streamline your use of QuickBooks Online. Keeping your financial books current and organized is one way to ensure that you don’t fall too far behind with customer payments.

If you dread every minute of the time you spend on accounting, you should know how QuickBooks Online can change your outlook.

How long would it take you to determine:

• What your total expenses for this quarter are?
• Whether or not your business is profitable as of today?
• How much you’ve sold every month this year?
• Which invoices are overdue?

If you’re using QuickBooks Online, you can get answers to all those questions—and more—in the time it takes you to sign on to the website.
That’s not an exaggeration. The first thing QuickBooks Online displays is what’s called its Dashboard. This is the site’s home page, which contains an array of charts and account balances that provide a quick overview of your finances. Click on an element here—say, a checking account balance—and you’ll be able to drill down and see the details behind it (in this case, an online account register). Click on the Expense graph, and a transaction report opens.

Your First Hours with QBO

QuickBooks Online is not one-size-fits-all. Its setup tools help you customize it to meet your own company’s needs.

QuickBooks Online works like other online productivity applications you may have used. It uses toolbars and buttons for navigation, drop-down lists and blank fields for data entry, and clickable links to open new related screens to trigger actions. Which is to say, the site is easy to use once you understand its structure. We can walk you through the early steps that are required, which involves tasks like: Using the provided setup tools to customize the site. Connecting QuickBooks Online to your bank and credit card company websites so you can work with transactions. Creating records for your customers, vendors, and the products and services you sell (you’ll be able to add new ones as your business grows). Learning about QuickBooks Online’s pre-built reports. Familiarizing yourself with the site’s workflow. Making the transition from your current accounting system.

How You’ll Benefit

Once you’re comfortable using QuickBooks Online, you’ll discover what millions of small businesses have already learned, that the site helps you:
Get paid faster. You can sign up with a payment processor to accept credit cards and direct bank withdrawals, which can speed up your customers’ responses to invoices. You’ll also be able to accept payments when you’re out of the office on your mobile devices.

Minimize errors. Once you enter data, QuickBooks Online remembers it. No more duplicate data entry that can cause costly mistakes.

Find any detail in seconds. QuickBooks Online has powerful search tools that allow you to find what you’re looking for quickly.
Better service customers. Because your customer profiles include transaction histories, you’ll be able to deal with questions and problems quickly and accurately.

Bill time as well as invoice products. QuickBooks Online supports sales of time-based services with capable time-tracking tools.

Improve your customers’ and vendors’ perception of you. Your business associates will know that you’re using state-of-the-art technology by the forms you share and the customer service you provide.

Save money and time. It does take some time to make the transition to QuickBooks Online. But you’ll quickly make that up with the hours you’ll save on accounting tasks, and be able to concentrate on tasks that improve your bottom line.

Be prepared to grow. Because all of your financial data is organized and easily accessible, you’ll be able to quickly generate reports that help you plan for a more profitable future. Banks and investors will need some of these if you decide to seek financing.

Mobile Access

Although you may do the bulk of your accounting work on your desktop or laptop, you’ll have access to many of the site’s features on your smartphone. Your home page displays both an abbreviated version of your browser-based dashboard and a list of recent transactions. You can view, edit, and build new customer, vendor, and product or service records. Snap a photo of a receipt to document an expense and look up or create invoices, estimates, and sales receipts. Record payments, view critical reports, and add notes. Of course, your mobile data is always synchronized with the site itself.

QuickBooks Online lets you do much of your accounting work when you’re away from the office with its mobile app.

Happy to Help

QuickBooks Online was designed for small businesspeople, not accountants. But it includes features that are best used in conjunction with our consulting services, like advanced reports, payroll, and the Chart of Accounts. In fact, the site makes it easy for us to have access to your data so we have the ability to monitor and troubleshoot.

We’ve helped countless sole proprietors and small businesses move their accounting operations to QuickBooks Online, and we’ve seen the difference it’s made in their productivity as well as their attitude toward financial management. Contact us, and we’ll be happy to do the same for you.

Call us at 770-229-7145 to learn more about our QuickBooks setup and support services.

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.

Call us at 770-229-7145 today. We offer a free initial consultation for new clients to find out how they can benefit from our accounting, bookkeeping and tax services for small businesses.

…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.

Call us at 770-229-7145 today. We offer a free initial consultation for new clients to find out how they can benefit from our accounting, bookkeeping and tax services for small businesses. We work with businesses in Lawrenceville and throughout the Snellville area.