Dibatalkan

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

Kemahiran: Pemprosesan Data, Pemasukan Data, Visual Basic, Perakaunan, Excel

Tentang Majikan:
( 0 ulasan ) Camden, United Kingdom

ID Projek: #32719829

86 pekerja bebas membida secara purata £225 untuk pekerjaan ini

(858 Ulasan)
9.0
(519 Ulasan)
8.4
(1152 Ulasan)
8.3
(447 Ulasan)
8.3
(398 Ulasan)
7.5
(428 Ulasan)
7.4
(309 Ulasan)
7.8
(255 Ulasan)
6.9
(183 Ulasan)
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!!

£100 GBP dalam sehari
(446 Ulasan)
6.8
(100 Ulasan)
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 Lagi

£200 GBP dalam 3 hari
(112 Ulasan)
6.6
(175 Ulasan)
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 Lagi

£55 GBP dalam sehari
(187 Ulasan)
6.6
(28 Ulasan)
6.3
osamawebjuggler

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

£20 GBP dalam sehari
(51 Ulasan)
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 Lagi

£135 GBP dalam 7 hari
(67 Ulasan)
5.6
(52 Ulasan)
5.8
(137 Ulasan)
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 Lagi

£135 GBP dalam 3 hari
(143 Ulasan)
5.6