How can I calculate the closing balance

To calculate the closing balance in an account, you start with the opening balance and then adjust it for all transactions that occurred during the period.

The general formula is:

$$\text{Closing Balance} = \text{Opening Balance} + \text{Total Debits} - \text{Total Credits}$$

• Opening Balance: This is the balance carried forward from the previous period.
• Total Debits: These are transactions that increase the balance of the account (e.g., new sales/invoices for a customer account).
• Total Credits: These are transactions that decrease the balance of the account (e.g., payments received or credit notes for a customer account).

For example, in a customer's statement of account (from the seller's perspective):

$$\text{Closing Balance} = \text{Opening Balance} + \text{Invoices} - \text{Receipts} - \text{Credit Notes}$$

The result is the amount the customer owes at the end of the period.