Importing a bank statement
No bank connection? Import a CSV or PDF statement from any bank, and Keeper sorts it like any other payments.
If your bank isn't connected, or you want to bring in older months, you can import a statement file from any UK bank. Keeper then sorts the payments the same way it sorts a bank feed.
Get the file from your bank
Download a statement from your bank's website or app. Holdfast takes:
- CSV (a spreadsheet file). This works best, so choose it if your bank offers it.
- PDF. Holdfast reads these as best it can, but some layouts don't read cleanly. If it finds nothing, it says so and suggests a CSV.
There's no need to set up columns. Holdfast recognises the layouts of the main UK banks and reads the dates, names and amounts for you. Payments in a currency other than pounds are left out.
Import it in the app
- Go to the right side of your books: Transactions for your business, or Spending, then Transactions for your own money. The side you import from decides where the payments go.
- Choose Import statement and pick the file. You'll also find Import statement on Home under Import a statement.
- Holdfast reads it and tells you how many payments it added, how many were already in your books, and the account's balance.
- If Holdfast isn't sure it read the file right, you'll see Check this statement first with a summary of what it found. If money in and money out look swapped, tick Money in and out are the wrong way round: flip them, then choose Import it.
- Keeper sorts the new payments, and anything it isn't sure about waits for you in Check these on the Keeper page. See How Keeper sorts your payments.
Import it on WhatsApp
Once your number is linked (see Using Holdfast on WhatsApp), send the CSV to Holdfast. WhatsApp imports take CSV files only, and only the owner of the books can import this way.
- Say whether it's for your business or personal account in the message. If you don't, Holdfast asks.
- Holdfast shows what it found and asks you to reply yes to import it, flip if money in and out are the wrong way round, or cancel. Nothing goes in until you reply.
- Changed your mind? Send undo import within 48 hours. This removes the last statement you imported from that number.
Good to know
- No doubles. Payments already in your books aren't added again, whether they came from the bank feed or an earlier statement. On the business side, a payment with the same amount within 2 days of one you already have is treated as the same payment.
- Connecting later. If you connect the bank afterwards, the feed starts from the day after your last imported payment.
- Taking one out. If a statement went in wrong, find it in the Imported statements box and choose Remove, then Remove it. Import the right file afterwards. A business statement can't be removed if any of its payments are in a period you've locked.
- Locked periods. On the business side, payments dated in a period you've locked as filed (Settings, Lock filed periods) are left out when you import, and Holdfast tells you how many.
- Statements don't carry a running balance, so if you want to check your books against your bank, add the statement's closing balance on the Reconcile page. See Checking your books against the bank.
- Lots of history? If you're moving from Xero, QuickBooks or FreeAgent, see Moving from another app instead.
Related
- Sorting payments into categoriesEvery payment gets a category so your tax is right. Keeper does most of it, and you check the rest.
- How Keeper sorts your paymentsKeeper files new payments into categories when your books make the answer clear, shows why, and leaves the rest for you.
- Connecting your bankHoldfast connects to your bank through regulated open banking, with read-only access. It can never move your money.