Skip navigation
Menu

MainBranch drafts each quarter’s variance memo, every figure traced to the budget file

The Data to memo workflow open in MainBranch: the street maintenance budget file with its two lines more than $50,000 ahead of pace marked, and beside it the variance memo, drafted with the same figures.

One request in Assistant drafts the whole memo

The draft takes its figures from the budget file and the transfer from the October 13 vote, then waits for your team

Assistant/Q1 variance memo

Draft the Q1 variance memo to council for street maintenance. Explain each line more than $50,000 ahead of pace.

  1. Read Street maintenance budget FY2027.xlsx

    Two lines are more than $50,000 ahead of pace

    LineAgainst pace
    Patching$156,000 ahead
    Resurfacing$126,000 ahead
    Crack seal$26,000 ahead
    Equipment$13,000 behind
    Sidewalks$70,000 behind
  2. Read Regular council meeting, October 13

    Council moved $250,000 from sidewalk repair to residential patching, 3 to 1, with one member absent.

  3. Drafted the memo in Documents and Spreadsheets

    Q1 variance memoDraft for your reviewRead the memo

Every figure in the memo sits beside its source

Press any figure to see the cell it came from and the arithmetic behind it

Q1 variance memo/DraftSaved October 14, 2026

The memo downloads as Word, PDF or Markdown, and here it is saved as a PDF.

Q1 variance memo

To
City Council
From
Finance Director
Date
October 14, 2026
Subject
Street maintenance, first-quarter variances

Summary

After one quarter, of the street maintenance budget is expended against a pace. Two lines are more than ahead: Patching and Resurfacing. Two are behind: Sidewalks and Equipment.

LineBudgetExpended% expendedAgainst paceQ1 last year
Patching$1,200,000$456,00038%$156,000 ahead$372,000
Crack seal$640,000$186,00029%$26,000 ahead$171,000
Sidewalks$520,000$60,00012%$70,000 behind$118,000
Resurfacing$2,100,000$651,00031%$126,000 ahead$588,000
Equipment$380,000$82,00022%$13,000 behind$79,000
Total$4,840,000$1,435,00030%$225,000 ahead$1,328,000

Benchmark after one quarter: 25 percent expended.

Lines ahead of pace

Patching is expended, ahead, after two crews were added in June.

Resurfacing is expended, ahead, as summer paving under last year’s contract finished in August; the FY2027 paving contract award comes to council on October 27, with nothing yet encumbered against it.

Crack seal is expended, ahead, under the threshold.

Lines behind pace

Sidewalks is expended, behind, with Tier 1 work begun in July; after the $250,000 transfer to Patching it is still behind.

Equipment is expended, behind, with one invoice open.

Recommendation

No further transfer is needed for Patching: it is ahead of pace after were added in June, and the transfer council approved on October 13, by a vote of 3 to 1, with one member absent, more than covers it: at $300,000 a quarter from here, Patching ends the year at , inside its . Resurfacing is the open question: the recommended award comes to council on against left in the line. If council awards it, a amendment from fund balance comes with it.

Your team accepts every change before the memo goes to council

The draft flags the assumption behind its numbers, and each edit waits in place for your team to accept or reject

Q1 variance memoOne change to reviewNo changes to review

Notes for your reviewThe memo assumes a straight-line pace; seasonal lines run ahead in summer.

Recommendation

No further transfer is needed for Patching: it is $156,000 ahead of pace after two crews were added in June, and the $250,000 transfer council approved on October 13, by a vote of 3 to 1, with one member absent, more than covers it: at $300,000 a quarter from here, Patching ends the year at $1,356,000, inside its $1,450,000. Resurfacing is the open question: the recommended $1,612,400 award comes to council on October 27 against $1,449,000 left in the line. If council awards it, a $163,400 amendment from fund balance comes with it.

Finance DirectorAdded from the October 13 meeting

Accepted into the memo

See the variance memo drafted from your own books

Bring last quarter’s workbook and your own memo to a demo

Records
From your budget workbook and the October 13 regular meeting
Apps
Documents and Spreadsheets, Meetings and Assistant
Signs
The finance director signs it before it goes to council
Controls
Single sign-on over SAML 2.0 and OpenID Connect, MFA enforced and role-based access