Property Management · RealPage

How to Allocate Payroll to Properties in RealPage

Payroll allocation charges site staff wages, employer payroll taxes and benefits to the properties those people serve, either by direct time worked or by an approved basis such as unit count. In RealPage it ends as a balanced journal entry imported into the General Ledger, one set of lines per property and payroll category.

Getting it wrong misstates every property's operating statement and can bill owners for costs their management agreement does not allow. This guide follows the full routine shown in the recording: retrieving the payroll email, allocating and mapping to GL accounts, running pre-import validation, controller approval, posting and the completion notice.

  • Who does itProperty accountant or payroll accountant, with Corporate Controller approval before posting
  • How oftenEvery pay period
  • Steps11 steps · 4 systems
  • By hand6–25 hours a week depending on headcount

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 finds the ADP 'Payroll Summary & Detail - PPE 10/02/2026' email in the Payroll / Unprocessed folder, saves both attachments to the October import folder and marks the message In Progress. In RealPage Financial Suite it verifies the payroll package (46 employees, 12 properties, $230,798.00), calculates property allocations under rules version 2026.10, maps wages, taxes, benefits and payroll clearing to GL accounts, and generates a 48-line journal CSV that passes pre-import validation. After the Corporate Controller approves batch PAY-20261002, it posts journal GLJ-20261002-4187 to October 2026, exports the confirmation PDF, sends a completion email to accounting leadership and 12 property managers, and moves the source email to Payroll / Completed.

  1. 1:33Find the payroll email
  2. 1:57Save the attachments to the import folder
  3. 2:51Verify the payroll package in RealPage
  4. 3:33Calculate property allocations
  5. 3:57Map payroll categories to GL accounts
  6. 4:39Generate the journal CSV
  7. 5:51Upload the CSV and run pre-import validation
  8. 7:09Controller approves the batch
  9. 7:39Post the approved batch
  10. 8:27Send the completion email
  11. 8:57Archive the source email

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 – General LedgerPayroll Allocation workspace (rules and GL mapping), Import Journal Entries with pre-import validation, Journal Batch Approval and posting
  • Microsoft Outlook (web)Payroll / Unprocessed, Processing and Completed folders; source email, completion email
  • ADP Payroll Services (email sender)Sends the Payroll Summary (XLSX) and Payroll Detail (CSV) files for each pay period
  • Network folder C:\Finance\Payroll_Imports\2026-10Monthly import directory where the payroll attachments are saved

What you start with

  • ADP payroll email with Payroll_Summary_PPE_2026-10-02.xlsx and Payroll_Detail_PPE_2026-10-02.csv
  • Approved property allocation rules (direct time + units, unit count, shared staff), version 2026.10
  • RealPage GL account crosswalk for wages, employer taxes, benefits and payroll clearing

What you end with

  • Payroll_Allocation_PPE_2026-10-02.csv journal import (48 lines)
  • Posted RealPage journal GLJ-20261002-4187 (batch PAY-20261002)
  • RealPage_Batch_Posting_2026-10-07.pdf posting confirmation
  • Completion email to the Accounting Manager, Corporate Controller and 12 property managers

The workflow at a glance

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

  1. 01 Action · Microsoft Outlook Find the payroll email
  2. 02 Action · Microsoft Outlook Save the attachments to the import folder
  3. 03 Action · RealPage Financial Suite – Payroll Allocation Verify the payroll package in RealPage
  4. 04 Action · RealPage Financial Suite – Payroll Allocation Calculate property allocations
  5. 05 Action · RealPage Financial Suite – Payroll Allocation Map payroll categories to GL accounts
  6. 06 Action · RealPage Financial Suite – Payroll Allocation Generate the journal CSV
  7. 07 Decision · RealPage Financial Suite – Import Journal Entries Upload the CSV and run pre-import validation Yes Send the validated batch for controller approval. No Stop and send a pending/error list by email; the allocation stays pending.
  8. 08 · Human review · RealPage Financial Suite – Journal Batch Approval Controller approves the batch
  9. 09 Action · RealPage Financial Suite – Journal Batch Approval Post the approved batch
  10. 10 Action · Microsoft Outlook Send the completion email
  11. 11 Action · Microsoft Outlook Archive the source email

Step-by-step: how to do it

  1. Action · Microsoft Outlook · 1:33 in the video

    Find the payroll email

    Open the shared payroll mailbox, go to Payroll / Unprocessed and search for messages with attachments and 'Payroll Summary' in the subject. Open the message and note the employee count, property count, pay period end date and total to allocate; these are your control figures for the rest of the run.

    In the video

    ADP Payroll Services, 'Payroll Summary & Detail - PPE 10/02/2026'.

    Received
    Oct 7, 2026 7:42 AM
    Employees
    46
    Properties
    12
    Total to allocate
    $230,798.00

  2. Action · Microsoft Outlook · 1:57 in the video

    Save the attachments to the import folder

    Use Save all attachments and choose the current month's payroll import directory. Confirm the number of files saved matches what the email says it contains, then mark the message In Progress (or move it to Processing) so nobody else picks it up.

    In the video
    Folder
    C:\Finance\Payroll_Imports\2026-10\
    • Payroll_Summary_PPE_2026-10-02.xlsx
      Size
      212 KB
    • Payroll_Detail_PPE_2026-10-02.csv
      Size
      96 KB
    • 2 of 2 files match the email control record
    • Message marked In Progress

  3. Action · RealPage Financial Suite – Payroll Allocation · 2:51 in the video

    Verify the payroll package in RealPage

    Sign in to RealPage and open General Ledger > Payroll Allocation. Select the payroll package for the period and confirm its status is Verified and that employees, properties, pay period end and control total match the email.

    In the video
    Package
    PA-20261002
    Portfolio
    Portfolio – All Active Properties
    Period
    October 2026
    Status
    Verified
    Employees
    46
    Properties
    12
    PPE
    10/02/2026
    Control total
    $230,798.00

  4. Action · RealPage Financial Suite – Payroll Allocation · 3:33 in the video

    Calculate property allocations

    Apply the approved allocation rules and click Calculate Allocations. Check that each property uses the right basis (direct time, unit count or shared staff), that the percentages total 100% and that allocated payroll equals the control total to the cent.

    In the video

    Rules version 2026.10, for example:

    • 101 Oakridge Apartments
      Basis
      direct time + units
      Units
      240
      Share
      20.00%
      Amount
      $46,159.60
    • 205 Lakeside Commons
      Basis
      unit count
      Units
      180
      Share
      15.00%
      Amount
      $34,619.70
    • 506 Cedar Ridge
      Basis
      shared staff
      Units
      200
      Share
      16.70%
      Amount
      $38,543.27
    • Total
      Units
      1,200
      Share
      100.00%
      Amount
      $230,798.00

  5. Action · RealPage Financial Suite – Payroll Allocation · 3:57 in the video

    Map payroll categories to GL accounts

    Open the GL Mapping crosswalk and confirm each payroll category points to the correct expense account, with the offset to the payroll clearing liability. Click Validate Journal and confirm every property ID and GL account is active and debits equal credits.

    In the video
    Lines
    48 (12 properties × 4 accounts)
    Property IDs
    12 of 12
    Accounts
    4 of 4
    Difference
    $0.00
    • 6100-0000 · Wages & overtime
      Debit
      $184,500.00
    • 6110-0000 · Employer payroll taxes
      Debit
      $28,675.00
    • 6120-0000 · Benefits
      Debit
      $17,623.00
    • 2100-1000 · Payroll Clearing Liability
      Credit
      $230,798.00

  6. Action · RealPage Financial Suite – Payroll Allocation · 4:39 in the video

    Generate the journal CSV

    Once the journal validates, click Generate CSV to produce the import file. Keep the file name tied to the pay period so it can be traced back to the source payroll.

    In the video

    Payroll_Allocation_PPE_2026-10-02.csv generated

  7. Decision · RealPage Financial Suite – Import Journal Entries · 5:51 in the video

    Upload the CSV and run pre-import validation

    Go to General Ledger > Import Journal Entries, select the CSV, preview the lines and click Run Pre-Import Validation. Review the checks for active properties and accounts, open period, duplicate batch and required fields before going further.

    • If yes Send the validated batch for controller approval.
    • If no Stop and send a pending/error list by email; the allocation stays pending.
    In the video

    Validation passed.

    Lines
    48
    Valid
    48
    Errors
    0
    Debits and credits
    $230,798
    Difference
    $0.00
    Period
    October 2026 open
    Prior batch
    no prior PAY-20261002 batch
    Status
    VALIDATED – NOT POSTED

  8. Human review · RealPage Financial Suite – Journal Batch Approval · 7:09 in the video

    Controller approves the batch

    The controller opens Batch Approval, works through the approval control checklist and clicks Approve Batch, entering their name and an approval note. If the controller rejects, the batch is not posted and the pending list goes out instead.

    In the video
    Batch
    PAY-20261002
    Validation
    VAL-20261007-2204
    Approved by
    Corporate Controller
    Note
    Validated payroll allocation reviewed; approved for posting
    Approval
    APR-20261007-0816

  9. Action · RealPage Financial Suite – Journal Batch Approval · 7:39 in the video

    Post the approved batch

    Click Post Batch, choose the open posting period and confirm Post Approved Batch. Then use Export Confirmation PDF and save it with the payroll files as audit evidence.

    In the video
    Period
    October 2026 – Open
    Journal
    GLJ-20261002-4187
    Posted
    10/07/2026 8:19 AM
    Debits and credits
    $230,798.00
    Report
    RealPage_Batch_Posting_2026-10-07.pdf (214 KB)

  10. Action · Microsoft Outlook · 8:27 in the video

    Send the completion email

    Draft a completion notice to accounting leadership and the property managers with the journal number, total and period, and attach the posting confirmation and allocation summary. Check the attachments open before sending.

    In the video
    Subject
    COMPLETED: RealPage Payroll Allocation - PPE 10/02/2026
    To
    Accounting Manager, Corporate Controller and 12 property managers
    Cc
    Finance Automation Audit
    Attachments
    RealPage_Batch_Posting_2026-10-07.pdf, Payroll_Allocation_Summary_PPE_2026-10-02.xlsx
    Sent
    10/07/2026 8:24 AM

  11. Action · Microsoft Outlook · 8:57 in the video

    Archive the source email

    Move the original payroll email from Payroll / Processing to Payroll / Completed. This closes the run and makes it obvious which pay periods are finished.

    In the video

    Source message moved from Payroll / Processing to Payroll / Completed

Rules, exceptions and controls

Rules to follow

  • Each property uses its approved basis (direct time + units, unit count or shared staff) from the current rules version (2026.10 in the recording).
  • Direct employee time overrides the unit-count formula; shared payroll uses the approved portfolio basis.
  • Property percentages must total 100% and allocated payroll must equal the source control total.
  • Debits must equal credits, and every property ID and GL account must be active.
  • The accounting period must be open and the batch ID must not already exist.
  • Nothing posts without controller approval.

When something doesn't match

  • Pre-import validation fails (unmapped account, inactive property, closed period, duplicate batch) — a pending/error list is emailed and the allocation stays pending.
  • Controller rejects the batch — nothing posts and the pending/error list is sent.
  • Charges a management agreement does not allow — held for the controller rather than allocated.

Controls and audit trail

  • Attachment count checked against the email's control record.
  • Source control total reconciled to the allocation and to the journal.
  • Pre-import validation with file checksum before any posting.
  • Controller approval separates preparation from posting.
  • Posting confirmation PDF, completion email and archived source email retained as the audit trail.

Practitioner tips

  • Tie allocated totals back to the payroll register before importing; a one-cent rounding gap is easier to fix in the allocation than after posting.
  • Mark the source email In Progress the moment you start so a second person does not process the same pay period.
  • Keep the rules version on the allocation so a later review can see which percentages were in force.
  • Check each management agreement for what payroll can be charged to the property; hold anything it does not allow for the controller.

About this recording

In the recording, the agent retrieved the ADP payroll files, allocated $230,798.00 across 12 properties, imported and validated a 48-line journal, posted it after the Corporate Controller approved, and sent the completion email.

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 allocate payroll to properties in RealPage?

Start from the payroll register for the pay period, apply the approved allocation rules (direct time, unit count or shared staff), map wages, employer taxes and benefits to GL accounts with the offset to payroll clearing, then import the journal into RealPage General Ledger and post it after approval.

How is shared site staff payroll split between properties?

Time worked directly at a property is charged there; shared payroll is spread using an approved basis such as unit count, so the property percentages total exactly 100%.

What should be checked before importing a payroll journal into RealPage?

That every property ID and GL account is active, the period is open, debits equal credits, the batch is not a duplicate and required fields are complete. RealPage's pre-import validation reports these before anything posts.

Who approves the payroll allocation journal?

Typically the corporate controller. The batch stays validated but unposted until approval is recorded, then it is posted and the confirmation is kept for audit.

What happens if validation fails?

The batch is not posted. A pending/error list goes to accounting so the mapping or rule can be fixed, and the pay period stays open until it is re-run.

Can an AI agent do payroll allocation in RealPage?

Yes. As shown in the video, the agent works the same mailbox and RealPage screens a person does, from picking up the payroll files to posting the journal, with the controller approving the batch before it posts.

More property management workflows