← Business Guides · Explore this topic
Reconcile completed RV park stay value with posted charges and documented adjustments, then model a cautious collection scenario.
Open the rv park unbilled reservation calculator to use your figures. The example amounts use one currency and are constructed scenarios, not industry benchmarks.
Start with completed stays
A reservation is not automatically an earned charge. Cancelled bookings, future stays and unused holds should not be mixed with completed site-nights. Define a reporting period and count occupied site-nights for stays whose charges should already have been posted.
Use a comparable nightly rate. Mixed seasonal prices, long-stay discounts and different site types can make a single average weak. Split materially different groups into separate calculations when the aggregate rate hides the actual charging rules.
Compare charges with charges, not payments received
Posted charges and cash received describe different stages. A guest deposit can arrive before the stay, while an outstanding balance can remain after correctly posted charges. Compare earned stay value with posted guest-account charges first. Review collection separately.
Keep tax, add-on fees and adjustments on the same basis. Document complimentary stays, valid discounts and approved exclusions. A refund should not be counted both as a reduction in expected charges and a reduction in the posted total unless those entries represent separate effects.
Use the difference as a review queue
Five hundred completed site-nights at 45 create 22,500 in base charges. Add 1,500 of earned extras and subtract 1,000 of documented reductions for 23,000 expected charges. With 21,500 already posted, the difference is 1,500.
If all 1,500 is later confirmed as valid missing charges and 80% is collected, cash would be 1,200. Subtract 200 in review cost for a net scenario of 1,000. Confirmation matters: a mismatched cutoff or mistaken rate can remove the apparent gap completely.
Investigate before contacting guests
Match booking identifiers to site, dates, guest account and charge lines. Check late extensions, manual rate overrides, fee exemptions and entries posted after the reporting cutoff. Resolve legitimate differences before deciding what is collectible.
A negative signed difference deserves review too. It can mean more charges were posted than the estimated earned value, but it can also mean your average rate is incomplete. The calculator displays that signed difference while keeping potential missing charges at zero.
Try your own scenario
Use the calculator, then change the assumption you are least confident about. Keep the reporting period and currency consistent. A currency selector changes formatting; it does not convert exchange rates.
Related reading
Prepared by ProWorkstack. Read our editorial standards and calculation methodology.