Match bank transactions to share trading transaction, work out realized p&l based on FIFO, construct a balance sheet

  • Status Closed
  • Budget $250 - $750 USD
  • Total Bids 13

Project Description

Need to match share trading transactions with bank account transactions

Group similar bank transactions together based on user defined key words

List unmatched transactions

Share trading settles in T+3days. It should match bank transactions on T+3 days, excluding Saturday, Sunday and public holidays

Flexibility to handle different bank account transaction downloads, I.e diff bank has diff column headings. User can specify column names

Flexibility to handle different broker transaction downloads, again user specified column headings

Work out share trading p&l with FIFO principal

Construct a balance sheet

In excel vb code. Must be auditable

Get free quotes for a project like this
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online