Subsidiary Balance (Customers / Suppliers)

The Subsidiary Balance shows the balance of each auxiliary account (customers, suppliers, banks, employees) grouped by control account. It verifies auxiliary account balances for the selected fiscal year.

Overview

• Filters by type: All, Customers (C), Suppliers (F), Banks (B), Employees (S)
• Grouped by account number and label
• Subtotals per group and grand total (debit, credit, balance)
• Empty state: no entries in the selected period
• Warning: opening balance recalculation failed
• Export to Excel (.xlsx) and PDF

Key Features

Filter by Auxiliary Type

Use the tabs to filter rows by auxiliary category. The filter applies instantly without page reload.

Grouping by Account

Rows are grouped by account_id. Each group shows:

• Account number and label
• Auxiliary code and label
• Total debit, total credit, balance

Export

Two export buttons in the page header:

• Export Excel: .xlsx file
• Export PDF: .pdf file

Export is disabled while another export is in progress.

Opening Balance Warning

If opening balance recalculation failed, a warning banner appears at the top (anError).

Step-by-Step Tasks

1. Go to /accounting/auxiliary-balance (or /clients, /suppliers, /banks, /employees)
2. Select the auxiliary type using the tabs (optional)
3. Review account groups and their balances
4. Click Export Excel or Export PDF to download the report

Tips

• Use the All filter for a global view of all auxiliary accounts.
• Balance is calculated as debit − credit; it can be negative.
• If the empty state appears (no_entries_in_range), check that a fiscal year is selected.

Troubleshooting

Issue	Probable cause	Solution
No results shown	No entries for the period	Verify the selected fiscal year
Red warning banner	Opening balance recalculation failed	Contact support; balances may be outdated
Export button inactive	Export in progress	Wait for the current download to finish

---

Need help? Contact our technical support.