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.
- Dannad12 years agoContributing Cover User
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-addons12 years agoSuper Partner
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.
- ASWatCR11 years agoPartner
I agree with your suggested reports coming as a "standard" report in the software - I have voted for it.
- GKO11 years agoUser
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.
- Nic-acc-addons11 years agoSuper Partner
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
- JTL_TR11 years agoUser
I vote for this to become a standard report
- eleanora10 years agoUser
I have a need to produce comparitive P/L Reports. Currently I run 3 P/L reports, export to Excell then combine. This allows all P/L reports to be presented to Management Committee on 2 pages instead of 6 pages and is also easy to compare.
I run current month with Year to Date (columns 3 and 4); Last Year (Period July to Currrent Month) and Budget (Period July to Current Month)
I have supported many financial applications including Oracle Financials, Finance 1 and always been able to have a customised report written which runs from the underlying database - in this case MYOB. Support call to MYOB sugested using an Add -On whihc I have tested out. However, add-on pulls MYOB data into it's database (clunky) and still requires a report to be prepared by Add-on. I am happy to pay a reasonable amount for development of report to save the 1/2 to 1 hour each month - within MYOB - but this does not seem to be an option.
Has anyone any suggest how I can achieve what I want directly from MYOB i.e. without requirements of Excell and combining?
Look forward to suggestions. Regards Eleanor
Last Year Account Name Selected Period Year to Date Budgeted - jenniek10 years agoUltimate Partner
Hi there,
Suggest you look at Calxa reports (www.calxa.com.au) which does reports in both Version 19.x and 2014, or Sidekick reports (www.computingsolutions.co.nz) which only runs with V19.x at present. Calxa has the ability to customise reports to your requirements, and I think Sidekick has this exact report as one of their std reports.
- eleanora10 years agoUser
HI Jenniek
Thank you for the reply. I have looked before at Calxa but it is only available (I think) on yearly subscription. We are on AR2014 so Sidekick is not a valid solution. Also, I think both of these pull the data into their own database and then you run reports from that database. I want to avoid this and be able to run the custom report from within MYOB report menu - custom report would be OK.
I run this as a volunteer for a charity and the cost of additional software is not really warranted when my time is given free to the charity.
Any other suggestions are welcome
Eleanor
- Mike_James10 years agoUltimate Partner
Hello eleanora the ability to incorporate additional reports within the AccountRight program does not exist, and unless MYOB changes its development philosophy for this program, never will.
Programs like Oracle and (SAP?) Finance One are many orders of magnitude more expensive than AccountRight, which is aimed at the small to medium organisation.
The only path for third-party developers to access AccountRight is through the API, using an external program.
- Davidb9 years agoCover User
I work for a turf Farm.
we sell our product by the M2
we are looking for a financial package that allows us to produce P&L's which also contain (At the top of the P&L Report) budgeted versus Actual volumes of our product sold.
We also need to produce reports for say the month of Sept 2015 that show us the Month to Date (Actual v Budget and variance) and also the Year to Date (Actual v Budget and variance)
It would look like this MTD YTD
Actual Budget Variance Actual Budget Variance
Volume sold in M2 10000 12000 (2000) 20000 25000 (5000)
Sales $120000 $140000 ($20000) $240000 $280000 ($40000)
Expenses
Profit/(Loss)
The combination of Volumes and $$ is invaluable information to us and is essential for our business.
I have been instructed by my MD to source a new financial package that can deliver this.
My initial thought is that you could enhance the Myob system so that I don;t have to source and alternative product.
If you do this, it would also require that budgeted volumes would need to be able to be entered into the MYOB systems.
I hope this is doable as my instructions to source the system that suits our business is clear.
Regards
David Butler
ph 0428 946 994
- TraceyR9 years agoContributing Partner
Yes, it is a shame that you have to either export to excel and consolidate or use an add-on program to create what should be a standard report.
I have voted on this idea quite a long time ago and like you I am still waiting on MYOB to come through on this one. A Profit and Loss Budget report with YTD figures is quite simple to get out of another program I use.....
- BYBookkeeping8 years agoTrusted Cover User
I was just looking for this exact report.
Why bother putting in Budget figures if I can't run a report to compare them to Actuals.
Poor Accounting MYOB !
- Deo7 years agoCover User
I need a profit and loss with
colums this period Current year
Year to date Current Year
this month last year
year to date last year
Related Content
- 12 months ago
- 4 years ago
- 7 months ago
- 3 years ago