Yeah, the reports are pretty bad. They also take up a lot of paper.

I programmed excel macros for an improved Nominal Ledger, VAT Review report and macros to format the aged debtors/creditors in excel.

I had intended posting on this forum, but Excel sheets with Excel VBA code get blocked.

I see what you're doing, the Sage option works best, thank you.

As you say ugly. I do hope the Kashflow team are going to put some serious effort into the reporting side, it will make a major difference in what is a competitive accounting/bookkeeping market.

Thanks again, much appreciated.

An ugly version of this can already be done:

Go to Reports

'Business Tab'

Select 'Audit Trail' Report

untick everything except 'Invoice Payments'

Enter dates at top

Click Download CSV button at the top right.

As with all Kashflow reports - This is not a well laid out.

An alternative is to go into reports again:

Business Tab

Select 'Sage Export' report

Put a tick in the option 'Include payments in Audit Trail transactions' (next to dates)

Select to download the Audit Trail transactions

Open the file in Excel

Sort by Column A and look for SR (Sales Receipts) and SA (Sales Payment on Account)