well_sum_missing_invoices

io.github.WellApp-ai/well-mcp · Verify this server

The missing supplier invoices of one ISO week, as one total: how many suppliers still miss an invoice, and the spend they cover, in the currency of the lines and converted to the workspace base currency. It returns no rows. `week` is an ISO week, `YYYY-Www` (Monday to Sunday), for example `2026-W40`. A week has ended when its Sunday has ended in the workspace time zone. Omit it to read the last week that has ended. A refusal carries `error_code`: `week_invalid` for a week its year does not have (a week 53 in a 52-week year), `week_not_ended` for a week that has not ended yet, `no_workspace` when no workspace is in context, `read_failed` when the read of the week failed. Pass `through_today: true` to read the week that is running: with `week` omitted it reads the current ISO week, and a named week that has started reads from its Monday to today in the workspace time zone. `is_complete` is false for that open window, so the figures cover the days so far and never compare to a full week. A week that starts after today is still refused with `week_not_ended`. Without `through_today`, a week that has not ended is refused. `supplier_count` counts the suppliers that still miss an invoice, with the gaps and the row rule of the missing-invoices card. `total` is the spend those suppliers cover, converted to `currency` (the workspace base currency). It is `null` when a line has no exchange rate for its date: a partial sum would read as the whole figure. It covers the named suppliers' groups only, so it is not the conversion of a `net` below, which also holds the groups with no named supplier. `totals_by_currency` is the money of the week still missing an invoice, ONE set per currency in the lines' own currency (the currency the bank lines are in), in major units: `gross`, the `copies` and `own_company` movements it holds, and `net`, the figure to quote. Never add two sets, and never convert one. It is `null` when the figures could not be read. `totals_unreadable_count` counts the lines with no readable amount, which sit in no figure. `bank_connected` is true when the workspace has a bank feed connected: synced, syncing, or in error. It is false when no bank feed is connected, or every one is disabled or not set up. Only a live bank feed counts: a workspace with imported bank statements only reads false too. Then Well sees no bank spend for the week, so its figures cannot say that nothing is missing: the week could not be checked. `pending_count` counts the transactions of those suppliers whose candidate invoice already waits for a confirmation. They are in `supplier_count` and `total`, as on the card. `unattributed_group_count` counts the groups of spend with no named supplier. They are not in `supplier_count` or `total`, and they are in `totals_by_currency`. `candidates_truncated: true` means the scan filled its page, so `supplier_count`, `total` and `pending_count` are floors; `totals_by_currency` is read apart and still covers every line. This tool reads the user's data and changes none of it. When the token authorizes one workspace, call this directly — no workspace call is needed first. When it authorizes several, this read will not guess which one you mean: pass `workspace_id` on the call.