Taj Settlement · Payment Reconciliation

Final invoice

₹56.67L

₹56,67,061 across rooms, banquets, liquor, F&B, and miscellaneous charges.

Balance owed

₹0

Settled with Taj.

Lodging

₹28.85L

50.91% · accommodation and room retention.

Events + venues

₹22.37L

39.47% · banquet food, beverages, and venue rental.

Hospitality extras

₹5.45L

9.62% · alcohol and guest food-and-beverage incidentals.

How the money was spent

Per Category Breakdown

Rooms and the wedding program account for 90.4% of the final bill.

₹56.67LFinal invoice

Gross category shares from Taj's final folio; the net ₹2 invoice round-off is included in the total.

Per-day category summary

Final-folio values by posting day. The net ₹2 POS round-off is included in Guest F&B on July 10.

Category	Jul 7	Jul 8	Jul 9	Jul 10	Total
Rooms	₹4,10,640	₹15,12,760	₹7,54,610	₹2,07,090	₹28,85,100
Banquets	₹0	₹15,91,011.70	₹1,06,200	₹3,39,108.40	₹20,36,320.10
Liquor	₹2,600.02	₹14,950.08	₹2,38,545.13	₹2,37,725.40	₹4,93,820.63
Venue rental	₹0	₹1,00,300	₹1,00,300	₹0	₹2,00,600
Guest F&B	₹1,917.50	₹23,213.56	₹18,066.19	₹8,023.02	₹51,220.27
Final invoice	₹4,15,157.52	₹32,42,235.34	₹12,17,721.32	₹7,91,946.82	₹56,67,061

One effective date per payment

Settlement ledger

Confirmed dates override Taj's posting date. Where no override exists, the ledger uses Taj's folio date and labels the fallback.

Owners TaruniAbhinavAviral Sources UserTajPlaid

Date	Entry / reference	Amount	Owner	Sources
10 Jan 2026User override	Card reference 003633	₹5,00,000	Taruni	UserTaj
10 Jan 2026User override	Card reference 003634	₹5,00,000	Taruni	UserTaj
07 Jul 2026Taj fallback	Deposit Transfer at Check-in	₹2,00,000	Aviral	UserTaj
06 May 2026	CCAvenue 114489279881	₹3,80,000	Aviral	TajPlaid
07 Jul 2026Taj fallback	Deposit Transfer at Check-in	₹23,00,000	Taruni	UserTaj
07 Jul 2026	Visa ending 5688	₹5,00,000	Aviral	UserTajPlaid
07 Jul 2026Taj fallback	Visa ending 1220	₹5,00,000	Taruni	UserTaj
07 Jul 2026	Visa ending 5688	₹2,00,000	Aviral	UserTajPlaid
10 Jul 2026	Card ending 6888	₹87,302	Aviral	TajPlaid
10 Jul 2026	Card ending 6680	₹4,99,760	Aviral	TajPlaid
Reported source payments		₹56,67,062
Final invoice credits		₹56,67,061

Category detail

Hotel Grids

Each category uses the same pattern: a day-level summary followed by its underlying cost grid. Room and banquet data come from the June cost sheet; the remaining categories come from the final folio.

Room Grid June cost sheet

7 Jul · 6 rooms₹1,85,850 · 6.47%
8 Jul · 100 rooms₹17,67,640 · 61.56%
9 Jul · 50 rooms₹9,18,040 · 31.97%

Day	Rooms	Gross cost	Share
7 Jul	6	₹1,85,850	6.47%
8 Jul	100	₹17,67,640	61.56%
9 Jul	50	₹9,18,040	31.97%
Total	156	₹28,71,530	100%

Room category	Jul 7	Jul 8	Jul 9	Gross
Superior / Deluxe Garden mix	5	80	48	₹21,18,690
Deluxe Seaview	0	18	0	₹3,39,840
Premium Villa Seaview	0	1	1	₹94,400
Grand Villa	1	1	1	₹3,18,600
Accommodation total	6	100	50	₹28,71,530

Banquet Grid June cost sheet

7 Jul · no program₹0 · 0%
8 Jul · 200 dinner guests₹13,39,300 · 65.99%
9 Jul · 100 dinner guests₹6,90,300 · 34.01%

Day	Program	Gross cost	Share
7 Jul	No banquet program	₹0	0%
8 Jul	150 hi-tea · 200 dinner · Machan	₹13,39,300	65.99%
9 Jul	50 hi-tea · 100 dinner · Bay Lawn	₹6,90,300	34.01%
Total		₹20,29,600	100%

Event / venue	Quantity	Rate	Gross
Jul 8 hi-tea	150 guests	₹1,000	₹1,77,000
Jul 8 vegetarian dinner	200 guests	₹4,500	₹10,62,000
Jul 9 hi-tea	50 guests	₹1,000	₹59,000
Jul 9 vegetarian dinner	100 guests	₹4,500	₹5,31,000
Machan rental	1 session	₹85,000	₹1,00,300
Bay Lawn rental	1 session	₹85,000	₹1,00,300
Banquet total			₹20,29,600

Liquor Grid Final folio

7 Jul · 2 checks₹2,600.02 · 0.53%
8 Jul · 1 check₹14,950.08 · 3.03%
9 Jul · 1 check₹2,38,545.13 · 48.31%
10 Jul · 3 checks₹2,37,725.40 · 48.14%

Day	Checks	Gross cost	Share
7 Jul	2	₹2,600.02	0.53%
8 Jul	1	₹14,950.08	3.03%
9 Jul	1	₹2,38,545.13	48.31%
10 Jul	3	₹2,37,725.40	48.14%
Total	7	₹4,93,820.63	100%

Date	Outlet / check	Charge	Gross
7 Jul	Anchor Bar · 2802343616	Indian liquor + VAT	₹1,300.01
7 Jul	Anchor Bar · 2802343623	Indian liquor + VAT	₹1,300.01
8 Jul	Anchor Bar · 2802343655	Indian + imported liquor + VAT	₹14,950.08
9 Jul	Anchor Bar · 2802343679	Indian + imported liquor + VAT	₹2,38,545.13
10 Jul	Anchor Bar · 2802343729	Indian + imported liquor + VAT	₹2,35,125.39
10 Jul	Treat Yourself · 2802507694	Indian liquor + VAT	₹550
10 Jul	Treat Yourself · 2802507696	Indian + imported liquor + VAT	₹2,050.01
Liquor total			₹4,93,820.63

Venue Rental Grid Final folio

8 Jul · Machan₹1,00,300 · 50%
9 Jul · Bay Lawn₹1,00,300 · 50%

Day	Venue	Gross cost	Share
8 Jul	Machan	₹1,00,300	50%
9 Jul	Bay Lawn	₹1,00,300	50%
Total		₹2,00,600	100%

Date	Venue / check	Pre-tax	Tax	Gross
8 Jul	Machan · 2800205433	₹85,000	₹15,300	₹1,00,300
9 Jul	Bay Lawn · 2800205436	₹85,000	₹15,300	₹1,00,300
Venue total		₹1,70,000	₹30,600	₹2,00,600

Guest Food & Beverage Grid Final folio

7 Jul · 1 check₹1,917.50 · 3.74%
8 Jul · 5 checks₹23,213.56 · 45.32%
9 Jul · 7 checks₹18,066.19 · 35.27%
10 Jul · 2 checks₹8,025.02 · 15.67%

Day	Checks	Gross cost	Share
7 Jul	1	₹1,917.50	3.74%
8 Jul	5	₹23,213.56	45.32%
9 Jul	7	₹18,066.19	35.27%
10 Jul	2	₹8,025.02	15.67%
7–10 Jul	20 adjustments	−₹2	Round-off
Total	15 checks	₹51,220.27	Net

Date	Outlet / check	Charge	Gross
7 Jul	In-room dining · 2802144109	Food/beverages + GST	₹1,917.50
8 Jul	Seagull · 2802059943	Food/beverages + GST	₹2,065
8 Jul	In-room dining · 2802144112	Food/beverages + GST	₹466.10
8 Jul	In-room dining · 2802144113	Food/beverages + GST	₹466.10
8 Jul	In-room dining · 2802144125	Food/beverages + GST	₹466.10
8 Jul	Treat Yourself · 2802507667	Food/beverages + GST	₹19,750.26
9 Jul	Seagull · 2802060026	Food/beverages + GST	₹5,310
9 Jul	In-room dining · 2802144144	Food/beverages + GST	₹1,917.50
9 Jul	In-room dining · 2802144147	Food/beverages + GST	₹3,168.30
9 Jul	In-room dining · 2802144159	Food/beverages + GST	₹2,761.20
9 Jul	In-room dining · 2802144160	Food/beverages + GST	₹3,127
9 Jul	In-room dining · 2802144175	Food/beverages + GST	₹932.20
9 Jul	Treat Yourself · 2802507676	Food/beverages + GST	₹849.99
10 Jul	Treat Yourself · 2802507694	Food/beverages + GST	₹6,625.02
10 Jul	Treat Yourself · 2802507696	Food/beverages + GST	₹1,400
7–10 Jul	20 POS adjustments	Net round-off	−₹2
Guest F&B total			₹51,220.27

Source record

What this report uses

Final invoice email + attachment

11 Jul 2026Invoice 202843694 was finalized at ₹56,67,061 with matching credits and a ₹0 balance.
13 Jul 2026Reception Fishcove emailed Aviral Sandeep Mansingka.pdf; the message directed the recipient to the attached final invoice.
24 Jul 2026The 28-page attachment was re-read: 549 folio rows were rolled up to 84 room items and invoice checks, matching the HSN summary.

Original contract

5–10 Jan 2026The wedding contract was finalized and signed with an original estimate of ₹38,80,430 and an advance schedule.

June cost sheet

20 Jun 2026The planning sheet recorded a ₹28,71,530 room grid and ₹20,29,600 banquet grid, totaling ₹49,01,130 before final-folio additions.

July addendum

6 Jul 2026The addendum updated the room scope and the July 8–9 wedding program, including Machan and Bay Lawn.

Plaid transaction records

6 May 2026Bilt recorded the ₹3,80,000 CCAvenue advance.
7 Jul 2026Chase Visa 5688 recorded Taj payments of ₹5,00,000 and ₹2,00,000.
10 Jul 2026A ₹5,87,062 Chase charge matched Taj card entries 6888 and 6680.

Payer confirmations

10 Jan 2026Taruni paid the two ₹5,00,000 advances.
24 Jul 2026The reconciliation records Aviral for the ₹2,00,000 deposit, Visa 5688, and the consolidated Chase entries; and Taruni for the ₹23,00,000 deposit and Visa 1220.

Prepared 24 Jul 2026 from the linked Markdown reconciliation.