We are a service company and would like to enter financial details into a spreadsheet from our accounting system and service management system to provide a weekly snapshot of the business to report to management. Management would like to see a report / dashboard of the following:
1. Bank Balance: identifying each bank account eg working account, term deposits etc (up to say 10 accounts)
2. Income: - How much money is owed to us eg Receivables. eg money owed to us.
3. Payables: A breakdown of all money we owe out eg, creditors, credit cards, Australian Tax Office (GST, Payroll, BAS)
4. How much money paid out in a week eg wages, suppliers, other
5. How much money received (Banked) within the week.
6. (a) Work in progress (WIP) current value of jobs started, (b) Work completed (Ready to be invoiced this week), (c)Work pending (yet to start but purchase orders received). (d) other
7. Purchase orders we have issued which have not been invoiced to us yet
8. Money owed in employee entitlements such as long service leave, holiday leave, Rostered days off etc
9. We would like to have an entry screen where the data can be entered into easy (eg entry screen).
10 .The report would need to provide an overview (snapshot) if figures have gone up or down from the previous week.
11. Cashflow for the week.
We can get a report from our accounting package which we can export to excel so if we could extract figures from that would save on manually entering.
Any other info, please feel free to contact me.
62 freelanceri licitează în medie 467$ pentru acest proiect
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 Mai multe
Hi, I am a Finance & Accounting Professional with MBA Finance, CMA qualifications and have experience in Finance & Accounting functions. I have expert knowledge & working experience in Financial statements, Excel Mai multe
Hello I am an excel and dashbord expert holder on an MBA yes we can automate the data pull from your accounting system exported file dashboard will be dynamic and interactive can we discuss more ? John
Hi, I have come across your post and I can enter financial details into spreadsheet as you require. A bit about myself, my academic qualification is Chartered accountant. For the past seven years I have gained conside Mai multe
Hello, I am Financial Analyst. I can prepare your required spreadsheet. I have prepared already this sheet. Please have a look: https://www.freelancer.com/projects/excel/High-Level-google-access-excel/reviews Looki Mai multe
Hi, I have more experiences in Visual Basic, MS EXCEL and VBA. I can write your Financial Spreadsheet . We can build software in Visual Basic or MS Access Database. Offering many other software solutions and suggestion Mai multe
Hi I am a Chartered Accountant (like CFA) having expertise in preparing dynamic financial models for my clients. I have understood your requirement and found that I can be the best person for this job. I am expert in e Mai multe
prepare your financial statements in excel Already do many similar project and completed it within your budget, time My Qualifications as under-: #Chartered Accountant(ACCA/CPA) #Laywer/advocate #Masters in commerce Mai multe
Hi there, I am an Australian myself! I have a Bachelor of Business Administration and a Masters in Financial Planning. I have two years experience as an operations analyst where my role was to generate and maintain var Mai multe
P.s One of our team member is a CFA L3 candidate (in addition to MBA in Banking & Finance) while another team member is a Chartered Accountant (CPA/ACCA Equivalent). We understand that this is a corporate level work Mai multe
Hi there, I'm really excited with your project. I have experience in excel so I can help you making excel dashboard/report based on your requirements. Let's discuss via message. I look forward to working on this projec Mai multe
Hello, I have thoroughly read your project details. The required skills match my expertise and I would love to work with you on this project. You can check my recent reviews in excel projects. [login to view URL] Mai multe
Hi there, I'm glad to help you to create a financial spreadsheet, we're a team of CPA's, Chartered Accountant & Company Secretary professionals who can do the following task for you. We have got experience in writing t Mai multe