PRC Rent Collection Tracker — Ghana Edition (Landlord, Excel)

Short Description:

Stop chasing rent manually. Automated tracking with late fee calculations —

works in Excel and Google Sheets. Built for Ghana landlords.

Full Description:

Tracking rent manually means missing late payments, forgetting who owes what,

and having no paper trail when disputes arise. This workbook automates the

math so you can focus on collecting.

What It Automates:

✔ Payment status (Paid / Partial / Unpaid) — updates automatically

✔ Days overdue — calculated from the due date you set per tenant

✔ Late fee — calculates automatically after your grace period expires

✔ Total outstanding per tenant — rent + late fee

✔ Colour coding — green (paid), amber (partial), red (unpaid)

What's Inside:

✔ 7 sheets: Setup · Tenant Register · Rent Roll · Arrears Register ·

 Dashboard · Receipts Log · How to Use

✔ Works in Microsoft Excel AND Google Sheets (full compatibility)

✔ Completely offline — no internet, no cloud, no subscriptions

✔ All your data stays on your computer — fully private

How It Works:

1. Fill the Setup sheet once with your grace period and late fee settings

2. Add your tenants in the Tenant Register

3. Each month, enter payments as they arrive on the Rent Roll

4. Status, days late, and fees calculate automatically

5. Check the Arrears Register for all unpaid accounts

6. Use the Dashboard for a one-page summary

Perfect For:

• Landlords renting out 1–10 units

• Property owners managing multiple tenants

• Anyone struggling to track who paid what

• Landlords who want to calculate late fees fairly and automatically

The Problem This Solves:

Without this tracker, landlords often:

 - Lose track of partial payments

 - Forget when rent is due for each tenant

 - Calculate late fees manually (and inconsistently)

 - Have no proof of arrears if disputes arise

 - Spend hours on spreadsheets each month

This Workbook Gets You:

 - Automatic status updates (no manual cell-filling)

 - Consistent late fee calculations

 - A paper trail for all payments

 - Arrears register (all unpaid accounts at a glance)

 - Dashboard with monthly KPIs

 - Peace of mind that nothing is forgotten

Works In:

✔ Microsoft Excel (Windows & Mac)

✔ Google Sheets (100% compatible — just upload the .xlsx file)

✔ Fully offline — no internet required

✔ Works across devices (Excel desktop, web, mobile)

Produced by Property and Rent Consult.