The data files typically would be created from within your accounting software by export a check register that is saved to a Excel or CSV (comma delimited) file.
At a minimum, you will need to create a file with the following fields:
Click the Open Folder Icon on the General Ledger Import Wizard.
Select your file to Import and click Open. Common file types are Excel and comma delimited (csv) files.
Click Next.
The Column Mapping screen allows you to select the appropriate column mapping from the drop down for the data. There will be a video to show you how to do this the first time.
Then select NEXT
Then NEXT again after you review your records in this screen.
The Invalid Rows section will list all rows that will not be imported. The software will automatically mark Header rows, footer rows, summation lines, and blank lines as invalid. For each row that is invalid, a check mark will be placed in the appropriate column indicating why the row was invalid.
Once you have verified the importable information is accurate, click Next. If you wish to Cancel the import process and try again, simply hit Cancel.
Click Finish to complete the Import Wizard.
Next Step
You are now ready to create and transmit your file.
Click the Create File button in the center of the homepage.
Then select Create Issue file.
Then you can view your file by selecting Yes. Remember to send your file to the bank!