Tag Archives: QuickBooks Online

Customer Statements: When, Why, and How

 If your business relies on invoices to get paid, there may be times when you need to create and send customer statements.

When you send an invoice, you enter into an informal contract with a customer. You expect that you will receive payment in a timely fashion for goods or services you’ve sold.

That probably works most of the time. But what happens when it doesn’t, when you’ve sent a reminder and are still waiting? And what do you do when a customer orders frequently, and is confused about what’s been paid and what hasn’t?

If you’re using QuickBooks Online, you can easily send a statement, a list of sales transactions, credits, and payments. There are three kinds of statements:

  • Balance Forward. This document emphasizes what’s currently owed by displaying it at the top. Below that is a list of sales transactions that occurred between two dates that you specify.
  • Open Item. You select a date, and the statement shows all transactions that were completed before it.
  • Transaction Statement. There’s no total balance here, just the amounts billed and received for every transaction.

 

Setting Up Statements

Balance Forward statements cover a period of transactions that you define.

There are three way to create statements. You can:

  • Click the Plus (+) icon at the top of the screen.
  • Dispatch one while you’re in a customer record.
  • Launch a batch action from the Customer

Before you create your first statement, though, make sure QuickBooks Online is set up the way you want it to be. Click the gear icon in the upper right of the screen and select Your Company  Account and Settings. Select the Sales tab and scroll down to Statements. Click Statements to open the options there.

You can List each transaction as a single line or List each transaction including all detail lines. Click the button in front of the one you prefer. If you want to Show aging table at bottom of statement, click in the box. This will show customers how many days each transaction is overdue.

Click Save when you’re done.

 

Creating Statements

 If you’ve already started entering transactions so there’s some data in QuickBooks Online, click the Plus (+) icon in the upper right corner of the screen.

Tip: If you don’t see the plus (+) icon, you’re in an active screen. Click the X in the upper right to close it, saving it first if necessary.

Click Statement, which is located under Other on the far right. Under Statement Type, select Balance Forward. Below that is the Customer Balance Status field. Do you want to see customers with open balances, those who have overdue invoices, or all customers? The third option will include credit memos.

Select a Start Date and End Date. In this example, these were 04/09/2018 and 09/09/2018, and the statement date was 09/10/2018.  Click Apply. QuickBooks Online will display a list of matching customers. Click Print or Preview at the bottom of the screen to see your statements.

In this preview, the customer’s balance forward on 04/09/2018 was $8,245.05. A catch-up payment was made on 08/09/2018 and another invoice sent on 09/01/2018, which accounts for the TOTAL DUE at the top.

From this screen, you can either Print the statements or Close to go back to the previous page, where you can Save and Send.

 

Two Other Options

As we stated earlier, there are two other ways to create statements. Click Sales in the left vertical toolbar and highlight the Customers tab by clicking on it. Hover your cursor over a customer and click the down arrow at the very end of that line. From the list that opens, select Create statement.

You can also hand-pick multiple customers to receive statements. With the Customers window open, click in the box in front of your choices, and then click the down arrow next to Batch actions at the top of the list. Select Create statements.

Creating statements in QuickBooks is fairly simple, but you don’t want to send an inaccurate one to a customer. Make sure your transactions are up to date before you generate any customer statements, and choose your date ranges carefully. As always, we at Squire are available to help with this task – or any other area of QuickBooks Online that might be confusing to you. We’re here to help you be proactive to avoid problems in the long run. Contact one of our certified Quickbooks ProAdvisors at (801) 225-6900.

Are You Using QuickBooks Online’s Mobile App?

Even if you don’t travel for work (but especially if you do), you should explore what QuickBooks Online’s mobile app has to offer.

You already know how convenient it is to be able to access your company’s financial data from any desktop or laptop computer that has an internet connection. Still, there are times when you’d like to be able to complete some of your accounting tasks without firing up a full-blown browser and logging on to QuickBooks Online.

If you haven’t yet tried out the site’s companion mobile app, you might be surprised at how much you can actually accomplish on your smartphone. Take a look at the app’s main menu (with a partial view of the Activity screen to the right):

You can’t do everything on QuickBooks Online’s smartphone app that you can do in the browser-based version, but there’s a surprising amount of functionality here.

 

Once you’ve downloaded the app and signed in with your QuickBooks Online user name and password, you’ll see a home page divided into two vertical sections; you can toggle back and forth between them. One is your Dashboard, which displays current account balances and a graph showing an abbreviated version of your Profit and Loss report, as well as a graphical summary of paid and unpaid invoices. Click on Activity to see a list of your most recent actions and transactions.

Click on the three horizontal lines in the upper left of the screen, and the app’s main menu slides out. As pictured in the image above, this interactive list also serves as the app’s primary navigation tool. Any data that you’ve entered in the browser-based version (as well as anything you add here) will appear in list form when you click on an entry here. To add customers, invoices, sales receipts, etc., click on the + (plus) sign. You can also enter new transactions from each individual list screen.

Adding Transactions

If you’ve worked with mobile apps at all, you know that the user interface is different from what you see in full versions of applications accessed through a browser. QuickBooks Online’s app, though, is exceptionally easy to understand and use – perhaps even easier than the browser-based QBO.

Take the app’s New Expense screen, for example. At the top of the page is a camera icon. Click it to take a picture of a receipt. You can also enter the total manually in a field to the right. Below that are three buttons representing Credit, Check, and Other, so you can indicate how you paid for the purchase.

You’ll describe the expense by clicking on links that contain labels like:

  • Who did you pay?
  • What kind of expense is this?
  • Who was it for?

When you click on one, the app opens your list of related data. So, Who did you pay? opens your list of Payees. You can select one or add a new one. Click on the Billable button if the expense can be charged to a customer, and click Add a Split if you need to separate some of the items. There’s also room to add a Ref # and Memo. When you’re done, click Save to add it to your main QuickBooks Online file.

Viewing Existing Information

Besides entering data in the QuickBooks Online app, you can look up existing information.

 

You can just as easily find records and transactions you’ve entered either in the browser-based version of QuickBooks Online or on the app. You can follow the journey of an invoice as pictured in the screen shot above. QBO even prompts you to complete steps you haven’t taken. Click on the pencil icon in the upper right, and you can edit the data that appears on that screen.

Warning! Editing transactions that have been processed is risky. If you’re making errors that need correcting, we can help you determine when this is safe.

The QuickBooks Online app can also provide quick overviews of customer activity, with links to actions.

 

You may never need to access your QuickBooks Online data remotely on your smartphone. If you do, though, we can help you get set up with the site’s companion app so you’ll learn how they work together.

Recording Simple Expenses in QuickBooks Online

Tracking even the little expenses is important.

How does most of the money you owe individuals and companies get disbursed? Do you print checks, or write them by hand? Use credit cards? Pay online through your bank’s website?

Keeping track of your outgoing funds can be challenging, since there are so many ways to complete those transactions. But it’s important that all expenses are recorded correctly and consistently, to keep your company file accurate. In addition, so many of your expenses are tax- deductible. You don’t want to miss any of them.

But when do you enter and pay bills using QuickBooks Online bill-paying screens? In what situations would you use a purchase order? Why would you record a purchase on the dedicated expense screen? These are all questions we can answer for you. If you’re new to QuickBooks Online or simply puzzled by your options here, we’d be happy to schedule some time to go over these purchase issues.

Setting Up the Site

QBO 0617-1 photo QBO 0617 image 1_zpsrxhzm4wy.jpg

How you set up these preferences depends on your company’s individual structure and needs. We can help you determine the answers that are right for you.

Before you start recording expenses, you’ll need to make sure that your site settings match what you need. Click on the gear icon in the upper right, then Your Company |Account and Settings| Expenses to see what we mean. Most of these options will turn columns on the Expense screen off or on (though you can change them for individual transactions). As for the Track billable expenses and items as income preference, that’s something we can discuss when we go over this topic.

Billable or Not?

Let’s say you need to buy some landscaping tools for your business that you’ll use with multiple customers. One of your customers has asked you to purchase some additional tools for her own use. This is how you could record your purchases on that trip. You’d click the + sign in the upper right, then select Expense. Click the down arrow in the payee field and select the name of the store (or add it if it’s not there by clicking + Add new).

In the field to the right, you’ll select the source of the money you’ll be paying. Choose the name of the Checking account from the drop-down list.

Note: Even if you’re using a credit card for this purchase, the money will ultimately come out of your checking account. So be sure to choose the correct option here.

Make sure the date is correct, and choose the Payment method that you’re using to complete the purchase at the store.

QBO 0617-2 photo QBO 0617 image 2_zpsio4nvrdr.jpg

This is the portion of the Expense screen where you’ll enter the actual details of your purchase

Click in the field under ACCOUNT to display a list of categories and click the correct one. In the DESCRIPTION field, enter descriptive text about the item – enough that it will be recognizable when you see it later. Type in the AMOUNT of the item. Since you’re buying these tools for company use, you can’t bill them to an individual customer. Click in the TAX field if necessary.

However, you’re buying the second item for a specific customer. You’ll click in the BILLABLE field to create a checkmark and add your company’s MARKUP PERCENTAGE in that field. Open the drop-down list in the CUSTOMER column and select the correct one. Choose a CLASS if you use them and save the transaction.

When you look at that customer’s transaction list, you’ll see an entry for a Billable Expense Charge. You can click Start invoice if you want to bill for this one item. If not, you’ll see this charge in the vertical column to the right the next time you create an invoice for that customer.

Mobile Expenses

QuickBooks Online has a companion mobile app that lets you—among other things—track expenses when you’re away from your computer.

As you can see in the image above, you’ll be able to enter the details of your expenses manually. Click on the camera icon in the upper left, and you can take a picture of a receipt and attach it to the transaction. The next time you log into QuickBooks Online, you’ll see the expense with the photo file attached.

QuickBooks Online can simplify the entry and tracking of expense data, but as we said, it’s important to enter purchases in the right places – and to categorize them correctly. We’re ready to work with you on expenses when you are.

QBO 0617-3 photo QBO 0617 image 3_zps5lqws8so.jpg

QuickBooks Online mobile app

Getting to Know QuickBooks Online Reports

They’re one of the rewards you get for your conscientious accounting work: reports. Are you using them to make better business decisions?

What do you see when you log on to QuickBooks Online? Your most important business numbers represented by real-time charts. Profit and loss. Income and expenses. Sales. And all of your account balances.

This is a great way to start your workday. You know where you stand financially, and you know what areas of your company file need attention, fast.

But QuickBooks Online’s home page only tells part of the story. You also need more in-depth, customizable reports. In the short term, reports help you further determine any necessary accounting work. Long-term, they’ll provide insight to help you make smarter decisions as you plan for your company’s future.

Critical Overviews

Creating reports in QuickBooks Online is easy. Customizing them is a bit harder. And analyzing them, depending on their complexity, can be more of a challenge.

We’ll start with some of the simplest, most important ones: Accounts Receivable. Where do you stand with customer payments? Who isn’t paying on time? How much is outstanding? To find them, click Reports in the toolbar pane. Click All Reports (over to the right, near the top), and then Manage Accounts Receivable. The list of related reports will open.

 photo QBO 0517 image 1_zpslyfisij7.jpg

QuickBooks Online displays descriptions of each A/R report and links to the Run and Customize functions in its directory.

Click the Customize button under Open Invoices. The customization options will appear on the pane to the right of the screen. You can modify:

  • The Report period, Number format, and the appearance of Negative numbers
  • Columns (Transaction Type, Due Date, Open Balance, etc.)
  • Aging method (Current or Report Date)
  • Filter (Customer, Territory, Sales rep, etc.)
  • Header/footer (Show logo, Report title, Date prepared, Alignment, etc.)

QuickBooks Online comes with commonly used options already selected. Changing them helps you zero in on the precise cross-section of data you want to see.

 photo QBO 0517 image 2_zpszyoobvr3.jpg

This is a partial list of the Column options in QuickBooks Online. You can also customize in multiple other ways.

When you’ve finished making changes, click Run report to see it displayed with your own data.

If you’d like to save that report (including the modifications you just made), click Save customization in the upper right corner of the screen. In the window that opens, create a new name for the report that you’ll recognize, and enter it in the Custom report name field.

Want to build a group of related custom reports? Click Add this report to a group and type its name into the New group name field. Click Add. That report will now appear in the list of reports you’ve created when you click the down arrow in the field below Add this report to a group.

Would you like to share the custom report with other QuickBooks Online users? Click the down arrow in the field under Share with, and select All or None. When you’re done here, click Save. You can click the icons in the upper right to email the report, print it, or export it to Excel or PDF format.

Reports in other categories—like Review Sales, Business Overview, and Review Expenses and Purchases—work similarly.

Note: There’s one category named Accountant Reports. If you’re very familiar with double-entry accounting, you might attempt to run and analyze these yourself. Most likely, you’ll need some help with these critical financial reports that should be created periodically. We’d be happy to assist with this.

 photo QBO 0517 image 3_zpsgunukvps.jpg

The Reports page toolbar

Saving Time

You can always go to the All Reports screen and drill down to the report you want to see. QuickBooks Online provides a better, faster way to access many of them. The toolbar pictured above appears when you’re browsing through lists of reports. Click Recommended to see what QuickBooks Online deems the most important data for you to see regularly.

Once you’ve started working with reports, the ones you access most often will appear when you click Frequently Run. Those reports that you modified and saved will be listed under My Custom Reports. Management Reports are geared toward company managers, of course.

We encourage you to familiarize yourself with QuickBooks Online’s reports and modification options. And as we said, we’re on hand to run and analyze the site’s more complex report options on a regular basis, or when you have a specific need, like when you apply for financing. Together, we can get the information you need to complete your daily work and do more long-term planning.

Need to Set Up Users in QuickBooks Online?

Your employees probably don’t need access to every corner of QuickBooks Online. Here’s how to set limits.

One of the best attributes of QuickBooks Online is that multiple users can access it without having software installed on their PCs. No more paying up front for a boxed copy that you’ll store on your hard drive. You just pay a monthly subscription fee.

Unless you assign specific access rights to your users, though, they’ll be able to see and do everything that you see and do on the site. You undoubtedly trust your employees or you wouldn’t have hired them, but it’s just good business practice to restrict individuals to their specific work areas. You probably did the same thing if you ever ran a manual accounting system.

QuickBooks Online makes this easy. Once you’ve set up individuals for a specific set of screen permissions, that’s all they’ll see when they log in with their user names and passwords. Here’s how it works.

Several Levels

Click the gear icon in the upper right of the QuickBooks Online screen, then select Manage Users under Your Company, then click New. This mini-interview will open.

 photo QBO 0417 image 1_zpsei9u3lqq.jpg

QuickBooks Online’s mini-interview will walk you through the steps required to assign access rights to employees.

As you can see, four access levels are supported. You’ll probably select Regular or custom user most often because you can drill down and set permissions at the screen level. The Company administrator is you, of course, unless you’ve assigned this role to someone else. The user at this level has access to everything.

You can also let someone see Reports only, with the exception of payroll reports and those that contain contact information about customers, vendors, and employees. If you have employees who submit time sheets but don’t otherwise work in QuickBooks Online, you can let them in to do Time Tracking only.

Tip: There’s a fifth option here. You can grant us access to your QuickBooks Online company data, making it easier for us to monitor and troubleshoot your accounting information. Let us know if you want to take advantage of this.

Paring Down Access

Click the button in front of Regular or custom user if it’s not already highlighted, and then click Next. This third screen in the mini-interview deals with Customers and Sales and Vendors and Purchases Access Rights. Click All or None if appropriate.

 photo QBO 0417 image 2_zps3hfipesf.jpg

This screen in the mini-interview helps you restrict user access in Sales and Purchase areas.

If you’re allowing Limited access in these two areas, be sure to read the fine print explaining what is and isn’t allowed. When you’re satisfied with your selection, click Next. On the next screen, you’ll set administrative rights for that user by indicating whether he or she can manage other users’ access rights and work with your subscription status and other company information.

You’ll supply the individual’s email address and name on the following screen. This will be used to send an email inviting the user to sign in using an existing Intuit Business Services user name or one he or she creates. Click through the next screen and click Finish when you’re done. The mini-interview will close, and you’ll be back at the Manage Users page.

Your User Overview

The Manage Users page displays a list of all users who have been invited or are active.

 photo QBO 0417 image 3_zpswddevkaz.jpg

The Manage Users screen

The table here lists all users’ names, email addresses, access rights, billable standing, and status. If you haven’t received a response to an invitation (Invited), you can click the Resend button to issue another email. When he or she responds, Invited changes to Active. Click on a row to highlight an individual, and you can Edit or Delete him or her, and see an audit log of Activity.

You or your appointed Master Administrator should set up access rights before any new employee is admitted to QuickBooks Online. Let us know if you’re having trouble with this element of the site, and if you’d like us to join your list of active users. It’s a lot easier for you and us if we can get in there and see what problems you’re having — and resolve them.

Your First Hour with QuickBooks Online

Whether you’re just launching a business or you’re going online with an existing company, take some time to get acquainted with QuickBooks Online.

Your first hour with any web-based application is probably spent exploring and clicking buttons, links, and other navigation tools to get the lay of the land.

QuickBooks Online should be no different. In fact, it’s even more important to take it slow when you’re using an accounting solution. If you start entering data without understanding how everything works together, you may make mistakes early on that will be difficult to undo down the road.

Simple Setup

If you’re not absolutely certain you’re going to stick with QuickBooks Online, you can sign up for a 30-day free trial (no credit card required). You’ll first create an account by entering a user name, password, etc., then be asked a few simple questions about your business and the features you plan to use (invoicing, inventory, bills, etc.).

If you have data in a desktop QuickBooks file, you can start the import process here, but we strongly recommend that you let us help with setup if you’re planning to do this.

 photo QBO 0317 image 1_zps9z79yswh.jpg

Once you start entering data, your QuickBooks Online Dashboard will give you an overview of your finances.

When you’ve completed your account setup, the main QuickBooks Online screen opens. You’ll see your Dashboard, a collection of data and charts that provides critical information like your bank balances, your outstanding invoices, and your current profit and loss.

You’ll eventually be using the vertical pane on the left for navigation. But you don’t need to click the links there yet – you have other setup tasks to do first.

Specifying Options

If you’ve used a desktop version of QuickBooks, you know about its many menus and its Preferences window. QuickBooks Online uses a different convention for choosing options and entering the information that will serve as the backbone for your company file. To get there, click the small gear icon in the upper right corner.

Tip: There are two other links next to the gear icon. You’ll be able to search for transactions by clicking the magnifying glass link. The plus (+) sign opens a window with links to screens where you can create transactions and initiate other activities.

 photo QBO 0317 image 2_zpsusmjela5.jpg

You’ll spend a lot of time working with the links in the Your Company window when you’re setting up QuickBooks Online. You can always refer back to it later on.

As you can see, you have access to a lot of data and activity in the Your Company window. You don’t have to go through absolutely every link before you start using QuickBooks Online, but two you should look at early are Account and Settings and Manage Users.

The Account and Settings page is divided into multiple areas that you can access from a navigation bar on the left. They include:

  • Company. Fill in contact details and upload your company logo for use on sales forms.
  • Sales. Customize sales form content (preferred terms, custom fields, discount field, etc.). Would you like to turn on inventory tracking?
  • Expenses. Do you use purchase orders? Track expenses and items by customer? Make expenses and items billable?
  • Payments. Do you want to subscribe to QuickBooks Payments so you can accept credit cards and/or bank payments through QuickBooks Online?
  • Advanced. You’ll have numerous decisions to make here. For example, what tax form will you use? Will you want to automate some activities, like applying bill payments? Do you need to support multiple currencies?
 photo QBO 0317 image 3_zpsayqecdmz.jpg

The Advanced page of QuickBooks Online’s Account and Settings presents you with numerous options. You may want our help with this.

Multi-User Access

Will more than one person at your company be using QuickBooks Online? If so, you’ll most likely want to specify what areas they’re allowed to visit and what activities they can do. Click the gear icon in the upper right and then select Manage Users. QuickBooks Online displays a mini-interview in a window here that walks you through the process of assigning access rights to individuals (Custom User, Time Tracking Only, etc.).

We’ve probably taken up more than your first hour by now, but we wanted to stress the importance of thoroughly setting up QuickBooks Online before you start entering contact records and creating transactions. If this is your first experience with an accounting application, we highly recommend that you engage us in your first hours of using QuickBooks Online. We can come in at any time and troubleshoot problems, but it’ll be more economical and less time-consuming if we work with you from the start.

Using Custom Fields and Classes in QuickBooks Online

QBO’s tools are generic enough that myriad businesses can use it. But custom fields and classes help you shape it to meet your specific needs.

Small business accounting is not a one-size-fits-all proposition. Your company is unique in that sense; you have your own customers and products, vendors and services. Your requirements for your accounting application—what it must do and how it does that—is unlike anyone else’s.

QuickBooks Online contains a standard set of features that can accommodate a broad cross-section of the millions of small businesses in the U.S. It also offers customization options that you can use to make it your own. Two of these are custom fields and classes.

Start from the Beginning with Custom Fields

You can start working with custom fields and classes at any time. They’re most effective, though, when you build them in as you’re just starting to use QuickBooks Online.

Let’s look at custom fields first. When we refer to “fields,” we simply mean the rectangular boxes in records and forms that either already contain data or that can be filled in by you, either by entering the correct word or phrase, or by selecting from drop-down lists. Most of these are already named. On an invoice, for example, there are fields for information like Invoice date and Due date.

But you can add up to three additional fields to sales forms. To do so, click the gear icon in the upper right corner of the screen and select Account and Settings, then click Sales in the vertical navigation bar on the left. The second block here contains Sales form content. Click Custom fields, and you’ll see something like this:

 photo QBO 0217 image 1_zpsvbxwssdq.jpg

You can define up to three custom fields on sales forms and make them visible internally and/or to your customers.

Click the word Off if it appears, and it will change to On and display three blank fields. Think carefully about what you would like to appear here, as this isn’t something you’ll want to change. If you haven’t yet met with us about how to set up QuickBooks Online, let’s schedule some sessions to go over all your setup procedures, including custom fields.

Enter the words or phrases you want displayed on sales forms in the three fields. Then decide whether you want them to be visible only to you and your accounting staff or to your customers, too. Click within the Internal and Public to create checkmarks. When you’re done, click Save.

Additional Categorization with Classes

QuickBooks Online’s classes provide another way to categorize transactions. You can use them to differentiate between, for example, departments or divisions. If you’re a construction company, you might have different classes for New Construction and Remodel. Unlike custom fields, you’re not limited to three classes.

You can filter many reports by class. QuickBooks Online contains report templates designed specifically for reporting by class, like Sales by Class Detail, Purchases by Class Detail, and Profit and Loss by Class.

Here’s how you create your own list. Click the gear icon in the upper right of the screen and select Account and Settings. Then click Advanced in the left vertical navigation toolbar. Under the fourth heading, Categories, you’ll see Track classes. If the word “Off” appears to the right, click in the box to turn this feature on. A box like this will appear:

 photo QBO 0217 image 2_zpstastuosl.jpg

Class-tracking in QuickBooks Online helps you create more targeted reports.

Even if you’ve defined a number of classes, they’re not required on transactions. If you want to be reminded should you forget to classify one, click in the box in front of Warn me when a transaction isn’t assigned a class. You can also choose to assign one class to an entire transaction or to each individual row. Click the arrow to the right of One to entire transaction to drop the option box down and make your choice. When you’re done, click Save.

You can create classes as you’re entering transactions by clicking the arrow next to Class over to the right of the screen and selecting +Add new. We recommend, though, that you think this through ahead of time and make at least an initial list by clicking the gear icon in the upper right and choosing All Lists, then Classes, then New.

Great Flexibility

These are two of the customization tools that are built into QuickBooks Online. Whether you’re just getting started or you’ve been using the site for a while, we can introduce you to all the ways that you can make QuickBooks Online your own.

5 QuickBooks Online Add-On Apps You May Need in 2017

Not finding quite everything you need in QuickBooks Online? Here are some handy add-on apps available.

QuickBooks Online may work for you just fine as is. After all, it was designed to meet the needs of the millions of small businesses that want to manage and track their income and expenses, create records and transactions, and run reports to gauge their financial health.

QuickBooks Online was also designed to grow along with your business. But there’s no need for Intuit to add internal features to do so. In fact, that would make it too expensive and unwieldy for many companies.

Instead, Intuit has partnered with other small business websites to provides add-ons—applications that extend the usefulness of QuickBooks Online in one or more areas, like accounts receivable and payable, inventory, and expense-tracking. They integrate easily to share data and do the extra work you need. Here are some of them to consider.

Bill.com

 photo QBO 1216 image 1_zpsi3ad4itu.jpg

Bill.com automates your accounts receivable and payable processes. It supports electronic billing and payment, as well as multiple approval levels.

You can certainly enter and pay bills using QuickBooks Online. And you can send invoices to customers and receive payments. But adding a connection to Bill.com gives you more advanced options for accounts receivable and payable. Simply send your bills to Bill.com by scanning, emailing, faxing, or taking a picture with your smartphone. The site’s automation tools turn them into digital records and route them through your specified approvers. Once approved, they’re paid electronically or by paper check. Invoices are just as easy to process; customers can pay by using PayPal, credit card, or ACH. Bill.com’s mobile app makes it possible to keep up with invoices and bills while you’re out of the office.

Expensify

Are your employees still paper-clipping receipts to handwritten expense reports? This method is unnecessarily time-consuming – and often inaccurate. Expensify solves both problems. Your staff can take photos of receipts with their smartphones. Expensify then converts the expense information into coded digital records and submits them for approval based on your company’s policies. Credit card purchases can be automatically imported, too. All data is synchronized with QuickBooks Online in real-time and coded to reflect your preference of QBO’s expense accounts, customers/jobs, etc. Once you’ve approved a report, you can have the money deposited in the employee’s bank account the next day.

TSheets Time Tracking

TSheets employee scheduling software automates tasks that QuickBooks Online doesn’t do: scheduling and remote time-tracking for your hourly employees. Your staff no longer has to fill in paper timesheets. Instead, they can use their smartphones to track their hours and GPS location points. And while Excel is certainly better for creating schedules than paper, TSheets takes over that task, too. After you’ve approved timesheets, that information is sent over to QuickBooks, ready for use in your payroll processing.

 photo QBO 1216 image 2_zpsroqo5qwy.jpg

Your employees can easily “punch” in and out using their smartphones. TSheets also uses GPS technology so that your staff members’ locations are always known to you.

SOS Inventory

QuickBooks Online performs some basic inventory management tasks. You can create records for items and use them in transactions, and keep track of the number of items in stock so you know when to reorder (or have a sale). SOS Inventory goes well beyond those capabilities. You can create sales orders, track cost history and serial numbers, and document work-in-progress (WIP). SOS Inventory supports multiple locations and the entire pick/pack/ship process.

Insightly CRM

You can create thorough customer records in QuickBooks Online and document some of your interaction. But it doesn’t facilitate true Customer Relationship Management (CRM) nor project management. Insightly CRM does both. It lets you build exceptionally thorough customer profiles so that you can view social streams, email history, and any events, opportunities, or events related to them. Its project management features include the ability to track by pipelines or milestones, define contact roles and custom fields, and generate advanced project reporting.

QuickBooks Online Integration Key

All of these apps can work in standalone settings, but their integration with QuickBooks Online and their mobile capabilities create powerful partnerships that help you serve both your customers and your employees in ways that QuickBooks Online alone can’t.

We’re not trying to sell you applications here. Our concern is that you’re getting as much out of QuickBooks itself as you can. We can steer you toward add-on solutions if that seems necessary, but we’re always happy to work with you on getting to know QuickBooks Online better and matching its capabilities to your company’s needs.

 

Customizing QuickBooks Online Forms

Make a good impression on your customers by sending them well-designed sales forms. QuickBooks Online helps you create them.

Your company’s “brand” can be composed of many things (and has many definitions), but it’s really about what pops into your customers’ minds when they think of you. Key components include your logo, your color scheme, and any other identifying visual element that people associate with your business.

A good way to reinforce this image is by making sure that a unifying graphic theme runs through every piece of print or web-based customer content you create, like your website, brochures, blog, and ebooks. Your brand should also be visible on all sales forms you dispatch, like invoices and receipts.

QuickBooks Online comes with its own default sales form style; this is the layout and content that will automatically display when you start a new transaction. You can easily change this and have it apply to all transactions.

 photo QBO 1016 image 1_zpsbsuqvatw.jpg

Your logo is an important element of your company’s brand. QuickBooks Online lets you include it on sales forms.

Here’s how it works. Click on the gear icon in the upper right of the screen, next to your company name. Select Custom Form Styles to open the table of existing styles. There should be one labeled Standard, though there may be another labeled Classic. You can make either the default by clicking Make Default or Remove as default using the down arrows and links under ACTION at the far right of each row.

Click the Edit link for the default style. This screen contains many of QuickBooks Online’s customization tools. The Style tab in the left vertical toolbar is automatically highlighted. In the column to its right, click through the five design options available and leave the desired one selected. Then click the plus (+) sign in the upper right of the screen. Browse for your logo file when the directory opens and double-click on it to add it to the top of your sales forms. Choose the color scheme you want by clicking in the correct box displayed below.

When you’re done there, click on the Appearance tab to specify your logo’s placement and change any other settings.

Content Critical

 photo QBO 1016 image 2_zpsw5rghapb.jpg

You can decide which fields should and shouldn’t appear on your sales forms by checking and unchecking boxes.

You won’t necessarily need to make every data field available on your sales forms. But you want to include every field you might possibly need without displaying extraneous content areas. QuickBooks Online lets you turn fields on and off and change their labels easily by checking and unchecking boxes.

Click the Header tab on the left to start this process. Among your options here are:

  • Form names. Do you want invoices to say “Invoice,” for example? Do you want to use form numbers and allow custom transaction numbers?
  • How much of your company’s contact information should appear?
  • Do you want fields for Terms, Due date, etc?
  • Do you need to define custom fields?

You’ll see more options when you click on the Activity Table tab in the left vertical pane (see image above). Not only can you choose what content appears and how its labels read, but you can also indicate what percentage of that line each entry should occupy. Under WIDTH%, click on the plus (+) and minus (-) buttons to the right of each number to size it (your numbers, of course, should total 100).

Warning: Many of the decisions you have to make when customizing sales forms are simple. Others take some consideration, like custom fields and the handling of billable time. We can help you with these.

Click on the final tab in the left navigation pane, Footer, to add or edit text that should be displayed at the bottom of your sales forms. Click Save in the lower right when you’re done.

 photo QBO 1016 image 3_zps858vk66i.jpg

Some settings may need to be tweaked in Account and Settings.

Note: As you’re browsing through the content options available as described above, you may find that a field appears to be missing or needs a default setting changed. If this occurs, click on the gear icon in the upper right of the main screen, then on Your Company | Account and Settings. Click on the Sales tab in the left vertical pane to get to Sales form content.

Consistent, well-designed sales forms will help promote your brand and present a polished, professional image to your customers.

Introducing QuickBooks 2017

QuickBooks 2017 Introduction

QuickBooks 2017 was built with power users in mind.  These are users that spend hours everyday in QuickBooks Desktop and do certain tasks repeatedly.  These tasks include:

  • Creating and sending reports
  • looking up customer and vendor information
  • Dealing with bills and checks especially in Multi-User Mode
  • Coordinate working with multiple users in the same company file

QuickBooks 2017 is intended to help these customers in several  ways

  • Find information quickly with better search functionality
  • Up-leveling information within QuickBooks so it is easier to discover
  • Making reporting easier with enhanced reporting features
  • Improving the multi-user experience and requiring less switching to single-user mode

What’s New and Updated in QuickBooks 2017

  • Schedule reports
  • Find information quickly
  • Report customization improvements
  • Up-levelling information
  • Improved security
  • Compliant under the payment,
    payroll & taxation laws
  • Recurring payment improvements
  • Multi-User improvements
  • Enterprise quality improvements

Schedule Reports

  • Automate sending of reports via email

Find information quickly

  • Search as you type
  • In between amount search
  • Vendor/customer type

Reports Customization improvements

  • Show filters on reports
  • Enhanced selection of filter values

Up-levelling information

  • Remind users of un-deposited funds
  • Showing company file name in deposit summary
  • Cleared flag on CC charges

Miscellaneous

  • Show the deleted user in audit trail report
  • Copy Line/Paste Line in timesheets

High Resolution support

  • Make QB comfortable and delightful on higher resolution comp

Keeping Financial Data Safe and Secure

  • Improved Security ( Reinforced security features that were released for the previous versions, will also be available in QB2017.
  • QBDT Point of Sale EMV Compliance
  • IE11 will not be supported in QuickBooks 2017 (Only the most current version of Internet Explorer available for a supported operating system will receive technical support and security updates from MS since Beginning January 12, 2016
  • Multi-factor Authentication updates
  • Support .NET 4.6
  • Flash discontinued
  • Eliminated older OS (Vista, Windows Server 2003 and Windows Server 2011 which were not compatible with latest security standards).
  • Compliant under the payment, payroll & taxation laws

Keeping QuickBooks Stable and Bug Free

  • Recurring payment improvements
  • Multi-User improvements
  • Enterprise Quality Improvements
  • IDS Sunset

Specific QuickBooks 2017 Improvements

Multi-User Experience

A QuickBooks 2017 makes it easier than ever to work with multiple users. There are now fewer instances that require users to switch between Multi-User and Single-User mode. It also has a built in communication tool to make switching modes easier.  When you do need to switch modes, switching takes much less time.

Smart Search

Save time with faster searching.  Begin typing a name and QuickBooks automatically fills in the rest.  Memorizing account numbers can be a pain.  Now you won’t need to search the full chart of accounts to find that one client or memorize the exact name of every account or item.  Also, you can now search between values to find a transaction without having to remember the exact amount.

Report Filters

Now one click is all it takes to see which filters have been applied to a report.  Visible filters make it easy to reproduce memorized reports.  The new filter tool also provides you with an easy way to quickly toggle back and forth between reports.

Undeposited Funds Reminder

Clearly see what deposits require action. A new badge displays the number of pending deposits to be recorded.  Bringing this information to your home screen will help you avoid overstating income or making duplicate entries due to unrecorded deposits.

Deleted User Name Appear in Audit Trail

Track transactions by deleted users with better accuracy; show the name of the deleted user in the audit trail.  Now you can purge old employees from your company file without losing their transaction history.

Vendor and Customer Type Filter

QuickBooks now provides two more new filters in custom search – Customer Type/Vendor Type.  These filters will help you find the information you need faster and give you a new way to group and keep track of customers and vendors.

Cleared Flag on Credit Card Charges

QuickBooks Added a cleared flag to credit card charges to Easily see if a credit card charge is reconciled

Show Company File Name on Deposit Summaries

Print Company name on Deposit summary in consistent to other QuickBooks reports. Quickly see which company’s deposit summary you are looking at with the ability to print your company name on deposit summaries.

Copy & Paste in Time Sheets

Provide a menu item “Copy Line” to select the line and paste it into the another line. Save time when entering time sheet information by copying and pasting data from one line to the next

Automated Reports in Single User Mode

Save valuable time by having QuickBooks create and send reports to your team regularly.

QuickBooks Online

The ideal group for QuickBooks 2017 are customers who are on an older version of QuickBooks 2017 and looking to upgrade to a newer desktop software.  However, many customers – both new prospects and existing QBDT users – may actually be a better fit for QuickBooks Online. The benefits of QBO include:

  • Work from anywhere
  • Send invoices, receive payments, and run payroll right from your phone.
  • Capture receipts with your phone and attach them to QuickBooks transactions.
  • Your accountant can access your books remotely to answer questions, fix problems, and get you ready for tax time.
  • QuickBooks online does more work automatically
  • QuickBooks Online automatically downloads and categorizes bank and credit card  transactions.
  • Include a button in email invoices that allows your customers to pay you online with one click.
  • Customers may not be right for QBO if they need job costing, need progress invoicing, require customization for reports, invoices, and checks, or need multiple companies on one account.

Can’t Keep Up with Bills? QuickBooks Online Can Help

There are more pleasant accounting tasks than paying bills, but QuickBooks Online organizes and simplifies this critical chore.

How does your company keep track of its bills now? If you’re like a lot of small businesses, you’re still dealing with a lot of paper. You may have a paper or electronic calendar where you enter all of the due dates as bills come in. When you see one approaching, you either take out your checkbook or schedule an online payment. Then you store all of your paid paper bills in file folders in case you have to look back at them.

It’s probably pretty clear to you that this isn’t the best system. You occasionally miss payments because a bill was lost in transit or for some other reason didn’t make its way to you. Or you were out of the office for a few days and didn’t look back on deadlines you missed.

QuickBooks Online can help keep bill-payment running smoothly and your relationships with vendors on the up-and-up.

Two-Step Process

Before you can start paying bills, you have to enter them into QuickBooks Online. This will entail a bit of extra work the first time you deal with a particular vendor, but there are numerous benefits to handling your accounts payable in this fashion, like:

  • Speed. Once you’ve created a framework (template) for a bill, it will take minimal time to pay it in the future.
  • Documentation. All of your bill payments will be recorded in QuickBooks Online, so you won’t have to hunt through checkbook registers or file folders to see if a bill was paid.
  • Timeliness. QuickBooks Online will always remind you when a bill must be paid (if you’ve set it up correctly).

To enter a bill, click the plus (+) sign at the top of the screen and click on Vendors and then Bill. This screen opens:

 photo QBO 0916 image 2_zps00hllu36.jpg

You’ll enter information about each bill on a screen like this. There are fields not pictured here that you’ll sometimes have to complete. So let’s start a conversation about the whole process.

Looks pretty simple, doesn’t it? It is – if you have a simple bill like the one you receive for gas and electric. You select the vendor by clicking on the arrow next to the blank field in the upper left and choosing from the list that opens. The Mailing Address and Terms should fill in automatically if you’ve done all of your initial QuickBooks Online setup. If not, you can add and edit this information.

Bill date refers to the date of the bill itself, not the day payment is due to the vendor. That goes in the Due date field. Select your Account from the list that opens when you click in that field, and enter a Description and Amount. If that’s all that’s required for that bill, you can save it and proceed to the next. It’s now recorded as a bill that needs to be paid.

Recurring Payments

Some of your bills are just one-offs,but others arrive on a regular basis. So QuickBooks Online has tools that will minimize the time required to process them after you’ve entered the basic information once. After you’ve completed a bill, click Make recurring at the bottom of the page to see this screen:

 photo QBO 0916 image 1_zpsncgowctt.jpg

QuickBooks Online lets you create templates for bills to use in future payments.

This screen is self-explanatory. You simply tell QuickBooks Online how much notice you want before a bill’s due date so you can process the payment. Take care with this screen to avoid paying bills too early, which affects your cash flow unnecessarily, or too late.

You have three options when you’re creating a Recurring Bill template. You’ll choose one from the list that opens when you click the arrow in the Type field:

  • Scheduled. This is best used when the details of a transaction don’t change, like rent or a loan payment. You don’t have to do anything for the payment to be dispatched; it’s done automatically for you at the interval you set. You can, however, ask to be notified every time this occurs.
  • Reminder. You could use this for periodic payments that will require editing before they’re sent. For example, you’ll probably need to change the amount on your utility bills every month. QuickBooks Online will place a reminder in your Activities list on the home page.
  • Unscheduled. If you have bills that contain a great deal of detail but aren’t due on a set schedule, you can save the template and call it up when you need it by clicking the gear icon in the upper right and selecting Recurring Transactions.

Next month, we’ll talk about the process of actually paying bills. If in the meantime you start entering bills and find that you’re having trouble completing the fields required for more complex bills, call us to schedule a session or two.

Better Budgeting Using QuickBooks Online Plus

Everyone groans when budget time rolls around. QuickBooks Online Plus offers tools that simplify the process.

Budget. The word evokes a sense of dread in most small business managers’ minds. Large corporations have entire teams of accountants that work on this critical element of financial planning. You, on the other hand, must go it alone – or with the help of other staff if your company is big enough.

Why is this chore so difficult? Several reasons. The biggest stumbling block is probably the sense of uncertainty. How do you know what your income and expenses will be for the coming year?

QuickBooks Online Plus can’t tell you how to plan the next year in terms of numbers, but its tools can make the mechanics of building a budget easier.

Your Fiscal Year Start

 photo QBO 0816 image 0_zpsy53bij2u.jpg

Finding the start of your fiscal year in QuickBooks Online Plus

Do you know exactly when your fiscal year starts? You’ll need this information before you can get started on your budget. Click the gear icon in the upper right next to your company name, and then select Account and Settings | Advanced. The first entry here tells you what the First month of fiscal year is.

Creating a Framework

To get started building your budget, click the gear icon again and select Tools | Budgeting. Click New Budget to open the mini-interview wizard (if it didn’t open automatically). QuickBooks Online Plus creates what are called Profit and Loss Budgets. This kind of budget tracks the numbers in your income and expense accounts.

There are three ways to create one, as you’ll see when you click Next on the first page of the interview. You can:

  • Work from historical amounts by copying last year’s data into the spreadsheet,
  • Start from scratch, or
  • Copy data from an existing budget.
 photo QBO 0816 image 1_zpsmk6o283g.jpg

You can choose from these three options to create your budget in QuickBooks Online Plus.

Click in the button in front of No amounts. Create budget from scratch, and then click Next. QuickBooks Online Plus’s budgets consist of a table divided into months (columns) and accounts (rows). You can break this down into even greater detail by subdividing your budget and tracking accounts separated by Territories, Classes, or Customers if this kind of information is important to you. For now, click the button in front of Don’t subdivide.

When you click Next, you’ll be asked to select the fiscal year for your budget. Click the down arrow to the right of Select fiscal year and choose the appropriate year. Type an easy-to-remember name for your budget in the box below and click Finish. The mini-interview will close, and your budget spreadsheet will open.

Entering the Numbers

QuickBooks Online Plus defaults to a monthly view when you first open it, but you can change this at any time to Quarter or Year by clicking the arrow in the field next to View by in the upper right corner.

If you had copied income and expense data from the previous year, or from an existing budget, those numbers would appear in the corresponding cells and could be changed to create a new budget. You opted to start from scratch, so the table is empty. You can just start entering individual numbers – not within the spreadsheet cells themselves, though.

Look down to the bottom left corner of the screen. If you’ve highlighted Discounts given, for example, by clicking on that label in the spreadsheet column, you’ll see a line directly below that last row that reads Edit – Discounts given.

This area is where you’ll do your actual data entry. If the drop-down list to the right of Enter by is set to Month, you’ll see 12 boxes below labeled with the months of the year. If you anticipate that every month will contain a different figure, enter the numbers in the correct boxes and click Save & Next. QuickBooks Online Plus will copy your numbers into the actual budget spreadsheet.

If the number will remain the same for each month, you can enter it in the Jan box and click Copy Across, then Save & Next (click this button after every row change). Your cells for that account will be automatically populated.

 photo QBO 0816 image 2_zpsg77seyor.jpg

Entering quarterly budget data

If you think more in terms of quarterly income and expenses, you can highlight the correct account and select Quarter from the drop-down box next to Enter by (see above image). Fill in your quarterly totals, and QuickBooks Online Plus will divide those evenly between each set of three-month periods. The result would look like this:

 photo QBO 0816 image 3_zpslohtkoqa.jpg

QuickBooks Online Plus can divide quarterly totals into monthly budget numbers.

And of course, if you select Enter by: Year, you’ll only enter one number that QuickBooks Online Plus will divide evenly into 12 months.

When you’re done with your budget, click Finish.

This is a lot of information to absorb all at once, and we imagine you may have some questions on budget projections and on the actual mechanics of creating a budget using QuickBooks Online Plus. As always, we’re happy to hear from you.

Charging for Time in QuickBooks Online, Part 2

Last month, we talked about time-tracking setup, single-activity data entry, and user permissions. This month, we’re exploring additional time-and-billing steps.

By now, you’ve set up QuickBooks Online for time tracking and entered your first timed activity. If you have employees who only need to get on the site to complete their timesheets, we showed you how to give them restricted access.

Let’s start here by looking at what’s involved in completing timesheets. We’ll assume for this example that you are entering your own billable time. You can see how this screen looks by clicking the plus sign (+) at the top of the screen, then Employees | Weekly Timesheet. The screen looks very similar to a paper timecard.

If you had entered a single activity for a billable time block already, all of that information would appear in your timesheet for that week, once you selected your name from the drop-down list in the upper left and set the work week to the correct one in the field to the right. It would look something like this:

 photo QBO 0716 image 1_zpsf2hu4f9e.jpg

Time entries recorded as single activities automatically transfer over to that week’s timesheet.

If you’re going to enter your complete work week directly on the timesheet, you’d open a blank form (using the instructions above) and select your name and the time range. Next, you’d go down to the first field under DETAILS and select the appropriate Customer Name by clicking on the arrows to the right of the field to open the list. Next to that, do the same thing to choose the Service.

The fields below those two are earmarked for Class (if you assign classes) and Territory (or whatever Location Label you’ve chosen). If you haven’t used these and want to explore them, let’s schedule a session to go over QuickBooks Online Classes and Custom Fields.

Type a Description in the box below and click in the box in front of Billable. The hourly rate and tax status should fill in automatically. In the boxes below the correct dates (in the grid to the right), you’d enter the billable hours worked for that customer that week. If you are reporting billable time for more than one customer, or time that is not billable, you’ll of course have to place those entries on new lines.

Employee Timesheets

 photo QBO 0716 image 2_zpsmiz8xqvd.jpg

This is part of what employees see when they log into QuickBooks Online using their Time Tracking only status.

Your employees can, of course, enter hours directly on their own timesheet screens. As we discussed last month, you can choose whether to let employees see the customer’s billing rate. In this example, the employee can only enter hours worked and indicate that they were billable. When you go to approve the timesheet, you will see the rate.

Getting Paid

As you start to create an invoice for a customer who needs to pay for services that have been included in a timesheet, look at the vertical pane to the right of the main working screen titled Add to invoice. Any estimate that hasn’t yet been accepted and any time that hasn’t been paid for should appear in the small blocks in that pane.

You have two options here: Add or Open. Clicking on the first adds that time block to the invoice, and clicking on the second opens the original form. You can also click on the Add all button at the top of the pane to include the details of every entry in the invoice.

 photo QBO 0716 image 3_zpszn7ghqdk.jpg

When you create an invoice for a customer who has outstanding billable time, that information will appear in the right vertical pane. You can open the original transaction or click to add it to the invoice.

Time Reports

As you can see, time billing can get a little complicated when you have employees entering their own timesheets. And QuickBooks Online wants to make sure that you’ve billed customers for every minute that you’ve worked for them. So there are two reports that you should be consulting regularly. Click on Reports in the left vertical pane, then All Reports and Review Sales. In this list, you’ll see:

  • Time Activities by Customer Detail, and
  • Unbilled Time.

The titles of these reports should be fairly self-explanatory. Be sure to set the correct date range before running them, though, to avoid missing anything.

Completing timesheets isn’t rocket science. Nor is earmarking time blocks as billable. But due to the setup and the options involved, as well as the complications that can occur when you add employee self-service to the mix, we highly recommend that you meet with us to go over the whole process. We want to make sure that your company’s time entry and timesheet configuration are right from the start.

Tracking Products and Services in QuickBooks Online, Part 2

Last month, we explored the process of creating a product record. Now we’ll look at where they’re used in QuickBooks Online.

Have you been able to create records for all of your products and services? If you have a large inventory, this can be quite a time-consuming process. But we highly recommend that you build complete records, even when you create them as you need them. This is critical if you plan to track inventory items.

You’ll use your product and service records in several areas of QuickBooks, including invoices and estimates, purchase orders, and sales receipts. There’s also an entire set of reports dedicated to products and inventory.

Important: If you’ve tried creating Inventory Items in QuickBooks Online but have only been allowed to set up Services or Non-Inventory Items, you missed a step when you were completing your Company Settings. Click on the small gear icon in the upper right (next to your company name), then on Settings | Company Settings. Click on Sales in the left vertical tab to see the Products and services section. If any of these three options is turned off, click in the box to turn it on.

 photo QBO 0516 image 0_zpsxoguayks.jpg

Figure 1: These three options in Company Settings must be labeled On in order to make use of all of QuickBooks Online’s inventory-tracking features.

This is one of the reasons we recommend that you let us help you set up QuickBooks Online, even if you’re making a transition from the desktop version of QuickBooks. If you don’t visit every area of Company Settings and designate your preferences, you may get frustrated as you start working, thinking that the site isn’t capable of doing everything you need.

Using Your Records

You’ll see why it was so important to build a thorough set of product and service records when you start to enter data in transaction forms. Assuming that you’ve also created records for your customers and vendors, filling out an invoice, for example, is mostly just a matter of selecting the correct options from drop-down lists.

Of course, even if you have a comprehensive set of records, you’ll certainly take on new customers and vendors, and start offering additional products and services down the road. When this occurs, or if you didn’t complete your setup work because you absolutely had to start entering transactions, you can add items as you need them.

 photo QBO 0516 image 1_zps5g0sadzy.jpg

Figure 2: When you create transactions, you can choose products or services from a list of existing records or add new ones “on the fly.”

Once you’ve selected a customer and either accepted the default terms and dates or edited them to reflect your needs, you’ll click on the arrow to the right of the first field in the body of the invoice, as pictured in the example above. You can scroll down and find the item that the customer wants to purchase in the list that drops down or click on +Add New.

If you do the latter, the Product/Service information panel will slide out from the right. You can then create a record for the product or service, like we wrote about last month.

A Running Tally

Here is another reason why it’s so important to be conscientious about completing product records. When you enter that number in the Initial quantity on hand field, QuickBooks Online uses that as a starting point for tracking your inventory levels. Every time you process a form indicating that you’re selling x number of widgets, the site subtracts that from the most recent total.

 photo QBO 0516 image 2_zpsmizffceb.jpg

Figure 3: QuickBooks Online helps you keep a close eye on your stock levels in real time.

When you click in the Quantity field, a small cartoon bubble opens above it, telling you how many units are currently available. This keeps you from selling items that you don’t have. It also indicates when you may have too much of a product, and it’s not selling quickly.

Unless you have a very small product list, you may not recognize overstocks. So QuickBooks Online offers several reports that can help you track your inventory. Click on Reports in the left vertical tab, then All Reports, then Manage Products and Inventory to see what’s available.

 photo QBO 0516 image 3_zpsnrcfar2q.jpg

Figure 4: The Inventory Valuation Detail report

Setting up QuickBooks Online for a successful launch can be challenging. So can the concepts involved in tracking your inventory of products. We’re always happy to help with either process – or both.

Use Recurring Transactions in QuickBooks Online

Save time and ensure that repeating transactions are processed as scheduled.

You know how much time QuickBooks Online already saves you. Customer, vendor, and item records need never be entered again once they’re created for the first time. Pre-built forms use your record data to complete transactions quickly and accurately. Customizable report templates provide real-time overviews of your financial status in every area.

There’s another way QuickBooks Online can reduce the time you spend on accounting chores: recurring transactions. If you have invoices, bills, and other transactions that occur on a regular basis, you can save all or part of their data to use again. You can even choose to have them dispatched automatically.

Here’s how it works. You need to create a template, a type of model, for each recurring transaction. To do this, simply create the transaction you want to repeat. Say it’s an invoice for a service you provide monthly to a company or individual. You’d fill in all the required fields, then click Make recurring in the horizontal toolbar at the bottom of the screen. This window will open:

 photo QBO 0117 image 1_zpsu1wbipn5.jpg

When you click Make recurring at the bottom of a transaction, this window of options will display.

Select the Customer first by clicking the arrows to the right of the blank field. QuickBooks Online will fill in contact information and automatically display name that as the Template name. You can leave it there, or you can try to think of a phrase that describes the transaction, so you’ll remember it. Next, you need to decide how QuickBooks Online will handle the transaction. There are three options:

  • Scheduled. Be very careful with this one, since QuickBooks Online will automatically create and dispatch it. This only works if the information in the transaction—minus the date—is always exactly the same.
  • Reminder. This is safer. QuickBooks Online will display a reminder in time for you to complete and process the transaction.
  • Unscheduled. QuickBooks Online will do neither of the above, but the template will be available to use as you need it. This is good for infrequent transactions that share some common information.

Next, taking into account variables like delivery methods and due dates, enter a number in the field in front of days in advance. Then skip down to Options and click the box in front of all the statements that apply to that transaction. The bottom line in this window contains the fields that will let you specify the transaction’s Interval. Click the arrows next to each field to open its menu.

In the example above, we’ve indicated that the invoice occurs monthly on the first day of the month, starting on January 1, 2017. You don’t know how long this will recur, so we’ve left End set to None. When you’re satisfied with everything in the window, click Save template in the lower right corner.

To see a list of the repeating transactions you’ve defined, click the gear icon in the upper right corner of the screen and select Recurring Transactions. A table displaying them will open and display columns including Type, Interval, and Previous Date. Look toward the end of one of these lines. To modify the template, click Edit.

 photo QBO 0117 image 2_zpstsrqrgvx.jpg

The Recurring Transactions screen gives you an overview of the templates you’ve created and provides links to action options.

There are other options here that vary depending on the type of transaction. In the screen shot above, the template is a bill. You can:

  • Use it to create a new transaction,
  • Duplicate it and modify it, to make a new template,
  • Pause it, to temporarily suspend its recurrence,
  • Skip next date and resume after the next interval, or
  • Delete

QuickBooks Online also includes a report that will display all the templates you’ve created. Click Reports in the left vertical pane, then All Reports (unless this list is already active), then Accountant Reports. You’ll find the Recurring Template List in the lower right corner.

Recurring transaction templates can save you a lot of time and increase accuracy. Conversely, they can result in unbilled revenue and past-due bills—or even duplicate transactions—if they’re not created with precision. We’d be happy to step in and guide you through the process for the first time.