Back

Client Balances and Statement

The system shows several balances for each client that explain their financial position with you: what they owe, what is overdue, and any credit they have with you. This guide explains what each balance means, where it appears, how to view the client statement, transactions, and journal entries, and why the end of period balance differs from the other balances.

🛈

Note: Client balances appear to users with the View All Clients permission, or the View His Own Clients permission if the client is one of their clients.

Client Balance Types

An invoice issue date may differ from its payment due date, so the system separates everything the client owes from what is already due:

Balance What It Means
Open Total unpaid amounts owed by the client, whether due or not. It is the client’s debit balance.
Overdue Amounts past their due date and not yet paid.
Credit An amount the client has with you, such as a credit opening balance, a sales return, or an overpayment not yet distributed to invoices.
  • Open and Overdue are usually equal if invoices are due upon issue.
  • Overdue does not appear if no invoice due date has passed yet.
  • A balance does not appear if its value is zero, and balances are split by currency if the client deals in more than one currency.

Where Client Balances Appear

Location What Appears
Client profile Open, Overdue, and Credit.
Create sales invoice screen Credit and Open in the invoice currency, below the client details after selecting the client.
Statement and Transaction List Start of period balance, all transactions, and the End of period balance.
Client account in the Chart of Accounts The debit and credit sides of every journal entry recorded for the client.

Viewing Client Balances from the Client Profile

  1. From the main menu, click Clients.
  2. Click Manage Clients.
  3. Open the client profile; the balances appear at the top: Open with the total owed, Overdue with the overdue part, and Credit if the client has a balance with you.

Client Balance on the Create Invoice Screen

When you create a sales invoice and select the client in the Client field, the client’s balances appear below their details in the invoice currency, so you know their position before saving the invoice:

  • Credit: the client’s available credit balance, with a Distribute button for users with permission to distribute it to invoices.
  • Open: the total unpaid amounts owed by the client.
  • Balances update automatically when you change the client or the invoice currency.

🛈

Note: The Overdue balance does not appear on the invoice screen; to view it, open the client profile.

Using the Client Credit Balance

If the client has a Credit balance, you can use it to pay their invoices in one of the following ways:

Method How
Distribute the balance to invoices Click Distribute next to the credit balance in the client profile or on the invoice screen, and select the unpaid invoices. See Distributing Client Credit Balance from the Client Profile.
Pay from the balance when creating the invoice In the payment record, select Client Credit as the payment method.
Automatic payment Enable automatic payment of invoices from the client balance, so new invoices are paid from it automatically. See Automatic Payment of Invoices from Client Balance.

Client Statement

  1. Open the client profile.
  2. Click Statement.
  3. The account summary, the transactions, and the amount due from the client appear, along with the print and PDF download buttons, and the Email to Client button if the client has an email in their profile.

Transaction List

From the client profile, click the Transaction List tab to view all client transactions:

Item What It Shows
Start of period balance The client’s opening balance, if any. See Client Opening Balance.
Date The transaction date, such as the invoice date or the payment date.
Transaction The type and number of the transaction that caused the entry.
Due Date When the amount is due; it may differ from the transaction date.
Amount The transaction value; amounts are added up to reach the end of period balance.
End of period balance The client’s net balance up to this moment after all transactions.
  • To view the items of each transaction, enable Show Details.
  • From the same tab you can print, export, email the client, and control the additional fields shown from Statement Settings.

Why Does the End of Period Balance Differ from the Open Balance?

The End of period balance may equal the Open balance minus the Credit balance, but this is not a rule. Some transactions are recorded in the statement without affecting the open or overdue balance, such as a manual journal entry on the client account. So rely on the End of period balance to know the client’s net balance including all transactions.

Viewing Client Transaction Journal Entries

  1. In the client profile, click the ledger account number below the client name.
  2. The client account appears in the Chart of Accounts under the Clients account, with all its debit and credit entries.
  3. Click any entry to view its journal entry in detail, then View Source to open the transaction that created it.

🛈

Note: Viewing journal entries requires the Accounting app to be enabled and the permission to view journal entries.

FAQs

Does the client balance appear on the sales invoice?

Yes; after selecting the client on the create invoice screen, their Credit and Open balances appear below their details in the invoice currency. Details.

What is the difference between the Open and Overdue balances?

Open is everything the client owes in unpaid amounts, and Overdue is the part that is past its due date.

Why does the Overdue balance not appear?

Because no unpaid invoice due date has passed yet. This balance also does not appear on the create invoice screen; open the client profile to view it.

The client has a credit balance; what does it mean?

It means the client has an amount with you, such as a credit opening balance, a return, or an overpayment. You can distribute it to their invoices or use it to pay a new invoice; see Using the Client Credit Balance.

Why does the end of period balance in the statement not equal Open minus Credit?

Because the statement includes transactions that do not affect the open balance, such as manual journal entries on the client account. Rely on the End of period balance as the comprehensive balance. Details.

How do I send the statement to the client?

Open the Statement from the client profile and click Email to Client. The button appears only if the client has an email in their profile.