Importing Bank Statements Absa

SUGGESTED

Please assist

Imported ABSA bank statement in OFX format - I can see no transactions in the bank - message said bank statement imported correctly - what can be the problem?

  • 0
    SUGGESTED

    Hi 

    The OFX file could possibly be corrupt, unfortunately, because it is an unreadable file, we cannot troubleshoot. I would suggest you either redownload the statement and try again, if this persists, you can download a CSV file and import that rather.

    With a CSV file, please ensure that your CSV file is in 3 columns, the file needs to be formatted with 3 columns
    Date: dd/mm/yyyy
    Description: no double spaces between descriptions.
    Amount: no zero balances
    These are the only three columns that should reflect on the file, anything else can be deleted.

    To check for double spaces in the descriptions, If the descriptions have double spaces, remove them by:
    Highlight the description column, Click on "Ctrl + F" on your keyboard.
    Under find what - click on your space bar twice.
    Replace with - Click on your space bar once.
    Then click on "replace all".

    Click on Replace All until you get a notice that "We couldn't find anything to replace".

    Regards
    Petronella
     
    If my suggested answer has worked for you, please click on verify Answer.