GlassJar Accounting Software

Year-End Accounting Migration Without Breaking Reconciliation

Ryan Joneson Avatar

|

9

Min. Read

Explore Tips & Resources


Try GlassJar
For $0

african american female bookkeeper

“Biggest game changer since QuickBooks.”

Felt diorama of a relay race baton exchange, two runners in the exchange zone with the baton mid transfer between their outstretched hands, a stadium crowd behind and a trackside barrier banner reading JAN 1.

Migrate on January 1, not in December. A clean year-end cutover gives you one complete year in the old system and one in the new, so reconciliation, prior-year comparatives and your tax return all tie without manual stitching. Everything below protects that date.

This guide is only about timing. For the mechanics of exporting data, mapping the chart of accounts and validating what landed, read our companion piece on how to migrate accounting software without data loss. This one deals with what actually causes year-end pain, which is the wrong cutover date.

Why the cutover date decides how hard this is

A migration does not break reconciliation. A badly placed cutover date does.

Reconciliation works because every cleared transaction has a match on a bank statement and your ledger balance equals the statement balance plus or minus timing differences. Annual reporting works because twelve months of activity sit in one set of books.

Move partway through a year and you break both. One bank statement now has transactions in two ledgers, and your income statement exists as two partial files someone adds together by hand. Nothing is lost, but everything needs explaining.

What a December migration actually costs you

Prior-year comparatives stop being automatic. Every statement your accountant produces shows the current period against the same period last year. That is how anyone spots a cost line that has drifted or a margin that has slipped. A system starting December 1 has no prior-year detail behind it, so for your first full year the comparative column is blank or sits there as a single imported lump sum. You can drill into this year and not last year.

You get two sets of year-end adjustments. Depreciation, accruals, prepayments and closing journals have to land somewhere. If December sits in the new system and January through November sits in the old one, those entries adjust a trial balance holding one month of activity, which is not the trial balance anyone reviewed.

December is the worst month to learn software. It is also when contractor reporting data gets pulled together and staff are thinnest. If you must buy in December, set the new system up but keep posting December transactions in the old one, then switch posting on January 1. You get the setup time without splitting the year.

Carrying opening balances so the trial balance ties

You are not importing history. You are importing the closing trial balance of the old system at December 31, entered into the new system as an opening journal. Done properly, the new system’s balance sheet on January 1 is identical to the old one’s at December 31.

  1. Close the old year first. Reconcile every bank and card account through December 31, clear suspense and undeposited funds, and let your accountant post closing journals. Migrating an open year means chasing a moving target.
  2. Export the final trial balance. Every account with its debit or credit balance, summing to zero.
  3. Enter it as one opening journal. Retained earnings absorbs all prior-year profit and loss, so income and expense accounts open at zero. If they do not, you have imported history you did not mean to.
  4. Load open sub-ledger detail separately. Receivables and payables need line-level detail, not a lump sum, because you have to apply a payment to a specific invoice from last year. Load unpaid invoices and bills individually and agree their totals to the control accounts.
  5. Prove it. Run a balance sheet in the new system dated January 1 and compare it line by line against December 31. Our free balance sheet template holds both sets side by side, and the income statement template does the same for the prior-year figures you will be quoting all year. Keep that comparison as evidence.

Also list uncleared items. Checks written in December that have not cleared, and deposits in transit, belong to the old reconciliation but clear against a January statement in the new system. Record them first, or your first reconciliation will be short by exactly their value.

Transactions that straddle the cutover

A clean date does not remove these. It makes them countable.

Unpaid invoices and bills. Load as open items at original dates and amounts. The revenue or expense already hit last year, so the opening journal must not recognize it again. You are importing the receivable, not the sale.

Deposits in transit and uncleared checks. Already inside the opening cash balance. When they clear, match them without creating an entry.

Recurring transactions. Rebuild the schedules before January 1 and switch the old ones off on December 31. The wrong order gives you a gap or a duplicate, and the duplicate is harder to find.

Prepayments and accruals spanning the year. An annual premium paid in October covers months on both sides. The prepaid asset carries over in the opening balance and the amortization journals get rebuilt.

Payroll. Change the posting destination on the first run of the new year, not mid-quarter, so quarterly filings reconcile to one ledger.

Keep read-only access for a full tax cycle

Do not cancel the old subscription in January. Keep read-only access until the return for that final year is filed and accepted, then keep it a little longer. For a calendar-year business that is roughly fourteen months past the cutover, because your accountant will be pulling detail out of the old system the whole time. Amended returns, a notice, a lender asking for prior-year detail: all of it sends you back.

Most vendors offer a read-only tier cheaper than a live seat, so ask before you cancel. Reactivation afterwards is often impossible and retention windows are shorter than people assume. Export and store locally regardless: general ledger detail, the trial balance, year-end statements, reconciliation reports, aging detail and PDFs of invoices and bills.

The 1099 complication nobody plans for

Contractor reporting is a calendar-year obligation that belongs to you as the payer, and it does not care which software you were using when you cut the check.

Migrate on January 1 and this is simple, because every payment in the old year was made in the old system and you file from that data.

Migrate mid-year and payments to one contractor sit in two systems, which have to be combined before you can tell whether anyone crossed the reporting threshold. For payments made in 2026, Form 1099-NEC is required at $2,000 or more, raised from the long-standing $600 by legislation enacted in 2025 and indexed for inflation after 2026. A contractor paid $1,200 in the old system and $1,100 in the new one is at $2,300 and needs a form. Neither system knows that alone. The deadline is January 31 for both the recipient copy and the IRS copy, which leaves no room to reconstruct split-year totals.

So pull a year-to-date vendor payment report on cutover day, store it with the migration file, and carry contractor year-to-date totals into the new system as reference data.

Many small business accounting systems do not generate 1099 forms at all, so check rather than assume. QuickBooks Online handles 1099 preparation and e-filing in the product, filing services such as Track1099 and Tax1099 work from a spreadsheet export, and payroll providers like Gusto cover contractors alongside employees. Decide which you are using before January.

FAQ

Can I switch accounting software in the middle of the year?

Yes, but you take on manual work a January cutover avoids. You will add two partial-year files together for every annual report, and prior-year comparatives stay incomplete for a full reporting cycle. If the current system is actively failing you, that cost is worth paying.

How do I make sure my opening balances are right in new accounting software?

Enter the old system’s closing trial balance as one journal, load open receivables and payables line by line rather than as totals, then run a balance sheet on day one and compare it against the old system’s final balance sheet. If every line agrees and income and expense accounts sit at zero, you are correct.

Will my accountant be able to see last year’s numbers after I migrate?

Only if you keep access to the old system or export the detail first. Opening balances carry forward a position, not a history, so transaction-level detail does not come with them. Give your accountant read-only access plus saved exports of the general ledger and trial balance.

How long should I keep the old accounting system running?

Through a full tax cycle, which for a calendar-year business means roughly fourteen months past the cutover. Keep it until the final return is filed and accepted, and ask whether the vendor has a cheaper read-only tier.

What happens to 1099s if I change accounting software mid-year?

You combine contractor payment totals from both systems yourself, because neither sees the other’s payments. For 2026 payments the 1099-NEC threshold is $2,000, so a contractor below it in each system separately can still cross it in total. File from the combined figure by January 31.

Do I need to re-reconcile my bank accounts after migrating?

No, if you reconciled fully through December 31 and your opening cash balance matches. Your first reconciliation covers January only. The usual cause of a first-month break is December checks and deposits in transit, which already sit inside the opening balance and should be matched without a new entry.

Pick the date, then the software

Choose the cutover date first, work backwards to the setup window, and only then let the software decision drive anything. A good product migrated in December causes more trouble than an adequate one migrated on January 1.

If you are still evaluating, GlassJar is one option among several. It is small business accounting software with a 14 day free trial and no card required, so a November test on a copy of your data is easy to run before committing. Plans start at $59 a month for one user. It does not generate 1099 forms, and it does not do payroll or sales tax filing, so plan all three separately.

Whatever you choose, the date protects your reconciliation. The rest is setup.

Last Updated:

Explore More Insights