Import List of Checks from Excel

Hello @buffalocharters,

As of the moment, there isn't an integrated way to import your list of checks created using an Excel file in QuickBooks Desktop. You can only import a list of names, accounts, and products or services using an Excel File.

With this, let's consider creating an IIF file for your check transactions and import them using the detailed instruction in this article: IIF Overview: Import Kit, Sample Files, and Headers.

Additionally, I've also included this reference for a compilation of articles you can use while working with us: Expenses and Vendors for QuickBooks Desktop.

If there's anything else that I can help you with, please let me know in the comments below. I'll be here to lend a hand.

@buffalocharters 

Prepare the Checks data with the following template

the utilize one of these importer tools

https://transactionpro.grsm.io/qbd

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

Using the import kit, would this be used only for one check transaction at a time, or can multiple checks be entered using new TRNS/SPL rows between the TRNS and ENDTRNS commands?

Hello HomewardBoundWNC!

Thanks for reaching out to us here. Allow me to help you in importing your checks.

Yes, you can import multiple checks using IIF. You'll just need to make sure that the file is in correct format especially the header. You can download and use the .IIF import kit to understand more how to prepare your file.

Here's an article you can review for more details: IIF Overview: import kit, sample files, and headers.

You can always reach out to us here if you have other questions. Take care!

I don't think you can import a list of checks directly from Excel. However, you can use a tool like our BRC IIF Transaction Creator  to create an IIF file from your worksheet data, which can then be imported.