Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
C
cp-books
April 22, 2026
Question

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

  • April 22, 2026
  • 1 reply
  • 6 views

I use the Supplier Balance Detail Report a lot. I prefer the classic view but am trying to get used to the modern view. However the 'Current' and 'Report Date' buttons appear to have disappeared. How do I set the modern report to show me the balances as at a certain date rather than now.

1 reply

J
jamesjdtQuickBooks Team
QuickBooks Team
April 22, 2026

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.

C
cp-booksAuthor
April 23, 2026

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.

J
JayCaeRQuickBooks Team
QuickBooks Team
April 23, 2026

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement