Microsoft Excel Add-in for Bank Statement Conversion

Converting a client's PDF bank statement from Excel takes four steps with the Rocket Statements add-on: install it from Microsoft Marketplace, sign in, convert the statement, and import the rows into your workbook with one click. This guide walks through that flow in Excel on the web, then shows how a bookkeeper with a dozen clients can make it a routine. (Microsoft calls these add-ins. Rocket Statements calls them add-ons. They are the same thing.)

What does an Excel add-on for bank statement conversion do?

A bank statement conversion add-on sends a statement you already have to a conversion service and writes the transactions back into your sheet. The Rocket Statements Excel add-on is a client for your Rocket Statements account. You sign in from the add-on, the conversion runs on Rocket Statements' servers rather than inside Excel, and the sheet receives a header row followed by the extracted transactions.

That split matters for firms. The sheet is just the destination. The statements themselves live in your account, in folders you organise, so the next month's conversion starts from the same place as this month's. It also means the add-on needs an account, which is why the first step is signing in rather than loading a file.

The add-on takes statements you supply. It accepts PDF and image (JPG, PNG) statements. It does not log into a bank and fetch documents for you, so the file has to be in your hands first.

How do you install the Excel add-on?

You install it from its Microsoft Marketplace listing, called "Rocket Statements", and it runs in Excel on the web.

Open the Rocket Statements listing on Microsoft Marketplace and choose to get it. Or open Excel on the web, select Home, then Add-ins, and search the Store tab for "Rocket Statements", as Microsoft's support page for Excel on the web describes.
Add it and accept the prompts. Microsoft may ask you to sign in first.
Open the add-on and sign in to your Rocket Statements account.

The add-on runs in Excel on the web, so that is where to use it. If your firm works in Excel on Windows, Mac or iPad, check the Marketplace listing before you rely on it there, and try it on a single workbook before you plan a workflow around it.

How do you convert a bank statement PDF to Excel with the add-on?

Sign in. Use Google, Microsoft, or an email and password. The same login works in the Google Sheets add-on and on the web app.
Choose the statement. Choose the PDF or image statement you want converted.
Convert. Rocket Statements recognises the bank's statement layout automatically, so there is no template to build for a new bank or a new client.
Import. One click writes the header row and the transactions into your workbook.

Extracted transactions are reconciled against the balances printed on the statement itself, so an extraction error surfaces instead of slipping into your workbook unnoticed. For a reviewer, that changes the job: you are not relying on a silent pass, because errors come to you rather than hiding in the rows.

How does it work for an accountant with many clients?

The add-on is most useful when the account behind it is organised by client, because every conversion lands in the sheet as a header row plus transactions. Take a bookkeeper with twelve monthly clients, each sending one bank statement and one or two card statements, which comes to 24 to 36 PDFs a month.

Without a system, those PDFs arrive by email, get saved wherever, and are converted one by one with whatever tool is open. With the add-on, the routine looks like this:

Each client has a workspace. With client portals, clients upload their statements straight into the right place, so you stop chasing attachments.
Statements sit in folders and subfolders, for example one folder per client and one subfolder per year.
At month-end you open the client's workbook, run the add-on, and import. Each client's sheet gets a header row followed by the transactions, which gives your own formulas, pivots and review checklist one predictable starting point.
Team accounts let a second person pick up a client without a handover over email.

Two permission levels exist, admin and client. There is nothing finer than that, so a firm that needs separate seat types for processing and administration should plan around two levels.

a bookkeeper's desk with a spreadsheet of monthly client statements beside a tidy folder tree of client uploads

Why use an Excel add-on instead of pasting a statement into ChatGPT?

An add-on keeps your statements, folders and clients in one account behind the sheet, which a chat window does not. Pasting a statement into a general AI chat can work for a single one-off. At twelve clients a month, the weaknesses show: column order and date formats can drift between runs, nothing ties the output to the statement's own totals, and the originals end up scattered across chat histories and email.

With the add-on, conversion is a repeatable job. Errors are surfaced by reconciliation against the statement's balances, documents are kept in cloud folders, and a colleague can open the same workspace. For a deeper look, see ChatGPT bank statement to CSV vs a managed workflow.

What can you do with the converted data?

Once the rows are in Excel, you work with them like any other sheet. If you need a file instead of an import, Rocket Statements also exports CSV, Excel and JSON, plus QuickBooks-compatible files. Those QuickBooks files are for importing yourself. There is no direct integration with QuickBooks, Xero or Sage, so nothing syncs automatically. Bank statement to CSV, Excel, JSON and QuickBooks covers the file formats.

You can also re-download the original PDF you uploaded, which is handy when a client asks about a line during review.

What does it cost and is there a free trial?

Rocket Statements offers pay-as-you-go pricing, subscription plans with volume allowances, and custom quotes. The free trial lasts 7 days or 20 pages, whichever comes first, and it is a one-time trial rather than a monthly allowance. Use it on a real statement from a real client to see how it handles the bank and the layout you actually receive before you commit. Current pricing is on the bank statement converter pricing page.

How secure is it for client documents?

Statement documents are protected with bank-level 256-bit encryption and are never shared. They are stored in your cloud account, which is what makes folders, portals and team access possible. If your engagement letter has specific retention terms, read them against how you plan to use the account.

Frequently asked questions

Is there a Microsoft Excel add-on for bank statement conversion? Yes. Rocket Statements is listed on Microsoft Marketplace and runs in Excel on the web.

Can I convert a bank statement PDF to Excel without building templates? Yes. The bank's statement format is recognised automatically.

Does it work on Excel for Windows or Mac? The add-on runs in Excel on the web. If you use desktop Excel, check the listing before relying on it.

Does it connect to QuickBooks, Xero or Sage? No. It produces files you import yourself.

Can it download statements from my client's bank? No. You or your client supply the PDF or image.

Where do I start? Install the add-on from the Marketplace listing. For firm-wide setup, see bank statement converter for accountants and bookkeepers and client portals for accounting firms.