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
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).
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)
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:
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.
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.
also make mark/notices of the cost basis according to the US stock wash sale rules
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.
22 freelancers are bidding on average $117 for this job
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.
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
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.
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.