Detailed Bank Transaction Spreadsheet

₹1250-2500 INR / hour

Posted 1 minute ago

•

Ends in 6 days

₹1250-2500 INR / hour

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.

Project ID: 40829879

About the project

2 proposals

Open for bidding

Remote project

Active 30 secs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

2 freelancers are bidding on average ₹1,450 INR/hour for this job

User Avatar
Flag of INDIA

The main challenge is keeping the spreadsheet faithful to each source while making transactions from PDFs, scans, and CSVs consistent enough to filter, sort, and reconcile. I’ll treat accuracy as more than copying figures: descriptions, references, balances, currencies, and source-specific notes all need to remain intact, and unclear entries must be visible rather than guessed. I’ll use the sample to agree column order, labels, date and number formats, and how negative amounts should appear. Then I’ll transcribe each supplied record, standardise only the agreed formatting, and check the completed sheet for missing fields, chronological order, and duplicate-looking entries. I’ll keep an exceptions tab for illegible items and apparent duplicates, so repeated transactions can be reviewed rather than silently removed. The result can be delivered as an Excel workbook or Google Sheet, with consistent headers and filters for straightforward review. For scanned pages, I’ll verify extracted details against the visible document instead of relying on automatic text recognition alone. I’ll keep the source wording in descriptions and flag uncertainty clearly, preserving confidentiality by handling the documents only for this task. After seeing the first batch, I can give you a realistic turnaround estimate based on its size and readability. Could you share the sample batch and confirm whether apparent duplicates should remain in the transaction sheet with a flag, or be excluded after review?

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

用 HomepageTab 新标签页关注 RSS,打开浏览器就能看到更新。

安装 HomepageTab