Church Bank Reconciliation: A Treasurer's Monthly Guide

TL;DR Each month, get the church's bank statement, convert it to a spreadsheet, and match every deposit to an offering count sheet and every payment to an approved bill or check. List outstanding checks and deposits in transit, and confirm that the adjusted bank balance equals the balance in your books. Then check that the balances of designated and restricted funds add up to no more than the cash available. Have someone other than the treasurer review the reconciliation, and present a short summary to the finance committee or board.

Church treasurers are often volunteers who agreed to "look after the money" and then discovered how much that involves. The bank reconciliation is the single most important control in that job. Done monthly, it catches errors quickly, protects the treasurer from suspicion, and gives the congregation confidence that gifts are handled properly.

This guide sets out a simple monthly process in Excel or Google Sheets. It works whether you use church accounting software or a spreadsheet as your books. It's general guidance; follow your denomination's or organization's policies where they differ, and ask an accountant familiar with nonprofits about anything specific to your situation.

Why reconciliation matters more for churches

Every organization should reconcile its bank accounts. A few things make it especially important for churches:

• Cash and checks in the offering. Physical money is handled by several people before it reaches the bank. Reconciliation confirms what was counted is what was deposited.
• Volunteers and turnover. Treasurers change. A clean record of reconciled months makes handovers simple.
• Designated gifts. Donors give for specific purposes, such as missions, a building fund or a youth trip. The church needs to show that money is available for its designated purpose.
• Trust. Members want to know their gifts are safe. A reviewed monthly reconciliation is the clearest evidence.
• Protection for the treasurer. When the numbers are reconciled and reviewed by someone else every month, nobody can reasonably question the treasurer's handling of funds.

Controls to have in place

Reconciliation works best alongside a few basic controls. If your church doesn't have these yet, they're worth discussing with your leadership:

• Two unrelated people count every offering and both sign the count sheet.
• Deposits are made promptly, with a copy of the deposit slip attached to the count sheet.
• The person who reconciles isn't the only person who writes checks or approves payments, or at least someone else reviews the reconciliation each month.
• Bills are approved before payment, according to your spending policy.
• Statements are sent to, or accessible by, more than one person.

These are common recommendations for small organizations, not legal requirements. Your church's size and structure will determine what's practical.

What you need each month

1. The bank statement for every church account: operating, savings, and any separate fund accounts.
2. Offering count sheets and deposit slips for every deposit.
3. Records of online giving, such as the giving platform's payout reports.
4. The check register or list of payments made, with approvals.
5. Your books: the accounting software, or the spreadsheet you use as the cash ledger.
6. Last month's reconciliation, for outstanding items carried forward.

Step 1: Convert the statement to a spreadsheet

Reconciling from a PDF means ticking items on paper. A spreadsheet lets you sort, match and total, and leaves a tidy record.

SheetStatement converts the statement PDF to Excel or CSV, puts each transaction on one row, keeps check numbers, and checks the opening balance plus activity equals the closing balance. The free plan includes 3 pages a month, which covers a typical small church statement; Starter ($9), Pro ($19) and Business ($39) monthly plans cover more.

Confirm the converted statement balances on its own:

=ROUND(OpeningBalance + SUM(Amounts) - ClosingBalance, 2)

It should be zero. The free balance checker can confirm it.

Add columns for Matched to, Fund and Note.

Step 2: Match deposits to count sheets

For each deposit on the statement, find the count sheet and deposit slip.

If a deposit doesn't equal the count sheet:

• Bank adjustments. Banks sometimes correct a deposit if the slip total was wrong or a check bounced. Look for an adjustment line or a notice.
• Split deposits. One count may have been deposited in two parts.
• Timing. A Sunday offering deposited Monday appears under Monday's date. That's fine; match by amount and the nearest count.

Every difference should be explained in the Note column and, if necessary, reported to the finance committee.

Online giving

Giving platforms usually deposit a net amount: gifts minus processing fees, often in batches. Match each payout to the platform's report, and record gifts at their gross amount in your books with the fee as an expense. That way giving totals and donor records match, and the fee is visible. Our guide to reconciling Stripe payouts explains the same gross-and-fee pattern in detail; many giving platforms work in a similar way.

Step 3: Match payments

For each check, transfer and card payment on the statement, find the approved bill or payment record.

Checks. Match by number and amount. Note any check that cleared for a different amount from the one in your register; this is rare but important. Our KeyBank statement guide shows how to build a check register with gap detection, which works with any bank.

Automatic payments. Utilities, insurance, payroll services and loan payments. Make sure each is expected and recorded in your books.

Bank fees and interest. These appear on the statement before you know about them. Record them in your books now.

Anything unexpected. An unfamiliar payment should be investigated promptly with the bank. Don't wait for the next meeting.

Step 4: Outstanding items

Some items in your books won't be on the statement yet, and that's normal.

• Outstanding checks: written and recorded, but not yet cashed.
• Deposits in transit: recorded in your books, but deposited after the statement date.

List them. Our guide to outstanding checks and deposits in transit explains how they work.

Watch for checks that stay outstanding for months. A check to a guest speaker or a supply that was never cashed should be followed up. If it's lost, void it and reissue; if it's no longer owed, void it and record the reversal.

Step 5: The reconciliation

Put it together on one sheet:

If the difference isn't zero:

1. Check bank fees, interest and automatic payments are all in the books.
2. Check every deposit matches a count sheet and every count sheet a deposit.
3. Look for transposed digits; differences divisible by 9 are a classic sign.
4. Compare last month's outstanding items with this month's statement; anything that cleared should come off the list.

Our guides to reconciling a bank statement in Excel and finding reconciliation discrepancies cover these steps in more depth.

Step 6: Check designated and restricted funds

This is the step specific to churches and other nonprofits. Money given for a specific purpose needs to be tracked separately, even if it sits in the same bank account.

Keep a fund table:

Two checks:

1. The total of all funds equals the reconciled book balance across the accounts that hold them. If not, a transaction is missing a fund or is assigned to two.
2. No fund is negative. A negative designated fund means money given for one purpose has effectively been spent on another. That's a conversation for the finance committee, not something to fix quietly.

In your converted statement and books, the Fund column makes this easy. Totals by fund:

=SUMIFS(Books[Amount], Books[Fund], A2)

The terms "designated" and "restricted" can have specific meanings in nonprofit accounting. Ask an accountant familiar with nonprofits how your church should classify and report them.

Step 7: Review and report

Independent review. Someone other than the treasurer, such as a finance committee member, should review the reconciliation each month. They look at the statement, the reconciliation sheet, the list of outstanding items and any notes, then sign and date it. This takes ten minutes and is one of the most effective controls a small organization can have.

Monthly report. Keep it short and readable:

• Bank balances at month-end.
• Giving for the month and year to date, compared with budget if you have one.
• Major expenses.
• Fund balances.
• Any issues: unexplained differences, stale checks, unusual transactions.

Year-end. Twelve reviewed reconciliations make a year-end review or audit much simpler. Keep the statements, count sheets, reconciliations and reports together. Our checklist on preparing bank statements for an audit covers what reviewers commonly request.

A worked example

A small congregation has one checking account and one savings account holding the building fund. The new treasurer takes over in June.

1. Convert. June's checking statement is converted. It balances on its own.
2. Deposits. Four Sunday deposits match count sheets. One online giving payout matches the platform report; gifts are recorded gross, with the fee as an expense.
3. Payments. Eleven checks match the register. One check from March is still outstanding, to a visiting speaker. The treasurer contacts the speaker, who never received it; it's voided and reissued.
4. Bank items. A monthly service fee wasn't in the books. It's recorded.
5. Reconciliation. After the fee, the difference is zero.
6. Funds. Fund totals equal the combined reconciled balance of checking and savings. Missions is positive but low; the treasurer notes it for the committee.
7. Review. A committee member reviews, signs and dates the reconciliation.
8. Report. A one-page summary goes to the next meeting.

The new treasurer has a clean starting point, and the handover from the previous treasurer is documented.

Petty cash, events and fundraisers

A few kinds of activity cause most of the reconciliation headaches in churches. Handling them consistently saves a lot of time.

Petty cash. If the church keeps a small cash float for minor purchases, treat it as its own account. Set a fixed amount, require a receipt for every purchase, and top it up by check or withdrawal for exactly the total of the receipts. The bank statement then shows a single replenishment, and your books record the individual expenses from the receipts. Count the float when you reconcile; cash plus receipts should always equal the fixed amount.

Special events. Bake sales, dinners, concerts and similar events often bring in cash and checks outside the normal offering. Count them with two people, just like the offering, use a separate count sheet marked with the event name, and assign the income to the right fund. If the event had expenses paid from the church account, record them against the same event so you can report a net result.

Fundraisers for a specific cause. Money raised for a mission trip, a family in need or a building project is designated by the donors' intent. Record it in the matching fund as it comes in, and pay related expenses from that fund. When the purpose is complete, any balance should be handled according to your church's policy, which your leadership should decide rather than the treasurer alone.

Reimbursements to members. When a member buys supplies and is reimbursed, require a receipt and an approval, pay by check or transfer rather than cash, and record the expense in the right category and fund.

A simple spreadsheet layout

If your church keeps its books in a spreadsheet rather than accounting software, a single workbook with a few sheets is enough:

1. Ledger. Every transaction in the church's books: date, description, amount, category, fund, check number and a reference to the count sheet or bill. This is the "balance per books" side.
2. Statement. The converted bank statement for the month, with Matched, Fund and Note columns.
3. Outstanding. Outstanding checks and deposits in transit, carried forward month to month.
4. Reconciliation. The one-page summary shown in Step 5, with formulas pulling from the other sheets.
5. Funds. The fund table, with formulas totaling the Ledger by fund.
6. Report. The monthly summary for the committee.

Start a new copy each year, and keep each month's statement sheet rather than overwriting it. Our bank reconciliation template guide shows how to build the reconciliation sheet step by step.

Handing over to a new treasurer

If you're stepping down, a good handover includes:

• The last reconciled month, signed by the reviewer.
• The list of outstanding checks and deposits in transit.
• The fund table.
• Online banking and giving platform access arranged through the proper channels, not by sharing passwords.
• A short note on recurring payments, annual bills, and anything unusual.

If you're taking over and the records are behind, start with the most recent month you can reconcile and work backward if needed. Our guide on catch-up bookkeeping describes a sensible order.

Start this month's reconciliation

Upload the church's bank statement to SheetStatement, confirm it balances, and download Excel or CSV to match deposits and payments. The free plan covers 3 pages a month.

FAQ

How often should a church reconcile its bank account?

Monthly, as soon as the statement is available. It keeps differences small and easy to explain.

Who should do the bank reconciliation?

Commonly the treasurer prepares it and someone independent, such as a finance committee member, reviews and signs it. Follow your church's policies.

How do I reconcile online giving?

Match each platform payout to the platform's report. Record gifts at their gross amount and the processing fee as an expense, so the net matches the deposit.

What if an offering deposit doesn't match the count sheet?

Look for a bank adjustment, a split deposit or a bounced check. Note the explanation, and report any unexplained difference to the finance committee.

How do I track designated gifts in one bank account?

Assign each transaction to a fund and keep a fund table. The total of all funds should equal the reconciled book balance, and no fund should be negative.

What should I do with very old outstanding checks?

Contact the payee. If the check was lost, void and reissue it. If it's no longer owed, void it and record the reversal. Follow any rules that apply to unclaimed funds in your area.

How should we handle petty cash?

Keep a fixed float, require receipts for every purchase, and replenish it for exactly the receipts' total. Count it when you reconcile; cash plus receipts should always equal the float.

Can I do this in Google Sheets?

Yes. Every formula here works in Sheets. See reconciling a bank statement in Google Sheets.

Is this accounting or legal advice?

No. It's general guidance on a common process. Ask an accountant familiar with nonprofits about fund classification, reporting and any requirements that apply to your church.