Import_Checks_Lines_to_skip

Import Checks - Lines to skip

If the import file includes a header row or additional information at the beginning of the file, enter the lines to skip before the check transactions begin. 

Why would you skip lines? 

Header rows

The file may include a header row with column names that you don't want imported as data. 

Example

CheckNumber,Payee,Amount,Date
12345,John Smith,150.00,2024-05-28
12345,Jane Doe,200.00,2024-05-28

In this example, you would set "Lines to skip" to 1 to skip the header row.

Comments or notes

Some files include initial comments or metadata, often marked with a special character (for example, # or //). 

Example
# Payroll check data for May 2024
CheckNumber,Payee,Amount,Date
12345,John Smith,150.00,2024-05-28

In this example, you would set "Lines to skip" to 2 to skip the comment (begins with #) and header row. 

Extra empty lines

Some files have blank or irrelevant lines at the top that need to be ignored to avoid import errors. 

 

Best practices

  • Always preview the file before import to determine how many lines (if any) should be skipped. You can use the import file view (in Import Checks), Microsoft Excel, or Notepad. 

  • If the file has a header row you want the system to use for mapping fields, enter zero to show the header row. You can use it to map the import data, and then change the lines to skip to 1 to remove the header row from the import data. 

  • Use consistent formatting across import files to reduce errors. 

 

 

 

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • 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 ...

    • 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? ...