Select customer, choose stage, then click Generate Letter.
Letter Log
Date
Customer
Stage
Type
Amount
Notes
Click Refresh to load log...
➕
Add / Update Customer in Sheets
ℹ This adds the customer to the Customer Tracking tab in Google Sheets so they appear in the Payment Tracker and Letter Generator.
📥
Import Bank Report — Weekly Payments
ℹ Paste your bank report data below. The tool will match customer names, show you a preview, and write every payment row directly to your Payment Log tab in Google Sheets.
Customer Name (Resolved)
Original Name
Date
Week
Amount
Status
🔗
Name Mappings
ℹ When a bank name doesn't match your customer list exactly, add a mapping here. These are saved in this browser session. Add permanent ones in the code.
Unit Directory
–
Total Units
–
Occupied
–
Empty
–
Unavailable
–
Weekly Revenue
Edit Note
Update notes for
Edit Customer
Update details for
Log Letter
Log the letter for to Google Sheets.
Edit Unit —
Changes apply immediately in this session. To make permanent, update the DIRECTORY data and redeploy.