Đã Hủy

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

Kĩ năng: Xử lí dữ liệu, Nhập liệu, Visual Basic, Kế toán, Excel

Về Bên Thuê:
( 0 nhận xét ) Camden, United Kingdom

ID dự án: #32719829

86 freelancer chào giá trung bình£225 cho công việc này

(858 Nhận xét)
9.0
(519 Nhận xét)
8.4
(1152 Nhận xét)
8.3
(447 Nhận xét)
8.3
(398 Nhận xét)
7.5
(428 Nhận xét)
7.4
(309 Nhận xét)
7.8
(255 Nhận xét)
6.9
(183 Nhận xét)
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 trong 1 ngày
(446 Nhận xét)
6.8
(100 Nhận xét)
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 Thêm

£200 GBP trong 3 ngày
(112 Nhận xét)
6.6
(175 Nhận xét)
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 Thêm

£55 GBP trong 1 ngày
(187 Nhận xét)
6.6
(28 Nhận xét)
6.3
osamawebjuggler

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

£20 GBP trong 1 ngày
(51 Nhận xét)
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 Thêm

£135 GBP trong 7 ngày
(67 Nhận xét)
5.6
(52 Nhận xét)
5.8
(137 Nhận xét)
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 Thêm

£135 GBP trong 3 ngày
(143 Nhận xét)
5.6