I will clean, reconcile and analyse your excel data as an acca
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
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.
FAQ
What file formats do you accept?
I work with .xlsx, .xls, .csv, and .ods. If you have a Google Sheet, export it to .xlsx first.
Is my data kept confidential?
Yes, completely. I treat all client files as strictly confidential and am happy to sign an NDA if required.
What if my dataset is larger than the package limit?
Message me with your row count and a description of the issues, I will send a custom quote within a few hours.
Do you offer revisions?
Yes, but Additional changes beyond the original scope are quoted separately.
Can you handle financial and accounting data?
That is my speciality. My ACCA background and audit experience means I understand financial data, AR ledgers, reconciliations, and reporting requirements precisely.

