Quickbooks

QuickBooks Online is good at saving you time and keystrokes. Here’s another way it helps avoid duplicate data entry.

Accounting is a repetitive process. As you prepare invoices and receipts and bills, and other sales and purchase forms, you undoubtedly grow weary of typing the same information over and over. Customer and vendor names, addresses, product and service descriptions – you practically memorize these details if you have to enter them frequently.

QuickBooks Online does that memorization for you. Once you’ve entered a detail like a customer’s shipping address or the cost of an item, you never have to supply it again. You only have to select data from lists when you’re creating a purchase order, for example.

But the site goes further. If you have to enter transactions on a regular basis that are identical or nearly identical, QuickBooks Online allows you to save them as recurring templates. When it’s time for them to go out, it gives you options for dispatching them depending on the need for any tweaking. Here’s how it works.

How Do You Make Transactions Recur?

The process is very simple. You start by creating a transaction that you’d like to repeat at intervals you specify. For example, you might send monthly invoices to some customers for lawn services. Enter the invoice details like you normally would, selecting a customer and the item or service descriptions and any other information that needs to be included.

When you’re done, click the Manage icon in the upper right, scroll down in the panel that opens on the right, and click Scheduling, then toggle on the button next to Make invoice recurring. In the Template name field, give it a descriptive name that you’ll associate with the invoice. Then click the down arrow in the field under Type.

QuickBooks Online gives you three options for managing your recurring transactions.

There are three ways you can ensure that the invoice goes out at its specified interval. They are:

● Scheduled. If you select this, your transaction will go out as scheduled with no intervention from you. Only the date will change. We urge caution with this one. Be sure you won’t want to change anything.
● Reminder. QuickBooks Online will send you a reminder ahead of the scheduled date. You can specify how many days ahead you should receive it. Then it’s up to you to make any necessary changes and send it out.
● Unscheduled. QuickBooks Online will do nothing except save your template. You can modify and use this at any time that’s appropriate.

Deal with the other Template options and scroll down to set up intervals and starting/ending dates if necessary. If you choose Unscheduled, you can save the template. For Reminder and Scheduled, though, be sure to complete the fields at the bottom of the pane before saving.

If you’re creating a Scheduled or Reminder invoice template, you’ll need to complete the fields at the bottom of the Recurring settings pane.

NOTE: These instructions are based on QuickBooks Online’s new invoice format. It’s possible that your account is still using the old format. If that’s the case, or if you’re creating another type of transaction that will recur (like a bill) you will see a link at the bottom of the form that says Make recurring. Your other options will remain the same.

How Do You Use Recurring Transactions?

When you want to modify or use a recurring transaction, click the gear icon in the upper right of the page and select Recurring transactions under Lists. A table containing all of the ones you’ve created will open. There are multiple columns in this table that provide a lot of information about each transaction. They are Template Name, Type, Txn (Transaction) Type, Interval, Previous Date, Next Date, Customer/Vendor, and Amount.

● The final column, Action, lists the options you have for each type of recurring transaction. For Unscheduled Invoices, you’ll most likely Use them, though you can also Edit them. If you set up a transaction as a Reminder, you can do the following to it:
● Edit (edit the template, not the transaction)
● Use (opens the original transaction that you can edit, save, and send)
● Duplicate (duplicate the template)
● Pause (stop sending reminders temporarily)
● Skip next date
● Delete

Your time as a business owner is valuable. Don’t waste any of it doing duplicate data entry. Creating recurring transactions in QuickBooks Online is one way of minimizing keystrokes and using the time savings to manage other elements of your business. If you have any questions about what we discussed here or are struggling with any other features in QuickBooks Online, don’t hesitate to contact us to schedule an appointment.

Customers may be the lifeblood of your business, but they wouldn’t exist without the products and services you sell. It doesn’t matter whether you’re a mineral specimen dealer who does one-off sales, a reseller who sells items you make or buy wholesale in large lots, or a provider of services. You must always know what you have available to offer buyers – goods, designing websites, or offering lawn care services in your community, for example.

QuickBooks Online can keep you in the know about what you have available to sell, and it can manage the forms and transactions you need to do business with your buying audience. If you were doing your accounting and customer management manually, you might be using index cards and large wall calendars and file folders stuffed with product lists and schedules. You’d spend a lot of time digging through item drawers and closets, counting your inventory by hand, and shuffling paper invoices and sales receipts and payment documentation.

Instead, what if all of that is automated, saving time, reducing errors, and increasing your chances of success? Here’s a quick look at some of the basics.

Are You Ready?

We’ve written about product and service management a lot. So you should know that to get ready to sell, you have to have made sure QuickBooks Online is set up to handle any inventory you might have. Click the gear icon in the upper right corner and then click Account and settings under Your Company. Click Sales in the toolbar and scroll down to Products and services. Make sure the first, fourth, and fifth options are turned on, as pictured below (the other two are optional). If they’re not, click the pencil icon in the upper right corner and change them. Be sure to click Save when you’re finished, then Done in the lower right corner.
Make sure your Products and services settings are correct.

Have you created your product and service records? You can do this on the fly as you’re entering transactions, but it’s much better to do it ahead of time. That way, too, you’re not as likely to skip the details, which will be important later on when you’re running reports, for example. We’ve gone over the steps before. Click New in the upper left corner, then Add product/service under Other. A vertical panel slides out from the right, and you simply select from options and enter data.

Warning: Be very precise when you’re dealing with inventory information. If you haven’t gone through this process before, it might be worth scheduling a session with us to go over this important step.

Using Your Records in Transactions

Let’s go through the process of entering a sales receipt. Click New in the upper left corner, and then Sales receipt under Customers. . Choose a Customer from the drop-down list and complete any other fields necessary in the upper section of the form. Select the Service Date in the first column by clicking the calendar, then select the Product/Service in the next column (or click + Add new). The Description should fill in automatically.

QuickBooks Online provides inventory information as you’re completing sales forms.

The QTY (quantity) defaults to 1. If you mouse over or click in that field, a small window will pop up containing numbers for Qty. on hand and Reorder point, as pictured above.

Tip: If you know that you have more in stock that is showing, you can cancel out of the transaction, find the item record in the list on the Products & services page, and click Edit at the end of the row. You’ll be able to adjust the quantity or the starting value. Be very careful with this. Please contact us if you’re not very confident about how to handle this.

Enter any additional items and/or services needed and save the transaction.

The Products and Services Page

QuickBooks Online offers numerous reports related to products and services and inventory tracking (you’ll find them under Reports | Sales and customers), but you can learn a lot from the Product and Service page (Sales | Products and Services). At the top of the screen (where you can’t miss them) are two colored circles containing the number of items that are Low Stock or Out of Stock.

This important information appears at the top of the Products and Services page.

Click on either of these, and the list below will change to only display these items. You can get a lot of information about your products and services on this page, including Sales Price and Cost, Qty On Hand, and Reorder Point. You can also create new records or import databases of records in CSV, Excel, and Google Sheet format. We can help you prepare to do this.

Your business depends on accurate, real-time information about your inventory, and QuickBooks Online can supply it. This element of the site, though, requires precision and regular upkeep. If you’re struggling with it, let us step in and help. We’re available to troubleshoot one-time problems, but we can also take a more active role in your accounting.