Recued
Menu
← Back to recipes

Month to close

by recued-core v1 25 views

Use “Month to close” in Recued. See, for one month, which lines of your bank statement are already in your Ledger book and which are not yet.

Complete workflow

Month-end closer 11 pinned recipes

Use Month-end closer in Recued to bring your imported bank statement into your Ledger book once a month: book or match every line, check the books against the statement, explain what changed since last month, and close the month with a package for your accountant. It installs Ledger book and Bank statement import too; give both Read + write. It includes 13 built-in actions and 10 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.

Month to close
This recipe

Use “Month to close” in Recued. See, for one month, which lines of your bank statement are already in your Ledger book and which are not yet.

pack:month-end-closermonth-endbank-reconciliationrecords
by recued-core pinned v1

Use “Link your bank account” in Recued. Tell Month-end closer, once, which Ledger book account your imported bank statement belongs to.

pack:month-end-closermonth-endbank-reconciliationrecords
by recued-core pinned v1

Use “Book bank lines” in Recued. Tick bank statement lines that are not in your Ledger book yet and book them to one of your existing accounts in a single step.

pack:month-end-closermonth-endbank-reconciliationbookkeeping
by recued-core pinned v1

Use “Match lines typed by hand” in Recued. Link bank statement lines to entries you already typed into your Ledger book, so the same money is never booked twice.

pack:month-end-closermonth-endbank-reconciliationbookkeeping
by recued-core pinned v1

Use “Book as suggested” in Recued. Book bank statement lines to the account your earlier bookings or your AI model suggest, ticking only the suggestions you agree with.

pack:month-end-closermonth-endbank-reconciliationbookkeeping
by recued-core pinned v1
Show all 11 recipes

Use “Suggest accounts with AI” in Recued. Ask your AI model which of your Ledger book accounts each new bank statement line belongs to, and keep its answers for you to review.

pack:month-end-closermonth-endbookkeepingai
by recued-core pinned v1

Use “Close the month” in Recued. Check your books against your bank statement's closing balance, then seal the month and copy a package for your accountant.

pack:month-end-closermonth-endbank-reconciliationbookkeeping
by recued-core pinned v1

Use “Reopen a month” in Recued. Unseal a month you sealed so its lines can be booked, matched and explained again. Its figures are kept, so sealing it again takes one click.

pack:month-end-closermonth-endbookkeepingrecords
by recued-core pinned v1

Use “Explain the month” in Recued. See which income and expense accounts changed most since last month and what drove each change, written by you or suggested by your AI model.

pack:month-end-closermonth-endbookkeepingvariance
by recued-core pinned v1

Use “Month-end reminder” in Recued. On a schedule you choose, it tells you when last month isn't sealed yet, and when a month you sealed has changed since.

pack:month-end-closermonth-endbookkeepingreminder
by recued-core pinned v1
View pack details, dependencies, and permissions →

One month, side by side

For the month you pick (last month if you leave it blank) this reads the lines of your imported bank statement and checks each one against your Ledger book. Nothing is written.

  • Booked from the statement means the line was booked with Book bank lines or Book as suggested.
  • Linked to an entry you typed in means you matched it with Match lines typed by hand.
  • Not in your books yet lists the rest, oldest first, with a button to book them.
  • Statement total and Bank account in your books, same month are the two sides of the month. Once every line is booked and nothing else was posted to that account, they agree.

Explain changes compares your income and expense accounts with the month before, and Close the month proves the month against your statement and seals it.

Why a month can look empty

The month is matched on the start of each line's date, so it needs dates written as YYYY-MM-DD. If you imported a statement without telling Bank statement import your date format, its lines are kept exactly as your bank wrote them and no month will find them. Import it again with the date format filled in.

Limits of this version

  • One bank account (see Link your bank account).
  • Up to 1,000 statement lines a month; the summary says when a month has more.
  • A date the month cannot read is checked among your latest 200 imported lines only.
How it works 81 steps

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

Process (81 steps)
■ now_iso date_add
Add 0 seconds to
■ today_local date_format
Format as a date
■ today default
Apply default
■ ym_parts split
Split today into parts
■ month_start template
Generate text from a template
■ prev_day date_add
Add -1 days to
■ prev_parts split
Split prev day into parts
■ last_month template
Generate text from a template
■ period_in trim
Trim whitespace from setting period
■ month default
Apply default
◆ setup recued-core.month-end-closer.bank_account.search
Search bank account on month end closer
■ setup_rows default
Apply default
■ setup_count count
Count items in setup rows
■ linked compare
Check if setup count is greater than 0
◆ month_closes recued-core.month-end-closer.month_close.search
Search month close on month end closer
skip: step.linked equal false
■ month_close_all default
Apply default
■ month_closed_rows filter
Filter by condition
■ month_unsealed_rows filter
Filter by condition
■ month_unsealed_count count
Count items in month unsealed rows
■ month_is_unsealed compare
Check if month unsealed count is greater than 0
■ month_closed_count count
Count items in month closed rows
■ month_is_closed compare
Check if month closed count is greater than 0
■ label default
Apply default
■ ledger_id default
Apply default
◆ lines recued-core.statement-import.line.search
Search line on statement import
skip: step.linked equal false
■ line_rows default
Apply default
■ signed map
Extract from each item
◆ booked recued-core.ledger-book.batch.search
Search batch on ledger book
skip: step.linked equal false
■ booked_rows default
Apply default
■ with_booking enrich_by
Apply enrich_by
◆ links recued-core.month-end-closer.bank_link.search
Search bank link on month end closer
skip: step.linked equal false
■ link_rows default
Apply default
■ with_link enrich_by
Apply enrich_by
■ unbooked filter
Filter by condition
■ booked_lines filter
Filter by condition
■ linked_lines filter
Filter by condition
■ line_count count
Count items in line rows
■ linked_count count
Count items in linked lines
■ unbooked_count count
Count items in unbooked
■ booked_count count
Count items in booked lines
■ bank_total_raw sum
Sum values in
■ bank_total math
Calculate: round({{step.bank_total_raw}} * 100) / 100
■ bank_ref template
Generate text from a template
◆ bank_legs recued-core.ledger-book.leg.search
Search leg on ledger book
skip: step.linked equal false
■ leg_rows default
Apply default
■ hand_legs filter
Filter by condition
■ linked_refs pluck
Extract batch_ref from each item
■ unclaimed_legs filter
Filter by condition
◆ recent recued-core.statement-import.line.search
Search line on statement import
skip: step.linked equal false
■ recent_rows default
Apply default
■ recent_dates pluck
Extract posted_on from each item
■ date_parts split
Split item into parts
■ date_checks map
Extract from each item
■ readable_dates filter
Filter by condition
■ unclaimed_count count
Count items in unclaimed legs
■ recent_count count
Count items in recent rows
■ readable_count count
Count items in readable dates
■ unreadable_count math
Calculate: {{step.recent_count}} - {{step.readable_count}}
◆ books recued-core.ledger-book.leg.balance
Balance leg on ledger book
skip: step.linked equal false
■ books_total_raw default
Apply default
■ books_total math
Calculate: round({{step.books_total_raw}} * 100) / 100
■ difference math
Calculate: round(({{step.bank_total}} - {{step.books_total}}) * 100) / 100
■ has_lines compare
Check if line count is greater than 0
■ all_booked compare
Check if unbooked count equals 0
■ page_full any
Check if any of the conditions are true
■ booked_text ternary
Apply ternary
■ lines_text ternary
Apply ternary
■ status_text ternary
Apply ternary
■ has_unreadable compare
Check if unreadable count is greater than 0
■ dated_text ternary
Apply ternary
■ unsealed_note ternary
Apply ternary
■ closed_note ternary
Apply ternary
■ setup_text ternary
Apply ternary
■ unbooked_sorted sort
Sort by posted_on
■ unbooked_table to_table
Format results as a data table
■ book_actions default
Apply default
■ link_actions default
Apply default
■ sealed_actions default
Apply default
■ month_actions ternary
Apply ternary
■ actions ternary
Apply ternary
■ card to_summary
Format results as a summary card
▼
Output
filter lines
summary card
button actions
table unbooked_table
Settings 1 configurable

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

period setting =

Uses (7 operations)

Pack operation Search bank account on month end closer recued-core.month-end-closer.bank_account.search
Pack operation Search month close on month end closer recued-core.month-end-closer.month_close.search
Pack operation Search line on statement import recued-core.statement-import.line.search
Pack operation Search batch on ledger book recued-core.ledger-book.batch.search
Pack operation Search bank link on month end closer recued-core.month-end-closer.bank_link.search
Pack operation Search leg on ledger book recued-core.ledger-book.leg.search
Pack operation Balance leg on ledger book recued-core.ledger-book.leg.balance

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 Month-end closer read-only
Read: bank_account.search · No approvalRead: month_close.search · No approvalRead: bank_link.search · No approval

4 more aren't listed here. You'll see them at install.

About

Tags

pack:month-end-closermonth-endbank-reconciliationrecordsv3

Details

81 steps 1 configurable settings recipe_id: month-to-close