Author: Ida_Bencomo

Last month, we created records for products and services. Now, we’ll talk about where they’re used in QuickBooks Online.

If you’ll recall, we went over two product-related concepts in QuickBooks Online in last month’s column. We first discussed getting the site ready for creating and using product and service records. You click the gear icon in the upper right and select Account and Settings, then click the Sales tab to indicate your preferences.

To create a product or service record, you hover your mouse over Sales in the left vertical pane on the main page and click Products and services. Click New in the upper right corner and open a blank record for an Inventory or Non-inventory part, a Service, or a Bundle (assembly). Once you complete a record and save it, it will appear in the list back on the Product and services page.

Working with Products and Services

That’s where we’ll start today, on the Products and services screen. This is a comprehensive table, a dashboard (or home page) for your products and services. It displays real-time information about your items’ pricing and inventory levels, as well as their type and tax status. At the top of the page, you’ll see big, colorful buttons that provide a total of the number of items that are low on stock or out of stock. When you click on one, a list of those products appears.

QuickBooks Online’s Products and services page displays inventory levels and warns you when your stock is low and at zero.

Each row on this screen contains details about the item listed there, like Description, Sales Price and Cost, and Qty On Hand. If you look down at the end of the row, you’ll see options for several types of Actions: Edit, Make inactive, Run report, and Duplicate. Click the gear icon above the table to modify the columns in the table. 

The More menu at the top of the screen contains more options: Manage categories, Run reports, and Price rules. If you want to know what actions you can take on multiple items simultaneously, check the box in front of each and click the Batch actions menu, over to the right (Adjust quantity, Reorder, etc.).

Warning: Be very careful using the Adjust quantity option. There are legitimate reasons for employing it, but you need to make very sure that you understand how this will affect other areas of your accounting. Please ask us if you’re unsure.

Using Products and Services in Transactions

Once you start using product and service records in transactions, you’ll see why we suggested that you create those early on and make them as comprehensives as possible. While you can add products and services in the process of creating an invoice, for example, it’s much easier if you have them ready to go.

Let’s look at a sales receipt to see how this works. Click +New in the upper right corner and select Sales receipt. Select a Customer in the first field and verify that the related fields on the form were filled out correctly. Check and make any changes necessary in the Sales receipt date, Payment method, and Deposit to fields. 

Once you’ve built up a list of products and services, they’ll be available when you create transactions.

Enter the Service Date, and then click the down arrow in the field under Product/Service. The top of the list has an entry labeled +Add new. Click it if you need to add a product or service on the fly, or just select the existing one that you want. QuickBooks Online will fill in the Rate, Amount, and Tax (status). You only have to enter the Qty (quantity) that you’re selling. 

If you have more items or services to add, you can do so on the next line(s). When you’re done, check the numbers in the lower right and save the transaction. QuickBooks Online will adjust your inventory to account for any items you just sold. You can see this change by going back to the Products and Services screen. Or you can run reports, including:

• Sales by Product/Service
• Product/Service List
• Inventory Valuation Detail
• Physical Inventory Worksheet

Supply Chain Woes?

It seems that the serious supply chain problems we were experiencing in previous months have eased up some, but you may still be having trouble stocking some items. We hope this isn’t affecting you too much. 

QuickBooks Online, though, can help ensure that you know ahead of time when you must reorder. Its inventory-tracking capabilities can also alert you to items that aren’t selling well, so you don’t get overstocked on anything. And the ability to pull up product and service records when you’re creating transactions saves time and keeps your inventory levels accurate. Please let us know if you need assistance with this element of your accounting – or any of QuickBooks Online’s other tools.

Your customers are your company’s lifeblood. Make sure their records are thorough and up-to-date.

When companies buy other companies, what’s often considered the most critical asset? The customer list. When a business is damaged and data possibly lost, which set of records do they most hope to recover? The customer list.

You probably spend most of your time in QuickBooks Online working with transactions and reports, but your customer records deserve equal time. If they’re incomplete or otherwise not maintained well, you lose time filling in the blanks when you’re trying to complete a task that requires complete customer profiles. Your searches and reports may not tell the whole picture. Your relationships can suffer, and you may miss out on sales opportunities.

QuickBooks Online provides excellent tools for creating and maintaining comprehensive customer and sub-customer records. Here’s a look at how it all works.

Moving Your Customer Data In

There are two ways to create customer records in QuickBooks Online. If you have an existing database in Outlook, Excel, Gmail, or Google Sheets, you can import it. This will save you an enormous amount of time, but it’s a challenging process. You select the file you want to import, and then you have to “map” it by matching the fields in your database to fields in QuickBooks Online. You’ll likely need our help with this.

To import a customer file into QuickBooks Online, you’ll have to “map” its fields. We can help you with this.

Your other option is to enter records manually. This is time-consuming, but the more information you can include about your customers from the start, the better. You can always edit your records to add, delete, or modify what you originally entered.

To get started, hover over Sales in the toolbar and click on Customers. Then click on New Customer in the upper right corner to open the Customer information window. The only field you’re required to complete is Display name as. You may want to do this if you have a new customer on the phone and you want to concentrate on the conversation. You can take notes about their contact information and fill in the record later, when you’re off the phone.

But wherever possible, as we’ve already said, complete as many fields as you can.  You’ll enter name and billing and shipping address and phone number(s) on the opening screen. You can also supply contact details like fax number and website. 

Creating Sub-customers

You’ll notice a checkbox that says Is sub-customer. QuickBooks Online lets you “nest” related records under the “parent” record. This can be an actual customer, but many people use it to document jobs they’re doing for the customer. So if you’re a contractor, for example, you might have sub-customers like Sun deck and Spa. 

If you want to set up such a record, enter the job name and click in the box next to Is sub-customer. Two fields will open below that allow you to select the parent customer and to indicate the sub-customer’s billing status. The remainder of the fields will automatically fill in with the parent customer’s contact information.

You can set up jobs as sub-customers in QuickBooks Online. 

Supplying Details

When you’re setting up individual customers, you should add as much detail as you possibly can to each record, beyond basic contact information. QuickBooks Online’s record templates display a number of tabs running horizontally across the window. The most important of these are:

• Tax info. Are the customers taxable or exempt? If taxable, what is his or her Default tax code? (If you haven’t set up sales taxes yet and need to, please let us help. It’s complicated.)
• Payment and billing. Do they have preferred payment and/or delivery methods? Will you be assigning default payment terms, like Net 30 or Due on receipt? What is their Opening balance? If they’re brand-new customers who have never ordered from you, this will be $0.00. If they’re existing, active customers, enter any outstanding balance they have with you as of the date that you enter. This must be correct, to avoid any problems with the customers’ ongoing balances. Questions? Ask us.

Other tabs here are self-explanatory. When you’ve entered everything you can, click Save. The new record will now appear in the Customers list and will be available to select from the drop-down list in transactions.

There will be times when you have to refer back to these forms to answer questions. By maintaining detailed, accurate customer records, you’ll be ready to respond. If you have questions about any of the information requested, or about other elements of QuickBooks Online that are puzzling you, please contact us so we can set up a consultation.

QuickBooks Online is more portable than you may realize.

In this work-from-home world, millions of people are finding it impossible to get away from the “office”. But there may be times when you’re not at home or work when it would be really convenient to have access to your accounting data in QuickBooks Online. 

The site’s free companion apps make that possible. Available for both Android and iOS, the QuickBooks Online mobile app can do many of the things that you’re used to doing on your desktop or laptop. And of course, everything you do on the app is synchronized with your browser-based version, and vice versa. Both versions look and work similarly and offer a user experience that makes your mobile tasks easy to accomplish. 

Here’s a look at what you can do.

The QuickBooks Online mobile app doesn’t look much like the browser-based version, but it can do many of the same tasks.

Navigation Tools

Once you’ve downloaded the QuickBooks Online mobile app and entered your login credentials from the browser-based version, you’ll see a screen full of shortcuts to the app’s main functions. This is an abbreviated list of what you can actually do, but it takes you to the screens you’ll want to see most often. Click the All tab, and a full set of links for the app opens that includes functions missing from the shortcuts page, like Reports and Products & services. 

Click on the home button in the lower left, and the app opens two more screens. One is a Dashboard that’s similar to the one you see in your browser. It displays charts for profit and loss, invoices, and expenses, as well as a list of your account balances. Click the Activity tab to see a list of the most recent activity. Like most everything on the app, the list is interactive. When you click on an activity, the transaction underlying it opens.

There are two more navigation links at the bottom of the screen. When you want to add a transaction, you can click on the + (plus) sign to open your options there. Click the three horizontal lines to open the Shortcuts page. The gear icon in the upper left takes you to the Settings screen, where you’ll find links to Company Information, Tax Rates, Overdue Invoice Alerts, etc.

Records and Transactions

Customer and vendor records are not as detailed as they are on the browser-based site, but they should serve you well for mobile activities. You can toggle between basic contact details and recent activity. There are also icons that allow you to quickly call, text, or email a contact. Product records are not as complete, however you can see each item’s name, description, sale price, tax status, and account and category assignments. You have the ability to edit records and create new ones on the apps.

You can view the data from your browser-based version of QuickBooks Online on the mobile app.

You can also add and edit transactions on the mobile apps, including invoices, estimates, sales receipts, expenses, and invoice payments. These are very thorough. They include the fields you need to bill customers and record purchases. You can even request signatures on estimates, add notes or attachments to invoices, and view a status bar for invoice progress.

Other Features

There are other tasks you can complete on the QuickBooks Online mobile apps. You can snap photos of receipts with your phone. The apps will then upload them to the main site and move some of their data on to the correct fields on forms. You can work with bank deposits, projects, and categories. And you can record mileage for business trips. If you turn on Auto-tracking, the apps will record your mileage as you drive.

There’s one more feature on the app that’s fairly new to QuickBooks Online – so new that it may not have been rolled out to you yet: Cash Flow. This is divided into two sections on the main site, Overview and Planner. The second deals with cash flow projections, which can be a complex concept to understand. We recommend you let us walk you through this tool so you know when it may be wise to take actions that will prevent an impending cash crunch.

Are you experiencing cash flow problems now because of the economic downturn? We can analyze your data and reports in QuickBooks Online and help you come up with a recovery plan, contact us to help you.

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

Keep a constant watch on your accounts receivable to improve cash flow.

Quick: How many of your invoices are unpaid? Have any of your customers gone over 30 days past due? Did you bill all of the time and expenses for that project you just completed for a customer?

If you’re doing your accounting manually, there’s simply no way to get that information quickly. Depending on your bookkeeping system, you may not be able to get it at all.

QuickBooks Online has more than one solution for this problem. You see the first one every time you log in. The Dashboard contains a graphic in the upper left corner that tells you how many invoices are overdue and unpaid. Click on the colored bar labeled OVERDUE, and you’ll see a list of invoices with the unpaid ones right at the top.

You can tell at a glance how much of your money is tied up in unpaid invoices.

While this is important information for you to have as you start your workday, it doesn’t tell the whole story. To get that, you’ll need to access some of QuickBooks Online’s reports – five of them in particular. Click Reports in the left vertical pane, and then scroll down to the heading labeled Who owes you.

These reports are listed in two columns. Each has the outline of a star next to it. Click on the star, and the report will be added to the Favorites list at the top of the page. Click on the three vertical dots next to it, and you’ll be able to Customize the report. And as you hover over the title, you’ll see a small, circled question mark. Click on this to get a brief description of the report.

There are several reports in this list that can provide insight into where your outstanding revenue is. We recommend you run five of them at least once a week – more frequently if your business sells large quantities of products and/or services. The suggested are:

Accounts receivable aging detail

This report provides a list of invoices that are overdue, along with aging information. There are several columns in the report, but you’ll want to pay special attention to the last one: OPEN BALANCE.

Tip: If you have many customers or simply a high volume of unpaid invoices, you might consider running the Accounts receivable aging summary instead.

Changing the Content

Before you run the report, you should explore the customization tools provided for it. They won’t be the same for every report, but you can start to get an idea of what can be done. Hover over the report title and click Customize. A panel like the one pictured below will slide out of the right side of the screen.

QuickBooks Online provides deep customization tools for reports.

You can see some of your customization options in the image above. Beyond these, you can also work with filters and headers/footers. When you’re satisfied with your changes, click Run report.

If you want to run a report with its default settings, just click on the report title in the list to display it.  You’ll have access to limited customization from there.

Four other reports you should be generating regularly are:

• Customer Balance Summary: Shows you how much each customer owes your business
• Open Invoices: Lists invoices for which there has been no payment
• Unbilled Charges: Just what it sounds like: tells you who hasn’t been invoiced yet for billable charges
• Unbilled Time: Lists all billable time not yet invoiced

We don’t expect you’ll have any trouble understanding reports like these; they’re fairly self-explanatory. QuickBooks Online offers many other reports, the standard financial reports that need to be generated monthly or quarterly, like Balance Sheet, Profit and Loss, and Statement of Cash Flows. You’ll absolutely need these should you apply for a loan or need to supply in-depth financials for any other reason. We can help you analyze them to get a comprehensive, detailed picture of your company’s fiscal health.