Hello world!
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
By Leon Clinton
Author: Leon Clinton
Create Assemblies to Bundle Products in QuickBooks
Let’s say you run a home improvement retail outlet, and one of the things you sell is doors. You might sell their parts — door frames, hinges, doorknobs, etc. — individually, in case a customer needs to replace a piece. You may also want to sell all of the individual components as a kit and give your buyer a price break for purchasing them all together.
QuickBooks calls these assemblies; sometimes they’re referred to as kits. Just as you’d create an individual inventory part, you can group related parts together and create an item that you would sell as a package.
A couple of caveats here: You can only build assemblies in QuickBooks Premier and above. If you need this feature and are using QuickBooks Pro, talk to a QuickBooks professional about upgrading. Second, not all of you are using the latest versions of the software so will use QuickBooks Premier 2018 in the examples here.
Under the Hood
Before you can start working with assemblies, check your QuickBooks settings to make sure they’re correct. Open the Edit menu and select Preferences, then Items & Inventory | Company Preferences. Click on the box in front of Inventory and purchase orders are active it’s not already checked. If you want QuickBooks to deduct the quantity of items that have already been entered on sales orders, check that box (we recommend this, so you’re not selling items that have already been promised). Then make sure the button in front of When the quantity I want to sell exceeds Quantity Available is filled in, for the same reason.
Figure 1: Before you start building assemblies, you’ll need to make sure your Company Preferences are marked accordingly.
Creating an Assembly Item
Open the Lists menu and select Item List. Open the drop-down list under Item in the lower left corner and click New. In the window that opens, click the down arrow under Type and select Inventory Assembly. Enter an Item Name/Number in the corresponding field in the window that opens. Don’t check the Subitem of or the I purchase this assembly item from a vendor boxes and ignore Unit Of Measure.
Again, depending on the version of QuickBooks you’re using, you may see different fields in the Inventory Information box at the bottom of this window. But there are some standard elements you should find in this window no matter the version. They include:
- Cost. How much does it cost you to purchase all of the parts for one assembly?
- Sales Price. What will you charge your customers per kit?
- COGS Account. “COGS” stands for Cost of Goods Sold. What account in the Chart of Accounts will you use to track the cost of producing your assemblies? Usually, the default one in QuickBooks is fine.
- Income Account. Which account tracks your sales of this assembly?
- Bill of Materials (BOM). This appears as a table in QuickBooks; it’s a list of all the individual inventory parts that make up the kit, along with their Cost (to you), QTY (quantity required for each assembly), and the total BOM Cost.
Figure 2: Your Bill of Materials Cost is the total of all inventory items required to create an assembly.
The Inventory Information box at the bottom of this window might contain fields for information like the Asset Account, quantity On Hand, and the number of items on purchase orders and sales orders. Once your inventory assembly is saved, it will appear in your Item List.
When you need to actually create kits, you’ll open the Vendors menu and select Inventory Activities, then Build Assemblies. You’ll select the Assembly Item from the drop-down list in the upper left corner, which will open a list of the components needed and their quantity on hand. You’d enter the number of kits you want (the maximum possible appears below the table) and then click one of the Build buttons. The next time you look at the kit in your Item List, you’ll see that its quantity has increased.
The concept of assemblies is easy to understand, but if you haven’t worked with accounts and inventory much, you may find creating kits in QuickBooks to be a bit of a challenge. Inventory levels can be a real problem if they get out of whack, and accounts must be assigned correctly to avoid inaccuracies in reports and taxes. If you need assistance as you get started with this task, please call.
Avoid Refund Delays by Renewing Expiring ITINs Now
ITINs (Individual Taxpayer Identification Numbers) are used by people who have tax filing or payment obligations under U.S. law but who are not eligible for a Social Security number. Under the Protecting Americans from Tax Hikes (PATH) Act, ITINs that have not been used on a federal tax return at least once in the last three consecutive years will expire Dec. 31, 2019. Furthermore, ITINs with middle digits 83, 84, 85, 86 or 87 that have not already been renewed will also expire at the end of the year. Others do not need to take any action.
Affected taxpayers who expect to file a 2019 tax return in 2020 must submit a renewal application by filing Form W-7, Application for IRS Individual Taxpayer Identification Number. With nearly two million ITINs set to expire at the end of 2019, affected taxpayers should submit their renewal applications as soon as possible to avoid refund delays next year.
The IRS began sending the CP48 Notice, You must renew your Individual Taxpayer Identification Number (ITIN) to file your U.S. tax return, in early summer. This notice explains the steps to take to renew the ITIN if it will be included on a U.S. tax return filed in 2020.
Taxpayers who receive the notice after acting to renew their ITIN do not need to take further action unless another family member is affected. ITINs with middle digits of 70 through 82 have previously expired. Taxpayers with these ITINs can still renew at any time if they have not renewed already.
How to Renew an ITIN
Form W-7. To renew an ITIN, a taxpayer must complete a Form W-7 and submit all required documentation. Taxpayers submitting a Form W-7 to renew their ITIN are not required to attach a federal tax return. However, taxpayers must still note a reason for needing an ITIN on the Form W-7.
Family Option. Taxpayers with an ITIN that has middle digits 83, 84, 85, 86 or 87, as well as all previously expired ITINs, have the option to renew ITINs for their entire family at the same time. Those who have received a renewal letter from the IRS can choose to renew the family’s ITINs together, even if family members have an ITIN with middle digits that have not been identified for expiration. Family members include the tax filer, spouse and any dependents claimed on the tax return.
Spouses and dependents residing outside of the U.S.. If your spouse or dependent lives outside the U.S., they only need to renew their ITIN if filing an individual tax return, or if they qualify for an allowable tax benefit (e.g., a dependent parent who qualifies the primary taxpayer to claim head of household filing status.) In these instances, a federal return must be attached to the Form W-7 renewal application.
Important Reminders
As a reminder, the IRS no longer accepts passports that do not have a date of entry into the U.S. as a stand-alone identification document for dependents from a country other than Canada or Mexico, or dependents of U.S. military personnel overseas. The dependent’s passport must have a date of entry stamp, otherwise, additional documents are required to prove U.S. residency.
Federal tax returns that are submitted in 2020 with an expired ITIN will be processed. However, certain tax credits and any exemptions will be disallowed. Taxpayers will receive a notice in the mail advising them of the change to their tax return and their need to renew their ITIN. Once the ITIN is renewed, applicable credits and exemptions will be restored, and any refunds will be issued.
Don’t hesitate to call if you have any questions about renewing ITINs.