How do I import checks? (2024.11)
Importing checks can streamline payment processing, record-keeping, and reconciliation.
-
Bulk processing and automation. Importing checks allows an organization to process multiple payments at once, saving time compared to manual entry. It reduces errors by automating data entry from digital check files. (Example: Utility deposit refunds)
-
Bank reconciliation. Imported check data can be matched against bank statements to ensure all payments have cleared. Helps detect discrepancies, fraud, or duplicate payments.
This view was updated with a new look and feel in the 2024.08 release. There will be a training webinar coming soon.
Webinar: Check on Demand Refresher Training
Review how to set up and use Check on Demand.
Step 1. Save checks to an export file
Save the checks that will be imported into Check on Demand to an export file (CSV). Make sure the export file includes
-
Check number
-
Payee name
-
Amount
-
GL account (this is optional)
Use Microsoft Excel to open the export file.
-
Review the transaction information.
-
Verify the GL account.
-
Enter corrections and missing information.
Step 2. Set up the import check options
1. Open Connect Check on Demand > Checks > Import Checks.
2. Set up the Import Checks view.
Preview area and Import file fields
3. Click GO (CTRL+G).
Copyright © 2025 Caselle, Incorporated. All rights reserved.
Related Articles
Import Checks - Import file name
Enter the import file name, include the path (d:\myfiles\filename.csv). The import file name is the name of the file that is being used to import data into Connect applications. While the name itself doesn't affect the data inside the file, it often ...Import Checks - Import file type
An import file is used to transfer checks from one system to another. It can be formatted using a comma-separated value or fixed-length field value, also referred to as the import file type. You will need to select the import file type to determine ...Import Checks - Source application
In importing checks, a source application is the Connect application where you want to see the imported checks. What is a source application? It's the system that holds the check data. After the checks are imported into Connect Check on Demand, the ...Import Checks - GL account
Enter a GL account to assign to imported checks that do not have a GL account included in the import file. The GL account tells the system where the expense or payment should be recorded in the general ledger. Why the GL account is important? ...Import Checks - Error report
The error file prints when you import checks and the import process is interrupted. About the error report: The error file will only be created when report or no report is selected. The error file name is "[Import File Name] Errors [HH:MM]" The error ...