HomeworkSampleJoin the waitlist
Ellis Residence / OverviewSheet rev. 11/16 · synced Nov 20

Hello, Sam & Alex

$4,150 is owed on Inv 11, and 7 other items are waiting on you.

$175,188
Contract incl. tax
bid + approved COs
$104,975
Invoiced to date
60% of contract
$90,159
Paid on invoices
of $104,975 invoiced
$4,150
Owed now
1 invoice unpaid
$19,874
Deposit left to apply
$30,540 held · $10,666 applied

Payments to Marco

$116,129deposit and invoice payments on the payment log in Marco's sheet, plus $4,570 sent and not yet logged
  • Paid, on Marco's log
  • Sent, not yet on his log (Inv 10)
  • Owed now (Inv 11)
$0$20K$40K$60KMayJunJulAugSepOctNov

Paid vs. contract

69%$120,699 paid of the $175,188 contract incl. tax, incl. $4,570 sent and not yet on Marco's log

$19,874 of the deposit is not yet applied to an invoice, so cash paid runs ahead of the $104,975 invoiced.

$0$50K$100K$150K$200KJunJulAugSepOctNovDecContract $175KInvoiced $105KDec 24 goalPowder room finished before year-end$120,699 paid

Budget vs. invoiced by room

  • Paid
  • Invoiced, unpaid
  • Not yet invoiced
  • $11,996 of $64,345
    19% invoiced · $10,512 paid · $1,484 owed
  • $39,358 of $43,130
    91% invoiced · $37,200 paid · $2,158 owed
  • $5,511 of $8,532
    65% invoiced · $5,188 paid · $323 owed
  • $7,550 of $14,074
    54% invoiced · $7,586 paid
  • $17,590 of $18,825
    93% invoiced · $17,590 paid
  • $2,367 of $5,376
    44% invoiced · $2,367 paid

Needs Sam & Alex

8 open

Last plan · week of Nov 2

  • Mon 2
    Exterior door install (CO8) if weather holds · Electrical: raise living room outlets above the wainscot cap · Drywall touch-ups in the hall · Millwork install: built-in shelves
  • Tue 3
    Drywall patch & prime · Millwork install: mantel trim · Millwork paint prep & first coat
  • Wed 4
    Electrical trim-out (TBD) · Millwork sanding & second coat (TBD)
  • Thu 5
    Millwork final coat (TBD)
  • Fri 6
    Millwork touch-ups (TBD) · Admin: weekly update to owners

Marco is reworking the schedule for the fireplace and powder room and expects a revised budget to walk through with Sam and Alex within the next week or so.

Contract breakdown

37%
25%
22%
5%
9%
  • Primary Bath
    $64,345
    $11,996 invoiced
  • Fireplace & Finished Millwork
    $43,130
    $39,358 invoiced
  • Change Orders
    $38,899
    Includes the laundry COs and the Northline insurance job
  • Powder Room
    $8,532
    $5,511 invoiced
  • Admin
    $5,376
    $2,367 invoiced
  • Sales tax
    $14,906
    9.3% on the subtotal

Rooms

Drag a slider to set progress by hand; the blue tick is the auto estimate
  • 21%
    Bid
    $64,345
    Invoiced
    $11,996
    Paid
    $10,512
    Left to pay
    $53,833
    Left to do
    $52,349 34 items
    Materials invoiced
    7 of 30
    8 paid1 awaiting33 not invoiced$1,484 on Inv 11
  • 8500%
    Bid
    $43,130
    Invoiced
    $39,358
    Paid
    $37,200
    Left to pay
    $5,930
    Left to do
    $3,772 8 items
    Materials invoiced
    16 of 17 · 2 partly
    23 paid4 awaiting1 not invoiced$2,158 on Inv 11
  • 4000%
    Bid
    $8,532
    Invoiced
    $5,511
    Paid
    $5,188
    Left to pay
    $3,344
    Left to do
    $3,021 13 items
    Materials invoiced
    13 of 16 · 4 partly
    15 paid1 awaiting7 not invoiced$323 on Inv 11
  • 57%
    Bid
    $14,074
    Invoiced
    $7,550
    Paid
    $7,586
    Left to pay
    $6,488
    Left to do
    $6,524 3 items
    Materials invoiced
    3 of 4 · 1 partly
    2 paid2 awaiting1 not invoicedon Inv 11, nets to $0
  • 96%
    Bid
    $18,825
    Invoiced
    $17,590
    Paid
    $17,590
    Left to pay
    $1,235
    Left to do
    $1,235 0 items
    Materials invoiced
    8 of 8
    14 paid0 awaiting0 not invoiced
  • 66%
    Bid
    $5,376
    Invoiced
    $2,367
    Paid
    $2,367
    Left to pay
    $3,009
    Left to do
    $3,009 2 items
    Materials invoiced
    1 of 1
    2 paid0 awaiting1 not invoiced