Import a bank statement
Take the CSV or OFX your bank already gives you. Nothing connects to your accounts.
On this page
Ledger does not connect to your bank, and will not ask for your banking credentials. Handing a third party read access to a business account is a decision for you to make deliberately, not a feature to assume.
What it does instead is the part that actually saves the time.
Set up the account
Bank & reconcile → Add a bank account. Name it, optionally the institution and the last four digits. Only the last four are ever stored.
Import
Export a statement from your bank as CSV, OFX or QFX and drop it on the import panel. You can also paste the rows straight out of the bank's web page, which is often quicker.
Ledger reads the columns whatever order they are in. It copes with a single amount column or separate debit and credit columns, and with dates written any of the usual ways. Rows it cannot read are skipped and reported rather than failing the whole file.
The same transaction is never imported twice. Banks give each one a unique id; where they do not, Ledger derives a stable one. Re-importing March imports March once.
Matching
Each imported line is compared against what is already in the books. Candidates must match the amount exactly — a near match on money is not a match — and are then ranked by how close the dates are and whether the description mentions the contact.
Nothing is matched automatically. A suggestion is offered and you confirm it. The cost of a wrong automatic match is books that quietly double-count a payment, which is not worth the few seconds it would save.
A line that is not in the books yet can be booked straight from the review panel, which creates the document and matches it in one step.
Rules
A rule says "when the description contains SHELL, it is fuel". Matching lines get tagged with the suggestion so you can accept them in one click.
Rules can create the document automatically, but that is off by default and should stay off for anything that is not genuinely routine — a set of books that grows entries on its own is a set of books nobody trusts.
Reconciling
Enter the statement's closing date and closing balance. Ledger shows what the matched items add up to and the difference between the two.
When the difference is zero, the books and the bank agree, and you can lock it. Locking is refused while there is still a difference, because a reconciliation that does not reconcile is worse than none.
Still stuck? Contact support and we'll get back to you as soon as possible.
