Converting a business bank statement to Excel works like any statement: one row per transaction, a signed amount and a balance check. The difference is the line types. Business statements can carry account analysis fees, automatic sweep transfers and card deposit batches, so add a Type column that labels each kind before you total anything.
Business bank statement lines a personal statement never shows
A business account statement often carries lines that come from services a personal account rarely uses: account analysis charges, sweep transfers into and out of an investment or loan account, merchant card deposits, payroll batches, wires, and lockbox or remote deposit credits. Each needs a label, because their totals answer different questions.
A Type column
Add a column named Type next to the description, and give every row one value from a short, fixed list. The list below is a starting point. The example descriptions are made up, and your bank's wording will differ.
| Type | Example description on the statement | Sign |
|---|---|---|
| Card batch | MERCHANT DEPOSIT EXAMPLE PROCESSOR 0714 | + |
| Customer payment | ACH CREDIT EXAMPLE CLIENT INC | + |
| Remote deposit | MOBILE DEPOSIT 3 ITEMS | + |
| Sweep in | SWEEP FROM EXAMPLE MONEY MARKET | + |
| Sweep out | SWEEP TO EXAMPLE MONEY MARKET | - |
| Payroll | ACH DEBIT EXAMPLE PAYROLL CO | - |
| Wire out | OUTGOING WIRE EXAMPLE SUPPLIER | - |
| Analysis fee | ACCOUNT ANALYSIS CHARGE | - |
| Card processor fee | MERCHANT FEES EXAMPLE PROCESSOR | - |
Keep the list short. Ten types is plenty for most businesses. A long list invites rows that could go in two places, and then the totals stop meaning anything.
Fill it with rules, not by hand
Most business statements repeat the same few descriptions every month. A lookup table with a fragment of text and the type it maps to, plus an =IFERROR(LOOKUP(2^15,SEARCH(fragments,B2),types),"Other") formula, fills nearly every row. Review the rows marked Other, add a fragment for each, and the next month will need less work.
Account analysis fees on a business bank statement
An account analysis fee is a single monthly charge that bundles the cost of the services the account used, such as deposits processed, items handled or wires sent, often reduced by an earnings credit on the balance kept. The statement shows one total line. The detail usually sits on a separate analysis statement.
What to do in the sheet
Keep the analysis fee as one row with Type set to Analysis fee. Do not try to split it into its parts inside the transaction list, because the parts never moved money one at a time. Only the total left the account, on one date, and that is what the balance reflects.
When the detail matters
If you want to know which service drove the cost, convert the analysis statement as a separate table. Its rows are services and volumes, not transactions, so they belong on their own sheet. A useful view is fees by service by month, which tells you whether a rise came from more volume or a new price.
Fees in other places
Not every business fee arrives as an analysis charge. Wire fees, returned item fees and stop payment fees may post as their own lines on the day they occur. Give them the same Type, or a separate Bank fee type, so the yearly total of what banking costs the business is one SUMIFS away.
How should sweep transfers appear in a business sheet?
Keep every sweep line, labelled Sweep in or Sweep out. A sweep is an automatic transfer between the operating account and a linked account, made to hold the operating balance near a target. Sweeps are real movements in the operating account, so deleting them breaks the balance check, yet they are not income or spending.
Why they look like noise
On an account with a daily sweep, every business day can end with one sweep line. A month of statements might have twenty of them, often for odd amounts, each one moving whatever the day's activity left above or below the target. They crowd out the transactions you care about, which is why people are tempted to delete them.
Filter, do not delete
With a Type column, the answer is a filter. Hide the sweep types when you want to see trading activity, and show them when you check the balance. Totals that exclude sweeps are a SUMIFS with a not-equal condition, such as =SUMIFS(F:F,D:D,"<>Sweep in",D:D,"<>Sweep out"), where F is the signed amount and D is the type.
The linked account
If the sweep moves money into an investment or loan account, that account has a statement too. Its sweep lines are the mirror image of the operating account's. When you combine both accounts, each sweep pair nets to zero, which is the correct result: the business moved its own money between its own accounts.
Card deposit batches on a business bank statement
A card deposit batch is one credit for a whole period of card sales. The card processor groups the day's transactions, settles them, and pays the total into the account, so the statement shows one deposit where your till shows dozens of sales. Processor fees may be taken out first or charged as a separate monthly debit.
A worked example
The figures below are made-up examples. A shop takes 37 card sales on 14 July totalling 1,240.00. Its processor takes fees from each batch before paying out.
| Source | Date | Amount |
|---|---|---|
| Point-of-sale report: gross card sales | 2026-07-14 | 1,240.00 |
| Processor report: fees on the batch | 2026-07-14 | -36.58 |
| Processor report: net payout | 2026-07-14 | 1,203.42 |
| Bank statement: merchant deposit | 2026-07-15 | 1,203.42 |
The bank statement shows only the last line, a deposit of 1,203.42 posted the next day. To tie it back to sales, match it with the processor's payout report by amount and settlement date. Then the gross sales and the fee come from the processor report, not from the bank.
Two layouts to watch for
Processors handle fees in one of two ways. Some deduct them from each payout, as in the example, so the deposit is net. Others pay out the gross amount and debit the month's fees as one line, often early the next month. The Type column should mark the second case as Card processor fee, so the cost of card acceptance is visible alongside the deposits it relates to.
Deposits that span dates
A batch from a Friday may post on the Monday, and a weekend's sales may arrive as one combined deposit. Never match batch deposits to sales by date alone. Match by amount first, then confirm the date is within a few days.
Can a business bank statement sheet be totalled by line type?
Yes. Once each row has a Type, a pivot table with Type down the side and month across the top totals every kind of line in one view. It shows card income, payroll, bank fees and sweep activity separately, and the grand total still equals the month's net change in the account.
Build the summary
- Turn the transaction list into an Excel table so new months extend it automatically.
- Add a Month column with
=TEXT(A2,"yyyy-mm"), where A holds the date. - Insert a pivot table with Type as rows, Month as columns and the signed amount as values.
- Check the grand total for each month against the statement: beginning balance plus that total should equal the ending balance.
Running balance on a busy account
A business account with hundreds of lines a month benefits from a running balance column beside the list, so you can see the cash position on any day. Building a running balance column in Excel for a bank statement covers the formula and how to keep it correct when you sort or filter.
Getting the rows in the first place
The steps to turn a statement PDF into rows are the same for business and personal accounts, and turning a PDF bank statement into an Excel transaction list walks through them. FastBankConvert is being built to turn a statement PDF into dated rows in seconds and to warn you before download if the balances fail to add up. It is getting ready to open, so you can register on the get started page to hear when trials begin.
Business statement PDFs to handle before converting
Several business statement files need attention before conversion: password-protected PDFs, statements that bundle several accounts, statements with check images on extra pages, and statements in another country's format. Sorting them first avoids a converted sheet that cannot be checked.
Protected files
Business banking portals sometimes deliver statements as password-protected PDFs, especially when they are sent by email. A converter cannot read a locked file. Converting a secured PDF to Excel explains how to remove the password from a copy you are entitled to open, and how to keep that copy safe.
Bundled accounts and image pages
A business with an operating account, a payroll account and a tax reserve account may get one PDF for all three. Add an Account column, convert, and check each account's balance separately. Check image pages, which show the front and back of paid checks, hold no transaction rows. They can stay in the PDF for your records; the converted list needs only the check numbers and amounts from the activity section.
Statements from other countries
If the business banks abroad, the statement may use a different date order, separate debit and credit columns with their own markers, and a different way of grouping digits. Converting an Indian bank statement to Excel is one example of how much those details change the conversion.
When to stop and ask
If a statement's total of fees looks wrong, or a sweep target seems to have changed without notice, a spreadsheet will show you the pattern but not the reason. That is a question for your bank's business support team, with the converted sheet in hand as evidence.