Đã Đóng

MYOB/Excel ODBC Dashboard Reporting

Project Brief ? MYOB OBDC Excel Dashboard

Aim: To develop a basic MS Excel reporting dashboard that uses ODBC to update automatically from MYOB as required.

Background: The current system of monthly reporting entails copy and pasting reporting information from MYOB excel reports into an ?aggregator? spread sheet that interprets the data and summarizes it into a dashboard for distribution to the client. This process is slow and cumbersome, resulting in 4 or more hours spent by the bookkeeper to manually update the report each month when new data is available. This project proposes to eliminate the time spent by the bookkeeper to manually update the report by creating an OBDC connection between the MYOB data file and the Excel reporting dashboard.

Target Outcome: Increased efficiency in monthly dashboard reporting

Project Output:

? Primary Output: An Excel based dashboard application that updates data from an OBDC connection to a specified MYOB data file. The excel dashboard will be operational for all client MYOB data files.

? Secondary Output: A relationship is developed with an expert MYOB and Excel freelancer, enabling further work to be completed via the freelancer as required.

Requirements of Excel Dashboard Spread sheet:

? Display of a reporting dashboard that covers:

o Table of accounts payable/receivable

 Ability to adjust the time periods displayed in days or months. (4 different periods required i.e. 0-5 days, 6-15 days, 16-30 days and 30 plus days). This could be done using a drop-down list.

o Cumulative graphs of income, operating profit and gross profit. Including last year, year to date and projections (projections based on last year?s PnL).

o PnL reporting table for last month, current reporting month, YTD and full year projection, including:

 Total Income

 Total Cost of Sales

 Gross Profit

 GP %

 Total Expenses

 EBITDA

 EBITDA Margin %

o Cash Flow summary

 Cash at Bank at end of current reporting month

 plus incoming commitments

 less outgoing commitments

 less GST Liability

 less Income Tax Provision

 Free Cash Flow

o BAS liabilities for current reporting month and previous month

 PAYG withholding payable

 GST collected and paid

 Total BAS liabilities

 Ability to select between either cash or accrual for BAS liabilities

o Other relevant liabilities

 Superannuation for current year

 Income tax provision for current year

? To refresh the data in real time, i.e. as MYOB is updated

? To update the dashboard in real time, i.e. as MYOB is updated

? Easy to understand layout, i.e. client friendly

? Ability to be used with multiple MYOB data files

A screenshot of a sample dashboard is attached. Please use the Clearwater Pty Ltd company file to program the dashboard.

Project Brief / MYOB OBDC Excel Dashboard

Aim: To develop a basic MS Excel reporting dashboard that uses ODBC to update automatically from MYOB as required.

Background: The current system of monthly reporting entails copy and pasting reporting information from MYOB excel reports into an "aggregator" spread sheet that interprets the data and summarizes it into a dashboard for distribution to the client. This process is slow and cumbersome, resulting in 4 or more hours spent by the bookkeeper to manually update the report each month when new data is available. This project proposes to eliminate the time spent by the bookkeeper to manually update the report by creating an OBDC connection between the MYOB data file and the Excel reporting dashboard.

Target Outcome: Increased efficiency in monthly dashboard reporting

Project Output:

Primary Output: An Excel based dashboard application that updates data from an OBDC connection to a specified MYOB data file. The excel dashboard will be operational for all client MYOB data files.

Secondary Output: A relationship is developed with an expert MYOB and Excel freelancer, enabling further work to be completed via the freelancer as required.

Requirements of Excel Dashboard Spread sheet:

Display of a reporting dashboard that covers:

- Table of accounts payable/receivable with the ability to adjust the time periods displayed in days or months. (4 different periods required i.e. 0-5 days, 6-15 days, 16-30 days and 30 plus days). This could be done using a drop-down list.

- Cumulative graphs of income, operating profit and gross profit. Including last year, year to date and projections (projections based on last year's PnL).

- PnL reporting table for last month, current reporting month, YTD and full year projection, including:
Total Income
Total Cost of Sales
Gross Profit
GP %
Total Expenses
EBITDA
EBITDA Margin %

- Cash Flow summary
Cash at Bank at end of current reporting month
plus incoming commitments
less outgoing commitments
less GST Liability
less Income Tax Provision
Free Cash Flow

- BAS liabilities for current reporting month and previous month
PAYG withholding payable
GST collected and paid
Total BAS liabilities
Ability to select between either cash or accrual for BAS liabilities

- Other relevant liabilities
Superannuation for current year
Income tax provision for current year

- To refresh the data in real time, i.e. as MYOB is updated
- To update the dashboard in real time, i.e. as MYOB is updated
- Easy to understand layout, i.e. client friendly
- Ability to be used with multiple MYOB data files

A screenshot of a sample dashboard is attached. Please use the Clearwater Pty Ltd company file to program the dashboard.

Project Brief / MYOB OBDC Excel Dashboard

Aim: To develop a basic MS Excel reporting dashboard that uses ODBC to update automatically from MYOB as required.

Background: The current system of monthly reporting entails copy and pasting reporting information from MYOB excel reports into an "aggregator" spread sheet that interprets the data and summarizes it into a dashboard for distribution to the client. This process is slow and cumbersome, resulting in 4 or more hours spent by the bookkeeper to manually update the report each month when new data is available. This project proposes to eliminate the time spent by the bookkeeper to manually update the report by creating an OBDC connection between the MYOB data file and the Excel reporting dashboard.

Target Outcome: Increased efficiency in monthly dashboard reporting

Project Output:

Primary Output: An Excel based dashboard application that updates data from an OBDC connection to a specified MYOB data file. The excel dashboard will be operational for all client MYOB data files.

Secondary Output: A relationship is developed with an expert MYOB and Excel freelancer, enabling further work to be completed via the freelancer as required.

Requirements of Excel Dashboard Spread sheet:

Display of a reporting dashboard that covers:

- Table of accounts payable/receivable with the ability to adjust the time periods displayed in days or months. (4 different periods required i.e. 0-5 days, 6-15 days, 16-30 days and 30 plus days). This could be done using a drop-down list.

- Cumulative graphs of income, operating profit and gross profit. Including last year, year to date and projections (projections based on last year's PnL).

- PnL reporting table for last month, current reporting month, YTD and full year projection, including:
Total Income
Total Cost of Sales
Gross Profit
GP %
Total Expenses
EBITDA
EBITDA Margin %

- Cash Flow summary
Cash at Bank at end of current reporting month
plus incoming commitments
less outgoing commitments
less GST Liability
less Income Tax Provision
Free Cash Flow

- BAS liabilities for current reporting month and previous month
PAYG withholding payable
GST collected and paid
Total BAS liabilities
Ability to select between either cash or accrual for BAS liabilities

- Other relevant liabilities
Superannuation for current year
Income tax provision for current year

- To refresh the data in real time, i.e. as MYOB is updated
- To update the dashboard in real time, i.e. as MYOB is updated
- Easy to understand layout, i.e. client friendly
- Ability to be used with multiple MYOB data files

A screenshot of a sample dashboard is attached. Please use the Clearwater Pty Ltd company file to program the dashboard.

Kỹ năng: Excel, MYOB, Visual Basic

Xem thêm: myob dashboard reporting, myob excel odbc, myob report refresh, real time dashboard odbc, dashboard reporting excel, real time reporting excel odbc, odbc dashboard, excel myob odbc, odbc reporting excel, odbc myob excel, myob reporting excel odbc, excel odbc dashboard, myob odbc monthly, accounts receivable dashboard excel, accounts payable excel dashboard, completed dashboard reporting requirements, odbc excel myob, myob odbc excel, project brief sample dashboard reporting, visual work flow, visual basic cost, visual basic 6 freelancer, tax year freelancer, summary in freelancer, sample company background information

Về Bên Thuê:
( 0 nhận xét ) Subiaco, Australia

Mã Dự Án: #1706847

3 freelancer đang chào giá trung bình $417 cho công việc này

muhammadandco

Have experience in excel dashboard OBDC & MYOB accounting software. Please contact to discuss further.

$250 USD trong 3 ngày
(4 Đánh Giá)
3.1
bbwservices

Please check private message

$750 USD trong 5 ngày
(0 Đánh Giá)
0.0
VinceRS

Looking forward to working with you.

$250 USD trong 2 ngày
(0 Đánh Giá)
0.0