Guide · Getting started

Moving a mall from spreadsheets to software: a checklist

Moving a mall onto a system is mostly a data job. The software can only be as right as the leases, balances and charges loaded into it. This is the list we work through with an operator before the first invoice is issued.

1. The mall itself

  • Every unit with its number, floor, area and status: leased, vacant, sold or owner-occupied.
  • The owning company of each mall, with its legal name and tax number. Both go on every invoice.
  • Sold units, whose owners pay a maintenance charge rather than rent.

2. Tenants and leases

  • Each tenant’s legal name, trading name, tax registration and contact person.
  • Each lease: start and end dates, rent per period, escalations and their dates, the service-charge basis, any percentage-rent terms, the deposit held, and every renewal or amendment signed since.
  • Leases that have expired while the tenant is still trading. Decide how they will be billed.

3. Money already owed and held

  • Each tenant’s opening balance on the go-live date, agreed against the tenant’s own statement where possible.
  • Post-dated cheques on hand: number, bank, date, amount and the lease each belongs to.
  • Security deposits held, per lease.

4. The books

  • The chart of accounts, and the opening trial balance on the go-live date.
  • The tax settings your accountant uses: VAT, stamp, schedule and withholding tax.
  • Suppliers with open contracts and unpaid bills.

5. Checks before the first invoice

  • The rent roll in the system matches the spreadsheet’s total.
  • Tenants’ opening balances add up to the receivables balance in the books.
  • A preview of the first monthly billing run, read line by line against what the team expected to bill.
  • A handful of tenants checked end to end: lease, invoice, balance and cheques.

6. Choose the cut-over

Pick a go-live date at the start of a month and stop changing the spreadsheets that day. Run the first month’s billing in the system, with the old sheet beside it as a check. After one clean month, the sheet retires.

How we do it with Atriom

When an operator moves to Atriom, we load units, tenants, leases, charges, suppliers, opening balances and the chart of accounts from their spreadsheets, and check the totals before any invoice is issued. Every monthly billing run can be previewed before anything goes out.