How to Use the Trial Balance Report for Month-End Reconciliation
As part of your month-end reconciliation process, the Trial Balance Report helps you confirm that your account balances align with your accounting configuration and that all journal entries are properly balanced.
This article explains how to run the Trial Balance Report in VRTrust, what to review, and how to troubleshoot issues.
What Is the Trial Balance Report?
The Trial Balance Report provides a summary view of your general ledger activity for a selected date range.
It acts as a pivot table of the General Ledger Detail Report and displays:
Account name (from your chart of accounts)
Starting balance
Ending balance
Total debits
Total credits
Account classification
This report is a key tool for validating that your books are balanced before closing the month.
Note: If your team has an operating account connected, you'll also see a Book filter on this report. This lets you run the Trial Balance for Trust only, Operating only, or both combined.
1. Navigate to the Trial Balance Report
Go to Reports
Select Trial Balance
Choose the appropriate date range for the period you are reviewing.
2. Run the Trial Balance for the Correct Period
For month-end reconciliation:
Run the report for the entire month
Example:
If your VRTrust Go-Live date is December 1, run the Trial Balance for December 1–December 31
This ensures you are reviewing only activity recorded within VRTrust.
3. Confirm Journal Entries Are Balanced
To verify that all journal entries are balanced:
Check that:
Total Starting Balance = 0
Total Ending Balance = 0
This confirms that total debits equal total credits across all accounts.
Note: Because every journal entry balances by ledger, a single-ledger Trial Balance (Book filter set to Trust only, or Operating only) will also foot to zero on its own. You don't need to run "both" to get a balanced check. If you filter to one ledger and it doesn't zero out, that points to an issue specific to that ledger (or an unexpected cross-ledger posting) rather than the books as a whole.
4. Validate First-Month Starting Balances
In your first month using VRTrust, you should also confirm that:
All starting balances for accounts are zero
There are no general ledger entries dated before your VRTrust start date
This applies separately to each ledger: your Trust-ledger Go-Live date and your Operating-ledger Opening Date (if OPEX is enabled) may differ, so check starting balances against the correct date for each Book filter.
This ensures that:
Opening balances were recorded correctly
No transactions exist outside your intended accounting period
5. Use Filters to Review Account Balances
At the top of the report, you can filter accounts by:
Book
Trust, Operating, or both. Hidden until an operating account is connected; until then the report always runs Trust-only.
Date
Users can select a specific date, date range, or dates from a preset range such as: Last 7 days, Last 30 days, Last Month, Last 12 Months, calendar years (ex: 2026, 2025).
Classification
Account type
Party (owner, vendor, property manager)
Zero-balance accounts (toggle to hide them)
These filters help you focus on specific areas of your chart of accounts during review.
6. Drill Into Account Activity
To review the journal entries behind an account balance:
Click the arrow to the left of the account name
View all journal entries contributing to:
Debit totals
Credit totals
This is useful for identifying unexpected activity or tracing discrepancies. Each journal entry line shown will also carry its Ledger tag, so you can confirm it's posting to the Book you expect.
Step 7: Export the Trial Balance
To download the report:
Click the Export icon
Download the file as a CSV
⚠️ The exported file will reflect any filters applied at the time of export.
What to Do If Balances Are Not Zero
If:
Total starting balances are not zero, or
Total ending balances are not zero
Reach out for support via the in-app chat assistant — it can resolve most issues directly, and if not, it will create a support ticket for you.
We don't have live phone or chat agents; tickets receive a reply in this conversation, typically within a few business hours during our support window (Mon–Fri, 8am–6pm ET). More about how we support you.
Summary
The Trial Balance Report is a critical month-end tool that helps you:
Confirm debits and credits are balanced (overall, and by ledger if OPEX is enabled)
Validate correct Go-Live (and Operating Opening Date) setup
Identify unexpected or misdated entries
Support accurate, audit-ready accounting
Reviewing this report monthly ensures your VRTrust accounting stays clean, consistent, and reliable.
Related Help Articles