Getting a Starling bank statement to Excel depends on which of Starling's two downloads you are holding. Since August 2026, Starling has provided monthly statements as True Copy PDFs, stamped at the top, and several months download together as one ZIP file. The CSV in the app is something else: Starling calls it a transaction summary, each export covers up to 12 months, and Starling says it is not a verifiable statement.
If all you need is bookkeeping rows from an account that is still open, take the CSV. It is Starling's own export, it costs nothing and it opens in Excel as it is. A live feed from Starling into Xero, FreeAgent or QuickBooks does the same job continuously.
Conversion is the job when the figures have to tie to the statement itself. A client's year of statements arrives as the True Copy ZIP. A lender, a mortgage broker or an HMRC enquiry wants numbers a third party can check. A year-end reconciliation runs against each month's closing balance, and a closed account's history arrives as statements. Those PDFs convert to Excel or CSV with one row per transaction.
| True Copy statement | Transaction summary | |
|---|---|---|
| Format | PDF or Large print PDF | PDF, Large print PDF or CSV |
| Dates covered | Full calendar months only | Custom range, up to 12 months per export |
| Verifiable | Yes: a statement identification number in the stamp | No, in Starling's words |
| Several months | One ZIP of monthly PDFs | One file per export |
| Use it for | Evidence, reconciliation, lenders, a client's records | Bookkeeping rows from a live account |
How to get a Starling bank statement: True Copy PDFs, one month or a ZIP
Starling's help centre puts the change in one line: "From August 2026, we changed how we provide your statements in the app." And the visible difference in another: "Every statement now has a 'True Copy' stamp at the top." The process is the same in Starling's business help article on getting statements and its personal account version, and joint accounts follow the same flow.
In the app, open Statements and documents, then Statement history, pick the month or months, and download as PDF or Large print PDF. Four details from those pages shape what a year's request produces:
- Timing. The previous month's statement is "available in the app between the 4th and 10th of each month". The October statement turns up in early November, and a client asked on the 2nd for a year to the end of last month may not have the final month for another week.
- Whole months. "Full monthly statements cover full calendar months only." A period that starts mid-month, such as a 6 April to 5 April year, needs the statements on either side and the rows outside the dates removed.
- The ZIP. Several months "download together in a compressed ZIP file". A client who selects twelve months sends one ZIP with twelve PDFs inside, and that file has to be extracted before the statements can be opened, filed or converted.
- Explanatory text. "From November 2026, we're also adding extra information to make your statements easier to understand," including what interest terms such as AER and EAR mean. That text sits on the statement but is not part of the transaction list.
What makes the PDF a statement rather than a print-out is the stamp. According to Starling's certified statement help page, the True Copy stamp sits "at the top of each page", and each monthly statement is "automatically allocated a verifiable statement identification number", "specific to that particular monthly statement". A lender or other third party can phone Starling on 020 7930 4450 to confirm that a statement is genuine, which is why the monthly PDF, not a spreadsheet or a summary, is what they ask for.
The transaction summary CSV: Starling's export, up to 12 months at a time, and not a statement
Starling offers the CSV as the alternative to a statement: "If you need custom dates, you can export a transaction summary instead." It sits in the same place in the app. From Statements and documents and Statement history, tap Go to feed exports, choose Current month to date, Last 3 full months or Custom date range, and pick PDF, Large print PDF or CSV. The CSV opens straight into Excel. For categorising a period's spending, checking a few months before a meeting, or giving a bookkeeper rows for an account the client still logs in to, that is the end of the job.
How far back it reaches is less clear, because Starling's help article says it two ways. One line reads: "This can cover any dates in the last 12 months." A few lines further down, under the CSV route: "Exports are available from account creation to the current date in up to 12 month periods." The page does not reconcile them. The reading that holds under either sentence is that any one export spans at most 12 months. Where the app does reach further back, as the second sentence says, two or three years of history means two or three exports, stitched together in Excel, with the joins checked for transactions that appear twice or not at all. Where it does not, the older months come only from the statements.
Then the line that decides where the CSV can be used: "Transaction summary exports are not verifiable statements." A summary has no True Copy stamp and no statement identification number for a third party to check, and its dates are whatever range was chosen rather than the statement's calendar months. Where statements are asked for, the summary is not what was asked for, however accurate its rows.
Part of the confusion online comes from Starling itself. Its features page on statements still invites customers to export "your transaction history as CSV" for use with accounting software such as Xero or FreeAgent. The help centre is the more specific and more recent source, and it is the one describing what the app does now: the CSV is a transaction summary.
When the True Copy PDF is the source, not the CSV
For an accountant with Starling clients, the statement becomes the source in a handful of recurring situations.
The client sends what you asked for. Ask a client for "statements" and you get what Starling calls statements: a ZIP of True Copy PDFs. Going back to ask for a CSV costs a round trip, and for evidence work the CSV would be the wrong document anyway.
Someone outside needs to check the figures. A mortgage broker's affordability pack, a lender's review of a company's trading, an HMRC enquiry into a tax return: in each, the figures have to tie to a document the other side can verify, and the True Copy statement carries the identification number they can confirm with Starling. A spreadsheet built from those statements keeps every figure traceable to a verifiable page. One built from a transaction summary leaves an extra step for anyone asking where a number came from.
The balances are the control totals. Year-end accounts and a bank reconciliation turn on the statement's monthly balances. Rows taken from the statement can be checked against them month by month, and a month that does not tie points straight at the rows to look at.
The records have to come from somewhere. VAT records kept under Making Tax Digital and, from April 2026 for sole traders and landlords with qualifying income over £50,000, Making Tax Digital for Income Tax record-keeping both need digital records. For a client who keeps no software and sends statements instead, the statements are where those records start.
The year a sole trader incorporates. Starling's Business Account General Terms (April 2026) say: "If you are a sole trader and decide to incorporate your business as a private limited company, you must tell us immediately and close your sole trader account." The agreement "does not automatically transfer", so the company needs "a new business account". The year of incorporation therefore spans two accounts, and the sole trader half ends in a closed one, with no app access left to export from.
The same terms give accountants a way to stop waiting on clients. A business owner can invite "an individual (such as an employee, accountant, or bookkeeper)" to "have view-only access" through Team Access. With it, the accountant sees the business account for themselves, at the point the work needs it.
A closed Starling account: the history comes as statements, by a link that lasts 60 days
Once a Starling account closes, there is no app to download from, no feed export and no bank feed. The history Starling sends is the only source left, unless the statements were saved from the app before closure. For a planned closure, such as an incorporation, that is the time to download them.
According to Starling's guidance on transaction history after closure, Starling emails the account's full transaction history "in the form of bank statements", free of charge. At closure it arrives within 10 working days. A former customer who asks later, at any point up to 5 years after closure, gets it within 7 working days. The email holds a link, Starling texts a password, and both the link and the password stay active for 60 days.
How the request is made depends on the account:
- Personal accounts: the holder chooses in the app, as part of closing, whether to receive the full history, a shorter range or none.
- Joint and business accounts: the holders ask for the history when they request closure.
The password opens the web page the email links to; Starling does not say the statements themselves are locked. The 60 days are the deadline: download every statement while the link is live and file them with the client's records, or the only route left is a fresh request. If any downloaded PDF does ask for a password when you open it, remove the password before converting it.
For the sole trader who incorporated, this history covers the closed sole-trader account's part of the year, and it converts the same way as the monthly statements. Tide, another app-based bank popular with sole traders and small companies, runs a similar closure process with gaps of its own, and our guide to getting Tide statements and a closed Tide account's history into Excel covers it.
Worked example: a year of True Copy PDFs from one ZIP into one sheet
A small limited company with a 31 October 2026 year end banks with Starling. In mid-November the director selects November 2025 to October 2026 in Statement history, and the accountant receives one ZIP containing twelve True Copy PDFs. The job: one sheet of every transaction for the year, checked against the statements before the accounts are drafted.
1. Extract the ZIP. The twelve PDFs are what gets converted, not the ZIP file. Unzip it to a folder and the statements are ready as they are.
2. Upload the twelve PDFs as one batch and describe the sheet. To convert Starling PDF statements to Excel, all twelve go into a single task with a prompt that says what the spreadsheet should hold, for example:
One row per transaction. Date as DD/MM/YYYY, description, money in, money out, balance. On every row add the statement month as YYYY-MM, the statement identification number from the True Copy stamp, and the opening and closing balance printed on that statement, left blank if it shows none. The stamp, the notes explaining terms such as AER and EAR, and any summary boxes are not transactions.
The statement month and the identification number on each row are what keep the sheet tied to the documents: any figure in it can be traced to the verifiable statement it came from, which is the point of working from the PDFs at all.
The sheet comes back as Excel, CSV or JSON. In Excel, numbers arrive as numbers and dates as dates, so the pivot table below works without cleaning. Every row also carries the file and page it came from, and a value or row the panel of AI agents cannot agree on is flagged as Review Needed, with what to check. In the results viewer, clicking the file name on a row opens the page it came from beside it.
3. Check every month against its statement. A pivot table by statement month, with Opening and Closing set to Max and Money in and Money out set to Sum, gives one line per statement. Add a column for opening plus money in minus money out, and compare it with the printed closing balance. For illustration, invented figures for the first three months:
| Statement month | Opening | Money in | Money out | Calculated closing | Printed closing |
|---|---|---|---|---|---|
| 2025-11 | 8,214.37 | 14,620.00 | 12,935.52 | 9,898.85 | 9,898.85 |
| 2025-12 | 9,898.85 | 11,305.00 | 13,072.18 | 8,131.67 | 8,131.67 |
| 2026-01 | 8,131.67 | 16,480.40 | 12,577.90 | 12,034.17 | 12,214.17 |
Two tests run down the table. Each month's calculated closing should equal its printed closing, and each month's opening should equal the previous month's closing. November and December pass both. January's calculated figure is 180.00 short, and a difference of exactly twice an amount usually means one transaction is in the wrong column: here, a 90.00 supplier refund read as money out instead of money in. Filtering January's rows for 90.00 finds it, the Source File column names the page, and one correction in the sheet brings the month into line. The same month-by-month discipline is set out in our guide to reconciling bank statement transactions month by month.
If the finished sheet has to match the layout an accounting package imports, a Structured Prompt fixes the exact column headers in the exact order, and the Source File and Review Needed columns can be left out in Preferences so the file carries only those columns.
Two variations change the inputs, not the method. A sole trader who keeps to a 5 April year end, rather than the 31 March date HMRC treats as equivalent, needs thirteen statements for the tax year, April to April, with the rows before 6 April and after 5 April removed. The year a sole trader incorporates needs two sets: the closed sole-trader account's history and the new company account's statements, run as separate tasks or kept apart with an account column added to the prompt.
The first 50 pages every month are free, with no credit card needed, which is enough to try the method on a client's last few statements before running a full year.
Starling feeds to Xero, FreeAgent and QuickBooks, and Starling Accounting
For an open account, a live feed is often the better answer than any download. Starling connects to Xero, FreeAgent and QuickBooks through its Marketplace, and the account's transactions flow into the accounting software from there. Pending transactions do not appear in the feed, one of the reasons Starling's help article on transactions missing from a bank feed gives for a payment the ledger has not picked up.
A feed that has dropped can be back-filled. On reconnecting, "you'll be asked to select a date in the past from which to sync transactions", and Starling states no maximum. That makes a feed a good way to bring a missed quarter into the books. It does not make the feed a statement: the rows land in the ledger with nothing a third party can verify, and a closed account has no feed to reconnect.
Starling also has its own bookkeeping tool, Starling Accounting, which accepts CSV uploads from other banks. A client who wants every account in one place there needs the other bank's history as CSV first. Where that bank is Monzo or Revolut, our guides to converting Monzo and Pot statements to Excel and converting Revolut statements to Excel cover getting their rows out.