Prioritise invoices by category when auto-allocating tenant receipts/landlord payments - configuration option

This guide has been reviewed against our global client base and classed as relevant to all regions

Currently when auto-allocating against invoices, a specific priority order is used:

  • for tenant receipts how rent invoices are prioritised is dependent on configuration

    • Amount matching (default configuration): this looks for an exact match, irrespective of the type of invoice - if there are one/more invoices matching the exact receipt amount, it allocates it to the oldest invoice - failing the above, it looks for permutations of invoices that make up the amount of the invoice

    • Date order configuration: when this configuration is in use, the routines look for an exact match for the receipt amount in any non-rent invoices first - failing this, it then allocates as much as possible to rent invoices, from oldest to newest - for any remaining amount, it falls back to the default behaviour as outlined above

  • for landlord payments monies are allocated in date order

From AgencyCloud 12.130+, configuration options are available for one/both of the above which allow invoices to be prioritised by category - to use this configuration, a priority list needs to be identified

Categories with equal weightings can be classed as the same priority level - in this case, equal categories are grouped in tranches, with priority within a tranche being established using date order

To enable this configuration option, click here to contact Reapit Support

Tenant receipts - example

A category order, such as the one below, could be used:

1. Deposit

2. Rent

3. Deposit deduction and tenant to landlord payment

4. Tenant supplier invoice

5. Tenant fee

Landlord payments - example

A category order, such as the one below, could be used:

1. Landlord tax

2. Reserve funds (to pay works orders/supplier invoices etc.)

3. Nominal letting fee and management fee

4. Landlord supplier invoice

5. All other letting fees

In both examples above, the third priority level consists of two categories

When this applies, priority level 3 will be set up as a tranche - meaning that both categories within the tranche will have equal priority and the order for auto-allocation within the tranche is determined by date

Tranches can be set up at any priority level (not just level 3)

Related articles