Account Transaction Report - Add additional custom columns
request for additional columns available in customised account transactions report
only standard columns available, would like to access other options such as unit quantity, unit cost, invoice status, etc.

-
Elaine Morneau commented
On the Account Transaction report would like to see in the filter to add 4 additional columns for better auditing purposes. Date Created, Last Date Modified, Created by and Modified by. Right now you need to go into each transaction to see the audit history. If would be nice to print the report and see all modified transactions and by who.
-
Philip Dittmer commented
I support more columns. In particular I'd like Xero to add the 'Analysis Code' which could be pulled from the details in the bank transactions screen. This will help sort and see what was paid via Eftpos etc.
-
Jane Stergio commented
I also would like to see the invoice status on the account transaction report - so I can see paid vs not paid.
-
Roz Voullaire commented
In trying to create clean and simple Account Transaction reports similar to the old reports, for quick reconciling of accounts such as Super Payable and PAYG Payable, showing the weekly Payroll Expense Journal entries for the month (as per old report with) without splitting the weekly Payroll Expense Journals into multiple payroll cost centres.
The closest I can get is via Grouping/Summarising using Summarise by Date or Summarise by Reference, however regardless of what Columns are selected, the output is too minimal:
- Summarise by Date shows the fields Date, Debit & Credit only, no References
- Summarise by Reference shows the fields Reference, Debit & Credit, no Dates.
- clicking the More option for either of the above the “Show opening and closing balances” boxes for “Asset, liability, and equity” and “Revenue and expense” are greyed out.
The options for at least one additional column of information and opening and closing balances is essential.