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
