How to reconcile payments using virtual bank accounts?

How to reconcile payments using virtual bank accounts?

Follow these steps to reconcile payments using virtual bank accounts:
  1. In Xero, go to the physical bank account
  2. Click 'Reconcile'
  3. Select 'Transfer Money'
  4. Choose the corresponding virtual bank account as the source
  5. Match the transfer amount to the payment received in the bank feed
Reconciliation Checklist
  1. Confirm the physical bank account is fully reconciled
  2. Compare virtual bank balance against outstanding allocations or timing differences
  3. Investigate any discrepancies
  4. Ensure all transfers from virtual to physical bank accounts are correctly posted
NB: Never reconcile deposits in the physical bank accounts directly to invoices or income.

    • Related Articles

    • Why do I need virtual bank accounts?

      Using virtual accounts provides a much more streamlined and accurate way of managing finances within AimyOne and Xero. Overall, they provide a more controlled and reliable workflow for managing payments and accounting. Key benefits include: Automated ...

    • How to set up a virtual bank account?

      This guide explains how to set up a virtual bank account in Xero and correctly link it correctly in AimyOne. Setup in Xero Go to Accounting → Bank Accounts Click Add Bank Account Choose any bank and select “Other” Select “I don’t have online banking ...

    • Payment Report

      The Payment Report displays a list of payments made through the selected payment gateway over a date range. The report can be exported to a Excel file by clicking the 'Export' button located in the top right corner.

    • Unauthorized Pickup Report

      The Unauthorized Pickup Report displays a list of unauthorized pickups linked to a selected site, along with the relevant attendees and accounts. Any custodial arrangements and related notes is displayed in this report as well. The report can be ...

    • New Registration Report

      The New Registration Report displays a list of new accounts registered to a selected site and date range. This report includes information including account name, attendee name, contact details, and date of registration. The report can be exported to ...