runbookify
← All plans
Accounting & Finance / Financial Reporting & Close

Close Binder & Supporting Schedule Organizer

Import your trial balance, collect a supporting schedule or reconciliation for every balance-sheet account, let AI check that each one ties to the balance, and assemble a reviewable close binder — accounts get signed off, the binder gets approved, and you export a clean index plus an exceptions list.

IntermediateA weekendBuilds onNext.jsSupabaseResend
What you'll build

A web tool where you import the trial balance, upload a supporting schedule per balance-sheet account, and AI checks each support total against the trial-balance balance — flagging accounts with no support or a tie-out difference and tracking the percent of the balance sheet reconciled. A reviewer signs off each account, the controller approves the complete binder, and you export a binder index plus an exceptions list as PDF or CSV.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.

Before you start

  • A Supabase account (free)
  • A Vercel account (free)
  • A trial-balance export (CSV is fine)
  • Your per-account supporting schedules / reconciliations as files (Excel or PDF)
  • Claude Code or any AI coding agent

The problem this kills

Close is over when every balance on the balance sheet is supported — and you can prove it. So at the end of every period you chase it down: a reconciliation for cash, a schedule for prepaids, an amortization table for fixed assets, a roll-forward for accruals. Each one is supposed to tie to the number on the trial balance. Most of them live as loose files on a shared drive, named however the preparer felt that day, and the only thing telling you whether they actually tie is someone eyeballing two numbers.

Then the real work begins: building the close binder. You collect every schedule, check each one against the trial balance, hunt for the accounts nobody reconciled, note the ones that are off by "just a rounding difference" that turns out to be $4,000, and assemble the whole thing into something a reviewer — and eventually an auditor — can sign off on. Miss an account and an unsupported balance walks straight into the financials. Miss a tie-out difference and you've certified a number you can't actually back up.

This is exactly the kind of checklist-plus-tie-out work a small internal tool does better than a folder full of spreadsheets — and you don't need to be a developer to build it.

What you'll build

A simple internal web tool for your close. You import the trial balance as a CSV and the tool lists every balance-sheet account that needs support. For each account you upload its supporting schedule or reconciliation and record the total it supports. AI compares that support total to the trial-balance balance, marks the account tied when it's within your threshold, and flags the two failure modes you care about: no support uploaded and a tie-out difference. A running dashboard shows the percent of the balance sheet that's reconciled, so you always know how close to done you are.

A reviewer works the list, opens each account's support, and signs it off as tied and approved. When every account is sorted — signed off or consciously noted as an exception — the controller approves the complete binder. Only then does the tool produce the deliverables: a binder index (every account, its balance, its support, its status, who signed off and when) and an exceptions list (everything unsupported or out of tie), ready to hand to your reviewer, your CFO, or your auditors as PDF or CSV.

What's inside the Implementation Plan

The plan is a single file you paste into an AI coding agent. It opens by interviewing you about your business — which GL system you run, exactly how your trial balance is shaped, how you tell a balance-sheet account from a P&L account, which accounts actually need support, what "tied" means to you and at what threshold, who prepares versus who reviews, and your messiest exceptions — and then tailors the data model, the tie-out rules, and every later step to your answers. This is a binder built around your close, not a generic template.

From there it walks the agent through the database schema, the trial-balance import with its duplicate guards, file upload into secure Storage, the tie-out engine that compares support to balance and tracks percent reconciled, the reviewer sign-off and controller binder-approval gates, and the export of the binder index and exceptions list. Every step ends with a ready-to-copy prompt. Because the whole thing runs on CSV in and PDF/CSV out, you can build and use it this weekend even with no live connection to your accounting system.

The governance it includes (this is the point)

A close binder is governance, so the tool is built like it matters: login so only your finance team can open it, row-level security so you only ever see your own entity's accounts and files, and a complete audit trail of every import, upload, sign-off, approval, and export — who did what, and when. Files live in access-controlled Storage, never in a public folder. And nothing is "done" on its own: each account stays open until a reviewer signs off that its support ties, and the binder stays in review until the controller approves it — two human-in-the-loop gates, one per role. Duplicate guards on account + period mean the same account can't sneak into a binder twice, and the same trial balance can't be imported twice.

Who it's for

Controllers and accounting managers who own the close and need every balance to be supported, tied, and review-ready before they sign — plus the staff accountants and reviewers who prepare and check the schedules. If you can explain how you decide a balance is properly supported, you can build this.

You've got this — open the plan, paste the first prompt, and let it interview you about your close.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.