Recued
Menu
← Back to recipes

What went under a tag

by recued-core v3 87 views

Use “What went under a tag” in Recued. Everything spent under one tag, including every tag beneath it, at any depth.

Complete workflow

Ledger book 18 pinned recipes

Use Ledger book in Recued for accounting, double entry, budget, and records. It includes 44 built-in actions and 17 ready-to-run workflows. Actions that change data use Recued's approval controls.

You are viewing one recipe in this workflow. Installing it opens the complete pack so its other recipes and background automations arrive together.

What went under a tag
This recipe

Use “What went under a tag” in Recued. Everything spent under one tag, including every tag beneath it, at any depth.

pack:ledger-bookaccountingtagsbudget
by recued-core pinned v3

Use “The accounts” in Recued. Every account with its id — what you post to, and what anything else in this workflow needs before it can name one.

pack:ledger-bookaccountingaccountsrecords
by recued-core pinned v4

Use “One account” in Recued. Everything the book holds about one account, opened from the Accounts list.

pack:ledger-bookaccountingaccountsdetail
by recued-core pinned v1

Use “The tags” in Recued. Every tag with its id and how deep it sits — the trees you can spend against, and the ids the rest of the pack takes.

pack:ledger-bookaccountingtagsrecords
by recued-core pinned v3

Use “What it all comes to” in Recued. Each currency's balance read exactly, then converted at rates you give and added up.

pack:ledger-bookaccountingcurrencyrecords
by recued-core pinned v3
Show all 18 recipes

Use “Every budget at once” in Recued. All your budgets for a period, each counting everything under its tag — in four queries, however many budgets you have.

pack:ledger-bookaccountingbudgetrecords
by recued-core pinned v4

Use “How a budget is doing” in Recued. What a budget has left, counting everything under its tag at any depth.

pack:ledger-bookaccountingbudgetrecords
by recued-core pinned v3

Use “The lines under a tag” in Recued. Every transaction line under a tag and everything beneath it — the lines themselves, not a total. With a CSV to copy.

pack:ledger-bookaccountingtagsexport
by recued-core pinned v3

Use “Open an account” in Recued. Adds an account to your chart. Its currency is fixed here and every line posted to it inherits it.

pack:ledger-bookaccountingrecordsv2
by recued-core pinned v2

Use “Post an entry” in Recued. One entry, any number of legs, written in a single all-or-nothing transaction. It will not post unless the legs sum to zero.

pack:ledger-bookaccountingdouble-entryrecords
by recued-core pinned v4

Use “Add a tag” in Recued. Adds a tag anywhere in your tree, at any depth. The tag and its place in the tree are written together or not at all.

pack:ledger-bookaccountingtagsrecords
by recued-core pinned v3

Use “Tag a month of lines” in Recued. One tree at a time: every line in a period on one page, with a picker in the tag cell.

pack:ledger-bookaccountingtagsrecords
by recued-core pinned v4

Use “Tag a transaction line” in Recued. Sets which tags a line belongs to, one per tree. Each tag and every tag above it counts the full amount.

pack:ledger-bookaccountingtagsrecords
by recued-core pinned v4

Use “Set a budget” in Recued. A cap on a tag for one period. It counts everything under that tag, at any depth.

pack:ledger-bookaccountingbudgetrecords
by recued-core pinned v3

Use “Move a tag” in Recued. Puts a tag inside a different one. Everything recorded under it follows automatically — no transaction is rewritten.

pack:ledger-bookaccountingtagsrecords
by recued-core pinned v4

Use “Delete a tag” in Recued. Removes a tag and everything beneath it. Refuses while anything is still tagged with it.

pack:ledger-bookaccountingtagsrecords
by recued-core pinned v4

Use “One budget” in Recued. Open one budget from the list that names it, and read everything recorded about that budget on one page.

pack:ledger-bookbudgetdetailnavigation
by recued-core pinned v1
View pack details, dependencies, and permissions →

Any level, same answer

Ask about a leaf and you get the leaf. Ask about the tag three levels above it and you get everything underneath, at any depth. There is no separate "rolled up" mode, because there is no separate stored total — the tree is read at the moment you ask.

⛔ A parent equals the sum of its children. Always, by construction: the tag you ask about is one of its own descendants, and so is everything beneath it. Nothing is stored twice and nothing has to be recomputed when you reorganise.

⛔ Every line counts in FULL at every level above it. A line tagged to a person is fully that person's, fully their department's, fully their division's — the same money seen from further out. Nothing is apportioned, so the number here needs no reconciliation.

⚠ Lines and transactions should always match. They can only differ if one line carries two tags from this tree, which tag-leg refuses — so a mismatch means a row got in some other way, and the check is on the card.

One currency at a time

⛔ A currency is required and every figure is scoped to it. Adding pounds to dollars gives a number with no unit that looks exactly like money — and a tag tree is precisely where a mixed book gets summed without anyone noticing, because the tags say nothing about which account the spending sat in.

The one limit

⛔ It reads at most 100 tags beneath the one you name, and refuses rather than truncating. A short answer that looks complete is worse than no answer — you would budget against it. If you hit this, ask about something narrower; for the whole book, read the accounts, which needs no tag at all.

⚠ The money is summed inside Records as whole units, never as decimals. Adding fixed-point strings in a recipe would drift, and a total that is out by a fraction of a penny in the wrong direction is exactly the kind of wrong nobody notices.

How it works 35 steps

Inspect the data fetches, transforms, gates, and output this recipe runs.

Process (35 steps)
■ tag_id trim
Trim whitespace from setting tag id
■ has_tag compare
Check if tag id has data
⚠ tag_guard guard
Stop if has tag equals
■ currency_raw trim
Trim whitespace from setting currency
■ currency uppercase
Convert currency raw to uppercase
■ has_currency compare
Check if currency has data
⚠ currency_guard guard
Stop if has currency equals
◆ tag recued-core.ledger-book.tag.get
Get tag on ledger book
■ found compare
Check if tag record id has data
⚠ found_guard guard
Stop if found equals
◆ edges recued-core.ledger-book.tag_closure.search
Search tag closure on ledger book
■ edge_rows default
Apply default
■ descendant_count count
Count items in edge rows
■ within_cap compare
Check if descendant count is at most 100
⚠ cap_guard guard
Stop if within cap equals
■ tag_refs pluck
Extract descendant from each item
■ period trim
Trim whitespace from setting period
■ account_id trim
Trim whitespace from setting account id
■ has_period compare
Check if period has data
■ has_account compare
Check if account id has data
■ base_filters default
Apply default
■ period_filters ternary
Apply ternary
■ account_filters ternary
Apply ternary
■ filters merge
Combine objects together
◆ rollup_raw recued-core.ledger-book.leg_tag.spend_under
Spend under leg tag on ledger book
■ rollup default
Apply default
◆ breakdown_raw recued-core.ledger-book.leg_tag.spend_by_tag
Spend by tag leg tag on ledger book
■ groups default
Apply default
■ rows map
Extract from each item
■ ranked map
Extract from each item
■ sorted sort
Sort by rank
■ table to_table
Format results as a data table
■ double_tagged math
Calculate: {{step.rollup.rows}} - {{step.rollup.legs}}
■ split_note ternary
Apply ternary
■ card to_summary
Format results as a summary card
▼
Output
summary card
table table
Settings 4 configurable

Configurable at install. Defaults shown — change them anytime in Recued.

period setting =
tag id setting = [object Object]
currency setting = GBP
account id setting =

Uses (4 operations)

Pack operation Get tag on ledger book recued-core.ledger-book.tag.get
Pack operation Search tag closure on ledger book recued-core.ledger-book.tag_closure.search
Pack operation Spend under leg tag on ledger book recued-core.ledger-book.leg_tag.spend_under
Pack operation Spend by tag leg tag on ledger book recued-core.ledger-book.leg_tag.spend_by_tag

Trust & control

What installing this recipe would let it do. Recued grants these permissions at install — review them there before approving.

What it's allowed to do

Read Pack Ledger book read-only
Read: tag.get · No approvalRead: tag_closure.search · No approvalRead: leg_tag.spend_under · No approvalRead: leg_tag.spend_by_tag · No approval

About

Tags

pack:ledger-bookaccountingtagsbudgetrecordsv3

Details

35 steps 4 configurable settings recipe_id: tag-spend