
In Progress
Posted
Paid on delivery
I’m putting together a straightforward ledger that lets me record every rent payment for each unit I manage and instantly see who is up to date and who is behind. The file should live either in Excel or Google Sheets—whichever you feel gives the cleanest formulas—and I want it laid out so it is painless for anyone on my team to maintain. Core data • Tenant name, phone / email, and lease start–end dates sit at the top of each tenant’s section. • Below that, a running table lists each scheduled rent date alongside the amount due, the amount received, the payment date, and the resulting balance. Functionality • When I enter a payment, the sheet automatically updates the balance and flags any overdue amounts in red. • A summary view aggregates totals across all tenants so I can see monthly income and outstanding balances at a glance. • Basic protection is applied to formula cells so accidental edits don’t break anything. Deliverables • The finished, unlocked spreadsheet/template. • A brief one-page guide explaining where to input new tenants, how to log payments, and how the alerts work. Acceptance The ledger must handle at least 100 tenants without slowing down, and all formulas should recalculate correctly after duplicating a tenant block for a new lease.
Project ID: 40473393
13 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello, I can create a clean, easy-to-use rent ledger in Excel or Google Sheets that tracks every tenant’s payments and instantly shows who is up to date or overdue. Each tenant section will include contact info, lease dates, and a running table of scheduled rent, amounts received, payment dates, and updated balances. The sheet will automatically update balances when payments are entered and highlight overdue amounts in red. A summary view will show monthly totals and outstanding balances across all tenants. Formula cells will be protected to prevent accidental edits, and the ledger will handle 100+ tenants efficiently. I’ll deliver the unlocked spreadsheet along with a one-page guide showing how to add new tenants, log payments, and understand alerts.
$10 AUD in 1 day
0.0
0.0
13 freelancers are bidding on average $19 AUD for this job

As an experienced Full-Stack Developer with a specific proficiency in PHP, I believe I'm the right fit for your project. Throughout my 10+ years in the field, I have successfully developed numerous web-based solutions including working NFC-based POS Systems for shopping centers and geolocation-driven ERP systems for logistics industries with functionalities similar to what you require. Therefore, I am more than confident in my ability to create and deliver a highly-functional custom rental payment ledger that will streamline your process while catering meticulously to your needs. Given the project description, I can assure you of a clean and user-friendly solution, leveraging either Excel or Google Sheets to ensure ease of use for your team. With large-scale data handling being one of my strengths, rest assured that there will be no slowing down even with up to 100 tenants on the ledger. Plus, meticulous error handling and security measures will be incorporated into the final design to circumvent accidental edits. Finally, a comprehensive one-page user guide will be provided explaining not just where to input new tenants and how to log payments but also how alerts work. My commitment extends beyond just delivering a finished product—I'll ensure that you are well-equipped to maximize its usage. Connect with me today and let's build the perfect solution for your business!
$10 AUD in 2 days
6.9
6.9

With a decade of experience under my belt, I’m confident that I have the skills you need to create this custom rental payment ledger. I’ve worked on a variety of projects, from large-scale applications to data-driven solutions, which means I know how to build complex systems that can handle the load without slowing down - precisely what you need for this project. My proficiency in Laravel and knowledge of SQL databases, like MySQL and PostgreSQL, will ensure the formulas recalculate correctly and smoothly handle 100 tenants. Moreover, my ability to leverage various technologies bodes well for delivering on your specific requests. I am comfortable working with Excel and Google Sheets, proficient in building spreadsheets/templates with clean formulas and applying formula validation to ensure cell integrity. In addition to developing for multiple platforms including WordPress, Wix and React, I’m extremely familiar with Figma which should make for easy communication when turning your vision into code. Finally, as a full-stack developer extending beyond just the coding elements of the role. Not only can I build an impeccable application for you but also provide you a detailed guide on how your team can properly manage it. Working on sites for diverse clients has sharpened my skills in ensuring that even non-technical users can conveniently leverage the systems built. Choose me for this project & let's untangle those rentals.
$25 AUD in 1 day
5.8
5.8

With my proficiency in data management and analysis combined with the fact that I'm an Excel and Google Sheets specialist, I am confident that I can create a custom rental payment ledger to meet your specific requirements. My expertise lies in advanced formatting, cleanup, and organizing data in a way that is efficient and easy to maintain, precisely as you seek for your team. As an added bonus, my dexterity within this project scope caters comfortably to managing large datasets without compromising on performance. Furthermore, my commitment to delivering accurate work paired with my keen eye for detail ensure that not a single rent payment would be overlooked or mismanaged in the ledger. By applying basic protection to the formula cells, I'll also prevent accidental edits from causing any disruption in the functionality of the ledger. Additionally, if any concerns or support is required post-delivery, be assured that I will be there until every query is resolved. In conclusion, hiring me means choosing someone who takes ownership of their work and invests the necessary time and effort into understanding your needs down to the last detail. My goal is to provide you with a tailored, user-friendly rent payment ledger which helps you easily track and manage all rent payments across 100 tenants while maintaining speed and accuracy. Choose me as your freelancer for a seamless experience and excellent results!
$20 AUD in 1 day
5.4
5.4

With over 7 years of experience as an advanced Excel/Google Sheets developer, I believe I am the perfect fit for your project. Throughout my career, I have worked on similar projects that involve data organization, calculations and developing user-friendly interfaces that ensure smooth operations. As a result, I am familiar with creating dynamic templates that automatically update records and highlight any overdue payments, just like you've requested. Thanks
$20 AUD in 1 day
4.2
4.2

Hello, I came across your project and it immediately caught my attention. We went through your project description and it seems like our team is a great fit for this job. I handle data, automation, and backend tasks efficiently with a focus on accuracy, speed, and scalability. Please come over chat and discuss your requirement in a detailed way. Best regards, Khadija Amin freelancer.com/u/khadijaamin9
$15 AUD in 3 days
4.2
4.2

Hi there, I’ll build you a clean, scalable Custom Rental Payment Ledger in either Excel or Google Sheets, whichever gives the cleanest formulas and fastest recalculation for 100+ tenants. Each tenant gets a dedicated section with name, contact, and lease dates, followed by a running table that tracks scheduled rent date, amount due, amount received, payment date, and current balance. The sheet will auto-update balances on payment entry and flag overdue amounts in red. A consolidated, monthly view will summarize total income and outstanding balances across all tenants, with basic protection on formula cells to keep the structure intact during everyday use and while duplicating blocks for new leases. Deliverables include the finished, unlocked template and a concise 1-page guide explaining how to add tenants, log payments, and interpret the alerts. I’ll design it for smooth performance, clear maintenance, and easy handoff to your team. Best regards,
$30 AUD in 1 day
2.3
2.3

Hi There, I can solve your Custom Rental Payment Ledger by delivering an Excel/Google Sheets template with a clean, scalable ledger for each unit, automatic balance updates, and red-flag overdue payments so your team can act quickly. I’ve built similar rent-ledger templates using Google Sheets formulas, data validation, and minimal VBA/Apps Script for automation, ensuring 100+ tenants perform smoothly with fast recalculation when duplicating blocks. For your project, I’ll create a master tenant template, per-tenant blocks with a running payment log (date, amount due/received, balance), a monthly summary, and protected formulas, so the ledger remains reliable yet easy to maintain. Could you share a sample tenant CSV or current layout so I can tailor the migration and identify any specific fields you require for the summary view? Could you share a sample tenant CSV or current layout so I can tailor the migration and identify any specific fields you require for the summary view? Best regards, Chibike
$25 AUD in 3 days
0.0
0.0

Brisbane, Australia
Payment method verified
Member since May 27, 2026
$10-30 AUD
₹12500-37500 INR
$250-750 USD
$250-750 USD
$750-1500 USD
€6-12 EUR / hour
$750-1500 USD
₹1500-12500 INR
₹37500-75000 INR
$2-8 USD / hour
€30-250 EUR
$25-50 USD / hour
₹750-1250 INR / hour
£750-1500 GBP
₹750-1250 INR / hour
$750-1500 CAD
₹750-1250 INR / hour
$250-750 USD
$15-25 CAD / hour
₹600-1500 INR
₹12500-37500 INR