Bank Import formats catered for

 

See this article on how to Import bank statements.

 

The following CSV imports formats are catered for:

 

Default format:

First line is the column headings:

Date, Reference, Amount, Balance

With subsequent line as the bank entries

Example: Default

 

ABSA:

First line is the column headings:

Date, Description, Amount, Balance

Example: Absa

ABSA Business integrator

Business integrator example: ABSABusinessIntegrator

 

Bank of New York:

Example: BankofNewYork

Note: Only the closing balance will be validated, since the closing balance (Closing Balance Local) use end of day balance, and is therefore not correct when you have multiple entries on the same day.

 

CIC Bank:

Example: CIC Bank Statement

 

Citi Bank

 

FNB format:

FNB Business Historical: Date, SERVICE FEE, Amount, DESCRIPTION, CHEQUE NUMBER, Balance

Historical Example: FNB_Historical

First two lines is the account details e.g

ACCOUNT TRANSACTION HISTORY

FOR ACCOUNT NUMBER 6534XXXXX

and third line is the column headings

 

FNB Business Interim: Effective Date, Description, Reference, Service Fee, Amount, Balance

Interim Example: FNB_Interim

Forth line is account number and sixth line is the column headings

 

FNB normal online statement:

Historical Example: FNB_Normal

 

Mauritius Commercial Bank:

Example: Mauritius Commercial bank

 

Nedbank:

First 4 lines are account details e.g

Statement Enquiry

Account Number :, 11112222

Account Description : , Some description

Account Statement No :, 1

From the 5 line the detail transaction entries start with no column headings in the following order:

Nedbank 1: Date, Reference, Amount, Balance

or

Nedbank 2: ArbitaryNumber, Date, Reference, Amount, Balance

 

Sasfin:

Example: Sasfin

 

Stadium:

Example: Stadium

 

Standard bank:

Example: Standard Bank

 

Standard bank SWIFT MT942:

Example: SWIFT MT942

 

Standard Chartered Bank

Example: Standard Chartered Bank

 

Last Updated on 12 months ago by Adrienne Dill