Since downloadable bank statements provided by your Bank(s) vary in format and do not conform to any ‘standard’, we need to ‘map’ the fields on the bank statement to the fields we are expecting so that these statements can be used as an upload into the Bank Reconciliation process.
Example
One bank may provide a file where (if you open it as a spreadsheet) it shows the ‘Transaction Date’ in column A (1), and the ‘Transaction Amount’ in column B (2) as a +/- figure.
In a statement format mapping, we would say the ‘Date’ is found in column ‘1’ and the ‘Amount’ is found in column 2 and there is no individual ‘debit’ or ‘credit’ column.
Another bank’s file might have the ‘Date’ in column C (3) and a ‘Debit’ and ‘Credit’ column for amounts in columns E (5) and G (7).
Panel Options
- Standard panel features
- Maintenance
- Views
- Audit – lists data changes made over time to the to the statement format currently being viewed