Get account balances
collmex_get_account_balancesAccount balances from the Collmex accounting (record ACCBAL_GET) for a fiscal year: account number, name and balance. Filter by account, account group (1 other, 2 fixed assets, 3 bank/cash, 4 income, 5 expenses, 6 output VAT, 7 input VAT, 8 receivables, 9 payables, 10 depreciation, 11 provisions, 12 inventory, 13 private, 14 non-deductible expenses), cost centre or an up-to date. With a customer or vendor given, the date is ignored.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Records returned, 1-500 (default 25; invoices and orders with many positions may need a smaller limit). | |
| offset | No | Records to skip (use next_offset from the previous reply). | |
| date_to | No | Balance up to this date (yyyy-mm-dd). | |
| vendor_no | No | Balance of this vendor. | |
| account_no | No | Only this account number. | |
| company_no | No | Collmex company number (Verwaltung → Firma anzeigen und ändern). Default 1. | |
| cost_center | No | Only this cost centre. | |
| customer_no | No | Balance of this customer. | |
| fiscal_year | Yes | Fiscal year, for example 2026. | |
| account_group | No | Only this account group (1-14). |