In this guide 6 sections
Month end suits most businesses because the books close cleanly, while quarter end or year start help when reporting periods matter and a seasonal peak must be avoided. Keep away from your busiest week. Whatever date you choose, set a freeze window, load a final delta of changes, count stock and agree open invoices so trading carries on.
Month end gives the cleanest close
Switching on the first of a month lets the old system close with complete ledgers, and the trial balance, bank reconciliation and stock valuation tie off together. Opening balances can be proved.
The risk is workload. Finance is already busy closing, so the switch competes with accruals, supplier statements and the payroll journal, and you should plan extra hands for those days.
Quarter end and year start suit reporting
A quarter end fits companies that file returns or report to lenders each quarter, because one system then holds the whole period and nobody stitches two sources together. The period stays in one piece. Year start is tidiest for comparatives, depreciation schedules and budgets, yet it is also the busiest time of year for accountants and auditors, so their diaries fill early.
Book them first. Agree in writing who signs the opening balances for each ledger and the bank accounts before the date is announced to staff.
- Month end: easier fallback, smaller scope
- Quarter end: clean period for returns
- Year start: one set of annual figures
- Mid-month: needs two sets of books to reconcile
Seasonal peaks can overrule the calendar
A retailer should not switch the week before a festival sale, a school should avoid admissions, and a distributor with a monthly rebate cycle needs that cycle closed. Mark every peak on the calendar.
Then count back from them. Leave a quiet fortnight on each side of the date, because staff learn a new billing screen far faster when customers are not queuing at the counter.
Use a freeze window and a delta load
Load most data ahead of time, then stop changes to customer, supplier and item records for a short freeze window, and collect anything entered afterwards. Load them as a delta.
Keep a written log of each one. Payroll goes after the pay run, stock goes after the count, open invoices wait for the last statement, and during the freeze staff keep trading on numbered paper slips.
Key them in once live. Agree who approves exceptions during the window, and write that name beside the freeze time so nobody has to guess on the day.
- Freeze date and time for master data
- Stock count date and counters
- Last payroll run on the old system
- Cut-off for open invoices and receipts
- Name of the person who approves go or no-go
Rehearse the switch and keep a fallback
Run the whole cutover once on a copy with a stopwatch in hand, so the rehearsal shows how long the delta load takes and which reconciliation checks fail. Fix those before the real date.
Keep the old system readable for at least one full close, so any opening balance that looks wrong can be traced back to its source ledger. Next step: put three candidate dates on the calendar and test each one against your payroll run, stock count, audit calendar and busiest week.
Cutover date comparison sheet
A single grid with the candidate dates down the side and criteria across: books closed, stock count, open invoices, payroll run, audit calendar, seasonal peak, staff availability. Each cell holds a green, amber or red mark with a short note, and a final column records the decision, the person who made it and the date.
Open a blank worksheet to printQuestions owners ask
Is month end always the best date?
Not always. It suits most businesses, but one with a heavy month-end close may prefer a quiet week after it, so check your own close calendar before committing.
How long should the freeze window be?
As short as the load allows. A rehearsal on a copy shows the real time, so add spare hours for checks and a possible fallback to whatever the stopwatch says.
What is a delta load?
It is the set of records created or changed after the main data load, loaded on cutover day so that the new system starts current.
Can we switch in the middle of a month?
Yes, with a cost. You will reconcile two systems for that month, and reports from the old ledger and the new one must be combined by hand, which makes errors easier to hide.