cancel
Showing results for 
Search instead for 
Did you mean: 
vkerb20
Level 1

import multiple bills using csv or excel

is there a way to import multiple bills into quickbooks using excel/csv files?

Solved
Best answer February 01, 2024

Best Answers
4Gal
Level 11

import multiple bills using csv or excel

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           

 

then use an importer tool to proceed. It's $199 one time license.

https://get.transactionpro.com/qbd

 

View solution in original post

2 Comments 2
4Gal
Level 11

import multiple bills using csv or excel

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           

 

then use an importer tool to proceed. It's $199 one time license.

https://get.transactionpro.com/qbd

 

vkerb20
Level 1

import multiple bills using csv or excel

Thank you! Will look into the service further.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us