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

Closed

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: trading account accounting, principal group, p&a group, out in public, match list, $l, key bank, c.e. broker, bank accounting and finance, balance sheet in accounting, balance in accounting, account names in accounting, accounting names, accounting bank, 53 bank, match, l & t, finance in excel, FIFO, construct, bank account, construct similar, saturday sunday, fifo code, excel transaction sheet

Project ID: #4616604

12 freelancers are bidding on average $422 for this job

uhostings

Highly interested , experienced and fully capable to prepare your financials based on your trading results , please check inbox for details !

$305 USD in 10 days
(47 Reviews)
5.7
xazoo

Consider it done, professionally. Thanks!

$400 USD in 8 days
(60 Reviews)
5.7
mahaabuzeina

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)
2.7
pawankhurana

hi i am a professional chartered accountant and can do this task very easily you don;t have to worry about the quality of the project . love to deliver quality with in time , so waiting for your positive response check More

$250 USD in 7 days
(5 Reviews)
2.5
caabdul

Sir, I have vast experience in reconciliations and FS preparation of listed companies and ready to do your task, thanks

$280 USD in 3 days
(2 Reviews)
1.8
trueworth

Being a CA, I will be able to assist you.

$555 USD in 3 days
(0 Reviews)
0.0
mvsolution

S888li, Please accept my submission to complete the task you have detailed relating to share trading, profit and loss construction (automated) & balance sheet construction (automated). I have completed a Bachelor of More

$500 USD in 5 days
(0 Reviews)
0.0
Sandip0019

Being a professional accountant I can do it perfectly.

$444 USD in 5 days
(0 Reviews)
0.0
HIGRO

A Team of Highly Qualified Accountants with 5000 Plus Freelance Hours, Ready to assist you.

$750 USD in 7 days
(0 Reviews)
0.0
rudrasourish

Ready to work with experience!

$250 USD in 3 days
(0 Reviews)
0.0
Pulkitagarwal

Hi I would like to bid upon the project. Kindly check your PMB for details Thanks

$290 USD in 4 days
(0 Reviews)
0.0
CATarunGupta

Hello Greetings.

$333 USD in 3 days
(0 Reviews)
0.0
Nickymartin

Hello Hiring Manager, I am a versatile freelancer with experience in accounting and finance. I would love the opportunity to create you P&L and Balance sheet from the given data. Please send me more details so that w More

$555 USD in 5 days
(0 Reviews)
0.0