I will remove duplicates and clean, merge or reconcile your csv, excel or xero data

China

I speak English

I clean messy Excel and CSV files: duplicates, dates, totals

I clean messy spreadsheets. Three date formats in one column. Duplicate rows. Amounts stored as text. Totals that don't add up. You get it back rebuilt: one date format, real numbers, duplicates lis...
About this Gig

A messy export with duplicate rows is worse than no export at all: every total you calculate from it is wrong, and you cannot tell which copy is the real one.


WHAT YOU ACTUALLY GET

One clean file, built from your CSV or Excel:

- Duplicates flagged side by side instead of deleted, so you can see exactly what came out

- Dates normalised to one format, amounts split into a single numeric column

- Categories standardised against a rule sheet I write down for you

- A control total, so you can see the clean file reconciles to what you sent

- A short exceptions list with row references


HOW IT WORKS

1. You send the file and tell me what it should look like at the end.

2. I clean it and send back the cleaned file plus the decisions I made.

3. If something is ambiguous, you get a question instead of a guess.


WHAT I DO NOT DO

I do not silently drop rows to make totals look tidy. If two rows look like the same transaction but are not identical, both stay and get flagged.


TURNAROUND

Up to 100 cleaned items back in 3 days. Bigger file? Message me the row count first and I will tell you honestly whether it fits the package.

Service type:

Accounts payable

•

Transaction categorization

Financial software:

QuickBooks

•

Xero

Industry:

E-Commerce

•

Financial services

Target country:

Canada

•

United Kingdom

•

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.