Church Petty Cash Log and Pledge Tracker Spreadsheet
$12.99
Petty cash that won't balance, pledges nobody is following up and a housing allowance designated late are the problems that surface at audit time. This church bookkeeping spreadsheet covers petty cash, pledge campaigns, the minister's housing allowance, and fixed assets, plus a housing allowance designation letter and a written financial policies starter. Excel and Google Sheets, Word and Google Docs.
Share
What's inside
- Church_Petty_Cash_Reconciliation.xlsx + EXAMPLE: imprest fund voucher log, cash counts with a second person (cash + receipts = fund), replenishment worksheet, cash box / change fund log, approval and receipt checks, summary by account and fund
- Church_Pledge_Campaign_Tracker.xlsx + EXAMPLE: pledges by campaign (weekly, monthly, quarterly, annual or one-time), payment log, pledged vs received and amount due to date, campaign summary, follow-up list sorted by amount behind
- Church_Housing_Allowance_Log.xlsx + EXAMPLE: designation by year (date designated, board minutes, letter given), actual housing costs by category, fair rental value plus utilities, and the "lowest of" limit worksheet from IRS Publication 517
- Church_Fixed_Assets_Register.xlsx + EXAMPLE: asset register with tag numbers, capitalization threshold, purchased or donated, straight-line depreciation, disposals with gain or loss, physical inventory tracking, summary by category and location with cost and depreciation roll-forward
- Church_Housing_Allowance_Designation_Letter.docx + EXAMPLE: letter to the minister, sample board-minutes wording, minister's acknowledgment and checklist
- Church_Written_Financial_Policies_Starter.docx + EXAMPLE: 13-section starter policy: roles and separation of duties, counting offerings, spending approvals, bank reconciliation, restricted funds, donor receipts, pay and reimbursements, petty cash, property, conflicts of interest, record retention, adoption
Who it's for
- Part-time treasurers at churches roughly 40 to 250 in attendance who keep a petty cash box, run a building or pledge campaign, pay a minister with a housing allowance, own property and equipment, or need written financial policies for the board
Details
This pack is for treasurers of small churches and ministries. It keeps petty cash, pledge campaigns, minister housing allowance records, fixed assets and written policies in one place.
The download is a .zip with 12 files: four workbooks (each blank plus EXAMPLE) and two Word documents (each blank plus EXAMPLE). Church_Petty_Cash_Reconciliation.xlsx has Start Here, Setup, Log, Counts, Reconciliation, Cash Box, Summary and Lists. Church_Pledge_Campaign_Tracker.xlsx has Start Here, Setup, Pledges, Payments, Campaigns, Follow-Up and Lists. Church_Housing_Allowance_Log.xlsx has Start Here, Setup, Designations, Expenses, Summary and Lists. Church_Fixed_Assets_Register.xlsx has Start Here, Setup, Assets, Inventory, Summary and Lists. The Word files are Church_Housing_Allowance_Designation_Letter.docx and Church_Written_Financial_Policies_Starter.docx. Fill in the yellow [brackets]. Fund categories are Unrestricted (General), Board-designated and Donor-restricted. Codes such as GEN, DES-OPR and RES-BLD can be customized.
Enter the church once on each Setup tab, then log vouchers, counts, pledges, payments, housing costs and assets as they happen. Type in the cream cells. Everything else calculates. It works in Excel 2016 or later, and in Google Sheets and Docs after you upload the files to Drive. There are no macros. Nothing is shipped.
Can our board adopt the policies as written? They are a starter. Have your attorney or CPA review them first.
Does it work in Google Sheets and Docs? Yes, after uploading to Drive.
Do the fund codes match the other church packs from this shop? Yes. They use the same fund categories.
Before you buy
Organizational tool, not tax, legal, or accounting advice. Not approved or endorsed by the IRS or any denomination. Does not guarantee compliance or a clean audit. The housing allowance tools follow the general rules in IRS Publication 517. Ask your CPA how the rules apply to your minister. Ministers still pay self-employment tax on the allowance. Have your attorney or CPA review the letter and policies before your board adopts them. Built by ReconciledBooksCo, a small shop run by an experienced accountant.
Excel and Google Sheets. No macros. Paid spreadsheet products include a blank file and a filled example, plus a Start Here tab in plain English.
Licensed for one church per purchase.
