Peruttu

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

Taidot: Tietojenkäsittely, Tiedonsyöttö, Visual Basic, Kirjanpito, Excel

About the Client:
( 0 arvostelua ) Camden, United Kingdom

Projektin tunnus: #32719829

86 freelanceria on tarjonnut keskimäärin £225 tähän työhön

(858 arvostelua)
9.0
(519 arvostelua)
8.4
(1152 arvostelua)
8.3
(447 arvostelua)
8.3
(398 arvostelua)
7.5
(428 arvostelua)
7.4
(309 arvostelua)
7.8
(255 arvostelua)
6.9
(183 arvostelua)
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 1 päivässä
(446 arvostelua)
6.8
(100 arvostelua)
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 Lisää

£200 GBP 3 päivässä
(112 arvostelua)
6.6
(175 arvostelua)
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 Lisää

£55 GBP 1 päivässä
(187 arvostelua)
6.6
(28 arvostelua)
6.3
osamawebjuggler

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

£20 GBP 1 päivässä
(51 arvostelua)
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 Lisää

£135 GBP 7 päivässä
(67 arvostelua)
5.6
(52 arvostelua)
5.8
(137 arvostelua)
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 Lisää

£135 GBP 3 päivässä
(143 arvostelua)
5.6