Projects · Interior and fit-out practices

Studio

Projects, bills of quantity, quotations, payments and the studio's books — so the number you quote is a number you trust.

In daily use at a studio · demo liveOpen the live demo
Problem 1 of 4

What has this project cost so far, and which vendor is it all going to?

To answer it today
  1. Open BOQ_v7_final_FINAL(2).
  2. Find the right tab. Not the one called “old rates — ignore”.
  3. Add each vendor up by hand; one line has no vendor at all.
  4. Find the total says #REF!, and has for a fortnight.

TodayFour tabs. One question.

NowOn the project's own screen, split by vendor.

Studio's project screen for Sunrise Cafe on sample data: ₹4,48,000 BOQ total, totals by category and by vendor, and every line item.
BOQ_v7_final_FINAL(2).xlsx4 tabs · 2 people editing
B8fx=SUM(B2:B7)
ABCDE1ItemAmountVendorQtyRate2Counter & booths210000Sharma Woodworks12100003Cafe chairs95000Prime Interiors2439584Lighting70000Iyer Electricals1700005Counter & boothsdup?Sharma Woodworks12100006Paint55000?1550007Labour#REF!8TOTAL#REF!
Sheet1BOQBOQ v7old rates — ignore

Four tabs. One question.

BOQ_v7_final_FINAL(2).xlsx4 tabs · 2 people editing
B8fx=SUM(B2:B7)
ABCDE1ItemAmountVendorQtyRate2Counter & booths210000Sharma Woodworks12100003Cafe chairs95000Prime Interiors2439584Lighting70000Iyer Electricals1700005Counter & boothsdup?Sharma Woodworks12100006Paint55000?1550007Labour#REF!8TOTAL#REF!
Sheet1BOQBOQ v7old rates — ignore
To answer it now

On the project's own screen, split by vendor.

interior-demo.buildwithneev.comSample data
Studio's By vendor panel for a sample project: Bansal Paints ₹55,000, Iyer Electricals ₹70,000, Prime Interiors Supply ₹95,000, Sharma Woodworks ₹2,10,000.
Problem 2 of 4

Who do we still owe, and how much?

To answer it today
  1. Scroll back through the WhatsApp group.
  2. Match each payment to a bill, across three projects.
  3. Ask whichever partner paid in cash.

TodayThree places. One question.

NowEvery vendor: what they billed, what's been paid, what's left.

Studio's Vendors screen on sample data: ₹19,91,000 to pay across six suppliers, each with billed, paid out and to pay.
Vendor payments 2026.xlsxlast edited by Ravi
B8fx=B2-B5-B7
ABCD1DatePaidVendorNote202 Sep200000Sharma Woodworksadvance311 Sep330000Bansal Paintsfull?419 Sep400000Sharma Wood workswhich project526 SepDeluxe Flooringpending, ask Meera603 Oct?sharmacash, from Ravi78#VALUE!Still owecheck WhatsApp
PaymentsWhatsApp copySheet3

Three places. One question.

Vendor payments 2026.xlsxlast edited by Ravi
B8fx=B2-B5-B7
ABCD1DatePaidVendorNote202 Sep200000Sharma Woodworksadvance311 Sep330000Bansal Paintsfull?419 Sep400000Sharma Wood workswhich project526 SepDeluxe Flooringpending, ask Meera603 Oct?sharmacash, from Ravi78#VALUE!Still owecheck WhatsApp
PaymentsWhatsApp copySheet3
To answer it now

Every vendor: what they billed, what's been paid, what's left.

interior-demo.buildwithneev.comSample data
Studio's Suppliers list on sample data: each supplier's billed and paid-out totals and what's still to pay, from ₹5,000 for Bansal Paints to ₹4,60,000 for Deluxe Flooring.
Problem 3 of 4

How much money do we have, and whose account is it in?

To answer it today
  1. Ask each partner for their balance.
  2. Open three copies of the cash book.
  3. Wait for month end to be sure.

TodayThree phones. One question.

NowEvery partner's bank and cash, and the studio's own, on one screen.

Studio's Books screen on sample data: balances for each partner's bank and cash and the studio's, this month's spending and what's owed to vendors.
Cash book Oct.xlsx3 copies on 3 phones
B8fx=B2+B3-B5
ABCD1WhoBankCashNote2Ravi738780-77400paid Sharma?3Meera-129840check4Studio-132050petty cash5Ravi-20000dup of row 2?678Total#REF!ask at month end
OctOct (Meera)Sep

Three phones. One question.

Cash book Oct.xlsx3 copies on 3 phones
B8fx=B2+B3-B5
ABCD1WhoBankCashNote2Ravi738780-77400paid Sharma?3Meera-129840check4Studio-132050petty cash5Ravi-20000dup of row 2?678Total#REF!ask at month end
OctOct (Meera)Sep
To answer it now

Every partner's bank and cash, and the studio's own, on one screen.

interior-demo.buildwithneev.comSample data
Studio's Balances panel on sample data: ₹2,59,740 across all accounts, with bank and cash for each partner and for the studio.
Problem 4 of 4

What do we quote for this 2BHK?

To answer it today
  1. Copy last month's quotation.
  2. Retype the rooms and the sizes.
  3. Hope no old rate rode along with it.

TodayOne copy. Every old mistake.

NowRooms and lines priced from your own rate card, printed on your own A4.

Studio's quotation editor on sample data: a 2BHK quotation for ₹2,60,125, rooms with lines priced by area and count.
Quote Kulkarni 2BHK (3).xlsxcopied from Mehta quote
B8fx=SUM(B2:B7)
ABCDE1ParticularsAmountWHRate2TV unit50400879003False ceiling159601412954Kitchen base41250102.751500 (old)5Wardrobe812007814506Wardrobe8120078dup?7Paintingask Ravi8GRAND TOTAL#REF!
QuoteRates 2024Mehta (old)

One copy. Every old mistake.

Quote Kulkarni 2BHK (3).xlsxcopied from Mehta quote
B8fx=SUM(B2:B7)
ABCDE1ParticularsAmountWHRate2TV unit50400879003False ceiling159601412954Kitchen base41250102.751500 (old)5Wardrobe812007814506Wardrobe8120078dup?7Paintingask Ravi8GRAND TOTAL#REF!
QuoteRates 2024Mehta (old)
To answer it now

Rooms and lines priced from your own rate card, printed on your own A4.

interior-demo.buildwithneev.comSample data
Studio's quotation editor on sample data: the living room of a 2BHK quotation, each line priced by area or count, ₹78,860 for the room.

Your version of this question.

Different trade, same shape: something you already know, spread across files that don't agree with each other.