Studio
Projects, bills of quantity, quotations, payments and the studio's books — so the number you quote is a number you trust.
What has this project cost so far, and which vendor is it all going to?
- Open BOQ_v7_final_FINAL(2).
- Find the right tab. Not the one called “old rates — ignore”.
- Add each vendor up by hand; one line has no vendor at all.
- Find the total says #REF!, and has for a fortnight.
TodayFour tabs. One question.
NowOn the project's own screen, split by vendor.

=SUM(B2:B7)Four tabs. One question.
=SUM(B2:B7)On the project's own screen, split by vendor.

Who do we still owe, and how much?
- Scroll back through the WhatsApp group.
- Match each payment to a bill, across three projects.
- Ask whichever partner paid in cash.
TodayThree places. One question.
NowEvery vendor: what they billed, what's been paid, what's left.

=B2-B5-B7Three places. One question.
=B2-B5-B7Every vendor: what they billed, what's been paid, what's left.

How much money do we have, and whose account is it in?
- Ask each partner for their balance.
- Open three copies of the cash book.
- 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.

=B2+B3-B5Three phones. One question.
=B2+B3-B5Every partner's bank and cash, and the studio's own, on one screen.

What do we quote for this 2BHK?
- Copy last month's quotation.
- Retype the rooms and the sizes.
- 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.

=SUM(B2:B7)One copy. Every old mistake.
=SUM(B2:B7)Rooms and lines priced from your own rate card, printed on your own A4.

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