- Lyn_WilliamsPartner
The GST Detail report doesn't show details of the past financial year.
My file is 2016.2 and current year is 2017 but cannot look at GL Detail for 2016 financial year. Even though the data doesn't purge from 2016.
I would like to be able to group accounts together and see the gl total for multiple accounts in 2016 for a prior year while listing totals at period end etc which would be the GL Detail Report. Can this be fixed please in 2016.
You can use the GL transactions (Accruals) but this doesn't list totals for the period which is a big help in budgeting.
thank you
Lyn Williams
CC
- Kym__YeowardUltimate Partner
As an accountant dealing with multiple clients, I'm frustrated that I cannot run the GL Detail Report for prior years - particularly when I'm researching an asset, liability or equity account - that is, what its' balance comprises.
It's particularly important at year end, when I'm preparing the annual accounts.
Currently I have to instead run a Find Transactions query and then save the screen as a GIF picture, using the Windows 10 Snipping Tool. An unprofessional solution.
Kym Yeowarrd CPA ACIS
Darwin
- DuncanSUltimate Partner
Further to Kym's comment, there was a recent request to MYOB for a 5 year P&L.
As the year is now closed not rolled and I believe the data can be saved for up to seven years then I believe that MYOB should make the reporting and search functions much more useful.
Duncan
- Mike_JamesUltimate Partner
Hi Kym__Yeoward, the Account transactions (Accrual) report can be run for prior years. There's no opening/closing/running balance. I'd like to see a GL summary report that could be run for any prior year, in support of this transaction report.
- DuncanSTrusted Partner
Steven,
Thanks for the update on Accountants Office.
I do believe that MYOB should be working on a 5 year P&L as a matter of urgency.
One does wonder if old style Tax Accountants would use it.
It may be that the government should change the reporting format/standards.
Duncan Smith
Business Advice + Tax
- Steven_MFormer Staff
Hi DuncanS
Accountant Division products are not my speciality, I work mainly with the AccountRight programs.
However my understanding after speaking with the Accountants Division team is that with the Accountant Office Tax program you can display most reports for the period of 2010 - through to the current tax year. It would be on a per tax year basis not across the full financial years i.e. you can't do one single report for 2010 to 2016. - DuncanSTrusted Partner
Steven,
I understand Xero does have Multi Year Reporting up to seven years.
One would think it was paramount for MYOB to match Xero's reporting.
Can you confirm whether MYOB Tax software has a 5 year P&L as mentioned to me by a MYOB representative at MYOB Connect in February 2016.
One of the difficulties is that Tax Agents only report using Current and Current -1.
If MYOB has a 5 year P&L in its tax software, why is it not utilised by Tax Accountants?
One can only hope that Tax Accountants concentrate on ongoing business and tax advice and not historical tax compliance.
Duncan Smith
Business Advice + Tax
- John_PFormer Staff
Would it be possible to consider having a way to generate Accounting Reports that stretch across multiple Financial years.
For example - be able to generate a Profit & Loss statement that stretches back from 2008 to 2015?
Cheers,
John
- Jennifer_KellySuper Partner
Hi John_P
You will find some of the Add-on Solution providers can allow you to easily report accross financial years like this, see - http://myob.com.au/addons/
As an example our software Business Intelligence for MYOB can report P&L but also Sales ( by Item, by Customer etc) , Jobs, Purchases etc across as many years as you have data for in your MYOB company file.
See below an example P&L accross 3 years.
(Note however as we build up from the detailed transactions in MYOB we can only produce reports on years where you HAVE NOT PURGED your MYOB data). If you have Purged historical years then you can add into the reporting an old backup file from earlier years, consolidate that with your current file and then report on a combination of the old MYOB file and the current one. Provided you have a clean cut off from the old file to the new one you will be able to produce the above report accross the years.)
All details and a you can Sign Up for a 14 day free trial from our website at www.BIforMYOB.com.
I hope this helps.
Jennifer Kelly CA
02 8011 1511
- Steven_MFormer Staff
Hi DebraAnderson
Thank you for voting and commenting for this idea. I've passed your feedback.
The SQL platform (AccountRight 2015) retains that data rather than the Classic versions which you could purge that information out. So as the data is in the system it is in theory possible for the program to pull that information like the sales/purchase reports. However its those restrictions for current, last and next financial year that are stopping them from getting pulled. This Idea has been suggested to removed those restrictions so you can get those financial reports for historical years.
Once again thank you for voting for this idea and your feedback. - DebraAndersonExperienced Partner
Absolutely!!!! I was under the impression that one of the major benefits of this new SQL platform was so we could have this capability.
- Liam_MFormer StaffStatus changed:NewtoOpenThanks for your great suggestion regarding reporting Tricia. To clarify there are a number of reports that can already be run for any period. For instance most sales and purchases reports can be run for any period. However there are also a number of reports (like the profit and loss report and general ledger reports) that can only be run for restricted periods. Anyone who would like to see these restrictions lifted in future versions, please cast your vote for this idea.
- DuncanSUltimate Partner
Tricia,
I believe your idea is very useful.
Business Owners should be looking at the past performance of their business over multiple years (5) not just 2.
The rollover procedures in MYOB have changed and, I believe. there is now a functionality to keep up to seven years of data in a MYOB file.
As a Tax Agent, it would be interesting what the response of Tax Agents and Softeware Providers might be.
Up to MYOB now.
Related Content
- 6 months ago
- 12 months ago
- 2 years ago
- 8 months ago
- 7 years ago