Hi, The job is to decipher a monthly statement from a brokerage account and turn them in a list of book entries which can be exported in a general journal which is only single currency capable. The cumulative entries must ensure that the balance of the asset account "Broker Account" reconciles to the end of month NAV provided in the statement.
I expect books entries to following income/expense accounts (in addition to any you need to add):
Interest Expense
Interest Income
Realised Short-Term Capital Gains
Realised Long Term Capital Gains
Unrealised Capital Gains
Realised Foreign Exchange Gains/Losses
Unrealized Foreign Exchange Gains/Losses
You must deliver an excel with a list of the journal entries in the format shown in the attached file with full workings shown and reconcilable to the broker statement.
Let me know if any questions. Happy bidding.
I have worked at an investment company registered in Dubai International Financial Centre in Dubai, UAE. I have been involved in accounting for transactions relating to brokerage, realised and undrealised capital and forex . gains and losses. I also have time on my hands at the moment to start on this task.
Thank you