Sales Based Reconciliation Workflow

Sales based reconciliation includes administration fees that are additional fees added to the proportional recovery of operating costs added during the reconcile contribution process. These fees are a percentage that can be applied to specific General Ledgers upon which the reconciliation is based and set on the lease charge itself.

Note: The sales based reconciliation feature requires its own license in addition to the standard Property Lease Management license. For more information, contact sales@binarystream.com.

Ensure a system administrator completes the setup tasks:

1. If you have Property Lease Management already setup and are adding the sales based reconciliation feature, generate the number sequence for the Sales reporting number and the Sales reconciliation number.

   If you are installing the complete Property Lease Management with the sales based reconciliation feature as an initial installation, all number sequences are generated at the same time.
   For more information about generating number sequences, see the Microsoft Dynamics 365 for Finance and Operations documentation.

   • Number sequences overview
   • Set up number sequences using a wizard
2. On the Property Lease Management Parameters page, complete the standard setup, and do the following: 
   1. On the General tab,  specify the Reconciliation year, and if needed, select the t the Partial year calculation.
   2. On the Number Sequences tab,  check that the Sales reporting number and Sales reconciliation number have values. If one or both are empty, go back to step 1 to generate the number sequence.
3. On the Charges page, create charges for the sales based reconciliation. These charges have the Charge type set to Sales based.

To use the sales based reconciliation feature for leases, follow this general workflow:

1. Follow the workflow for adding a revenue lease.
2. When adding an sales based charge to the Charges FastTab on the Lease Details page, the Sales based button becomes available.
3. If needed, select the Billing lines button and specify any escalation or abatement for the sales based charge on the Billing Lines page.
4. Select the Sales based button and on the Sales Based page set up the charge calculations for the selected charge.
5. Select Sales based reconciliation > Sales reporting and set up a sales report.
   During the life of the lease, the sales reporting numbers can be added to the report.
6. Use the Sales Based Reconciliation page to reconcile the sales based charges for the leases.
7. After the reconciliation is run, billing lines are created, which can be reviewed on the Billing Lines page.
8. Use the Invoice Creator to generate invoices.