Real finance work on Panes
Three years of files.
One October close.
An agent picks up September’s close workbook and management deck. It imports October’s ledger, resolves a new account, reconciles the statements, and updates the presentation in real Excel and PowerPoint.
A shared drive with history.
37 monthly closes, September 2023 through September 2026. The model follows a regional commercial HVAC group through seasonal demand, an acquisition, and a department reorganization.
Alder Mechanical / Finance
FY2023September–December · 4 closes
00 Planning / Board budget · July reforecast
Each month /
- 01 ERP exports / GL detail · Trial balance
- 02 Subledgers / AP aging · AR aging · Payroll · Bank recs
- 04 Close and review / Excel close model · Management deck
FY2024January–December · 12 closes
00 Planning / Board budget · July reforecast
Each month /
- 01 ERP exports / GL detail · Trial balance
- 02 Subledgers / AP aging · AR aging · Payroll · Bank recs
- 04 Close and review / Excel close model · Management deck
FY2025January–December · 12 closes
00 Planning / Board budget · July reforecast
Each month /
- 01 ERP exports / GL detail · Trial balance
- 02 Subledgers / AP aging · AR aging · Payroll · Bank recs
- 04 Close and review / Excel close model · Management deck
FY2026January–September · 9 closes
00 Planning / Board budget · July reforecast
09 Sep /
- 01 ERP exports / GL detail · Trial balance
- 02 Subledgers / AP aging · AR aging · Payroll · Bank recs
- 04 Close and review / Excel close model · Management deck
06 Jun / Review trail / Superseded pack · Restatement bridge
10 Oct / New source exports · Close instructions
The files carry the changes a team has to live with: a new entity, old and new department names, a payroll account migration, hidden legacy tabs, reviewed versions, a restated warranty reserve, and a February 2026 deck refresh. Supporting history starts in 2022 for prior-year and trailing comparisons.
October, all the way through.
- Roll the existing model forward. Preserve September. Import October’s GL and trial balance; carry the schedules and reporting history into a new close file.
- Resolve the exceptions. Map new account 6265 for third-party warranty callouts. Review the $24,600 field-payroll accrual true-up against the close journal.
- Refresh the analysis. Entity and department P&Ls, balance sheet, cash flow, budget and reforecast, prior year, trailing 12, YTD, KPIs, and flux commentary.
- Update the management deck. Roll September’s presentation into October with refreshed editable charts, tables, and commentary. Leave both files ready for the finance team.
The numbers have to tie.
All 319 Office and CSV files open in desktop Excel or PowerPoint. Every workbook control passes, with no formula errors. The independent validator reconstructs the statements from the source exports. It checks balanced journals and trial balances, month-to-month continuity, retained earnings at year-end, intercompany eliminations, and the bank, payroll, AP, and AR reconciliations.
The workbook keeps its formulas: SUMIFS, INDEX/MATCH, named ranges, and structured tables. Current-month reporting flows from the ledger through the account mapping. The checks tab makes differences visible before the pack is delivered.
Read the validation resultsOpen the work.
The completed model, supporting schedules, and check tab.
Six slides with editable charts and embedded data.
Give your agent the desktop.
Panes gives your agent a Windows computer with the actual apps and existing files. Connect through MCP or the SDKs, run commands in the signed-in desktop, and open the viewer to watch or take over.