Extract Gambling Transactions Excel -- 2
Budget: $30 – $250 AUD
I have 576 pages of bank statements and only care about the gambling-related entries. Your job is to open every page, find each transaction that fits this category, and record four things—statement number, date, exact description line, and the amount showing clearly whether it is a credit or debit—into one consolidated Excel worksheet.
Accuracy is crucial: every qualifying line must be captured exactly as it appears in the statement, numbers must balance to the cent, and descriptions must keep their original spelling and punctuation. I will spot-check against the PDFs, so please include page or statement references that make verification easy.
The final deliverable is a single .xlsx file with tidy column headings and no extra formatting. If you use OCR or data-capture software, build in a manual review to eliminate recognition errors before delivery.
Accuracy is crucial: every qualifying line must be captured exactly as it appears in the statement, numbers must balance to the cent, and descriptions must keep their original spelling and punctuation. I will spot-check against the PDFs, so please include page or statement references that make verification easy.
The final deliverable is a single .xlsx file with tidy column headings and no extra formatting. If you use OCR or data-capture software, build in a manual review to eliminate recognition errors before delivery.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Data Cleansing
Data Extraction
Data Analysis
Data Management