Sasha_2671's avatar
12 years ago

Report: Trial balance - Current year to date amounts to not include previous balances


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?





"Trial Balance - Account movements"


  • Status changed:
    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.
  • 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.

  • 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?

  • CloverQ's avatar
    Former Staff

    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's avatar
    Former Staff

    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!

  • 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's avatar
    Former Staff
    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?
  • 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.

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