Month End Process - Realized & Unrealized Accounting

Realized Accounting

Before starting the Month End process, the Realized Accounting for the month should be completed.

Realized accounting is normally processed every business day (or on weekly basis) and a final check is done before the Unrealized Accounting is run to verify that all Realized Accounting is completed.

Start by opening the 'Accounting' view:

1. In 'Accounting' view - handle all accounting entries in the tabs: 'Error', 'Update FX Rates' and 'Incomplete'.
2. Check that all deals have been confirmed, i.e. open the view 'Confirm' to verify that no deals are listed related to the month to be closed or related to previous months.
3. Approve and Export all Realized Accounting to ERP.

Unrealized Accounting

At Month End, all Unrealized Accounting entries, such as accrued interest, market valuation etc. are created via the function 'Accounting of Unrealized'.

Prerequisites

Before running the Unrealized Accounting, the following checks should be done to make sure all neccessary information is in the system and required steps have been performed:

• Realized Accounting for the month should be completed.
  
• Interest Fixing - verify that all transactions with floating interest are fixed. This is done by open the view 'Fixing'. Make sure all missing interest rates are set before month end. This can be done either from the view 'Fixing' or by running the Autopilot activity. 
• Market Data - validate that the FX Rate table and Interest Rate table include all rates needed for Unrealised Accounting. If there are any rates missing, the tables must be updated. There are two alternative options to consider related to Market Data and Month-End processes;
  • Always have a rate tabled stored for the last date of the month, even if this date falls on a weekend or bank holiday. This can be achieved by copying the rates from the last business day.
  • Use rates from the last business day of the month. Ensure that no incomplete rate table is created for a later date than the expected date of use (e.g., if Easter falls at the end of March)
• Confirmation - Check that all deals have been confirmed, i.e. no deals are related to the month to be closed are listed in the view 'Confirm'.
• Errors - In the 'Accounting' view - make sure there are no accounting entries in the tabs: 'Error', 'Update FX Rates' and 'Incomplete'.
• Report controls - Run Month End Reports to check the figures and that there are no error messages in the reports, i.e. this to make sure all necessary market data is available and that all outstanding deals are fixed etc.  Example of reprots to run: 'FX market value', 'Balance position: Loan FX gain loss, accrued interest, accrued fees' etc

Run Unrealized Accounting

Open the view 'Accounting of Unrealized' (or go via 'Accounting' and 'Code Unrealized' to open the view) 

1. The date of the closest Month End is automatically populated inte the field 'Balance Date' which means that normally there is no need to change this date. 
2. The fields 'FXRate End' and FX Rate End Date Code' is normally left empty. The system will then automatically use the rates from the set Balance Date, or the rates closest prior to the balance date if there are no rates for the balance date (i.e. if last day of month occurs on a weekend or bank holiday). 
3. Market Valuations (if applicable) - the Interest Rate table for the balance date will be fetched, or the date closest prior to the balance date.
4. To generate the Unrealized Accounting, click the button 'Run'.
5. Unrealized Accounting is generated for deals in status Confirmed, New and Modified. But please note that Unrealized Accounting for deals in status 'New' or 'Modified' are not visible in the 'Accounting' view until they are confirmed. 
6. After Unrealized Accounting is run, the created Accounting Entries are visible and handled in the 'Accounting' view. Verify that no Unrealized Accounting are in the tab 'Incomplete'. The error message indicates why the entry is incomplete and possible causes could e.g. be that interest fixing is not done or an FX Rate is missing. When the errors have been corrected, run 'Accounting of Unrealized" again. See also section below - 'Unrealized Accounting in tab 'Incomplete''.
7. All correct unrealized accountings will appear in the tab 'Preliminary' and need to be checked and Approved. 
8. Finally, the accounting entries are exported to be imported in to the ERP system. 
9. NOTE: All unrealized accounting will, when you press Run, also get a reversal accounting the first day of the next month. The reversal accounting also needs to be approved and exported to the ERP system.  
   

Rerun Unrealized Accounting

Open 'Accounting of Unrealized' view, select the correct date and click 'Run'. All already created Unrealized Accounting entries, that are not yet Approved or Exported, will be updated with changes in market data, deals or accounting / dimension rules. If the accounting would not be updated, then delete the existing unrealized accounting on the month end date before you run it again.

NOTE: If the unrealized accountings are approved or exported, then it is not possible to update the accounting. The 'Undo Export' and 'Undo Approved' must be done first. It is possible to  'Undo Approved' in the views 'Accounting' or 'Accounting Overview' but to undo 'Exported' this must be done from 'Accounting Overview'.

Unrealized Accounting in 'Incomplete' 

If a floating rate transaction has not been updated and has "Missing" in Fixing Status, the unrealized accounting will appear in the tab 'Incomplete' in the 'Accounting' view. Then fix the interest and rerun 'Accounting of Unrealized'. 

If FX-rates are missing in the 'FXRATE END' table, the Unrealized Accounting entries will also appear in the tab 'Incomplete' in the 'Accounting' view. Add the missing FX-rates in the table and rerun 'Accounting of Unrealized'.

Rerun of 'Accounting of Unrealized' can be done for all deals or for specific Deal ID(s). The selection of what should be included in the run is defined under Settings. 

Delete Unrealized Accounting

To delete Unrealized Accounting entries for a single transaction, open the deal in question and click 'Accounting' button.

then mark the Unreal Accounting to be deleted (including the reversal) and click Remove.

To delete multiple Unrealized Accounting Entries at the same time, this is easiest done in 'Accounting Overview'.  

In this view, filter on Event Time 'Unreal' and a specific 'Due Date'. Mark all Accounting Entries to be deleted (including the reversal entries) and go to '...' and click 'Remove'.