Barclays Bank Statement PDF to Excel: UK Current Accounts, Savings, and Cards
Convert a Barclays bank statement PDF to Excel or CSV for a UK current account, savings, or card, then tie every total back to the statement before you import it.
Key Takeaways
A Barclays bank statement PDF is the record to keep for a UK account. A spreadsheet is the file you can sort, total, and import. Use both, and do not treat the spreadsheet as a replacement for the PDF.
- This guide is for a UK account on barclays.co.uk or in the Barclays app. It does not cover Barclays US credit card statements.
- In Online Banking, open My Barclays documents from your profile and download one statement. In the app, tap Help/More, then Statements. Older menus may still say Statements and documents.
- Barclays displays the online statement as a PDF. A live balance in the app is not that statement.
- Barclays’ help pages say electronic copies from July 2013 were uploaded, and if you registered for online statements before July 2013 you can view statements from the date you registered. If a month is missing, ask Barclays through the app.
- Convert that PDF with the bank statement converter, then compare dates, amounts, and balances with the original before you import it. Leave the amounts in pounds.
Why a Barclays statement PDF is a poor spreadsheet
Barclays issues the statement as a PDF so you can read and store a fixed copy. That is the right file for a mortgage packet, a landlord, or your own tax file. It is a poor file for bookkeeping. Columns do not survive a copy-paste, descriptions wrap onto the next line, and a payment in can land in the money-out column.
Accountants, bookkeepers, and households need rows they can filter. The PDF stays the source. The spreadsheet is the working copy.
What the monthly statement is for
The statement is a closed record for one statement period. On a current account or savings account, that period is the cycle Barclays assigned to the account. On a credit card, it is the billing cycle, which may not match a calendar month. The opening balance, the posted activity, fees, interest, and the closing balance belong together. Items that have not posted are not part of that closed record.
What the live balance is for
The balance in the app today can include payments that posted after the statement closed. Use that screen for a quick look at new activity. If a client, a landlord, or a lender asks for the statement, send the PDF. If your books need rows for a full cycle, convert that same PDF.
How to download a Barclays bank statement PDF
Download the file from Barclays before you convert anything. Menu labels have changed over time, and a business profile can look different from a personal profile, so follow the labels you see after you sign in. The current Barclays online statements page is the reference for the download path. Barclays also still publishes an older path on its print or save help page.
In Online Banking
- Go to barclays.co.uk yourself and sign in. Do not use a link from an unexpected email or text.
- Under your profile, open My Barclays documents.
- Select the account and the statement. Download or save the PDF.
- If you do not see My Barclays documents, open Manage accounts and then Statements and documents, or look for Online Statements in the menu under your name. Barclays still documents those labels.
- Save the file somewhere private. Barclays says a saved statement should be kept so that no one else can open it. Name it with the account and the period, for example
barclays-current-2026-09.pdf. - Open the PDF and confirm the sort code, account number, and statement dates before you upload it.
Barclays says the online statement is displayed as a PDF, so you need a PDF viewer to open it. You can also save it from the PDF icon or the File menu in that viewer.
In the Barclays app
- Open the Barclays app and sign in yourself.
- Tap Help/More, then Statements. On a business profile, Statements may sit on the home page instead.
- Select the document, then download or save the PDF to a private folder.
A phone photo of a paper statement is a different file. It can work with OCR later, but the PDF you download from Barclays is sharper and should be the copy you keep.
Paperless statements and how far back you can go
To stop paper on eligible accounts, Barclays says to open Profile, then Statement and document preferences under Communication preferences, and choose Go paperless for all accounts. In the app, the same choice is under Help/More, then Settings, then Statement/letter preferences. If you choose online only, you no longer receive paper copies. Barclays says you can switch back to paper.
On its statement help page, Barclays says electronic copies of statements from July 2013 were added to the archive, and that customers who registered for online statements before July 2013 can view statements from the date they registered. Treat that as the published archive rule, not a promise that every product shows every month. If the period you need is missing, ask Barclays through the app or a contact option you opened on barclays.co.uk.
What a Barclays UK statement usually contains
Layouts differ by product, and Barclays can change them. These are the sections that matter when you convert a Barclays bank statement to CSV or Excel.
| Account | What to find first | What conversion must preserve |
|---|---|---|
| Current account or savings | Statement period, balance brought forward, balance carried forward, sort code, account number | Date, description, money in, money out, and the running balance when the statement prints one |
| Credit card | Billing cycle, new balance, minimum payment, payment due date | Transaction date, post date, description, and amount, including payments, fees, and interest |
| Business current account | The legal entity and account on the header | The same posted rows as a personal statement, often with more Faster Payments and Direct Debits |
Current account and savings lines
Barclays often groups money in and money out, and the narration often names the rail: Faster Payment, Direct Debit, standing order, or BACS. Keep the description in one cell when it wraps. A transfer between your own Barclays accounts is not new income and not a new expense. If you are unsure how CR and DR behave on a statement, this CR and DR guide is the short version, with one UK extra below.
A balance marked CR or DR
On a UK current account, CR next to the balance usually means the account is in credit. DR, or OD, usually means it is overdrawn. That marker describes the balance. It is not a second transaction, and it does not mean the last row was a credit. When you convert the PDF, store the balance as a signed number you can explain, and do not drop the CR or DR marker on the floor if the statement uses it to show which side the balance is on.
Credit card lines
A Barclaycard or other Barclays credit card statement is a billing statement, not a current account statement. Purchases, payments, fees, and interest sit in one activity list. A payment reduces what you owe. It is not income. The new balance is the balance on the statement date. The balance in the app today can be different because new charges have posted since the cycle closed. If that card is managed on Barclaycard rather than under the current account, sign in where you already view the card, download that statement PDF, and convert the card file on its own.
How to convert a Barclays bank statement PDF to Excel
Once the PDF is the right account and the right cycle, convert that file. The bank statement converter on this site accepts the PDF, extracts the transaction table, and lets you download CSV or Excel. Sign in, upload the file, and read the preview before you download.
- Save the original PDF somewhere you control. Conversion does not replace that file.
- Open the converter and upload the statement. If the PDF itself asks for a password, enter the document password on that file. Your Barclays password and your PINsentry code stay on barclays.co.uk. Do not type them here.
- Wait for the preview. Check the row count against the number of posted lines you can see in the PDF.
- Download CSV if you are importing into accounting software. Download Excel if you are reviewing, filtering, or sending a working file to a client.
- Reconcile the spreadsheet to the PDF before anyone posts it to a ledger.
The same steps apply to a scanned or photographed statement, but the extraction uses OCR. OCR quality follows the scan: straight pages, readable type, and no cropped amounts. Review those files more slowly. For a general walkthrough of digital PDFs versus scans, see how to convert a bank statement PDF to Excel.
Columns worth keeping
Ask for a boring table. A useful Barclays export has one transaction per row and these columns when the statement provides them:
- Date, kept as a real date after you confirm day/month order
- Description, in one cell, even when the PDF wrapped it
- Money in and money out in separate columns, or a single amount with a sign you document
- Balance, including whether it was marked CR or DR
- A source column you add yourself, such as the filename, so a merged year still points back to a PDF
Do not paste the statement summary, the overdraft terms, or the legal footer into the transaction table. Those lines break totals.
Barclays statement to CSV or Excel
Excel is the review file. CSV is the import file. You can create both from the same extraction and they should contain the same transactions.
| Format | Use it for | Watch out for |
|---|---|---|
| Excel | Filters, a tie-out tab, notes on exceptions, a file you send to a client | Dates that Excel silently reformats. A Barclays UK statement prints day/month dates, so 04/10 is 4 October. On a computer set to month/day order, Excel can read that as 10 April. Amounts stored as text will not total. |
| CSV | QuickBooks, Xero, and other imports that want a plain text file | A description that contains a comma must stay quoted, or columns will shift |
Open the CSV in a text editor once if a description looks split across columns. Commas inside payee names are the usual cause. A broader comparison of the two formats is in the PDF bank statement to CSV guide.
Check the spreadsheet against the PDF
This is the step that protects the books. A converter can misread a wrapped description, drop a page, or place money in under money out. The preview on the converter is a first look. The tie-out is the real check.
Current accounts and savings
- Confirm the balance brought forward matches the prior statement’s balance carried forward.
- Total money in and compare it with the statement, if Barclays printed a total.
- Total money out, Direct Debits, and fees the same way.
- Confirm the balance carried forward, including CR if the account is in credit or DR if it is overdrawn.
- Spot-check the first line, the last line, and any line where the description wrapped.
Credit cards
- Confirm the previous balance and the new balance.
- Separate payments from purchases, fees, and interest. A payment must not be imported as income.
- Confirm the payment due date in your notes, even if you do not import that field.
- Search the sheet for a missing sign on a refund or a payment.
If a total is off, fix the spreadsheet from the PDF. Do not type a balancing figure you cannot trace to the PDF. If you cannot explain the difference, do not import the file.
Using the file for books, tax, and applications
Bookkeeping in QuickBooks or Xero
Some clients still send Barclays PDFs when a feed is missing, closed, or not what the engagement uses. A checked CSV cuts the retyping on those files. Where QuickBooks or Xero already has a live Barclays feed, keep that feed as the book of record. Import a CSV into QuickBooks or Xero only after the tie-out, and only for the statements the feed does not already cover. Map money in, money out, and card payments to the accounts you already use. A card payment is a transfer between the current account and the card, not a new expense, or you will double-count the purchases.
Keep the PDF next to the import. If a reviewer later asks where a row came from, the filename column should point at that statement.
Tax files and lending packets
A landlord or a mortgage lender almost always wants the PDF. Give them the PDF. For a UK tax file, keep the PDF with the workpapers and use the spreadsheet only to prepare your own schedules. Do not send a spreadsheet and call it the bank statement.
If you use a UK Barclays account from the US, Europe, Australia, or New Zealand
The download path does not change because you are in New York, Berlin, Sydney, or Auckland, as long as the account is a UK Barclays account. Sign in at barclays.co.uk, or in the Barclays app, and download the PDF for the cycle you need. This does not cover a Barclays US card.
A few habits save a round trip:
- Download the PDF while you still have the device or PINsentry Barclays uses for sign-in.
- Put the statement period in the file name as a year and month, such as 2026-09, so a preparer does not read 04/10 as 10 April when the statement means 4 October.
- Leave amounts in pounds. Do not convert the statement to dollars, euros, or another currency inside the transaction file. If you need a translated total, put the rate and the date in a note beside the file.
- Send the PDF, not only the spreadsheet, when someone asks for proof of funds or income.
Problems that show up on Barclays files
The statement you need is not in the list
Confirm the account first. A current account and a Barclaycard are easy to mix up, and each PDF covers the account named on it. Then check the archive note above. A month before July 2013 will not appear unless you registered for online statements before July 2013, in which case you can view statements from the date you registered. The live balance will not recreate an old statement.
The menu does not match this guide
Barclays documents more than one label: My Barclays documents, Statements and documents, and Online Statements. Use the one you see after you sign in. The file you need is still the statement PDF, not a screenshot of the balance.
Copy-paste scrambled the columns
That is normal for this PDF. Descriptions wrap, amounts sit in a tight column, and a multi-page statement repeats headers. Stop pasting and convert the file. Extract the table, then tie the rows out, as described in the bank statement PDF to Excel guide.
A row does not match a receipt
Payee names are often shortened, and a card purchase can show the merchant’s legal name. Compare the date and the amount before you call a payment unknown. If it is still unfamiliar, contact Barclays through the app, and keep the statement page. Report the item even if you are still reconciling the rest of the file.
The spreadsheet balances but the books do not
Then the statement tie-out worked and the ledger mapping did not. Look for a card payment recorded as an expense, a transfer between your own accounts recorded twice, or a pending payment that was categorized before it posted. The statement cannot fix a mapping error.
Conclusion
Download the Barclays UK statement from My Barclays documents or Statements in the app, keep that PDF, and convert it to Excel or CSV only as a working copy. Check the opening balance, the closing balance, the CR or DR marker, and the direction of each amount before you import. If you want the rows without retyping, use the statement PDF converter, then tie the download back to the statement you saved.