|
A Bank Import Template is available on the Documentation page ( |
Format
The file format compatible with the payroll application is Excel (.xls, .xlsx).
Parameters
✓The file size must not exceed 5 MB.
✓The decimal separator in amounts should be the period (.) or the comma (,).
✓A file can only contain data from one company at the time.
✓All data must be included in the first sheet of the Excel file. Other sheets will not be processed.
Column |
Column Headers and Field Descriptions |
A (alphanumeric) N (numeric) |
Length |
Mandatory |
A |
Company Company number. Must match the company selected on the screen. |
A |
8 |
Mandatory |
B |
Employee no. Employee's file number. Terminated employees from previous years are excluded. |
N |
9 |
Mandatory |
C |
Base year. Allowed values: 1900 to 9999. |
N |
4 |
Optional |
D |
Bank Absence code corresponding to the bank. It must exist in the company's bank. Holiday earning are excluded. |
N |
7.2 |
Optional |
E |
Allowed quantity Allowed values: -99,999.99 to 99,999.99. The value is rounded to 2 decimal places. |
N |
11.2 |
Optional |
F |
Allowed amount Allowed values: -999,999,999.99 to 999,999,999.99. The value is rounded to 2 decimal places. |
N |
12.7 |
Optional |
G |
Accumulated quantity Allowed values: -99,999.9999999 to 99,999.9999999. The value is rounded to 7 decimal places. |
N |
11.2 |
Optional |
H |
Accumulated amount Allowed values: -999,999,999.99 to 999,999,999.99. The value is rounded to 2 decimal places. |
N |
12.7 |
Optional |
I |
Eligible quantity Allowed values: -99,999.9999999 to 99,999.9999999. The value is rounded to 7 decimal places. |
N |
11.2 |
Optional |
J |
Eligible amount Allowed values: -999,999,999.99 to 999,999,999.99. The value is rounded to 2 decimal places. |
N |
7.2 |
Optional |
K |
Quantity due Allowed values: -99,999.99 to 99,999.99. The value is rounded to 2 decimal places. |
N |
11.2 |
Optional |
L |
Amount due Allowed values: -999,999,999.99 to 999,999,999.99. The value is rounded to 2 decimal places. |
N |
7.2 |
Optional |
M |
Quantity paid Allowed values: -99,999.99 to 99,999.99. The value is rounded to 2 decimal places. |
N |
11.2 |
Optional |
N |
Amount paid Allowed values: -999,999,999.99 to 999,999,999.99. The value is rounded to 2 decimal places. |
N |
7.2 |
Optional |
O |
Anticipated quantity Allowed values: -99,999.99 to 99,999.99. The value is rounded to 2 decimal places. |
N |
7.2 |
Optional |
P |
Anticipated amount Allowed values: -999,999,999.99 to 999,999,999.99. The value is rounded to 2 decimal places. |
N |
11.2 |
Optional |
Q |
Rate Allowed values: 0 to 9,999.9999. The value is rounded to 4 decimal places. Unlike other fields (where positive or negative values adjust the balance), if the import file contains a valid rate (between 0 and 9,999.9999), it replaces the rate set in the bank parameter. If no rate is specified in the import file, the rate from the payroll application’s bank settings is retained. |
N |
10.4 |
Optional |
Return the Importing employee banks procedure