We can run the Vendors Balance Detail in your book, orenmarciano.
The Vendors Balance Detail report generates all bills to your different suppliers. In the Transaction Type column, you'll see the bills that you may need to pay. However, we can only filter it by the current week and the previous week.
What we can do is customize the report by the unpaid bills and select either the current week, next week and the previous one on the reporting period. Then, export it to Excel. This way, you can have these transactions by week through exporting them.
I'll guide you how:
- Go to Reports on the left panel and enter Vendor Balance Detail in the search box.
- Click the Customize button at the upper-right corner. Then, select the Filter section.
- Put a check inside the Vendor and A/P Paid boxes. For the Vendor side, select Specified so the report will populate by vendors. And for the A/P Paid, select Unpaid to see all the bills you may need to pay to your suppliers.
In the reporting period, you can filter the dates you want QuickBooks to populate. Then, export this report by clicking the Excel icon next to the small gear icon. Then, select Export to Excel.
You'll want to make the report more personalize by checking out this article.
Please get back to me if you have additional questions about QuickBooks Online reports. I'll be around anytime to assist you further! Take care!
