FREE TEMPLATE / RENTAL RECORDS
A simple rent ledger.
Every payment accounted for.
Download a free rental payment ledger template for Excel, Google Sheets, or other spreadsheet programs. Track charges, money actually received, and the receipt or record supporting each entry. Built for independent rental owners, including Georgia landlords.
Need to keep receipt photos with individual payment entries? Try the free mobile rent payment log . It stores records locally, with optional encrypted backup; it does not sync between devices.
No signup, email submission or payment required. The CSV contains three clearly marked fictional examples; delete those rows before you start.
Need more than a basic ledger? Compare the free CSV with the $29 Casebook
WHAT IT HELPS YOU TRACK
Clear numbers.
Traceable records.
This starter spreadsheet separates rent and other charges from actual payments or credits. It also leaves space to identify a source document such as a receipt, bank confirmation, or signed lease. Keeping source references in the same row makes later reconciliation less dependent on memory.
Use this template for administration and basic arithmetic, not as a determination of what is legally owed or collectible. Verify every line against original records.
What's inside the free CSV
- Transaction date and charge amount
- Payment or credit amount recorded separately
- Description and payment method
- Receipt or source-reference ID
- Applicable rent period and notes
Open the downloaded file in Excel or import it to Google Sheets. Remove the sample rows, then record each transaction on its own dated line. Retain your source documents separately and keep the references consistent.
FICTIONAL EXAMPLE
What three entries can tell you
Imagine a monthly charge of $1,900. A $900 payment is received on November 4 and a $600 payment on November 15. Those entries show an arithmetic difference of $400, before other verified charges, credits, or adjustments. A promised installment is not a payment until received.
| Date | Entry | Charge | Received | Source |
|---|---|---|---|---|
| Nov 1 | Monthly charge | $1,900 | — | L-001 |
| Nov 4 | Partial payment | — | $900 | P-001 |
| Nov 15 | Partial payment | — | $600 | P-002 |
This is only a fictional accounting illustration. It does not determine a collectible balance, legal rights, notice requirements, or any court outcome.
BETTER HABITS FOR RENTAL RECORDS
Three ways to keep
your ledger useful.
Record receipt dates, not promised dates. Track a promised future installment in your notes or a separate schedule; only post a payment when confirmed.
Attach a source reference. Retain receipts, statements, deposit confirmations or other original evidence in a secure folder, then assign each transaction a source ID.
Reconcile regularly. Compare your ledger to bank records and lease terms, resolve unclear transactions, and keep a dated correction history rather than silently overwriting figures.
For more detailed examples, read our free rent-ledger guide and partial-payment tracking guide.
WHEN ONE SPREADSHEET ISN'T ENOUGH
Move from a ledger to an organized case file.
The free CSV is a simple starting point. The $29 Georgia Rental Casebook adds a reconciliation workbook, offline studio, field guide, quick-start instructions and editable professional-review handoff brief. It's a one-time digital purchase, not a subscription.
Administrative tools only. Not legal advice, court representation, legal document preparation or guaranteed results.
Review all features and purchase terms before buying.
COMMON QUESTIONS
Before you download
Is this template really free?
Yes. You can download the basic CSV, open it in a spreadsheet program and use it without a signup or payment.
Will my tenant data be uploaded to Z-Signature?
No. The static CSV file downloads to your device. Any later storage or sharing depends on the spreadsheet app and account you choose. Avoid including unnecessary sensitive personal information.
Does this spreadsheet calculate late fees or legal balances?
No. It records basic transactions and their source references. Late-fee applicability, deductions, notice obligations and legal recoverability depend on facts and law; seek qualified advice where needed.