What would you do here? Real Estate clean up mess.

“`markdown

Navigating a Chaotic Real Estate Clean-Up: What Would You Do?

I recently received an inquiry from a real estate investor in dire need of a financial clean-up for the current year. Her immediate concern is being unable to file taxes due to her disorganized books.

Following a brief 15-minute conversation and a quick review of her accounts, it was clear: her financial records are indeed a mess. Her situation involves three intertwined LLCs:

  • A residential rental real estate company
  • A commercial real estate company
  • An interior renovation company

Fortunately, she maintains separate QuickBooks accounts and bank accounts for each business. However, there have been occasions where funds from one company’s account were used for acquisitions or expenses of another company, primarily to cover payroll or contractor payments. Luckily, she confirms there have been no personal transactions mingled with her business finances.

She revealed that her primary focus is on the residential property LLC as it is the most established and financially active. This is also the sole business she currently seeks help with in terms of clean-up and catch-up, leaving the other two on the back burner for now.

Previously, she outsourced her Bookkeeping to an online Accounting firm based on the west coast but ceased their services at the end of 2023 due to high charges. As of now, her accounts are trailing by about 1,100 transactions.

Here’s where I need your advice: how would you handle such a situation? It’s a complex case, unlike the simpler sole proprietorships or single-member LLCs I’ve dealt with before, given the multiple intertwined businesses.

If I decide to take on this challenge, what would be a reasonable fee to charge? I’m considering somewhere between $5,000 to $10,000.

This situation is undoubtedly intricate. Any suggestions or guidance would be greatly appreciated!
“`

Tags:

Categories:

One response

  1. Handling a messy set of books for a real estate investor with multiple LLCs requires a methodical and strategic approach to ensure accuracy and compliance. Here’s a detailed plan for addressing this challenging situation:

    Steps to Clean Up the Books

    1. Initial Assessment and Scope Clarification
    2. Re-evaluate the Books: Conduct a deeper assessment to understand the full scope of the mess, especially focusing on the rental property LLC first, as that’s currently the priority.
    3. Define the Scope: Clarify with the client that the current focus is on the residential rental LLC, while the other LLCs might require attention later.

    4. Prioritize Compliance

    5. Tax Deadlines Understanding: Confirm the tax filing deadlines and seek to prioritize transactions and reconciliations based on tax implications.
    6. Compliance: Ensure that you adhere to all applicable Accounting standards and tax laws.

    7. Segregate the Transactions

    8. Separate Transactions: Begin by segregating the transactions of the residential rental LLC from the others. Focus on distinguishing intercompany transfers and ensure there are notes or documentation for those transactions.
    9. Record Intercompany Transactions: Clearly categorize and record transactions that involve inter-company payments to understand the cash flow and ensure they don’t affect the individual P&Ls improperly.

    10. Use of QuickBooks

    11. Leverage QuickBooks: Take full advantage of QuickBooks to run reports, segregate accounts, and address discrepancies. This might include setting up rules to automatically categorize future transactions.
    12. Match Bank Records: Cross-reference QuickBooks entries with bank statements to ensure all entries are accurately recorded.

    13. Address Backlog of Transactions

    14. Categorize Transactions: Start categorizing the 1100 backlogged transactions appropriately into income, expenses, intercompany transfers, etc.
    15. Reconcile Monthly: Reconcile bank statements monthly to ensure there is no mismatch.
    16. Focus on High-Impact Entries: Prioritize larger or more complex transactions that have a significant impact on financial statements or tax reporting.

    17. Regular Communication

    18. Regular Updates: Maintain regular communication with the client to report on progress and seek clarification on any ambiguous entries.
    19. Set Expectations: Clearly define the timeline for the cleanup process and convey any issues or delays promptly.

    20. Consider Long-term Structural Changes

    21. Consultation on Intercompany Management:

Leave a Reply