Month end Realised & Unrealized Accounting

Created by Erik Akerlund, Modified on Mon, 20 Feb 2023 at 02:31 PM by Erik Akerlund

Realised Accounting

  1. In accounting view make sure there is no accounting in TAB Error
  2. Check that all deals have status confirmed before month end
  3. Fixing view update all interest rate missing before month end 
  4. Check FX rate table that there is rates per last business day of month
  5. Approve and export all realised accounting

Unrealised Accounting

During month end all unrealised accounting such as accrued interest, market valuation etc. needs to be booked on the accounts. 

Before running unrealised accounting check that all new deals are confirmed and all floating rate transactions have been updated with the correct interest rate. Unrealised accountings will be run also if Deal are in status New.

To run unrealised accounting during month end follow the steps below:

  1. Check FX rate table that there is FX swap points and interest rate table needed for month end accounting.  
  2. Run reports of the month end accounting (FX market value, Balance position: Loan FX gain loss, accrued interest, accrued fees etc) and check the figures.
  3. Open Accounting view
  4. Click on Code unrealised icon
  5. In due date enter the date for the month end. In FX rate End enter the FX table that should be used to calculate the unrealised FX gain and loss. Usually last business day of the month. 
  6. If discounted market valuation on FX shall be included the IR rate table will be fetch from due or the closest to due date.
  7. Click icon run to preform the unrealized accounting
  8. Make sure no unrealised accounting are in TAB incomplete then either a floating interest or FX rate is missing to do the unrealised accounting. It needs to be deleted, updated and run the realised accounting again on the specific transaction or approve all correct unrealised accounting and then run all deals again. See section Unrealised Accounting in Incomplete Tab below.
  9. All unrealized accountings will be shown in TAB preliminary and needs to be checked, approved and exported to be sent to the ERP system. 
  10. Note, all unrealized accounting will when you press run also get a reversal accounting the first day of next month, as well which needs to be exported to the ERP system.  

Rerun unrealised accounting

Open Accounting / unrealised accoutning select the correct date and click run. All created unrealised accoutning will be updated with the new changes in market data om deals or accounting / dimension rules. If the accounting would not be updated delete the existing unrealised accounting on the month end date before you run it again.

Note, If the unrealised accountings are approved then it is not possible to update the accounting. You have to undo export and undo approved first. 

Unrealised accounting in Incomplete tab

If a floating rate transaction has not been updated, "Missing" in Fixing Status, the unrealised accounting will appear in tab Incomplete in Accounting View. Then fix the interest and rerun Accounting of Unrealised on the specific Deal ID.

If FX-rates are missing in the FXRATE END table the unrealised accountings will also appear in tab Incomplete in Accounting View. Add the missing FX-rates in the table and rerun Accounting of unrealised.

How to delete unrealised accounting

To delete a single or in batch several unrealised accountings:

If it is a single transaction you want to delete then go to the Deal and tab Transactions. Click on "show more actions", choose Accounting and tick the Unreal accounting and click Remove.


To delete several unrealised accounting in one batch. Go to menu Accounting - Accounting Overview. Filter on Event time Unreal and Date time. Mark all accountings and click Remove.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article