If you have access to the Internet Cash Book screen in Back-office, you can setup the bank statement mapping.
Before importing a bank statement, you will have to set the correct mapping/ layout for the file to ensure the file can import without any errors.
This process can be followed to set up the mapping:
STEPS:
Start by downloading the bank statement:
- Log into the internet banking facilities provided by your bank.
- From the download file options choose the file that is in a .csv (comma separated values) format.
1. In Advantage Back-office, click the left sidebar menu.
2. Click on the Accountant menu.
3. Open the Internet Cash Book screen.
4. Go to the Bank Statement Mapping tab.
5. Select the bank account.
6. Insert the values into the mapping fields using the examples below:
| ABSA | |||||||||
 | |||||||||
| Header rows | 1 | Date field no. | 1 | Date format | yyyyMMdd | Cheque field no. | |||
| Trailer rows | 0 | Description field no. | 2 | Combine fields no's. | Cheque Identifier | CHEQUE | |||
| Field Delimiter | , (Comma) | Amount field no. | 3 | Transaction Type field no. | Cheque No. position from | 8 | to | 20 | |
| First National Bank (FNB) | |||||||||
 | |||||||||
| Header rows | 3 | Date field no. | 1 | Date format | yyyy/MM/dd | Cheque field no. | 5 | ||
| Trailer rows | 0 | Description field no. | 4 | Combine fields no's. | Cheque Identifier | CHEQUE | |||
| Field Delimiter | , (Comma) | Amount field no. | 3 | Transaction Type field no. | Cheque No. position from | 1 | to | 14 | |
| Mercantile Bank | |||||||||
 | |||||||||
| Header rows | 0 | Date field no. | 2 | Date format | yyyyMMdd | Cheque field no. | |||
| Trailer rows | 0 | Description field no. | 1 | Combine fields no's. | Cheque Identifier | ||||
| Field Delimiter | , (Comma) | Amount field no. | 3 | Transaction Type field no. | Cheque No. position from | 0 | to | 0 | |
| Nedbank | |||||||||
 | |||||||||
| Header rows | 4 | Date field no. | 2 | Date format | dd/MM/yyyy | Cheque field no. | |||
| Trailer rows | 1 | Description field no. | 3 | Combine fields no's. | Cheque Identifier | ||||
| Field Delimiter | , (Comma) | Amount field no. | 4 | Transaction Type field no. | Cheque No. position from | 0 | to | 0 | |
| Standard Bank | |||||||||
 | |||||||||
| Header rows | 3 | Date field no. | 2 | Date format | yyyyMMdd | Cheque field no. | 6 | ||
| Trailer rows | 1 | Description field no. | 6 | Combine fields no's. | 5 | Cheque Identifier | CHEQUE | ||
| Field Delimiter | , (Comma) | Amount field no. | 4 | Transaction Type field no. | 5 | Cheque No. position from | 0 | First | 0 |
NOTE: Select the Date format from the list that exactly matches the format in the bank statement file. 7. Press Tab on your keyboard.
8. Click save in the navigation bar:
