KnowledgeBase

What Is a Sales Tax Item and How Should I Use One?

Chief Mechanic · September 12, 2010 ·

A sales tax item is a special type of Item, the list of goods and services that you sell. It is used to specify the sales tax rate and the tax authority collecting it that will be charged on each invoice.

See our article on all of the Item types supported by QuickBooks for more information.

Sales tax items can be grouped into another special type of item, a sales tax group, to combine multiple sales tax items on a single invoice.

You should create 1 sales tax item for each tax authority for which you collect tax.

Sales tax items are maintained on the Lists->Items menu. There is a secondary method to maintain sales tax items by visiting the Edit->Preferences menu and choosing the Add sales tax item… button on the Company Preferences tab of the Sales Tax submenu.

Primary Method to Maintain Sales Tax Items

Secondary Method to Maintain Sales Tax Items

QuickBooks Premier 2009 Preferences Sales Tax Items

You can specify the default sales tax item for new customers in the Preferences window. To do so, use the pull down on the Your most common sales tax item selection.

When you add or edit a customer, you can use a sales tax item to specify that customer’s default tax rate. The sales tax item is on the Additional Info tab in the New and Edit Customer windows.

QuickBooks Premier 2009 New Customer Sales Tax Item

When an invoice is created in the Create Invoices window, the sales tax item can be entered for the overall invoice. This value defaults to the sales tax item for that customer, but it can be changed for this invoice only. For example, this capability could be used to apply a different tax rate on a single invoice for a shipment to a location different from the normal location of a taxable customer.

QuickBooks Premier 2009 Create Invoices Sales Tax Item

(No Ratings Yet)

What Is a Sales Tax Group and How Do I Create One?

Chief Mechanic · September 12, 2010 ·

A Sales Tax Group is a type of Item that is maintained on the Item List. It’s used to combine multiple Sales Tax Items (which are themselves another type of Item) into a single sales tax charge on a customer invoice.

See our article on all of the Item types supported by QuickBooks for more information.

Since QuickBooks only supports 1 sales tax code (item or group) on an invoice, a Sales Tax Group is a way to reduce the number of codes needed to invoice a customer. In turn, that reduces the chance of data entry error while at the same time calculating all required sales taxes.

Before you can set up a Sales Tax Group, make sure that you have:

Set the preference to collect and track sales taxes
Already created all of the individual Sales Tax Items that will be combined into a Sales Tax Group

With those steps completed, you can create a Sales Tax Group by completing these steps:

Open the Item List from the Lists->Item List menu selection
Click the Item button in the lower left corner of the Item List window
Select New from the menu or press the keyboard shortcut Ctrl + N
When the New Item window appears, choose Sales Tax Group from the pull down menu
Enter the Group Name and Description
Add all the single Sales Tax Items that make up the Sales Tax Group
As you add the Sales Tax Items, QuickBooks will update the Group Rate, the total tax rate for this Sales Tax Group
Click Ok to save your work

Note:

You may observe a minor display bug in early releases of QuickBooks 2009. Here’s a screenshot from QuickBooks 2009 Premier Accountant Edition R3P. Instead of displaying the Sales Tax Group as a percentage similar to a Sales Tax Item, the Sales Tax Group is displayed as a rounded decimal. In this example, the Sales Tax Group is shown as 0.08 even though it is a combination of East Bayshore and San Domingo, for a total of 0.078, or 7.8%. However, although the Sales Tax Group is displayed incorrectly, QuickBooks calculates the tax total for the Sales Tax Group correctly.

QuickBooks Premier 2009 Sales Tax Group Display Bug

Here’s a similar display from QuickBooks Premier Accountant 2008 R6P, where the Sales Tax Group is shown as a percentage accurate to 2 decimal places:

QuickBooks Premier 2008 Sales Tax Group No Display Bug

This display bug was fixed in later releases of QuickBooks 2009 and doesn’t affect QuickBooks 2010. If you’re running an old release of QuickBooks 2009, update your QuickBooks to the latest release.

(0 rating, 2 votes)

What Is a Sales Tax Code and How Should I Use One?

Chief Mechanic · September 12, 2010 ·

A sales tax code is a list item that is used to set the overall taxable or non-taxable status of both customers and items (goods or services).

You should use sales tax codes to identify a customer, such as a reseller, from which you don’t collect sales taxes, or to identify goods and services that aren’t taxable even to customers who are otherwise taxable.

Sales tax codes are maintained on the Lists->Sales Tax Codes menu. There is a secondary method to maintain sales tax codes by visiting the the Edit->Preferences menu and choosing the Company Preferences tab on the Sales Tax submenu.

Primary Method to Maintain Sales Tax Codes

QuickBooks Premier 2009 Sales Tax Code List

Secondary Method to Maintain Sales Tax Codes

QuickBooks Premier 2009 Preferences Sales Tax Codes

There are only 2 types of sales tax codes: taxable and non-taxable.

If a customer is marked with a non-taxable code, all invoices for that customer are non-taxable. If an item is marked as non-taxable, no sales taxes will be charged for that item even for a customer who otherwise pays sales taxes.

When you add or edit a customer, you can use a sales tax code to specify that customer’s overall taxable status. The sales tax code is on the Additional Info tab in the New and Edit Customer windows.

QuickBooks Premier 2009 New Customer Sales Tax Code

When an invoice is created in the Create Invoices window, the sales tax code can be entered for each line item on the invoice and for the overall invoice. These values default to the sales tax codes for the item and customer, but they can be changed for this invoice only. For example, this capability could be used to eliminate sales taxes on a single invoice for an out-of-state shipment to an otherwise taxable customer.

QuickBooks Premier 2009 Create Invoices Sales Tax Code

(No Ratings Yet)

How Do I Collect and Track Sales Tax?

Chief Mechanic · September 12, 2010 ·

The first step to collect and track sales tax in QuickBooks is to enable the preference to do so.

On the Edit->Preferences menu, select the Company Preferences tab on the Sales Tax submenu.

Click Yes on the Do you charge sales tax? preference.

QuickBooks Enterprise Solutions 10 Preferences Sales Tax

Once the preference is set, you use:

sales tax codes to specify whether a customer or item is or is not taxable
sales tax items to specify the sales tax applicable to a customer or invoice
sales tax groups to combine multiple sales tax items into a combined rate for a customer or invoice

To collect and track sales tax, you’ll need to create at least 1 sales tax item, which you can do directly from the Preferences window.

If you are changing your sales tax preference after you’ve already created customers, inventory, or non-inventory parts, you’ll be given the opportunity to change the tax status of those existing customers and items. When the Updating Sales Tax window appears, choose what you’d like to update and click Ok.

QuickBooks Premier 2009 Updating Sales Tax

This update process will update all customers and all items that are either an inventory part or non-inventory part, so make your decision to update carefully. Decide based on the characteristics for the bulk of your customers or inventory items, because the exceptions will have to be reviewed and changed individually.

(No Ratings Yet)

How Does Quickbooks Online Edition Compare To the Desktop Versions of QuickBooks?

Chief Mechanic · September 11, 2010 ·

Online Edition (OE) is available in 2 versions: Basic and Plus. It offers 3 powerful features:

lower up-front software costs resulting from less expensive, on-demand pricing
reduced burden for installation, maintenance, and support
rapidly scalable access to your accounting data when and where you need it

Generally speaking, OE does not offer the full feature set of the desktop versions of QuickBooks but makes up for those differences by delivering significant cost savings, providing “anytime, anywhere” access to accounting information in a rapidly scalable model, providing built-in rapid support, and eliminating ongoing software maintenance.

We’ve prepared our own QuickBooks Product Comparison for 2009 which provides more details on the exact feature differences between OE and the desktop versions of QuickBooks. OE Basic and OE Plus are compared alongside QuickBooks Pro, Premier, and Enterprise Solutions.

We’ve also written a detailed evaluation of Online Edition that includes screen shots comparing common tasks in both QuickBooks Premier and OE.

(No Ratings Yet)

KnowledgeBase

Accounting

Developer

Intuit