Kapalı

Work out profit and loss on each stock code and altogether from buy and sell records for each month Excel records on daily stock trading transactions to monthly tabs submitted monthly to record profit and loss

An spread sheet with some months done is prepared.

Receive a master Excel spreadsheet and stock buy and sell transactions in a separate Excel spreadsheet and copy the transactions into the master to produce a profit and loss statement for each transaction and carry forward any unsold transactions to the next month.

The first few months for last financial year has been done as an example.

I might buy 10,000 of stock X in January and sell 5,000 of stock X in January at a profit. 5000 of stock x are carried forward to February. Then 4000 of stock X are sold in February and 1, 000 kept. In late February it goes down and and I buy another 4,000 of stock X. 5000 0f unsold stock is carried forward to March finally all the stock 5000 are sold in March

Beceriler: Excel, Muhasebe, Finans, Veri İşleme, Veri Girişi

Daha fazlasını gör: surf internet work excel, work excel database, online contract work excel, work excel file, show project work excel, article submission work excel, excel 2000 macros work excel 2007, contract work excel access, macros written excel 2000 work excel 2007, track work excel, macro dont work excel 2000, macros work excel internet, work excel documents, design development work excel template, need work excel spreadsheets

İşveren Hakkında:
( 0 değerlendirme ) Brisbane, Australia

Proje NO: #29050599

Bu iş için 84 freelancer ortalamada $440 teklif veriyor

(809 Değerlendirme)
8.8
asin1987

Dear Employer, I understand you need an Excel tracker to note the sale and purchase of your stocks. I have delivered such projects many times in past. Will prepare a professional tracker for you. Kindly check my prev Daha Fazla

$400 AUD in 3 gün içinde
(238 Değerlendirme)
8.0
schoudhary1553

Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in sa Daha Fazla

$500 AUD in 10 gün içinde
(414 Değerlendirme)
8.2
(282 Değerlendirme)
7.5
(167 Değerlendirme)
6.4
(81 Değerlendirme)
6.4
wsh2

* MsEXCEL Business/Finance Programming and Database Expert. American English is first and only language. Greetings Australia from the USA.. {smile} Highly experienced (25+ years) MsACCESS/MsEXCEL/SQL/VBA/VB.Net Busin Daha Fazla

$489 AUD in 7 gün içinde
(41 Değerlendirme)
6.2
kanchana1974

Hi, I am a Finance & Accounting Professional with MBA Finance, CMA qualifications and have experience in Financial Accounting functions. I have expert knowledge & working experience in Stock Accounting, Excel and Daha Fazla

$250 AUD in 7 gün içinde
(54 Değerlendirme)
5.7
SayTechSolution

Hi there? I hope you are well today! I can help you with building stock and management spreadsheet. Looking forward to hear from your side Regards, Subhash

$650 AUD in 10 gün içinde
(54 Değerlendirme)
5.5
GopalJp

Hi, You can reach to me for this Job as I am interested being an finance and Excel person. Please check my profile. I will update all your buy and sell for stakes and provide you a comprehensive dashboard. Thanks G Daha Fazla

$400 AUD in 3 gün içinde
(35 Değerlendirme)
5.5
Godfreyvictor

Hello, Top of the day. Trust you are doing great. I will like to work with you on your project. I am a Professional Accountant, Researcher and Writer with wealth of experience in report writing, academic writing, fi Daha Fazla

$500 AUD in 7 gün içinde
(44 Değerlendirme)
5.3
Bhanupriyaproje1

Hello I've read your project description and will do your work as per your request. Feel free to message and we will discuss the details in the chat. Looking forward to working with [login to view URL]'ll provide you with quality Daha Fazla

$250 AUD in 20 gün içinde
(3 Değerlendirme)
3.3
arunkumar9896

Hi there, I am an expert in excel formulas, dashboards, macros.I have gone through the description on your project and will be able to finish before the deadline with Best Quality Thank you. Arun

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(10 Değerlendirme)
3.5
FaizaMehmoodK

hi there, I am interested in your project and ready to discuss the details. looking forward to your kind response. Regards, Faiza Mehmood

$500 AUD in 7 gün içinde
(3 Değerlendirme)
2.5
Vamsi4113

I am an excel and data analysis expert with 7+ years of experience. I have read your requirement and can perfectly help you with your task. I have done similar work before. Moreover I am a trader myself from last 5 yea Daha Fazla

$375 AUD in 7 gün içinde
(4 Değerlendirme)
2.6
hussainmuzammal4

Assalam-o-Alaikum ⭐⭐⭐Hi!⭐⭐⭐ I have an excellent skills in your project.I have a master [login to view URL] just need to contact me and I am willing to start your project very soon.I have 5 stars ratings in the similar Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(4 Değerlendirme)
2.2
aruls1962

I built a share tracking application (sell and buy continuously) in Google Sheet, which is running live now. I created a dashboard too. [login to view URL] Daha Fazla

$500 AUD in 7 gün içinde
(1 Yorum)
1.8
Najahmohomed

Hello I am happy to help you with your job. We are an outsourcing company based in Sri Lanka providing outsourcing services such as data entry, bookkeeping, accountancy and taxation to clients based in UK, Canada, Aus Daha Fazla

$556 AUD in 5 gün içinde
(1 Yorum)
1.4
saqqal786

I have done MBA Finance and currently managing Accounts and Finances of Government organization. I have 6 years in similar field. I can help you to accomplish your task.

$278 AUD in 3 gün içinde
(1 Yorum)
1.4
Harooniqbal80

Dear Concern, I have gone through the whole project . I am fully confident i can do it . As i have 6 year of Finance Experience If you Allow me i should start work if you like than pay Otherwise no Payment. Kindly co Daha Fazla

$250 AUD in 5 gün içinde
(1 Yorum)
1.2