Accounts & Financial Master Ledger
Audited Real-time Reconciliations: Front Office • Kitchen Stores • POS Dining
Active Accounting Period:
This Month (November 2026)
Hotel Sagar Sonnet • Main Luxury Wing PMS Audit
Total Inflow Collected
₹ 65,570.50
FO (₹65,571) + POS (₹0)
FO Gross Bill
₹ 191,800.21
10 Booking(s) • Due: ₹109,038
Restaurant POS Sales
₹ 3,934.40
5 Orders • Direct: ₹0
Procurement Cost
₹ 0.00
0 Inward (+0 Plates Yield)
Net Operating Margin
₹ 65,570.50
(Direct Inflow − Store Purchases)
Revenue Breakdown By Department
Income Statement
Room Tariffs & Accommodations:
₹ 190,713.81
Extra Services (Folio Transferred):
+ ₹ 1,086.40
POS Dining Sales (Room • Table • Takeaway):
₹ 3,934.40
POS GST Tax Collected (12%):
₹ 294.40
Total Gross Billings Incurred:
₹ 194,648.21
Less: Kitchen Store Raw Procurement Expense:
- ₹ 0.00
Net Realized Cash Operating Position:
₹ 65,570.50
Consolidated Cash Drawer & Digital Collections
Realized Inflow
Cash In Hand (Front Desk + POS Counter):
₹ 11,269.50
UPI / Digital Payments (GPay • PhonePe • Paytm):
₹ 0.00
Card / EDC POS Swipes:
₹ 0.00
Direct Bank Transfers (NEFT • RTGS • IMPS):
₹ 0.00
Other Payment Modes:
₹ 54,301.00
Total Realized Direct Inflow:
₹ 65,570.50
Outstanding Pending Receivables:
₹ 109,037.71
Room Dining POS Sales
₹ 3,619.40
Direct In-Room orders
Table Dine-in Sales
₹ 315.00
Restaurant tables & deck dining
Walk-in Takeaway Sales
₹ 0.00
Non-resident takeaway patrons
Front Office Guest Bookings & Settlement Ledger
All active room bookings, stay tariffs, extra charges, advance receipts & balances.
| SL | Booking / Folio # | Primary Guest & Mobile | Room | Stay Dates | Room Tariff | Extra Serv. | Total Bill | Paid Amt | Balance Due | Status |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 |
844\2026-2027
Folio: SET-505-941
|
Mr. DAS
9733907990
|
R505 |
06 Nov 2026
07 Nov 2026
|
₹ 1,102.50 |
₹ 1,848.00 (Paid)
1 extra bill(s)
06 Nov: ₹1,848.00 (PAID)
|
₹ 1,102.50
|
₹ 2,950.50 |
₹ 0.00
|
Settled |
| 2 |
843\2026-2027
Folio: SET-102-852
|
Mr. Jaydev Bera
9564900277
|
R102 |
06 Nov 2026
07 Nov 2026
|
₹ 3,920.00 | ₹ 0.00 |
₹ 3,920.00
|
₹ 3,920.00 |
₹ 0.00
|
Settled |
| 3 |
842\2026-2027
Folio: SET-102-746
|
Mr. DAS
9733907990
|
R102 |
12 Nov 2026
14 Nov 2026
|
₹ 3,150.21 | ₹ 0.00 |
₹ 3,150.21
|
₹ 0.00 |
₹ 3,150.21
|
Due |
| 4 |
841\2026-2027
Folio: SET-403-185
|
Mr. Jaydev Bera
9564900277
|
R403 |
07 Nov 2026
07 Nov 2026
|
₹ 2,467.50 |
+ ₹ 10.50
1 extra bill(s)
06 Nov: ₹510.50
|
₹ 2,478.00
(Room + Extra)
|
₹ 0.00 |
₹ 2,478.00
(incl. +₹10.50 extra)
|
Due |
| 5 |
840\2026-2027
Folio: SET-102-305
|
Mr. Jaydev Bera
9564900277
|
R102 |
06 Nov 2026
06 Nov 2026
|
₹ 7,700.00 | ₹ 0.00 |
₹ 7,700.00
|
₹ 7,700.00 |
₹ 0.00
|
Settled |
| 6 |
839\2026-2027
Folio: SET-101-800
|
Mr. Monikanchan Datta
+919064467677
|
R101 |
02 Nov 2026
03 Nov 2026
|
₹ 5,241.60 |
+ ₹ 325.50
2 extra bill(s)
02 Nov: ₹510.50
12 Nov: ₹315.00
Table -1 (window)
|
₹ 5,567.10
(Room + Extra)
|
₹ 0.00 |
₹ 5,567.10
(incl. +₹325.50 extra)
|
Due |
| 7 |
838\2026-2027
Folio: SET-103-649
|
Mr. Jaydev Bera
9564900277
|
R103 |
01 Nov 2026
02 Nov 2026
|
₹ 5,460.00 |
+ ₹ 750.40
1 extra bill(s)
06 Nov: ₹750.40
|
₹ 6,210.40
(Room + Extra)
|
₹ 1,000.00 |
₹ 5,210.40
(incl. +₹750.40 extra)
|
Due |
| 8 |
836\2026-2027
Folio: SET-110-562
|
Mr. Jaydev Bera
9564900277
|
R110 |
30 Oct 2026
01 Nov 2026
|
₹ 19,040.00 | ₹ 0.00 |
₹ 19,040.00
|
₹ 19,040.00 |
₹ 0.00
|
Settled |
| 9 |
835\2026-2027
Folio: SET-105-292
|
Capt. Sudip Chakraborty
+91469003270
|
R105 |
02 Nov 2026
30 Nov 2026
|
₹ 136,416.00 | ₹ 0.00 |
₹ 136,416.00
|
₹ 50,000.00 |
₹ 86,416.00
|
Due |
| 10 |
833\2026-2027
Folio: SET-403-765
|
Mr. Rony Biswas
+919432829897
|
R403 |
01 Nov 2026
02 Nov 2026
|
₹ 6,216.00 | ₹ 0.00 |
₹ 6,216.00
|
₹ 0.00 |
₹ 6,216.00
|
Due |
| Front Office Totals: | ₹ 190,713.81 | +₹ 1,086.40 | ₹ 191,800.21 | ₹ 84,610.50 | ₹ 109,037.71 | |||||
POS Restaurant Dining & Takeaway Sales Ledger
Itemized restaurant orders, food items sold, tax collected, and settlement modes.
| SL | Order # | Order Type | Table / Room | Customer / Guest | Ordered Items | Subtotal | GST (12%) | Total Bill | Billing Mode | Status |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 |
POS-20261112-0001
12 Nov 2026, 08:04 PM
|
Table Dine-in |
Table -1 (window)
R101
|
Monikanchan Datta
|
1x Sagar Lagoon Mocktail, 1x Tea
2 plate(s) served
|
₹ 300.00 | ₹ 15.00 | ₹ 315.00 | Room Folio | In Kitchen |
| 2 |
POS-20261106-0003
06 Nov 2026, 03:01 PM
|
Room Dining |
R505
|
DAS
|
1x Awadhi Dum Biryani (Mutton), 1x Gulab Jamun with Rabri, 1x Sagar Sonnet Breakfast Platter
3 plate(s) served
|
₹ 1,650.00 | ₹ 198.00 | ₹ 1,848.00 | Room Folio | Completed |
| 3 |
POS-20261106-0002
06 Nov 2026, 02:56 PM
|
Room Dining |
R103
|
Jaydev Bera
|
1x Tea, 1x Sagar Lagoon Mocktail, 1x Fresh Lime Soda / Mint Cooler, 1x Cappuccino Royale
4 plate(s) served
|
₹ 670.00 | ₹ 80.40 | ₹ 750.40 | Room Folio | In Kitchen |
| 4 |
POS-20261106-0001
06 Nov 2026, 02:50 PM
|
Room Dining |
R403
|
Jaydev Bera
|
1x Sagar Lagoon Mocktail, 1x Tea, 1x Cappuccino Royale
3 plate(s) served
|
₹ 510.00 | ₹ 0.50 | ₹ 510.50 | Room Folio | In Kitchen |
| 5 |
POS-20261102-0001
02 Nov 2026, 11:08 PM
|
Room Dining |
R101
|
Monikanchan Datta
|
1x Cappuccino Royale, 1x Sagar Lagoon Mocktail, 1x Tea
3 plate(s) served
|
₹ 510.00 | ₹ 0.50 | ₹ 510.50 | Room Folio | In Kitchen |
| POS Sales Totals: | ₹ 3,640.00 | ₹ 294.40 | ₹ 3,934.40 | Direct Cash/UPI: ₹0.00 • Folio: ₹3,934.40 | ||||||
Kitchen Stores & Procurement Expense Ledger
Raw ingredient inward receiving, purchase rates, vendor challans, and kitchen stock deductions.
| SL | Date & Time | Type | Dish / Raw Ingredient | Category | Quantity / Plates | Reference / Invoice # | Unit Rate | Procurement Expense | Issued / Remarks | Performed By |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 12 Nov 2026, 08:04 PM | CONSUMED | Tea | Beverages & Mocktails | −1 | POS-POS-20261112-0001 | - | - | POS Order #POS-20261112-0001: Tea (1 plates served. Remaining: 91 plates) | POS Auto Kitchen Deduction |
| 2 | 12 Nov 2026, 08:04 PM | CONSUMED | Sagar Lagoon Mocktail | Beverages | −1 | POS-POS-20261112-0001 | - | - | POS Order #POS-20261112-0001: Sagar Lagoon Mocktail (1 plates served. Remaining: 43 plates) | POS Auto Kitchen Deduction |
| 3 | 06 Nov 2026, 03:01 PM | CONSUMED | Sagar Sonnet Breakfast Platter | Breakfast | −1 | POS-POS-20261106-0003 | - | - | POS Order #POS-20261106-0003: Sagar Sonnet Breakfast Platter (1 plates served. Remaining: 49 plates) | POS Auto Kitchen Deduction |
| 4 | 06 Nov 2026, 03:01 PM | CONSUMED | Gulab Jamun with Rabri | Desserts | −1 | POS-POS-20261106-0003 | - | - | POS Order #POS-20261106-0003: Gulab Jamun with Rabri (1 plates served. Remaining: 49 plates) | POS Auto Kitchen Deduction |
| 5 | 06 Nov 2026, 03:01 PM | CONSUMED | Awadhi Dum Biryani (Mutton) | Main Course | −1 | POS-POS-20261106-0003 | - | - | POS Order #POS-20261106-0003: Awadhi Dum Biryani (Mutton) (1 plates served. Remaining: 47 plates) | POS Auto Kitchen Deduction |
| 6 | 06 Nov 2026, 02:56 PM | CONSUMED | Cappuccino Royale | Beverages | −1 | POS-POS-20261106-0002 | - | - | POS Order #POS-20261106-0002: Cappuccino Royale (1 plates served. Remaining: 46 plates) | POS Auto Kitchen Deduction |
| 7 | 06 Nov 2026, 02:56 PM | CONSUMED | Fresh Lime Soda / Mint Cooler | Beverages | −1 | POS-POS-20261106-0002 | - | - | POS Order #POS-20261106-0002: Fresh Lime Soda / Mint Cooler (1 plates served. Remaining: 44 plates) | POS Auto Kitchen Deduction |
| 8 | 06 Nov 2026, 02:56 PM | CONSUMED | Sagar Lagoon Mocktail | Beverages | −1 | POS-POS-20261106-0002 | - | - | POS Order #POS-20261106-0002: Sagar Lagoon Mocktail (1 plates served. Remaining: 44 plates) | POS Auto Kitchen Deduction |
| 9 | 06 Nov 2026, 02:56 PM | CONSUMED | Tea | Beverages & Mocktails | −1 | POS-POS-20261106-0002 | - | - | POS Order #POS-20261106-0002: Tea (1 plates served. Remaining: 92 plates) | POS Auto Kitchen Deduction |
| 10 | 06 Nov 2026, 02:50 PM | CONSUMED | Cappuccino Royale | Beverages | −1 | POS-POS-20261106-0001 | - | - | POS Order #POS-20261106-0001: Cappuccino Royale (1 plates served. Remaining: 47 plates) | POS Auto Kitchen Deduction |
| 11 | 06 Nov 2026, 02:50 PM | CONSUMED | Tea | Beverages & Mocktails | −1 | POS-POS-20261106-0001 | - | - | POS Order #POS-20261106-0001: Tea (1 plates served. Remaining: 93 plates) | POS Auto Kitchen Deduction |
| 12 | 06 Nov 2026, 02:50 PM | CONSUMED | Sagar Lagoon Mocktail | Beverages | −1 | POS-POS-20261106-0001 | - | - | POS Order #POS-20261106-0001: Sagar Lagoon Mocktail (1 plates served. Remaining: 45 plates) | POS Auto Kitchen Deduction |
| 13 | 02 Nov 2026, 11:08 PM | CONSUMED | Tea | Beverages & Mocktails | −1 | POS-POS-20261102-0001 | - | - | POS Order #POS-20261102-0001: Tea (1 plates served. Remaining: 94 plates) | POS Auto Kitchen Deduction |
| 14 | 02 Nov 2026, 11:08 PM | CONSUMED | Sagar Lagoon Mocktail | Beverages | −1 | POS-POS-20261102-0001 | - | - | POS Order #POS-20261102-0001: Sagar Lagoon Mocktail (1 plates served. Remaining: 46 plates) | POS Auto Kitchen Deduction |
| 15 | 02 Nov 2026, 11:08 PM | CONSUMED | Cappuccino Royale | Beverages | −1 | POS-POS-20261102-0001 | - | - | POS Order #POS-20261102-0001: Cappuccino Royale (1 plates served. Remaining: 48 plates) | POS Auto Kitchen Deduction |
| Total Store Procurement Purchases: | ₹ 0.00 | Inward Shipments: 0 • Plates Yielded: 0 | ||||||||
Consolidated Financial Transaction Receipts Trail
Chronological audit log of all direct payments received and procurement disbursements.
| SL | Date & Time | Department / Domain | Reference # | Party / Guest / Vendor | Category / Details | Payment Mode | Inflow (+) | Outflow (−) |
|---|---|---|---|---|---|---|---|---|
| 1 | 06 Nov 2026, 03:05 PM | Front Office | 844\2026-2027 | Mr. DAS | Settlement | Cash | ₹ 2,949.50 | - |
| 2 | 06 Nov 2026, 02:59 PM | Front Office | 844\2026-2027 | Mr. DAS | Advance | Cash | ₹ 1.00 | - |
| 3 | 06 Nov 2026, 02:54 PM | Front Office | 843\2026-2027 | Mr. Jaydev Bera | Settlement | Cash | ₹ 3,920.00 | - |
| 4 | 06 Nov 2026, 02:42 PM | Front Office | 840\2026-2027 | Mr. Jaydev Bera | Settlement | Cash | ₹ 4,400.00 | - |
| 5 | 06 Nov 2026, 01:54 PM | Front Office | 840\2026-2027 | Mr. Jaydev Bera | Advance | Cash | ₹ 3,300.00 | - |
| 6 | 01 Nov 2026, 01:00 PM | Front Office | 838\2026-2027 | Mr. Jaydev Bera | Advance | Cash | ₹ 1,000.00 | - |
| 7 | 30 Oct 2026, 01:26 PM | Front Office | 835\2026-2027 | Capt. Sudip Chakraborty | Advance | Cash | ₹ 50,000.00 | - |
| Total Reconciled Cash Flow: | ₹ 65,570.50 | − ₹ 0.00 | ||||||
| NET SURPLUS / CASH POSITION: | ₹ 65,570.50 | |||||||