This is a re-posting of the project. I do not think that i have given enough detail to award the project. This is a project for a programmer with good accounting or access to accounting skills. I will attach a few files as a example. The outcome of the project is having an excel vb program which
1. read in broker and bank transaction details
2. match broker to bank settle trades, including options trading
3. prepare trading result, realised pnl based on FIFO matching.
4. any un-matched bank transactions be listed in a separate sheet
5. construct a PnL statement and a balance sheet
6. there should be a config sheet such that you vb routine can handle multiple brokers and multiple bank statements in csv format
When you bid for the project, please outline how you are going to tackle the problem. Sample files are attached. Below was the original project listed.
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
11 freelancers are bidding on average $469 for this job
It's my pleasure to bid on this project. I am qualified CIMA and have relevant experience. I have gone through your requirement and I assure that assignment shall be completed swiftly. You may check PM for detail.
An experience Accountant is ready to perform this job,I have strong background in Accounting and Finance,Kindly consider my bid for your Top Notch Quality Work,Thanks