
Closed
Posted
Paid on delivery
My personal finance spreadsheets have grown messy and unreliable, and I’d like them brought back into shape and made smarter. The files contain several years of transactions, account balances, and a few ad-hoc sheets that have been copied around so often they no longer link correctly. Here’s what I need: • First, a thorough clean-up—remove duplicate rows, standardise dates and currency formats, and reorganise everything into a clear, logical structure. • Then, build the advanced formulas I’ve been trying (and failing) to write: running balance calculations, automatic month-to-month summaries, and a set of error-proof lookups that tie the different sheets together. I’m comfortable reviewing the work, so please keep your formulas transparent and, where helpful, annotate tricky sections. A short note explaining any key techniques you use (array formulas, dynamic ranges, Power Query steps, etc.) will help me maintain the file later. The end deliverable is a single Excel workbook that is clean, consistent, and ready for ongoing use, along with a brief walkthrough of the core formulas you implemented. If you can finish within a week, even better—I’m keen to get my budgeting back on track.
Project ID: 40488122
25 proposals
Remote project
Active 22 secs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs