İptal Edildi

Excel Spreadsheet

Dashboard Banking Spreadsheet

1. Looking for an excel spreadsheet to use with work

2. I Copy banking transactions (+ for money in and -for money out) from bank and paste to spreadsheet

3. The transaction date will be copied and pasted too

4. From a drop down menu I allocate a cost to the business for each transaction (these will be supplied but rent, water, stock etc)

5. I Choose a bank to assign to the transaction (WORK, DIRECTOR LOAN, OTHER) for each transaction

6. The dashboard to show cumulative costs, turnover, profit, directors loan balance, bank balance

7. At the start of each month manually input an opening balance for each bank and a stock figure. At the end on the month the spreadsheet should work out closing figures with the option to manually adjust so it balances

8. One cumulative running total to show annual financial summary

9. The year runs from January to December

10. This means when I finish input on the 31st of December the summary page and the dashboard will show the full years annual performance

11. This information will then be emailed to an accountant

12. There is no data entry on your part just the spreadsheet

Beceriler: Veri İşleme, Veri Girişi, Visual Basic, Muhasebe, Excel

İşveren Hakkında:
( 0 değerlendirme ) Camden, United Kingdom

Proje NO: #32719829

Bu iş için 86 freelancer ortalamada £225 teklif veriyor

(858 Değerlendirme)
9.0
(519 Değerlendirme)
8.4
(1152 Değerlendirme)
8.3
(447 Değerlendirme)
8.3
(398 Değerlendirme)
7.5
(428 Değerlendirme)
7.4
(309 Değerlendirme)
7.8
(255 Değerlendirme)
6.9
(183 Değerlendirme)
7.0
rohitagarberg

Hi..i can understand your project and prepare the spreadsheet for you of the banking transactions category wise.. looking forward to work..thanks!!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(446 Değerlendirme)
6.8
(100 Değerlendirme)
6.7
usmanhassan123

"I am a Excel developer with specializations in Vba and Macro's. I provide a variety of services, including: - Execl VBA & Macro's - Execl Dashboards & Models - Financial Analysis Reports - Financial Modelling & Proj Daha Fazla

£200 GBP in 3 gün içinde
(112 Değerlendirme)
6.6
(175 Değerlendirme)
6.4
AccountantArman

"Sir, I am an Excel Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading A Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(187 Değerlendirme)
6.6
(28 Değerlendirme)
6.3
osamawebjuggler

Hi I am expert in excel having experiance in excel and work with 100% accuracy and quality.,,,,,,,,,,,,,,,,,,,,,,,,,,

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(51 Değerlendirme)
5.7
konanhenry1111

"⭐⭐⭐⭐⭐⭐I am an engineer and I read the details accurately.⭐⭐⭐⭐⭐⭐ I am ready to start now. Just if u have more details or questions u can ask me in chat. Check my projects that I have finished related to engineering in Daha Fazla

£135 GBP in 7 gün içinde
(67 Değerlendirme)
5.6
(52 Değerlendirme)
5.8
(137 Değerlendirme)
6.1
merinsinha

Senior Banking spreadsheet Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipat Daha Fazla

£135 GBP in 3 gün içinde
(143 Değerlendirme)
5.6