SmartFusion Modules > Accounting > Bank Reconciliation > Parameters > Bank Reconciliation File Layouts
SmartFusion Modules > Accounting > Accounts Payable > Parameters > Positive Pay File Layouts

Recent Changes: 
6.161 - Added as menu item to Accounts Payable > Parameters 

6.71 - Modified the CSV export type to filter out double quotes (") and commas from the payee name.

6.66 - Allow the selection of specific fields and add date format capability for CSV files

Introduction

Many banks offer services that can greatly enhance the bank account reconciliation process, such as:

• Providing a file that lists all checks cleared during the current accounting period. Information from this file can be copied into the Bank Reconciliation module to avoid manually entering checks that cleared the bank during the period.
• Accepting a file that lists all checks written for the account during the current accounting period. Banks that accept a file usually use the information to provide a more complete (but more costly) reconciliation service.

In order to send or receive electronic data, information about the files must be defined with parameter files.

Bank File Layout Detail Fields

Bank name
CSV or Fixed Length
Implied decimal
Reverse sign
No carriage returns
Show totals record
Include address1 with payee
Right justify bank account (using zeros)
Bank account pad char override
Track export usage for positive pay
Date format - CSV files only

Code to report for Issues and Action Code
Code to report for Voids and Action Code
Code to report for Non-Voids and Action Code

Wells Fargo Only Fields

Wells Fargo bank id
Include header record
Include footer record
Create Wells Fargo