{"id":147497,"date":"2023-03-16T13:39:02","date_gmt":"2023-03-16T19:39:02","guid":{"rendered":"https:\/\/www.biggerpockets.com\/blog\/?p=147497"},"modified":"2023-08-10T14:07:26","modified_gmt":"2023-08-10T20:07:26","slug":"rent-ledger","status":"publish","type":"post","link":"https:\/\/www.biggerpockets.com\/blog\/rent-ledger","title":{"rendered":"What Is A Rent Ledger And Why Do You Need One?"},"content":{"rendered":"\n\n      <iframe loading=\"lazy\" frameborder=\"0\" height=\"200\" scrolling=\"no\" src=\"https:\/\/playlist.megaphone.fm\/?e=BIGPOC9322405262\" width=\"100%\"><\/iframe>\r\n  \n\n\n\n\n<p>Managing rental properties is a complex task, especially when it comes to keeping track of which tenants are paying on time and who has outstanding balances. If you\u2019re not maintaining an accurate paper trail and organizing your finances, your investment property can quickly become your greatest nightmare.<\/p>\n\n\n\n<p>A rent ledger is invaluable for property managers, landlords, and accountants, as it makes your life much easier when paying taxes and settling landlord and tenant disputes.&nbsp;<\/p>\n\n\n\n<p>In this article, we\u2019ll discuss what a rent ledger is, how to create one, and the many benefits of having one.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What is a Rent Ledger and Why is it Important?<\/h2>\n\n\n\n<p>A rent ledger keeps a record of monthly rent payments and the charges and balances of each of your tenants. Whether you have one rental unit or 100, maintaining a rent ledger is crucial for property managers and real estate investors because it helps them quickly identify each tenant\u2019s rent payment status. In business terms, your rent ledger is like your accounts payable and accounts receivable ledgers.&nbsp;<\/p>\n\n\n\n<p>Your rent ledger also identifies the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Payment history<\/li>\n\n\n\n<li>Outstanding balances (if any)<\/li>\n\n\n\n<li>Any late fees<\/li>\n<\/ul>\n\n\n\n<p>When examining a rent ledger, you\u2019ll see what you should be collecting and how much you\u2019re owed from tenants who aren\u2019t paying their rent. You can also identify patterns, such as late or missed payments, and address them to the tenant if needed.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Who Can Benefit From Using a Rent Ledger?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Landlords and property owners<\/h3>\n\n\n\n<p>Landlords and property owners use rent ledgers to track payments and identify the amount of rent they\u2019re owed (if any).&nbsp;<\/p>\n\n\n\n<p>Also, rent ledgers can keep track of security deposits. As a landlord, you\u2019re responsible for protecting your tenant\u2019s security deposit and can\u2019t use them for personal expenses. If you mix your business funds with a tenant\u2019s security deposit check, you\u2019re&nbsp;<a target=\"_blank\" href=\"https:\/\/www.biggerpockets.com\/blog\/commingling\" rel=\"noreferrer noopener\">commingling<\/a>, which is illegal.&nbsp;<\/p>\n\n\n\n<p>Rent ledgers are also very handy when you\u2019re trying to sell a property. Your ledger documents the property\u2019s income potential, which will help buyers decide whether or not they want to go through with the transaction.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Tenants<\/h3>\n\n\n\n<p>Rent ledgers help tenants keep track of when they\u2019re paid rent and what they owe. If they\u2019re also getting&nbsp;<a target=\"_blank\" href=\"https:\/\/www.biggerpockets.com\/blog\/why-landlords-use-rent-receipts\" rel=\"noreferrer noopener\">rental receipts<\/a>&nbsp;from their landlord, they can compare the information on the receipts with that of the ledger to ensure the information is accurate. If it isn\u2019t, the landlord can update it as needed.&nbsp;<\/p>\n\n\n\n<p>Rent ledgers also offer tenants a paper trail in case they ever have to dispute rent payments or risk eviction.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Real estate investors<\/h3>\n\n\n\n<p>Like landlords and property owners, real estate investors use rent ledgers to identify how profitable their investments are. This information helps them calculate their&nbsp;<a target=\"_blank\" href=\"https:\/\/www.biggerpockets.com\/glossary\/return-on-investment-roi\" rel=\"noreferrer noopener\">return on investment<\/a>&nbsp;(ROI) and&nbsp;<a target=\"_blank\" href=\"https:\/\/www.biggerpockets.com\/blog\/internal-rate-return-irr\" rel=\"noreferrer noopener\">internal rate of return<\/a>&nbsp;(IRR) to determine the value of their investment. If it\u2019s not as much as you thought it would be, you can make an action plan to increase these values.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Lenders<\/h3>\n\n\n\n<p>Rent ledgers help lenders identify a property\u2019s net operating income (NOI), which is how much leftover cash you have after collecting rent and paying for operating expenses. Similarly, the ledger shows lenders a property\u2019s vacancy rates. If an apartment complex has 50 units and five vacant units, the vacancy rate is 10%.<\/p>\n\n\n\n<p>Also, a rent ledger can identify a property\u2019s&nbsp;<a target=\"_blank\" href=\"https:\/\/www.omnicalculator.com\/finance\/dscr\" rel=\"noreferrer noopener\">debt service coverage ratio<\/a>&nbsp;(DSCR). The DSCR compares a property\u2019s monthly mortgage payment to its NOI to identify the owner\u2019s cash flow after the mortgage payment of operating expenses has been paid. Typically, lenders look for a DSCR of 1.20 or greater.&nbsp;<\/p>\n\n\n\n<p>Let\u2019s say your fourplex generates a gross monthly income of $6,000 and has no vacancies. The NOI of the property is $1,200, and then the mortgage payment is $3,000. Your DSCR is ($6,000 &#8211; $1,200) \/ $3,000, or 1.6.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Home buyers and sellers<\/h3>\n\n\n\n<p>Rent ledgers give buyers insights into how much revenue a property is making. They can use this to calculate their projected ROI and\/or IRR and decide whether or not the property is worth buying.&nbsp;<\/p>\n\n\n\n<p>Similarly, sellers can use this information to determine their property\u2019s fair market value. This information can also help them identify opportunities to improve their NOI or DSCR, making their property more desirable to buyers.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Benefits of Having a Rent Ledger<\/h2>\n\n\n\n<p>To recap, here are the many ways having a rent ledger can benefit you:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Keep track of rental payments and security deposits<\/li>\n\n\n\n<li>Identify problem areas or patterns<\/li>\n\n\n\n<li>Aid in rental or eviction disputes<\/li>\n\n\n\n<li>Realize new opportunities to improve your ROI, IRR, NOI, and DSCR<\/li>\n\n\n\n<li>Determine a property\u2019s fair market value<\/li>\n\n\n\n<li>Determine whether a property is worth buying or selling<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">How to Make a Rent Ledger<\/h2>\n\n\n\n<p>Rent ledgers can include a lot of information. Many landlords and investors use a&nbsp;<a target=\"_blank\" href=\"https:\/\/www.biggerpockets.com\/blog\/due-diligence-avoid-bad-deal\" rel=\"noreferrer noopener\">rental ledger template<\/a>&nbsp;to keep it simple.<\/p>\n\n\n\n<p>Creating a rent ledger template is pretty simple. Start by filling out the essential information regarding your property. You should include the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Property owner\u2019s name<\/li>\n\n\n\n<li>&nbsp;Property address<\/li>\n\n\n\n<li>&nbsp;Type of property<\/li>\n\n\n\n<li>&nbsp;Lot size<\/li>\n\n\n\n<li>&nbsp;Zoning of use<\/li>\n\n\n\n<li>&nbsp;Date of report<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"170\" src=\"https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-16-at-3.34.12-PM.png\" alt=\"rent ledger spreadsheet\" class=\"wp-image-147654\" title=\"\" srcset=\"https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-16-at-3.34.12-PM.png 783w, https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-16-at-3.34.12-PM-300x65.png 300w, https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-16-at-3.34.12-PM-768x167.png 768w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><\/figure>\n\n\n\n<p>Next, fill out all the information regarding a specific unit of your property, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tenant name<\/li>\n\n\n\n<li>&nbsp;Tenant\u2019s address<\/li>\n\n\n\n<li>&nbsp;Square footage of the property<\/li>\n\n\n\n<li>&nbsp;Number of bedrooms and baths<\/li>\n\n\n\n<li>&nbsp;Lease start date<\/li>\n\n\n\n<li>&nbsp;Lease end date<\/li>\n\n\n\n<li>&nbsp;Monthly rent payment&nbsp;<\/li>\n\n\n\n<li>&nbsp;Additional rent (e.g., parking, storage, etc.)<\/li>\n\n\n\n<li>&nbsp;Rent due date<\/li>\n\n\n\n<li>&nbsp;Paid date<\/li>\n\n\n\n<li>&nbsp;Security deposit<\/li>\n\n\n\n<li>&nbsp;Additional notes<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"357\" height=\"320\" src=\"https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-16-at-3.34.29-PM.png\" alt=\"rent ledger spreadsheet\" class=\"wp-image-147655\" title=\"\" srcset=\"https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-16-at-3.34.29-PM.png 357w, https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-16-at-3.34.29-PM-300x269.png 300w\" sizes=\"auto, (max-width: 357px) 100vw, 357px\" \/><\/figure>\n\n\n\n<p>Finally, print and sign your name at the bottom of the ledger:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"347\" height=\"57\" src=\"https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-16-at-3.34.43-PM.png\" alt=\"rent ledger spreadsheet\" class=\"wp-image-147656\" title=\"\" srcset=\"https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-16-at-3.34.43-PM.png 347w, https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-16-at-3.34.43-PM-300x49.png 300w, https:\/\/www.biggerpockets.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-16-at-3.34.43-PM-340x57.png 340w\" sizes=\"auto, (max-width: 347px) 100vw, 347px\" \/><\/figure>\n\n\n\n<p>Regularly update your rent ledger to ensure your information is accurate.&nbsp;<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"<p>Managing rental properties is a complex task, especially when it comes to keeping track of which tenants are paying on time and who has outstanding balances. If you\u2019re not maintaining [&hellip;]<\/p>\n","protected":false},"author":613625,"featured_media":147553,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5183,7119],"tags":[],"class_list":["post-147497","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-landlording","category-biggerpockets-daily"],"acf":[],"comment_count":0,"_links":{"self":[{"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/posts\/147497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/users\/613625"}],"replies":[{"embeddable":true,"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/comments?post=147497"}],"version-history":[{"count":0,"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/posts\/147497\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/media\/147553"}],"wp:attachment":[{"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/media?parent=147497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/categories?post=147497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/tags?post=147497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}