Hello, If I import bills there's no Product Name column to it. If I import products and services, there's no way I can connect it to the Bill. How do I connect the two?

kynethjane-kjabi · ‎March 04, 2024

Hello, i need help how to properly import. Our client have Imonggo POS that cant sync with QBO.

We already exported the 10,000 items from the POS then imported it in the Product and Services Template where there is a Quantity Column.

When we tried to Import Bills, we realized there's no way to connect it to the Products per Bill Number. There's only Account Name Column there and Total Amount.

Now that there's additional 5,000 items in the POS. How are we going to Import it now to QBO? Are we still going to use the Product and Services Template? Wont it override what we previously encoded?

And how are we going to Import both Bills and Inventory in a synchronized way without the hassle?

We had already imported Sales but the Import Template only recognizes name, not the Barcode Number. So we cant just override the Quantity by uploading all 15,000 products right?

Please help. Thank you

Carneil_C · ‎March 04, 2024

I appreciate you for laying out the details of your concern, @kynethjane-kjabi.

I'm here to help guide you in the right direction to help you with the importing process into QuickBooks Online.

Please know that QBO depends on the data imported from the POS you've used. With this, I recommend contacting the Imonggo POS Customer Support Team. They can help you configure the integration settings and guide you with an accurate process. This way, you can import those bills seamlessly into QBO.

You can find their contact information on their page or website.

For future reference, I'm attaching this article with detailed instructions on exporting your reports to Microsoft Excel from QBO: Export your reports to Excel from QuickBooks Online.

Please don't hesitate to reply on this thread if you require additional assistance integrating data in QBO. I'll be right there to help you whenever you need it.