Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Could you help me by explaining how I can send bills in bulk to Quickbook desktop from an Excel file. Apart from that, I am a developer that you recommend to automate the uploading of invoices and bills from my system.
You can use an importer tool as a workaround and it's a $199 one time license. You can buy it via a partner and you can get $100 cashback.
https://get.transactionpro.com/qbd
For more advanced users that would like to schedule imports into QB Desktop, a full command line interface exists that you can use to start the process even if your company file is not open. These commands can also be used in a batch file, and the process scheduled via Windows Scheduler. You can ask their Support for details and several helpful articles on writing batch files exist in their website as well as helpful videos explaining the process on YouTube.
We appreciate your time posting here in the Community space, Choose. Let me share some insights about importing data to QuickBooks Desktop (QBDT).
Importing bills to QBDT using an Excel file is currently unavailable in the program. As a workaround, consider using the Intuit Interchange Format (IIF) files to import and export your lists and transactions to and from QBDT.
Before importing, back up your company file in case you ever run into problems. You can use your backup to restore your data.
If you're on QBDT for Windows, here's how:
If you're on QBDT for Mac, here's how:
Moreover, we have a dedicated discussion thread for concerns related to the automation of uploading forms in QuickBooks. This is where you can engage with our software engineers and developers. That said, I recommend posting your query on our Intuit Developer Community page.
Here's how:
Please feel free to post here if you're still in need of assistance importing your data or any other concerns in QBDT. I'd be happy to assist you again. Have a good one.
@Choose the type of data you want
RE: Could you help me by explaining how I can send bills in bulk to Quickbook desktop from an Excel file
QuickBooks won't import detailed bills directly from an Excel file. However, you can convert the Excel file to an IIF file for import.
IIF is a highly structured tab delimited text file format. You can technically write one yourself, or use a tool like our BRC IIF Transaction Creator Pro to do it.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here