I will clean, reconcile and analyse your excel data as an acca

Pakistan

I speak English, Urdu
ACCA Qualified with professional Big 4 audit experience and strong expertise in Excel, data cleaning, reconciliation, and financial reporting. I help businesses organize, clean, and analyze data effic...
About this Gig

Are your spreadsheets messy, full of duplicates, wrong formats, or inconsistent data? 

I will professionally clean, reconcile, and analyse your Excel data delivered with 

the rigour of an ACCA affiliate with audit and financial reporting experience.


WHAT I WILL DO:

- Remove duplicate rows and inconsistent entries

- Fix date formats, text-stored numbers, and currency errors

- Standardise names, codes, and categories using TRIM, PROPER, UPPER

- Fill missing values using XLOOKUP against master tables

- Build reconciliation schedules with clear variance analysis

- Create pivot table summaries by client, region, date, or category

- Deliver a full data quality issue log with before/after comparison

- Build KPI dashboards with conditional formatting


FORMULAS I USE:

XLOOKUP, SUMIFS, COUNTIFS, AVERAGEIFS, IFS, IF(ISBLANK), IFERROR, 

DATEVALUE, TRIM, ABS, TEXT, LEFT, RIGHT, CONCATENATE


WHO THIS IS FOR:

Accountants, finance managers, business owners, and analysts who 

have inherited messy data and need it cleaned and ready for decisions.


WHAT YOU RECEIVE:

- Cleaned Excel file (.xlsx)

- Issue log documenting every problem found and fixed

- Pivot table summaries

- Professional note

Financial statement type:

Balance sheet

Income statement (P&L)

Accounting standards:

Service type:

Pro-forma financial statements

Reporting frequency:

Monthly

Quarterly

Annually

Ad-hoc

Target country:

United States

Gigs are not screened

Please note that there is no screening process for this service. We recommend that you message the freelancer and check all necessary details before placing your order. Read more about Financial services at Fiverr.