Enter your idea

We desperately need an audit trail report available for advisors.

I think it would be sufficient to have the below added to the account transactions report style (but named as Audit Trail):
1 - the ability to include an 'edited date' column
2 - the ability to include a 'notes' column
3 - a tick box to show/hide audit trail history (so voids would show as separate creation and void lines netting off, not just removal of the original transaction)
4 - a unique un-editable transaction identifier for all transactions, not just bills/invoices

It must be exportable to excel with the dates on every line.

So many times I have gone to produce a set of accounts and the prior year has changed because the date wasn't locked, or the client unlocked it, or someone didn't realise they shouldn't retrospectively correct the bank after filing the year end...