Em Andamento

Financial Spreadsheet : We require an Excel Expert to create a financial spreadsheet for our organisation

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.

Habilidades: Contabilidade, Excel, Finanças, Análise Financeira, MYOB

Veja mais: excel expert financial models, create financial calculators india, create financial business logo photoshop, financial statement test ratio excel, create financial information database, create financial database, load financial information yahoo finance excel, create feedback spreadsheet excel, financial statement case study excel, need create inventory spreadsheet excel, excel travel agency financial plan, looking excel expert create multiple macros, excel spreadsheet expert create, financial analysis investment report excel, financial report analysis examples excel, financial business plan template excel, create tracking spreadsheet excel, extract information financial statements insert data excel simple, need excel expert create macro

Acerca do Empregador:
( 0 comentários ) Canberra, Australia

ID do Projeto: #29004835

Concedido a:

(283 Comentários)
7.5

62 freelancers estão ofertando em média $467 nesse trabalho

schoudhary1553

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 Mais

$500 AUD in 10 dias
(378 Comentários)
8.1
(291 Comentários)
7.8
(130 Comentários)
7.6
(294 Comentários)
7.3
(117 Comentários)
6.6
(71 Comentários)
6.1
(85 Comentários)
6.5
kanchana1974

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 Mais

$270 AUD in 7 dias
(54 Comentários)
5.7
JohnRikz

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

$500 AUD in 7 dias
(44 Comentários)
4.9
dheerajjshetty19

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 Mais

$250 AUD em 1 dia
(35 Comentários)
4.9
Goodfreelancer1

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 Mais

$500 AUD in 10 dias
(18 Comentários)
4.5
MMG2019

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 Mais

$500 AUD in 10 dias
(23 Comentários)
4.5
caharshadshinde

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 Mais

$750 AUD in 7 dias
(16 Comentários)
4.4
oldaccountant

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 Mais

$250 AUD em 1 dia
(22 Comentários)
3.9
ashleighisabelle

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 Mais

$556 AUD in 7 dias
(7 Comentários)
3.9
carpeomniaa

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 Mais

$250 AUD in 3 dias
(11 Comentários)
3.4
(7 Comentários)
3.0
zhy

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 Mais

$750 AUD in 7 dias
(9 Comentários)
2.6
hamidr2020

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] Mais

$325 AUD in 7 dias
(6 Comentários)
2.2
vishaljagetia

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 Mais

$750 AUD in 7 dias
(1 Comentário)
1.3