Quarter-end arrives, your invoices are out, and now you need your own books in order — which means converting your Nationwide bank statement PDF to Excel. As a freelancer or sole trader, your bank statement is your bookkeeping system: every client payment in, every subscription and tax payment out. The problem is that Nationwide protects its statement PDFs with a password, and a locked file is a dead end for spreadsheets and accounting tools. This guide is built for the quarterly routine: find the password, unlock the files on your own machine, convert three months of statements into one clean Excel file, and lock everything back down when you are done.
Nationwide's password habit: what a member should expect
Nationwide is a building society, not a bank, and its statements sometimes behave a little differently from the big banks. Statements requested through the Internet Bank or the app usually download as plain PDFs, while statements sent by email — for example, the e-statements some members still receive — typically carry a password. If you are seeing a password prompt, the format is usually spelled out in the email the statement came with, and it commonly involves your date of birth, sometimes combined with part of your name or member details. The key point for freelancers: figure out the format once, write it down in your password manager, and the next eleven quarters are friction-free. And if you hold a joint account with a partner, the password follows whichever member details Nationwide used when generating the statement — usually the primary account holder — so do not burn an hour trying your partner's date of birth first.
Step 1: Get the right password, including the edge cases
Open the original email and read it carefully before you guess anything — the password format is almost always stated there, and it saves the classic loop of trying DOB variations for twenty minutes. Copy it exactly: passwords are case-sensitive and leading zeros count. A few freelancer-specific gotchas: if you changed your name when you got married, Nationwide's system may still use the old name on the password even though your statements show the new one, or vice versa; if your business is a limited company, the statement password follows the personal details of the person who requested the statement, not the company name; and older statements downloaded years ago may use a format Nationwide has since retired, so do not assume the password that worked in 2023 works for a 2019 file. Two or three failed attempts is your signal to stop and check Nationwide's official help pages or call them, rather than risk locking the file. Our password-removal guide covers the general mechanics if you want the background first.
Step 2: Unlock it locally — keep the file on your own machine
Here is the rule I give every freelancer client: the locked PDF should never leave your computer in locked form, and it should never be uploaded to a random unlocking website. Those free unlock sites are black boxes — you have no idea whether they keep a copy of your full financial history. Instead, open the PDF in Chrome or Edge, enter the password, press Ctrl+P, and save as a new PDF. The new copy has no password and was created entirely on your machine. Save it into a dedicated folder for the quarter, something like bookkeeping/2026-Q3/, with a clear name: nationwide-current-jul-2026.pdf. Do not leave unlocked statements sitting in Downloads, where backup tools and sync apps can scatter copies you will forget about. This local-only habit is the single biggest security upgrade most freelancers can make, and it costs nothing — our data-security best practices post has the full checklist.
Step 3: Convert a full quarter of PDFs into one spreadsheet
Upload each unlocked PDF to ConvertStatement's Nationwide converter and download the Excel files. Nationwide statements are generally well structured, but three separate monthly files are not a bookkeeping system — merge them into one sheet. Open the first month's file, then copy the data rows from months two and three underneath, keeping the column order identical (Date, Description, Amount, Balance). Then add two columns of your own: Category (client income, software, travel, tax, personal) and Notes. Go through the quarter once, line by line, and categorize everything. This is the unglamorous hour that makes the rest of the year easy: with categories in place, a pivot table gives you quarterly revenue, deductible expenses, and the number your accountant needs for your tax return in about thirty seconds. Freelancers who do this quarterly instead of annually consistently tell me their accountant's bill drops, because clean categorized data is cheaper to work with than a shoebox of PDFs — see how bank statements work for freelancers for more on that math.
Step 4: Lock the output back down
An unlocked Excel file with a year of income and spending is more sensitive than the locked PDFs you started with, so finish the job properly. In Excel, go to File, then Info, then Protect Workbook, and set a password on the file — pick something from your password manager, not your dog's name. Store the quarterly spreadsheets in the same bookkeeping folder, and keep one encrypted backup: an external drive or a cloud folder with two-factor authentication, not an email draft to yourself. Finally, delete the intermediate unlocked PDFs from your Downloads folder now that the Excel versions exist and are backed up. Redundant copies of financial documents are how data leaks happen — one authoritative, protected copy per quarter is the goal.
Frequently asked questions
Why does my Nationwide PDF ask for a password but my friend's does not?
It depends on the delivery channel. Emailed statements are usually password-protected; statements downloaded directly from the Internet Bank or app often are not. Both are the same statement — only the wrapper differs.
Can I convert a whole year of Nationwide statements at once?
Convert each PDF individually, then merge the Excel outputs into one sheet as described above. Keep column order identical across months so the merge is a clean copy-paste.
Is removing the password from my own statement allowed?
Yes. It is your file and your data. Just keep the unlocked version somewhere secure, as described in step 4.
What if I lost the password entirely?
The password is derived from your own details (DOB, name), so it is recoverable — check the original email first, then Nationwide's help pages. You can also request a fresh copy of the statement, which will come with the current password format stated.
Quarterly bookkeeping is a habit, not a project. Find the password once, build the unlock-and-convert routine, and every quarter after this one takes under an hour. Start with this quarter's Nationwide statements on ConvertStatement — free for your first files — and give your future self the gift of books that are always current.