Clients/Suppliers Balance

Accurately managing client and supplier balances is crucial for financial control, timely payments, and effective debt recovery. This guide covers how to track balances, adjust them when necessary, and generate detailed reports to support informed decision-making.

Viewing Balance Information

Accessing Client/Supplier Balances

Go to Analytics → Clients/Suppliers Balance

By default, the report is generated for the current month (from the 1st to today).

You can change the reporting period – for example, last 3 months.

Using Search and Filters

Use the Quick Search field to find a client or supplier by organization name or Tax ID.

Apply quick filters to:

  • 🔹View only active clients/suppliers.
  • 🔹Show accounts with outstanding debt, prepayments, or zero balances.

Report Details

The balance report includes:

  • 🔹Status of the client/supplier
  • 🔹Opening Balance
  • 🔹Current Balance
  • 🔹Pending Payments
  • 🔹Overdue Amounts
  • 🔹Total transactions for the selected period

Detailed View

Double-click an organization name to open their client/supplier card, where you can:

  • 🔹Edit company details
  • 🔹View full transaction history
  • 🔹Add balance adjustments
  • 🔹Add inflow or outflow payments

Adjusting Balances

Adding a Payment

Go to Operations → Payments

Click +create.png.

Fill out the form with:

  • 🔹Client/Supplier
  • 🔹Amount Paid
  • 🔹Payment Method
  • 🔹Transaction Date

Click Save to apply the payment and update the balance.

Issuing a Credit Note

Navigate to Customers/Suppliers → Payments.

Double-click the relevant invoice to open it.

Click Change to switch to edit mode.

Enter the adjustment amount (e.g., a discount, return, or correction).

Click Save to apply the credit and update the client's or supplier’s balance.

Generating Balance Reports

Generating the Report

  • 🔹Go to Analytics → Clients/Suppliers Balance
  • 🔹Choose a custom date range
  • 🔹Apply additional filters if needed

Exporting the Report

  • 🔹Click Download as Excel on the control panel
  • 🔹Save the file to your computer for archiving, accounting, or audits

Best Practices

✅ Reconcile balances regularly to prevent discrepancies.

✅ Set up automated alerts for overdue payments.

✅ Ensure all invoices and payments are properly recorded to maintain accurate financial data.