Client and Supplier Monthly Balance Reports

Overview

The Client and Supplier Monthly Balance Report provides a detailed breakdown of outstanding invoice balances for the past six months, grouped by client or supplier. This report offers valuable insights into your client debtor or supplier creditor balances, helping you stay on top of unpaid invoices and better manage your cash flow.

The amounts displayed are in GBP, and you can click on the balances to drill down into the unpaid or partially paid invoices that contribute to the totals.

How this report helps

  • Focus on which client invoices need to be chased.
  • Identify supplier balances that are due or overdue for payment.

How to Access the Report

To access the Client and Supplier Monthly Balance Report:

  1. Navigate to the Reports menu.
  2. Select Show All Reports.
  3. Find and select the Client or Supplier Monthly Balance Report.

Monthly Balance Report vs. Ageing Reports

While the Monthly Balance Report shows all outstanding invoices, the Debtor and Creditor Ageing Reports focus specifically on overdue invoices — those that have exceeded their agreed payment terms.

  • Monthly Balance Report: Covers all outstanding invoices, whether due or not.
  • Ageing Reports: Highlight invoices that are overdue segmented by age, providing a more targeted view for managing overdue payments.

Both reports complement each other and are useful for assessing the company’s financial health, helping you evaluate cash flow efficiency and debt recovery performance.