Skip to main content

Squillify development is paused indefinitely. Read why, and discover what this experiment achieved. Read the story

MicroSkills Reference

Check Trial Balance

accounting.trial_balance_check

ProductionBounded custom (Class B)Deterministicstrictinstantv1.0.0
No network

Overview

Perform a bounded exact-decimal trial balance check and return totals, signed differences, and the equality decision. Input shapes are closed, order is stable, and no currency conversion, materiality threshold, posting, or accounting policy is inferred.

You receive exact decimal totals, signed differences, and the resolved tolerance so the control can be reproduced. This guidance applies specifically to accounting.trial_balance_check.

Reliability

Closed shapes and bounded exact-decimal accumulation fail before expensive work. DECIMAL_INVALID means a malformed or over-limit amount; correct it. CONTROL_INVALID means ids, dimensions, or debit-credit sides violate the closed control; correct the named row. CURRENCY_MISMATCH means rows use different currencies; convert or split them. TOLERANCE_INVALID means tolerance is negative or malformed; send a non-negative decimal. ITEM_LIMIT_EXCEEDED means a row or column bound was exceeded; split the request. This guidance applies specifically to accounting.trial_balance_check.

Context footprint

The compact receipt replaces manual cross-checking while retaining totals and differences. This guidance applies specifically to accounting.trial_balance_check. A successful call costs 1 execution credit.

When to use it

When a list of account balances must prove that total debit equals total credit.

When you are still proving one journal, or accounts need currency translation first.

Scope

Note
Perform a bounded exact-decimal trial balance check and return totals, signed differences, and the equality decision

Non-goals

  • Does not infer materiality, currency conversion, posting, or accounting policy This guidance applies specifically to accounting.trial_balance_check.
  • Does not mutate a ledger, fetch files, or accept unbounded rows This guidance applies specifically to accounting.trial_balance_check.

Properties

IdempotentRetry safeStreaming supportedFile input supportedRequires external service

Capabilities

mathvalidation

Cost & billing

Flat rate per invocation

MetercallsBillable onsuccessCost per call1 credit

File handling

Accepts file_refProduces file_refMax input64 KB

How we handle your data

Sensitive input, safe output
What this means

This skill may receive sensitive content, but it does not target sensitive data and returns only a structured non-sensitive result.

Squillify guarantees
  • Runs inside Squillify
  • This skill runs inside Squillify.
  • Payloads are not sent to an external service by this skill.
  • Squillify does not permanently store submitted payloads.
  • Telemetry records metadata only, not submitted content.
  • Submitted payloads are not used for training.
  • Submitted payloads are not reviewed by humans.
  • This skill does not target sensitive data.
  • The response does not contain submitted content.
Your responsibility

Squillify does not determine whether submitted content is sensitive. Your application is responsible for deciding what data it is allowed to submit. Your application is responsible for securing the response.

Read the Microskill Data Handling Policy

Input schema

FieldTypeRequiredDescription
accountsarrayYesFrom 1 through 10,000 closed rows with the identifier, debit, credit, and currency properties.
tolerancestringNoOptional absolute tolerance; omitted values resolve to zero.

Output schema

FieldTypeRequiredDescription
totalDebitsstringYesExact sum of every supplied non-negative debit amount.
totalCreditsstringYesExact sum of every supplied non-negative credit amount.
differencestringYesDebit total minus credit total.
balancedbooleanYesWhether the difference is within tolerance.
tolerancestringYesResolved absolute tolerance.
currencystringYesShared uppercase ISO 4217 currency.
countintegerYesNumber of input rows.

API contract

POST /v1/execute
curl
curl -sS -X POST "$BASE/v1/execute" -H "Authorization: Bearer $KEY" -H 'Content-Type: application/json' -d '{"skillKey":"accounting.trial_balance_check","input":{"accounts":[{"accountId":"asset","debit":"250","credit":"0","currency":"USD"},{"accountId":"equity","debit":"0","credit":"250","currency":"USD"}]}}'
Integrations
TypeScript SDK
import { Squillify } from "@squillify/sdk";

const sq = new Squillify({ apiKey: process.env.SQUILLIFY_API_KEY });

const { output } = await sq.execute("accounting.trial_balance_check", {"accounts":[{"accountId":"asset","debit":"250","credit":"0","currency":"USD"},{"accountId":"equity","debit":"0","credit":"250","currency":"USD"}]});

Errors

CodeHTTPRetryableDescription
VALIDATION_ERROR400NoThe request payload failed schema validation.
UNAUTHORIZED401NoMissing or invalid API key.
SKILL_NOT_ACCESSIBLE403NoThe API key is not granted access to this skill.
SKILL_NOT_AVAILABLE_FOR_PLAN403NoThis skill is not included in your current plan.
PLAN_ELIGIBILITY_UNAVAILABLE503YesPlan eligibility could not be decided. Retry after backoff.
SKILL_NOT_FOUND404NoThe requested skill or version does not exist.
TENANT_RATE_LIMITED429YesRequest rate limit exceeded. Retry after backoff.
QUOTA_EXCEEDED429YesPlan quota exhausted. Retryable once the quota period resets.
EXECUTION_TIMEOUT504YesExecution exceeded the allowed time budget.
DECIMAL_INVALID400NoThe request payload failed this skill's input validation.
CONTROL_INVALID400NoThe request payload failed this skill's input validation.
CURRENCY_MISMATCH400NoThe request payload failed this skill's input validation.
TOLERANCE_INVALID400NoThe request payload failed this skill's input validation.
ITEM_LIMIT_EXCEEDED429NoA size, quota, rate, or time limit was exceeded.

Other limits

LimitValue
Recommended inline bytes32 KiB

Limitations

  • Does not infer materiality, currency conversion, posting, or accounting policy This guidance applies specifically to accounting.trial_balance_check.
  • Does not mutate a ledger, fetch files, or accept unbounded rows This guidance applies specifically to accounting.trial_balance_check.
  • Currency conversion, posting, or inferred materiality This guidance applies specifically to accounting.trial_balance_check.
  • Matrices or ledgers above the documented bounds This guidance applies specifically to accounting.trial_balance_check.

How to call

POST /v1/execute (requires authentication)

Request bodyjson
{
  "skillKey": "accounting.trial_balance_check",
  "input": {
    "accounts": [
      {
        "accountId": "asset",
        "debit": "250",
        "credit": "0",
        "currency": "USD"
      },
      {
        "accountId": "equity",
        "debit": "0",
        "credit": "250",
        "currency": "USD"
      }
    ]
  }
}

Examples

Exact equality

Inputjson
{
  "accounts": [
    {
      "accountId": "asset",
      "debit": "250",
      "credit": "0",
      "currency": "USD"
    },
    {
      "accountId": "equity",
      "debit": "0",
      "credit": "250",
      "currency": "USD"
    }
  ]
}
Expected outputjson
{
  "difference": "0",
  "tolerance": "0",
  "balanced": true,
  "totalDebits": "250",
  "totalCredits": "250",
  "currency": "USD",
  "count": 2
}

Explicit tolerance boundary

Inputjson
{
  "accounts": [
    {
      "accountId": "asset",
      "debit": "1",
      "credit": "0",
      "currency": "GBP"
    },
    {
      "accountId": "equity",
      "debit": "0",
      "credit": "0.99",
      "currency": "GBP"
    }
  ],
  "tolerance": "0.01"
}
Expected outputjson
{
  "difference": "0.01",
  "tolerance": "0.01",
  "balanced": true,
  "totalDebits": "1",
  "totalCredits": "0.99",
  "currency": "GBP",
  "count": 2
}
  • Deterministic trial balance check
  • Pre-posting fund-accounting equality controls This guidance applies specifically to accounting.trial_balance_check.

Avoid for

  • Currency conversion, posting, or inferred materiality This guidance applies specifically to accounting.trial_balance_check.
  • Matrices or ledgers above the documented bounds This guidance applies specifically to accounting.trial_balance_check.

Composable with

Safety & privacy

  • Runs without calling any external service.
  • Your payloads are never stored permanently.
  • Telemetry captures metadata only — never your payload contents.
  • We never train models on your payloads.
  • No human reviews your payloads.

Tags

accountingmathvalidationfinance