Mapping QB Inventory and Amazon Inventory Worksheets
You cannot view this unit as you're not logged in yet.
6 Comments
John W on March 16, 2019 at 4:05 pm
Vicki, I have some items that were a one time sale items and will never do them again, I deleted them from my Amazon inventory files in an attempt to keep things cleaner. I am one of those who has procrastinated about doing the books part of this and now I need the information on these items (I am sure I will have to enter the transactions individually) so I can make my books balance and for tax purposes. Would I be better off to add them into the excel worksheet “before” I upload it into Quickbooks, or would I be better off to try and add them into Quickbooks after excel sheet is uploaded?
John, it is quicker and easier to add all inventory on the initial upload. I would try to do it in the setup. Of course, if you don’t have the info handy and it will take a while to compile it, you may want to go ahead with the upload and come back in later to do the previously deleted ones. It is better to get all the inventory processes in before you do the invoices to make sure QB costs items correctly.
After this lesson do we need to input the things such as cost, FBA fees, etc into each item? Can our column just be FBA fees instead of breaking it up into Referral, pick and pac, etc?
Hi Jennifer, The accounting system is yours and you can customize it to fit your needs (accounts, processes, etc.). I am just giving you a starting point. Yes, you can just use one column for FBA Fees if you want. The reason for the breakdown shown is to have more pin pointed accounting for the ROI report. The only reason for the columns or custom fields is to use in the ROI report shown at the end of the course. They are just notations, if you will, not “accounting”. The accounting is done in the Chart of Accounts and I would use the accounts shown in the basic setup, unless you already know you have others. You may want to look at the last lesson in the course for the ROI report before you make your decision on the level of breakdown you want.
On the first part of the question….once you do the total download of current inventory, you will only need to input the new items as you purchase them. You can do that individually as shown in the course just like the Sample Item. You can also do a mass update if you are confident in the process you learn by using the copy and paste of mapping. I hope that is not too confusing. You are basically repeating the steps you learn in the course, but only updating the new inventory items. This process would be most helpful for retail arbitrage of multiple items at once. Otherwise, you can just add new items one at a time.
Where did you get the “descriptions” that you pasted in the video? You did not sources them from the inventory download, only the item name. Can the descriptions be user defined as mine are very long for keyword search.
I use the item name from the AMZ download for Item Name, Purchase Description and Description. See the video 1:26 – 2:02. I just copy once and then paste three times. Yes, you can choose to use any description you want. I use the one from AMZ because that is the name they will use to tell me what they sold. I then can type a couple letters and the item comes up quickly to match.
Having the Item Name match AMZ is the important part so that it pulls up with a few clicks of the keyboard. Using the copy once and paste three times just speeds up the process of the mapping portion of the video. The description auto-fills in the inventory item creation page and I just leave it, instead of taking the time to customize my descriptions. Nobody sees those anyway since I do not invoice AMZ directly. (I don’t send them invoices)
Vicki, I have some items that were a one time sale items and will never do them again, I deleted them from my Amazon inventory files in an attempt to keep things cleaner. I am one of those who has procrastinated about doing the books part of this and now I need the information on these items (I am sure I will have to enter the transactions individually) so I can make my books balance and for tax purposes. Would I be better off to add them into the excel worksheet “before” I upload it into Quickbooks, or would I be better off to try and add them into Quickbooks after excel sheet is uploaded?
Thanks
John W
John, it is quicker and easier to add all inventory on the initial upload. I would try to do it in the setup. Of course, if you don’t have the info handy and it will take a while to compile it, you may want to go ahead with the upload and come back in later to do the previously deleted ones. It is better to get all the inventory processes in before you do the invoices to make sure QB costs items correctly.
After this lesson do we need to input the things such as cost, FBA fees, etc into each item? Can our column just be FBA fees instead of breaking it up into Referral, pick and pac, etc?
Hi Jennifer, The accounting system is yours and you can customize it to fit your needs (accounts, processes, etc.). I am just giving you a starting point. Yes, you can just use one column for FBA Fees if you want. The reason for the breakdown shown is to have more pin pointed accounting for the ROI report. The only reason for the columns or custom fields is to use in the ROI report shown at the end of the course. They are just notations, if you will, not “accounting”. The accounting is done in the Chart of Accounts and I would use the accounts shown in the basic setup, unless you already know you have others. You may want to look at the last lesson in the course for the ROI report before you make your decision on the level of breakdown you want.
On the first part of the question….once you do the total download of current inventory, you will only need to input the new items as you purchase them. You can do that individually as shown in the course just like the Sample Item. You can also do a mass update if you are confident in the process you learn by using the copy and paste of mapping. I hope that is not too confusing. You are basically repeating the steps you learn in the course, but only updating the new inventory items. This process would be most helpful for retail arbitrage of multiple items at once. Otherwise, you can just add new items one at a time.
Where did you get the “descriptions” that you pasted in the video? You did not sources them from the inventory download, only the item name. Can the descriptions be user defined as mine are very long for keyword search.
Hi Keith,
I use the item name from the AMZ download for Item Name, Purchase Description and Description. See the video 1:26 – 2:02. I just copy once and then paste three times. Yes, you can choose to use any description you want. I use the one from AMZ because that is the name they will use to tell me what they sold. I then can type a couple letters and the item comes up quickly to match.
Having the Item Name match AMZ is the important part so that it pulls up with a few clicks of the keyboard. Using the copy once and paste three times just speeds up the process of the mapping portion of the video. The description auto-fills in the inventory item creation page and I just leave it, instead of taking the time to customize my descriptions. Nobody sees those anyway since I do not invoice AMZ directly. (I don’t send them invoices)