Church offering count sheet
If the envelopes and loose cash don't add up to the money on the table, don't adjust the loose cash until they do. Type the count into this sheet as you go, and any difference shows up while both counters are still in the room. It also prints on one page for teams that count on paper first.
Inside your free Excel download
- A count by denomination, from $100 bills down to pennies, that adds itself up
- A check log and an envelope log, each gift with its donor and fund
- Totals by fund, two signature lines, and four checks that say Ties or Off by
Count the loose cash on its own and type it in. Don't work it out from the other totals.
Get your offering count sheet
Download an editable .xlsx file immediately.
One Sunday's count, tied out
A preview of the workbook. Your download includes the full editable template.
| Cedar Hill Church, March 8, 2026 | Amount |
|---|---|
| Cash counted by denomination | $1,738.87 |
| Envelope cash plus loose cash | $670.00 + $1,068.87 = $1,738.87 |
| Checks, listed one by one (8) | $1,995.00 |
| Total offering | $3,733.87 |
| General, Building, Missions, Benevolence | $3,733.87: Ties |
| Deposit slip | $3,733.87: Ties |
Keep your next step connected
Start with the spreadsheet. When you need your giving, spending, funds, and reports in one ledger, explore Grain.
When the count doesn't match
Someone asked on the PowerChurch user forum why "the envelope contribution total plus the loose offering total don't always match the actual money count." One reply told them to adjust the loose change so the totals equal the deposit. Don't. That hides the mistake. If an envelope held less than the donor wrote, the donor gets credit for money that never came in. If someone miscounted the twenties, nobody ever finds out.
The sheet runs four checks while you count. Each one says Ties or Off by, and the amount:
- Envelope cash plus loose cash equals the cash you counted.
- The second counter's own count of the cash equals the first.
- The fund totals add up to every check, envelope, and loose dollar listed.
- The deposit slip equals the total offering.
One Sunday's offering, counted two ways
- Checks (8) $1,995.00
- Loose cash $1,068.87
- Envelope cash $670.00
- General $2,758.87
- Building $700.00
- Benevolence $160.00
- Missions $115.00
When one says Off by, recount together before the bag is sealed. If it still won't tie, write the difference on the sheet and both counters sign. A $5 gap that's written down can be traced. A $5 gap tucked into the loose cash never will be.
Envelope cash belongs to a donor. Loose cash doesn't.
Open each envelope and write down what was inside, next to what the donor wrote on it. In the sample, envelope 117 says $50 and holds $45. The donor gets credit for $45, the envelope total drops by $5, and the count still ties. The Free Methodist Church in Canada's treasurer's guide gives the same rule: "record the amount in the envelope."
The donor needs that amount on record too. Under IRS Publication 1771, a donor can't deduct a cash gift of any size without a bank record or a written record from the church showing its name, the date, and the amount. When a donor needs a receipt for one of those gifts, the donation receipt template prints it.
Loose cash has no donor to credit. It goes to the General fund, and so does a plain envelope with no name.
What the sheet records
- Two counters' names and signatures. United Methodist guidance asks for "two or more persons - unrelated to each other", and neither of them the treasurer.
- The number on the tamper-evident deposit bag.
- A line for the person who later compares the sheet with the deposit on the bank statement. That person doesn't count.
Deposit the same or next business day, and keep the signed sheet with your accounting records.
After the count
Online giving hasn't replaced the plate. Across churches on Grain so far in 2026, 31% of giving dollars arrive by check and 14% in cash, so close to half of the money still passes through the count room.
At the bank, Sunday's offering is one deposit. In your books, it's many gifts split across funds, the same split this sheet makes. In Grain, each fund keeps its own balance. If you enter cash and checks in Pushpay's Batch Entry, those batches sync to Grain. With Planning Center, batch deposits reconcile with your bank. Grain's Starter plan is free for churches with up to $20,000 a month in expenses. See fund accounting in Grain.
At month end, the treasurer's report template ties each bank account to its statement, and the month-end checklist covers the rest of the close.
Frequently asked questions
Should we still count pennies?
Yes. The US Mint stopped putting new pennies into circulation in 2025, but the Treasury says pennies are still legal tender. The sheet keeps a pennies row.
Do online gifts go on the count sheet?
No. The count sheet covers what was in the plate and the box. Online gifts reach the bank through your giving platform's own deposits, so they're recorded from the platform, not counted by hand.