Importing invoices

Welcome back to the QuickBooks Community, Bluemagma1. Yes, there is a way to import customer invoices and vendor bills from an excel spreadsheet into the Desktop. I'll ensure you can perform the process by following the steps below so you can accomplish your goal.

To start with, you'll have to install the QuickBooks Import Excel and CSV toolkit to begin importing a list in the CSV format to QuickBooks Desktop. Beforehand, you can see the details below of what the toolkit contains.

• Import from Excel and CSV Manual – a PDF document with instructions, best practices, and notes.
• CSV Examples Folder – 4 sample CSV files, one for each type of list.
• XLS Example Folder – a sample Excel file containing 4 worksheets, one for each type of list.
• Allowed fields – a reference guide explaining what fields are available for Excel and CSV import.

Then, follow the steps below on how you can start to install the QuickBooks Import Excel and CSV toolkit.

1. Open the file download window for the toolkit and click select Save.
2. Go to your Windows Desktop and choose Save.
3. Double-click QuickBooks_Import_Excel_and_CSV.exe on your Windows desktop to open the WinZip Self-Extractor window.
4. Click Browse and choose the folder where you want to install the toolkit (such as your Desktop). Then, OK.
5. Select Unzip to extract the contents and select Close to close the WinZip Self-Extractor window.
6. Open the QuickBooks Import Excel and CSV folder from the location you selected in step 4.

After that, you can now import customer invoices and vendor bills into the Desktop 2020 version. You can open this article to see the detailed information on how to perform the process: Import and export data in QuickBooks Desktop.

Lastly, you may refer to this article to view steps on how you can run various reports to display all your income and expenses entries from your company file: Understand reports.

Please don't hesitate to click the Reply button below if you have further questions about importing invoices and bills. I'll be here to help, Bluemagma1. Have a great day.

@Bluemagma1 

You need a 3rd party importer tool to do so.

https://transactionpro.grsm.io/qbd

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

Hi ChristiAnn,

Thanks for your help.  I was able to download the kit but unfortunately I'm unable to use it to import invoices into QB's. I have high volume of recurring invoices I need to key in every month and would like  to be able to import it from my excel spreadsheet into QB's.

Thanks for getting back to us, @Bluemagma1.

I want to ensure this is taken care of, but first, could you tell me what error message you get when using the toolkit to import invoices?

In the meantime, we can import your transactions using IIF files. Make a backup of your company file before proceeding, then import IIF files. If you ever have an issue, you can recover your data from your backup.

1. Sign in to your company file as an admin.
2. Note: If you’re in Multi-user mode, go to the File menu, then select Switch to Single-user Mode.
3. Go to the File menu, and then Utilities.
4. Choose Import, then select Import IIF.
5. Select the IIF file you want to import, then click Open.
6. Click OK to confirm the import.

These instructions are also available from our guide on exporting and importing IIF files.

You can also check out this article for more info about setting up data files in QuickBooks Desktop: Import and export data.

Please reach me here if you need further assistance with QuickBooks. I want to ensure your success. Take care, and enjoy your day!

Hello - 

Is there a method to import invoices into the Quickbooks for Mac..(Desktop) Version?

Thank-You

Thank you for taking the time to reach out to us, link.

Yes. There's a way how you can import transactions. I'm here to guide you through the steps.

You can do so by importing them via an Excel file. Here's how:

1. Go to the File menu located in the upper left hand. 
2. Hover the mouse in the Utilities button, then select Import and pick Excel File. 
3. Click either Yes or No.

• Yes- if you want to edit Multiple List Entries
• No- to find the spreadsheets that you created  

    4. Click the Add button on the Add the Product and Services You Sell-side (on the right) window, then hit Browse to locate the file. 

    5. Press Add My Data Now, then review the data.

    6. Pick Import, then click OK when the status window says Import Complete.

To learn more about keyboard shortcuts and what lists and transaction types you can import into QuickBooks, please check these articles for future reference: 

• Keyboard shortcuts in QBDT
• Import and export data

Please know I'm only a post away if you have anything else.