cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here

Reply to message

View discussion in a popup

Replying to:
JessT
Moderator

Reply to message

Hi rachelfork57,

 

Currently, we're unable to create this report, but the closest we have is the Transaction List by Supplier. Though this will not give you the forwarded balance and the running balance, you can get them from the Supplier Balance Detail (or Summary) report.

 

What I do is I export the Transaction List by Supplier to Excel. Then, I insert a row for the forwarded balance to be the first transaction line for each supplier, and then I use Excel's AutoSum feature to add the running balance at the bottom part.

  1. Click on Reports.
  2. Choose Transaction List by Supplier.
  3. Change the date range and click Run Report.
  4. Click the Export icon between the Printer and Gear icons.
  5. Choose Export to Excel.

You can also check about customizing reports and managing them.

 

Let me know if you need anything else. Have a good day!