ChangeLensहिन्दी में पढ़ें

← All tools

Coming soon

Commission ledger

Write each deal once and log every payment you receive. The ledger works out the commission, the total to bill, what is still pending and how much goes to a co-broker — so you always know who owes you what.

Works in Google Sheets and Excel.

GST % is entered by you for each deal — no tax rate is built in. TDS is not included. This sheet only does the arithmetic; it is not tax advice. Ask your CA what applies to you.

Notify me

What’s inside

Columns marked “auto” are grey in the sheet and fill themselves from a formula.

  1. Sheet: Deals

    One row per deal. Commission is either a % of the deal value or a fixed amount.

    Columns

    • Deal ID
    • Deal date
    • Property
    • Client
    • Deal value (₹)
    • Commission %
    • Or fixed commission (₹)
    • Commission (₹) (auto)
    • GST % (if you charge it)
    • GST (₹) (auto)
    • Total to bill (₹) (auto)
    • Received (₹) (auto)
    • Pending (₹) (auto)
    • Payment status (auto)
    • Co-broker
    • Co-broker share %
    • Co-broker amount (₹) (auto)
    • My share (₹) (auto)
    • Notes

  2. Sheet: Payments

    Every amount you receive, one row each. Use the Deal ID from the Deals sheet.

    Columns

    • Date
    • Deal ID
    • Amount (₹)
    • Mode
    • Reference / UTR

  3. Sheet: Summary

    Totals for all deals: billed, received, pending and your own share.

    Nothing to type here — it fills itself.

Price

There is no price yet. Nothing is on sale and we will not ask you to pay anything now.

Want to know when it is ready? Leave your email on the home page.

Notify me