Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello community,
I'm using QBO Plus with FIFO inventory tracking and I'm looking for a solution for the next scenario:
Each 2-3 months I need to enter to QBO a new vendor's invoice for 500-600 products (a half of existing products and another half is new products).
As I see, the typical solution by QBO is creating a purchase order (for inventory control) and vendor bill (for money tracking). Am I correct?
If I follow this solution, I can import a list of new products and create a purchase order manually. However, doing it manually I spent a lot of time and have a big chance for mistakes.
If I change number of products directly in stock manually, I loose opportunity to track inventory by FIFO and have a chance for mistakes again.
So, the question is:
Is there any way to import vendor's invoices (_not_ bills) OR purchase orders to QBO, as I can import initial inventory?
Thank you.
Hello SergeiG,
Glad to have you message us here. QuickBooks is a versatile program that helps you streamline your accounting with ease. I'll be happy to steer you in the right direction so you can get back to doing what you love.
The function you've described above isn't available. I can see the benefit of having the importing options you've described and I encourage you to send feedback about this to our engineers. You can send feedback by clicking on the Gear icon and looking for Feedback. I recommend searching for a third-party data migration app that can offer more importing options on our app store www.apps.com.
Let me know if you have other questions by leaving a comment below. I'll be one message away.
You can prepare your Purchase Order data with the following template
RefNumber | APAccount | Vendor | PrintOnCheckName | TxnDate | DueDate | SalesTerm | POStatus | ShipMethodName | Class | AddressLine1 | AddressLine2 | AddressLine3 | AddressLine4 | AddressCity | AddressState | AddressPostalCode | AddressCountry | PrivateNote | Currency | ExchangeRate | ExpenseAccount | ExpenseDesc | ExpenseAmount | ExpenseBillableStatus | ExpenseBillableEntity | ExpenseClass | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineBillableStatus | LineBillableEntity | LineClass |
101 | Staples | ######### | ######### | Open | UPS | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | Office Supplies | For Anne | 25.1 | ||||||||||||||||||||
101 | Staples | ######### | ######### | Open | UPS | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | Telephone | Phone Cards | 50.25 | ||||||||||||||||||||
101 | Staples | ######### | ######### | Open | UPS | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | Office Furnitue | New Chairs | 300.18 | ||||||||||||||||||||
185 | Green's Taxi Service | ######### | Net 30 | Closed | 1 Main Street | San Diego | CA | 12345 | Transportation | 125.13 | ||||||||||||||||||||||||
201 | Federal Express | ######### | Net 30 | Open | PO Box 1800 | Dallas | TX | 23456 | Delivery Charges | tracking number PR7 1HX | 25.15 |
then use an importer tool to proceed
https://get.transactionpro.com/qbo
Thank you for the answer.
I left a feedback and I hope that it wouldn't put at the bottom of a backlog.
As a new customer, I was surprised that this root and useful feature still not implemented in QBO.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here