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
