Changing a Bank Account's Opening Balance Date (VRTrust)
Audience: Property managers and accounting partners using VRTrust who need to correct or adjust the opening balance date on a connected bank account.
What is the opening balance date?
When you set up a bank account in VRTrust, you provide an opening balance date — the date from which VRTrust begins tracking that account's transactions and reconciliation history. This date anchors your reconciliation timeline.
Why can't I edit the opening balance date?
VRTrust locks the opening balance date field once any reconciled (matched) bank transactions exist on the account. This is a safeguard: changing the anchor date after reconciliation has already happened could corrupt your reconciliation history and throw off your running balance.
If you try to edit the field and find it greyed out or non-interactive, it means one or more bank records on that account have already been matched.
How to change the opening balance date
If you need to move the opening balance date — for example, to align with a bank statement cutoff — you'll need to first clear all reconciled records on that account, make the date change, then re-reconcile.
Important: This process involves unmatching all previously reconciled transactions. Consider carefully whether the date change is necessary before proceeding, especially if you have a large number of matched records.
Steps
Navigate to Bank Reconciliation for the account you want to update (Accounting → Bank Reconciliation → select the account).
Unmatch all reconciled transactions. Work through each matched bank record and remove the match. You must unmatch every reconciled transaction before the opening balance date becomes editable.
Once the account shows zero reconciled transactions, return to the bank account settings. The Opening Balance Date field will now be editable.
Update the date to the correct value (e.g., April 30) and save.
Re-reconcile your transactions starting from the new opening balance date.
Things to consider before starting
Volume: If you have many reconciled records (e.g., 100+), unmatching them is a manual process. Factor in the time and effort before proceeding.
Why is the date wrong? If the date was set incorrectly during initial setup, it's worth addressing. If it's a minor discrepancy, confirm whether the change materially affects your reconciliation before unmatching everything.
Re-reconciliation: After updating the date, you'll need to re-match all your transactions from the new anchor date forward. Make sure you have your bank statements handy.
Need help?
If you're unsure whether the date change is necessary, or you'd like guidance on the re-reconciliation process after the change, message us through Intercom and we'll walk you through it.