cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
RB2008
Level 1

Import Bills including Customer References

Is there an option when importing bills into Quickbooks to include the "CUSTOMER" field to map to the CSV Import file?  This would be so useful as we import hundreds of bills each month and they need to be tracked by customer so that we can run our PLs by customer.

So many good things about QBO yet this seemingly fundamental field box is missing from the Import data mapping boxes.

I'm sure I'm not the only business who needs this function.

 

7 REPLIES 7
Ashleigh1
QuickBooks Team

Import Bills including Customer References

Hello RB2008, 

 

Welcome to the Community page, 

 

Currently, there is not a mapping field for customers for the importing of bills. 

 

We have taken this feedback on board and will pass it on to the developer team. 

Fiat Lux - ASIA
Level 15

Import Bills including Customer References

@RB2008 

Do you utilize the Class feature by customer name?

RB2008
Level 1

Import Bills including Customer References

No, we use sub customers linked to parent billing for each job, I then run PLS for that customer job number and currently need to manually add the customer ref into each expense after importing the expenses.  

RB2008
Level 1

Import Bills including Customer References

Thank you!  This would be such a valuable feature to add this customer field box to the Bills Import Mapping.

Fingers crossed xxx

Stonewood1
Level 1

Import Bills including Customer References

Does this feature exist yet?

 

The fact that the customers need to be inputted manually negates the benefit of the importing process.

Fiat Lux - ASIA
Level 15

Import Bills including Customer References

@Stonewood1 

Prepare your Bills data with the following template

VendorTransaction DateRefNumberBill DueTermsMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerItems BillableUnit of MeasureAP AccountCurrencyExchange Rate
Bell Telephone01/09/2020123#########Net 30Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA Telephone1000Sales Line              
Bell Telephone01/09/2020123#########Net 30Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA Telephone500Service Line              
Ajax Lumber01/09/2020400#########Net 30RepairsAjax Lumber200 Smith Street  AnytownNY11111USA Repairs750Front Door              
Green Taxi Company01/09/2020500#########Net 30Taxi to AirportGreen Taxi Company1 North Street  AnytownNY11111USA       Part 11Part #120  N    
Green Taxi Company01/09/2020500#########Net 30Taxi to AirportGreen Taxi Company1 North Street  AnytownNY11111USA Travel25VT Trip ABC CompanyY           
Green Taxi Company01/09/2020500#########Net 30Taxi to AirportGreen Taxi Company1 North Street  AnytownNY11111USA Travel25CA Trip DEF CompanyN           

 

then use an importer tool to proceed

https://get.transactionpro.com/qbo

 

ChristineJoieR
QuickBooks Team

Import Bills including Customer References

I understand you need to import bills that include the customer column in QuickBooks Online, @stonewood. I can see the relevance and convenience of having this feature for managing your billing efficiently. With that, I'll share the steps to submit feedback. 

 

While importing bills have limited columns available in QuickBooks Online, I would suggest you send a request to our product developer. This way, they'll see your suggestion and consider adding it to the next program update.

 

Follow the steps below:

 

1. You can go to the Gear icon.

2. Under the Profile column, press the Feedback button.

3. Write your product suggestion, then click Next.

 

On the other hand, we can use a third-party application and choose a program that can import bills and has functions that can add additional columns Customer Column. We can visit the QuickBooks App Center. You can find them in the Search bar to locate them. Please ensure to change your region from the upper area of the page.

 

To learn more about using QuickBooks Online, managing your account, and handling invoices and subscriptions, see this article for additional references: Manage billing, payment, and subscription info in QuickBooks Online.

 

I'm eager to provide more information on any Quickbooks-related topic. Please add it in the comment section. May you have a great day.

Need to get in touch?

Contact us