If you're using our File Import feature, incorporating rows of remittance onto your check stub allows you to combine multiple invoices onto a single payment. To use this function, you'll need to include in your import file all the things you would normally include when formatting your file. However, when designing your .CSV file there are some other important considerations you'll want to take into account.
- For each new line of remittance you will need a new row on your .CSV file.
- Your file MUST include check numbers. Check numbers are how the File Import feature will identify what is a new line of remittance and what is a new check.
- All rows that are part of the same check/stub should have the same check number.
- For each check number, the DPX system will use the first row bearing that check number to determine the check total, who the check is written to, and the delivery address. This means that these three values must be included in the first row for any given check number (these values can also be in every row for that check number if necessary or convenient).
- While it's not a required field like the amount of the check or who the check is being paid to, this is also true if you are including a Memo Line on your checks.
The image below, and attached to the bottom of this page, is a basic example of what a .CSV file for checks with multiple rows of remittance could look like.
You can see that in addition to the row for headers, this file includes 7 additional rows for check/stub data but will only create two checks; check number 10221 and 10222. The total of each check and the delivery address is listed in the first row for each check number (this file does not include columns for a physical address, but if you are sending Print+Mail checks you can also include those columns). This file does include a blank column for Memo, but it is not a required column and could just as easily be deleted.
Just as with any other File Import, up to eight of any of the columns on this file could also be designated as remittance data during the mapping steps of the File Import process.
Remember that for the File Import process, even once checks are created you have a chance to review them before you choose to Complete Payment or Abandon Import. You should always take the chance to make sure your checks and their stubs appear how you want them to before sending checks.