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


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

Skills: Accounting, Finance

See more: realized, need work, trading account accounting, statement problem example, statement of the problem sample, statement of the problem example, statement of problem sample, statement of a problem, sample problem statements, sample problem statement, sample of problem statement, program problem statement, problem statements example, problem statement sample, problem statements, problem statement format example, problem statement format, problem statement example, problem in accounting, principal of accounting, principal group, posting in accounting, p&a group, out in public, match problem

Project ID: #4651575

11 freelancers are bidding on average $469 for this job


Please check pm

$263 USD in 3 days
(94 Reviews)

Consider it done, professionally. Thanks!

$2000 USD in 25 days
(61 Reviews)

Highly interested and fully capable to prepare and reconcile your financials , please check inbox and contact for details !

$388 USD in 10 days
(46 Reviews)

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.

$250 USD in 3 days
(14 Reviews)

i am working as chief accountant since 12 years & I'm doing remote accounting & business consulting since three years i had experience with several accounting software QuickBooks , Xero , quicken,Myob, with different More

$555 USD in 10 days
(4 Reviews)

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

$330 USD in 8 days
(4 Reviews)

Association of Chartered Certified Accountants Here....Thanks!

$600 USD in 7 days
(1 Review)

Please allow me to do this work done for you and assure will do it in the best possible way!!!

$250 USD in 2 days
(0 Reviews)

Hi I am a chartered Accountant and having great amount of experience in same kind of projects. It will be done in professional manner .

$777 USD in 3 days
(0 Reviews)

well persuing C.A, Final Year. This will be very easy for me.

$555 USD in 3 days
(0 Reviews)

Date: June 23, 2013. Dear sir' I am working as chief of Accounts of a real-estate company since 2004 and I got experience in accounts & finance for the period of 15 (Fifteen) years and also 4 (Four) years audi More

$400 USD in 15 days
(0 Reviews)

Hello, Greetings! Please check your PM for my bid details. Regards

$555 USD in 20 days
(0 Reviews)

Hello, we are expert in development of accounting software. Portfolio include, QuickBooks inventory management software and trust accounting automation software on excel , Based on 60 Macros . For more details , please More

$833 USD in 15 days
(0 Reviews)