Contents

Bank Reconciliation Take-on

Caroline Buckland Updated by Caroline Buckland

Overview

The Bank Statement Take-on process is used to import electronic Bank Statement files into the General Ledger. Bank transactions are posted to the full GL bank account code as defined on the Bank Codes Table and to the Bank Statement Balance Class as defined on the Bank Reconciliation Company Controls.

Load the Bank Statement File – 2 stage process

Ensure that you have placed the bank statement file into Files Management and that it is the next consecutive file to be processed, then, within the Bank Statement Take-on menu initiate the 'Run Bank Statement Load’ process.

Menu access: Bank Reconciliation-Bank Reconciliation Processes-'Run Bank Statement Load’ process.

The screen displayed will show screen MQRA:

Enter the following:

  • Bank Company - company code for the file load
  • BACS Calendar - this calendar will default and represents week days
  • Override Date Check? - files should loaded in daily but if not, or the file you load in may not have transactions that fall on the next consecutive day the override date check allows you to load in a file that skips a day. 
     So if the bank date is 09/10/2025 and the next date in the file for a transaction is the 11/10/2025 then you would need to toggle that on so it lets you skip the 10th 
  • Name of Statement Import File - STATXX - where xx is the company code

Use the Submit button followed by Submit again.

Once the mapping has finished (should be within a couple of minutes), then, within the Bank Reconciliation Statement Takeon menu select ‘Review Bank Statement Report’ and ensure that the transactions processed and resulting balance look as you would expect.

Once the process has run and you are happy with the control report, then initiate the ‘Bank Statement Takeon’ from the Menu.

Menu access: Bank Reconciliation-Bank Reconciliation Processes-Bank Reconciliation Statement Takeon-Bank Statement Takeon

Enter the Company Code and Bank Code.

Select the Submit button followed by Submit again.

The statement load process will be actioned in background.

Successful completion of the take-on process will result in: -

  1. An email to the User indicating process success or failure (if requested)
  2. A report of statement details in report REWI01 (including error condition)

  1. The transactions being recorded in the General Ledger under the Bank Statement Balance Class (RA), the Bank Account (Full GL bank account code) and the Bank Statement Batch Type (BRSD).
  2. Updating of the Bank Closing Balance value and Bank Statement Date on the Bank Code screen (ME03).

Was this article useful?

Manual Bank Reconciliation

Unmatching Transactions

Contact