When Church Books Still Live in Excel and a Shoebox
The money is already in the account. The books are not. A look at the Tuesday night close when churches still run Excel, bank apps, and a shoebox of receipts.
Tuesday night the fellowship hall is quiet. The treasurer sits at the same folding table where the youth group ate pizza on Sunday. She opens the bank app first.
Sunday's deposit is already there. A $340 cash-and-check drop from the morning service. A $250 Zelle from M. Rodriguez that landed at 2:17. A $75 Cash App transfer that came in Monday after work. The money is in the account. The books are not.
She sets the rest of the table. The phone, still logged into PayPal and Venmo. A manila folder of receipts, some printed, some photographed and never printed. Three checks that were not in the Sunday deposit because someone left them in a Bible. Last year's workbook, copied forward in January, still named Church_Finances_2026_final_v3.xlsx.
I have sat at that table. I have counted the ones and fives twice because the first count did not match the envelope. I have stared at a bank line that said "Zelle payment from JPerez" and tried to remember whether José meant Missions or General. The work is not mysterious. It is slow.
The piles on the table
Every church that still closes in Excel ends up with the same piles.
The bank app is the first pile. It tells the truth about cash in the account. It does not tell you who gave, which fund they meant, or whether the $89.42 debit at the hardware store belongs to Building or to a volunteer who still needs to be reimbursed. It is a list of movements. It is not the books.
The second pile lives on the phone. Zelle notifications sit inside the bank. Cash App, PayPal, and Venmo sit in their own apps, each with a different name format and a different habit of leaving the memo blank. The money is real. The identity is a puzzle.
The third pile is cash and checks. Someone counted the cash after the last song. Someone stacked the checks and wrote a total on a sticky note. Those bills and checks may already be in the night drop. They still have to become rows: donor, amount, fund, date.
The fourth pile is receipts. A folded Home Depot slip from a Saturday work day. A photo in a text thread of a grocery run. A reimbursement that arrived as "can you pay me back when you get a chance." Expenses wait in a tab named Expenses, or they wait in the folder, which is the same as waiting.
The fifth pile is last year's workbook. Tabs for Giving, Expenses, Funds, maybe Bank Rec. Formulas someone trusted in March and has been afraid to touch since. A fund balance that is "probably close." A note in cell A1 that says "ask pastor about the special offering." The file is the closest thing the church has to a system. It is also the thing that only one person fully understands. Together the piles are the close.
Why Excel is still the honest tool
Spreadsheets are flexible and familiar. I will not pretend otherwise.
A church with one bank account, one weekly service, and a handful of checks can run an honest set of books in Excel. Cash is counted. Checks are listed. A few Zelle gifts are typed in because the treasurer already knows who sent them. Expenses stay in one person's head. Reports go to the pastor once a month.
That church should keep the spreadsheet.
Keep spreadsheets when the church is very small, activity is simple, and one reliable person maintains the process. I mean that. Altarflow is not a moral upgrade. It is a different operating model, and it is the wrong one if the workbook still fits the work.
A spreadsheet is not a failure. Volunteers built entire ministries on files like this. I have watched a treasurer keep a congregation solvent with a well-loved workbook and a habit of reconciling every Tuesday. Familiar software, flexible columns, no new login for the person who already gives the church ten hours a week. Those are real strengths.
The honest question is not whether Excel is good. Excel is good at being a spreadsheet. The honest question is whether the church is still doing spreadsheet work, or whether the file is now holding work it was never meant to hold.
When the spreadsheet becomes the bridge
The real alternative is usually not one spreadsheet. It is a spreadsheet plus bank portals, paper, receipt folders, giving exports, and QuickBooks.
That is the sentence I wish someone had said to me earlier.
The file looks like the system because it is the only place the story gets assembled. The bank holds the deposits. The giving app, if the church has one, holds some of the gifts and none of the Zelle. Cash App and PayPal hold their own histories. The shoebox or the kitchen drawer holds the paper. QuickBooks, if anyone opened it this month, holds a version of the books that is waiting on the spreadsheet to be finished.
The spreadsheet is the bridge between those things. Every Tuesday someone walks the money across.
Choose Altarflow when the spreadsheet has become the bridge between bank accounts, giving records, receipts, and reports. The trigger is not church size by itself. I have seen a small congregation drown in sources and a larger one stay clean because one person still owned a simple process.
What I watch for is coordination.
Too many sources. The bank, Zelle, Cash App, PayPal, Venmo, cash, checks, a card form, and a pile of receipts no longer fit one Tuesday night.
Month end keeps slipping. The books are late because the person responsible has to reconstruct the month from evidence that never lived in one place.
More people need control. The pastor wants to see the Building fund without asking for a file. A bookkeeper should receive something cleaner than a forwarded export and a promise that the Zelle tab is almost done.
Reports need to stay current. Leadership asks a question on Thursday and the honest answer is "I will know after I finish the sheet."
When those things start stacking, the file is still flexible. The process is not. The church is depending on a spreadsheet to connect systems and people it was never designed to coordinate.
The weekly close as it already happens
I want to walk the close the way churches already do it, not the way software pages describe it.
Sunday afternoon. Two people count the cash. They write $186 in ones, fives, and a few twenties. They stack four checks: $50, $100, $25, $20. Someone notes that the $100 check says Building in the memo and the rest are silent. The cash and checks go in a bag for the night drop.
Monday. The deposit hits. Zelle gifts that members sent during the service are already in the bank, some with names, some with initials. A Cash App notification sits on the treasurer's phone. A PayPal transfer arrived from a member who gives that way because a niece set it up.
Tuesday night. This is the close.
She opens the bank app and copies the deposit into the Giving tab. She types the four checks as four rows, assigns the $100 to Building, and leaves the others in General because that is the house rule when the memo is blank. She opens the Zelle activity and starts the names. M. Rodriguez is probably María. JPerez is probably José. A new sender named A. Chen has no match. She texts the pastor. The gift sits unassigned.
She opens Cash App and types those gifts. She opens PayPal. She opens Venmo if anything landed. Each app is a separate login and a separate chance to miss a transfer that already cleared.
Then expenses. The bank already shows the hardware-store debit and the utility draft. The folder has the hardware-store slip. The utility bill lives in email. A volunteer texted a grocery photo for the Wednesday meal. She parks what she can in the Expenses tab and highlights the rest.
Fund balances are a later pass. She subtracts the Building check from the Building column. She adds María's Zelle to General until the pastor answers. She leaves Missions alone because she is not sure whether last month's special offering was already moved. If the church also keeps QuickBooks, this is the night she types the same story again, or the night she decides it can wait.
By 10:30 the money has been in the bank for two days. The workbook is closer. The pastor will get a text that says "we are around the same as last week," because a precise number would require finishing the highlights. That is the close. Competent work. The same reconstruction every week, from piles that do not talk to each other.
What changes when the piles become one record
Altarflow does not invent a new close. It takes the close you already do and puts the piles in one reviewed record.
Bank activity, Zelle and other giving, cash, checks, expenses, funds, approvals, and reports meet in the same place. The deposit is not a number you retype. The Zelle gift is not a detective story you start from a blank row. The receipt does not wait in a folder until it becomes a tab.
I need to be plain about the AI, because churches have been sold magic before.
The system prepares work. It can pull bank activity, suggest that a Zelle deposit belongs to a known donor and a known fund, attach a receipt to an expense, and propose a category. A trusted person reviews that work and approves it before it hits the books. If the name is ambiguous or the fund is unclear, the gift waits. If the receipt does not match the debit, a person decides.
AI does not become the treasurer. I would not ship a product that pretended otherwise. Preparation without approval is a guess with better lighting. Approval without preparation is the Tuesday night you already have.
What changes is the starting point. The treasurer opens a review queue instead of five apps and a folder. Familiar gifts are ready to confirm. The new sender is marked as needing a person. Cash and checks are entered once, next to the bank deposit they belong to. Expenses arrive with the receipt attached.
Early customers report the same weekly close moving from 8 to 10 hours down to about 30 minutes of review. We have already published that figure in the Zelle post and on the spreadsheet comparison. I will not invent a new one. The shape of the change is the same: less reconstruction, more review.
Across our current customers, we manage about $1.5 million in volume. Seventy percent of that giving arrives through Zelle. That is not a national church statistic. It is the market we actually serve. The other thirty percent still has to be closed: cash, checks, Cash App, PayPal, Venmo. The books have to hold all of it, or the spreadsheet remains the bridge.
The Zelle work is one piece of the close
I already wrote the Zelle matching piece, and I am not going to rewrite it here.
When a Zelle deposit hits the bank, the gift still needs a donor and a fund. That article walks the identification problem: M. Rodriguez, empty memos, three possible families, the difference between recording a gift and matching one. If Zelle is eating your Monday, start there.
This post is about the rest of Tuesday night.
The cash counted after service. The checks in the bag. The Cash App, PayPal, and Venmo transfers that never pass through a giving form. The hardware-store debit. The grocery photo. The report the pastor wants before Thursday prayer.
Zelle matching without the rest of the close still leaves a Tuesday night. The bank is one source. The shoebox is another. The workbook is still the bridge.
A financial operating system for churches is the name we use for the whole picture: donations, expenses, funds, approvals, and reports that stay current because the transactions were reviewed as they arrived. The Zelle work is the loudest piece in our churches. It is not the only piece.
Pastor and treasurer have to trust the same numbers
A close that lives in one person's file produces two financial pictures.
The treasurer has the picture she can defend, full of highlights and the things she has not had time to ask about. The pastor has the picture he was texted, rounded, a day or two behind. When they sit down together, they spend the first fifteen minutes reconciling their versions of the truth.
I do not blame either of them. The treasurer is protecting the church from a number that is not finished. The pastor is trying to lead with the best number he can get. The gap is the system.
Both of them have to trust the same record. The Building fund cannot be one figure in the workbook and another in the pastor's head. The General fund cannot be "we are fine" until the sheet is done and "we are tight" the morning the rent draft hits.
When the piles become one reviewed record, the argument changes. The question is no longer "which file is current." The question is "have we approved what came in and what went out." A board can act on that. Current numbers also change how a church talks about money. We have written about that pattern separately: visibility drives generosity. People cannot respond to a picture they have never seen, or to a picture the treasurer does not fully trust yet. The close is how the picture becomes shareable.
Book a thirty-minute demo
If your Tuesday night still looks like a bank app, three giving inboxes, a folder of receipts, and last year's workbook, I want to see that close with you.
Book a 30-minute demo. Bring the piles. We will map the process you already run and show what the same work looks like as one reviewed record. Altarflow is built in English and Spanish. It is for churches in the United States. Pricing is a tailored monthly or annual plan with guided onboarding. We will give you a custom quote after we understand the workflow, the migration, and the support you actually need.
Keep the spreadsheet if it still fits. Choose the reviewed record when the spreadsheet has become the bridge.
The money is already in the account. The books should be able to catch up the same week.

