In Progress

400+ transactions Stock profit & loss calculation in Excel

using accounting method, first in first out (FIFO)calculate profit/loss.

see the example in first sheet, 30-40% is already completed as example.

400+ transactions Stock profit & loss calculation in Microsoft Excel

Description

Please take a look at the attached files (this is only an example, the actual sheet that I have has much more approx 418 lines, but I prepared this one for the sake of the example).

3 Files:

freelancer 2006 DCL [url removed, login to view]

freelancer-Stock - DCL ONLY [url removed, login to view] (2 tabs, one short by symbol, another by date)

sample entry [url removed, login to view]

freelance provider prerequisite:

understand stock transactions

understand FIFO accounting methods

understand 1099 form only documents sells of transaction, no information on buying (cost basis)

Jobs:

1. I need to produce another excel that match form 1099’s dates, and other information that needs to complete the “sample entry [url removed, login to view]“

List of things needed are:

1) Descriptions:

2) Gross Proceeds from Gross Sale After Commission and Fees.

3) Cost Basis

4) Date of sale

5) Date of Acquired.

To qualify this job:

Must send sample “answer” calculations from date 6/6/2006 symbol SCHW (high lighted in yellow) about 15 transactions.

Must provide estimated number of hours that will be using for this project and estimate completion date and time.

Some of the works has already been completed.

Additional info:

What solution would you suggest here? Is it possible to produce the sheets using excel or would it need an external software to make this process efficient.

Open to suggestions.

Thank you!

also make mark/notices of the cost basis according to the US stock wash sale rules

http://en.wikipedia.org/wiki/Wash_sale

the stock transaction is "sort by date" which follows the form 1099, that's was one of our goal.

there are 2 tabs, one sort by date, another sort symbol.

we needed you to calculate "cost basis" to match the 1099.

Skills: Accounting, Audit, Data Processing, Excel

See more: stock transactions excel, excel profit loss stock, stock transaction profit loss excel, transaction accounting excel example, calculate stock profit excel, sample excel stock cost basis calculation, profit loss stock excel, accounting sample transactions using excel, stock loss calculation, yellow software, works to freelance, works freelance, what's freelance, what's a freelance job, what are the freelance jobs, v4 jobs, to excel freelance, stock take jobs, stock take freelancer, solution of accounting, software freelance works, software freelancer jobs, software freelancer cost, sheets jobs, sells jobs

About the Employer:
( 0 reviews ) Walnut, Taiwan

Project ID: #859288

22 freelancers are bidding on average $117 for this job

waqar21081974

Please see your PMB

$150 USD in 3 days
(30 Reviews)
5.1
binaryromel

Lets start. Please check PM. Thanks.

$100 USD in 3 days
(39 Reviews)
5.1
UltimateJob

Hi, Plz check PMB. Regards UJ

$100 USD in 1 day
(9 Reviews)
3.8
MZargham

please check PM

$99 USD in 10 days
(3 Reviews)
2.0
techmbapat

plz see pmb

$100 USD in 1 day
(2 Reviews)
1.8
nuraalam

I want to talk with you in PMB for details. I am expert in Excel. So, feel free to discuss. Thanks.

$100 USD in 5 days
(0 Reviews)
0.0
numanpsc

i have good experience in excel. i did this kind of job before that's why i hope i will be given this job

$100 USD in 5 days
(0 Reviews)
0.0
WealthManager

Hi I can do your project. I am a CPA and exposed to various accounting and finance projects. I am looking forward to be working with you. My Bid covers all necessary services. I CAN DO PRESENTABLE EXCEL FILES.

$50 USD in 30 days
(0 Reviews)
0.0
Ranpariya

I am ready for this project please send me details.

$70 USD in 2 days
(0 Reviews)
0.0
musukhan

Immediate Available....Satisfaction Guaranteed...

$80 USD in 2 days
(0 Reviews)
0.0
Alishanuj

I have read the entire description of project and went through all three filesfreelancer 2006 DCL [url removed, login to view] freelancer-Stock - DCL ONLY [url removed, login to view] (2 tabs, one short by symbol, another by date) sample entry [url removed, login to view] The More

$150 USD in 5 days
(0 Reviews)
1.4
imii1981

Its a piece of cake!

$100 USD in 2 days
(0 Reviews)
0.0
Mendisjoachim

As a highly Qlified well experienced Accountant I'm Confident to accept any job.

$80 USD in 10 days
(0 Reviews)
0.0
jayko0228

I am very good in accounting because i am an accounting graduate and I think this is my advantage over the others as well as my deep knowledge in microsoft excel. I hope to do business with your company.

$150 USD in 7 days
(0 Reviews)
0.0
moon6289

thanks.. i agree to work with you.....

$100 USD in 7 days
(0 Reviews)
0.0
abcxyzzz

I work as a Senior Financial Analyst and work on spreadsheets all day every day in excess of 25000 lines. I do spreadsheets like this for my own personal stock and fx portfolio. Please see PM.

$200 USD in 2 days
(0 Reviews)
0.0
Inazir

Thanks for the opportunity, please let me know when you willing to get this done.

$150 USD in 15 days
(0 Reviews)
1.0
sureshk2n

plz check pmb

$100 USD in 7 days
(0 Reviews)
0.0
A3B2

I am ready for this project please send me details. Thanks A3B2

$50 USD in 7 days
(0 Reviews)
0.0
mdislam

Thank you. I Interested your Project. I like to your Project.I ma a hard worker. I have work12 yers Expanse the project. I have a Unlimete men workers. Please give me your [url removed, login to view] me your project 15 days work t More

$100 USD in 15 days
(0 Reviews)
0.0