Help us improve

Export Payments

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.

  • George Ross
  • Oct 16 2020
  • New
  • Attach files
  • G B commented
    21 Oct, 2020 03:53pm

    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.

  • George Ross commented
    20 Oct, 2020 03:30pm

    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.

  • G B commented
    19 Oct, 2020 03:14pm

    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)