I was hoping I could get some insight into this as I could be missing some information. Anyway, importing Paypal CSV, works great. Had issues doing so at first (particularly the date column gave me grief for
some time, anyway fixed now)
So following an import of all my paypal transactions, I now go in and bulk process items, however when doing so for sale, it doesnt give me the option to choose the inventory item from the inventory list so I can expense COGS.
Similarly, short of being able to do the above I go in each transaction and manually process so I can expense the COGS account. However, when I select the inventory, the amount the item sold for get dropped and I have to enter it manually. Now I have worked out that this is due to the fact that I did not put a sale price on my inventory item. So that problem is fixed when/if the sale price is constant, however I have situations where the same inventory item is sold at different prices at different times,
- Is there a way I could have the further options available when buld processing imported transactions e.g. sales>Select inventory item
- How can I avoid the amount being dropped when adding item to the correct expense account
- I found the answer to the last part, which is “Multiple Sales Prices for an inventory items”