Managing Inventory in QuickBooks Desktop
ฝัง
- เผยแพร่เมื่อ 30 ก.ค. 2024
- QuickBooks 30-day free trial + 30% off for 12 months:
quickbooks.intuit.com/partner...
(30% discount offer to expire 9/30/2021)
This video (part 1) is meant to cover the basics in Inventory for QuickBooks Desktop, if you want to take an in-depth course on this topic, join my Advanced QuickBooks Desktop Course for $500: hectorgarcia.teachable.com/p/...
Topics contained in this video:
00:00:00 - Intro
00:02:33 - Avalara (sponsor)
00:03:53 - Learning objectives
00:04:22 - Table of contents
00:04:33 - Item types
00:05:03 - Create invoice (how QuickBooks inventory part and non inventory part affects your accounting)
00:05:33 - Create a new item (step by step) (non inventory part) how it works
00:08:15 - Create a bill (vendors, enter bills) (item tab)
00:09:54 - Item list
00:10:02 - Edit item
00:11:56 - Separation between revenue and cost of goods sold
00:12:29 - Balance sheet standard compared with profit and loss
00:13:06 - Item list, modify item (inventory part) (conversion) (converting non inventory part to inventory part) how it works
00:14:56 - Changes on profit and loss and balance sheet
00:15:51 - Quick poll (question)
00:17:19 - How to group inventory for valuation purposes (multiple inventory assets accounts) (item list) (create account type) (chart of accounts) (classify) (example)
00:19:04 - Organizing your item list
00:19:34 - Item list (group items) (sub items) (group sub items using custom fields) (set up custom fields) how it works (example)
00:22:17 - Customize columns and how it works
00:24:43 - Invoice (find and select items)
00:25:22 - Trick to insert item (searching item) (invoice) (shortcut)
00:27:05 - Inventory center and how it works (only available on Premier or Enterprise edition)
00:30:06 - Units of measure and how it works (single units of measure) (multiple units of measure) (create purchase order) (example)
00:38:16 - Quick tip (lb, kg, convert measure) (google)
00:40:17 - Manufacturing (Premier and Enterprise) (inventory assembly items, bill of materials, build assemblies, where used component replacement, raw materials/finish goods, create inventory assembly item, create invoice) how it works (step by step) (example)
00:50:34 - QuickBooks Enterprise component replacement and how it works (where used assemblies)
00:55:01 - Non posting transactions in Pro (estimates, purchase orders, estimate to invoice workflow, pending invoices)
00:55:16 - Non posting transactions in Premier and Enterprise (sales orders, sales order fulfillment worksheet, S.O to P.O workflow)
00:55:44 - Posting transactions (all editions) (decreasing inventory) (increasing inventory)
00:56:02 - Inventory adjustments
00:56:10 - Inventory reports
00:56:35 - What QuickBooks cannot do with inventory
00:57:38 - Inventory (adjust quantity/value on hand) (modify units report) how it works
00:58:35 - Profit and loss and balance sheet
00:59:12 - Inventory add-ons for QuickBooks Desktop
00:59:25 - links
Slides: bit.ly/QBINV
Other Inventory Videos:
-Avg. Cost vs. FIFO In QuickBooks
• Average Cost vs. FIFO ...
-Tracking Landed Cost
• Landed Cost in QuickBo...
-Manage Sales Tax, Surtax, and Use Tax in QuickBooks
• Manage Sales Tax, Surt...
-QuickBooks Online vs. Desktop Inventory Pros and Cons
• Pros and Cons of Quick...
-Enhanced Inventory Receiving Workflow
• NEVER RECOMMENDED: Qui...
-QuickBooks Enterprise Manufacturing Workflow
• QuickBooks Enterprise ...
-QBES Advanced Inventory and Advanced Pricing:
• QuickBooks Enterprise ...
-Dealing with Vendor Pre-Payments:
• Managing Pre-payments ...
Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary fro $195 to $545) for first consultation depending on length and consultant required. E-mail Hector your questions hector@garciacpa.com
Purchase QuickBooks DESKTOP:
www.quickbooksprice.com - วิทยาศาสตร์และเทคโนโลยี
![แล้วแต่เวรแต่กรรม-ครูศรีหนุ่ม [OFFICIAL MV]](http://i.ytimg.com/vi/Xide0fkAS8g/mqdefault.jpg)
Thank you Hector. Excellent explanation & instructions. Finally, I have my own non-inventory correctly & with P & L.
This is VERY helpful! Thanks for moving fast and covering a lot of information!
This is an amazing video! Holy moley, never thought I would be excited to learn accounting.
:)
Thank you for posting hector! a wealth of information as always.
Hi Hector. could you print bard code labels from QB or you need an external software if so how do you implemented and what QB version allows you do do that
Hola Hector, saludos. Quisiera saber si existe la posibildad en inventory assembly de agregar un producto que vendria siendo un item que se va a cortar en varias piezas y los unicos tratamientos que lleva es la mano de obra del corte y lijada del producto...? Si es posible como se haria?
Is there an inventory management system you would recommend for a small retail boutique store that speaks to Quick Books Desktop?
Hi Hector please advise if online plus manages pharmaceutical inventory in terms of batch and expiry tracking for both receiving and invoicing?
Another great video presentation of Hector, the legend.
Hehe thanks
Thanks alot Mr hector
@@HectorGarciaCPA telme your WhatsApp number
Hi Hector, I run a desktop version of QB 2019. I'm trying to track boat sales & expense incurred. Should I use Items as non inventory item or Inventory item? Or, is other current asset is better suited for these transactions. I normally purchase at end of season and sell the following season.
I buy goods in credits and how do I show it and pay latter . So the inventory should show as account payable and when I pay it should clear it.
Thanks for posting hector!
Hi
how we can see the item coast with the different vendors or different invoice if we getting as different prices
Hi Hector
Can I apply my non-inventory to jobs? How do I do that? We use a different system for the actual contract price of our jobs so I use an invoice for that but how do I apply the non inventory material that i am buying in bulk?
Thank you so much for this. It was so helpful.
Thanks you for you video Hector. Can you make a video on allocating overhead cost to inventory.
Hello Hector. I am looking at your awesome videos. A company purchases and keeps snacks in the ABC warehouse and sells them the LF company and the GS company. The company wants the Profit and Loss Report to show profits of each company. For example, the company purchases Dori snacks for $400 and sells them for $200 to the LF company and for $300 to the GS company. The Profits and Loss Report should show Account #4100 LF sales $200, #4200 $300, #5100 Snacks COGS $400.
How do I have to set up the snacks on the Item List? Is it possible to set up so that an inventory in a warehouse can have different income accounts only when the inventory is sold? Thanks in advance!
Thanks for excellant presentation .Do we have option to charge inventory cgs at the time of sales instead of purchase .If so please guide.
I have a small store and I sell online too. The prices are different. Is there an option to have at the same warehouse 2 prices on the same item?
Can I use QuickBooks desktop pro for POS?
HELP!! When I make a PO and buys items . When I go to profit loss it don’t show and amount on that line it has zero as if I don’t purchase it
Hello Hector your video are really helpful, thank you! I currently work for a non profit and we host meal packaging events. We send extra bags of food for just in case scenarios at these events but eventually some of that overage comes back to the warehouse. Do you know if there is any way of receiving inventory back into the system without using the inventory adjustment function?
With a customer credit (credit memo)
The negative quantity inventory adjustments move dollar amounts from the balance sheet and into the cost of goods sold. The end result changes the net income on the P&L. Is this a desired result for adjusting quantities that are not real or negative in the inventory?
Can i added tax in the the bill transaction for the inventory part?
Excellent explanations and content. Thank you Hector.
Glad you find it useful
Do you have a simple process to check in parts. I have used Item>new item & have filled in the proper blanks, to show the part in stock. I have also tried placing a part in stock through billing>credit> item. I fill in the inventory parts section, only to end up with a zero quantity in the end or a negative quantity in the end. What am I missing? Thanks
I am needing that info too
Hey Hector. Thank you for the content! I was wondering, after I tweak the layout of my inventory list, is there a way to lock the list? I sell metal, and I'd like to organize my list to go "smallest to largest" size, so that folks can find items faster. But if someone "resorts the list" it erases all of the changes made. Thank you for your time!
You can rename the items in your list with prefixes such as AA001, AA002, and so on to indicate the "smallest to largest" size. That way you can always sort the list alphabetically by name to arrive at the desired sort that you want.
very informative , i have one question , i have been using QB entreprises for my Cloths manufacturing business, but whenever i add Labor costs per item and FOH in Bill of Material and then do build assembly , costs of Labor and FOH comes in Credit side in my Expense account, can you guide what i am doing wrong as labor cost is also important in item wise profitability.
That sounds right as it is relieving labor and FOH and adding to inventory cost. perhaps you need to assign the labor and FOH account in the Bill of Material so it can charge those accounts.
Hi hector
I'm malti
I'm looking for job in Canada
Here most of the businesses are using QuickBooks
So, I want to learn QuickBooks but I don't know which version should I learn ?
Hector, You Rock!
thanks
Hello Hector -
I have a unique situation. I understand that QB Enterprise 2021 does not allow us to use both a lot number and serial number.
I am creating a manufacturing process. The situation is as per below.
1. Business requires both a batch numbers and serial number. Can I make the default to Serial No. and add a custom field for Batch No.
2. If I make serial number as default, then this is the problem I am running into.
a. I get raw material in bags, but the bags are of varying weight (lbs), each bag is tagged and I need to track each bag through my process.
b. If I get a 500 lbs of raw material, then they can come in 20-30 bags, but when I put 500 lbs on PO and receive it, it will ask me for 500 serial numbers vs 20-30 I have.
You help would be greatly appreciated.
Thanks,
Hello my friend, could you plz help me to know how to issue material from inventory without using invoice ,
What I mean to say is just like the management agree to issue two pieces as marketing
So the entry will be
Dr. Marketing exp ( 2 PCs @ cost )
Cr. Inventory
Hi Hector. Thank you for your videos, they are always very valuable and useful! :) I am experiencing an issue with my inventory management and was hoping you may be able to guide me in the right direction. When I first started off my business, I set up my inventory quantity in terms of Cases (1 case = 12 units). Now that I am changing business model and creating new inventory (which is now reflected in terms of Units instead of Cases) I am having issues because Quickbooks is automatically posting an inventory shrinkage expense when I make my old inventory items Inactive. Do you know how I can avoid this automatic posting to the Inventory Shrinkage account? Thank you in advance!
I don't think i can answer from here... It would require a full diagnosis to see what is going on
Hector, Thank you for the video. Question for you please. Do you have to "build assemblies"? I don't see this happening for us. We build stuff day in and day out. To go to our office manager and tell her every time we build something would be a nightmare. Is there a workaround where we could just have inventory, and sell assemblies and inventory without dealing with entering "build assemblies"? Thanks Chris
If you need to track raw materials as inventory, you need to convert them from raw to finished goods (assemblies) somehow. So I don’t see away around it. Unless you don’t want to track inventory on hand
Does the Pro version of QB 2019 allow for barcode scanning of inventory in and out?
Jeremy Davis no.. Enterprise only.. is like a $2000 difference in price.
I have customized my purchase invoice and sales invoice and added 2 additional fields batch number and expire date but it is not automatically picking up the data of these 2 when i try to sale the items .
It won’t, you have to enter it manually,
Hi Hector, appreciate your webinars and your explanations. Could you make an Video on how to manage inventory in consignment being the consignor? I do find a lot of people having difficulties to manage their goods, being sold in various other places on the basis of consignment. thank you and best regards
You need QuickBooks Enterprise with Advanced Inventory with multiplelocations.
This topic is covered in my advanced training: hectorgarcia.teachable.com/p/quickbooks-desktop-advanced-webinars-premium-archive
Hello Sir I am Doing Degree in Business Administration and I know Basics of Manual Accounting Like JOURNAL ENTRY, LEDGER,TRAIL BALANCE TD, AND PROFIT AND LOSS, BALANCE SHEET, so Am i Eligible for your training or do i require to learn more advanced accounting because i want to help my brother whose a wholesaler for Spare Parts for Automobiles, Sorry for my English as it is not my Native Language, Hope u understood my question.
Is it possible to track financial assets such as stocks, bonds, and options using inventory? How much do you charge to do books or consulting?
Technically yes.. but it’s a lot of work to adjust them all every month/quarter like that.
We do bookkeeping and consulting, but pricing is customized based on your needs. Call the office for a quote 954-414-1524
On your tutorial are you using quick books Pro 2017. Thank you nice job
Yes and Premier as well
Sir, If I use barcode then what should we do?
how to maintain the stationary stock, as well as machinery repair item stock. (without income account)
Not enough information in this question to answer, sorry.
I've learned so much from this video! Thank you!!
Great
Fantastic.... its really a very helpful video
Great/thanks
Hey Hector, i work for a construction company. Having difficulty figuring out how to bill clients for all of the components involved with an epoxy floor.
Would you suggest an inventory assembly or group? (I do not require components to be visible on invoice/estimate) Im working in premier.
Group
Hector, una consulta Quickbook tal vez tendrá una opción para control de fecha de vencimiento de los productos que ingresas al módulo de inventario?
No tiene… pero mira esto; th-cam.com/video/UaYR-uPhc2A/w-d-xo.html
I have a questions regarding seeing inventory vs future Purchase orders. Right now If I have 10 units on hand with 30 coming in in six months but I have orders already for the 30 that will be coming in 6 months my inventory will show negative even though then 10 I have now are available. Is there a way to show inventory but have it take into account purchase orders and the dates around them. I hope this makes some sense. Thanks!
not possible to show open PO's in the available inventory in hand
How do I track expiration dates for my inventory in QuickBooks?
I’ll post a video on that soon
Hey Hector, this is my to-go video on Inventory but today I come with a different question.
Using QB Accountant Desktop: I have a client who buys from me at a Credit of 15 Days and in addition, they're interested in re-selling more of my products at a trial period but as a Conginment note. So I have 2 payment / Trade terms with them.
How do I set up to track inventory out for the consignment notes and when they've sold and paid for various items noting i only want to include my VAT 16% against the consignment sale?
Your assistance will be much appreciated.
This one too many moving parts, cant answer via a comment sorry
Your videos are a lifesaver! However, I am having a hard time using multiple u/m for my items. We sell items by the case, but end up invoicing by the pound. How can I get QB to understand there are 2 measurements used per item? Does that make sense?
Jessica Scott makes sense.. but you can only transact in one U/M
Hey Hector, on the kit assemblies can we just leave both in inventory assets?
Sure..
hi hector, thank you for your content, can i have question? do we have any chances to generate sales with calculated discount in a particular item? they have a report like that? thank you for your time!
Not possible to do discount on the line item
I really liked your presentation, though it was bit fast, since you had only limited time, it was really understandable, felt easy and helping a lot.. Thank you..
Lovely Shankar thanks
Hi Hector. Any advise on inventory management when looking at it from a hire/lease business model? An inventory is needed to keep track of stock, but stock is seldom sold, rather is hired out for a period of days instead. Any advise would be great!
By “hired” you mean you rent the equipment correct?
@@HectorGarciaCPA thanks for the reply Hector! When I say "hire out" I mean we own (for example) a table and would then charge a customer x amount to use that table for a defined period of time. We own the products, and the customers hire them from us. I hope that makes sense? Sorry for the poor explanation
Any further ideas?
Hi Hector. Our company sells services, where heavy machinery is used. We are wanting to set up inventory for machinery parts that are stocked until such time they are used on the machinery at a specific job. We would not sell the machinery parts, but consume them at the time of usage and charge to that job. Can that be accomplished using QB inventory feature and are there proper steps to consume the inventory item, capturing the cost as part of the job cost? Is there a better way to handle other than inventory?
Yes, you need to create the inventory parts and load them at their cost as you buy them.
You must “sell” them at zero sales price to consume them in an invoice or sales receipt
How do i add inventory items for retail clothing store? Every item has different sizes and rate and color?
MOHAMMAD UMAIR JAAN there is no inventory matrix
Hi Hector, thank you for sharing. I have a question, when there are lots of items in inventory (for example retailer business), it is hard to give each item a unique name, it is also hard to remember the item name, especially for new employee, so can i use product bar code as item name? in this way, when issue invoice, just use scanner to scan the product, the bar code will input in the item name space quickly. any advise for using bar code as item name? thanks.
You could yes.
@@HectorGarciaCPA thanks for your quick reply. do you know any side effect if I use bar code as item name? I don't want to mess up in the future. Have you ever use bar code as item name? or do you know anyone has done so?
Onsite Bookkeeping no drawbacks. Works perfectly
@@HectorGarciaCPA Thank you so much. watch lots of your video. all amazing video. God bless you.
Do you have a video on creating and setting reorder points for inventory sites?
I might have covered that in one of the in-depth inventory videos, but can’t recall now
Hector, I appreciate your many videos you have done. they have been a big help in my learning how to use QuickBooks. I am currently subscribed to QuickBooks Online Pro. I run a General Handyman business and have been classifying all the materials I buy to fix toilets, sinks, decks, ceiling fans, Garbage disposals, ect. as Non Inventory items. I am now starting to set up a workshop where I can start creating Chess Boards, Pepper and Salt Grinders, Pens, Kitchen utensils, ect. These materials I want to designate as Inventory Items. I'm looking around and not seeing the menus or selections for things like setting up Raw material boards with selections of different species of wood instead of color as you show in your video. Also the Bill of Materials I'm not finding. Is there another version that I need to get that I'm not finding, or an add on? Thanks for your help.
Raw materials and bill of materials are only in the premier and enterprise editions. pro doesn’t have it
Hi Hector! Thanks a lot for the detailed video. I see a inventory Adjust item under Type column of Inventory valuation detail report. What does this mean? Whether is this automatically calculated by QB or manually entered?
That means the item was adjusted on value or qty at some point (manually entered)
@@HectorGarciaCPA
Thank you! So kind of you for this quick response!!
Hi Hector, I love your videos. They are very informative and practical. Please where can I get the Part 1 of 1 of this particular video? I need it ASAP. Grateful for your kind revert.
This is part 1 of 1
Hector...when tracking non-inventory parts for purchases such as office supplies, etc., would you pick an associated expense account rather than a revenue account (not selling the item)? Thanks.
There is a sales account and an expense account. The one you pick in there will be used based on the transaction type
@@HectorGarciaCPA Thank you.
This is a great video and you the best teacher in this Quickbooks
Thanks.
@@HectorGarciaCPA Hi Hector, I followed your steps to set up my company. However, i have a problem with getting the quantities onto the inventory. For example, My bakery recipe batch produces 5 large, 10 medium, and 50 small breads. Please, how do i set this up to have each type bread instead of the number of batches produced in the quantity column? Thanks
I use Quickbooks premier plus.
Than you Hector you are the best instructor. Now if a company has other five sources other companies meaning the companies are intertwin. How can i handle that in qbb desktop?
There will be a lot of balance sheet transactions
We are in fruits and vegetables business and our inventory is always messed, COGS is not correct any suggestions to improve inventory for fresh fruits and vegetables
Inventory adjustments probably.... without looking at it, is hard to give any more advice.
Great video! This was very helpful. I am struggling to figure out how to apply this to the business of making items from a recipe, then selling the items by the case. We make sausage, and we have several different 200 LB recipe batches that we use. I assume a 200 LB batch would be a sub-assembly. When I run a batch, in the real world, the end result is usually 10-12 20LB boxes of sausage that we then stock in our warehouse and sell to our wholesalers. We also sell individual 1 lb sausages in our retail store or our mail order store. By far our most common unit of sale is a 20 LB box, but we also have 10 LB boxes and individual retail or (group) mail order sales.
I am stuck after I create the sub-assembly batch of sausage. How do I then get my finished goods by the case or by individual sausage links? When we count inventory of finished goods, we count cases, but I can't scale all of my recipe ingredients down to the case level or the individual item level because the quantities of some of them would be less than .001.
We run the retail/mail order batches separately from the wholesale batches.
I feel like I am missing something really obvious here!
What aversion of QB you have? You need enterprise to be able to have a 10,000 variation across units of measure.
I have Enterprise.
Jo Williams then you should be fine.
@@HectorGarciaCPA I still don't get it. I have a recipe of 200+ lbs of ingredients. How do I get the output to be something besides 1 batch?
Very good very helpful
Is the Inventory Center not available in Premier? I don't have an Inventory option across the top of my screen. Running 2019 version.
I realize in the video I'm told it's available only in Premier and Enterprise but I can't access it or find it.
Yes.. as long as you installed the Wholesale and Manufacturing edition or the Retail Edition. If you installed the Contractor, Non-Profit, or General Business editions it won’t be there.
@@HectorGarciaCPA I'll check in the morning. Thank you!
Hi Hector, your video is really helpful! one question i have is, We are a manufacturer of concrete products and i want to setup an inventory item as a (raw material) to be used in an assembly, how come quickboooks asks me for an income account associated with the inventory part if i am not going to sell that part and generate income? we have enterprise and i dont know how to create an inventory item without putting an income account, please let me know if you can help me with this!
thanks!
You still set a sales/income account. But it will never be used if is never sold in an invoice.
Hi Hector, I purchased Raw material inventory process it and want to sell, but I am unable to when I am trying to create a sales order it is showing not stock in QB desktop premier. Please help me solve this. Thanks
You probably need to assemble (Build) the raw materials into the finished good)
Thank you.
I am doing recycling business. Basically just converting raw material into new form as finished goods. My inventory items will be just Raw material and Finished goods with freight in, fright out and all those packaging supplies. What I'm looking for is to be able to record inventory received / tracking both raw material and finished goods by quantity (in Lbs) with unit cost (in USD). we are now using QuickBooks Premier plus 2021 desktop version. Please let me know if I need to upgrade to Enterprise? I do need CPA consulting on set up. I need to get this in place before we start production in around next months.
If you stay with premier, you will need to use the workaround (explained in another video) to add those external costs (shipping, etc) to the components. If you upgrade to enterprise platinum, you can assign specific costs to the the items you receive
Premier will allow you to take multiple components and do the assemblies as the video shows. If you upgrade to enterprise, you will also be able edit those BOM's on the fly
@@HectorGarciaCPA Thank you Sir, I've just sent email to you.
Can you add Lot numbers while on the app and picking your products?
No, needs to be on the desktop app
Hello, Once I have entered an item on a order how do can I tell if there is already an order with that item on it?
You have to look at the history (Ctrl Q)
can you tell me what version did you use?
Enterprise 2016
Question......One of my clients wants to be able to track items but he does not track the physical inventory......Can we set them up as non inventory part or in order to track the items would i have to create an inventory part? .....
Jorge Fraga work non-Inventory you can buy and sell items and be able to track the quantities bought and sold... but not how many you have in stock....
For that it would need to be inventory.
@@HectorGarciaCPA thank you Hector .....you rock......
how to keep inventory for service business.. i mean we are not selling the stock but instead consuming it to provide service to clients.?
Will ‘Adjust the quantity on hand’ serve the purpose?
Yes it could
Thanks..
Hi sir how to quick books Data Import in Tally. Is There A Way To Do This?
I have never done it
great job . do you have anything on avg cost up dating
David Doran Adjust the historical cost of inventory items in QuickBooks Desktop th-cam.com/video/QtXYs9hCTGk/w-d-xo.html
I have followed step by step copy and paste inventory and it only puts info in the very first box. help
Using the Add/edit Multiple items screen?
Excellent!!!
I just upgraded to premier I sell gold and silver and cannot figure out how to do my Troy ounces from 1 ounce down to 1/10th ozt
What impediment are you having?
hola Hector tendrás explicación en español por supuesto con los términos en ingles ?
No tengo
I want to buy an Enterprise version. Please tell me about the cost. and how can I purchase?
It’s an annual cost.. starts around $1600 per year
Very helpful
Thank you sir.
:)
Hi Hector，
How can I get inventory for the restaurant business?
Probably a journal entry is best... tracking inventory (food) usage in QB is hard and too much work for what it’s worth
@@HectorGarciaCPA Hi Hector, How can I write the inventory on journal entry? for example, I have worth 10000 dollars inventory on June and Used 1000 dollars end of July. How can I write in the journal?
Yes
hi , Hector Excellent job !! awesome !! great and easy way to explain ...one question ? I have a retail, smartphones, apple, android, repair, sell , payments every months..I need manage inventory , repair invoice, sales, ..what software do you recommend for small business only one employ .. thanks
angel luis guzman de leon QB Pro
Do you have a part 2?
Jiggsa, LLC not yet.
I Hector Where is the Part 2 of this video? I imagine you also speak Spanish right can you Please do some tutorial of Qk Desktop Entrerprise 2018 in Spanish? for Inventory and how to work in non-profit companies?
Part 2+ is sold as an 8-part series for $500 hectorgarcia.com/advanced
👍🏻 good stuff. When do you have training I have basic to intermediate experience. Would really like training.
My Self if you want deep inventory training in QB Desktop, signup for our webinar series that starts in May 2020
@@HectorGarciaCPA
Ok thanks we will do that
at 26:27 Ctrl-L & Ctrl-U good tricks !
Probably my top favorite
Hola Sra. Hector! I appreciate your videos. Please cover "Desktop" Premier 2018 (Small business accounting). I do not intend on using a required online program or monthly accounting fee program. This is it! I purchased the TaoTronics Barcode Scanner TT-BS030 also. I haven't been able to find a "how to" video specifically for that scanner. Gracias for your time and consideration!
Home Quarters quickBooks premier does not allow scanners
Hector Garcia CPA Gracias for your prompt reply. Would it allow importing from excel?
Home Quarters that is a complex question. The answer is yes, but you may need an addon
Hector Garcia CPA You are awsome. What type of add-on and how? Without having to upgrade in any type of Internet program. I am tired of the Internet programs that do not work if you have no Internet service. That is why I chose the desktop.
Home Quarters there is a few: FishBowl; Acctivate, Handi-fox
Hello Hector. Thank you for the content! The resources you put in a form of websites in your presentation don't work !Can you please send me the resources especially the one that has questions in it ?
Email me your request pleaSe hector@garciacpa.com
Where can I find the part 2 you spoke about at the end of this?
I never published it. I did a paid 8-part series actually
@@HectorGarciaCPA is there somewhere I can find the 8 part series and what is the cost?
@@user-ie7fy1lb1z hectorgarcia.teachable.com/
good job.
Thanks
Do you know the proper steps to take out old inventory that just never sold?
Adjust to zero
@@HectorGarciaCPA that's easy! Thank you.
The assembly cost was 220 but when you built 10 it reflected 2,100 instead of 2,200 in the balance sheet. Also the price of the Assembly was 400 but when creating the invoice it was 360. Can you please explain why?
I wouldn’t pay much attention to the specific math on the examples I used. You do it in your QB and see what happens
@@HectorGarciaCPA Not everyone is having QB on hand while watching this. Some persons actually pay lots of attention to the figures. Even if a user does the same thing you did and arrived at different values, they'll definitely ask questions.
@@jameseze9469 I understand, but the video is too old for me to remember the details
The low character limit of 31 characters for items is such a real weakness of QB for retailers which stocks branded products. The brand name needs to be included in the item name (as there is not a brand name field) and this then means there are not many characters left for the product description. This is a real problem if using QB with software like synder to try and sychronise transactions.
Yeap… its a limitation for sure. But you could use an ITEM:SUBITEM structure and make the parent item the brand
All the time
:)
God you're good..