Recued
Menu
← Back to recipes

Show the expenses

by recued-core v3 42 views

Use “Show the expenses” in Recued. List captured expenses for a period with a running total, and count what still needs review. Read-only — it re-reads no receipt and re-runs no extraction.

Complete workflow

Expense Ledger 7 pinned recipes

Use Expense Ledger in Recued for expenses, receipts, bookkeeping, and ocr. It includes 7 built-in actions and 6 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.

Show the expenses
This recipe

Use “Show the expenses” in Recued. List captured expenses for a period with a running total, and count what still needs review. Read-only — it re-reads no receipt and re-runs no extraction.

pack:expense-ledgerexpensesboardrecords
by recued-core pinned v3

Use “Capture a receipt” in Recued. Read one receipt locally — OCR for a photograph, text extraction for a PDF — pull out the merchant, date, total, VAT and payment method, and keep it as an expense.

pack:expense-ledgerexpensesreceiptsocr
by recued-core pinned v3

Use “Review an expense” in Recued. Confirm or correct one captured expense. Whatever you leave blank keeps what was extracted; whatever you fill in replaces it.

pack:expense-ledgerexpensesreviewrecords
by recued-core pinned v4

Use “Export a period” in Recued. Produce the CSV for one month — every reviewed expense, with totals. Only rows you have reviewed are included, so the export is what you stand behind rather than what the model read.

pack:expense-ledgerexpensesexportcsv
by recued-core pinned v2

Use “Import expenses (CSV)” in Recued. Reads a card or expense export you downloaded yourself, lets you match its columns from the file’s own header, and records every line as an expense. Re-importing an overlapping export adds only what is new.

pack:expense-ledgerexpensescsvimport
by recued-core pinned v6
Show all 7 recipes

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

pack:expense-ledgerexpensedetailnavigation
by recued-core pinned v1
View pack details, dependencies, and permissions →

The board

Blank period shows everything; otherwise give a month as YYYY-MM.

Status is captured (read, not yet confirmed), needs_review (read with low confidence), reviewed (you confirmed it), or no_text (nothing could be read from the file).

⚠ The total shown includes every row EXCEPT no_text, reviewed or not. It is what you have captured, not what you have confirmed — Export a period counts only reviewed rows, so the two numbers will differ until you have worked through the queue. That gap is the point of the board.

⚠ Flagged duplicates are counted in the total. They are possible duplicates, not known ones; excluding them would understate the month on a guess.

⚠ A no_text row is not a zero-value expense — it is a receipt that could not be read at all. It contributes nothing to the total and needs re-capturing as a photograph.

How it works 22 steps

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

Process (22 steps)
■ period trim
Trim whitespace from setting period
■ filter_by_period compare
Check if period has data
◆ all_rows recued-core.expense-ledger.expense.search
Search expense on expense ledger
skip: step.filter_by_period equal true
◆ period_rows recued-core.expense-ledger.expense.search
Search expense on expense ledger
skip: step.filter_by_period equal false
■ rows coalesce
Use the first available value from: period rows records, all rows records,
■ rows_sorted sort
Sort by purchase_date
■ row_count count
Count items in rows sorted
■ valued_rows filter
Filter by condition
■ reviewed_rows filter
Filter by condition
■ needs_review_rows filter
Filter by condition
■ no_text_rows filter
Filter by condition
■ dup_rows filter
Filter by condition
■ captured_total sum
Sum values in
■ captured_tax sum
Sum values in
■ reviewed_total sum
Sum values in
■ reviewed_count count
Count items in reviewed rows
■ needs_review_count count
Count items in needs review rows
■ no_text_count count
Count items in no text rows
■ dup_count count
Count items in dup rows
■ board_table_rows map
Extract from each item
■ board_table to_table
Format results as a data table
■ card to_summary
Format results as a summary card
▼
Output
summary card
table board_table
Settings 2 configurable

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

limit setting = 100
period setting =

Uses (1 operation)

Pack operation Search expense on expense ledger recued-core.expense-ledger.expense.search

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 Expense Ledger read-only
Read: expense.search · No approval

About

Tags

pack:expense-ledgerexpensesboardrecordsv3

Details

22 steps 2 configurable settings recipe_id: list-expenses