Reports - Option to include additional information when summarising Account Transactions report
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.