Plainbooks

Bank and card import

Bank and Card CSV Import with AI Suggestions on Every Line

Drop in the CSV file your bank already gives you. Check it once, and next month it remembers. AI then suggests a category for every line.

Columns Guessed, Dates Written Out

A CSV file is a plain table of your transactions. Each column is matched to what it holds: date, description, amount. Empty columns say so instead of being guessed.

  • Every date is written out, like Oct 14, 2026, so a mixed-up day and month shows before anything is saved
  • One example tells us whether money is in or out
  • Descriptions from every column are joined, so the merchant is never lost

Your choices are saved for that account, so next month there is nothing to set up. Day and month can swap between banks, and written-out dates make that easy to spot.

You see a preview before anything is saved. Nothing is imported until you have looked and agreed.

This matters most for credit cards, where the signs on amounts are often the reverse of a chequing account. One example from you settles it for every row in the file.

If your bank gives you separate columns for money in and money out, or one column with plus and minus signs, the example you give covers both. You do this once for each account.

Account Numbers Hidden, the Right Account Picked

The file is read in your browser. Only the last four digits of an account number are ever kept.

Those four digits also pick the account for you. If you choose a different one, you are told, so a card file never lands in the wrong account by accident.

A masked number still tells you which account a file belongs to. If you pick a different account, you are told before anything is saved.

You never need to retype an account number, and you never paste a full one into a form. That keeps the file you work with safe to look at over your own shoulder and easy to share with your accountant.

Nothing Imported Twice

Bring in the same file twice and the second time is recognised, so each transaction is there once. Overlapping files are fine too.

That matters when you download a statement for the month and a fresh export a week later. The lines that overlap are skipped and only the new ones come in.

Before anything is saved you see how many rows are new and how many are already in. A coverage bar shows the dates you have for each account, so a missing week stands out.

If a bank changes the wording of a description between two downloads, you still see the lines in the preview before they are saved. You stay in charge of what goes in.

AI Suggests a Category as Soon as Lines Arrive

Once the lines are in, they wait in your review inbox. AI suggests a category, a vendor and the tax for each one, with a reason you can read.

You confirm the sure ones together and look closer at the rest. Nothing is recorded until you confirm it.

Each suggestion comes with a reason and a confidence word: High, Medium or Low. The more you confirm, the less you have to change next month.

Bring the file in on any day you like. A weekly habit keeps the inbox short, and a monthly one works too.

See how the AI review inbox works

Checked Against Your Statement Balance

After an import you can type the balance and the date from your statement. Plainbooks adds up the lines you brought in, starting from the account's opening balance and compares the result.

If the two agree, the file is complete. If they differ, you see the difference and know to look for a missing line before it becomes a year-end puzzle.

It is a quick check, and it turns a hope that the books are right into something you can see.

Do this once per account each month and a gap never has time to hide. Your statement is the bank's own record, so it is the fairest test of whether the import is complete.

Think of it as the same check a bookkeeper does by hand with a statement and a pencil. Here the adding up is done for you, and the answer is on screen in a moment.

Questions About Bank Import

Which Banks and Cards Work?

Any bank or card company that lets you download a CSV file. The columns are matched to what they hold, so any layout works.

What File Do I Download from My Bank?

Look for an option such as Download transactions and choose CSV. Pick the dates you want and save the file. Then drop it into Plainbooks.

What If I Bring in the Same File Twice?

The second time is recognised and each transaction stays in once. Before anything is saved you see how many rows are new and how many are already in.

Can I Bring in a Credit Card Statement?

Yes. A card file comes in the same way as a bank file. Charges and payments are read from the file, and a payment from your bank to the card shows up as one transfer to confirm.

Why Only the Last Four Digits?

A full account number is not needed to keep your books. The last four digits are enough to pick the right account and for you to recognise it, so that is all that is kept.

Something else? Write to [email protected].

Want a calmer month end? Request early access and we will be in touch.

Plainbooks is open by invitation, and we reply to each request.

  • How It Works

    The monthly routine in four steps: snap receipts, bring in your bank and card files, confirm what AI suggests and hand over the reports.

  • Receipts

    Coming soon: an AI receipt scanner that reads each receipt and keeps a clean scan named by date and supplier.

  • Review Inbox

    AI suggestions for every bank transaction, each with its reason, confirmed in one tap.

  • Reports and GST/HST

    Coming soon: GST/HST return figures and year-end reports that follow a year end on any day.

  • Switch from QuickBooks

    An AI-first QuickBooks alternative for Canada, with every year checked against QuickBooks to the cent.