vendor

What Data Is Exchanged Between POS and QuickBooks Financial Software?

Chief Mechanic · August 25, 2010 ·

When you enable the company preference Use with QuickBooks Financial Software on the Edit->Preferences->Company->Financial menu, certain information is exchanged between POS and QuickBooks financial software.

POS 8 Company Preferences Use QuickBooks

Exchanges take place by initiating the exchange from POS by clicking on the menu Financial->Update QuickBooks.

The results of a successful exchange are shown below.

The Financial Exchange window summarizes what has been exchanged.

Some information is exchanged in both directions:

customer information excluding account balances
active vendor information

Once POS is installed and running, inventory transactions are managed in POS. Therefore, most information exchanges occur from POS to QuickBooks. These exchanges are:

customer payments
cash register payouts
sales and order deposits
receiving vouchers
financial impact of inventory adjustments
freight charges on inventory transfers between stores (POS Pro Multi-store)
time clock records (POS Pro)

To provide the ability for management to record some transactions that affect account balances and change customer credit limits, QuickBooks financial software exchanges this information to POS:

customer account balances
customer credit limits

Certain information is not exchanged in either direction:

inventory items and quantities after the initial import from QuickBooks financial software to POS
employees
employee commissions and tips
purchase orders

This information is summarized in this Intuit knowledge base article.

(No Ratings Yet)

What Is a Group Item?

Chief Mechanic · August 23, 2010 ·

In QuickBooks a group item is a specific type of Item that is used to quickly enter a bundle of individual items that are typically bought or sold together where tracking the detail on individual items is desired.

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

It is similar to – but different from – an inventory assembly item, another approach to managing a bundle of individual items. An inventory assembly item is a new item created out of a bundle of individual items, reducing the quantity on hand of the individual items used to create the assembly. Where an inventory assembly item functions like a pre-assembled kit, a group item functions like an “on the fly” kit.

A group item enables a company to track the detail of each individual item in the group while optionally providing a way to simplify information presented to customers and vendors. Data entry is faster because a single group item automatically fills in the information for all of the items in the group.

QuickBooks Premier 2009 Edit Item Group Item

If the Print items in group box is not checked, QuickBooks will print only the group item itself. A customer or vendor will not see the detail on the individual items included in the group. However, company reports will track the detail of each item in the group.

Here’s an example of invoicing for the group item A1 Custom Storage Shed shown above. Entering the single group item automatically added the 2 individual items that make up the group.

QuickBooks Premier 2009 Create Invoices Customize

The price of a group item is the sum of the items in the group; the price of the group cannot be changed directly, but the price of each individual item can be changed.

Sales tax for group items is calculated based on the taxable status of each individual item in the group. In the example above, both taxable and non-taxable items are included in the group.

A group item can include any other item except other groups; it cannot be included in an inventory assembly item. There are no reports for group items. Instead, the detail of each individual item in the group is reported.

(+2 rating, 4 votes)

What Is an Inventory Assembly Item?

Chief Mechanic · August 23, 2010 ·

In QuickBooks an inventory assembly item is a specific type of Item that is the result of putting together a new inventory part out of a bundle of individual items to enable tracking finished goods separately from individual components. Normally, an inventory assembly item is used when separate raw materials are assembled, packaged, and sold as an inventory item that is separate from the component parts.

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

The inventory assembly item type is only available in QuickBooks Premier and Enterprise Solutions. It’s not available in QuickBooks Pro.

It is similar to – but different from – a group item, another approach to managing a bundle of individual items. A group item is a way to quickly add a bundle of items to a form while preserving the ability to track those items individually. Where an inventory assembly item functions like a pre-assembled kit, a group item functions like an “on the fly” kit.

An inventory assembly item is made up of a Bill of Materials (visible by clicking the Full View… button) which can contain a range of item types: service, inventory part, another inventory assembly, non-inventory part, and other charge. Note that a subassembly can be nested within an inventory assembly. However, the Bill of Materials cannot contain these item types: subtotal, group, discount, payment, sales tax item, or sales tax group. Further, there’s a limit of 100 items in the Bill of Materials for an inventory assembly in QuickBooks Premier; for Enterprise Solutions, that limit is 500 items.

QuickBooks Premier 2009 Bill of Materials Full View

The Cost shown for an inventory assembly item should normally not be entered. When a Cost is not entered, QuickBooks will use the Bill of Materials Cost that appears at the bottom of the table.

An inventory assembly is built from its components parts by clicking on the Vendors->Inventory Activities->Build Assemblies menu selection. During the build process, the Quantity on Hand of the inventory assembly item is increased by the Quantity to Build, and the Quantity on Hand of each component is reduced by the product of that item’s Qty in the Bill of Materials and the Quantity to Build.

Builds in QuickBooks can be either pending or final. If there are insufficient quantities of the component parts, a build will automatically be marked as Pending. You can also manually mark a build as pending by clicking on the Edit->Mark Build As Pending menu selection while the Build Assemblies window is displayed. The Pending Builds report (Reports->Inventory->Pending Builds) supports managing future build requirements.

Here’s an example of invoicing for the inventory assembly item Interior Door kit shown above. Unlike a group item, which automatically adds other items to a form and controls whether these other items are printed, the inventory assembly item appears as a single line item on a form.

QuickBooks Premier 2009 Create Invoices Inventory Assembly Item

The price of an inventory assembly item is specified, just like the price of an inventory item, and can be changed directly on a form.

Sales tax for an inventory assembly item is calculated based on the single Tax Code assigned to the inventory assembly.

(0 rating, 2 votes)

What Are Service Items and How Should I Use Them?

Chief Mechanic · August 23, 2010 ·

Service Items are one type of Item and are maintained on the Lists->Item List menu selection.

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

Generally speaking, Items are designed to pre-fill invoicing and purchasing forms. Service Items normally include charges for labor or professional fees that your firm buys or sells. You should use Service Items for those charges for labor and professional fees that you plan to included on invoicing and purchasing forms.

Once you’ve created a Service Item, you can’t change the type to another type of Item, so use care when choosing the Item Type.

The New Item window appears below. How you record values in these fields depends on whether you’re creating a Service Item that you purchase or an Item that you sell. Some fields only appear if you’ve set a preference.

If you’re creating a Service Item used in purchases, record your vendor’s unit price as the Rate and choose an expense account for the Account. If you’re creating a Service Item you sell, record your typical selling price as the Rate and choose an income account for the Account.

Since you’ll have a chance to change the Description on invoicing and purchasing forms, you can either leave the Description blank, enter the most common Description, or create different Service Items for each unique description. QuickBooks stores the actual description recorded on each line of every invoicing and purchasing form, so the Description you enter when recording the Item is only an aid to filling out a form.

QuickBooks Enterprise Solutions 10 New Item

If the Service Item is used in assemblies or performed by a subcontractor or owner, click the checkbox indicating This service is used in assemblies or is performed by a subcontractor or partner. Doing so will allow you to record both the revenue and expense for each Item in separate accounts. Such Items can be used on both sales and purchase forms.

QuickBooks Enterprise Solutions 10 New Item Subcontractor

When you’ve recorded all relevant fields, click Next to save your changes and enter another Item or click Ok to save your changes and close the window.

(+4 rating, 4 votes)

Can QuickBooks Print Checks In Currencies Other Than the US Dollar?

Chief Mechanic · April 2, 2010 ·

QuickBooks 2009 and Enterprise Solutions can print checks in currencies other than the US dollar (USD), with a few words of caution. Each time you attempt to print checks in a currency other than the USD, QuickBooks will display the warning screen shown below. To continue with the printing process, you’ll need to click Ok. There’s no obvious way to turn the warning off, so you’ll see it once each time you print checks from a foreign bank account.

Note that the warning says that QuickBooks only supports printing on “US dollar check templates and other currencies may not match” that template. You can simply order checks for your foreign bank accounts that do match the US dollar check template.

If your preprinted check for each foreign bank account matches the US check template, your checks denominated in a foreign currency will print fine. For example, the normal QuickBooks voucher check prints the check amount to the right of the payee with a pre-printed currency symbol ($ for USD) at the left margin of the check amount. For a check in a foreign currency, QuickBooks will print the 3 letter currency abbreviation before this amount; if you want a currency symbol to appear at the left margin of the check amount, you’ll have to order pre-printed checks with the symbol for the currency used by each bank account.

QuickBooks Premier 2009 Multicurrency Print Warning

Checks will print using the currency for the bank account from which you make the payment, provided the currency for the bank account is either the same currency as the vendor or your home currency. If your vendor transacts in a foreign currency and you record payments from a foreign bank in that currency, your checks will print in that currency. If USD is your home currency and you issue these payments from a USD bank account, QuickBooks will record the bill payment for the amount converted to USD at the exchange rate entered when paying the bill. But you can’t pay a vendor transacting in EUR with British Pound Sterling (GBP) if your home currency is USD.

Therefore, when paying foreign bills in a foreign currency, be sure to select the correct A/P Account and bank Account on the Pay Bills window. If you don’t select the correct A/P Account, the bill won’t appear in the window; if you don’t select the correct bank Account, you’ll make your payment in your home currency.

QuickBooks Premier 2009 Multicurrency Pay Bills

If you inadvertently make payment from the wrong bank account, you can easily fix the error by opening the Bill Pmt – Check transaction for that payment and changing the Bank Account.

QuickBooks Premier 2009 Multicurrency Bill Payment Check

QuickBooks will prevent you from changing the Bank Account to an account denominated in a currency that doesn’t match the customer/vendor or that isn’t your home currency.

QuickBooks Premier 2009 Multicurrency Match Warning

So, if you make sure your check template for your foreign bank matches the US check template and you’re paying foreign vendors in their own foreign currency from a bank account using that same currency – all easy-to-manage considerations, your foreign currency checks will print just fine.

(-1 rating, 1 votes)

vendor

Accounting

Developer

Intuit