None of the reports suggested provide a total, regardless of the filters I applied.
MissMary, thank you so much for suggesting we add the Name filter as it was a game changer for me. I did it a little differently and was able to generate the total for a single vendor by using the following report/filters:
Reports > Custom Reports > Transaction Detail, select Bill > Filters > Name, select vendor > OK and run Report Basis as CASH
TIPS:
1.) Search for vendor under "multiple names" to find it faster.
2.) To simplify the report, keep only columns: Type, Date, Name, Credit and Debit
3.) Memorize the report for quick access and just change the vendor as needed.
I hope this helps!!