Skip to main content

πŸ“˜ External GL Workflow: How to Map Accounts for PM Statement Sync (VRTrust β†’ QuickBooks/Xero)

When syncing data from VRTrust to QuickBooks, the simplest approach is simply posting the PM Statement to QBO

Updated this week

Overview

When syncing data from VRTrust to QuickBooks, you should only push the PM Statement, not full trust activity.


πŸ”§ Key Mapping Rule

Inside your integration settings:

βœ… Manager Activity: Revenue & Expense Accounts

  • Map to actual QuickBooks accounts

🚫 All Other Accounts (Owner & Manager Activity)

  • Map to a single offset account:
    ➀ β€œDue From Trust”


πŸ”„ How It Works

When the PM Statement is posted:

  • Revenue and expenses β†’ Proper P&L accounts

  • Offset β†’ Due From Trust


πŸ’‘ Example

Account Type

Mapping

Rental Revenue

Rental Income (QB)

Cleaning Expense

Cleaning Expense

Owner Payable

Due From Trust

Trust Accounts

Due From Trust

When you transfer cash from the Trust to Operations for you PM balance due, receive the cash with an offset to the "Due from Trust" account


βœ… Result

  • Clean P&L in QuickBooks

  • Single balancing line: Due From Trust

  • No duplication of trust accounting entries


🧠 Why This Approach Works

  • Keeps QuickBooks focused on:

    • Operating performance (PM business)

  • Keeps VRTrust focused on:

    • Trust accounting + owner balances

  • Eliminates reconciliation headaches

Did this answer your question?