ValixValix

Help Center

Back to Help Center

ReconcilingBankStatementsviatheValixAccountingModule

Objective

Match your actual bank transactions against Valix's internal payment and expense records so your books tie out to your bank statement at month-end.

Prerequisites

  • •You must be signed in as a Manager, Admin, or Master Admin
  • •At least one Bank Account must be configured under Accounting → Bank Accounts
  • •The statement period you want to reconcile must be unlocked (not inside a closed accounting period)
  • •You have a PDF or CSV of the bank statement for the period being reconciled
  • •All tenant payments and vendor payments for the period have been posted to the Valix GL

Step-by-Step Instructions

  1. 1

    Navigate to Accounting → Bank Reconciliation from the left sidebar.

  2. 2

    Click the + New Reconciliation button in the top-right.

  3. 3

    In the Start Reconciliation modal, fill in the following fields:

    • —Bank Account: Select the account you are reconciling.
    • —Statement Start Date and Statement End Date
    • —Beginning Balance: The opening balance from your bank statement.
    • —Ending Balance: The closing balance from your bank statement.
  4. 4

    Click Continue to open the reconciliation workspace.

  5. 5

    Valix will list all uncleared transactions for the period. For each line item on your bank statement:

    • —Find the matching Valix transaction in the list (by amount and date).
    • —Click the checkbox in the Cleared column to mark it reconciled.
  6. 6

    The Difference indicator at the top of the page updates in real time. Your goal is to drive this value to $0.00.

  7. 7

    If you find a bank transaction that has no matching Valix record:

    • —Click + Add Bank Transaction to log a one-off entry (bank fees, interest, NSF returns).
    • —Select the correct GL account (e.g. Bank Fees 6100, Interest Income 4500).
  8. 8

    If you find a Valix transaction that is not on your bank statement, leave it unchecked — it will carry forward to the next period.

  9. 9

    Once the Difference reaches $0.00, click Complete Reconciliation.

  10. 10

    Valix locks the reconciled transactions and generates a Bank Reconciliation Report that you can export as PDF.

Troubleshooting Tips

Pro Tip:Reconcile monthly, ideally within 5 business days of receiving your statement. Small discrepancies are much easier to track down while transactions are fresh.
Note:Valix automatically suggests matches based on amount, date (±3 days), and reference number. Review suggested matches before accepting — especially for round-dollar amounts like $1,000.00 that may conflict.
Note:If the Complete Reconciliation button is greyed out, the statement period may overlap with a closed accounting period. An Admin must temporarily unlock the period via Accounting → Period Close.
Note:If you use Stripe for rent collection, each Stripe payout may batch multiple tenant payments. Expand the Stripe deposit line to see the individual charges and match them to the underlying Valix payments.
Note:A $0.01 difference almost always indicates a rounding discrepancy in a partial payment or a CAM distribution.

Related Articles