Use “List statement lines” in Recued. Shows imported statement lines, most recently imported first, for one account or across all of them, with the net for the page.
List statement lines
Use “List statement lines” in Recued. Shows imported statement lines, most recently imported first, for one account or across all of them, with the net for the page.
Complete workflow
Bank statement import
3 pinned recipes
Use “Bank statement import” in Recued to bring a statement you exported yourself — CSV from any bank — into your own warehouse, with no aggregator in the middle. Aggregators gate real account data behind an approved business account; a file needs no credentials and no third party sees your transactions. You name your bank's columns once, so nothing is guessed. Re-importing an overlapping export skips lines you already have instead of double-counting them. Feeds ledger-book and expense-ledger.
You are viewing one recipe in this workflow. Installing it opens the complete pack so its other recipes and background automations arrive together.
Use “Records runtime” in Recued. It helps you complete this workflow using the connections and settings you choose.
Use “Import a bank statement (CSV)” in Recued. Reads a statement CSV you exported from your bank, maps its columns the way you named them, and records every line in your own warehouse. Re-importing an overlapping export adds only what is new.
Leave the account blank to see every account at once. The net is the sum of the lines SHOWN, not the account balance — raise the limit or filter by account before reading anything into it.
The order is import order, not date order
Your bank's date is stored exactly as it wrote it, and text like 20-Aug-2020 does not sort into date order — December would land before August. Recued will not guess your bank's date format, because a wrong guess silently reorders your statement. Lines come back most-recently-imported first, which within one import is the order your file listed them. To pick a day, filter on it.
Why there are three money columns
Recued stores your statement the way your bank printed it. A bank that prints one signed column fills Amount; a bank that prints a pair fills In and Out. Nothing is folded together on the way in, because which column means money out is a fact about your bank — a stored line you can check against the paper is worth more than a tidier table. The net combines all three here, at reading time, where it is easy to check and easy to change.
How it works
Inspect the data fetches, transforms, gates, and output this recipe runs.
Process (12 steps)
acct
trim
Trim whitespace from setting account label
scoped
compare
Check if acct has data
all_lines
?
skip: step.scoped equal true
account_lines
?
skip: step.scoped equal false
lines
coalesce
Use the first available value from: account lines records, all lines records
shown
count
Count items in lines
net_signed
sum
Sum values in
net_in
sum
Sum values in
net_out
sum
Sum values in
net
math
Calculate: {{step.net_signed}} + {{step.net_in}} - {{step.net_out}}
table
to_table
Format results as a data table
card
to_summary
Format results as a summary card
Settings
Configurable at install. Defaults shown — change them anytime in Recued.
limit
setting
=
100
account label
setting
=