I'm trying to run a report for bills paid with check number information. However, I need the report by bill date not by payment date (accrual/GL date). Ideally, the report would be sorted by check number but if this is not possible I can do it in excel.
It's nice to have you here in the Community, @Ana B.
You have the option to open/run the Transaction List by Vendor report to sort the report by bill date. Allow me to share some information and help guide you how.
If you're running the Bills and Applied Payments report in QuickBooks Online (QBO), for now, we don't have the option to run the report by bill date. The report is sort by bill payment date. However, you may export the report to Excel and sort the report by bill date from there.