Initial data setup

Entering a real portfolio in the right order, and the decisions to make before the first invoice.

1. Enter data in this order

Each record requires the one above it. Entering them out of order means going back to reassign things by hand.

#CreateBecause
1AreasBuildings group into them for reporting
2BuildingsEverything else lives inside one
3FloorsFloor is required on the room form
4RoomsLeases are signed against rooms
5BedsOnly if you rent per person
6ServicesInvoice lines come from these
7Usage tiersOnly for banded electricity or water
8MetersRequired before a metered service can bill
9Payment accountsRequired on every receipt
10Transaction typesRequired on every receipt line
11DocumentsNeeded to print or send anything
12Roles and UsersBefore staff start entering data
13Tenants and LeasesOnly once all of the above exists

2. Decisions to make before the first invoice

These are painful to change once invoices exist:

  • Beds or rooms. Once a room has active beds, the bed field becomes required on leases, invoices and bookings.
  • How shared meters are split. Changing the rule later does not recalculate issued invoices.
  • The due date rule. Changing it mid-month leaves the month with two conventions.
  • Your transaction type list. Renaming a type changes past reports.

3. Moving an existing portfolio

  1. Pick a cut-over date

    One date, announced to the team.

  2. Start leases from the cut-over, not the original signature date

    A lease starting in the past generates invoices for months you already collected by hand.

  3. Enter opening meter indexes

    So the first invoice charges one period, not a year.

  4. Enter outstanding balances as opening invoices

    So Outstanding balances is true from day one.

  5. Enter deposits you already hold

    So they can be refunded correctly later. See Deposits.

  6. Stop maintaining the old spreadsheet

    On the cut-over date.

Running both systems for a month guarantees they disagree and nobody knows which is right.

Última actualización