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 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.

Taidot: Excel, MYOB, Visual Basic

Näytä lisää: myob dashboard reporting, myob excel odbc, myob report refresh, real time dashboard odbc, dashboard reporting excel, 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, visual work flow, visual basic cost, tax year freelancer, sample company background information, sample company background, reporting freelancer, payable freelancer, new aggregator freelancer

About the Employer:
( 0 reviews ) Subiaco, Australia

Projektin tunnus: #1706847

3 freelanceria on tarjonnut keskimäärin 417 $ tähän työhön


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

250 $ USD 3 päivässä
(4 arvostelua)

Please check private message

750 $ USD 5 päivässä
(0 arvostelua)

Looking forward to working with you.

250 $ USD 2 päivässä
(0 arvostelua)