the total paid by particular supplier

Options
Peter_9962328
Peter_9962328 Member Posts: 40 Reckoner Reckoner

Reckon One

How can I get a report on all payments made, including the total, to a particular supplier during a financial year.

The 'supplier' report gives the individual expenses, but not the total

Answers

  • Rav
    Rav Administrator, Reckon Staff Posts: 14,372 Reckon Community Manager Community Manager

    Hi @Peter_9962328

    This post has been created in the Reckon Accounts Hosted category however I see you've mentioned Reckon One in your post.

    Can you please confirm which software you're using and if possible, please add it to the My Reckon Software field in your Community profile by clicking HERE.

  • Nickiu
    Nickiu Reckon Alumni Posts: 227 Former Reckon Staff Member Former Reckon Staff

    Hi @Peter_9962328

    The alternative would be to generate supplier transactions, which you can filter by supplier names, report period, etc., and then export them as a CSV file to calculate the total using the amount column

    image.png

    Hope this helpful,

    Let me know if you have any another questions.

    Nick

  • Peter_9962328
    Peter_9962328 Member Posts: 40 Reckoner Reckoner

    Thanks Nick, that did the trick

    (Had worked it out myself in the mean time. Had some trouble with the .csv saving the $ figures as text and not adding these up, but got there in the end. Lot of time though.)

    Still, I think the $ total should be an optional selection in the Reckon One report builder.

    In general I would love to see more data selection options being made available to construct the reports.

    Thanks for your help

    Peter