Monday, August 21, 2017

7 Best Practices for QuickBooks Online

Even if you’ve been using QuickBooks Online for a long time, it’s good to step back and evaluate your actions.
“Best practices” aren’t enforceable rules. They’re simply guidelines businesses commonly follow in one area or another. If you’re in retail, for example, one best practice might be to always ask customers checking out if they found everything they were looking for. This serves two purposes: It conveys a feeling of concern for the customer’s shopping experience, and it may also lead to increased sales.
QuickBooks Online has many best practices, some of which may serve multiple purposes, including these:
  • They keep your company data safe and clean.
  • They provide insight on your financial status.
  • They save time.
  • They can lead you to better relationships with customers and vendors.
Are any or all the following common practices for your business?
Reconcile accounts regularly.
One of QuickBooks Online’s most useful features is its ability to connect to your financial institution’s websites and download cleared transactions. QuickBooks Online also offers tools to help you keep your accounts reconciled online, like you used to do every month when your paper statement came. Reconciling accounts can help you uncover errors. It gives you a truer picture of your cash flow, and it improves the accuracy and timeliness of some reports.
It’s not a particularly pleasant process, but you should be reconciling your accounts regularly in QuickBooks Online. We can help.


Clean up your lists.
Some lists in QuickBooks Online aren’t overly lengthy. You don’t have to worry about, for example, Payment Methods, Terms, or Classes. Your lists of customers and vendors, products and services, on the other hand, can grow unwieldy over the years. This means it can take more time than it should to scroll through lists when you’re using those entities in transactions. It also puts unnecessary stress on your company file. If you can’t delete any, at least make them inactive.
Never leave QuickBooks Online open when you leave your work area.
This goes for everyone, even people who work alone and don’t access their company files away from their work areas. The obvious reason is to keep someone else from getting in and authorizing payments, for example, or otherwise compromising your financial information. It also protects the integrity of your data file in case your internet connection suffers some kind of outage.
Keep track of 1099 vendors.
Whether your company uses 10 vendors or a hundred or more, you may have to supply at least some of them with an IRS Form 1099 at about the same time you’re preparing W-2s for employees. Your 1099-related tasks will be much easier if those individuals and/or companies are earmarked. If you think vendors might need 1099s when you create their records in QuickBooks Online, click in the box to the left of Track payments for 1099 in the lower right corner. Not sure? Ask us.
Classify everything with care. Every time you have to create a record or transaction where categories are involved (i.e., Classes, Customers and Vendors, Territories), check and double-check that you’ve assigned them the correct classification. Errors here can result not only in problems with daily workflow, but your reports will not be accurate. A related best practice: Create a meaningful group of Classes, and use them faithfully. They’ll help you make better business decisions.


To create your list of Classes, click the gear icon in the upper right and select All Lists | Classes | New.


View reports on a regular basis.
There are some advanced financial reports in QuickBooks Online that we should be creating for you on a regular basis, either monthly or quarterly. These include Profit and Loss, Balance Sheet, and Statement of Cash Flows. The mechanics of creating them aren’t difficult, but analyzing them is. You should be running reports on your own at frequencies that you think would be helpful, like A/R Aging Detail, Unpaid Bills, and Sales by Class Detail.

If you’ve been using QuickBooks Online for a while, you could probably come up with your own list of best practices. If you’re new to the site, consider scheduling some time with us to go over more of them. Develop good habits from the start, and there won’t be nearly as much need for troubleshooting down the road.

Monday, August 7, 2017

What Sales Orders Are and When to Use Them

They’re not as commonly used as invoices. But if you need them, they’re there.
When you want to document sales that you can’t (or won’t) fulfill immediately, but you plan to do so in the future, you can’t create an invoice just yet. This is where sales orders come in.
You may never need to create a sales order for a customer. Perhaps you have a service-based business, or you never run out of inventory. Or you simply don’t enter an order unless you know you have the item(s) in stock.
But if you plan to use sales orders, you must first make sure QuickBooks is set up to accommodate them. Open the Edit menu and select Preferences, then Sales & Customers. Click the Company Preferences tab to open that window.

Before you can use sales orders, you’ll need to make sure that QuickBooks is set up for them.
Sales Orders Are Required for Some Tasks
There are a few situations where you must use a sales order:
  • If you have a customer who orders very frequently, you may not want to create an invoice for absolutely every item. You could use a sales order to keep track of these multiple orders, and then send an invoice at the end of the month.
  • If you’re missing one or more items that a customer wanted, you can create a sales order that includes everything, but only note the in-stock items on an invoice. The sales order will keep track of the portion of the order that wasn’t fulfilled. Both forms will include the back-ordered quantity.
Warning: Working with back orders can be challenging. In fact, working with inventory-tracking itself may be problematic for you. If your business stocks enough of multiple types of items that you want to use those QuickBooks features, let us help you get started to ensure that you understand these rather complex concepts.
Creating a Sales Order
Creating sales orders in QuickBooks is actually quite simple and similar to filling out an invoice. Click the Sales Orders icon on the home page, or open the Customers menu and select Create Sales Orders.

A sales order in QuickBooks looks much like an invoice.
Click the down arrow in the field next to Customer: Job and choose the correct one. If you use Classes, select the correct one from the list that drops down, and change the Template if you’ve created another you’d like to use.
Tip: Templates and Classes are totally optional in QuickBooks. Templates provide alternate views of forms containing different fields and perhaps a different layout. Classes are like categories. You create your own that work for your business; they can be very helpful in reports. Talk to us if you don’t understand these concepts.
If the shipping address is different from the customer’s main address, click the down arrow in the field next to Ship To, and either select an alternate you’ve created or click <Add New>. Make sure the Date is correct, and enter a purchase order number (P.O. No.) if appropriate.
The rest of the sales order is easy. Click in the fields in the table to make your selections from drop-down lists, and enter data when needed. Pay special attention to the Tax status. Let us know if you haven’t set up sales tax and need to.
When everything is correct, save the sales order. When you’re ready to convert it to an invoice, open it and click the Create Invoice icon in the toolbar. QuickBooks will ask whether you want to create an invoice for all the items or just the ones you select. You’ll be able to specify quantities, too, in the window that opens.
When you create an invoice from a sales order, you can select all the items ordered or a subset.
As we’ve said, sales orders are easy to fill out in QuickBooks. But they involve some complex tracking, and you may want to schedule a session with us before you attempt them. Better to understand them ahead of time than to try to troubleshoot problems later.

Social media posts
Sales orders are totally optional in QuickBooks. But there are times when you may need them. Ask us about this.
Is your inventory large and unpredictable enough that you sometimes have to back-order items? Use a QuickBooks sales order.
Once you’ve created a sales order in QuickBooks, it’s easy to convert it to an invoice. The software can do this for you.

QuickBooks displays an icon in the sales order toolbar that lets you create a purchase order for needed items.