XenosHMS
PT Accuransi Teknologi Indonesia
Managed by: —
—
Admin
Admin
—
Dashboard
Loading...
—
VIP In House
—
Guest Complimentary
—
Guest House Use
% Occupancy
0%
loading...
Average Room Rate
Rp 0
per room / night
Total Revenue
Rp 0
Total Bookings
0 Transactions
Booking Sources
ARR vs Occupancy per Night
Recent Guest Ratings
OTA vs Direct Booking — Overall Comparison
Occupancy & Revenue Recap per Night
| Date | Rooms | Occupancy % | Check In | ARR | Rev/Night | Lodging Rev/Night | Room Oth Rev/Night | F&B Rev/Night | Others Rev/Night |
|---|---|---|---|---|---|---|---|---|---|
| Total |
Reservation Report
| Reservation No | Guest Name | Room | Source | Check In | Check Out | Status | Amount (IDR) |
|---|
Estimasi Hari Ini
Belum di-Night Audit
Est. Occupancy
0%
Est. ARR
Rp 0
Est. Total Revenue
Rp 0
Est. Room Revenue
Rp 0
Est. F&B Revenue
Rp 0
Est. Others Revenue
Rp 0
Revenue Detail
| Total |
Tidak ada transaksi untuk kategori ini.
Upload New Period
Download the template first to see the exact columns needed (Guest Name, Room Number, Check In/Out, Rate/Night, etc.).
Cash & Bank
Record cash & bank transactions
| Account Code | Group Code | Cash Bank Account Name | Balance |
|---|
No Cash & Bank accounts configured yet.
Transactions
| Date | Journal | From | To | Description | Amount | Actions |
|---|
No transactions yet.
Account Register
—
| Date | Journal | Description | In | Out | Balance |
|---|
No transactions yet for this account.
Room Status
Click a room to record housekeeping (linen, amenities, status)
Housekeeping Report
Select a report to view details
Worksheet Housekeeping
Room cleaning history for the selected date range
Worksheets
0
Rooms Serviced
0
No rooms configured yet.
Activity Log
| Date | Room | Room Type | Status | Linen & Amenities | Notes | By |
|---|
No housekeeping activity in this range.
Amenity Requests
Guest amenity request history for the selected date range
Total Requests
0
Pending / In Progress
0
| Date | Room | Guest | Amenity | Qty | Status | Notes | Handled By |
|---|
No amenity requests in this range.
No Shift Open
Open a shift with your starting cash before taking F&B orders.
F&B Cashier
Banquet Agenda
POS > Banquet — agenda pemakaian ruang meeting/banquet
Purchase Request
Logistic > Purchase Request
| PR No. | Date | Department | Requested By | Items | Status | Actions |
|---|
Supplier
Logistic > Supplier
| Name | Contact Person | Phone | Status | Actions |
|---|
Items List
Logistic > Items
| Name | Category | Unit | Standard Price | Status | Actions |
|---|
Purchase Order
Logistic > Purchase Order
| PO No. | Date | Supplier | Source PR | Total | Status | Actions |
|---|
Receiving
Logistic > Receiving
| Receipt No. | Date | Type | PO No. / Supplier | Total | Received By | Actions |
|---|
Issuing
Logistic > Issuing
| Issue No. | Date | From Storage | Department | Issued To | Items | Actions |
|---|
Inventory
Logistic > Inventory
| Name | Unit | Category | Standard Price | Current Stock | Status | Actions |
|---|
Logistic Report
Select a report to view details
Stock Movement
Pergerakan stok item pada rentang tanggal terpilih
| Item | Category | Unit | Stock In | Stock Out | Current Stock |
|---|
Tidak ada item.
Purchase Summary
Ringkasan transaksi pembelian pada rentang tanggal terpilih
Purchase Request
0
Purchase Order
0
Receiving
0
Total Nilai PO
Rp 0
| PO No. | Date | Supplier | Total | Status |
|---|
Tidak ada Purchase Order pada periode ini.
Website
Kelola website publik hotel Anda sendiri
Hero (Banner Utama)
Tentang Hotel
Fasilitas Hotel
Tipe kamar, ruang meeting, restoran, dan fasilitas lain — bebas jumlahnya.
Galeri Foto
Kontak
Insight News
Berita seputar perhotelan/destinasi — tampil ke semua Guest Member XenosHMS di tab News.
Booking Engine
Tamu bisa booking & bayar langsung dari website hotel Anda — tanpa komisi pihak ketiga.
Program Affiliate
Affiliate dapat link booking sendiri untuk dipasang di Link in Bio TikTok/Instagram, dan dapat poin tiap booking yang berhasil selesai menginap. Pengaturan poin & aktivasi program dikelola oleh SaaS Admin/Partner Admin.
—
Order Booking Engine
| Order | Tamu | Tipe Kamar | Tanggal | Total | Status | Reservasi |
|---|
Kelola Affiliate
Daftar affiliate & antrean pengajuan redeem poin
Affiliate
| Nama | Email / Social | Link Booking | Poin | Status | Aksi |
|---|
Pengajuan Redeem
| Affiliate | Poin | Rekening Tujuan | Status | Aksi |
|---|
Tambah Affiliate
Undangan set password akan dikirim ke email ini.
F&B Report
Select a report to view details
F&B Sales Report
Sales summary for Food & Beverage orders
Orders
0
Subtotal
Rp 0
Tax + Service
Rp 0
Total Revenue
Rp 0
| Order No | Date | Items | Payment / Status | Subtotal | Tax | Service | Total |
|---|
No F&B orders in this range.
Cashier Report
Sales summary per cashier for the selected date range
Currently grouped by cashier for the selected date range. Once F&B Cashier supports closing by Shift, this report will also be filterable per shift.
| Cashier | Orders | Voided | Cash (Physical) | Non-Cash | Room Charge | Subtotal | Tax | Service | Total |
|---|
No cashier activity in this range.
Shift History
| Shift No | Cashier | Opened | Closed | Opening Cash | Expected | Closing Cash | Variance | Status |
|---|
No shifts in this range.
Guest Notifications — Room Service
Room Service order history for the selected date range
Total Orders
0
Pending / In Progress
0
| Date | Room | Guest | Item | Qty | Status | Notes | Handled By |
|---|
No Room Service orders in this range.
Bank Recon
Upload & analyze bank statements
Select a bank statement from the left list
or upload a new PDF
—
—
Opening Balance
—
Total In
—
Total Out
—
Closing Balance
—
Transaction Detail
0| # | Date | Time | Description | Debit | Credit | Balance | Book Recon |
|---|
Upload Bank Statement
General Journal
| Journal No. | Date | Description | Type | Status | Total Debit | Actions |
|---|
Account Receivable
City Ledger — booking yang belum lunas saat Payment Settlement
| Folio Number | Guest | Room | Check In | Check Out | Payment Type | Settlement Date | Total | Paid | Remaining | Status | Booking Source | No Voucher |
|---|
Pencatatan uang yang sudah masuk ke bank dari OTA sebelum tamu check-in (mis. akhir bulan Traveloka/Agoda/Tiket.com sudah transfer, tapi tamunya baru check-in bulan berikutnya) — Debit Kas/Bank, Credit akun AR Deposit sesuai channel.
| Deposit No. | Date | Booking Source | AR Deposit Account | Bank Account | Amount | Remaining | Journal | Actions |
|---|
Piutang ad-hoc yang bukan dari booking tamu (mis. tagihan listrik ke penyewa lahan parkir) — Debit akun Piutang (AR Others), Credit akun Biaya (mengurangi biaya yang sudah dicatat) atau akun Deferred Income.
| Invoice No. | Date | Billed To | Credit Account | Amount | Paid | Remaining | Status | Actions |
|---|
Booking source segment Corporate / Government / Travel Agent — kalau Credit Facility OFF, opsi payment type City Ledger tidak akan muncul saat Front Desk Payment Settlement untuk reservasi dari booking source ini (tamu harus bayar langsung). Default OFF sampai di-approve di sini.
| Booking Source | Segment | PIC | Contact | Credit Facility |
|---|
Account Payable
AP Trade — utang ke supplier dari Receiving Purchase Order
| Receipt No | PO No | Supplier | Receipt Date | Total | Paid | Remaining | Status | Actions |
|---|
Settlement
Verifikasi transaksi FO & F&B Cashier (cash, kartu, QRIS, transfer bank) sebelum disetor & di-settle ke Bank
0 transaksi dipilih · Total Rp 0
| Date | Source | Reference | Guest | Check In | Check Out | Description | Payment Type | Amount |
|---|
| Batch No. | Deposit Date | Bank Account | Journal No. | Total | Actions |
|---|
Monthly Closing
Kunci transaksi keuangan per bulan & posting P&L ke 290-01-102 (Profit (Loss) Current Year)
| Period | Status | Closed At | Closed By | Actions |
|---|
Close Year
Prasyarat: semua 12 bulan tahun itu sudah di-Close (Monthly Closing) — pindahkan saldo 290-01-102 (Profit (Loss) Current Year) ke akun RE Yearly pilihan
| Year | Status | RE Yearly Account | Closed At | Closed By | Actions |
|---|
Close Year
Pre-Closing Checklist
Akun Ekuitas tujuan (mis. "290-01-201 Profit (Loss) Year 2026") — buat dulu di Chart of Accounts kalau belum ada.
Close Month
Pre-Closing Checklist
Settle to Bank
0 transaksi dipilih
Rp 0
Biaya MDR (0%): Rp 0
Batch Detail
| Date | Source | Reference | Guest | Description | Amount |
|---|
Record AR Payment
Available AR Deposit — same Booking Source
Payment History
AR Payment
Folio Terpilih
Total Piutang Gabungan:
Add AR Deposit
Uang sudah masuk ke bank tapi tamu belum check-in (mis. transfer OTA akhir bulan, tamu check-in bulan berikutnya). Jurnal: Debit Kas/Bank, Credit akun AR Deposit sesuai channel.
Add AR Manual Invoice
Contoh: tagihan listrik atas sewa lahan parkir — piutang listrik ini akan mengurangi biaya listrik yang sudah dicatat (Credit ke akun Biaya Listrik).
AR Manual — Record Payment
Payment History
Record AP Payment
Payment History
Create Journal
| Account | Description | Debit | Credit |
|---|
Generate Income Journal
Automatically from settled booking data
Preview Journal Lines
| Account | Description | Debit | Credit |
|---|
| Account | Description | Debit | Credit |
|---|
Source Bills/Folios
F&B orders & guest folio charges that were summed into this journal.
F&B Orders
| Order No. | Outlet / Table | Guest | Payment | Total |
|---|
Guest Folio Items
| Folio No. | Guest / Room | Description | Debit | Credit |
|---|
Guest Folio
| Date | Description | Debit | Credit |
|---|
Bank Book Reconciliation
—
Book Opening Balance
—
Statement In
—
Statement Out
—
Book Net Change
—
Book Closing Balance
—
Difference
—
Stmt Closing − Book Closing
Bank Statement Transactions
| Date | Description | In (Credit) | Out (Debit) | Status |
|---|
Journal Lines — COA
| Date | Journal No. | Description | Debit | Credit | Status |
|---|
Reports
Select a report to view details
Profit & Loss
Period
Select a month to view the report
| Description | Month to Date | Year to Date | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Actual | % | Budget | % | Variance | Actual | % | Budget | % | Variance | Last Year | % | |
| Select a month to view the report | ||||||||||||
Profit & Loss Multi Period
Period
Select a period to view the report
| Select a period to view the report |
Balance Sheet
As of Date
Select a date to view the balance sheet
Balance Sheet Multi Period
Period
Select a year to view the report
| Select a year to view the report |
Trial Balance
Report Period
Select a month to view the trial balance
| Code | Account Name | Previous Balance | Mutation | Ending Balance | |||
|---|---|---|---|---|---|---|---|
| Debit | Credit | Debit | Credit | Debit | Credit | ||
| Select a month to view the trial balance | |||||||
| TOTAL | — | — | — | — | — | — | |
General Ledger
Mutation Detail
| Date | Journal No. | Description | Debit | Credit | Balance |
|---|
Cash Flow — All Bank
Report Period
Select period range
Opening Balance
—
Total Receipts
—
Total Expenses
—
Closing Balance
—
| Bank | Account No. | Opening Balance | Receipts | Expenses | Closing Balance |
|---|---|---|---|---|---|
| Select a period and click Show | |||||
| COMBINED TOTAL | — | — | — | — | |
AR Aging Report
As of Date
Loading...
Current (0-30)
—
31-60 Days
—
61-90 Days
—
> 90 Days
—
Total Outstanding
—
| No. | Booking Source | Total Outstanding | Current | Over 30 Days | Over 60 Days | Over 90 Days |
|---|---|---|---|---|---|---|
| GRAND TOTAL | — | — | — | — | — | |
No outstanding receivables as of this date.
AP Aging Report
As of Date
Loading...
Current (0-30)
—
31-60 Days
—
61-90 Days
—
> 90 Days
—
Total Outstanding
—
| No. | Supplier | Total Outstanding | Current | Over 30 Days | Over 60 Days | Over 90 Days |
|---|---|---|---|---|---|---|
| GRAND TOTAL | — | — | — | — | — | |
No outstanding payables as of this date.
Macro P&L Report
Downloads your own Excel template (Settings > Macro P&L) with its RawData sheet filled in — one row per posting-level COA account, with Actual MTD, Budget MTD, LY MTD, Actual YTD, Budget YTD and Last YTD for the month below — same numbers as the Profit & Loss report, your template's own formulas/macros do the rest.
Macro BS Report
Downloads your own Excel template (Settings > Macro BS) with its RawData sheet filled in — one row per posting-level COA account (Assets/Liabilities/Equity) with its balance as of the date below, plus Current Period Net Income/Loss — same numbers as the Balance Sheet report, your template's own formulas/macros do the rest.
Supplier
| Reference | PO No. | Receipt Date | Days Overdue | Bucket | Amount |
|---|---|---|---|---|---|
| Total | |||||
Booking Source
| Reference | Debtor | Room | Invoice/Settled Date | Days Overdue | Bucket | Amount |
|---|---|---|---|---|---|---|
| Total | ||||||
P&L Budget
Input budget bulanan per akun Revenue & Expense untuk satu tahun.
| Account | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|
No active Revenue/Expense accounts found — set up Chart of Accounts first (Settings > Chart of Accounts).
Create Budget — Annual Budget
Susun budget tahunan lewat strategi harga kamar, F&B, Others & planning Cost/Expenses.
% Occupancy
—
Rata-rata tahunan
ARR
—
Blended, rata-rata tahunan
RevPAR
—
Rata-rata tahunan
Room Revenue
—
Total setahun
F&B Revenue
—
Total setahun
Others Revenue
—
Total setahun
Total Revenue
—
Total setahun
Budget Revenue vs GOP per Bulan
Budget Room Revenue per Market Segment
Profit & Loss Statement Simulation
| Loading... |
Room Rate Strategy
Isi Published Rate (Rp/malam) & Occupancy % per Room Type untuk satu tahun, lalu atur discount per Market Segment per bulan di bawah — ARR simulasi (blended) & Room Revenue dihitung otomatis per bulan.
1. Published Rate & Occupancy %
| Room Type | Actual Occ % | Occupancy % (Target) | Room Only Weekday |
Room Only Weekend |
Room Breakfast Weekday |
Room Breakfast Weekend |
|---|
Belum ada Room Type — set up dulu di Settings > Room Types.
Proporsi Weekday:Weekend dihitung otomatis dari kalender bulan berjalan. Proporsi Room Only vs Room Breakfast diatur manual disini: % tamu ambil paket Breakfast
Breakfast Allocation — bagian rate Room Breakfast yang sebenarnya milik Breakfast (bukan Lodging), mengurangi simulasi ARR/Room Revenue: Rp per pax
Posting ke Revenue F&B (opsional) — reklasifikasi dari Lodging, Total Revenue tidak berubah:
2. Market Segment Mix (Whole Hotel)
Proporsi Room Sold per Market Segment, berlaku ke semua Room Type & sepanjang tahun — total harus 100%. Diurutkan dari achievement aktual tahun sebelumnya yang paling besar, sebagai pembanding untuk menentukan target.
3. Discount % per Market Segment (per Room Type, per tahun)
Belum ada Room Type / Market Segment aktif.
4. Trend Ratio per Bulan (Whole Hotel)
Proporsi Room Sold tahunan per bulan (total 12 bulan harus 100%) — refleksi kondisi sepi/ramai tiap bulan. Total Room Sold tahunan (dari Occupancy % × Room Available diatas) dibagi ke tiap bulan sesuai proporsi ini, menggantikan penyebaran rata. "Actual" = proporsi Room Sold sungguhan bulan itu tahun sebelumnya, sebagai pembanding.
| Trend Ratio % | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|
Ringkasan
Guest In House = Room Sold × Pax per Room (dipakai juga sebagai Cover base di F&B Revenue). pax per kamar terjual
| Ringkasan (Total Semua Room Type) |
|---|
F&B Revenue
Revenue dihitung dari Guest In House × Cover % × Price per akun — bukan input Rp langsung.
1. Guest In House
Guest In House per bulan = Total Room Sold × Pax per Room — diatur di modal Room Rate Strategy (kartu pertama), ditampilkan disini sebagai referensi untuk Cover di bawah.
| Guest In House per Bulan |
|---|
2. F&B Items
Tiap baris: pilih akun COA Revenue, Cover % dari Guest In House, Price/cover, opsional COGS %.
Belum ada baris F&B — klik "Add F&B Item" untuk mulai.
Others Revenue
Satu baris per FO Article non-room (dari Settings) — Flat (Rp sama tiap bulan) atau Per Room Sold (Rp/room × Room Sold bulan itu).
Belum ada FO Article non-room aktif — set up dulu di Settings > FO Articles.
Expenses
Baris bebas per akun Expense — Flat (Rp sama tiap bulan) atau Per Room Sold (Rp/room × Room Sold bulan itu). Cost of Sales tidak disini lagi, sudah otomatis dari COGS% tiap baris F&B Revenue.
Belum ada baris Expense — klik "Add Expense Item" untuk mulai.
Manning Budgeting
Baris bebas per posisi staf — Headcount × Gaji/bulan, FLAT sepanjang tahun. Departemen ditentukan otomatis dari akun Payroll yang dipilih (bukan input terpisah).
Belum ada posisi — klik "Add Position" untuk mulai.
Below GOP Assumptions
Management Fee/Depreciation/Amortization/Other Expenses = % Total Revenue, Incentive Fee = % GOP. Simulasi saja — tidak diposting ke akun COA manapun.
DSR Budget
Input budget bulanan per Article Front Office & F&B untuk satu tahun.
| Article | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|
No active FO Article found (Settings > FO Articles), dan belum ada baris F&B Revenue di Budgeting > Create Budget.
Settings
Select a settings category
| # | Name | Role | Status | Actions |
|---|
Tampil di tab Home Guest Portal (guest.html) — cuma yang aktif.
Tampil ke tamu yang login sebagai XenosHMS Member (Google Sign-In) saat check-in di hotel ini — cuma yang aktif.
| Name | Category | Unit | Status | Actions |
|---|
| Room Type | Rate Plan | Price / Night | Status | Channel Manager Sync | Actions |
|---|
| Name | Description | Mapped COA Account | Status | Actions |
|---|
| Name | Description | Status | Actions |
|---|
| Name | Status | Actions |
|---|
| Group | Category | Mapped COA Account | Status | Actions |
|---|
| Name | Mapped COA Revenue Account | Room Charge | Tax | Service | Status | Actions |
|---|
| Code | Name | Status | Actions |
|---|
Automatic Fee
Guests may still check in early or check out late — when the actual check-in/check-out time is outside the standard time below, the fee is charged to the Guest Folio automatically (no manual step needed).
Standard Time
Early Check-in Fee
Applied automatically when check-in happens before the standard time above. Set to Rp 0 or leave the FO Article empty to disable.
Late Check-out Fee
Applied automatically when check-out happens after the standard time above. Set to Rp 0 or leave the FO Article empty to disable.
Cancel Check-in Limit
Staff dengan permission "Cancel Check-in" cuma bisa membatalkan check-in tamu dalam rentang waktu ini sejak check-in dilakukan — setelah lewat, harus lewat alur Check-out normal.
Cancel Check-out Limit
Staff dengan permission "Cancel Check-out" cuma bisa membatalkan check-out tamu dalam rentang waktu ini sejak check-out dilakukan (data booking/settlement yang sudah terbentuk ikut dihapus) — setelah lewat, harus dikoreksi manual.
How it works
A guest booking far in advance can pay a deposit when the reservation is created (Add Reservation form) — the cashier picks a payment method just like a normal Guest Bill payment. This is recorded as a liability (credited to the account below), not revenue yet. When the guest checks in, the deposit is automatically applied as a credit on their Guest Folio, offsetting what they owe.
Guest Deposit Account
Credited when a deposit is received at booking time, and debited (relieved) when it's applied to the Guest Folio at check-in. Default: 230-01-101 Guest Deposit.
How it works
A customer booking a meeting/banquet room can pay a deposit when the booking is created (Banquet Agenda > Add Booking) — recorded as a liability (credited to the account below), not revenue yet. On the event day, the cashier can apply (part of or all of) this deposit as payment when closing the F&B Cashier bill for that room — any remaining balance is settled with Cash/Room Charge as usual, in the same Close Bill action.
Banquet Deposit Account
Credited when a banquet deposit is received at booking time, and debited (relieved) when it's applied to an F&B bill on the event day. Separate account from Reservation Deposit — no default, must be set explicitly.
How it works
Book Recon (Bank > upload statement > Book Recon) compares each bank statement's mutations against posted journal entries in the Cash & Bank COA account mapped below, for the same period. Pick the correct account for each bank so the comparison actually finds your journal entries.
BRI
BCA
How it works
When staff record an AR Payment (single or bulk) and toggle "Split ke Biaya Komisi OTA", the commission leg always posts to the ONE account mapped below — staff no longer pick it from a dropdown, so there's no risk of the wrong expense account being used transaction to transaction.
Commission Expense Account
How it works
Map each Booking Source to ONE AR Deposit (liability) account — changes save immediately per row. Add AR Deposit only offers Booking Sources that already have a mapping here, so there's no risk of recording a deposit against a source with nowhere to credit it.
| Booking Source | Market Segment | AR Deposit Account (COA) |
|---|
| Name | Order Mode | Articles | Status | Actions |
|---|
| Table | Outlet | Status | Actions |
|---|
| Name | Outlet | Category | Price | Mapped COA Revenue Account | Tax | Service | Status | Actions |
|---|
Calculation Method
PBJT Perhotelan (Pajak Barang & Jasa Tertentu)
Service Charge
Simulasi jurnal untuk Room Rate Rp 1.000.000
| Code | Account Name | Type | Description | Status | Actions |
|---|
Company Being Audited
This data is used across all reports, occupancy calculations, and print headers. Number of rooms directly affects the occupancy rate calculation.
Company Identity
Used to calculate % occupancy and RevPAR
Ditampilkan di website & halaman Booking Engine
Contact & Location
Guest Membership Directory
Ditampilkan di direktori hotel Guest Portal (Beranda member Google Sign-In) — lihat contoh.
Printed on AR Invoices
Info rekening bank & catatan di bawah ini otomatis dicetak sebagai "Important Notice" di invoice AR (mis. AR Manual).
Bank Account
Additional Notice
Hotel Timezone
Used as the fallback "today" for System Date, Night Audit, journal dates, Folio Transfer, and POS Cashier shifts whenever a date isn't explicitly provided — so these stay correct regardless of the server's own system timezone.
Timezone
Managed by Accuransi
Provider connection (credentials, enable/disable) is set up by your Accuransi or partner admin, not here — contact them to connect or switch provider. Once a connection is active, map every Room Type and Rate Plan to their provider IDs below.
Connection
Not connectedShowing mappings for the active connection:
Room Type Mapping
| Room Type | External Room Type ID |
|---|
Rate Plan Mapping
| Room Type | Rate Plan | External Rate Plan ID | Status |
|---|
Hotel Business Date
System Date is used as the reference date for transactions (reservations, room plan, housekeeping, cash & bank, AR payment). Running Night Audit automatically advances it by one day.
Current System Date
—
Actions
You don't have permission to change the System Date.
Select a period from the list on the left
Sales Report
Macro DSR Template
Upload your own Excel workbook (.xlsx or .xlsm, macros/VBA are preserved). The Macro Report Daily Sales Report card on Front Desk Report fills its RawData sheet with real Today/MTD/YTD Actual & Budget numbers for the date you pick — your own formulas, layout, and macros do the rest. No template yet? Download the starter file above — its RawData sheet is already filled with today's real numbers (including this company's own Detail rows) so you can build formulas against real cells, then upload it back below.
—
—
RawData Sheet Layout
Build your report/macro on a sheet named exactly RawData. It will always be (re)written with this layout — reference these cells from your own sheets.
| Row | A: Item | B: Today Actual | C: Today Budget | D: MTD Actual | E: MTD Budget | F: Last MTD | G: YTD Actual | H: YTD Budget | I: Last YTD |
|---|
Rows 1–4 (above the header row) carry Report Date, MTD From, YTD From and Generated At in column B. Budget cells with no data source yet (Others Revenue, Service, Tax, Gross, Payment, GAB rows) are written as 0. Last MTD/Last YTD are this same Actual figure for the same month/date range one year earlier (Feb 29 falls back to Feb 28 in a non-leap prior year) — always Actual only, no budget concept for last year.
Below row 22, three Detail sections are appended (Room Revenue by FO Article, F&B Revenue by Category × Outlet, Payment by Payment Type), each with its own header row. Their row counts depend on how many articles/outlets/payment types your company has, so they can shift between runs — reference them by matching the Item label (e.g. a lookup formula) rather than a fixed cell address.
You can hide RawData (and any other helper sheet) before uploading — hidden/very-hidden state is preserved on every generated download. RawData itself is also automatically Excel-protected (locked, no password) on every generated file, so nobody can accidentally edit the raw numbers — column/row/cell FORMATTING (e.g. resizing columns) is still allowed, only editing the actual values is blocked. Note: this protection is applied fresh by the app each time — if you also protect your own report/formula sheets in Excel, that protection unfortunately does NOT survive the regenerate (a limitation of the Excel library used here, which can write protection but not read an existing one back).
Macro P&L Template
Upload your own Excel workbook (.xlsx or .xlsm, macros/VBA are preserved). The Macro P&L Report card on Reports fills its RawData sheet with real detail-COA MTD/YTD Actual, Budget & Last Year numbers for the month you pick — your own formulas, layout, and macros do the rest. No template yet? Download the starter file above — its RawData sheet is already filled with this month's real numbers (one row per posting-level COA account) so you can build formulas against real cells, then upload it back below.
—
—
RawData Sheet Layout
Build your report/macro on a sheet named exactly RawData. It will always be (re)written with this layout — reference these cells from your own sheets.
| Row | A: COA Code | B: COA Description | C: Actual MTD | D: Budget MTD | E: LY MTD | F: Actual YTD | G: Budget YTD | H: Last YTD |
|---|---|---|---|---|---|---|---|---|
| 1–5 | Report Month / MTD From / MTD To / YTD From / Generated At (value in column B) | |||||||
| 7 | "Room Statistics" section title | |||||||
| 8 | Header row (as shown above) | |||||||
| 9–13 | (blank) | Room Available, Room Sold, Occupancy %, ARR, RevPAR — same definitions as Daily Sales Report, fixed row position (always rows 9-13) | Actual MTD | Budget MTD | LY MTD | Actual YTD | Budget YTD | Last YTD |
| 15 | "Detail COA" section title | |||||||
| 16 | Header row (as shown above) | |||||||
| 17… | e.g. 300-01-101 | Account name — one row per POSTING-level COA account (Revenue/COGS/Expense/Other Expense), ordered by account code | Actual MTD | Budget MTD | LY MTD | Actual YTD | Budget YTD | Last YTD |
Room Statistics (rows 9-13) sit at a FIXED row position — safe to reference by exact cell address (e.g. RawData!C9 for Room Available Actual MTD). "Detail COA" means posting-level (leaf) accounts only — header/group accounts used purely to organize the Chart of Accounts are excluded, same rule the regular P&L report itself uses. Revenue rows use credit − debit; COGS/Expense/Other Expense rows use debit − credit (same sign convention as the P&L report, so numbers match). LY MTD is this month's Actual figure one year earlier (same calendar month); Last YTD is Jan 1 through the same month-end, one year earlier. Detail COA row count varies by company (depends on how many posting accounts you have) and can shift between runs — reference those rows by matching the COA Code rather than a fixed cell address.
You can hide RawData (and any other helper sheet) before uploading — hidden/very-hidden state is preserved on every generated download. RawData itself is also automatically Excel-protected (locked, no password) on every generated file — column/row/cell FORMATTING (e.g. resizing columns) is still allowed, only editing the actual values is blocked. Note: this protection is applied fresh by the app each time — if you also protect your own report/formula sheets in Excel, that protection unfortunately does NOT survive the regenerate (same Excel-library limitation as Macro DSR).
Macro BS Template
Upload your own Excel workbook (.xlsx or .xlsm, macros/VBA are preserved). The Macro BS Report card on Reports fills its RawData sheet with real detail-COA Balance Sheet numbers (Assets/Liabilities/Equity) as of the date you pick — your own formulas, layout, and macros do the rest. No template yet? Download the starter file above — its RawData sheet is already filled with today's real numbers (one row per posting-level COA account) so you can build formulas against real cells, then upload it back below.
—
—
RawData Sheet Layout
Build your report/macro on a sheet named exactly RawData. It will always be (re)written with this layout — reference these cells from your own sheets.
| Row | A: COA Code | B: COA Description | C: Type | D: Parent Code | E: Parent Name | F: Balance |
|---|---|---|---|---|---|---|
| 1–2 | Report Date / Generated At (value in column B) | |||||
| 4 | "Summary" section title | |||||
| 5 | (blank) | Total Assets | Amount | |||
| 6 | (blank) | Total Liabilities | Amount | |||
| 7 | (blank) | Total Equity (excl. Net Income) | Amount | |||
| 8 | (blank) | Current Period Net Income / Loss | Amount | |||
| 9 | (blank) | Total Equity (accounts + Net Income) | Amount | |||
| 10 | (blank) | Total Liabilities & Equity | Amount | |||
| 12 | "Detail COA" section title | |||||
| 13 | Header row (as shown above) | |||||
| 14… | e.g. 100-01-101 | Account name — one row per POSTING-level COA account (Assets/Liabilities/Equity), ordered by account code | aset / kewajiban / ekuitas | Parent's code | Parent's name | Balance as of report date |
| last | (blank) | "Current Period Net Income / Loss" — synthetic row (not a real COA account) appended after the Detail COA list, so SUM(Balance) grouped by Type='ekuitas' matches the report's Total Equity | ekuitas | Amount | ||
Summary (rows 1-10) sit at a FIXED row position — safe to reference by exact cell address (e.g. RawData!C5 for Total Assets). "Detail COA" means posting-level (leaf) accounts only — header/group accounts used purely to organize the Chart of Accounts are excluded, same rule the regular Balance Sheet report itself uses. Balance uses debit − credit for Assets, credit − debit for Liabilities/Equity (same sign convention as the Balance Sheet report, so numbers match). Detail COA row count varies by company (depends on how many posting accounts you have) and can shift between runs — reference those rows by matching the COA Code rather than a fixed cell address.
You can hide RawData (and any other helper sheet) before uploading — hidden/very-hidden state is preserved on every generated download. RawData itself is also automatically Excel-protected (locked, no password) on every generated file — column/row/cell FORMATTING (e.g. resizing columns) is still allowed, only editing the actual values is blocked. Note: this protection is applied fresh by the app each time — if you also protect your own report/formula sheets in Excel, that protection unfortunately does NOT survive the regenerate (same Excel-library limitation as Macro DSR/Macro P&L).
Reservation
Front Desk > Reservation
| Reservation No. | Guest | Room | Package | Pax | Check-in | Check-out | Source | Total | Status | Actions |
|---|
FO Cashier
Front Desk > FO Cashier — Guest Folio tamu In House
| Room | Guest | Room Type | Check-in | Check-out | Balance | Guest Folio |
|---|
Room Plan
Front Desk > Room Plan
Guest
Front Desk > Guest
| # | Name | Phone | Identity No. | Nationality | No Member | Actions |
|---|
Booking Source
Front Desk > Booking Source
| Source Name | Segment | PIC | Phone | Address | Actions |
|---|
Night Audit
Front Desk > Night Audit — closing date —
Guest Account Balance List
— pastikan mutasi Debit/Credit setiap folio sudah sesuai sebelum Run Night Audit| Guest / Room / Folio | Description | Prev Balance | Debit | Credit | Balance | Arrival | Departure |
|---|
No folio mutations to review for this date.
Summary of Transaction
| Description | Prev Balance | Debit | Credit | Balance |
|---|---|---|---|---|
| Total | Rp 0 | Rp 0 | Rp 0 | Rp 0 |
| Outstanding | Rp 0 | |||
| Room | HK Status | Guest | Reservation Status | Check-in | Check-out | Today | Folio Total |
|---|
No rooms configured yet.
Front Desk Report
Select a report to view details
Guest Account Balance Report
Debit/Credit movement of each folio for the selected date (posted via Night Audit)
| Guest / Room / Folio | Description | Prev Balance | Debit | Credit | Balance | Arrival | Departure |
|---|
No folio mutations to review for this date.
Summary of Transaction
| Description | Prev Balance | Debit | Credit | Balance |
|---|---|---|---|---|
| Total | Rp 0 | Rp 0 | Rp 0 | Rp 0 |
| Outstanding | Rp 0 | |||
Guest In House History Report
Select a date to view the report
| No. | Room | Guest | Room Type | Package | Check-in | Check-out | Nights | Booking Source |
|---|
No guests in house for this date.
Reservation Report
Select a date range to view the report
| No. | Reservation No. | Guest | Room | Room Type | Package | Pax | Check-in | Check-out | Booking Source | Status | Total |
|---|
No reservations for this date range.
Repeater Guest Report
Select a date range to view the report
| No. | Guest | Phone / Email | Reservation No. | Room | Room Type | Check-in | Check-out | Status | Prev. Stays | Last Stay Checkout |
|---|
No repeater guests for this date range.
Room Production by Segment Market
Select a date range to view the report
| Market Segment | Room Nights | Room Revenue | % of Revenue | ARR |
|---|---|---|---|---|
| Grand Total | 0 | Rp 0 | 100.0% | Rp 0 |
No room revenue for this date range.
Room Usage Report
Select a date range to view the report
| Room Number | Room Type | Nights Available | Nights Occupied | Occupancy % |
|---|---|---|---|---|
| Grand Total (0 rooms) | 0 | 0 | 0.0% |
No room numbers configured yet.
Room Usage Report by Room Rate
Select a date range to view the report
| Room Type | Rate Plan | Package | Setting Price | Actual Avg Price | Nights Sold | Variance (Rp) | Variance (%) |
|---|---|---|---|---|---|---|---|
| Grand Total | Rp 0 | Rp 0 | 0 | Rp 0 | 0.0% | ||
No room rates configured yet.
Monthly Room Forecast
Select a month to view the forecast
| Date | Day | Arrival | Departure | Total | Saleable Room | Room Available | Room Maintenance | % | Revenue | ARR | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Room | Pax | Room | Pax | Rooms Sold | Pax | ||||||||
| Select a month to view the forecast | |||||||||||||
Macro Report Daily Sales Report
Downloads your own Excel template (Settings > Macro DSR) with its RawData sheet filled in from Today/MTD/YTD Actual & Budget for the date below — same numbers as Daily Sales Report, your template's own formulas/macros do the rest.
Daily Sales Report
Select a date to view the report
| Description | Today | Month to Date | Year to Date | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Actual | Budget | Var (Rp) | Var (%) | Actual | Budget | Var (Rp) | Var (%) | Actual | Budget | Var (Rp) | Var (%) | |
| Select a date to view the report | ||||||||||||
Night Audit Pre-Flight Checklist
Review & print these documents before closing —
1. All Transactions — cross-check with FO & F&B Cashier reports
FO Cashier — 0 transactions
| Room | Guest | Description | Debit | Credit |
|---|
No FO Cashier transactions for this date.
F&B Cashier — 0 orders
| Order No | Room / Guest | Payment | Total |
|---|
No F&B Cashier orders for this date.
2. Journal Income Estimate — Room Charge
| Account | Debit | Credit |
|---|---|---|
| Total (0 reservations) | Rp 0 | Rp 0 |
3. FO & F&B Cashier — Estimated Summary Journal
| Account | Debit | Credit |
|---|---|---|
| Total (0) | Rp 0 | Rp 0 |
4. Guest In House List — 0 RO · 0 RB
| Room | Guest | Package | Check-in | Check-out |
|---|
No guests in house for this date.
Night Audit Gagal — Jurnal Tidak Balance
System Date belum maju — Night Audit dibatalkan seluruhnya (di-rollback), aman dicoba lagi setelah transaksi folio yang jadi penyebabnya dikoreksi.
Breakdown Jurnal Ringkasan FO & F&B Cashier
| Account | Debit | Credit |
|---|---|---|
| Total |
Add Account
Leave blank if this is a top-level parent account.
Tandai jika akun ini adalah kas/rekening bank yang muncul di menu Cash & Bank.
Akun kontrol untuk Guest Account Balance List — hanya satu akun boleh ditandai. Semua posting Guest Folio (Room Charge, Payment, dst) menjurnal terhadap akun ini.
Tandai kalau akun ini dipakai mencatat biaya MDR — dropdown "Akun Biaya MDR" di Settle to Bank cuma nampilin akun yang ditandai ini.
Tandai kalau akun ini dipakai mencatat selisih kas Settlement Cash FO/F&B (bisa kurang atau lebih) — dropdown "Akun Cash Short/Over" di Settle to Bank cuma nampilin akun yang ditandai ini.
Transfer Money
Receive Money
Pay Money
Room —
—
Linen — In (clean) / Out (dirty)
No linen types configured yet.
Room Amenities Added
No amenity types configured yet.
Recent Activity