United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
MW001
Level 1
posted
‎June 29, 2021 02:15 AM
last updated ‎June 28, 2021 11:16 PM

Uploading multiple invoices

May i check if there is a function for uploading of multiple invoices/journals from excel to the quickbook desktop company file for recording of sales/expenses?

 

Current version I'm using is Quickbooks Premier Desktop 2016 version :)

Reply Join the conversation
2 Comments 2
Fiat Lux - ASIA
Level 15
‎June 29, 2021 06:45 AM

Uploading multiple invoices

You have to convert your XLS data to IIF format to import data into QB Desktop

https://quickbooks.intuit.com/learn-support/en-ca/import-or-export-data-files/export-import-and-edit...

 

If you are not familiar with IIF, utilize one of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Prepare the invoice data with the following template

CustomerTransaction DateRefNumberPO NumberTermsClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoCust. Tax CodeItemQuantityDescriptionPriceIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureAR AccountCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000              Non
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50              Non
John's Barber Shope02/09/2020101    Y15/09/2020John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500              

Non

 

Reply Join the conversation
Tammy_H
QuickBooks Team
QuickBooks Team
‎June 29, 2021 01:43 PM

Uploading multiple invoices

Hi MW001,

 

It's terrific to have new members joining the QuickBooks Community. QuickBooks Desktop makes importing data a breeze. I can point you in the right direction.

 

Follow the steps in this article: Import and export data in QuickBooks Desktop.

 

I'm confident that you've got this, but let me know if you need a helping hand.

 

Have a fantastic day!

Reply Join the conversation
Featured
QuickBooks Canada Accountant Hub
Calling all QuickBooks Accountants! We're thrilled to announce the launch o...
Read more
New ROE submission process in QuickBooks Payroll
To learn more about the new record of employment submission process in Quic...
Read more
Quick-Tips FAQ: International Payroll Week
International Payroll Week FAQ Welcome to our special "International Payrol...
Read more

Need to get in touch?

Contact us