Cash reconciliation
...
There are two different types of reconciliation that need to be done:
Custody accounts in Bricknode Broker in relation to the custody account at the bank.
Custody accounts in Bricknode Broker in relation to other accounts in Bricknode Broker such as counterparty accounts and customer accounts.
There are different ways to do reconciliation in Bricknode Broker, and we will only show an example of how it can be done. You could also use our add-on reconciliation manager.
Postions > Cash
Balance Dimension: settlement.
-
Balance Date: the day before today's date.
Currency: select a currency or do this selection in the CSVfile.
Click Search and Export to CSV (bottom of the right corner)
Filter the CSV
-file.
In column U (Account.AccountType.Label) we can filter on accounts and column AC (Amount) shows how much cash we have on a specific balance date.
Select only "Custody Accounts" and view Amount.
Do the opposite and select the other account types (like counterparty, holding, and ISK accounts) and sum up the amount. Now we can compare the amounts and if they are the same, the reconciliation is correct.
Instrument Reconciliation
Positions exists in accounts and and are the result of transactions being made for certain assets.
Positions > Instrument (in this example Mutual Funds)
Balance Dimension: Settlement
Balance Date: the day before
Click Search and Export to CSV (bottom of the right corner)
When the export is made to Excel we can make a Pivotable (Insert > Pivo table).
Columns: Asset.ISIN
Rows: Account.AccountType.Label
Values: Amount
We can now compare the positions of custody and customer with counterparty accounts.
