How to import checks from Excel? 

How to import checks from Excel? 

You can add many checks at once from an Excel or CSV file. This page shows the steps, with a screenshot of each one.

Quick answer: In Payments Out, open the Check tab and click Import checks > Import From Excel. Pick the bank account and your file, click Import, match your columns, then click Submit.

How to import checks from Excel

Before you start, get your file ready. The import window has a Download Sample File link. The sample has one header row and these columns: Date, Check Number, Amount, Memo, Notes, Category Name, Payee Ac #, Payee Address Line 1, Payee Address Line 2, Payee Company, Payee Email, Payee Invoice #, Payee Name, Payee Nick Name, Payee Phone, City, State, Country, and Zip.

Step 1

Click Import checks

In the left menu, under PAYABLES, click Payments Out, then open the Check tab. Click Import checks at the top right.
Check tab in Payments Out with the Import checks button at the top right

Step 2

Choose Import From Excel

The Import Payments window opens. It lists Connected Apps, such as QuickBooks Online, and an Import From Excel option. Click Import From Excel.
Import Payments window with QuickBooks Online and Import From Excel

Step 3

Fill in the import form

  • Source: Bank Account.
  • Select Account: the bank account the checks are paid from.
  • Select File: click BROWSE and pick your Excel or CSV file.
  • Select Template: pick a saved template, or leave No template.
  • Include column heading lines: see the note below.
Import from Excel File window with the bank account, the file and the Import button

Step 4

Click Import

Click Import. The Match Your Data page opens.

Step 5

Match your columns

Above each column of your file is a list that says -- MATCH --. Pick what the column holds. The choices include Payee Full Name, Amount, Date, Payee Adrs L1, Payee Adrs L2, City, State, Zip, Country, Payee Vendor/Account #, Payee Inv#, Memo, Notes, Payee Ph, Payee Email, Payee Company, Check Number, Category Name, Payee Nick Name, Payee Bank Account Number, Payee Bank Routing Number, Payee Bank Account Type, Payee First Name, Payee Last Name, and Payment Method.
Match Your Data page with every column set to Match
Match Your Data page after the columns are matched

If you match the same columns often, click Save new template. Next time, pick that template in Select Template.

Step 6

Click Submit

Click Submit. If a check number is already in use, a window tells you the row numbers and asks if you want to proceed anyway. Click OK to continue, or use the other button to go back and fix the numbers.
Window that warns about duplicate check numbers

Step 7

Review and submit

The Import Checks page shows your rows with a tick box on each. Check the details. The page also has a Process Now button. Click Submit to add the checks.
Import Checks page with the rows to import and the Submit button

Where your imported checks are

The checks show in Payments Out. In our test, each imported check appeared at the top of the list with a Pay button in the Status column.

Payments Out list with two imported checks at the top

About "Include column heading lines"

Our sample file has a heading row. When we chose Yes, the heading row showed on the Match Your Data page as row 1. After we clicked Submit, an Error Rows page listed that row, because the heading text is not real check data. When we chose No, the page showed only the data rows and the import worked. If you see Error Rows, click Back, change this setting, and try again.

Error Rows page that lists a row with an invalid payee email

Common questions

Where can I get a sample file?

In the Import from Excel File window, click Download Sample File.

Can I import from QuickBooks instead?

The Import Payments window also lists QuickBooks Online and other apps. Read Can I import checks from QuickBooks and mail it?.

I need help importing checks.

Call (408) 775-7720 or use the chat box in the lower right corner of the app.

Pay your vendors with ZIL MONEY

Want help? Book a demo. Our team will answer your questions.

This page gives general information. It is not legal advice.