This can be used to create special codes for TRCD bank key source

This might be required where the bank key is not at start of the bank ref or cust ref field

For example, if bank statement shows AP cheque numbers in the Bank Ref field with 10 characters, but only the last 8 characters match our IP1 cheque number (AP Doc#, GL Jnl#, Bank Key). Can use this control file to create a ‘source code’ that picks up from pos 3 of the Bank Ref field..

If the Bank upload procedure is to calculate any commissions then the commission codes must be defined in this control file and specified in TMSBK/***-TRCD. The G/L Account defined in this control will be used to automatically post G/L Journal for the commission.

Identifies which GL accounts are ‘bank accounts’ (for GLO065 EOD interface to bank rec)

For each bank rec group, can optionally nominate default bank key, GL account. MUST setup Journal Rule which identifies if GL account is mandatory, etc.

Only used in GLR040 interim report. Transactions that are given a Report Print Code will print on the
Banking Report. Transactions with the same Report Code will be grouped together and the report will page break by the Report Code. 

Dictates the GL Bank Account used for different payment methods

It also has an “Auto Gen” column which dictates how Bank Rec Key will be assigned to these payments

1. 0 – Do not auto number.
   • Use this for AP Cheques
   • AP Transaction will have separate AP Document Number for each Cheque
   • This will be used as the GL Journal Number and therefore Bank Key
2. 1 = Auto number.
   • Use this for AP EFT payments where we want to group the bank key for entire payment cycle run.
   • AP captures the payment run# as an AP Reference field
   • When posted to GL, this AP Reference (pay run#) becomes the GL journal number, and therefore bank key

This control file defines for each AR pay type

1. GL jnl type, which subsequently also dictates bank rec group (see TMSGL/JNLT)
2. Bank Key Source (batch, reference, date)
3. Whether or not to consolidate entries
   • AR Direct Deposits would normally be setup to use the Reference and NOT consolidate (ie. Create individual GL Journals and “G” bank rec entries
   • While Cash & Cheques would typically use AR Batch# (or maybe Date) and be consolidated to create single entry for the day
4. Company
5. GL clearing account (CR) – “Deposits In Transit”
   • Note that the monthly AR/GL interface – opt 3,25,1 should be setup to DR this same account and CR an AR debtor control account.
   • If client is NOT using Bank Reconciliation and ARO140, then they would setup the monthly AR/GL interface to DR the GL Bank account directly!
6. GL bank account (DR)

Upload bank statement

Various programs exist to accommodate upload of various bank statement formats, e.g. GLO100, GLO105 etc. The BAI or BAI2 format is becoming a global standard (program GLO121). The upload statement program will clear and replace the bank interface file GLBNI00P. Therefore if previous upload has not yet been ‘transferred’ to the Bank rec file, then that will be lost. 

See Bank statement upload programs in Auto Bank Reconciliation document for the details of the various upload programs.

1. All of these programs take the raw bank information and reformat into GLBNI00P bank interface file using TMSBK/XXX-* control tables (where XXX=bank id such as ANZ, WBC etc.)
   1. Main setup is done under TMSBK/XXX-TRCD and TMSBK/XXX-TRCX extension table which ‘map’ bank transactions into appropriate bank rec group, bank key
   2. In some cases, you may want to auto post to a GL account (e.g. Bank Fees, Salary, Gas, Electricity)
   3. All bank statements uploads have following key elements from the bank which can be utilised to try and best identify how to ‘map’ the various transactions into the “B” side of the bank rec
      • Bank Transaction Code
      • Bank Ref
      • Customer Ref
      • Text

Check/review interface file (GLBNI00P)

1. Check the upload to see if any errors (e.g. Transactions that does not have a matching setup in TMSBK/XXX-TRC* control tables).
2. To review GLBNI00P file use GLR040 Bank Statement Print option. The GLBNI00P file is used primarily during the implementation/setup phase of project to check that transactions from the bank have been correctly ‘mapped’ for bank reconciliation.  Check for the following:

• Correct use of DR (withdrawals) vs CR (deposits)
• Appropriate Bank Rec Group assigned
• Most useful Bank Key assigned to facilitate automatic matching off with “GL” entries where possible.
• Allocation to a valid GL account where auto posting is expected (e.g. Bank Fees)
• No transaction in statement that haven’t been defined in TMSBK/XXX-TR* control tables.

3. If there are errors then repeat the bank statement upload after making TMSBK/xxx-TRC* changes. 

Note: During the implementation/setup phase, you can keep repeating the bank statement upload after making TMSBK/xxx-TRC* changes until satisfied with mapping, before transferring to the final Bank Rec file.

 Once the errors are checked and rectified and you are satisfied with the mapping, you can run the option to transfer to the Bank Rec file (GLBNK00P).

 Menu option: Base Modules> General Ledger> Bank reconciliation> Auto Bank Reconciliation> Bank Statement Transfer to GL.

 This program  (GLO030) performs the following.

1. Validates GL accounts
2. Produces exception report (GLO030P1) if invalid account(s) are specified auto posting
3. Moves GLBNI00P data into GLBNK00P bank reconciliation file
   • writes “B” (bank) entries to GLBNK00P
4. Generates GLTR00P journal entries and “G” side of GLBNK00P info where auto posting has been setup in TMSBK/XXX-TRCD
   • Note that these entries must use Bank Key source = 1
5. Where applicable, updates APTR00P cheque transactions with presented date, and writes narrative to AGTXT00P.

If there are no errors then GLO030P2 report has the BANK STATEMENT UPLOAD LIST. This shows more details of what has been uploaded, including GL bank acct, dates, group, bank key, amount, narrative. Also shows the GL Account and journal number for auto postings.

 After the transfer to GL, the interim GLBNI00P file is cleared.