User Tools

Site Tools


business:auto_bank_reconciliation

Auto Bank Reconciliation File Layout

This file record layout is used to import bank transactions.

Field Length Position Type Description
Bank Account Number121-12NumericLeft-Justified, Zero-Filled
Blank 13-19
Check Number620-25NumericLeft-Justified, Zero-Filled
Amount1226-37NumericLeft-Justified, Zero-Filled, 2 decimal places implied; 00056789 indicates $567.89
Date Paid838-45NumericYYYYMMDD format
Blank 46-49
Record Indicator150AlphanumericOptional; For example: P for Paid, S for Stops, etc.
business/auto_bank_reconciliation.txt · Last modified: 2018/07/24 12:21 (external edit)