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
rachelfork57
Level 1

How to extract supplier ledger?

 
1 Comment 1
JessT
Moderator

How to extract supplier ledger?

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!