Month-end close
Month-end close automation for NetSuite and Excel
Every schedule rolled forward. Every area tied to the GL. Cash, prepaids, accruals, leases, fixed assets, payroll and equity, each rolled forward by its own workflow, then reconciled to the trial balance as of one month-end date.
Reported customer result
1 month → 1 day
From rolling each schedule forward to a close reconciled to the general ledger
The work before Billow
Close was a stack of separate workbooks: the bank reconciliation, the prepaid schedule, the accrual roll-forward, leases, the fixed asset schedule, the payroll entry and, every quarter, the equity rollforward. Each one started by copying last month’s file, adding new columns and pasting in fresh data without breaking the formulas. The tie-out to the general ledger could only start once every schedule was done.
How Billow handles it
From the source documents to work your team can review.
- 1
Roll each schedule forward
Each close area runs as its own workflow. Billow reads last month’s workbook, the new source documents and the ERP, then adds the current period next to the prior months. Existing line items, formulas and formatting stay as they were.
- 2
Tie every area to the GL
A reconciliation workflow collects the workbook from each area and reconciles it to the trial balance as of the same month-end date, with live formulas that net to zero. If a workbook is missing, Billow stops and names it instead of filling the gap.
- 3
Review the exceptions
Differences that don’t tie, new items that need coding and entries waiting for approval come to your team with their sources attached. Nothing is posted until someone approves it.
What it covers
Each area is its own workflow, so you can start with one and add the rest.
Cash
Bank reconciliation from statement balance, items in transit and adjusting entries to an agreed book balance.
Prepaids
New prepaids identified from invoices and contract terms, with amortization rolled forward in last month’s workbook.
Accruals
Reversals, additions and balances for the period, including clinical trial accruals.
Leases
Lease schedules rolled forward each month, with a close summary sent to the team.
Fixed assets
Additions and depreciation rolled forward in the fixed asset schedule.
Payroll
Payroll register mapped to departments and GL accounts, drafted as a journal entry in NetSuite for approval.
Equity
Quarterly equity rollforward and stock-based compensation workpaper, with Carta’s expense tied to what was booked.
Reconciliation
One workbook that reconciles cash, prepaids and accruals to the trial balance, every reconciliation tied to zero.
What you get back
- Rolled-forward schedule for each close area
- Reconciliation workbook tied to the trial balance
- Draft journal entries for approval
- Exceptions with their sources
Where your team steps in
Your team approves entries and resolves exceptions. When an input is missing, Billow stops and asks rather than substituting data.