Group the expense accounts a commercial tenant pays back into pools, add a recovery setup for each cost type on a commercial lease, and reconcile a period's actual costs against the estimates billed.
Before you start
- The workspace needs an active commercial property, and your role needs core accounting access. The COMMERCIAL menu group appears once both are in place.
- Recovery Reconciliation also needs access to the leasing plugin. Without it, the item does not appear under COMMERCIAL.
- Expense pools need Settings with Manage access to add, edit or delete. Without it, you see "You need workspace settings access to change expense pools."
- Recovery setups need Leasing with Manage access. The reconciliation also checks that you can access the lease's property.
- For a per-area amount, set the lease's contracted area first. Without it, you see "Set the lease's contracted area in its settings to charge per sq ft."
- You need a charge code for the monthly estimate and another for the annual reconciliation. The two codes must differ.
Steps
Add an expense pool
- Select Accounting, then the COMMERCIAL group, then Expense Pools.
- Select Add New. The dialog is titled Add expense pool.
- Enter the Name. It is required and can be up to 100 characters. Enter a Description if you want one, up to 500 characters.
- Enter the Fixed gross-up % if part of the pool should never gross up. Leave it empty otherwise.
- In the accounts table, choose an Expense account and its Type appears beside it. Select Add Row to add more accounts. An account can appear only once in a pool.
- Select Save. The page shows "Expense pool saved."
To change a pool, select Edit on its row. To delete a pool, select Delete on its row, then select Delete pool in the dialog. The Used by column shows how many recovery setups use each pool.
A new workspace starts with four default pools, built from its starter chart of accounts.
Read a lease's contracted area
- Open the commercial lease and select Settings, then Contracted Area.
- The page shows the contracted area and its dated history. Each change is dated, and it must fall on or after the change before it.
Add a recovery setup to a lease
- Open the commercial lease and select the Recovery Setup tab.
- Select Add Recovery Setup. The dialog is titled Add recovery setup.
- Under Monthly estimate charge, choose the Charge code, the Amount type (Flat amount or Amount per area), the Amount period (Monthly or Annual) and the Amount.
- Under Annual reconciliation, choose the Expense pool and the Reconcile code.
- Under Share, enter a Share or a Fixed prorata share % (override), and choose the Denominator (Total, Occupied or Leased). A typed share overrides the calculated share.
- Under Base, fee and limits, enter a Base amount or a Base year, and optionally the Admin fee %, its Admin fee type, a Cap, a Cap year, a Cap increase % per year and a Minimum.
- Under Gross-up, enter the Gross-up % if the lease has a gross-up clause.
- Enter the From and To dates, and the Notes if you want them.
- Select Save.
Estimates post with Monthly Posting from the From date. Earlier months of the setup are billed by hand on the estimate charge code. The reconciliation counts them.
To stop a setup, select End on its row. In the dialog, choose the Last day and select End setup. Its monthly estimate stops the day after the last day. Charges already posted stay.
Reconcile a period
- Select Accounting, then the COMMERCIAL group, then Recovery Reconciliation.
- Choose the Property, the From month and the To month. Select Display to see what is stored, or Calculate to work out the amounts.
- Review the worksheet. Its status reads Calculated. It shows each tenant's Expense share, the Estimate billed and the Amount due.
- Select Create batch for review. The status changes to Batch created. The batch holds the reconciliation's charges, on each setup's reconcile charge code.
- The batch card on the reconciliation shows the batch number and its status. Post the batch from Charge Batches. When it posts, the status reads Posted.
You can reconcile a period only after it has ended.
What happens next
- Saving a recovery setup creates its monthly estimate. Changes apply to future charges and reconciliations only. Charges already on the ledger stay as they are.
- Creating the batch does not post it. Posting the batch from Charge Batches books its charges to the lease ledger.
- The Next year's estimates panel adds a new dated estimate charge to each lease from the date you choose. Enter the Increase and New estimates from, select Preview, then select Update estimates. Charges already billed stay as they were.
Common problems
- Pool in use. The message ends "use this pool in a recovery setup. Change or end those setups before deleting it." The message names the leases that use the pool. Change or end those setups first, then delete the pool.
- Accounts recovered twice. The message says the accounts would be recovered twice on the named leases, because another setup uses a pool with the same account over the same dates. Change the dates, or remove the account from one of the pools.
- Someone else changed this expense pool. Refresh the page and try again. Refresh the page, check the pool, then save again.
- You need workspace settings access to change expense pools. Ask a member with workspace settings access to make the change.
- Recovery Setup and Contracted Area show "not found" on a residential lease. These pages apply only to commercial leases.
Related articles