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.
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
Step 2
Choose Import From Excel
Step 3
Fill in the import form
Step 4
Click Import
Step 5
Match your columns
If you match the same columns often, click Save new template. Next time, pick that template in Select Template.
Step 6
Click Submit
Step 7
Review and submit
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.
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.
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.
Want help? Book a demo. Our team will answer your questions.
This page gives general information. It is not legal advice.