How to Create an Expense Report From a Bank Statement

Short answer: To create an expense report from a bank statement, convert the statement PDF to a spreadsheet so every transaction is a row, add a category column and tag each line, exclude transfers and personal charges, then total the expenses by category and by date range. The result is a dated, categorized list with a grand total, which is exactly what a reimbursement request, a client bill, or a tax return needs.

Most people build expense reports the slow way, typing charges off a PDF into a template one at a time. The statement already has every transaction in order, so the faster path is to get that data into rows and work from there. Here is the full process, plus the judgment calls that keep the report accurate.

Why build the report from the statement

A bank or card statement is the source record. It shows every charge that actually cleared, with the real date and amount, which is stronger evidence than a pile of receipts that may be missing a few. Building the report from the statement means nothing gets left out, and it gives you a document that reconciles to an account rather than a hand-keyed list nobody can verify. For a business, that is the difference between an expense report an accountant trusts and one they have to re-check.

Step 1: Convert the statement to a spreadsheet

Start by turning the PDF into rows. Upload it to the PDF bank statement to Excel converter and download an XLSX or CSV with dates, descriptions, debits, credits, and the running balance in their own columns. Copying and pasting out of a PDF scrambles the columns, so a proper conversion saves the cleanup. If the expenses span several months or cards, convert each statement and stack the rows into one sheet so the whole period is in one place.

Step 2: Categorize each transaction

Add a category column and label every line: travel, meals, software, supplies, advertising, and so on. Sort by description so repeat merchants group together and you can tag each one in a single pass. Naming categories after the lines on your tax form (Schedule C for a sole proprietor) means the totals carry straight into filing later. To skip the manual tagging, our transaction categorization tool assigns an income or expense category during conversion, so the sheet arrives already labeled and you only review the exceptions. A dedicated expense management tool that reads receipts and sorts spending automatically can take this further for a team that files reports every month.

Step 3: Exclude what is not an expense

This is the step that separates an accurate report from an inflated one. Transfers between your own accounts, credit card payments, owner draws, and loan principal move through the statement but are not expenses. Tag them as excluded and keep them out of the totals. On a mixed personal-and-business account, also flag personal charges so they do not end up in a business report. If you are reimbursing an employee, drop anything that was not a business purchase, even if it cleared the same card.

Step 4: Total by category and date range

With every line categorized, build a pivot table (or a simple SUMIF) to total spend by category, then filter to the date range the report covers. You now have a per-category breakdown and a grand total. For a reimbursement, that total is the amount owed. For taxes, the category totals map onto the return. For a client, you can filter to just their billable charges and export that slice.

Step 5: Attach the backup and reconcile

Keep the converted statement as the backing document, and attach receipts for the larger or unusual charges so the report stands up to a review. Then confirm the numbers are complete by running a quick bank reconciliation: the categorized expenses plus the excluded transfers and any income should account for the change in the running balance over the period. If it ties out, nothing is missing.

How do I make an expense report in Excel?

To make an expense report in Excel, put the transactions in a table with Date, Description, Amount, and Category columns, use Format as Table so you can sort and filter, then add a PivotTable that sums Amount by Category. Filter the table to your date range, exclude transfers and personal lines, and the pivot gives you category subtotals and a grand total. Starting from a converted statement means the rows are already clean, so you only add the category column and the pivot.

Can I use a bank statement as an expense report?

A raw bank statement is not an expense report on its own, because it mixes expenses with transfers, income, and personal charges and shows no category totals. But it is the ideal source for one. Once you convert it to a spreadsheet, categorize the lines, and drop the non-expenses, you have a proper report. Many reimbursement and tax processes will accept the statement itself as supporting evidence alongside the categorized summary.

The bottom line

An expense report is just a categorized, totaled view of the money you spent, and your statement already lists every transaction. Convert it to a spreadsheet, tag the categories, exclude the transfers, and total by category. You get a faster, more complete report than typing from a PDF, and one that reconciles to a real account.