Report - Optimized Excel export layout for Account Transactions report to support Excel tables and pivot analysis
Adjust layout of a downloaded Account Transaction report from Xero to an excel format for a period of to enable 'Insert a Table' analysis
Attached please find a file which shows an existing tab Purchases Transactions for JA26 / second tab New layout for Excel and third tab shows final 'Insert a table to produce a report for simpler presentation and analysis
Thanks for sharing this idea. A table-ready Excel export of the Account Transactions report could make it easier to use filters, create pivot tables and analyse data without manual formatting.
I’ve updated the status to Gaining Support so we can continue tracking community interest. Add your vote and share how you’d use this export.