Skip to main content

Bank reconciliation for Auto-Posted Deposits

How to Reconcile Auto-Posted Deposits During Bank Reconciliation

Updated over a week ago

Objective

To ensure accurate matching of deposits with bank records during the monthly bank reconciliation process.

Bank Reconciliation for Stripe and Airbnb - Watch Video

Review, Match, and Troubleshoot Deposits in VRTrust

As part of your monthly bank reconciliation, VRTrust automatically extracts deposits from supported merchant processors (such as Stripe, Airbnb, Authorize.net, Lynnbrook, and others) and matches them to your bank feed. This article walks through how to review, match, and troubleshoot those deposits to ensure your reconciliation is complete and accurate.

Overview

  • Deposits from connected merchant processors are automatically generated in VRTrust

  • These deposits should be matched to incoming transactions from your bank feed

  • Proper matching ensures accurate trust balances and clean month-end reporting

Step 1: Open the Bank Reconciliation Page

  1. Navigate to Bank Reconciliation

  2. Click the blue Reconcile Items button

You’ll see two primary columns:

  • Unmatched Bank Records (Left Column)
    Transactions pulled directly from your bank feed that have not yet been reconciled

  • Suggested Matches (Right Column)
    Deposits and expenses already recorded in VRTrust’s Accounting Records
    (These can be reviewed on the Transactions tab)

Step 2: Understand Suggested Matches

  • When a matching transaction already exists in VRTrust, it will appear automatically in the Suggested Matches column

  • When no suggested match appears, it means a corresponding accounting transaction does not yet exist in VRTrust

⚠️ A transaction must exist in VRTrust before it can be reconciled to the bank feed.

Step 3: Match Auto-Posted Deposits

  1. Enter the reconciliation period under review

  2. Search or filter for deposit transactions

  3. Review the Unmatched Bank Records column

Expected Result

  • Each deposit from the bank feed should have a suggested match generated automatically from your connected merchant processors

To Reconcile

  • Click Match next to each suggested match

  • The transaction will be fully reconciled and removed from the unmatched list

Continue matching until all deposit transactions are reconciled.

Step 4: When a Deposit Has No Suggested Match

If a deposit does not show a suggested match:

First: Check Connection Status

  • Navigate to Connections

  • Confirm the relevant merchant processor connection shows a green checkmark

  • A green checkmark indicates the connection is active and syncing

Step 5: Fetch Missing Deposits from Merchant Processors

If the connection is active but deposits are missing:

  1. Navigate to Connections

  2. Click the ellipsis (three dots) next to the merchant processor connection

  3. Select Fetch Connection

  4. Choose:

    • All transaction types

    • A prior date range that includes the missing deposits

  5. Click Fetch Data

Repeat this process for any merchant processor missing deposits.

Step 6: Confirm Fetch Status

  • Yellow status icon → Transactions are still being fetched

  • Green checkmark → Fetch is complete

Once the green checkmark appears:

  1. Refresh the screen

  2. Return to the Bank Reconciliation page

Step 7: Complete the Reconciliation

After fetching:

  • Previously missing deposits should now appear as suggested matches

  • Match the remaining deposits

  • Confirm no auto-posted deposits remain in the unmatched bank records column

Key Takeaways

  • Deposits from connected merchant processors should always be matched to auto-generated transactions in VRTrust

  • Missing matches typically indicate:

    • A fetch is needed, or

    • A connection status issue

  • Always confirm:

    • Green connection status

    • Fetch completion before proceeding

Completing this process ensures your trust account, bank balance, and transaction activity remain fully reconciled.

Did this answer your question?