Layers
Download

Free Excel template · Bank statement

Bank statement Excel template — paste the export, print the summary

Paste up to 400 lines from any bank or system export. Each line gets a category from your keyword rules, and the summary adds them by month — money in, money out, net, with a check that nothing was lost.

Download Excel Save to my Layers — free
Bank statement Excel template: first page
Open full screen

Start typing right in the document — no sign-up. It stays in this browser; save it to your free Layers account to keep it, open it on your phone and share it.

  1. 1Fill in. Type into the bank statement Excel template right here on the page — no sign-up, nothing to install.
  2. 2Print or download. Print it in one click, or download the Excel file to keep and edit.
  3. 3Send. Print the monthly summary or send the Excel file to your accountant or bookkeeper.
  4. 4Deadline. Do it each month when the bank statement closes, before your bookkeeper’s cut-off.

What is inside

The Excel file, sheet by sheet

Yellow cells are for you to type, blue cells are calculated. Ordinary formulas, no macros — opens in Excel, Google Sheets and LibreOffice. Licence CC BY 4.0 · © Layers (layers.md).

How to use it

Five steps

  1. 1

    Export

    Download the statement as CSV or Excel from online banking or your accounting system.

  2. 2

    Paste values

    Paste date, description and amounts into the Transactions sheet (Paste values).

  3. 3

    Add rules

    For lines marked "Uncategorized", add a keyword and category on the Rules sheet.

  4. 4

    Read the summary

    Pick the first month; see each category by month.

  5. 5

    Check

    Net equals the categories and the running balance equals the bank closing balance.

What people do next

Make a budget from it

Use the monthly averages as your budget plan.

Hand it to your accountant

Share the folder instead of e-mailing statements.

What Layers does with it

Honest status: Works today is live now; Coming is not yet.

01

Fill it in the browser

Type into the statement right on this page — no sign-up. Save it to a free Layers account to keep it.

  • Works today Pages, spreadsheets and documents in the browser

02

The real Excel file

Formulas, checks and print layout in .xlsx — opens in Excel, Google Sheets and LibreOffice.

  • Works today Download as .xlsx

03

Share and work together

One folder for the team: everyone sees the latest version; comments instead of e-mail threads.

  • Works today Drive with shared folders, chat, calls

04

Edit the Excel file in Layers

Open the .xlsx in the Layers spreadsheet editor with formulas, without Microsoft Office.

  • Works today For signed-in users
  • Coming Right on this page, without an account

Questions

How do I convert a bank statement to Excel?

Most banks let you download transactions as CSV in online banking. Open the CSV, copy the columns and paste them as values into the Transactions sheet. For PDF-only statements, copy the table or use your bank's CSV export instead.

My bank uses one amount column with minus signs

Paste it into "Amount (+/−)" and leave Debit and Credit empty — the template takes whichever is filled.

How does categorisation work?

If the description contains a keyword from the Rules sheet, the line gets that category. Rules are not case-sensitive; when several match, the last one wins.

Is my data uploaded anywhere?

Not if you use the Excel file on your computer. If you save it to Layers, it is stored in your private Drive.

Do I have to sign up?

No. The template is open on this page; sign in free only to save it.

More free Excel templates

Keep it, share it, open it on your phone

The template and the editor are free. Layers is free for teams of up to 20 people.

Start free Get the Excel file

Templates are starting points. Check figures and rules with your accountant, engineer or the agency concerned. Layers is an independent product.

Letters and deadlines by country — in the local language