TMC Thane Project Finance Module V17 - Single Billing Workflow V10

Master Data Source: 3rd Runnung bil demand list (1) - Copy.xlsx
Permanent master starts with 989 building records and the historical 1st / 2nd / 3rd bill tags already available in the source. New Bill workflow: Excel upload → building-wise preview → select buildings → invoice → save invoice → letter → payment. A newly uploaded Excel is kept temporary for invoice preparation and is not added to Dashboard / Building Master until you explicitly save the invoice with “Save / update Permanent Building Master” selected.

Bill Position – Basic Amount (Before GST)

95% Claim Completion

Critical Source Reconciliation

Workbook Summary

Zone-wise Revenue & Claim Position

Zone	Rows	Properties / Units	Demand	Agency Share	45% Tagged	50% Tagged	50% Not Claim	5% Hold

Sr	Zone / Ward	Building	Units	Current	Retrospective	Total Demand	16.16% Share	45%	45% Bill	50%	50% Bill	Type	Processing

Source Reconciliation – Historical Bills

Editable Reconciliation / Adjustment Entry

Link Type

Linked Reference

Date

Excel Source Summary (Sheet6)

Bill	Structures	Units	Current Demand	Retrospective	Total Demand	Collection Structures	TDO	Actual Collection

Permanent finance history: every Bill and Letter is a separate record. Add documents directly inside the Bill/Letter entry. Old records and attachments are never replaced when a new bill is created.

Running Bill	Letter	Invoice	Buildings	Revenue Basis	Components	Basic	Gross	Received	Outstanding	Status	Docs	Action

Enter the letter and upload all related PDFs / Excel / Word / images in the same entry. For old letters, use Documents to add more files at any time.

Date	Letter Ref.	Subject	Linked Bill	Status	Documents	Remarks	Action

Demand Revision / Reconciliation Entry

Building ID

Revision Date

Reason

Previous Total Demand

Revised Total Demand

Applicable Claim Stage

Calculated Claim / Adjustment

Link With

Select Letter / Bill

Financial Treatment

Reference / Remarks

Optional Supporting Documents

Demand Difference

₹0

16.16% Share Difference

₹0

Claim Rate

45%

Net Claim / Set-off

₹0

Treatment

Old bill/payment history is frozen. A revised demand creates a new revision entry. Positive difference can become supplementary claim; negative difference becomes set-off / recovery.

Revision Control Logic

Agreement company share16.16%

Submitted claim component45%

Finalized cumulative entitlement95%

Balance hold5%

Reference controlLink every correction to a Bill or Letter

Date	Building	Reason	Linked Letter / Bill	Old Demand	Revised	Diff	Share Diff	Claim Rate	Claim / Set-off	Treatment	Docs	Action

Total Gross Invoices

₹0

Gross Received

₹0

Net Bank Receipt

₹0

Outstanding

₹0

Record every receipt separately. One bill can have unlimited part-payments. Keep Basic, CGST, SGST, TDS/deductions, Net receipt, payment date and remarks separately.

Bill	Part / Ref	Payment Date	Basic	CGST	SGST	Gross	Income TDS	GST TDS	Other Ded.	Net Received	Status	Remark	Docs	Action

STEP 1 — REVIEW BEFORE BILLING

Building-wise Smart Preview

Upload only building + demand details. The module calculates Total Demand and 16.16% share automatically; you manually choose the claim combination for each building.

No file loaded

Manual 45% Manual 50% Manual 5% 45+50 = 95% • 45+50+5 = 100%

Search Building

Zone

Bill Type

Selected Claim

Master Status

Min Total Demand

Max Total Demand

	Zone	Building Details	Units	Current Demand	Retro / Pending	Total Demand	16.16% Share	History Suggestion	Claim Selection	Claim Amount	Type	History / Warning

Select the required eligible buildings.

Choose a claim combination for each building, then include only the required buildings in the invoice. Upload itself does not change the Dashboard or Master.

New Bill / Invoice Workflow

Excel upload → validation / reconciliation → invoice PDF → submission letter

1. Upload / Select Billing Data

Building Demand Excel / CSV *

Running Bill / Batch

Calculation

AUTO • 16.16% • GST • MANUAL CLAIM %

You only enter: Zone, Building ID, Building Name, Property/Unit Count, Current Demand and Retrospective/Pending Demand. Bill Type / Old Ward / Remarks are optional. Do not calculate 16.16%, 45%, 50% or GST in Excel.

Save / update uploaded buildings in Permanent Building Master only after invoice is saved

Upload raw demand data. Total Demand and 16.16% share are automatic; claim percentage is selected manually building-wise.

2. Selected Buildings → Invoice Calculation

Billing Data Source

Basic Claim₹0

With GST₹0

3. Invoice Details

Order No. / Date

Invoice No.

Invoice Date

Page No.

4. Client Details

Client Name

Client Address

Client GSTIN

State Code

5. Automatic Parameters

Agency Share %

GST %

These are agreement controls. Your upload needs only building and demand details. Claim percentage is selected manually building-wise; all monetary calculations are automatic.

6. Branding

Company Logo (optional, saved in browser)

Single practical sequence: upload Excel → preview buildings → select required buildings → Add Selected to Invoice → verify calculation → enter Invoice No./Date → Print/Save PDF → click Save Invoice → Create Letter. Only after saving the invoice is the batch treated as an actual bill in finance totals.

Agreement-based Excel Import

Company Share16.16%

Submitted Claim45%

Finalized Additional50%

Cumulative95%

Hold5%

Select Excel / CSV

Link this import to Bill

Link this import to Letter

Default Assessment Status

Import Note

Create revision automatically when demand changes

Select Excel and click Preview. No master data changes until you click Confirm & Merge.

Accepted legacy format: the module now also recognizes 4th-running-bill style columns such as Row Labels, current demand, Pending Demand, Total demand, 0.45 and 50%.

Permanent Master Safety

Original pre-loaded rows

Current saved buildings

Permanent keyBuilding ID

Demand changeRevision history + current update

Blank old bill tag in new ExcelOld tag preserved

Every confirmed import is saved locally and recorded in Import History. Download a Full Backup regularly.

Excel Import History

Audit & Control Reports

Project Finance Principles

Building masterPermanent Building ID

Financial historyNever overwrite

Claim vs paymentSeparate ledgers

Demand changesVersion + adjustment

Future billsUnlimited count

Automated Control Checks

Recommended Operational Controls

1. Master keyBuilding Id

2. Claim split45% / 50% / 5%

3. Payment splitBasic / GST / TDS / Net

4. Bill statusDraft → Submitted → Paid

5. ReconciliationExcel vs approved bill

Rows Requiring Attention

Sr	Building	Issue	Demand	45% Bill	50% Bill

TMC Thane Project Finance Module

Bill Position – Basic Amount (Before GST)

95% Claim Completion

Critical Source Reconciliation

Workbook Summary

Zone-wise Revenue & Claim Position

Building-wise Master Ledger

Source Reconciliation – Historical Bills

Editable Reconciliation / Adjustment Entry

Editable Reconciliation Register

Excel Source Summary (Sheet6)

Unlimited Bill Register

Letter Register

Demand Revision / Reconciliation Entry

Revision Control Logic

Revision History

Payment / Part-Payment Register

Eligible Claim Components

New Bill / Annexure

Building-wise Smart Preview

New Bill / Invoice Workflow

1. Upload / Select Billing Data

2. Selected Buildings → Invoice Calculation

3. Invoice Details

4. Client Details

5. Automatic Parameters

6. Branding

Agreement-based Excel Import

Permanent Master Safety

Excel Import History

Audit & Control Reports

Project Finance Principles

Automated Control Checks

Recommended Operational Controls

Rows Requiring Attention

Add Part Payment

Add / Edit Bill

Add / Edit Letter

Documents

Bill Annexure Preview