City Ledger

Outstanding AR (Accounts Receivable) per company — total tagihan yang belum di-bayar oleh corporate clients.

Path menu: Laporan → Pendapatan & Keuangan → City Ledger (/reports/city-ledger)

Konsep

Saat reservasi corporate (Bill-to-Company) checkout, folio status → posted_to_ar (bukan closed). Tagihan masuk City Ledger sebagai outstanding AR per company.

City Ledger = sum semua outstanding posted_to_ar folio per company, plus invoice yang sudah generated tapi belum paid.

Output

Summary

• Total Outstanding AR — sum semua company
• Active Companies with AR — count
• Avg DSO (Days Sales Outstanding) — avg days dari posted_to_ar ke paid
• Overdue Amount — yg lewat payment terms

Tabel per Company

| Company | Outstanding AR | Invoice Count | Oldest Invoice Age | Avg DSO | Status |

Status:

• 🟢 Current — semua dalam payment terms
• 🟡 Approaching — invoice mendekati due date
• 🔴 Overdue — sudah lewat payment terms

Drill-Down Per Company

• List invoices outstanding
• List folios posted_to_ar yang belum invoiced
• Payment history
• Credit limit utilization

Use Case

• AR collection — daily/weekly outreach untuk overdue accounts
• Credit control — block company yang overdue significant (set status Hold di Companies)
• Cash flow planning — outstanding AR = future cash inflow expected
• Aging analysis detail — pakai AR Aging Corporate

Tips

• Daily review untuk hotel dengan banyak corporate
• Credit limit warning — sistem alert kalau AR mendekati limit company
• Reminder otomatis — best practice email reminder otomatis 3 hari sebelum due date
• Pair dengan Company Invoices untuk action invoice & payment recording