Recued
Menu
← Back to recipes

Show the expenses

by recued-core v2 8 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 6 pinned recipes

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

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 v2

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 v3

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, maps its columns the way you named them, and records every line as an expense. Re-importing an overlapping export adds only what is new.

pack:expense-ledgerexpensescsvimport
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 21 steps

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

Process (21 steps)
period trim
Trim whitespace from setting period
filter_by_period compare
Check if period has data
all_rows ?
skip: step.filter_by_period equal true
period_rows ?
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 to_table
Format results as a data table
card to_summary
Format results as a summary card
Settings 2 configurable

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

limit setting = 100
period setting =

About

Tags

pack:expense-ledgerexpensesboardrecordsv2

Details

21 steps 2 configurable settings recipe_id: list-expenses