commissions PAYROLL auditorBeehive BPO

Job description
Internal "ledger balance" process reconciling advances and prepaid commissions.
Manage and assist in researching payroll-related issues received through email, mail, and phones.
Perform audit in EC calc and Update Commission Sheet
Ensure accurate information on all weekly leads generate in EC Calculator
Obtain contract price to compare with lender loan amount, exact numbers of panels, and module size.
Edit loan code list if any updates to ensure all leads will accrue correct lender fee
(manually edit lender fee when necessary).
Review Advance Entries
Check the disposition from SB to review if On Hold/Cancelled and mark
accordingly in the sheet.
Maintain notes on respective Dealer commission sheet for each lead.
Matching all install with its advance to make sure all information showing in EC
Calc are accurate.
Upon audit completion of IA, SB and confirm in lender portals (Sunnova,
Goodleap, Dividend, and EnFin) ensure input in the EC calculator sheet during full
SB audit, manually transfer the calculated commissions for the current week onto respective dealers paysheet.
Audit all adders to confirm all are being deducted from the dealer at the time of install.
Manually edit roofing and generator amount to be deducted by lender %
To determine and input trenching ft on EC Calc
Manually input flat, metal, or concrete tile amount in EC calc to match SB
Confirm all adders are in SB, Enerflo, and IA as required.
Manually update installers pay into all applicable paysheets.
Full SB, Enerflo, and EC Calc audit
Review all audited leads in EC calc matches SB and Enerflo
Re-audit leads in EC calc if necessary and ensure all discrepancies have been resolve
Updating lender fees, redlines, adder cost in EC Calc as needed.
Install recheck for any projects that are on hold or removed from prior period.
Ensure weekly audited leads in EC calc and SB matches.
Manually update increased lender fee for the dealers that it applies to
Cancelled Customer Invoice Tracker Process
Determine cancellation request by reading the notes in SB to put all necessary
Maintain all pending/canceled leads into customer invoice tracker log.
Transfer tags from payroll SB access and review lead and reason of tagging payroll
Update Operating/FDA Ledgers by confirming if all FD payments have been clawed back for cancelled or projects not installed 60 days past sale date.
Update Limitless Sheet by adding the adders from calc to the paysheet.
Requirements
2 years of payroll processing
Strong knowledge of Excel (pivot tables, vlookups, xlookups, etc.)
Working knowledge of payroll wage and hour laws
Strong analytical and critical thinking skills, reconciliations
Proficient in problem solving, Multi-tasker
Ability to maintain attention to detail in order to analyze accordingly
Ability to maintain and navigate multiple systems