Billing Analyst - Remote
Posted Updated
Description
Job Purpose
The Billing Analyst is responsible for translating complex customer summary billing requirements into accurate, compliant invoice submissions. This role relies heavily on advanced Excel skills to build formulas, pull and reconcile data from multiple sources, and prepare billing packages for upload to customer invoicing portals such as Coupa, Ariba, Taulia, and Textura. The ideal candidate is detail-oriented, comfortable working with large volumes of accounts receivable invoice data, and able to work independently to meet customer billing deadlines.
What you will do...
- Interpret customer-specific summary billing requirements and translate them into repeatable, accurate billing processes.
- Use Excel formulas (e.g., XLOOKUP/VLOOKUP, INDEX/MATCH, SUMIFS, IF logic, text and date functions) to pull in and consolidate required invoice, contract, and rental data.
- Clean, manipulate, and reformat large data sets in Excel to meet customer and portal template requirements.
- Prepare and submit invoices and other supporting documentation through customer portals including Coupa, Ariba, Taulia, Textura, and similar platforms.
- Validate billing data for accuracy and completeness prior to submission; reconcile totals back to the source accounts receivable invoices.
- Monitor portal submissions for rejections, errors, or status changes; research root causes and resubmit corrected invoices in a timely manner.
- Partner with branch operations, sales, collections, and customer contacts to resolve billing discrepancies, missing purchase order information, and customer inquiries.
- Maintain documentation of customer billing requirements, portal procedures, and Excel templates to support consistency and cross-training.
- Identify opportunities to streamline billing workflows and improve accuracy, turnaround time, and first-pass portal acceptance rates.
- Support month-end close activities and accounts receivable reporting as needed.
- Support invoice submission processes across multiple portals.
Requirements
- 2–5 years of experience in billing, accounts receivable, or a similar finance/accounting role.
- Demonstrated proficiency in Microsoft Excel, including writing and troubleshooting multi-step formulas and manipulating large data sets.
- Experience working with accounts receivable invoices and data, including invoice detail, credits, adjustments, and reconciliations.
- Experience submitting invoices through customer payable portals (e.g., Coupa, Ariba, Taulia, Textura).
- Ability to interpret complex customer billing requirements and apply them accurately and consistently.
- Strong attention to detail, organization, and ability to manage multiple deadlines.
- Clear written and verbal communication skills for working with internal teams and customers.
Preferred Qualifications
- Experience with Pivot Tables and other advanced Excel data tools.
- Familiarity with systems such as RentalMan. GetPaid, Qlik.
- Background in equipment rental, construction, or industrial billing environments.
- Associate or bachelor's degree in accounting, finance, business, or a related field, or equivalent experience.
Skills
Skills
Sign in to read and join the discussion.