Bank Fee Expense Template

Bank fees are the kind of expense nobody likes finding on a statement. They are small, they are recurring, and they slip right past a busy bookkeeper chasing bigger problems. Left untracked, those $12 overdraft charges and $35 wire fees quietly drain a few hundred dollars a year from a small business, and they almost never make it into the right expense category on the tax return. A simple bank fee expense template fixes that. One sheet, one row per fee, and a clear view of what you paid, why, and whether the charge should have been there at all.

What the template is

This is a reusable spreadsheet layout designed to log every fee your bank charges across every account you operate. Each row captures the date, the bank, the account, the fee type, the dollar amount, whether the fee was waived on request, and a notes column for context. Whether you use Google Sheets, Excel, or Numbers, the columns stay the same, and the totals at the bottom give you an at-a-glance picture of how much you handed the bank over the quarter.

The template is built for the realistic mess of small-business banking: multiple accounts, occasional overdrafts, monthly service charges on accounts you barely use, and the occasional mystery fee that nobody on staff can explain.

Fields and columns

Every column earns its place. Here is what each one does and how to fill it.

• Date: The day the fee posted, which is usually one or two business days after the triggering event. Use the posted date, not the transaction date, so your report matches the bank statement.
• Bank: The name of the institution that charged the fee. Helpful when you operate business accounts at more than one bank.
• Account: The masked account number or nickname (for example, "Business Checking …4421") so you can trace the fee back to the right statement.
• Fee type: A short label like overdraft, monthly service, wire transfer, ATM, returned deposit, foreign transaction, or stop payment. Consistent labels make filtering easy.
• Amount: The fee in U.S. dollars. Use a number only, no dollar sign, so the column sums cleanly in your spreadsheet.
• Waived: A yes/no flag. Mark Yes if you called the bank and got the fee reversed, then log the date you got the reversal in the notes column.
• Notes: Free-form context. What triggered the fee, who you spoke with, any escalation reference number, and whether the same fee is likely to recur.

How to use the template

Start by downloading your bank statements for the period you want to track, either as CSV exports from online banking or as PDF statements you will review manually. Most small-business online banking portals let you filter by "fees" or "service charges," and that filter alone cuts a 200-row statement down to the handful of rows that matter.

Open the template and create one row per fee. Resist the temptation to combine two fees on the same line; the whole point of the template is to flag patterns, and patterns only show up when each fee stands alone. Once the rows are in, drop a SUM formula at the bottom of the Amount column to see the running total, and a COUNTIF formula on the Fee type column to see how many of each kind you paid.

If you operate more than one account or more than one entity, duplicate the template into a separate sheet per account, then build a small summary sheet that rolls everything together for a quarterly review.

Customization options

Every business is different, so the template should bend to fit yours. The most useful customizations are:

• Add a "Recovered" column if your bookkeeper routinely calls banks to reverse fees. It separates fees you actually paid from fees you fought back and won, which makes the true cost of banking very visible.
• Add an "Account category" column if you want to separate personal accounts, business operating accounts, and savings. Useful at tax time when only certain fees are deductible.
• Add a "Reimbursed by client" flag if some of your accounts are client trust or escrow accounts. A flag column makes it easy to invoice those fees back at month end.
• Add a dropdown for "Reason code" with values like avoidable, bank policy, one-time error, or reimbursable. The reason-code column is where the real cost-cutting decisions start to surface.

When you finish a quarter, copy the sheet into a master "Bank fees by year" file. A year-over-year view is the fastest way to spot a creeping fee problem, like a slowly rising number of overdraft charges on a single account that you can solve by switching accounts or wiring your account to a different product.

Common use cases

Small-business owners use this template in three situations. First, at tax time, to confirm the bank-fee line on Schedule C or the appropriate deduction on a corporate return, and to argue with the bookkeeper if those numbers seem low. Second, during a quarterly review with the bank, where a one-page summary shows whether the monthly service charge on a business account is paying for itself. Third, when a CFO or accountant asks, unprompted, "how much did we pay in fees last year?" A clean template answers that question in under a minute instead of a half-day of statement archaeology.

If you want to skip the manual statement review and pull these fees directly from your bank feed, SlipSheet can scan your statements, extract every fee line, and drop the rows into this template format ready for export to Google Sheets or Excel. Try SlipSheet free for 14 days and skip the typing.