Skip to content
← Reports & tax

Enter your idea

Reports & tax: Reporting

Categories

(thinking…)

Account transaction report | Grouping - Ability to show opening & closing balances

Reporting - Account Transactions - Group by Contact Group - Aged Receivable Transactions

When I run the Account Transactions new report with Grouping as Contact Group, the option to add opening and closing balances is blocked. Is it possible to enable this so that we can use the report in lieu of a monthly activity statement for the Group.

21 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Andrea Green shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Nancy Nancy commented  ·   ·  Report

    There's one thing I can't understand why they changed. Previously, there were opening and closing balances when grouping by contact. AP and AR are the main balance sheet items and are important by CLIENTS, not for the entire account.

    I've read about Xero's enthusiasm for changing the first page with bank accounts. Yes, it's more convenient, but what difference does it make if you can't create a BASIC client report for the required period with balances? Why should I export it to Excel, sort by client, and figure out the balances? Then what's the point of Xero? It's a basic report!!! It just needs to be there and work.

  • Alfred Ang commented  ·   ·  Report

    This is an important feature! Hope can be expedited soon!

  • Maria Verri commented  ·   ·  Report

    Very Important for workpaper if we are grouping accounts that the transaction report shows closing balance.

  • Judy Watson commented  ·   ·  Report

    Would like this so can have the option for Opening and Closing balances when Grouping/Summarising by Source also - so can report as a control account.
    The Opening and Closing balances on all grouping/summarising options is a must. At present seems to work on Account Name only, even Account Code grouping does not have the opening/closing balance.

  • Kah Yen Ooi commented  ·   ·  Report

    The ability of Account transactions, when select Account receivable account and payable account, then filter by contact to show opening and closing balance of each contact is essential for review and audit purposes.

  • Kah Yen Ooi commented  ·   ·  Report

    Please add Account Transaction reports for Account Payable and Receivable that show opening balance and closing balance.

    Example of the existing Account Transaction report when customise it by checked Account Payable and then sort by contact. The report shows each contact's transactions for the period selected without the opening balance. Therefore the closing balance is total amount for the period. It is useless to be used for checking without the opening balance and a correct closing balance.

    It should have account payable/receivable Ledger which shows opening balance, detail transactions and closing balance for each contract at one report.

  • Lai Har Lim commented  ·   ·  Report

    Availability of all account transactions that shows opening balances and closing balances in one screen.