Forum Discussion

ro1's avatar
ro1
Contributing User
2 months ago
Solved

Grand Total for Supplier payments

Hi 

Is there any way to run a report that shows supplier payments made for a specific period with a grand total at the bottom? I'm just trying to work out cash required in our bank account!

Thanks :)

  • JulieAC's avatar
    JulieAC
    2 months ago

    hi ro1 

     

    Try going to reports>purchases>payments>supplier payments.  Put in your date range, run the report and then export it to excel, where you can then do an auto sum of the payments column to get your total.

     

3 Replies

Sort By
  • Earl_HD's avatar
    Earl_HD
    MYOB Moderator
    2 months ago

    Hi ro1,

    Thank you for your post. If you're searching for supplier payments with a total amount, I recommend running the Supplier Purchase (Detail) Report or Supplier Payment Reports. For more detailed guidance, please refer to this help articles: Supplier Payment History report and Supplier Payments report. 

     

    Feel free to post again, we're happy to help!

     

    If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

     

    Regards,
    Earl

    • ro1's avatar
      ro1
      Contributing User
      2 months ago

      Hi 

      Thanks for your reply, but I am looking for a report that has a GRAND total - so if I pay supplier A $200 and Supplier B $300 then the grand total at the bottom of the report would be $500 in total payments made.

       

      Thanks

  • JulieAC's avatar
    JulieAC
    Contributing Cover User
    2 months ago

    hi ro1 

     

    Try going to reports>purchases>payments>supplier payments.  Put in your date range, run the report and then export it to excel, where you can then do an auto sum of the payments column to get your total.