Real Estate Investment Accountant – Clean Books & Deal-Level Reporting

I’m a real estate investor buying fractional interests in properties in Texas, often with tax foreclosures pending. I’m looking for an experienced accountant who can clean up my books and set up an accounting system that allows me to produce detailed property-level and business-level profitability reports, plus investor-quality schedules. My goal: clean, reliable books that make it easy to generate the type of reports outlined below (P&L / balance sheet / cash flow, deal inventory, track record, forward scenarios, capital stack, investor materials). My current data sources Chase checking account Chase credit card Payoneer Ramp corporate card Upwork (contractor payments) A set of historical financial statements and other supporting files (not fully cleaned or consistent) You should be comfortable pulling, cleaning, and reconciling data from these sources and mapping them into a clear chart of accounts. Core outcomes I want the books to support Clean historical financials (last 24–36 months) Monthly P&L, balance sheet, and cash flow that tie out across all accounts Clear view of fixed overhead run rate (salaries/ops, legal, tech, marketing, etc.) Debt schedule showing lenders, balances, interest rates, accruals, and payments Capital accounts by partner (contributions, distributions, profit allocations) Deal inventory – book value vs. mark-to-market Full list of all open deals with address, ownership %, status (pre-judgment / post-judgment / under contract) Book cost per deal: taxes, deed purchases, legal, capitalized interest, other capitalized costs Management fair value estimate per deal Unrealized gain/(loss) per deal and in total Tie total book cost back to “investments in properties/deeds” on the balance sheet Summary of total book value vs total estimated fair value Track record & unit economics (realized deals only) Realized deals table: capital in, proceeds out, net profit, holding period, MOIC, IRR Totals and averages across the portfolio Generic deal unit economics: typical capital required, exit price, expenses, profit Unlevered and levered returns (using current funding costs) ️ Ability to run sensitivities for a realistic loss rate (e.g., 5% capital lost on bad deals) Forward-looking scenarios & self-funding analysis (supporting the model) Books and schedules organized in a way that a modeller can build: ◽ 2–3 growth cases (e.g., 10 / 15 / 20 deals per month) ◽ Projections of capital deployed, overhead/legal/ops, interest costs, and cash from exits ◽ Identification of “self-funding month” (exits cover overhead + capital costs + loss reserve) ◽ Peak external capital needed to reach that point ️ Capital stack & use of proceeds (accounting support) Clear picture of equity vs. debt/high-yield credit currently in the business Ability to support a “target structure” (e.g., raise $X equity at Y% ownership, plus debt) Clean tracking of how new capital is used: refinancing existing lenders, funding pipeline, loss/contingency reserves Investor materials & data room (input from accounting) Historical financials organized and reconciled Deal inventory and realized deals tables exported cleanly A well-structured chart of accounts and schedules that plug into a forecast model and investor deck Note: I’m not expecting you to design the slide deck itself, but your work should make it easy for me (and/or a modeller) to build these materials. Scope of work Rebuild and clean 24–36 months of historical books so they are audit-ready and investor-friendly Design or refine the chart of accounts to support both property-level and business-level profitability ️ Set up tags, classes, projects, or entities (depending on the software) so each property/deal has its own P&L and roll-up Reconcile all banks, credit cards, and platforms listed above Produce monthly P&L, balance sheet, and cash flow statements that tie together cleanly Create supporting schedules: overhead breakdown, debt schedule, capital accounts, deal inventory, realized deals Prepare exports/templates that can feed into financial models and investor decks If you have strong modeling skills as well (MOIC/IRR, scenario analysis), that’s a plus, but the core requirement is reliable accounting and structure. ️ Tools / systems I am open on the accounting system (QuickBooks Online, Xero, or similar). I’m looking for your recommendation on the best stack for: multi-deal tracking, partner capital accounts, and reporting. Please mention what system you prefer and why. ✅ Ideal freelancer Strong background in accounting for real estate investments, private lending, funds, or similar deal-based businesses Experience with property-level and portfolio-level reporting Comfortable building and maintaining schedules for capital accounts, debt, and deal inventory Very detail-oriented and rigorous about reconciliations ️ Good communicator who can explain what you’ve set up so my team and I can maintain it going forward Available to do an initial cleanup project and possibly ongoing monthly work if we’re a good fit ✉️ When you apply, please include: A short description of your relevant experience (especially with real estate or investment-style accounting) Examples of similar reporting or structures you’ve built (you can redact sensitive info) Which accounting software you recommend and why Your estimated timeline to clean up 24–36 months of books and set up the needed schedules Your hourly rate and a rough estimate of total hours for the initial cleanup To help me filter out bots, please start your proposal with the word “Ledger”. Apply tot his job Apply To this Job