Automated coding - Batch

Created by Erik Åkerlund, Modified on Mon, 20 Feb 2023 at 02:29 PM by Erik Åkerlund

Back Office > Automated coding - Batch

Automated coding – Batch

Use at inception after Confirm start and at maturity after Confirm close. All transactions need to have status CONFIRMED (at value) and COMPLETED (at maturity) in order to run Automated coding - Batch.

This is the function for making the automated account coding. The coding is made in batch according to selection criteria for each transaction individually according to accounting instructions. For interim account coding use the Menu item Coding of Unrealised Profit/loss.

Select transaction by Value/maturity date. Transactions with Value- or Maturity date within the Date interval will be processed. It is also possible to select only on Due date and all transactions with payment date within the Date interval will be processed.
Date codes can also be used. Automated coding – Batch is used in conjunction with Confirm Start and Confirm Close.

Differences in debit/credit balance due to rounding can occur for some deals. In System parameters you enter Account number for such differences in Diff account and allowed difference in Diff in balance.

Check box 'Automatic complete'. Automatically set status to Completed and Spot at maturity rate when coding at maturity (run Automated coding - Batch). This setting means that the manual Confirm Close step is skipped.

Note! you need to select by due date From and To when 'Automatic complete' is activated

Check box 'Automatic Journal entries'. Export of journal entries ready simultaneously when running automated coding batch. Allowed difference (max 99/100) in debit/credit balance due to rounding. Account for these differences.

Parameter	Description
Diff in balance	Allowed difference (max 99/100) in debit/credit balance due to rounding.
Diff account	Account for these differences.
Automatic journal entries	Export of journal entries ready simultaneously with automated coding batch.
Automatic complete	Automatically set status to completed and spot at maturity rate when coding at maturity.

Report displaying the result of the Automated coding Batch process

All transactions must be accounted both on value (Confirm start) and maturity (Confirm close). If there is no cash flow in the transaction on the Start date the transaction is DUMMY-coded automatically when the transaction is confirmed in Confirm start. It means that the transaction is marked as coded but no real coding is done. For example FX Transactions are dummy coded at Confirm start since they only have a cash flow on maturity date.

Examples of possible error messages: