contigi Book a call
AI Business Tools › Bank statements
Bank statements to Google Sheets

Save your bank files. Your sheet updates itself.

Once a week you save the latest bank files from your banking app into one folder. At 12:00 on Friday every new line goes into your company sheet and the totals are checked against the bank. Then you get one short email.

Book a free 20 min discovery call All AI Business Tools
Your Friday, in 3 steps10:00 you save the bank files in one folder. 12:00 the routine adds new lines to the sheet and checks the balances. 12:05 you get one email with a line for each company. FRIDAY 10:00 You save the files CSV About 2 minutes FRIDAY 12:00 The routine runs Only new lines added Balances checked to the penny Bank files filed by date FRIDAY 12:05 You get one email 5 of 5 updated 1 line per company
What happens at 12:00

5 steps, in the same order every week

  1. You save the bank files.Download the latest file for each company from your banking app and drop it in one shared folder. Any file name works.
  2. Each company is found.The account number inside every file shows which company it belongs to, so each file lands on the right tab of your sheet.
  3. Only new lines are added.Lines already in the sheet are recognised and skipped. New lines slot in by date, newest at the top. Running it twice adds 0 extra lines.
  4. The totals are checked against the bank.Where the bank shows a running balance, each new line joins up with the lines around it to the penny. Elsewhere the number of lines is checked. A failed check stops that company before anything is written.
  5. Files are put away and you get an email.Each bank file moves into a Filed folder with the date in front of its name. You receive one email with a line for every company.
Built in

4 protections that come with it

Lines are only added

Older lines, tabs and files stay exactly as you saved them.

Same result every week

A fixed routine with fixed steps, so this Friday behaves like the last.

Checks come first

The sheet is read back after writing and compared with the bank file. The file is put away once both match.

Anything unusual reaches you

It is named in the email with the reason. The other companies carry on.

See it

One sheet, one tab for each company

Every tab has the same 7 columns. The figures below are invented examples.

DateTypeDescriptionInOutBalanceInv #
30-10-2026Bank creditTenant rent, Flat 3450.006,210.50
29-10-2026Direct debitWater supplier98.005,760.50
27-10-2026TransferRoofing contractor1,200.005,858.50INV 0412
26-10-2026Bank creditTenant rent, Flat 1520.007,058.50
24-10-2026Card paymentHardware store62.406,538.50

Each balance minus its line gives the balance on the row below, all the way down.

Bank statements: 5 of 5 updated
  • Company A: 8 new lines, closing balance £6,210.50, filed
  • Company B: 12 new lines, closing balance £3,402.18, filed
  • Company C: 5 new lines, closing balance £11,075.90, filed
  • Company D: 7 new lines, line count checked, filed
  • Company E: 6 new lines, line count checked, filed

Business accounts at NatWest, Barclays and Revolut run today. Another bank takes one short setup when its app offers a download file of your transactions. A new company is one extra tab.

The next step

Want Friday bookkeeping off your list?

A free 20 minute call, no obligation. We check it fits your business before anything is set up.

Book a free 20 min discovery call office@contigi.com 020 7070 8343