Skip to main content
October 25, 2022
Solved

Importing Bills

  • October 25, 2022
  • 2 replies
  • 0 views

When I import multiple bills into QBO, I can't get the customer/project field or the class field to upload. It is entered on my CSV but just doesn't populate in QBO. I then have to go individually into the bills to add them in by which time I may aswell have just posted the bill manually. Why can't these fields upload or am I doing something incorrectly?

Best answer by JonpriL

I hear you, @collyerconstruction.

 

I'm here to help share insights about the formatting requirements when importing bills in QuickBooks Online.

 

As of the moment, there isn't an integrated way to insert or add a column to select a customer, project, or class while creating a CSV file of bills to import in QuickBooks. For now, we may need to select each transaction information after importing the bills.

 

Kindly read and use this article to learn more about importing bills in bulk: Import your Bills in QuickBooks Online.

 

While I am unable to determine when such a feature like this is added to the program, I recommend getting in touch and letting our product developers know about this by sending a request via feedback. I'll show you how.

 

  1. Go to the Gear icon.
  2. Under Profile, select Feedback.
  3. Describe how inserting such a column showing the customer or project and class for each bill upon importing the CSV file is helping your business in QuickBooks grow.
  4. Select Next.
  5. Click Skip and send message.

 

For now, I'm including our Customer Feedback for QuickBooks Online page to track the status of your request and get the latest updates from our developer team. Updates such as how the recent enhancement made to QBO helps our business owners, like you.

 

It'll always be my pleasure to help if you've got other questions aside from working with your bills and expense transactions in QuickBooks. Use the Reply button and leave your comment below so that I, @JonpriL, can lend a helping hand.

2 replies

JonpriLAnswer
October 25, 2022

I hear you, @collyerconstruction.

 

I'm here to help share insights about the formatting requirements when importing bills in QuickBooks Online.

 

As of the moment, there isn't an integrated way to insert or add a column to select a customer, project, or class while creating a CSV file of bills to import in QuickBooks. For now, we may need to select each transaction information after importing the bills.

 

Kindly read and use this article to learn more about importing bills in bulk: Import your Bills in QuickBooks Online.

 

While I am unable to determine when such a feature like this is added to the program, I recommend getting in touch and letting our product developers know about this by sending a request via feedback. I'll show you how.

 

  1. Go to the Gear icon.
  2. Under Profile, select Feedback.
  3. Describe how inserting such a column showing the customer or project and class for each bill upon importing the CSV file is helping your business in QuickBooks grow.
  4. Select Next.
  5. Click Skip and send message.

 

For now, I'm including our Customer Feedback for QuickBooks Online page to track the status of your request and get the latest updates from our developer team. Updates such as how the recent enhancement made to QBO helps our business owners, like you.

 

It'll always be my pleasure to help if you've got other questions aside from working with your bills and expense transactions in QuickBooks. Use the Reply button and leave your comment below so that I, @JonpriL, can lend a helping hand.

July 7, 2023

@JonpriL "As of the moment, there isn't an integrated way to insert or add a column to select a customer, project, or class while creating a CSV file of bills to import in QuickBooks. For now, we may need to select each transaction information after importing the bills." 

 

Has there been any update on this  as yet I've been forced to move to online from desktop and this is a function I require, I also require to import class with my invoices. 

 

your feedback would be appreciated 

 

thank you 

Fiat Lux - ASIA
July 7, 2023

@Ovec_Anne 

You still need to use the 3rd party tool as I mentioned earlier to import Bills with Class.

 https://get.transactionpro.com/qbo

 

Fiat Lux - ASIA
October 26, 2022

@collyerconstruction 

Prepare your Bills data with the following template

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           

 

then utilize an importer tool to proceed.

https://transactionpro.grsm.io/qbo