Skip to main content

Chart of Accounts

How to build Custom XBerts on the Chart of Accounts data area - policing account configuration: watchlisted accounts still active, revenue/expense accounts missing a tax type, bank-account currency, suspense/clearing accounts and fixed-asset roles.

Written by Marsha Galicia

The Chart of Account in XBert represents a single general-ledger account and its configuration - account code, name, type and classification, status, tax type, and the bank-account attributes where the account is a bank account. It also flags the account's fixed-asset roles (asset, depreciation, accumulated-depreciation) and whether it is on the watchlist.

Use this area to police the chart of accounts: watchlisted accounts still active, revenue or expense accounts missing a tax type, bank accounts in an unexpected currency, suspense or clearing accounts in use, or fixed-asset accounts that are mis-configured.


The AI will only look back at 12 months' worth of data.

Key Properties:

  1. AccountCode: The account code (account number) as configured in the ledger chart of accounts, e.g. '200', '610'. May be empty if the ledger has no code for the account.

  2. AccountName: The display name of the chart-of-accounts entry as configured in the ledger, e.g. 'Sales', 'Office Expenses', 'GST'.

  3. AccountClassification: The top-level classification of the account: typically 'ASSET', 'LIABILITY', 'EQUITY', 'REVENUE' or 'EXPENSE'. This is the broadest category; use AccountType for the sub-category. Copied verbatim from the ledger, so match on exact values without assuming casing.

  4. AccountType: The sub-category of the account within its AccountClassification (e.g. 'CURRENT', 'CURRLIAB', 'FIXED', 'DEPRECIATN', 'OVERHEADS', 'SALES'). More specific than AccountClassification. Copied verbatim from the ledger, so match on exact values without assuming casing.

  5. AccountStatus: The lifecycle status of the chart-of-accounts entry: typically 'ACTIVE' or 'ARCHIVED'. Archived accounts are inactive and should not receive new transactions. Distinct from BankAccountStatus, which is the bank-feed status of a bank-type account.

  6. SystemAccountRole: The role this account plays when it is a system/special account (e.g. accounts receivable, accounts payable, GST/tax control). This is not the account status, type, or classification, and is empty for ordinary user-defined accounts.

  7. TaxType: The account's default tax type code/name configured in the ledger, e.g. 'OUTPUT', 'INPUT', 'GST on Income', 'NONE', 'BAS Excluded'. Copied verbatim from the ledger - match on exact values and do not change the casing. Empty means no default tax type is set on the account.

  8. AccountIsOnWatchlist: True if this account has been flagged on the tenant's account watchlist for closer monitoring; false otherwise.

  9. BankAccountType: The bank-feed account type for bank/credit-card accounts only (e.g. 'BANK', 'CREDITCARD'). Empty for ordinary (non-bank) accounts. This is the bank-feed type, not the chart-of-accounts AccountType.

  10. BankAccountCurrencyCode: The ISO currency code of the bank-feed account (e.g. 'AUD'), set for bank/credit-card accounts only; empty for ordinary (non-bank) accounts.

  11. BankAccountStatus: The bank-feed status of a bank/credit-card account, populated for bank-type accounts only; empty for ordinary (non-bank) accounts. Distinct from AccountStatus, which is the chart-of-accounts lifecycle status (ACTIVE/ARCHIVED).

  12. IsFixedAssetTypeAssetAccount: True if this account is configured as the asset (capitalised cost) account on at least one fixed-asset type in the tenant's fixed-asset register; false otherwise. Identifies chart-of-accounts entries that hold the cost of fixed assets.

  13. IsFixedAssetTypeDepreciationAccount: True if this account is configured as the depreciation (depreciation-expense) account on at least one fixed-asset type; false otherwise. This is the profit-and-loss expense account that depreciation charges are posted to.

  14. IsFixedAssetTypeAccumulatedDepreciationAccount: True if this account is configured as the accumulated-depreciation (contra-asset) account on at least one fixed-asset type; false otherwise.

  15. IsUsedInFixedAssets: True if this account is referenced (as the asset, depreciation, or accumulated-depreciation account of its fixed-asset type) by at least one actual registered fixed asset; false otherwise. Distinguishes accounts merely configured on a fixed-asset type from accounts that real assets are booked against.

📝 Example Alerts

Alert me when an account on the watchlist is still active.
Alert me when a revenue or expense account has no tax type set.
Alert me when a bank account's currency code is not AUD.
Alert me when a new account is added with "suspense" in its name.
Alert me when an account is archived but still marked as used in fixed assets.
Did this answer your question?