MYOBCommunity
Partner Zone
|
|
Partner Zone

Share your ideas for improving MYOB Essentials Accounting. Vote on ideas and discuss them with the MYOB product development team.

MYOB Essentials

Trial Balance - Account movements

Sasha_2671

6Posts

12Kudos

0Solutions

6 Posts
User
Australia

Hi,

Is it possible to run a report that only has the account movements for the year/set period included? Generally we code the trial balance into APS/XPA program - but I've noticed that the trial balance 'current year to date' amount includes the previous year's closing balance in the owners drawings, owners contribution (3 - Equity accounts) and in the fixed asset accounts (1-Fixed assets). This throws out those balances and (if we are not careful) can be double coded the following year.

 

Otherwise, is it possible to be able to download the trial balance in excel format so we can then manually fix up these issues before we print and code these reports into our client's financial reports?

 

Thanks,

Sasha

Current Status: Open
Last Changed: January 2014

Thanks for the idea Sasha_2671. Being able to run the trial balance report for a specific financial year should be a option. We would love to hear what others think about this so we can understand the need for this functionality.

10 Comments
MYOB Moderator Barry_C
2,948 Posts
MYOB Moderator
Thanks for the idea Sasha_2671. Being able to run the trial balance report for a specific financial year should be a option. We would love to hear what others think about this so we can understand the need for this functionality.
Super Partner Nicquel_Walker
664 Posts
Super Partner

In order to enter the MYOB data for the financial year we need to be able to pick up the movement in the MYOB file for a selected period typically 12 months but not always. So the ability to enter a start & end date is crucial as well as the ability to export this information to Excel. This need would become redundant however if a general ledger summary report by date range existed.

FergusR
1 Post
User

Seems pretty obvious that "Current year to date" column should show current year to date figures for all accounts. I suggest this issue needs addressing as a high priority, unless there is already a solution?

MYOB Moderator CloverQ
7,010 Posts
MYOB Moderator

Thank you for your suggestion Fergus. 

 

The Trial Balance report is a standard report that to prove all the credit values equal to the debit values. The 'Current Year to Date' column displays the balance of the account at the end of the selected period, the same information is also displayed in the YTD Debit/YTD Credit columns in AccountRight Trial Balance reports. I agree the column header isn't very clear, I have passed the feedback to our developers for consideration. 

 

For asset, liabilities and equity accounts, you can use the 'Current Year to Date' figure minus the 'Last Year' figure to get the net activities in current financial year only. Alternatively, you can run the General Ledger detail report for the desired period, and check the total debit and credit.

martynf
6 Posts
Cover User

This is a very important function.

 Should not be a request, should have been part of the original design, especially as other reports can be printed in Excel.

 

This is an important feature for accounting firms, to do their working papers at the end of the financial year for their clients, to do the final statutory reports.

 

Please look at this as a high priority!

MYOB Moderator Steven_M
30,551 Posts
MYOB Moderator

Hi @martynf


Thank you for your feedback in regards to MYOB Essentials and Trial Balance reports. 

I have combined your idea with this one already included on the MYOB Essentials Idea Exchange.

Topcat
2 Posts
Cover User
I've had a Partner wanting to export data from the Trial Balance Report into Excel. Can this be done, and if not, can we see if we can implement this?
MYOB Moderator Steven_M
30,551 Posts
MYOB Moderator

Hi @Topcat

 

Thank you for your feedback in regards to MYOB Essentials.

I 've merged your idea with this one already included on the MYOB Essentials Idea Exchange.

Topcat
2 Posts
Cover User
Thanks.. I think it will be really handy
debg
4 Posts
User

Please tell me this is not under consideration since November 2012!

A report showing opening balances,periodic movement and closing balances (customisable start and end date) for all accounts is definitely needed -refer previous desktop MYOB software General Ledger Summary Report.