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.

Company Preferences Screenshot

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.

 Sales Order Screenshot

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.

Specify Items and Quantities Screenshot

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.

For more QuickBooks tips, tricks and info on training from our team of Certified QuickBooks ProAdvisors® subscribe to The QBC.

QuickBooks and QuickBooks ProAdvisor are registered trademarks and/or registered service marks of Intuit Inc.

Establishing Preferences in QuickBooks

Before you start entering data, make sure QuickBooks is set up appropriately for your company.

QuickBooks was designed to serve the needs of millions of small businesses. To do that, it had to include the tools and processes suitable for a wide variety of companies. But Intuit recognized that every organization is unique, so your copy of QuickBooks can be customized in ways that make it work best for you.

You could just dive in and start adding records and transactions. But we recommend you do some setup first. If you don’t, you may run into some issues later, such as finding that some features you need haven’t been turned on, for example, or that QuickBooks is simply not doing some things the way you do. The good news is that you can change many of these.

Getting There

QuickBooks refers to these options as Preferences. You’ll find them by opening the Edit menu and selecting Preferences.

To start customizing QuickBooks so it works best for you, open the Edit menu and choose Preferences.

As you can see, the left vertical pane contains a list of Preference types. Click on any of these to change the option screens to the right. Always click the tabs labeled My Preferences and Company Preferences to make sure you see everything that’s displayed for each type (sometimes one will have no choices).

Setting Up Reminders

Let’s look closely at one set of Preferences: Reminders. It’s very important that you visit these screens when you begin using QuickBooks. Depending on how big your company is and how complex your accounting processes are, there may be things you need to do every day, like pay bills and follow up on overdue invoices. It would be nearly impossible for you to do everything on time if you didn’t ask QuickBooks to keep track of critical dates and remind you of them.

Click Reminders in the left vertical tab. You’ll see one option under My Preferences. Do you want QuickBooks to show Reminders List when opening a Company file? If so—and this is a good idea—click the box in front of that line if there isn’t a checkmark there already.

Then click Company Preferences. Here’s where you’ll tell QuickBooks whether you want to see summaries or lists for each reminder, or neither. You can also specify how much advance notice you want for specific tasks by entering a number of days. QuickBooks comes with default settings, but you can easily change these.

QuickBooks comes with default settings for Reminders, but you can enter your own Preferences here.

As you can see, it’s easy to specify your Company Preferences. Click the appropriate button under Show Summary, Show List, or Don’t Remind Me. If you’ve requested a reminder, delete any number that appears in the box in front of days before or days after and then enter your own.

Critical Areas

We recommend that you look through all of QuickBooks’ Preferences and change any that don’t fit your company. Some simply have to do with the way QuickBooks displays information and how it functions, but others have direct impact on your accounting work. As always, we’re available if you have questions here.

There are many that you will probably want to visit. They may have numerous options, but here’s some of what you can establish in each:

  • Accounting. Do you want to use account numbers and classes?
  • Checking. Which accounts should QuickBooks automatically use for tasks like Open the Pay Bills, Open the Make Deposits, and Open the Create Paychecks?
  • Finance Charge. Will you be assessing finance charges on late payments from customers? What’s the interest rate, minimum finance charge, and grace period?
  • Items & Inventory. Do you want inventory and purchase orders to be active?
  • Multiple Currencies. Does your company do business using other currencies?
  • Payments. Can customers pay you online? What methods can they use?
  • Payroll & Employees. Will you be processing payroll using QuickBooks?
  • Sales & Customers. Do you want to use sales orders? How should QuickBooks handle invoices when there are time and costs that need to be added?

You can see why it’s important to study QuickBooks’ Preferences early on. It’ll help you avoid unnecessary roadblocks and ensure that your company’s needs are reflected well in the software.

For more QuickBooks tips, tricks and info on training from our team of Certified QuickBooks ProAdvisors® subscribe to The QBC.

QuickBooks and QuickBooks ProAdvisor are registered trademarks and/or registered service marks of Intuit Inc.

Anatomy of a QuickBooks Inventory Item

If you have an item-heavy business, you need tools to track your inventory. QuickBooks provides them.

When you started your business, maybe you were able to keep track of your inventory by peering in the closet or your garage. As you grew, that simply took too long. But you grew tired of running out of stock because you didn’t have time to constantly check its levels, and you forgot about items that didn’t sell and were tucked away in a corner.

You need inventory-tracking. QuickBooks can help you create thorough records for each product you sell. It keeps track of how much you have on hand and warns you when your stock is running low. And its reports tell you what’s selling and what’s not, so you can make better, smarter purchasing decisions.

Activating Inventory-Tracking

Before you get started creating item records and including them in transactions, you need to make sure that QuickBooks is set up to start tracking. Open the Edit menu and click Preferences. Click Items & Inventory in the left vertical pane and then select the Company Preferences tab. This window will open:

QuickBooks needs to know what your intentions are when it comes to inventory tracking.

First, of course, click in the box to the left of Inventory and purchase orders are active if it isn’t already checked. Click the next box down if applicable. The rest of this window deals with two concepts you need to understand. Quantity on Hand refers to the number of items that you actually have. Quantity Available subtracts items currently on Sales Orders. QuickBooks will warn you if you don’t have enough of a specific item to commit to a customer. You just have to decide which definition of Quantity you want to use.

When you’re done here, click OK.

Accuracy Matters

Now you can start entering records for the products you sell. Accuracy is absolutely essential here. You’ll see why as you explore QuickBooks’ tracking capabilities.

There are a few ways to open an item record window. You can click Items & Services in the upper right corner of the Home Page, or open the Lists menu and select Item List. Both will open a window displaying any item records that have been entered in a register-type view. Right-click anywhere and select New, or click the arrow next to Item in the lower left corner and select New.

QuickBooks Item List for Inventory

Double- and triple-check your work as you enter information in the QuickBooks item record window.

QuickBooks lets you create records for numerous types of items, including Service, Discount, and Inventory Assembly. To see how inventory-tracking works, select Inventory Part from the drop-down menu under TYPE. Next, enter an Item Name/Number in that field.

If you’ve already named a main category (like Hardware, in the example above) and want to place your product in a subcategory of it, click the Subitem of box and choose from the drop-down list. Manufacturer’s Part Number is optional. You can ignore UNIT OF MEASURE, if this isn’t an option in your version of QuickBooks.

Purchase Information

If you buy this item from a vendor, fill in this side of the window. Write the description that should appear on purchase transactions when you place an order. Enter the cost you pay for it, and select the COGS (Cost of Goods Sold) account if the default isn’t correct. Do you buy this product exclusively from one supplier? Select the name in the drop-down menu under Preferred Vendor.

Sales Information

Enter the description you’d like customers to see on invoices and the price you’ll charge. If you’re at all unsure of what to select for Tax Code or Income Account, we can go over your Chart of Accounts with you and explain how its accounts are used in records and transactions.

Inventory Information

Here’s where the software’s tracking capabilities come in. QuickBooks will probably default to your Inventory Asset account, which is fine. Enter the minimum number of items that should be in stock when you get a reminder to reorder, and the maximum you want to have at any one time. Fill in the On Hand field with the number you currently have. QuickBooks will automatically calculate the Total Value.

In the screen shot above, you see an example of what that last line looks like once you start using that item in transactions. You’ll see its Average Cost and the number that are currently on purchase orders and sales orders.

Creating records for every product you sell can be tedious, time-consuming work. But the payoff comes in the real-time knowledge you’ll have of your inventory that will lead to better, smarter purchasing decisions. As always, we stand ready to help.

For more QuickBooks tips, tricks and info on training from our team of Certified QuickBooks ProAdvisors® subscribe to The QBC.

QuickBooks and QuickBooks ProAdvisor are registered trademarks and/or registered service marks of Intuit Inc.

Audit & Accounting Update: January 26, 2017

At Insero, we make it our business to stay abreast of the latest trends and technical updates in accounting, tax, and audit and we understand how important timely updates are to our clients. As a member of the RSM US Alliance, we also have the benefit of access to the resources and subject matter experts of RSM US LLP (formerly known as McGladrey LLP). This includes regular updates on the latest financial reporting insights. We hope that you find these informative and useful, and invite you to reach out to us if you have any questions.

Changes to revenue recognition in the technology industry 
Our white paper discusses how certain issues will significantly affect revenue recognition in the technology industry.
Read more

Clarifications to definition of a business
The FASB recently issued clarifications to the definition of a business, which affects many areas of accounting.
Read more

Consolidation of for-profit limited partnership by not-for-profit entity
ASU 2017-02 clarifies when a not-for-profit entity that is a general partner should consolidate a for-profit limited partnership.
Read more

Proposal: Balance sheet classification of debt
A recent proposed ASU introduces an overarching principle for determining whether debt should be classified as current or noncurrent.
Read more

Proposed changes to disclosure requirements for inventory
If finalized, recent proposed amendments to FASB ASC Topic 330 would require additional inventory disclosures.
Read more

FASB makes additional corrections to new revenue guidance
A recent FASB Accounting Standards Update makes technical corrections to ASC Topic 606, Revenue from Contracts with Customers.
Read more

Tool for audit committees: Preparing for the revenue recognition standard
A new Center for Audit Quality tool aims to help audit committees assess a company’s implementation of the new revenue recognition standard.
Read more

 

Audit and Accounting Updates for Business Owners and Financial Professionals

Source: RSM US LLP
Used with permission as a member of the RSM US Alliance
http://rsmus.com/our-insights/newsletters/financial-reporting-insights.html

As always, we hope you enjoy this edition of our newsletter and we look forward to receiving your feedback. Should you have any questions regarding the information contained in the attached materials or our service offerings, please contact us directly.

Ringing Out 2016 in QuickBooks

2017 is just around the corner. Now’s the time to do your end-of-year QuickBooks tasks.

Since early January of this year, you’ve been faithfully creating new records, entering transactions, and recording payments. You’ve run basic reports. You’ve done your collection duties. You may have paid employees and submitted payroll taxes.

Now the end of the year is rapidly approaching. In the midst of holiday get-togethers, gift shopping, and perhaps preparing for travel, you probably have a list of work tasks that must be completed by December 31.

Is your annual QuickBooks wrap-up on that list? It should be. Here are some of the things we suggest you fit into your busy schedule sometime this month.

Create and send year-end statements.

Create and send year end statements in QuickBooks

As your customers wrap up 2016, too, it’s good to send statements to past-due accounts.

In an ideal world, all of the invoices that are currently due would be paid off by the end of the year. We all know that that’s not usually the reality. Two reports can help you here: the A/R Aging Summary and Open Invoices.

Give everyone a chance to clear their accounts before December 31 by sending statements. Click Statements on the Home page (or Customers | Create Statements) to open the window pictured above.

You have multiple options here that are fairly self-explanatory. The screen above is set up to create statements for all customers who have an open balance as of the date you select, but not for inactive customers or those with a zero balance or no account activity. That way, no one who’s paid in full to date will receive a statement. Of course, if you didn’t want statements created for anyone who’s less than 30 days past due, you’d click in the box in front of Include only transactions over and enter a “30” in the following field. Questions about all of this? Give us a call.

Tip: You can also find out who’s overdue by clicking on the Customers tab in the left vertical pane to open the Customer Information screen. Click on the down arrow to the right of the field just below Customers & Jobs. QuickBooks provides several filters for your list.

Reduce your inventory.

Discount items in QuickBooks

Want to discount all or selected items in your inventory by the same percentage or amount? Open the Customers menu and click Change Item Prices. We can work with you on the whole item pricing process.

The week between Christmas and New Year’s Day might be a good time to sell excess inventory by having a sale. If you only sell a few products, you probably know what hasn’t sold well in 2016. If your stable of products is larger, you can run QuickBooks reports like Inventory Stock Status by Item and Sales by Item Detail to identify your slow-sellers and discount them. You may need to filter your reports to see the right data. Talk to us about customization options if you’re unsure of this.

Clean up your contact lists.

If you don’t maintain your customer and vendor lists, you’ll eventually start wasting time scrolling through them when you enter transactions. So this would be a good time to designate those contacts that you’ve not dealt with in 2016 as Inactive (you can delete their records entirely, but we advise against that). Simply open a Customer record, for example, and click the small pencil icon in the upper right to edit it. Click on the box in front of Customer is inactive.

Send holiday greetings to customers and vendors.

It’s getting a little late to send a holiday greeting/thanks-for-your-business note in December. Consider doing this in January (Best Wishes for a Successful 2017!) when your customers’ and vendors’ lives have slowed down a bit. You’re less likely to get lost in the crowd. If your lists are short enough, personalize these cards as much as possible. At least sign them by hand if you can.

Tip: You can print customer labels for your cards directly from QuickBooks. Open the File menu and then click Print Forms | Labels.

Run advanced reports.

Here’s where we come in. If we’re not already creating and analyzing QuickBooks’ advanced financial reports (found in the Accountant & Taxes submenu of Reports) monthly or quarterly, talk to us about it. They’re important, and they give you insight that you can’t get on your own. This is another activity that can spill into January.

We’d like to thank you for being a client this year, and to wish you a successful 2017!

For more QuickBooks tips, tricks and info on training from our team of Certified QuickBooks ProAdvisors® subscribe to The QBC.

QuickBooks and QuickBooks ProAdvisor are registered trademarks and/or registered service marks of Intuit Inc.

How QuickBooks’ Custom Fields Can Provide Better Business Insight

The QBC: QuickBooks® Client Newsletter

QuickBooks’ customizability makes it flexible enough for countless business types. Custom fields are a big part of that.

QuickBooks makes it possible for your business to create very detailed records for customers, vendors, employees, and items. In fact, you may find that you rarely make use of every field each contains.
But you may also find that there are additional fields that you’d like to see in your predefined record formats. That’s where custom fields come in. QuickBooks lets you add extra fields and specify what their labels should be.

You can define up to 12 total fields for use in customer, vendor, and/or employee records. QuickBooks treats these just as it treats your built-in fields. They appear in the records themselves, of course, and are included when you export a file containing them. You can also search for them in reports.

People Records

There are separate processes for defining fields for your individual and company contacts and your items. Let’s look at how you can set up custom fields for customers, vendors, and employees first.

Go to your Customer Center and open a blank Customer record (in newer versions of QuickBooks, you’ll click on New Customer & Job in the upper left corner, and then click New Customer). Then click the Additional Info tab in the left vertical pane of the New Customer window, then click on the Define Fields button in the lower right. This window will open (with blank fields):

 

QBC 0415 image 1_zps2yqm8twk

Figure 1: You can create up to 12 total custom fields that will be shared by customers, vendors, and employees.

(more…)

Make Your Preferences Known in QuickBooks

The QBC: QuickBooks® Client Newsletter

QuickBooks is ready to use when you install it. But you can change its settings to make it work the way your company needs it to.

There are some features that all small businesses need in their accounting software. Everyone needs a Chart of Accounts and a good set of report templates. There must be tools to bill customers and to document income and expenses. Some companies need payroll management, and some need the ability to create purchase orders. These days, many businesses want to accept payments online.

But what does your company need? It’s unlikely that you would use absolutely every feature that QuickBooks offers, but you need to make sure that every tool you want to use is set up properly.
If you’ve been using QuickBooks for a while, you may have been directed to the Preferences window already (accessible by clicking on Edit | Preferences). If you’re just starting out with the software, it’s a good idea to acquaint yourself with the most important elements contained there. Here are some of them.
QBC0215image1_zpsf849645a

Figure 1: QuickBooks’ Preferences window. Some features are already turned on or off by default, but you can change their status.

(more…)

Creating Item Records in QuickBooks

The QBC: QuickBooks® Client Newsletter

Accurate, thorough item records inform your customers and help you track inventory levels correctly.

Whether you’re selling one-of-a-kind items or stocking dozens of the same kinds of products, you need to create records for each. When it comes time to create invoices or sales receipts, your careful work defining each type of item will:

  • Ensure that your customers receive correct descriptions and pricing,
  • Provide the information you must know about your inventory levels, and,
  • Help you make smart decisions about reordering.

You’ll start this process by making sure that your QuickBooks file is set up to track inventory. Open the Edit menu and select Preferences, then Items & Inventory. Click the Company Preferences tab and click in the box in front of Inventory and purchase orders are activated if there isn’t a check in the box already. Here, too, you can ask that QuickBooks warn you when there isn’t enough inventory to sell. Click OK when you’re finished.

QBC0115image1_zpsdc48f652Figure 1: You need to be sure that QuickBooks knows you’ll be tracking inventory before you start making sales.

(more…)

Year-End Accounting Advice for Small Businesses

Can you believe that the end of 2014 is quickly approaching? Before you know it, it will be time to close your books once again and prepare for year end and the next tax filing season. Instead of waiting for the year to close, here are some tips and strategies to think about now that might make the process easier.

Physical Inventory Count

Schedule a date for a physical inventory count. If you carry some type of inventory, scheduling a date at year-end to take a physical inventory count is essential. Many owners rely on their computer generated reports for an ending inventory balance, but the balance on the report may not be accurate or may require adjustments due to obsolescence or quantity and costing modifications

Auto Usage

Do you use your personal automobile for business? This is the time to update and/or prepare your auto mileage logs to document your business usage.

Bottom Line

Take some time to review and manage your bottom line. It’s easy to get busy with the daily demands of running a business. Often times business owners don’t take the time to step back and look at the overall picture. Has your business had significant changes from the prior year? Has your income changed substantially? What impact could these changes have on your tax liability?

Taxes

It may seem like the distant future, but planning ahead – before year-end – can minimize surprises and allow for proactive measures to be taken. Our small business team will work with you to ensure your bookkeeping is in order, understand your overall tax situation, and identify your priorities.

Software

Are you getting what you need from your accounting software? Selecting and implementing the best system for your business is hardly a one-size-fits-all affair. If you have questions about reporting or if you are considering making a switch, give us a call. We have a team of Certified QuickBooks ProAdvisors® who provide assistance and training to our clients from full scale implementations to daily activities. We have extensive expertise with Quickbooks Enterprise, Enterprise Advanced Inventory, Enterprise Advanced Pricing, as well as Quickbooks Premier and Quickbooks Pro.

Our team has systems experience including Sage 50, Sage 300 (formally Timberline), Microsoft Dynamics, Yardi, Macola, MRI, and Intacct.

Staffing

Are you and your staff struggling to cover basic accounting functions or do you occasionally need higher level expertise? Does your team have the right technical knowledge to identify potential issues and/or recommend solutions? Are you spending too much time supervising your accounting functions?

Our experienced team of outsource CFOs, Controllers, Accountants, and Bookkeepers can help provide your business with quality service. We specialize in providing our clients with  the right person in the right position, whether it be a short term, transitional position or a long term arrangement.

Are you ready?

If you answered yes to any of the questions above or have any additional accounting concerns as year-end approaches, reach out to a professional for advice and assistance. Spending less time on your accounting and knowing you’ll have the information you need, when you need it, enables you to focus your attention on the other critical aspects of your business.

To learn more about Insero & Company’s Small Business and Outsource Accounting Services Group and how we can assist you, please contact me at 585-697-9643.

Page 1 of 212