Skip to main content

Daily/Monthly General Ledger Data Summary Workflow

Sync GL summary data from VRTrust into external accounting systems

Updated yesterday

VRTrust allows you to automatically push general ledger (GL) data into external accounting systems like QuickBooks Online or Sage Intacct. This keeps your accounting workflows aligned with fewer manual steps.

This article will cover how this workflow is set up with QuickBooks Online.

Where to Find the GL Sync Workflow

To access the workflow:

  1. Go to the Connections page

  2. Select QuickBooks Online

  3. Navigate to the Workflows tab

Here, you’ll see available workflows for syncing data between VRTrust and QuickBooks.

For more details on the transfers to bills, or billable expenses workflows, please refer to the corresponding help articles in the Support Center.


Choosing a Sync Method: Daily vs Monthly

VRTrust offers two options for syncing GL data:

Daily Sync

  • Aggregates financial activity by day

  • Sends data to QuickBooks as daily journal entries

Monthly Sync

  • Aggregates all activity for the month

  • Groups data by:

    • Account

    • Listing

    • Party (e.g., owner, property manager)

  • Sends a single summarized journal entry per month

⚠️ Important: Choose either daily or monthly sync—not both.
Running both will result in duplicated data and inaccurate financials.


Configuring the Workflow

To set up your preferred workflow:

  1. Select either Daily or Monthly sync

  2. Click Settings


Map Your Data to QuickBooks

Within the settings, you’ll configure how VRTrust data maps to QuickBooks:

  • Map accounts (e.g., revenue, expenses, liabilities)

  • Map listings

  • Optionally map classes or locations

This mapping ensures that your data is structured correctly when it’s pushed into QuickBooks.

Set Sync Frequency

You can choose to:

  • Run the workflow automatically on a schedule

  • Trigger the sync manually when needed


What Gets Synced?

When the workflow runs, VRTrust compiles your financial activity into clean, summarized journal entries.

These entries may include:

  • Owner billings

  • Property expenses

  • Reimbursements

  • Merchant fees

  • Guest deposits

  • Cleaning fees

  • Rental income

  • Channel commissions

  • Management commissions

  • Transfers between trust and operating accounts


What This Looks Like in QuickBooks

Once synced, QuickBooks will receive a structured journal entry that reflects all activity recorded in VRTrust for the selected period—organized according to your mapping configuration.


Why This Matters

This workflow allows you to:

  • Manage trust accounting entirely within VRTrust

  • Keep your external accounting system accurate and up to date

  • Eliminate duplicate data entry

  • Maintain clean, consistent financial records across systems

Did this answer your question?