Skip to main content

Bank reconciliation for Stripe & Airbnb

How to reconcile Stripe and Airbnb deposits in VRTrust

Updated over 2 weeks ago

Objective

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

Key Steps

1. Open Bank Reconciliation Page 0:03

  • Navigate to the bank reconciliation page.

  • Click the blue 'Reconcile Items' button.

2. Review Unmatched Bank Records 0:18

  • Check the left column for unmatched bank records from the bank feed.

  • Review the suggested matches in the right column.

3. Create Transactions if No Suggested Match 0:43

  • If there is no suggested match, create a transaction in VRTrust's Accounting Records.

4. Enter Reconciliation Period 1:04

  • Input the reconciliation period under review.

5. Match Airbnb Deposits 1:16

  • Search for all Airbnb deposits in the unmatched bank records column.

  • Select the match button for each Airbnb deposit to reconcile.

6. Match Stripe Transactions 1:35

  • After matching Airbnb deposits, search for and match all Stripe transactions.

7. Check Connection Status 1:44

  • If a transaction lacks a suggested match, verify that both Stripe and Airbnb connections show a green status checkmark.

8. Fetch Missing Transactions 2:01

  • If connections are green, select the ellipses (three dots) next to the connection.

  • Choose 'Fetch Connection', select all types, and set a previous date range to capture missing transactions.

9. Refresh Screen 2:16

  • After fetching, refresh the screen.

  • Look for a yellow status icon indicating transactions are still being fetched.

10. Confirm Fetching Completion 2:27

  • Wait for the green check mark to appear, indicating fetching is complete.

  • Return to the bank reconciliation page to match any remaining deposits.

Cautionary Notes

  • Ensure that all connections are properly set up before starting the reconciliation process.

  • Double-check for any discrepancies after matching transactions.

Tips for Efficiency

  • Regularly check the connection status of Stripe and Airbnb to avoid delays in fetching transactions.

  • Keep a checklist of the steps to streamline the reconciliation process each month.

Did this answer your question?