Supplier Balance Detail Report - modern view - where is 'Report Date' button?

Hi, cp-books. The Current and Report date options are only available in the Classic View. In the Modern View, you can set the Report period to Custom dates to view supplier balances for a specific date.

After selecting Custom dates, make sure to set the as of date to display the information you need. Then, click Save As to keep the report unchanged.

You can access your customised report from the Reports menu > Custom reports.

Let us know if you need any further assistance. We're here to help.

Hi

Yes I am aware that you can change the custom date. But this then gives you the current value of the creditors up to the month end date entered, rather than the value of the creditors as at that date. that is the distinction which is available on the classic report by toggling between  'Current' and 'Report date'.

As an example - I have run today a client's suppler balance detail report in both Classic and Modern views, setting the custom date to 28/02/26. I have also run a TB as at 28/02/26.

• The TB shows the value on the Creditors Control Account as at 28/02/26 as £56,396
• The total on the Supplier Balance Detail report, Classic view, with Report Date selected is £56,396. This matches the balance on the TB as at that date.
• The total on the Supplier Balance Detail report, Classic view, with Current selected is £50,953. This is because the Current view is now including any payments made against the invoices shown ( dated on or pre28/02/26) which were applied after 28/02/26.
• The total on the Supplier Balance Detail report, Modern view, is £50,953. ie it matches the 'Current' view on the Classic report. It does not match the TB at that date. How do I customuse the Modern report to show the actual balance as at 28/02/26 ie excluding subsequent payments.

This is very important as for accounts preparation you need to be able to run a breakdown of the figure shown no the TB as at a certain date. the Modern report does not do this - in the above example the Modern report shows a total of £50,953 which does not match the figure of £56,396, for the reasons explained above.

Hello there, cp-books. You can click the Customise button to find the Current and Report Date options in the Modern View. It ensures the report ignores any activity occurring after 28/2/2026, allowing you to total to align perfectly with your Trial Balance.

To start, go to the Customise button and scroll down to the Ageing tab. Select the dropdown option to show the Ageing method. You can now select the Current or Report Date to ensure your balance matches the Trial Balance.

If you have other concerns in QuickBooks, you can use the Reply button below. We're here to help.