Reconcile the operating costs that commercial tenants share at year end. Calculate each tenant's share, then send the amounts due to a charge batch for review.
Before you start
- The property must be commercial. Recovery reconciliation is for commercial properties you manage.
- The period must have ended. Choose only whole months that have ended, up to twelve months.
- At least one lease at the property must have a recovery setup that runs in the period. See Set up commercial recoveries.
- The actual costs come from posted lines on the expense pools' accounts for the property in the period. Set up the expense pools first. They appear under Commercial in the Accounting menu.
- Each lease needs a move-in date and a contracted area. The property needs a total area.
- Your role needs Leasing with Manage access to calculate. To create the batch, your role needs Leasing with Manage access, and your account access must also allow posting.
Steps
- Select Accounting, then Recovery Reconciliation under Commercial.
- Choose the Property.
- Choose the From month and the To month.
- Choose the Post date. It must fall after the period.
- Select Calculate. The reconciliation table shows each tenant's share.
- Review the columns: Operating expense, Base, Over base, Days, % Share, Expense share, Mgmt fee, Net share, Estimate billed, Amount due and Posted.
- If the numbers need to change, select Recalculate. A run that already has a batch cannot be recalculated. Delete the batch first.
- Select Create batch for review. The amounts due go to one charge batch that is not yet posted. Open the batch to review and post it.
Next year's estimates
Use this section to change the estimates that each lease pays through the year.
- Enter the Increase, as a percent from 0 to 100 with up to two decimals.
- Choose the date in New estimates from. It must fall after the period.
- Select Preview to see which leases change.
- Select Update estimates.
Each lease gets a new dated estimate charge from the date you chose. Charges that were already billed stay as they were.
What happens next
- Select Calculate to store the run. The toast "Reconciliation calculated." confirms it. Until you calculate, the page shows "Nothing is stored for this property and period."
- Select Create batch for review to create the charge batch. The toast "Charge batch created." confirms it. The batch is listed as unposted until you post it.
- The batch has a charge on the reconcile charge code for each amount owed. It also has a credit for the estimate charges that the run counted.
- Creating the batch does not post the amounts. You post them from the batch.
- After you post the batch, the run shows the status Posted.
Common problems
- Recovery reconciliation is for commercial properties. Choose a commercial property.
- This period has not ended yet. Choose months that have ended to reconcile them. Choose months that have finished.
- A period is at most twelve months. Shorten the period.
- Check the property, the period (one to twelve whole months) and a post date after the period. Correct the property, the months or the post date.
- No lease at this property has a recovery setup that runs in this period. Set up a recovery on a lease first.
- Another reconciliation of this property already covers part of this period. Choose a period that no other run covers.
- Set the move-in date of {leases} before calculating. Enter the move-in date on each named lease.
- Set the contracted area of {leases} before calculating. Enter the contracted area on each named lease.
- Set the property's total area before calculating. Enter the property's total area.
- This run already has a charge batch, so it is not calculated again. Delete the batch first, then calculate again.
- Nothing is due, so there is no batch to create. No tenant owes or is owed an amount for this run.
Related articles