Report: Profit & Loss [Budget Analysis] - Show month by month values

[Donna_cecs]

My Board of Management request a Profit & Loss with Budget Analysis and YTD figures every month.  Currently I need to send to XL and spend the day cutting and pasting as I have five separate businesses to complete this report for.  I would love to see this report in Account Right Live.  I was hoping when I recently upgraded to Account Right Live 2012 that I would be able to create this report, but no such luck.

Donna

"Reporting"

[ASWatCR]

There are addon solutions that do exactly this.  Am not sure MYOB will be able to do what you want (even thought it would be nice).

[Dannad]

In the Reports section, is it possible for the P&L report to have ALL the following fields available to be selected as columns:

Actual - Current Month

Actual - Year to Date

Budget - Current Month

Budget - Year to Date

Last Year - Current Month

Last Year - Year to Date

At present if I want to get a report that compares current month and year to date to the budget, I have to print 2 seperate reports of extract and manipulate in excel.

[Nic-acc-addons]

Hi Dannad,

If MYOB does not let you generate the report you need, feel free to go to our website and downlaod our BudgetLink tool. It comes with a free version (yes Free as in 0$) which can solve 90% of the simple problems MYOB users experience when it comes to reporting.

There are also higher-end versions which are paid, but for what you need, the free version would do.

It would plug right in, and be able to download the info from your MYOB (or Quickbooks or Xero) data file.

Best of luck.

[JTL_TR]

I think it would be a good idea to have a profit & loss report where you can view the following information all on one report:

1. Profit & loss actual versus budget for the selected month

2. Profit & loss Year to Date

3. Profit & loss Budget Yeat to Date

Currently I have to print 3 separate reports in MYOB, download to excel and then combine the 3 reports.

[ASWatCR]

I agree with your suggested reports coming as a "standard" report in the software - I have voted for it.

[GKO]

I need a report that shows the month actual & month budget figures as well as YTD Actual & YTD Budget. I have to export two reports to excel and cut & past them together. Mistakes can happen in the cut & paste! Please put this report into your next release.

[JTL_TR]

I vote for this to become a standard report

[Nic-acc-addons]

Hi GKO,

I work for a third-party addon developer that can produce exactly the report you need using your data in MYOB. The addon in question is called BudgetLink. What's more, there is a FREE edition and i believe this may be all you need. 

You can head over to our website to find out more about it. BudgetLink.com.au

I hope it helps.

Nic

[PRB]

In Account Right Enterprise you can enter a budget amount against each general ledger account, however the only P&L Budget Analysis Report lists the whole P&L in one report for selected months. What would be a great idea is to be able to select an individual general ledger account for a specified date range and report actual vs budget expenditure against it. This is such a simple modification as all the data is already there. It would be extremely helpful for organisations with many cost centres as you could then run a tailored budget analysis for any dept.

Could the MYOB Technical people please confirm that all that is needed is a simple modification to the P&L Budget Analysis Report to enable the selection of individual general ledger accounts ?

Thank you 

[Kym__Yeoward]

You might like to look at two excellent add-ons that significantly boost AccountRight reporting  -  see www.calxa.com.au for Calxa Premier (for non-profits) and Calxa Express (for small businesses). Calxa's Account Analysis report provides this info. Also see www.smartreports.com.au - they have many custom reports.

Alternatively, you could export the report to Excel (see the arrow above Run Report) and use it's grouping feature, to hide the accounts you don't want to show.