Replacing Excel for Lease Accounting: A Migration and First-Close Checklist

Spreadsheet records, a lease folder and a review checklist leading to an accounting book.

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

ItemWhat to establish
Lease populationAgreements included, excluded, expired or terminated
DocumentsBase agreements, schedules, amendments and relevant supporting records
Current termsApproved term, payments, options and other required inputs
Accounting assumptionsPolicies and judgments approved by the accounting owner
Opening positionBalances and schedules reconciled to the agreed reporting date
OutputsJournals, disclosures, supporting reports and entity views
Operational workCritical 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.

CheckAcceptance question
PopulationDid the intended leases and accounting records make it into the run?
InputsCan a reviewer find the source and approval for material assumptions?
BalancesAre differences explained and accepted?
ChangesDoes a reviewed amendment affect the appropriate records and outputs?
JournalsDo account mappings, entities, dates and totals meet the team's requirements?
ReportingAre the schedules and disclosures needed for the close available?
ReviewCan 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.

Profile picture for Maggie McLaughlin

Maggie McLaughlin

Customer Success Manager

Share this post