cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Jadallah
Level 2

Import bill from excel with CLass

Dear QBO 

im still new in GBO system 
i try to import bills to system but i wan add class for each bill i find Location but i dnt know how to add the class 
please in attached you can find what i exactly mean 
i already switch on the Class and location 

2 Comments 2
FritzF
Moderator

Import bill from excel with CLass

Welcome back to the Community, @Jadallah.

 

You can import bills in QuickBooks Online (QBO) UKAU, and CA versions. However, the ability to add a class for each transaction is currently unavailable. You can only include a Location.

 

I can see how having this option would be helpful for you and your business. Rest assured that I'll pass along your suggestion to our Product Developers. They're always looking for ideas to consider on how to improve QBO.

 

In the meantime, I recommend visiting our Blog site. This is where we share recent happenings and future developments, such as updates to newly added features.

 

Just in case, I'll add this article for future reference: Common questions about importing data to QuickBooks Online.

 

Please know that I'm only a few clicks away if you have any other questions or concerns. I'll be here to help. Have a good one!

Fiat Lux - ASIA
Level 15

Import bill from excel with CLass

@Jadallah 

Utilize an importer tool to so.

https://transactionpro.grsm.io/qbo

 

The template should be like this

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