Replacing Excel for Lease Accounting: A Migration and First-Close Checklist
Replacing Excel for lease accounting starts with agreeing what your current spreadsheets mean. Before importing data, identify the agreements, assumptions, balances and reports your team relies on. Then test the new process through a representative close.
Spacebase is designed for corporate tenants that need lease administration and accounting to work from the same lease information. It can help with migration, abstraction, configuration and onboarding, but a successful implementation still needs people who can resolve exceptions and approve the result.
Decide what problem the move should solve
Excel is flexible and familiar. A spreadsheet process can be workable when the information is controlled, the requirement is straightforward and the responsible people have enough capacity to maintain it.
The case for changing becomes stronger when updates are difficult to reconcile, current terms are scattered across documents, the close depends on unexplained formulas or several teams keep conflicting versions.
Describe the problem in terms you can check later. For example: “Finance needs a reviewed payment schedule when Real Estate signs an amendment.” That is a better acceptance criterion than “automate everything.”
Build the inventory before the import
| Item | What to establish |
|---|---|
| Lease population | Agreements included, excluded, expired or terminated |
| Documents | Base agreements, schedules, amendments and relevant supporting records |
| Current terms | Approved term, payments, options and other required inputs |
| Accounting assumptions | Policies and judgments approved by the accounting owner |
| Opening position | Balances and schedules reconciled to the agreed reporting date |
| Outputs | Journals, disclosures, supporting reports and entity views |
| Operational work | Critical dates, responsible people and document access |
Give each lease a stable identifier that connects the source documents and accounting record. Decide how an amendment is linked to the agreement it changes. Do not make the import file the only place where that relationship is understood.
Separate missing data from disputed data
A blank field, an ambiguous clause and a difference between two spreadsheets are different issues.
Missing information needs a source or an explicit decision about how it will be obtained. Disputed terms need review by the responsible person. An unexplained balance needs reconciliation; copying it into a new system does not make it correct.
Keep an exception log with the lease, issue, source, owner and resolution. This prevents unresolved assumptions from becoming invisible after import.
Choose a representative test set
Do not test only the simplest agreement. Include the lease types and events that drive your recurring work: a routine office lease, an equipment agreement if relevant, an amendment, a lease approaching a notice decision and an unusual scenario material to the portfolio.
Decide the expected outcome with the accounting and operational owners before the demonstration. This makes it possible to distinguish a software issue from an unresolved source or policy question.
Run the first close in parallel
For the agreed reporting period, prepare the required output from the new process and compare it with the approved baseline.
| Check | Acceptance question |
|---|---|
| Population | Did the intended leases and accounting records make it into the run? |
| Inputs | Can a reviewer find the source and approval for material assumptions? |
| Balances | Are differences explained and accepted? |
| Changes | Does a reviewed amendment affect the appropriate records and outputs? |
| Journals | Do account mappings, entities, dates and totals meet the team's requirements? |
| Reporting | Are the schedules and disclosures needed for the close available? |
| Review | Can another person reconstruct the work without relying on the original preparer? |
Do not force the new system to match a spreadsheet number whose basis nobody can explain. Resolve the reason for a difference and have the accounting owner approve it.
What Spacebase contributes
Lease Accounting supports ASC 842, IFRS 16 and GASB 87 workflows, including schedules, modifications, journal entries, disclosures and audit history. Lease Administration holds documents, amendments, terms, obligations and critical dates.
One underlying lease record can support separate accounting records for different standards without entering the original lease information again. AI-assisted extraction supplies source references for human review before import.
Implementation and specialist services are scoped to the customer. Connections use configured API, SFTP or reports/exports, with separately scoped engineering where needed. Enterprise API access is plan-restricted and cannot create leases. An API should not be assumed to be a bulk lease-creation path.
A real equipment-accounting example
General Glass International replaced more than 30 Excel tabs used for equipment lease accounting with Spacebase. GGI reported approximately 80% less equipment-lease audit time and reducing monthly noncash journal-entry work from one to two hours to about two minutes.
These are GGI's reported results. They provide an accounting example, not a forecast for another company or proof of a migration from a named competitor. Your acceptance test should use your own portfolio and close work.
Retire the old process deliberately
Agree who signs off on balances, documents, operational dates and interfaces. Decide which historical files remain accessible and how they will be labelled so someone does not restart the old process accidentally.
Record the cutover date and responsibilities for the next change and close. If the new system still requires spreadsheet work, document why, who owns it and whether it is part of the agreed design.
Compare the full implementation
Request the cost and responsibility for source collection, data preparation, historical records, configuration, connections, training, parallel reporting and support. Include internal work as well as supplier fees.
You are buying a process the team can maintain, not simply moving rows from one file to another.
Bring a spreadsheet, amendment and current close report to a Spacebase demonstration.
Maggie McLaughlin
Customer Success Manager