Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi
I am presently setting up QBO.
I have turned on Multi-currency as we purchase our stock in USD and sell in £ and €.
I have inputted all our SKUs and now want to put in the opening stock balances, qty on hand at 01/12/19 and USD/£ rate (manual) .
Where/how to I put in the corresponding USD rate for the 01/12/19?
What is the best way to record my opening stock qty on hand at 01/12/19?
Your help would be greatly appreciated.
Thanks
You can utilize the importer tool to import the stock
https://transactionpro.grsm.io/qbo
https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
Unfortunately the template does not support multi-currency yet
Name | Type | UnitPrice | SKU | QtyOnHand | InvStartDate | InvAssetAccount | SalesDescription | Taxable | PurchaseDescription | PurchaseCost | IncomeAccount | ExpenseAccount |
Handhelds | NonInventory | 100 | Portable Game Player | Y | Portable Game Player | 50 | Product Sales | Purchases | ||||
Software | Service | 59.95 | 1 Year Warranty | Y | 1 Year Warranty | 32.5 | Product Sales | Purchases | ||||
Extended Warranty | Service | 29.95 | 1 Year Extended Warranty | Y | 1 Year Extended Warranty | 15.25 | Product Sales | Purchases |
Hello GJB37,
When you create the stock in the product and service section, click on edit on right hand side> under quality on hand you have the option to click starting value there for that stock item and save.
Stock is always in the home currency, you cant change this.
Cant put multi-currency on the stock, you have to create a transaction for example a expense or bill then can convert it to the currency you want so the USD rate and you can put the date as the 1/12/19. However you need to set up a supplier or customer in the USD currency first.
Thank-you Fiat Lux Asia
However, I have all the SKUs already in and am about to put the qty's in.
However my main issue is the historical USD rate for 01/12/19 that I need to put in against the GBP (home Currency) rate to value the opening stock correctly.
It was easy to do in the old desktop version but I can't find the same option in QBO.
many thanks.
If you really want to record the real cost in USD, consider using an inventory management.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.