top of page

Accounting entries generation

The process to generate accounting entries on the back of a trade population can be seen as a succession of intermediary reports that are calculated in different sheets of a Datascade spreadsheet:

  • Cash payments are listed by categories

    • Trade life cycle payments (upfront premium, coupon payments, option exercise, unwind fees, ...)

    • Other fees (broker fees, clearer fees, etc.)

  • Trade valuations for live trades are updated (reversed and reinserted)

  • Special reserves reflecting various risks for the unrealized P&L can be added

Each column is calculated using simple Spreadsheet formulae. For example if the entity is determined by the salesperson associated to the trade the formula would be:

Thanks to this "spreadsheet driven" approach accountants can clearly see each stage of the calculation process.

Trial balances can be easily obtained from there by configuring a pivot table summing credits and debits by account

Trial balances can be easily obtained from there by configuring a pivot table summing credits and debits by account

The accounting process can be further automated by integrating a reconciliation with broker statements similar to the one described here or by configuring screens for cash adjustments.

Back to the list of finance use cases

​

bottom of page