QuickBooks Desktop: Inventory Assemblies & Importing components (Bill of Materials) from Excel

[@Nate0p0tat0]

Hector, you have helped me so much over the years with my small business. Have you considered doing a video on the tax nexus(or have done already and I’ve missed it) for some of us in states like Oregon whom are new to this law? Thanks in advance!

[@nedswartz9814]

Thanks Hector - this was SUPER helpful!

[@Ledsigncity]

Do you still provide support for the plugin. Im unable to upload all the product assemblies. Only the first is an assembly and remainders are inventory parts. How do i solve

[@HectorGarciaCPA]

Which Plugin?

[@annieli6995]

Hello, for the cost, what if I want to use Total BOM Cost instead of typing in an actual number?

[@sandylamb1329]

Hector. How do I schedule a call with you and what is the cost for 2-3 hour consultation?

[@wilsoncheng8209]

Hi Hector. What version of Quickbooks are you using for this video?

[@scotttreichler3491]

Hector, thank you for the video, I have hundreds of assemblies in my item list. If I delete all of those when creating the IIf to import back in will all my other assemblies still be there after I import the IIF with the new assembly in in?

[@HectorGarciaCPA]

If you adjust them to zero and make them inactive they will remain on the list. But should affect you. You can import the new ones with a different name

[@jamorris88]

Hector how are you able to import components using your macro if they are not already in QB?

[@HectorGarciaCPA]

You need to import the components as inventory parts first

[@viviamoretv5963]

how to find error why build assembly reflected on Profit and Loss? thank you

[@HectorGarciaCPA]

Thats complicated. Hard to answer. I have a long video explaining how to add labor and non-inventory costs to assemblies

[@kimcoelho2669]

Great video, very helpful! Wanted to purchase the Macro File, but nothing came to my email. How else can we purchase the Marco file?

[@HectorGarciaCPA]

If you paid for it, search for “sendowl” in your email

[@kimcoelho2669]

@@HectorGarciaCPA Yeah I wasn't even able to pay for it, I clicked the link and it said failed

[@HectorGarciaCPA]

@@kimcoelho2669 weird. Email me [e-mail]

[@HectorGarciaCPA]

I think i fixed it now, try again.