Automatic reconciliation of rent payments with your bank statement

The scenario takes a new bank statement, reconciles each payment against tenant and property data and appends to a sheet whatever needs attention.

• Payment reconciliation on its own
• See who paid and who owes
• Mismatches as a separate list
• Results appended to a sheet