Accounts & Financial Master Ledger
Audited Real-time Reconciliations: Front Office • Kitchen Stores • POS Dining
Active Accounting Period:
All Time History
Hotel Sagar Sonnet • Main Luxury Wing PMS Audit
Total Inflow Collected
₹ 108,578.90
FO (₹105,869) + POS (₹2,710)
FO Gross Bill
₹ 224,619.81
18 Booking(s) • Due: ₹121,537
Restaurant POS Sales
₹ 7,798.40
11 Orders • Direct: ₹2,710
Procurement Cost
₹ 0.00
24 Inward (+1402 Plates Yield)
Net Operating Margin
₹ 108,578.90
(Direct Inflow − Store Purchases)
Revenue Breakdown By Department
Income Statement
Room Tariffs & Accommodations:
₹ 222,477.81
Extra Services (Folio Transferred):
+ ₹ 2,142.00
POS Dining Sales (Room • Table • Takeaway):
₹ 7,798.40
POS GST Tax Collected (12%):
₹ 708.40
Total Gross Billings Incurred:
₹ 230,276.21
Less: Kitchen Store Raw Procurement Expense:
- ₹ 0.00
Net Realized Cash Operating Position:
₹ 108,578.90
Consolidated Cash Drawer & Digital Collections
Realized Inflow
Cash In Hand (Front Desk + POS Counter):
₹ 42,539.90
UPI / Digital Payments (GPay • PhonePe • Paytm):
₹ 2,000.00
Card / EDC POS Swipes:
₹ 0.00
Direct Bank Transfers (NEFT • RTGS • IMPS):
₹ 0.00
Other Payment Modes:
₹ 64,039.00
Total Realized Direct Inflow:
₹ 108,578.90
Outstanding Pending Receivables:
₹ 121,537.31
Room Dining POS Sales
₹ 4,045.00
Direct In-Room orders
Table Dine-in Sales
₹ 1,043.00
Restaurant tables & deck dining
Walk-in Takeaway Sales
₹ 2,710.40
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 |
837\2026-2027
Folio: SET-201-777
|
Mr. Jaydev Bera
9564900277
|
R201 |
30 Oct 2026
31 Oct 2026
|
₹ 9,520.00 | ₹ 0.00 |
₹ 9,520.00
|
₹ 9,520.00 |
₹ 0.00
|
Settled |
| 9 |
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 |
| 10 |
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 |
| 11 |
834\2026-2027
Folio: SET-404-224
|
Capt. Sudip Chakraborty
+91469003270
|
R404 |
30 Oct 2026
30 Oct 2026
|
₹ 0.00 | ₹ 0.00 |
₹ 0.00
|
₹ 0.00 |
₹ 0.00
|
Settled |
| 12 |
834\2026-2027
Folio: SET-404-764
|
Capt. Sudip Chakraborty
+91469003270
|
R404 |
30 Oct 2026
30 Oct 2026
|
₹ 4,160.00 | ₹ 0.00 |
₹ 4,160.00
|
₹ 2,000.00 |
₹ 2,160.00
|
Due |
| 13 |
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 |
| 14 |
832\2026-2027
Folio: SET-103-466
|
Mr. Rony Biswas
+919432829897
|
R103 |
30 Oct 2026
31 Oct 2026
|
₹ 0.00 | ₹ 0.00 |
₹ 0.00
|
₹ 0.00 |
₹ 0.00
|
Settled |
| 15 |
832\2026-2027
Folio: SET-103-512
|
Capt. Sudip Chakraborty
+91469003270
|
R103 |
30 Oct 2026
31 Oct 2026
|
₹ 5,460.00 | ₹ 0.00 |
₹ 5,460.00
|
₹ 2,000.00 |
₹ 3,460.00
|
Due |
| 16 |
831\2026-2027
Folio: SET-102-720
|
Mr. Soma MItra
+916289191294
|
R102 |
30 Oct 2026
30 Oct 2026
|
₹ 0.00 |
₹ 210.00 (Paid)
1 extra bill(s)
30 Oct: ₹210.00 (PAID)
|
₹ 0.00
|
₹ 0.00 |
₹ 0.00
|
Settled |
| 17 |
831\2026-2027
Folio: SET-102-339
|
Mr. Aman Islam
9832516559
|
R102 |
30 Oct 2026
30 Oct 2026
|
₹ 6,800.00 |
₹ 938.00 (Paid)
2 extra bill(s)
30 Oct: ₹728.00 (PAID)
Table -1 (window)
30 Oct: ₹210.00 (PAID)
|
₹ 6,800.00
|
₹ 7,738.00 |
₹ 0.00
|
Settled |
| 18 |
830\2026-2027
Folio: SET-101-452
|
Mr. supriyo
9838983888
|
R101 |
30 Oct 2026
31 Oct 2026
|
₹ 5,824.00 |
+ ₹ 1,055.60
₹ 367.50 (Paid)
4 extra bill(s)
30 Oct: ₹630.00
30 Oct: ₹367.50 (PAID)
30 Oct: ₹358.40
30 Oct: ₹67.20
|
₹ 6,879.60
(Room + Extra)
|
₹ 0.00 |
₹ 6,879.60
(incl. +₹1,055.60 extra)
|
Due |
| Front Office Totals: | ₹ 222,477.81 | +₹ 2,142.00 | ₹ 224,619.81 | ₹ 105,868.50 | ₹ 121,537.31 | |||||
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 |
| 6 |
POS-20261030-0007
30 Oct 2026, 02:06 PM
|
Takeaway |
Table 2 (Lawn View)
|
dd
|
1x Tea, 1x Fresh Lime Soda / Mint Cooler, 1x Awadhi Dum Biryani (Mutton)
3 plate(s) served
|
₹ 930.00 | ₹ 111.60 | ₹ 1,041.60 | Cash Paid | In Kitchen |
| 7 |
POS-20261030-0006
30 Oct 2026, 02:06 PM
|
Takeaway |
Table 2 (Lawn View)
|
dd
|
1x Tea, 1x Fresh Lime Soda / Mint Cooler, 1x Awadhi Dum Biryani (Mutton)
3 plate(s) served
|
₹ 930.00 | ₹ 111.60 | ₹ 1,041.60 | Cash Paid | In Kitchen |
| 8 |
POS-20261030-0005
30 Oct 2026, 01:48 PM
|
Takeaway |
Table -2 (Middle)
|
Sudip
8910385221
|
2x Sagar Lagoon Mocktail
2 plate(s) served
|
₹ 560.00 | ₹ 67.20 | ₹ 627.20 | Cash Paid | In Kitchen |
| 9 |
POS-20261030-0004
30 Oct 2026, 01:43 PM
|
Room Dining |
R101
|
supriyo
|
3x Tea
3 plate(s) served
|
₹ 60.00 | ₹ 7.20 | ₹ 67.20 | Room Folio | Received |
| 10 |
POS-20261030-0002
30 Oct 2026, 01:33 PM
|
Room Dining |
R101
|
supriyo
|
2x Fresh Lime Soda / Mint Cooler
2 plate(s) served
|
₹ 320.00 | ₹ 38.40 | ₹ 358.40 | Room Folio | Completed |
| 11 |
POS-20261030-0001
30 Oct 2026, 10:06 AM
|
Table Dine-in |
Table -1 (window)
R102
|
Aman Islam
|
1x Fresh Lime Soda / Mint Cooler, 1x Sagar Lagoon Mocktail, 1x Cappuccino Royale
3 plate(s) served
|
₹ 650.00 | ₹ 78.00 | ₹ 728.00 | Room Folio | Completed |
| POS Sales Totals: | ₹ 7,090.00 | ₹ 708.40 | ₹ 7,798.40 | Direct Cash/UPI: ₹2,710.40 • Folio: ₹5,088.00 | ||||||
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 |
| 16 | 30 Oct 2026, 08:30 PM | INWARD | Chicken Butter Masla | Indian Item | +10 | INWARD-20261030-203014 | - | - | Inward Received: +0 Pcs chicken (+10 Plates added). | Chef / F&B Store Keeper |
| 17 | 30 Oct 2026, 02:06 PM | CONSUMED | Awadhi Dum Biryani (Mutton) | Main Course | −1 | POS-POS-20261030-0007 | - | - | POS Order #POS-20261030-0007: Awadhi Dum Biryani (Mutton) (1 plates served. Remaining: 48 plates) | POS Auto Kitchen Deduction |
| 18 | 30 Oct 2026, 02:06 PM | CONSUMED | Fresh Lime Soda / Mint Cooler | Beverages | −1 | POS-POS-20261030-0007 | - | - | POS Order #POS-20261030-0007: Fresh Lime Soda / Mint Cooler (1 plates served. Remaining: 45 plates) | POS Auto Kitchen Deduction |
| 19 | 30 Oct 2026, 02:06 PM | CONSUMED | Tea | Beverages & Mocktails | −1 | POS-POS-20261030-0007 | - | - | POS Order #POS-20261030-0007: Tea (1 plates served. Remaining: 95 plates) | POS Auto Kitchen Deduction |
| 20 | 30 Oct 2026, 02:06 PM | CONSUMED | Awadhi Dum Biryani (Mutton) | Main Course | −1 | POS-POS-20261030-0006 | - | - | POS Order #POS-20261030-0006: Awadhi Dum Biryani (Mutton) (1 plates served. Remaining: 49 plates) | POS Auto Kitchen Deduction |
| 21 | 30 Oct 2026, 02:06 PM | CONSUMED | Fresh Lime Soda / Mint Cooler | Beverages | −1 | POS-POS-20261030-0006 | - | - | POS Order #POS-20261030-0006: Fresh Lime Soda / Mint Cooler (1 plates served. Remaining: 46 plates) | POS Auto Kitchen Deduction |
| 22 | 30 Oct 2026, 02:06 PM | CONSUMED | Tea | Beverages & Mocktails | −1 | POS-POS-20261030-0006 | - | - | POS Order #POS-20261030-0006: Tea (1 plates served. Remaining: 96 plates) | POS Auto Kitchen Deduction |
| 23 | 30 Oct 2026, 01:48 PM | CONSUMED | Sagar Lagoon Mocktail | Beverages | −2 | POS-POS-20261030-0005 | - | - | POS Order #POS-20261030-0005: Sagar Lagoon Mocktail (2 plates served. Remaining: 47 plates) | POS Auto Kitchen Deduction |
| 24 | 30 Oct 2026, 01:43 PM | CONSUMED | Tea | Beverages & Mocktails | −3 | POS-POS-20261030-0004 | - | - | POS Order #POS-20261030-0004: Tea (3 plates served. Remaining: 97 plates) | POS Auto Kitchen Deduction |
| 25 | 30 Oct 2026, 01:40 PM | INWARD | Tea | Beverages & Mocktails | +100 | INIT-ITEM-16 | - | - | Opening kitchen stock: 1 Kg tea (10 gm/plate) = 100 Plates ready for POS sales | Chef / F&B Store Keeper |
| 26 | 30 Oct 2026, 01:35 PM | CONSUMED | Paneer Lababdar with Lachha Paratha | Main Course | −1 | POS-POS-20261030-0003 | - | - | POS Order #POS-20261030-0003: Paneer Lababdar with Lachha Paratha (1 plates served. Remaining: 49 plates) | POS Auto Kitchen Deduction |
| 27 | 30 Oct 2026, 01:33 PM | CONSUMED | Fresh Lime Soda / Mint Cooler | Beverages | −2 | POS-POS-20261030-0002 | - | - | POS Order #POS-20261030-0002: Fresh Lime Soda / Mint Cooler (2 plates served. Remaining: 47 plates) | POS Auto Kitchen Deduction |
| 28 | 30 Oct 2026, 10:06 AM | CONSUMED | Cappuccino Royale | Beverages | −1 | POS-POS-20261030-0001 | - | - | POS Order #POS-20261030-0001: Cappuccino Royale (1 plates served. Remaining: 49 plates) | POS Auto Kitchen Deduction |
| 29 | 30 Oct 2026, 10:06 AM | CONSUMED | Sagar Lagoon Mocktail | Beverages | −1 | POS-POS-20261030-0001 | - | - | POS Order #POS-20261030-0001: Sagar Lagoon Mocktail (1 plates served. Remaining: 49 plates) | POS Auto Kitchen Deduction |
| 30 | 30 Oct 2026, 10:06 AM | CONSUMED | Fresh Lime Soda / Mint Cooler | Beverages | −1 | POS-POS-20261030-0001 | - | - | POS Order #POS-20261030-0001: Fresh Lime Soda / Mint Cooler (1 plates served. Remaining: 49 plates) | POS Auto Kitchen Deduction |
| 31 | 30 Oct 2026, 07:11 AM | INWARD | Refined Sunflower Oil & Desi Cow Ghee | {"id":22,"name":"Spices, Oils & Dry Pantry","code":"SPICE","description":"Tandoori masalas, cooking oil, mustard oil, saffron, whole spices and dry provisions","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +40 | INWARD-KIT-14 | - | - | Inward fresh kitchen stock received (Yield: 15 plates/Liters = 600 Plates) | Chef / F&B Store Keeper |
| 32 | 30 Oct 2026, 07:11 AM | INWARD | Royal Saffron Kulfi Bricks (Rabri Base) | {"id":23,"name":"Desserts & Sweet Provisions","code":"DESSERT","description":"Khoya\/mawa, kulfi bricks, falooda sev, rose water, cardamom and dessert mixes","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +16 | INWARD-KIT-13 | - | - | Inward fresh kitchen stock received (Yield: 5 plates/Pcs = 80 Plates) | Chef / F&B Store Keeper |
| 33 | 30 Oct 2026, 07:11 AM | INWARD | Pure Khoya / Mawa (Gulab Jamun Prep) | {"id":23,"name":"Desserts & Sweet Provisions","code":"DESSERT","description":"Khoya\/mawa, kulfi bricks, falooda sev, rose water, cardamom and dessert mixes","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +12 | INWARD-KIT-12 | - | - | Inward fresh kitchen stock received (Yield: 8 plates/Kg = 96 Plates) | Chef / F&B Store Keeper |
| 34 | 30 Oct 2026, 07:11 AM | INWARD | San Pellegrino Sparkling Mineral Water (330ml) | {"id":21,"name":"Beverages, Mocktails & Bar","code":"BEV","description":"Mocktail syrups, Arabica coffee beans, mineral water, imported sparkling waters, tea","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +96 | INWARD-KIT-11 | - | - | Inward fresh kitchen stock received (Yield: 1 plates/Bottles = 96 Plates) | Chef / F&B Store Keeper |
| 35 | 30 Oct 2026, 07:11 AM | INWARD | Sagar Lagoon Blue Curacao Mocktail Syrup | {"id":21,"name":"Beverages, Mocktails & Bar","code":"BEV","description":"Mocktail syrups, Arabica coffee beans, mineral water, imported sparkling waters, tea","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +6 | INWARD-KIT-10 | - | - | Inward fresh kitchen stock received (Yield: 25 plates/Bottles = 150 Plates) | Chef / F&B Store Keeper |
| 36 | 30 Oct 2026, 07:11 AM | INWARD | Gourmet Arabica Coffee Beans (Medium Roast) | {"id":21,"name":"Beverages, Mocktails & Bar","code":"BEV","description":"Mocktail syrups, Arabica coffee beans, mineral water, imported sparkling waters, tea","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +8 | INWARD-KIT-09 | - | - | Inward fresh kitchen stock received (Yield: 70 plates/Kg = 560 Plates) | Chef / F&B Store Keeper |
| 37 | 30 Oct 2026, 07:11 AM | INWARD | Fresh Full Cream Milk & Cooking Cream | {"id":19,"name":"Dairy & Paneer","code":"DAIRY","description":"Fresh malai paneer, milk, cooking cream, butter, curd and pure ghee","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +35 | INWARD-KIT-08 | - | - | Inward fresh kitchen stock received (Yield: 6 plates/Liters = 210 Plates) | Chef / F&B Store Keeper |
| 38 | 30 Oct 2026, 07:11 AM | INWARD | Black Urad Dal (Dal Makhani Special) | {"id":20,"name":"Grains, Rice & Flour","code":"GRAINS","description":"Aged Basmati rice, wheat atta, maida, black urad dal, lentils and batters","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +25 | INWARD-KIT-07 | - | - | Inward fresh kitchen stock received (Yield: 6 plates/Kg = 150 Plates) | Chef / F&B Store Keeper |
| 39 | 30 Oct 2026, 07:11 AM | INWARD | South Indian Idli & Dosa Fermented Batter | {"id":20,"name":"Grains, Rice & Flour","code":"GRAINS","description":"Aged Basmati rice, wheat atta, maida, black urad dal, lentils and batters","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +18 | INWARD-KIT-06 | - | - | Inward fresh kitchen stock received (Yield: 4 plates/Kg = 72 Plates) | Chef / F&B Store Keeper |
| 40 | 30 Oct 2026, 07:11 AM | INWARD | Farm Fresh Table Eggs (Tray Pack) | {"id":18,"name":"Meat, Poultry & Eggs","code":"MEAT","description":"Fresh broiler chicken, mutton, seafood, eggs for daily tandoor & curry prep","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +160 | INWARD-KIT-05 | - | - | Inward fresh kitchen stock received (Yield: 0.5 plates/Pcs = 80 Plates) | Chef / F&B Store Keeper |
| 41 | 30 Oct 2026, 07:11 AM | INWARD | Tender Baby Mutton (Dum Biryani Cut) | {"id":18,"name":"Meat, Poultry & Eggs","code":"MEAT","description":"Fresh broiler chicken, mutton, seafood, eggs for daily tandoor & curry prep","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +14 | INWARD-KIT-04 | - | - | Inward fresh kitchen stock received (Yield: 4 plates/Kg = 56 Plates) | Chef / F&B Store Keeper |
| 42 | 30 Oct 2026, 07:11 AM | INWARD | Aged Royal Basmati Rice (Daawat Gold) | {"id":20,"name":"Grains, Rice & Flour","code":"GRAINS","description":"Aged Basmati rice, wheat atta, maida, black urad dal, lentils and batters","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +60 | INWARD-KIT-03 | - | - | Inward fresh kitchen stock received (Yield: 5 plates/Kg = 300 Plates) | Chef / F&B Store Keeper |
| 43 | 30 Oct 2026, 07:11 AM | INWARD | Fresh Malai Paneer (Dairy Fresh) | {"id":19,"name":"Dairy & Paneer","code":"DAIRY","description":"Fresh malai paneer, milk, cooking cream, butter, curd and pure ghee","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +20 | INWARD-KIT-02 | - | - | Inward fresh kitchen stock received (Yield: 5 plates/Kg = 100 Plates) | Chef / F&B Store Keeper |
| 44 | 30 Oct 2026, 07:11 AM | INWARD | Fresh Chicken (Curry / Tandoori Cut) | {"id":18,"name":"Meat, Poultry & Eggs","code":"MEAT","description":"Fresh broiler chicken, mutton, seafood, eggs for daily tandoor & curry prep","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +25 | INWARD-KIT-01 | - | - | Inward fresh kitchen stock received (Yield: 4 plates/Kg = 100 Plates) | Chef / F&B Store Keeper |
| 45 | 30 Oct 2026, 07:11 AM | INWARD | Room Mist Aerosol Air Freshener | {"id":16,"name":"Cleaning Supplies","code":"CLEAN","description":"Disinfectants, detergents, room sprays, mops and housekeeping chemicals","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +15 | INIT-STOCK-ST-08 | - | - | Initial stock inventory audit opening balance | Stores Supervisor |
| 46 | 30 Oct 2026, 07:11 AM | INWARD | Sanitizing Floor Wash & Cleaner (5L) | {"id":16,"name":"Cleaning Supplies","code":"CLEAN","description":"Disinfectants, detergents, room sprays, mops and housekeeping chemicals","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +60 | INIT-STOCK-ST-07 | - | - | Initial stock inventory audit opening balance | Stores Supervisor |
| 47 | 30 Oct 2026, 07:11 AM | INWARD | Minibar Imported Sparkling Water | {"id":15,"name":"F&B Stores","code":"FNB","description":"Dry provisions, coffee beans, imported waters, beverages and minibar items","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +95 | INIT-STOCK-ST-06 | - | - | Initial stock inventory audit opening balance | Stores Supervisor |
| 48 | 30 Oct 2026, 07:11 AM | INWARD | Gourmet Arabica Coffee Beans | {"id":15,"name":"F&B Stores","code":"FNB","description":"Dry provisions, coffee beans, imported waters, beverages and minibar items","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +12 | INIT-STOCK-ST-05 | - | - | Initial stock inventory audit opening balance | Stores Supervisor |
| 49 | 30 Oct 2026, 07:11 AM | INWARD | Dental Kits & Shaving Kits | {"id":14,"name":"Guest Toiletries","code":"TOIL","description":"Soaps, shampoos, body washes, dental kits and vanity items","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +180 | INIT-STOCK-ST-04 | - | - | Initial stock inventory audit opening balance | Stores Supervisor |
| 50 | 30 Oct 2026, 07:11 AM | INWARD | Herbal Shower Gel & Shampoo 50ml | {"id":14,"name":"Guest Toiletries","code":"TOIL","description":"Soaps, shampoos, body washes, dental kits and vanity items","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +35 | INIT-STOCK-ST-03 | - | - | Initial stock inventory audit opening balance | Stores Supervisor |
| 51 | 30 Oct 2026, 07:11 AM | INWARD | Plush Bath Towels (White) | {"id":13,"name":"Linen & Bedding","code":"LINEN","description":"Bed sheets, duvet covers, pillowcases, bath towels and bathrobes","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +220 | INIT-STOCK-ST-02 | - | - | Initial stock inventory audit opening balance | Stores Supervisor |
| 52 | 30 Oct 2026, 07:11 AM | INWARD | Luxury Cotton Bed Linens (King) | {"id":13,"name":"Linen & Bedding","code":"LINEN","description":"Bed sheets, duvet covers, pillowcases, bath towels and bathrobes","status":"Active","created_at":"2026-10-30T01:41:25.000000Z","updated_at":"2026-10-30T01:41:25.000000Z"} | +140 | INIT-STOCK-ST-01 | - | - | Initial stock inventory audit opening balance | Stores Supervisor |
| Total Store Procurement Purchases: | ₹ 0.00 | Inward Shipments: 24 • Plates Yielded: 1402 | ||||||||
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, 06:18 PM | Front Office | 837\2026-2027 | Mr. Jaydev Bera | Settlement | Cash | ₹ 9,520.00 | - |
| 8 | 30 Oct 2026, 06:18 PM | Front Office | 836\2026-2027 | Mr. Jaydev Bera | Settlement | Cash | ₹ 19,040.00 | - |
| 9 | 30 Oct 2026, 02:06 PM | Restaurant POS | POS-20261030-0007 | dd | Takeaway Dining | Cash | ₹ 1,041.60 | - |
| 10 | 30 Oct 2026, 02:06 PM | Restaurant POS | POS-20261030-0006 | dd | Takeaway Dining | Cash | ₹ 1,041.60 | - |
| 11 | 30 Oct 2026, 01:48 PM | Restaurant POS | POS-20261030-0005 | Sudip | Takeaway Dining | Cash | ₹ 627.20 | - |
| 12 | 30 Oct 2026, 01:26 PM | Front Office | 835\2026-2027 | Capt. Sudip Chakraborty | Advance | Cash | ₹ 50,000.00 | - |
| 13 | 30 Oct 2026, 01:07 PM | Front Office | 831\2026-2027 | Mr. Aman Islam | Settlement | Google Pay | ₹ 5,738.00 | - |
| 14 | 30 Oct 2026, 01:02 PM | Front Office | 834\2026-2027 | Capt. Sudip Chakraborty | Advance | Cash | ₹ 2,000.00 | - |
| 15 | 30 Oct 2026, 12:07 PM | Front Office | 832\2026-2027 | Capt. Sudip Chakraborty | Advance | Cash | ₹ 2,000.00 | - |
| 16 | 30 Oct 2026, 10:01 AM | Front Office | 831\2026-2027 | Mr. Aman Islam | Advance | PhonePe | ₹ 2,000.00 | - |
| Total Reconciled Cash Flow: | ₹ 108,578.90 | − ₹ 0.00 | ||||||
| NET SURPLUS / CASH POSITION: | ₹ 108,578.90 | |||||||