invoice

How Do I Print a Report of Invoices In Number Order To Identify Missing Invoice Numbers?

Chief Mechanic · August 23, 2010 ·

It’s relatively straightforward to prepare a report of invoices in number order and have QuickBooks automatically identify missing invoice numbers, such as where there are gaps in the sequence of numbers.

The key to preparing this report is to use another report as a building block. Identifying sequential transactions and those items missing from the list are common requirements for Banking reports. That causes the Missing Checks report to come to mind. This report is found on the Reports->Banking->Missing Checks menu selection.

Let’s start with this report. By default, this report asks you to specify a Bank account. Instead, simply choose an Accounts Receivable account.

QuickBooks Enterprise Solutions 10 Missing Checks

With the account selected, set a Filter for the Transaction Type. In the pulldown list on the left side of the Filters window, choose to include transactions having a Transaction Type of Invoice. If you have multiple Accounts Receivable accounts that you’d like to include, you can modify the Filter for Account on this screen as well. Although the Missing Checks report only allows you to select 1 account when first creating the report, you can select multiple accounts at this stage.

QuickBooks Enterprise Solutions 10 Transaction Type Filter

To complete the report, change the Report Title on the Header/Footer tab to reflect the actual contents of the report, which is a list of Missing Invoices.

QuickBooks Enterprise Solutions 10 Missing Invoices Header

The result is a list of invoices in invoice number order with each break in the sequence marked.

QuickBooks Enterprise Solutions 10 Missing Invoices Report

When the report is complete, click the Memorize… button to save these steps that created the report.

(+1 rating, 1 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 Is a Payment Item and How Should I Use One?

Chief Mechanic · August 23, 2010 ·

A Payment Item is a type of Item maintained on the Item list, which is accessed on the Lists->Item List menu selection.

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

A Payment Item is used to record a partial payment on an Invoice or Statement made before the original sale. Payment Items shouldn’t be used on other sale documents, such as Sales Receipts or Credit Memos.

Payment Items are typically used by firms seeking the ability to create a single customer document (the Invoice) that reflects the net balance due on the grounds that a single document showing payments deducted reduces customer confusion and improves collections.

QuickBooks Enterprise Solutions 10 Payment Item

Typically, recording a customer payment via the Customers->Receive Payments window is used to record a full or partial payment received at or after the time of sale. Recording a Payment Item on an invoice is an alternate to this approach to reduce an invoice balance. One common use of a Payment Item is to record a deposit or retainer.

A Payment Item is designed to give you the flexibility to control the account to which it is deposited and to specify the associated Payment Method to enable the payment to be grouped with other similar items into a bank deposit. To specify the deposit account, either select Group with other undeposited funds or select Deposit To and pick an account from the pull-down list of accounts.

The screenshot below shows a Payment Item being recorded in the Create Invoices window. The Payment Item is recorded as a negative number and reduces the Balance Due on the invoice.

QuickBooks Enterprise Solutions 10 Payment Item on Create Invoice

One downside to using a Payment Item is that any reference number information, such as a customer’s check number, is not recorded in the typical field for such information, the No. field. Instead, the No. field is populated with the Invoice number.

For those who favor using a Payment Item, the advantage of being able to produce a single document (the Invoice) that reflects a customer’s net balance outweighs these shortcomings.

(+1 rating, 3 votes)

invoice

Accounting

Developer

Intuit