Did the Money Actually Balance Today? The Daily Financial Close Report for Campgrounds¶
"Every night my closing manager would total the drawer, jot the card machine numbers on a sticky note, and tell me it 'looked about right.' Then my bookkeeper would find a $312 hole in August that nobody could explain. By then the day was three weeks gone and untraceable." Park Owner, Ontario
Here is the question every campground owner, bookkeeper, and closing manager is really asking at the end of the day: did the money we earned actually match the money we collected? For most parks, the honest answer is "probably," and "probably" is where losses hide.
A Daily Financial Close report answers that question with a number instead of a shrug. PitchCamp's new Daily Financial Close puts the revenue you earned for a business date next to the payments you took in, and proves the two sides reconcile down to a Difference of $0.00. When they do not, it tells you, on the same day, while the transactions are still fresh enough to fix.
This post covers what a daily financial close is, the gap it fills that most campground software leaves open, and exactly how PitchCamp closes your day in about two minutes.
What a Daily Financial Close Actually Is¶
A daily financial close is an end-of-day statement that reconciles two numbers most campgrounds never line up against each other: the revenue you earned (site fees, add-ons, utilities, store sales, tax) and the money you actually collected (cash, debit, cards, online payments). The close proves those two totals agree once you account for timing differences like deposits, unpaid balances, and refunds.
In plain terms: it is the difference between "we rang up $4,180 in sites and store items today" and "we have $4,180 in the drawer and the card processor." A daily close proves both statements describe the same day, or shows you precisely where they diverge.
Most campground software can tell you the second number. Almost none can prove it matches the first. That gap is the whole point.
The Gap: What Most Campground Software Gives You (And Where It Stops)¶
Walk into ten campground offices and you will find ten versions of the same nightly ritual: a payment total from the booking system, a batch total from the card terminal, a cash count on a scrap of paper, and a manager's gut feeling that it "balances." The reconciliation, the part that actually proves nothing walked out the door, either happens weeks later in an accountant's office or never happens at all.
Here is where the common tools stop:
| What you need at day's end | Spreadsheet by hand | Typical booking-system payment report | Accounting software (after the fact) | PitchCamp Daily Financial Close |
|---|---|---|---|---|
| Totals the payments you collected | Manual, error-prone | Yes | Yes (once imported) | Yes |
| Totals the revenue you earned, by category | Manual | Sometimes | Yes | Yes |
| Proves earned equals collected to $0.00 | No | No | Only at month-end | Yes, per day |
| Explains why the two sides differ | No | No | No | Yes (balancing bridge) |
| Flags discrepancies the same day | No | No | Weeks later | Yes |
| Breaks Canadian sales tax out by type | Manual | Rarely | Yes | Yes (HST, GST, PST) |
| Lives inside your reservation system | No | Yes | No | Yes |
| Time to produce | 20 to 45 minutes | A few minutes | Not same-day | Seconds |
The pattern is clear. A payment summary answers "how much came in." A daily financial close answers "did everything that should have come in, come in, and can we prove it." Those are different questions, and only the second one protects you from slow leaks.
What the Report Reconciles: Two Columns, One Truth¶
Open the Daily Financial Close and you see a single statement with two money columns, Payment amount and Revenue amount, and three sections that must tie out.
The revenue side shows what you earned, grouped the way a campground actually earns it:
- Camping site charges
- Occupants and vehicles
- Booking and administration fees
- Metered utilities (electric, water), dated on the reading date
- Products and services, split into reservation add-ons and direct camp-store (POS) sales, itemized by product with quantities
- Discounts (shown as reductions)
- Sales tax, broken out by name: HST, GST, PST
- Property tax, where you charge it
The payment side shows what you collected, grouped by how guests paid:
- Cash
- Debit, credit cards (by brand), cheque, e-transfer
- Online and terminal payments
- Wallet top-ups (real money loaded onto a guest's prepaid campground wallet)
- Net of any refunds and voids, dated on the day they happened
The reconciliation block at the bottom is the payoff. It shows your Revenue total, your Payments received, the Balancing adjustments, and a single Difference line. When everything ties out, the Difference reads $0.00 in green. When it does not, it turns red with a plain warning that the period has a real data issue to investigate, not a rounding quirk. That one line is the difference between "the day is closed" and "the day needs a look."
The Balancing Bridge: Why "Earned" and "Collected" Are Never the Same Number¶
Here is the part that trips up every manual reconciliation and the reason so many nights end in "close enough." Earned and collected are almost never equal on any given day, and that is completely normal.
Think about a single Saturday:
- A guest pays a deposit in June for an August stay (money in, revenue not earned yet).
- Another guest settles a balance today for a stay that was rung up last week (revenue earned earlier, cash today).
- A third charges site fees to their account and will pay on checkout (revenue earned, no cash yet).
- Someone loads $100 into their wallet for the camp store (cash in, no sale yet).
- You issue a refund for a cancellation (cash out today against an earlier sale).
Every one of those is a legitimate gap between earned and collected. Traditional reports either ignore these or bury them, which is exactly why the totals never quite match and nobody can say why.
PitchCamp shows the gap on purpose. The Balancing activity section spells out each bridge item in words a person can read:
- Today's unpaid charges
- Payments collected for earlier charges
- Unallocated payments (money received with no matching charge, surfaced, never guessed)
- Wallet funding received
- Refunds and voids added back
Add the balancing bridge to your payments, and it equals your revenue. That is how the Difference lands on $0.00. Instead of hiding the timing gaps, the report proves they are the only reason the two sides differ. If some other, unexplained amount is hiding in there, the Difference stops being zero and you know instantly.
Collected Only or All Charges? You Choose the Basis¶
Not every campground counts revenue the same way, so the report gives you a two-option Amounts toggle in the settings panel: All charges and Collected only. A caption under the toggle spells out what you are looking at: "Include every charge, whether paid or unpaid" for All charges, or "Include only the portion paid by the report cutoff" for Collected only.
| Collected only (default) | All charges | |
|---|---|---|
| Question it answers | How much money actually came in by the report cutoff | How much did we earn today, paid or not |
| Counts unpaid charges entered today | No | Yes |
| Best for | Daily cash reconciliation, matching bank deposits, catching drawer gaps | Revenue recognition, handing your accountant a period figure |
| Who usually wants it | Owners and closing managers | Bookkeepers and accountants |
By default the report runs on Collected only: it counts only money you actually received by the report's cutoff, which is what you want when you are reconciling a drawer against a deposit. Switch to All charges and it recognizes every charge entered today even if it is not paid yet. The report reconciles to $0.00 either way, and your choice is remembered the next time you open the report.
One thing worth knowing before you rely on Collected only for a category-by-category read: the report only tracks a handful of categories at the collected-money level of detail. Metered utilities and the two product lines (reservation add-ons and direct POS sales) keep their own real collected figures because a payment can be explicitly linked to those charges. Occupants and vehicles, booking and administration fees, other charges, discounts, and property tax all read $0.00 under Collected only, and that money is not lost, it is folded into Camping site charges instead, since there is no way to know which charge type an unlinked payment was meant to cover. Sales tax is affected too: under Collected only it shows only the tax on the portion actually paid, so a partially paid charge shows partial tax, while All charges shows the full billed tax regardless of payment. Switch to All charges and every category shows its full breakdown again.
Where the Daily Risk Actually Lives¶
"Daily risk reconciliation" sounds like accountant language, but for a campground it is concrete. Risk is the $312 hole in August that nobody can explain three weeks later. The daily close attacks that risk while the day is still recoverable:
- A non-zero Difference means real money is unaccounted for. You see it tonight, not at tax time.
- Unallocated payments get their own line, so a payment posted without a matching charge cannot silently vanish into a monthly total.
- Uncollected balances show up as today's unpaid charges instead of being mistaken for lost revenue.
- Sales tax by type (HST, GST, PST) is totaled for you, so remittance is a lookup, not a reconstruction. Pair it with the GST, HST, and PST guide for Canadian campgrounds and your CRA filing gets a lot less stressful.
Run the report across a date range and it adds a Daily Reconciliation view: one row per business day with revenue, payments, cash, tax, and the Difference, plus charts for revenue by category and payments by method. At the top, a status roll-up tells you how many days balanced, how many have discrepancies, and how many had no activity, with a single "All clear" or "Needs attention" verdict. That is a full season's financial integrity on one screen, which is the kind of visibility a stack of nightly sticky notes will never give you.
Built to Take Two Minutes, Not Twenty¶
A control nobody uses is worthless, so the whole report is built to be fast:
- It runs automatically when you change the dates. There is no "generate" button to hunt for.
- A Today button and seasonal quick-picks jump you to the period you want, along with Previous Day and Next Day picks that page the current range back or forward by a day at a time.
- A Show calculation details toggle reveals exactly where every number came from, for the nights you want to audit, and stays out of the way the rest of the time.
- Print, Export to PDF, and Export to CSV hand your bookkeeper a clean, reconciled statement, with the reporting basis stamped on it, so month-end is a handoff instead of a reconstruction.
Compared with the nightly ritual it replaces, the difference is stark:
| Closing the day | The old way | With PitchCamp Daily Financial Close |
|---|---|---|
| Gather the numbers | Booking report + terminal batch + cash count on paper | One screen, auto-loaded |
| Reconcile earned vs collected | Rarely done, or done at month-end | Proven to $0.00 instantly |
| Explain a mismatch | Guesswork, weeks later | Balancing bridge, on the spot |
| Hand off to the bookkeeper | Re-key everything | Export PDF or CSV, basis stamped |
| Confidence at lockup | "Looks about right" | "It balances, and here's the proof" |
Frequently Asked Questions About the Daily Financial Close¶
What is a daily financial close for a campground? A daily financial close is an end-of-day report that reconciles the revenue you earned against the money you collected for a business date, and proves the two match. In PitchCamp it shows revenue by category next to payments by method and confirms the totals agree to a Difference of $0.00.
How is this different from a payment summary report? A payment summary tells you how much money came in and how. A daily financial close proves that the money coming in matches the revenue you earned, and explains any gap through timing items like deposits, unpaid balances, wallet top-ups, and refunds. One totals payments; the other reconciles the whole day.
What does "reconcile to zero" mean? It means revenue earned equals payments collected once you account for legitimate timing differences (the balancing bridge). When those are the only reason the two sides differ, the Difference line reads $0.00. Any other number means something is genuinely unaccounted for and needs a look.
Should I use "Collected only" or "All charges"? Use Collected only (the default) for daily cash reconciliation and matching bank deposits, since it counts only money actually received by the report's cutoff. Switch to All charges when your accountant wants revenue recognized as it is earned, paid or not, including today's unpaid charges. The report balances either way, and the Amounts toggle remembers your last choice the next time you open the report.
Can I give this to my accountant or bookkeeper? Yes. You can print the report or export it to PDF and CSV with the same reconciled figures shown on screen, and every copy notes which reporting basis produced it. That turns month-end from a reconstruction into a simple handoff.
Does it handle Canadian sales tax? Yes. The report breaks sales tax out by type, including HST, GST, and PST, so your totals for remittance are ready without manual sorting.
What happens if a day does not balance? The Difference line turns red and warns that the period has a data issue, not a rounding quirk, and that the close should not be treated as final until it is investigated. Across a date range, that day is counted under "days with discrepancies" so it is easy to find and fix.
You cannot protect revenue you cannot see, and you cannot fix a discrepancy you only discover months later. The campground owners who sleep well are not the ones with the biggest parks. They are the ones who can prove, every single night, that the money they earned and the money they collected are the same number.
That proof used to take a bookkeeper and a month. Now it takes about two minutes at lockup.
Book a free demo at pitchcampmanagement.com to see the Daily Financial Close reconcile your day to $0.00. 馃崄
Related reading: - Are You Flying Blind? The Numbers Every Campground Owner Should Be Tracking - GST, HST, and PST for Campgrounds: A Canadian Tax Guide - Prepaid Metering and a Prepaid Camp Store: The Campground Wallet That Replaces the Clipboard
Tags: daily financial close 路 campground reconciliation 路 campground accounting 路 end of day report 路 revenue reconciliation 路 campground bookkeeping 路 PitchCamp 路 campground management software 路 HST GST PST 路 daily cash reconciliation