Import Bank Statements

You will need an electronic copy of your bank statement before you can continue with this step.  This electronic copy can be obtained in various ways but the most common method is to log into your bank’s internet banking website and download it from there.  Please note that we require different file formats for different banking institutions and in some instances also different file formats for different types of accounts within the same banking institution.

Importing a bank statement

It is best practice to rename the files that you download from your banking institution to the following format: YYYYMMDD, for example, 20150315.ofx - it is easier to find these files in the directory when you want to do the import into the system, especially if you do the sorting by name (it will always be the first or last one in the list).  If you have multiple bank accounts, it is also advisable to include an extra character (like an “M” for the Money Market account) in front of the YYYYMMDD, for example, M20150315.ofx so that it could be easily identified.

Finance users will be reminded by means of tasks; to import their bank statements if they have not done so in the last 30 days. Please Note, that the reminders are not per a bank account - therefore if your school has more than one bank account for which you must import bank statements, it remains your responsibility to check for which bank account the notice is applicable.

• Select the bank account from the drop-down menu. 
  
• Select the relevant month and year for the import
  
• Click on the “Choose File” button and browse to the specified folder on your computer or network where the downloaded file was saved.
  
• Select the file that you want to import
  
• Click on the button to " Import " to proceed.
  
• You'll get a message that says " Bank statement successfully imported. Do you want to do a bank reconciliation now? Yes or No "
  
• If you choose ‘Yes’, you will be redirected to the Bank Reconciliation screen where you can capture the imported transactions.  If you choose ‘No’, you will stay on the Import bank statement screen, where you can import a bank statement for another bank account.
  
• In the event that an error occurs, please rectify the problem or contact our support desk for assistance.
  

© Copyright d6 group (Pty) Ltd

• Related Articles

• Cashbook Accounts

  How to create a bank account Click on the create an account button. Enter the account code Enter the account name Choose the date from when the account is active You can add a sub-account if you want to but it's not compulsory Add a description if ...

• Debtor Account Statements

  Debtor & Other Debtor Statements Each learner has an accountable person. Only one account per accountable person can be printed. If there are 2 learners part of one family code but the accountable persons differ there will be then an account for each ...

• Cashbook Report

  Reports > Finances > Transactions > Cashbook Report Type <Ctrl> <F> to search for words in the article How to generate a cashbook report Choose the period for which you want to generate a report for Choose the format of the report by clicking on the ...

• Income Statement

  Reports > Finances > Transactions > Income Statement Type <Ctrl> <F> to search for words in the article. How to generate an income statement Choose with which structure you would like to report. You can choose between Budget Categories or Incomes & ...

• Transfers

   Finances > Cashbook > Transfers Type <Ctrl> <F> to search for words in the article This function enables the user to perform and search for a bank transfer between bank accounts. This function will automatically link bank transfers on your bank ...