Property Management · RealPage

How to Do a Daily Bank Reconciliation in RealPage Accounting

Bank reconciliation proves that the cash in a property's bank account agrees with the cash GL account in RealPage. Done daily, it means pulling the bank's activity file, matching each line to a receipt, payment or journal in the ledger, and booking anything that only the bank knows about, such as fees.

Unreconciled items hide errors and, for trust and deposit accounts, can become a compliance problem. This guide follows the routine shown in the recording for one operating account: retrieving the BAI2 file, fixing an unmapped account, importing and auto-matching, booking a bank fee, finalizing at a $0.00 difference and emailing the summary.

  • Who does itProperty accountant / staff accountant, reviewed by the controller
  • How oftenDaily
  • Steps11 steps · 3 systems
  • By hand3 to 18 hours per week

Watch the full workflow

every click in this recording is an AI agent — no one is touching the keyboard.

In the recording, an AI agent signs in to RealPage, opens Financial Suite Accounting for entity 101 - Oakridge Apartments and retrieves the 10/07/2026 BAI2 activity for US Bank ••1842 through the US Bank SinglePoint feed (24 transactions, integrity passed). It maps the one unmapped account (US Bank ••4410 Payroll Clearing) to GL 1010-2000, imports the batch and runs auto-match, which matches 23 of 24 items. It posts a journal entry for the unmatched $75.00 service charge, confirms a $0.00 difference, finalizes reconciliation BR-2026-10-1842 and emails the summary and outstanding-items PDFs to the controller and asset-management teams.

  1. 1:45Retrieve the day's bank activity
  2. 3:03Check for unmapped bank accounts
  3. 3:27Map the missing account
  4. 4:27Import the validated batch
  5. 4:57Run auto-match
  6. 5:21Book a journal entry for the bank-only fee
  7. 6:09Confirm the difference is $0.00
  8. 6:33Review the completion checklist
  9. 7:03Finalize the reconciliation
  10. 8:15Run the reconciliation summary report
  11. 8:45Email the reconciliation package

Systems involved

You need access to each of these before you start. In the recording the agent works in all of them from one desktop, signed in as the user.

  • RealPage Financial Suite - AccountingBank Feed Data, Bank Account Mapping, Imported Bank Activity, Reconciliation Workbench, Reconciliation Review and Reconciliation Summary report
  • US Bank SinglePointSource of the daily BAI2 activity file, retrieved through RealPage's bank connection
  • RealPage report emailSends the reconciliation package to the controller and asset-management teams

What you start with

  • US Bank daily BAI2 activity file
  • RealPage bank account to entity and GL mappings
  • RealPage GL cash activity

What you end with

  • Imported and matched bank batch USB-20261007-1842
  • Journal entry BR-1007-01 for the bank fee
  • Finalized reconciliation BR-2026-10-1842
  • Bank_Reconciliation_Summary_2026-10-07.pdf and Outstanding_Items_2026-10-07.pdf emailed

The workflow at a glance

Action Decision Human review Select a step to jump to how it's done.

  1. 01 Action · RealPage Accounting (Bank Feed Data) Retrieve the day's bank activity
  2. 02 Decision · RealPage Accounting (Bank Account Mapping) Check for unmapped bank accounts Yes All accounts mapped: go straight to import No An account is unmapped: map it first
  3. 03 Action · RealPage Accounting (Bank Account Mapping) Map the missing account
  4. 04 Action · RealPage Accounting (Imported Bank Activity) Import the validated batch
  5. 05 Action · RealPage Accounting (Reconciliation Workbench) Run auto-match
  6. 06 Action · RealPage Accounting (Reconciliation Workbench) Book a journal entry for the bank-only fee
  7. 07 Decision · RealPage Accounting (Reconciliation Workbench) Confirm the difference is $0.00 Yes Difference is $0.00: move to review and finalize No Difference remains: log the unreconciled items with evidence and route for follow-up
  8. 08 · Human review · RealPage Accounting (Reconciliation Review) Review the completion checklist
  9. 09 Action · RealPage Accounting (Reconciliation Review) Finalize the reconciliation
  10. 10 Action · RealPage Accounting (Reports) Run the reconciliation summary report
  11. 11 Action · RealPage report email Email the reconciliation package

Step-by-step: how to do it

  1. Action · RealPage Accounting (Bank Feed Data) · 1:45 in the video

    Retrieve the day's bank activity

    Go to Accounting > Bank Reconciliation > Bank Feed Data. Pick the bank account and date range, choose BAI2 as the format and click Retrieve Activity. Check that every transaction parsed, the control total is present and the integrity check passed.

    In the video
    Entity
    101 - Oakridge Apartments
    Account
    US Bank ••1842 Operating Cash
    Date
    10/07/2026
    File
    US_BANK_20261007.BAI2
    Parsed
    24 of 24
    Deposits
    $184,620.42
    Withdrawals
    $96,874.19
    Control total
    $281,494.61
    Integrity
    Passed

  2. Decision · RealPage Accounting (Bank Account Mapping) · 3:03 in the video

    Check for unmapped bank accounts

    Open Bank Account Mapping and review each bank account's RealPage entity and GL cash account. Any account showing Unmapped must be mapped before you import, or its activity has nowhere to land.

    • If yes All accounts mapped: go straight to import
    • If no An account is unmapped: map it first
    In the video

    3 source accounts.

    • ••1842 Operating Cash Mapped
      GL
      1010-0000
    • ••9275 Security Deposit Mapped
      GL
      1010-1000
    • US Bank ••4410 Payroll Clearing Unmapped

  3. Action · RealPage Accounting (Bank Account Mapping) · 3:27 in the video

    Map the missing account

    Click Map Account, choose the property entity, the GL cash account and the import format, add a description and click Save Mapping. Confirm no unmapped accounts remain.

    In the video
    Account
    US Bank ••4410
    Entity
    101 - Oakridge Apartments
    GL
    1010-2000 Payroll Clearing Cash
    Format
    BAI2
    Result
    All 3 bank accounts mapped

  4. Action · RealPage Accounting (Imported Bank Activity) · 4:27 in the video

    Import the validated batch

    Select the retrieved batch and click Import Selected Batch. Confirm the import completed with no exceptions and that RealPage's imported totals equal the bank file totals.

    In the video
    Batch
    USB-20261007-1842
    Imported
    24 of 24
    Deposits
    $184,620.42
    Withdrawals
    $96,874.19
    Exceptions
    0
    Totals
    Source and RealPage totals agree

  5. Action · RealPage Accounting (Reconciliation Workbench) · 4:57 in the video

    Run auto-match

    Open the Reconciliation Workbench for the account and click Run Auto-Match. Review what matched to which receipt, payment or payroll batch, and list every bank line left unmatched.

    In the video
    Statement ending
    $1,482,736.28
    GL 1010-0000
    $1,482,661.28
    Difference
    $75.00
    Matched
    23 of 24
    • Resident ACH deposits Matched
      Amount
      $96,480.42
      Match
      Cash receipts batch CR-1007
    • AP-BATCH-391 Matched
      Amount
      $52,711.89
      Match
      AP-1007
    • Payroll Matched
      Amount
      $43,812.30
      Match
      PR-1020
    • US Bank service charge Unmatched · no GL record
      Amount
      $75.00

  6. Action · RealPage Accounting (Reconciliation Workbench) · 5:21 in the video

    Book a journal entry for the bank-only fee

    On the unmatched line click Create Journal Entry. Choose the entity, use the statement date, pick the bank fees expense GL, write a clear memo, then Post and Match.

    In the video
    Date
    10/07/2026
    GL
    6105-0000 Bank Fees and Service Charges
    Memo
    US Bank service charge - October 7
    JE
    BR-1007-01
    Matched
    24 of 24
    Difference
    $0.00

  7. Decision · RealPage Accounting (Reconciliation Workbench) · 6:09 in the video

    Confirm the difference is $0.00

    Compare the statement balance to the GL balance. Only a zero difference moves to finalization; anything else is logged with evidence and routed for follow-up.

    • If yes Difference is $0.00: move to review and finalize
    • If no Difference remains: log the unreconciled items with evidence and route for follow-up
    In the video

    Difference equals $0.00, proceed to finalization

  8. Human review · RealPage Accounting (Reconciliation Review) · 6:33 in the video

    Review the completion checklist

    Before finalizing, confirm the source file is retained with its control total, all bank activity is matched, any journal entry is posted, and statement and GL balances agree.

    In the video
    • Source US_BANK_20261007.BAI2 control total $281,494.61 verified
    • 23 automatic matches + 1 journal match complete
    • JE BR-1007-01 posted
    • Difference $0.00 balanced

  9. Action · RealPage Accounting (Reconciliation Review) · 7:03 in the video

    Finalize the reconciliation

    Click Finalize Reconciliation, enter a finalization note and confirm. Finalizing locks the matched items and keeps the source batch, matching evidence and journal entry in the record.

    In the video
    Reconciliation
    BR-2026-10-1842
    Account
    US Bank ••1842
    Statement
    10/07/2026
    Difference
    $0.00
    Note
    Balanced reconciliation reviewed and ready for reporting

  10. Action · RealPage Accounting (Reports) · 8:15 in the video

    Run the reconciliation summary report

    Open the reconciliation summary report, select entity, bank account, period and as-of date, and view it. Check that the roll-forward from beginning to ending balance foots and that unreconciled is zero.

    In the video

    RPT-BR-20261007-1842

    Beginning
    $1,395,065.05
    Deposits
    + $184,620.42
    Checks/debits
    - $96,874.19
    Service charge
    - $75.00
    Ending
    $1,482,736.28
    Matched
    24 of 24
    Unreconciled
    $0.00

  11. Action · RealPage report email · 8:45 in the video

    Email the reconciliation package

    Click Email, confirm recipients, subject and the PDF attachments, then send. Keep the sent confirmation with the reconciliation.

    In the video
    To
    Controller Team and Asset Management
    Subject
    Daily Bank Reconciliation Summary - Oakridge Apartments - 10/07/2026
    Attachments
    Bank_Reconciliation_Summary_2026-10-07.pdf and Outstanding_Items_2026-10-07.pdf (0 items)
    Message ID
    RP-EMAIL-20261007-1921

Rules, exceptions and controls

Rules to follow

  • Every bank account must be mapped to a RealPage entity and GL cash account before its activity is imported
  • Bank file control totals and RealPage import totals must agree
  • Bank-only items such as fees are booked by journal entry dated to the statement, not left as reconciling items
  • Only a $0.00-difference reconciliation is finalized
  • Finalizing locks matched items and keeps the source batch, evidence and journal entry

When something doesn't match

  • Unmapped bank account (US Bank ••4410 Payroll Clearing): mapped to GL 1010-2000 before import
  • Bank service charge with no GL record ($75.00): journal entry to 6105-0000 Bank Fees and Service Charges
  • Difference not zero: unreconciled items logged with evidence and routed for follow-up instead of finalizing

Controls and audit trail

  • Integrity and control-total check on the bank file
  • Import totals tied to source totals
  • Completion checklist reviewed before finalization
  • Finalization note and locked audit record
  • Report package emailed to controllers and asset management with a message ID

Practitioner tips

  • Old reconciling items are a warning sign: a difference carried for months is one nobody researched.
  • Expect the time to go to the few lines that do not match, such as duplicate lockbox batches, NSF reversals, bank fees or unrecorded distributions.
  • Write journal memos that name the bank and date so the entry is easy to trace back to the statement line.
  • Check account mapping whenever a new bank account is opened; an unmapped account silently drops activity.

About this recording

In the recording, an AI agent reconciled the Oakridge Apartments US Bank operating account end to end in RealPage, from retrieving the BAI2 file through mapping, matching, the fee journal entry, finalization and emailing the report package.

Documented the way you'd train a new hire — and the same way an agent learns it.

See it on your workflow

Frequently asked questions

How do you do a bank reconciliation in RealPage Accounting?

Retrieve or import the bank activity for the account, make sure the account is mapped to the right entity and GL cash account, run auto-match in the Reconciliation Workbench, resolve unmatched items, and finalize once the difference is $0.00.

How do I record a bank service charge during reconciliation in RealPage?

From the unmatched bank line, create a journal entry to the bank fees expense GL dated to the statement with a clear memo, then post and match it so the difference clears.

Why do bank accounts need to be mapped in RealPage?

Mapping tells RealPage which property entity and GL cash account each bank account belongs to; an unmapped account's activity cannot be imported and reconciled correctly.

What is a BAI2 file?

BAI2 is a standard bank reporting format for daily account activity. In the workflow shown, RealPage retrieves the US Bank BAI2 file and checks its control totals before import.

Can an AI agent do bank reconciliation in RealPage?

Yes. As shown in the video, the agent works the same RealPage screens a person does: it retrieves the bank file, maps accounts, imports and auto-matches, books the fee entry, finalizes at $0.00 and emails the reports, with a review checklist before finalization.

What happens if the reconciliation does not balance?

It is not finalized. The unreconciled items are logged with supporting evidence and routed for follow-up.

More property management workflows