Financial Data Entry & Cleanup

I have a set of financial records that currently live inside another system/database and need them rebuilt in Microsoft Excel (and, where helpful, summarized in Word). The job is two-fold: first, bring the data over accurately; second, make sure every new entry is complete, well-formatted, and free of duplicates.

Most of what you will handle are typical finance columns—dates, descriptions, amounts, account codes—plus a small vendor/contact sheet that requires fresh entries as the import takes place. I already have a template, yet it needs tidy formulas, consistent number formats, and clear headings so monthly reporting becomes painless.

What I expect from you
• One polished Excel workbook containing the migrated transactions and the newly filled-out contact list
• Light documentation (a brief Word note) describing any assumptions, added formulas, or validation rules you introduced

Everything must reconcile with the source database, so cross-checking totals is essential. If you regularly use pivot tables, data validation, or Power Query, mention it when you submit; those skills will keep the workflow smooth.

I’ll share a CSV export and limited database access once we start. Accuracy and neat, human-readable formatting matter more than speed, but I’m aiming to wrap this up within a week.