Triangled,
Yes that is true, I am a bit obsessed with Excel. I do have the business end semi-automated on Excel (I did try QuickBooks but didn't see it amenable to my type of business), but my business Excel is a bit of a mess and needs a lot of work.
I have been aware of this uncollected account because when I receive payment, I enter date and amount and that changes a red highlighted cell to green.
The way this all works: Builder (B) approaches Res Dsgnr (RD) to start on a house, RD shows B how much my fee is because RD has my fee table of XXXX sq ft = $ fee, RD gets drawings to point of where framing and other structure needs to be redlined by me, I do my stuff, RD hands over stamped dwgs and calculations to B, and at that point B either hands over a check to RD or promises to send it in the mail soon. The check will be cut by either B or the house owner.
Eventually, I get check in the mail form the RD, not even knowing who the B ever was, unless there is a plans check or construction problem. Actually this all makes sense MOST of the time to cut down on phone calls and emails.
Obviously this is all different how things are done with commercial projects, where there is an actual General Contractor known to you all along.