Virtual Senior Accounting Support Specialist

We are seeking an experienced, analytical, and highly meticulous Virtual Senior Accounting Support Specialist to manage revenue reporting, Accounts Receivable (AR) tracking, invoicing, and provider payroll support for Perio Providers Group (PPG), a growing periodontal healthcare organization supporting 41 doctors across Southern California.

This is a specialized, high-level accounting support role requiring strong core accounting principles, advanced math skills (including percentage-based calculations), and expert-level Microsoft Excel proficiency (Pivot Tables, XLOOKUP/VLOOKUP, SUMIFS). Operating under established procedures, you will consolidate multi-provider production data, investigate financial discrepancies, and deliver accurate financial summaries without relying on traditional accounting software like Quick Books.

• Role
  
  Title:
  
  Virtual Senior Accounting Support Specialist
• Organization: Perio Providers Group (PPG) — Supporting 41 Periodontal Doctors
• Status: Full-Time (40 Hours / Week)
• Schedule: Monday – Friday, 8:00 AM – 5:00 PM PST (Pacific Standard Time)
• Core Technology Stack:
  Microsoft Excel (Advanced), Outlook, Google Voice, Practice Production Reporting Portals (No Quick Books access utilized)
• Primary Scope: Multi-Provider Revenue Consolidation, AR & Invoicing, Production-Based Provider Payroll Audit

• Multi-Location Revenue Consolidation: Extract and aggregate production figures across 41 periodontal providers; audit report entries for accuracy, identify balance discrepancies, and maintain master revenue summary workbooks.
• Invoicing & Ledger Adjustment Audits: Compile line-item invoice data and supporting documentation; analyze office fee adjustments, refunds, and write-offs, flagging any out-of-policy items for management review.
• Production-Based Payroll Support: Reconcile doctor production reports against contract compensation structures, calculating complex percentage-based tiers and maintaining structured payroll verification schedules.
• Advanced Financial Analysis in Excel: Build, maintain, and audit complex financial workbooks using Pivot Tables, XLOOKUP/VLOOKUP, SUMIFS, and custom formulas to support month-end financial closes.
• Communication & Confidentiality: Maintain secure communication with internal teams via Outlook and Google Voice, following strict data governance, confidentiality, and accounting procedures.

• Accounting & Financial Background: Strong foundational understanding of accounting principles, GAAP standards, invoicing, AR, and financial reporting workflows. (Staff Accountant or Senior Accountant background strongly preferred).
• Advanced Excel Proficiency: High-level mastery of Microsoft Excel, including hands-on experience building and auditing Pivot Tables, XLOOKUP / VLOOKUP, and SUMIFS functions. (Candidates without advanced Excel mastery will not be considered).
• Advanced Mathematical
  
  Skills:
  
  Demonstrated strength in quantitative analysis, financial auditing, and calculating complex percentage-based compensation or revenue splits.
• Analytical Discrepancy Auditing: Proven ability to scrutinize large data sets, cross-reference multi-source reports, and spot minor financial discrepancies independently.
• Procedure Adherence & Independence: Ability to follow established accounting protocols precisely while managing strict monthly close deadlines with high autonomy.
• Communication & Confidentiality: Excellent written and verbal English communication skills with absolute discretion when handling confidential financial and payroll data.
• Remote Workspace: Private, quiet, HIPAA/financial-compliant home office equipped with a high-performance computer (PC/Mac), high-speed internet, backup power/internet solutions, and a headset.