Require ability to export (.csv); Customer Code, Payment Date, Payment Value as a report.If I can filter this by nominal code even better.Essentially the ability to export customer payments so I can reconcile them in a separate system.
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
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:
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)
You won't be notified about changes to this idea.