To turn a business credit card statement into Excel by cardholder, convert the PDF to rows, then add a Cardholder column and fill it section by section, since the statement groups each employee's charges under their name. A filter then gives each person their own sheet. The page count of the PDF sets the conversion price.
How is a business card statement split by cardholder?
A business card statement is usually one account with several cards on it. The PDF opens with an account summary for the company, then lists transactions in blocks, one block per card, each headed by the employee's name and the last digits of their card. Within a block, rows run in date order.
The layout varies by issuer, but most share these parts:
- Account summary. The previous balance, payments, new charges, fees and interest, and the new balance for the whole company.
- Cardholder blocks. A heading such as a name and "card ending 4471", followed by that card's purchases and credits.
- Cardholder subtotals. Many issuers print a total at the end of each block.
- Company-level lines. Payments, account fees and interest that belong to the account, not to one person.
- Disclosures. Rate tables and legal text at the end.
The blocks are what make this statement different from a personal one. A personal card statement has one spender. A business statement for five employees has five small statements stacked inside one PDF, plus a summary for the company that pays the bill.
That structure matters for the spreadsheet. A converted file has date, description and amount columns, but the cardholder is printed as a heading above the rows, not on each row. If you sort the sheet by date before you record who spent what, you lose the cardholder for good. Tag first, sort later.
Cardholder page counts and the price of one business statement
The price of a converted business statement depends on its page count, and cardholders drive the page count. Each extra card adds a heading, its rows and often a subtotal. Three active employees can push a statement past 10 pages, which moves it from the small tier to the larger one at early pricing.
The homepage lists these early prices, which may change before launch. A statement up to 10 pages costs $2.99. One from 11 to 40 pages costs $5.99. Five statements of up to 40 pages each cost $9.99 together, and the first 2 pages of any statement can be previewed free.
Here is an example of how cardholders add up. The page counts are illustrative.
| Example statement | Pages | Tier | Single price |
|---|---|---|---|
| Owner's card only | 4 | Small | $2.99 |
| Owner plus 2 employees | 9 | Small | $2.99 |
| Owner plus 4 employees | 16 | Larger | $5.99 |
| Owner plus 12 employees | 38 | Larger | $5.99 |
For a year of statements at 11 to 40 pages, bundles save the most. Twelve larger singles would cost $71.88, and three bundles cost $29.97. The bundle price stays the same whether a statement is 4 pages or 38, so a statement that crossed 10 pages is no more expensive inside a bundle.
There is a ceiling to check. The early pricing names no tier above 40 pages. A company with many active cards can produce a longer statement than that, so look at the page count of the busiest month before you plan a year.
Disclosure pages count as pages too. If the last six pages of a 13-page statement are rate tables and legal text, the transactions fit in 7 pages. Removing pages is only safe when you are sure they hold no charges, fees or interest. The summary box on page 1 tells you the totals to expect.
Tagging each row with its cardholder in Excel
Tagging means adding a Cardholder column and filling it for every transaction row before you sort anything. Work down the sheet in the order of the PDF: when a new cardholder heading appears, every row below it belongs to that person until the next heading. A fill-down handles each block in seconds.
Here is a short procedure:
- Open the converted file and insert a column to the left of the date, called Cardholder.
- Open the PDF beside it and find the first cardholder heading.
- Type that name next to the first row of their block, then fill down to the last row of the block.
- Repeat for each block.
- Type "Company" for account-level lines such as the payment and any account fee.
- Add a Card column with the last four digits if two people share a name or one person holds two cards.
This is an example of a tagged section with made-up data:
| Cardholder | Card | Date | Description | Amount |
|---|---|---|---|---|
| A. Rivera | 4471 | 2026-05-03 | Hotel booking | 412.00 |
| A. Rivera | 4471 | 2026-05-04 | Airport parking | 36.00 |
| J. Chen | 9025 | 2026-05-02 | Office supply store | 88.19 |
| J. Chen | 9025 | 2026-05-09 | Refund, office supply store | -22.50 |
| Company | 2026-05-20 | Payment, thank you | -2,500.00 |
Some charges on a business card come with a vendor invoice the business needs to keep. When you match card lines to invoices, remember the invoice is its own document. Converting a PDF invoice to Excel for free explains why an invoice converts differently from a statement.
Employees who travel abroad add another wrinkle. A purchase in another currency may print the original amount, a rate and the converted amount across two lines. Turning a multi-currency bank statement into Excel covers how to keep the original amount in its own column.
One sheet per card from a single business statement
Once every row carries a cardholder, you can give each person their own sheet. The simplest way is a filter on the Cardholder column, then copying the visible rows to a new tab named after the employee. A pivot table is quicker if you want totals rather than rows.
There are three common approaches, and each suits a different use:
- Filtered copies. Filter by name, select the visible rows, paste to a new tab. Good when each employee needs to review and annotate their own charges.
- A pivot table. Rows by Cardholder, values as the sum of Amount. Good for a manager who wants one total per person for the month.
- The FILTER function. In Excel versions that support it,
=FILTER(A:E, A:A="J. Chen")on a new tab builds a live copy that updates when the main sheet changes. Good when you add a new month each time.
Keep the main tagged sheet as the source. If you edit an employee tab and the main sheet separately, they drift apart, and month-end totals stop agreeing. Make corrections in one place.
A company that also holds a store card for one supplier will have a second, simpler statement to add. Converting a store card statement to Excel covers those short statements and the promotional balances they carry.
Business card edge case: company-level fees and payments
Some lines on a business card statement belong to no cardholder. The payment that clears the balance, an annual account fee, late fees and interest are charged to the account. If you assign them to the first or last employee in the file, that person's total looks wrong, so tag them as Company.
Watch for these lines in particular:
- The payment. One large credit, often listed before the cardholder blocks or in its own section.
- Account fees. An annual fee or a fee per card, sometimes printed per card and sometimes as one line.
- Interest. Charged on the account balance, not on any one person's spending.
- Statement credits. Rewards or adjustments applied to the account as a whole.
Fees printed under a cardholder's own block are a judgment call. A fee for an extra card might reasonably sit with that employee, or with the company. Pick one rule and apply it every month.
Refunds are the other trap. A refund appears in the block of the card that made the original purchase, as a negative amount. If it posts in a later month, the employee's total for that month can be negative. That is correct and worth leaving as it is.
A business owner sometimes pulls figures from statements for personal forms as well. A card balance is money owed, not money held. If a family member is applying for student aid, what the FAFSA asks about bank account balances covers what goes on that form, which is a separate question from this sheet.
Do the cardholder subtotals add up to the business statement?
The subtotals add up when the sum of every cardholder's charges, plus company-level lines, equals the new charges and credits in the account summary. Build that check right after tagging. If a block was cut short in conversion, or a row landed under the wrong name, this is where it shows.
Here is a worked check with made-up figures:
| Line | From the sheet | From the PDF |
|---|---|---|
| A. Rivera charges | 1,210.40 | 1,210.40 (block subtotal) |
| J. Chen charges | 465.69 | 465.69 (block subtotal) |
| M. Okafor charges | 802.15 | 802.15 (block subtotal) |
| Company fees and interest | 31.00 | 31.00 |
| Total new charges | 2,509.24 | 2,509.24 (summary box) |
| Payment | -2,500.00 | -2,500.00 |
Then run the account equation: previous balance, plus new charges, minus payments and credits, equals the new balance. When both checks pass, every row is accounted for.
If a cardholder's total does not match their block subtotal, the gap is inside that block. Look for a row at a page break, a refund that lost its minus sign, or a row filed under the neighbouring name. Fix the gap before you send anyone their sheet.
When the statement is ready, the free preview from CheapBankConvert shows the first 2 pages as rows, so you can see the first cardholder block before you pay. It is getting ready to open, and you can sign up to be emailed when it does.