Who this article is for: Accounting partners who ran reservation and trust activity through QuickBooks Online (QBO) under VRPlatform/VRIntegrations, and are migrating a team to VRTrust.
When a team goes live on VRTrust, VRTrust becomes the system of record for trust and guest activity going forward. But your legacy QBO connection may have already posted reservation invoices, commission/management fee bills, and payout journals dated on or after your Go-Live date — since VRP creates these ahead of the stay, not on it.
Left in QBO, that activity duplicates what VRTrust now tracks and makes your trust balance impossible to reconcile.
This guide walks through using an AI assistant connected to QBO to find and remove those future-dated invoices and bills, then close out what's left of the related guest deposits with a journal entry to Trust Liabilities.
Why this cleanup matters
Reservation invoices and fee bills that VRP already posted to QBO don't disappear on their own once you go live on VRTrust — they sit in QBO representing guest activity that's now also being tracked in VRTrust.
That duplication is what breaks reconciliation: your QBO trust balance and your VRTrust Trust Reconciliation Report won't agree while both systems claim the same guest activity.
Deleting an invoice on its own isn't the end of it — any deposit or payment that was applied to it becomes unapplied in QBO. That leftover balance needs to land somewhere, which is what the journal entry in Step 4 is for.
This article covers the trust-related reservation invoices, fee bills, and the guest deposit balances tied to them. It's one part of a broader QBO wind-down that also typically includes reassigning products/services off the accounts you're retiring and deactivating chart-of-accounts entries you no longer need — talk to your VRP contact if you'd like help scoping the full transition.
Before you begin
Confirm your VRTrust Go-Live date — every deletion and journal entry in this guide is anchored to it. See Go-Live Planning in VRTrust if you haven't finalized one.
Make sure the legacy VRP → QBO connection is disconnected (or paused) so it stops posting new invoices and bills while you're cleaning up.
Deletions in QBO can't be undone. Before you delete anything, export or otherwise note what you're removing — a saved report of invoices and bills dated on or after Go-Live is enough.
Step 1: Connect an AI assistant to QuickBooks Online
Most AI assistants (Claude, ChatGPT, and others) can connect to QBO through a QuickBooks MCP (Model Context Protocol) connector. This is separate from — and in addition to — the VRTrust MCP described in Connect an AI Assistant Using VRTrust MCP; it talks to QuickBooks directly, not to VRTrust.
A few options exist, ranging from Intuit's own developer-oriented server to hosted, no-code connectors where you just sign in with your QBO credentials and choose read/write access. If you're not sure which fits your setup, ask your VRP contact.
Only grant write access to the QBO company file you intend to clean up, and treat every delete action the same way you'd treat it if you were doing it yourself — review before you confirm.
Step 2: Find invoices and bills dated after your Go-Live date
Ask your assistant to list every invoice and bill with a transaction date on or after Go-Live, for example:
List every invoice and bill in QuickBooks with a transaction date on or after [Go-Live date].
Review the list before deleting anything. Confirm it's limited to trust-related activity — reservation invoices and the commission/management fee bills tied to them — using the class or location VRP tagged them with. Leave out anything unrelated to trust or reservation activity, like ordinary operating bills that have nothing to do with the migration.
Step 3: Delete the invoices and bills
Once you've confirmed the list, ask your assistant to delete each one, for example:
Delete these invoices and bills: [list].
Confirm each deletion rather than approving a bulk action blind — most QBO connectors will prompt you before writing anything.
Note: Deleting an invoice doesn't delete the deposit or payment that was applied to it — it unapplies that payment. That's expected. You'll clear the leftover balance in the next step.
Step 4: Journal the remaining balance to Trust Liabilities
After you delete the invoices, any advance deposits or guest payments that were applied to them are still sitting in QBO, now unapplied. That balance needs to move to a liability account, tagged by customer and class, since VRTrust is what will track and report it as a Guest Balance going forward.
For each customer/listing combination with a remaining balance, record a journal entry:
Debit the account currently holding the balance (commonly Undeposited Funds or the applicable Accounts Receivable account)
Credit Trust Liabilities
Tag both lines with the guest (Customer) and the listing (Class), so the entry ties back to the reservation it came from
Your assistant can help draft these, for example:
For each customer with an unapplied balance left from the invoices we just deleted, draft a journal entry crediting Trust Liabilities and debiting [account], tagged with that customer and their listing class.
Review every entry before you approve it. Accuracy here is what keeps this reconcilable later — not speed.
This is the same idea as reviewing advance deposits when you set opening balances in VRTrust (see Edit opening balances, add taxes payable, and review advanced deposits) — you're doing the equivalent here on the QBO side, for whatever wasn't yet resolved as of your Go-Live date.
What's next
Once QBO reflects only pre-Go-Live activity, VRTrust is solely responsible for guest balances, advance deposits, and trust reporting going forward. From here, review your Trust Reconciliation Report in VRTrust to confirm everything ties out.
Related Help Articles
Have questions about your specific QBO setup?
Reach out to our support team and we'll help you work through it.
