Recued
Menu
← Back to recipes

Book bank lines

by recued-core v1 27 views

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.

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.

Book bank lines
This recipe

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 “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 “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 “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 →

How to use it

  1. Pick the month, then choose the account the lines should go to: press Use this account beside it in the Your accounts table (or type its id, e.g. supplies, and press Show).
  2. Tick the statement lines that belong to that account — up to 30 at a time.
  3. Press Book ticked lines.

Each line becomes one entry in your Ledger book with two sides: your bank account moves by the line's amount, and the account you chose moves by the opposite. So a £19.99 card payment to a supplier books £19.99 out of the bank and £19.99 into supplies, and the entry balances by construction.

Only accounts you already have

The account must already exist in Ledger book, be open, use the same currency as your bank account, and not be the bank account itself. Anything else is refused and nothing is booked. Your open accounts are listed underneath, each with a Use this account button, so you pick one rather than type it.

All or nothing

⛔ The ticked lines are booked in one transaction: every one of them lands, or none does. There is no half-booked month to tidy up after a failure.

It cannot book a line twice

Each entry is named after the statement line it came from, so ticking a line that is already booked — from a second tab, or by pressing twice — books nothing new. Those lines are counted as skipped.

What it trusts

Only the ids of the ticked lines and the account you typed come from the page. The date, description and amount are read again from your imported statement at the moment of booking, so what is booked is what the bank said.

Lines you already typed in

A line you linked to an entry you typed into Ledger book yourself (see Match lines typed by hand) is already in your books, so it is not offered here.

A closed month

While a month is closed (see Close the month), nothing in it is booked or matched here; reopen it first.

How it works 78 steps

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

Process (78 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_closed_rows default
Apply default
■ 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
■ bank_currency default
Apply default
◆ lines recued-core.statement-import.line.search
Search line on statement import
skip: step.linked equal false
⚠ stop_more_than_1000_statement_lines_this_month guard
Stop if lines next cursor has data
■ 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
⚠ stop_more_than_1000_bookings_this_month guard
Stop if booked next cursor has data
■ 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
⚠ stop_more_than_1000_links_this_month guard
Stop if links next cursor has data
■ link_rows default
Apply default
■ with_link enrich_by
Apply enrich_by
■ unbooked filter
Filter by condition
■ pick_ids default
Apply default
■ has_picks compare
Check if pick ids has data
⚠ stop_link_your_bank_account_first guard
Stop if linked equals
skip: step.has_picks equal false
⚠ stop_month_is_sealed guard
Stop if month is closed equals
skip: step.has_picks equal false
■ account_id trim
Trim whitespace from setting to account
⚠ stop_choose_an_account_first guard
Stop if account id is empty
skip: step.has_picks equal false
■ account_ids default
Apply default
◆ account_lookup recued-core.ledger-book.account.get
Get account on ledger book
skip: step.has_picks equal false
■ account_rows map
Extract from each item
■ account_found filter
Filter by condition
■ account_count count
Count items in account found
⚠ stop_no_such_account guard
Stop if account count equals
skip: step.has_picks equal false
■ account_active default
Apply default
⚠ stop_account_is_closed guard
Stop if account active equals
skip: step.has_picks equal false
⚠ stop_account_is_the_bank_itself guard
Stop if account id equals
skip: step.has_picks equal false
■ account_currency default
Apply default
⚠ stop_currency_differs guard
Stop if account currency does not equal
skip: step.has_picks equal false
■ picked filter
Filter by condition
■ bookable filter
Filter by condition
■ bookable_count count
Count items in bookable
⚠ stop_nothing_left_to_book guard
Stop if bookable count equals
skip: step.has_picks equal false
⚠ stop_tick_at_most_30 guard
Stop if bookable count is greater than
skip: step.has_picks equal false
■ batch_ops map
Extract from each item
■ bank_leg_ops map
Extract from each item
■ category_leg_ops map
Extract from each item
■ ops flatten
Flatten nested lists in
◆ post recued-core.ledger-book.batch.post
Post batch on ledger book
skip: step.has_picks equal false
■ booked_now_ids pluck
Extract id from each item
■ booked_now_count count
Count items in booked now ids
■ pick_count count
Count items in pick ids
■ skipped_count math
Calculate: {{step.pick_count}} - {{step.booked_now_count}}
■ remaining filter
Filter by condition
■ remaining_count count
Count items in remaining
■ remaining_sorted sort
Sort by posted_on
■ board_table to_table
Format results as a data table
◆ accounts recued-core.ledger-book.account.search
Search account on ledger book
skip: step.linked equal false
■ account_list default
Apply default
■ account_choices filter
Filter by condition
■ account_rows_with_use map
Extract from each item
■ accounts_table to_table
Format results as a data table
■ more_actions default
Apply default
■ closed_note ternary
Apply ternary
■ status_text ternary
Apply ternary
■ card to_summary
Format results as a summary card
▼
Output
filter lines
summary card
button more_actions
table board_table
table accounts_table
Settings 3 configurable

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

period setting =
book ids setting =
to account setting =

Uses (8 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 Get account on ledger book recued-core.ledger-book.account.get
Pack operation Post batch on ledger book recued-core.ledger-book.batch.post
Pack operation Search account on ledger book recued-core.ledger-book.account.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 Month-end closer read-only
Read: bank_account.search · No approvalRead: month_close.search · No approvalRead: bank_link.search · No approval

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

About

Tags

pack:month-end-closermonth-endbank-reconciliationbookkeepingrecordsv3

Details

78 steps 3 configurable settings recipe_id: book-bank-lines