Night Auditor

Every hotel runs a night audit, the process of checking that room charges, point-of-sale postings (restaurant, bar, spa, minibar), and guest payments all agree with each other. Done by hand in spreadsheets, it's slow, error-prone, and the kind of small mismatch that slips through, an unposted bar tab, a folio that was never fully paid, a POS charge that never made it to the room, quietly adds up to real lost revenue every single night.

Night Auditor automates the reconciliation. Import your Property Management System exports, POS transactions, and payment records (CSV or Excel, no reformatting required), and it instantly cross-checks every reservation, highlighting reservations where charges don't match payments ("Payment Gap"), POS transactions that were never posted to a guest folio ("Unposted POS"), and clean, reconciled folios, so your team can focus only on what needs attention.

On top of the daily reconciliation, it gives you a library of ready-made revenue and occupancy reports, plus the ability to build and save your own custom reports from any data you import.

FEATURES

• Automatic daily reconciliation that cross-checks room charges, POS postings, and payments for any business date and flags "Payment Gap" and "Unposted POS" issues at a glance
• Import of CSV or Excel files directly from your PMS, POS, or payments system, with Excel converted automatically
• Import into new or existing tables with duplicate protection, choosing unique columns so re-importing the same data skips or updates rows instead of creating duplicates
• Table manager to browse every imported dataset, set column formats (currency, dates, etc.), manage unique keys, or remove a table you no longer need
• Library of ready-made report templates you can configure against your own data in a few clicks
• Custom report builder to write and save your own report from any imported table
• Multiple chart views to display any report as a table, line chart, or pie chart
• One-click CSV export to download the results of any report for further analysis or sharing
• Ability to edit, duplicate, and delete reports and templates, revising them, cloning one as a starting point for a new report, or removing it at any time

Night Auditor is a single self-contained program. There's nothing to install, no dependencies to configure. Run it locally on a Windows, Mac, or Linux machine at the property. Because it runs entirely on your own computer, your guests' financial data never has to leave the building, which matters if you'd rather keep sensitive revenue and payment data off the internet entirely. Or host it in the cloud if you want to access your reports and reconciliation from anywhere, across multiple properties, or from any device.