Detailed Bank Transaction Spreadsheet
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted2 hours ago
I have a stack of bank statements and payment records that need to be converted into one clean, easy-to-filter spreadsheet. Your job is to take every statement I supply—PDFs, scanned images, or CSV exports—and capture every available field exactly as it appears in the source documents. That means dates, full descriptions, payee or payer names, references, amounts, running balances, currencies, and any other notes that show up must all make it into the sheet without omissions or typos.
I’ll provide a small sample first so we can agree on column order, naming conventions, and formatting rules (e.g., negative figures, thousand separators, date format). Once that’s locked in, you’ll work through the remaining files, standardising everything and flagging any unclear entries.
Deliverable
• A single Excel or Google Sheet containing every transaction from the supplied statements, fully cleaned, de-duplicated, and sorted chronologically.
• An exceptions tab noting items that were illegible or appeared twice.
Accuracy and confidentiality are critical; let me know your estimated turnaround time once you’ve seen the first batch of documents.
I’ll provide a small sample first so we can agree on column order, naming conventions, and formatting rules (e.g., negative figures, thousand separators, date format). Once that’s locked in, you’ll work through the remaining files, standardising everything and flagging any unclear entries.
Deliverable
• A single Excel or Google Sheet containing every transaction from the supplied statements, fully cleaned, de-duplicated, and sorted chronologically.
• An exceptions tab noting items that were illegible or appeared twice.
Accuracy and confidentiality are critical; let me know your estimated turnaround time once you’ve seen the first batch of documents.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.