Remote Excel Jobs in Rincon, GA (NOW HIRING)

REMOTE (Offshore) | Full-time | Accounting / Finance

Arboreal Management is the property management arm of Great Expectations, a fast-paced, mission-driven real estate investment firm focused on providing affordable, innovative, and profitable housing throughout the Pacific Northwest.

We manage over 6,000 apartment homes and are growing quickly. We believe in collaboration, data-driven decision-making, and building communities—not just buildings. Our team is small, driven, and deeply committed to changing how housing works.

We’re hiring an AR Specialist to own the accurate and timely recording of tenant payments and the full move-out security deposit process in AppFolio. This role works remotely with our onshore team and is perfect for someone who combines strong data-entry discipline with the judgment to investigate discrepancies and drive balances to resolution.

You’ll own daily cash application, deposit reconciliation, move-out accounting, and collections follow-through—directly contributing to revenue recovery and financial accuracy across our portfolio.

This position requires a minimum 6-hour overlap with Pacific Standard Time (PST).

• Enter scanned tenant checks into AppFolio daily, applying each receipt to the correct tenant, lease, and property ledger.

• Reconcile the batch of scanned check images against recorded payments to confirm every check is captured once, with the correct amount and date.

• Verify recorded receipts tie out to bank deposit totals; flag any over/short or missing items.

• Allocate receipts across rent, late fees, utilities, and other charges per lease and company policy; handle partial and prepaid payments correctly.

• Research and resolve unidentified or misapplied payments, NSF/returned checks, and duplicate entries; escalate unclear items to the AR Manager with a clear summary.

• Keep tenant ledger balances accurate, post adjustments and reversals when approved, and ensure aging is correct.

This role owns the full move-out security deposit workflow—an area where balances currently go uncaptured, estimated at $10K+ per month in recoverable revenue.

• Reconcile the security deposit against the final ledger—prorated rent, unpaid charges, damages, and RUBS (Ratio Utility Billing System) move-out estimates—so utility allocations are captured rather than written off.

• Prepare and process refunds within statutory deadlines, with proper itemization and documentation.

• Open and track receivables where a balance is owed after the deposit is applied, maintaining a live tracker capturing tenant, property, amount, age, and status.

• Follow a defined escalation path for owed balances: tenant portal → payment plan → Stripe payment link → collections agency → small claims, documenting each step and timeline.

• Record refunds, applied deposits, write-offs, and recoveries in AppFolio and the receivables tracker so balances, the GL, and aging stay accurate and reconciled.

• Prepare daily/weekly receipt summaries, batch logs, and AR aging snapshots for the onshore team.

• Maintain clear documentation and flag discrepancies or issues proactively to the AR Manager/Controller.

• 2–4 years of accounts receivable, bookkeeping, or payment-posting experience, required.

• Hands-on experience with AppFolio strongly preferred; Yardi, Buildium, or QuickBooks also acceptable.

• Solid understanding of AR fundamentals: cash application, reconciliation, debits/credits, and aging.

• High accuracy and attention to detail with high-volume data entry.

• Comfortable reading scanned check images and bank deposit reports.

• Proficiency in Excel/Google Sheets (filters, lookups, basic formulas) to build and maintain a receivables tracker.

• Strong written English for clear communication with the onshore team.

• Reliable high-speed internet and a quiet remote work setup; ability to overlap with PST business hours.

• Impactful Work: Own a critical function that directly recovers revenue and keeps our portfolio’s financials accurate.

• AppFolio Expertise: Deepen your skills with industry-leading property management software.

• Growth Path: Gain hands-on AR and property management experience—a launchpad into accounting leadership.

• Mission-Driven Team: Be part of a company redefining affordable and workforce housing in the Pacific Northwest.

• Daily scanned-check batch processed in AppFolio independently with minimal corrections.

• Deposits consistently reconciled to the bank; unapplied/unidentified receipts minimized.

• A working move-out reconciliation process—including RUBS estimates—and a live receivables tracker stood up within 90 days.

• Previously uncaptured move-out balances actively recovered through the triage and collections workflow.

• Accurate financial reporting and well-maintained tenant ledgers.

Location: Remote (Offshore)

Schedule: Minimum 6-hour overlap with Pacific Standard Time (PST) required

System: AppFolio Property Manager

Reports to: AR Manager / Controller

Arboreal is a drug-free workplace, and we use E-Verify to confirm the identity and employment eligibility of all new hires. We background check all new employees upon offer letter acceptance. We encourage people with a criminal record or nontraditional backgrounds to apply.