In-House Accountant – Excel & Customer Invoicing

Amanah group of companies

Published Date: • Lahore, Pakistan (On-Site)

Apply Now

Description

Amanah Group of Companies is seeking a highly skilled and detail-oriented In-House Accountant with at least 5 years of practical accounting experience and advanced proficiency in Microsoft Excel. The successful candidate will play a critical role in managing carrier invoice breakdowns from UPS and DPD, preparing customer invoices, and maintaining accurate financial reconciliations and general ledger records. This role requires someone who is comfortable processing large datasets, applying complex pricing structures, and ensuring accuracy in billing and cost allocation. The candidate will be responsible for end-to-end invoicing cycles and will interact professionally with customers to resolve invoicing inquiries and disputes. This position involves working full-time onsite and does not include team management responsibilities.

Responsibilities

Receive, review, and process carrier invoices and associated raw CSV billing files from UPS and DPD, ensuring detailed parcel-level cost breakdowns.

Utilize Microsoft Excel to clean, organize, analyze, and reconcile large volumes of data, employing functions such as VLOOKUP, XLOOKUP, PivotTables, and advanced formulas to ensure data accuracy.

Break down carrier invoices into individual parcel, shipment, and customer charges for accurate cost allocation according to shipment manifests and operational records.

Apply agreed customer pricing structures and profit margins accurately to generate timely and precise customer invoices reflecting all chargeable parcels and services.

Match tracking numbers against shipment records to confirm billing accuracy and investigate discrepancies such as incorrect charges or duplications.

Maintain sales and purchase ledgers by recording payment allocations, credit notes, and account reconciliations systematically to uphold financial integrity.

Address customer billing inquiries promptly and professionally, providing clear cost breakdowns, supporting documentation, and managing invoice dispute resolution in coordination with operations teams and carriers.

Monitor outstanding customer balances regularly and implement timely follow-ups for overdue payments to support effective cash flow management.

Maintain a thorough audit trail linking carrier costs, applied profit margins, and customer invoices for transparent financial reporting and compliance.

Continuously improve invoicing processes and financial reconciliation practices, ensuring that all tasks are completed accurately within deadlines and corporate standards.

Experience

5 Years

Apply By

Required Skills

Nice to Have Skills