{"product_id":"airbnb-owner-trust-ledger","title":"Property Management Trust Account Spreadsheet – Owner Ledger, Reserves, Pass-Through Expenses \u0026 Monthly Reconciliation, Excel, No Canva","description":"\u003cp\u003e\u003cstrong\u003eOwner Funds Trust Ledger\u003c\/strong\u003e is a property management trust account spreadsheet for Excel and Google Sheets. It keeps a separate running balance for every owner you hold money for: payouts in, expenses out, management fees, reserves and owner draws, with the checks you need to prove the bank account matches the ledger at the end of the month.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWhy it is different:\u003c\/strong\u003e an owner statement is the monthly report you send. This workbook is the ledger behind the statement. It tracks each owner's available funds and reserve, flags any owner whose balance goes below zero, checks that every pass-through expense has a receipt and a ledger entry, and reconciles the bank statement to the ledger and to the sum of owner balances.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eNo Canva needed.\u003c\/strong\u003e This is a plain spreadsheet with no macros and no add-ons. Yellow cells are for typing and gray cells hold the formulas. It works in Excel, Google Sheets and Numbers.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eTemplate only, not legal or accounting advice; have a local professional review your set-up.\u003c\/strong\u003e Trust-account rules vary by state, so check the rules that apply to you.\u003c\/p\u003e\n\u003ch3\u003eWhat is inside (7 sheets)\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eOwners\u003c\/strong\u003e - three sample owners with management fee % and reserve target, with room for six.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eLedger\u003c\/strong\u003e - 60 rows (37 filled): date, owner, type (payout in, expense out, management fee, reserve, owner draw), description, reference, amount, effect, suggested fee and a running balance per owner using SUMIFS on the rows above, with an overdrawn flag.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eReserve Balance\u003c\/strong\u003e - reserve target against reserve held for each owner, % funded, status, monthly top-up and a chart.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePass-Through Expenses\u003c\/strong\u003e - receipt number, vendor type, owner, amount and a receipt attached Y or N, with flags for a missing receipt, an expense not in the ledger, a different amount and an approval limit.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMonthly Reconciliation\u003c\/strong\u003e - bank statement balance plus deposits in transit minus outstanding items, compared with the ledger and the owner balances, with an OK or Investigate flag and a six-month log with a chart.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMulti-Owner Summary\u003c\/strong\u003e - payouts, fees charged and due, expenses, draws, reserves, available balance, total held and share for every owner.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRead Me\u003c\/strong\u003e - how to use the workbook and what the colors mean.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSample data (three owners and 37 transactions) is included, so every number, flag and chart shows a real result from the first click. Replace it with your own in about 30 minutes.\u003c\/p\u003e\n\u003ch3\u003eFiles you receive\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eOwner-Funds-Trust-Ledger.xlsx - editable workbook\u003c\/li\u003e\n\u003cli\u003eOwner-Funds-Trust-Ledger.pdf - printable overview of every sheet\u003c\/li\u003e\n\u003cli\u003eSTART-HERE-How-to-Edit.pdf - editing guide for Excel, Google Sheets and Numbers\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eHow it works\u003c\/h3\u003e\n\u003col\u003e\n\u003cli\u003eDownload the ZIP after checkout.\u003c\/li\u003e\n\u003cli\u003eOpen the .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.\u003c\/li\u003e\n\u003cli\u003eList your owners, then add each payout, fee, expense and draw to the Ledger.\u003c\/li\u003e\n\u003cli\u003eAt month end, type the bank statement balance on Monthly Reconciliation and check that it says OK.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003ch3\u003eFAQ\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eDo I need Canva?\u003c\/strong\u003e No, this is an Excel file.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eIs this legal or accounting advice?\u003c\/strong\u003e No. Trust-account rules vary by state, so check the rules that apply to you and ask a local professional to review your set-up.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eCan I use it for one owner?\u003c\/strong\u003e Yes. Keep a single row on the Owners sheet. It also works for several owners at once.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDoes it work in Google Sheets?\u003c\/strong\u003e Yes. Upload the file and open it with Google Sheets. The formulas avoid add-in functions.\u003c\/p\u003e\n\u003cp\u003e\u003cem\u003eLicense:\u003c\/em\u003e personal and single-business use. Please do not resell or redistribute the files. Template only, not legal, tax or financial advice; have a local professional review your numbers. Airbnb, VRBO and Booking.com are trademarks of their respective owners; this product is not affiliated with or endorsed by them.\u003c\/p\u003e","brand":"Welcome Desk Co.","offers":[{"title":"Default Title","offer_id":68054734405884,"sku":"WDC-B9-058","price":4.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0829\/2358\/5788\/files\/owner-trust-ledger__01-hero.jpg?v=1793526461","url":"https:\/\/hello.welcomedeskco.shop\/products\/airbnb-owner-trust-ledger","provider":"Welcome Desk Co.","version":"1.0","type":"link"}