cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
sjgroceries-gmai
Level 1

I am a reseller. I am not able to import bills with inventory details. Please provide a sample file with inventory column.

 
2 Comments 2
MaryLandT
Moderator

I am a reseller. I am not able to import bills with inventory details. Please provide a sample file with inventory column.

Good day, sjgroceries-gmai.

 

I'm here to help ensure you're able to import bills in QuickBooks Online. You need a CSV file format to successfully bring in your bills.

 

And, the file requires the following columns:

 

  • Bill no.
  • Supplier
  • Bill Date
  • Due Date
  • Account
  • Line Amount
  • Line Tax Code.

 

You can download the sample format when you import the bill. There's a Download an example option. Click it to get the file.

 

 

I'm adding this article as a guide: Import your bills in QuickBooks Online. It provides instructions and detailed steps to map the columns.

 

You can also browse this article to get answers: Common questions about importing data to QuickBooks Online. You can watch the video tutorial as your virtual guide.

 

Let me know if you have additional concerns about importing bills. Just leave a comment below and I'll get back to you.

Fiat Lux - ASIA
Level 15

I am a reseller. I am not able to import bills with inventory details. Please provide a sample file with inventory column.

@sjgroceries-gmai 

Do you need like this one?

RefNumberAPAccountVendorPrintOnCheckNameTxnDateDueDateSalesTermLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office SuppliesFor Anne25.1           
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  TelephonePhone Cards50.25           
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use        MP3 PlayerBlue MP3 Player255    
185 Green's Taxi Service ######### Net 30 1 Main Street   San DiegoCA12345    Transportation 125.13           
201 Federal Express ######### Net 30 PO Box 1800   DallasTX23456    Delivery Chargestracking number 1234525.15