If i need a supplier/vendor statement or detail ledger with all transactions with total DR/CR

Hi there, @official-zahid-g.

You can pull up the Transaction Detail by Account report to see your supplier or vendor's statement with the debit and credit information. I'll guide you on how to customize the report.

1. Sign in to your QuickBooks Online (QBO) account.
2. Click on Reports at the left pane.
3. Look for Transaction Detail by Account, then open the report.
4. Go to the Customize tab, then filter the Name to the supplier's name.
5. Tap on the Run report tab to refresh the page.
6. You can then go to the small gear icon to select the columns you want to add including the Debit and Credit.

You can also check out this article for additional tips about creating a ledger report in QBO: Create a report that shows Debits and Credits for each transaction.

Otherwise, you can run the Transaction List by Vendor or Supplier report to see the transactions you have for each vendor.

In case you want to bring the report to Excel, you can also check out this link as your reference: Export your reports to Excel from QuickBooks Online.

Let me know if you have any other follow-up questions about preparing a supplier's ledger. I'm always here to help. Wishing you a good one!