Get expense cash summary
Summarize manual operational cash outflows for one business day. It includes paid manual expenses and payments allocated to manual credit expenses. It excludes received CFDI invoices and unpaid manual expenses. Historical coverage is forward-only until a backfill is intentionally run.
get_expense_cash_summaryPurpose
Summarize manual operational cash outflows for a business day.
- Use when
- You need paid manual expense cash flow.
- Do not use when
- You need received CFDI expenses or unpaid expense balances.
- Required permissions
- Side effects
- None
- Idempotency
- Idempotent
Input schema
JSON Schema{ "type": "object", "properties": { "date": { "description": "Business date in YYYY-MM-DD; defaults to the org's today", "allOf": [ { "$ref": "#/definitions/__schema0" } ] }, "activityLimit": { "description": "Top suppliers, categories, and locations; defaults to 4", "allOf": [ { "$ref": "#/definitions/__schema1" } ] } }, "$schema": "http://json-schema.org/draft-07/schema#", "additionalProperties": false, "definitions": { "__schema0": { "type": "string" }, "__schema1": { "type": "integer", "minimum": 1, "maximum": 10 } }}Output schema
JSON Schema{ "type": "object", "properties": { "data": { "type": "object", "properties": { "source": { "type": "string", "const": "cash_expenses" }, "currency": { "type": "string", "const": "MXN" }, "date": { "type": "string", "pattern": "^\\d{4}-\\d{2}-\\d{2}$" }, "historicalCoverage": { "type": "string", "const": "forward_only" }, "accountingBasis": { "type": "string", "const": "cash" }, "totals": { "type": "object", "properties": { "cashOutflow": { "type": "number" }, "movementCount": { "type": "number" }, "classified": { "type": "number" }, "unclassified": { "type": "number" }, "unallocated": { "type": "number" } }, "required": [ "cashOutflow", "movementCount", "classified", "unclassified", "unallocated" ], "additionalProperties": false }, "bySource": { "type": "array", "items": { "$ref": "#/definitions/__schema0" } }, "byPaymentMethod": { "type": "array", "items": { "$ref": "#/definitions/__schema0" } }, "top": { "type": "object", "properties": { "suppliers": { "type": "array", "items": { "$ref": "#/definitions/__schema1" } }, "categories": { "type": "array", "items": { "$ref": "#/definitions/__schema1" } }, "locations": { "type": "array", "items": { "$ref": "#/definitions/__schema1" } } }, "required": [ "suppliers", "categories", "locations" ], "additionalProperties": false } }, "required": [ "source", "currency", "date", "historicalCoverage", "accountingBasis", "totals", "bySource", "byPaymentMethod", "top" ], "additionalProperties": false }, "error": { "$schema": "http://json-schema.org/draft-07/schema#", "type": "object", "properties": { "code": { "type": "string", "enum": [ "validation_error", "unauthenticated", "forbidden", "not_found", "method_not_allowed", "conflict", "idempotency_conflict", "operation_in_progress", "recovery_required", "rate_limited", "provider_unavailable", "internal" ] }, "message": { "type": "string" }, "details": { "type": "object", "properties": { "issues": { "type": "array", "items": { "type": "object", "properties": { "path": { "type": "array", "items": { "anyOf": [ { "type": "string" }, { "type": "number" } ] } }, "message": { "type": "string" }, "code": { "type": "string" } }, "required": [ "path", "message" ], "additionalProperties": false } }, "retryable": { "type": "boolean" }, "retryAfterSeconds": { "type": "integer", "exclusiveMinimum": 0, "maximum": 9007199254740991 } }, "additionalProperties": false } }, "required": [ "code", "message" ], "additionalProperties": false } }, "$schema": "http://json-schema.org/draft-07/schema#", "additionalProperties": false, "definitions": { "__schema0": { "type": "object", "properties": { "key": { "type": "string" }, "amount": { "type": "number" }, "share": { "type": "number" } }, "required": [ "key", "amount", "share" ], "additionalProperties": false }, "__schema1": { "type": "object", "properties": { "name": { "type": "string" }, "amount": { "type": "number" }, "movementCount": { "type": "number" }, "share": { "type": "number" } }, "required": [ "name", "amount", "movementCount", "share" ], "additionalProperties": false } }, "oneOf": [ { "required": [ "data" ] }, { "required": [ "error" ] } ]}Related workflow
See the canonical workflows in the introductionRelated tools
Get sales receipt summary
Summarize sales recorded as Exac receipts for one business day. Use this for 'how much did I sell?'. It includes receipts later invoiced and receipts never invoiced, and never adds CFDI totals separately.
Get CFDI collection summary
Summarize gross cash collected through valid sent Type I invoices for one CFDI civil day. PUE invoices are recognized on Fecha and PPD collections on payment-complement FechaPago. PPD parents are never counted as cash, so payment allocations cannot double count them. Historical coverage is forward-only until an intentional backfill.