Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI need to see the balance brought down from another period when I run the supplier balance detail report. Please may you assist?
I might have an idea on how to do this, DBD1.
When pulling up the Supplier Balance Detail report, we can customize the Report period and the Aging method. With this customization, the report will display the balances from a specific period. Here's how:
You can also use this link when customizing reports: Customize reports in QuickBooks Online.
You might also want to try the Expenses by Supplier Summary report. You can filter out out the transaction types and set the date range.
We'll be right here if you have additional queries in customizing the report or getting your supplier data. Have a great day!
Thank you for the response. I would like to see the closing balance in 2019 which is the opening in 2020 as well as the running 2020 balance. Currently the 2019 opening balance is not reflecting.....
Hi DBD1!
We're unable to add a column to the Supplier/Vendor Balance Detail report. What I can suggest is to set the date of the said report to as of 12/31/2019 to see the supplier ending balance of 2019. If you need the supplier opening balance of 2019, run the report and set it to as of 12/31/2018.
Then, you can export the reports for 2018 and 2019 to the Excel file and merge them from there to create one report. Simply click the Export button next to Print and select Export to Excel.
Keep on posting here if you need more help. We'll respond as soon as we can.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.