Junior Accounting Administrator to prepare monthly expense forecast for IP & SG&A expenses, reconciliations and billing as well as other office adm

Our national retail client in looking for a Junior Accounting Administrator to prepare monthly expense forecast for IP & SG&A expenses, reconciliations and billing as well as other office admin support. - 28143

Location: Mississauga - in office Tuesdays + Thursdays

Duration: 10 months to start

Work hours: 37.5 hours a week

Job ID: WECJP00028143

Scope: This position is a 60-70% accounting role + admin support. The responsibility of this specialist role is to assist with billing our advertisers, expense processing for vendor partners, and general administrative support for our teams. The client is looking for someone with a good understanding of finance & accounting basics

Responsibilities:

• The individual in this role will be required to work collaboratively with other departments and provide customer support related to billing inquiries.
• Prepare monthly expense forecast for IP & SG&A expenses
• Liaise with external partners to reconcile expense forecasts against executed programs
• Prepare monthly billing file for advertisers, reconcile partner statements, resolving billing issues, and generating invoices
• Reconcile billing & expenses for upload into Salesforce
• Manage Accounts Receivables with internal teams: follow up with Sales, work with AR to make sure payments are applied, and report on monthly distribution of aged balances.
• Providing Customer Support: Assisting advertisers and sales teams with billing inquiries, providing explanations of charges, and resolving billing related concerns or questions.
• General Administrative Support:
• Office support and Administrative Coordination
• Meeting Coordination & Scheduling
• Data Entry and Database Maintenance
• Assist with new team member onboarding

Must Haves:

• Good understanding of finance & accounting basics (monthly reconciliations and billing)
• Expert level Excel skills - V-lookups, pivot tables, formulas, joining tables