
Closed
Posted
I’m ready to hand over three full years of PDF statements for five separate bank and credit-card accounts and need every single transaction moved into Excel. You’ll be working with 2022, 2023 and 2024 files; each account should end up with its own workbook tab for each year so I can switch between them quickly. I’ll supply a sample sheet that shows the custom headers and layout I want—date, description, amount, balance, plus a few extra columns for categories and notes. Please keep that structure identical across all tabs. During extraction you’ll also need to clean the data: normalize dates, strip out blank rows, fix any OCR quirks, and make sure credits and debits sit in the correct signed columns. In short, I want a spreadsheet that’s ready for pivot tables and reconciliations the moment I open it. You’re free to use the tools you prefer—Python with tabula-pdf, Power Query, Adobe Acrobat, or any combination—as long as the end result is a tidy, fully searchable .xlsx file with no broken formulas or mismatched columns. I’ll consider the job finished once each year-tab balances to the ending balance shown on its respective PDF and the layout matches my sample exactly.
Project ID: 40205646
63 proposals
Remote project
Active 7 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
63 freelancers are bidding on average ₹1,029 INR/hour for this job

As the CEO & Founder of Digital Screencast, I bring over seven years of experience in web scraping, web automation, and scripting to the table. These skills are exactly what you need to extract and transform your three years' worth of PDF bank statements into organized, clean Excel spreadsheets. I am well-versed in working with different tools such as Python (including libraries like tabula-pdfl), Power Query, and Adobe Acrobat. This all translates to me approaching your project from multiple angles and ensuring no details slip through the cracks. Moreover, with my expertise in data analysis and entry, I understand the importance of accuracy and precision for tasks like cleansing data, normalizing dates, and fixing OCR errors -- requirements you have specifically highlighted. My goal is to provide you with an Excel spreadsheet that's not just correctly formulated but also easily navigable with comprehensive categorizations and notes.
₹1,000 INR in 40 days
8.7
8.7

sure I can assist you task regarding pdf bank statements to excel lets start......................................
₹1,000 INR in 40 days
8.1
8.1

Hello, I trust you're doing well. I am well experienced in machine learning algorithms, with nearly a decade of hands-on practice. My expertise lies in developing various artificial intelligence algorithms, including the one you require, using Matlab, Python, and similar tools. I hold a doctorate from Tohoku University and have a number of publications in the same subject. My portfolio, which showcases my past work, is available for your review. Your project piqued my interest, and I would be delighted to be part of it. Let's connect to discuss in detail. Warm regards. please check my portfolio link: https://www.freelancer.com/u/sajjadtaghvaeifr
₹1,800 INR in 40 days
6.5
6.5

As someone with over 16 years of experience in data management, I assure you that transforming your three years worth of PDF bank statements into a tidy, fully searchable .xlsx file will be a seamless process for me. My expertise lies in Data Cleansing, Data Entry, Data Extraction, and Excel; skills you mentioned are key for this project. I pride myself on my ability to maintain the integrity of data throughout any process and ensuring accurate representation. Additionally, I am highly familiar with Python, Power Query and Adobe Acrobat which are among your preferred tools for this task. Over the years, I have employed these tools effectively for similar projects and delivered exceptional results to clients in over 200 countries. Furthermore, my commitment to detail and quality means that I will meticulously apply your custom headers and ensure that every credit and debit is accurately placed within the correct signed columns.
₹999 INR in 40 days
5.2
5.2

I'm an Excel expert and I fully understand your needs. I can start preparing the Excel file tomorrow, exactly as you require. Quality work guaranteed. Immediate availability. I respond quickly.
₹1,000 INR in 40 days
4.8
4.8

Dear Hiring Manager, I am pleased to assist with extracting and organizing your financial transaction data from multi-year PDF statements into structured Excel workbooks. With strong experience in data extraction, financial record normalization, and spreadsheet automation, I can ensure accurate, clean, and analysis-ready outputs that align perfectly with your provided format. ➡ Extensive experience extracting financial transactions from bank and credit-card PDF statements ➡ Ability to organize five accounts into structured workbooks with separate year-wise tabs ➡ Skilled in maintaining identical custom headers and layout based on your sample sheet ➡ Strong expertise in cleaning data including date normalization, OCR correction, and blank row removal ➡ Accurate handling of credit and debit transaction sign alignment and balance validation ➡ Proficient with automation tools such as Python (Tabula, Pandas), Power Query, and advanced Excel processing ➡ Ensure spreadsheets are fully searchable, formula-safe, and ready for pivot tables and reconciliation ➡ Perform balance verification to match ending balances with original statements ➡ Deliver consistent, error-free, and well-documented datasets I am committed to delivering highly accurate, organized, and reliable financial data conversion aligned with your requirements. Best Regards, Mayank Saluja
₹750 INR in 40 days
4.6
4.6

Hi, I’m Karthik, a developer with 10+ years of experience in data processing, automation, and financial-data handling. I’ve converted large volumes of bank/credit-card PDFs into clean, analysis-ready Excel files for reporting and reconciliation. Why I’m a good fit • Strong with PDF data extraction (Tabula, PDFPlumber, OCR when needed) • Experienced in financial transaction formatting and validation • Detail-focused on data cleaning and consistency • Comfortable handling multi-year, multi-account datasets How I’ll handle your statements – Extract transactions from 2022–2024 PDFs per account – Create separate tabs per account per year as requested – Match your sample template exactly (headers, layout) – Normalize dates and clean OCR issues – Ensure correct debit/credit signs and balances – Remove blanks and inconsistencies – Reconcile each tab to statement ending balances Tools Python-based pipeline + Excel validation to ensure accuracy and repeatability. Delivery ✔ Tidy, searchable .xlsx files ✔ Consistent structure across all tabs ✔ Ready for pivots and reconciliations I value accuracy and confidentiality with financial data. Happy to start with a sample and scale to all files. Best regards, Karthik
₹1,300 INR in 40 days
5.3
5.3

⭐ Hello there, My availability is immediate. I read your project post on Python Developer for PDF Bank Statements to Excel. We are experienced full-stack Python developers with skill sets in - Python, Django, Flask, FastAPI, Jupyter Notebook, Selenium, Data Visualization, ETL - React, JavaScript, jQuery, TypeScript, NextJS, React Native - NodeJS, ExpressJS - Web App Development, Data Science, Web/API Scrapping - API Development, Authentication, Authorization - SQLAlchemy, PostegresDB, MySQL, SQLite, SQLServer, Datasets - Web hosting, Docker, Azure, AWS, GPC, Digital Ocean, GoDaddy, Web Hosting - Python Libraries: NumPy, pandas, scikit-learn, tensorflow, etc. Please send a message So we can quickly discuss your project and proceed further. I am looking forward to hearing from you. Thanks
₹780 INR in 40 days
4.2
4.2

I can easily do this work of PDF Bank Statements to Excel as mentioned in your brief. Please let me know further. Thanks
₹1,000 INR in 40 days
3.6
3.6

Hi there! I am a Data Analyst and MS Office expert. I have experience in data analysis, data entry, copy typing. I have understood your requirement; I can help you with this task in Excel with 100% proficiency and accuracy that you are looking for. I ensure you that I will complete your work in a satisfactory manner and in the committed time. You can view my portfolio here- https://www.freelancer.in/u/Kirti048. We can discuss more about the project in the chat box. Looking forward to work with you. Thank you.
₹1,000 INR in 40 days
2.3
2.3

As an experienced Python developer with a focus on practical solutions, I'm confident that I'm the best fit for your project. My proficiency in Python is particularly pertinent considering our task involves working with PDF files as well as cleaning, transforming and organizing data- this is where the language really shines. I have used tools such as tabula-py extensively to extract and organize data from PDFs into spreadsheets for analysis. Additionally, my clients routinely praise me for my communication skills and ability to understand their needs even when they are not fully defined yet. This means I not only understand your requirements but can also ensure that your transactions are properly sorted, categorized, and documented so you can efficiently track spending and make informed financial decisions. Considering the vast amount of data we'll be working with, performance and usability are paramount, which again aligns perfectly with my past accomplishments. Lastly, my approach to every project is towards long-term maintainability. You don't simply need an Excel sheet, you need a reliable solution that you can use seamlessly whenever the need arises. This makes us a perfect match as I will ensure all your requirements are precisely met, while keeping in mind future scalability and relevance. Let's get started on transforming these bank statements into a user-friendly, easily searchable spreadsheet that will save you significant time and effort down the line!
₹750 INR in 40 days
1.5
1.5

I can accurately extract and consolidate transactions from multi-year bank and credit-card PDF statements into a clean, analysis-ready Excel workbook. Each account will be organized into separate tabs per year (2022, 2023, 2024), all following your exact sample layout with consistent headers and structure. I’ll handle full data cleanup—normalizing dates, removing blanks, correcting OCR issues, and ensuring credits/debits are correctly signed—so the file is immediately ready for pivot tables and reconciliations. I’ll use reliable tools such as Python (tabula-pdf, pandas, openpyxl) or equivalent methods as needed, and I’ll validate that each year’s ending balance matches the source PDF before delivery. You’ll receive a tidy, fully searchable .xlsx file that matches your sample precisely and balances correctly across all accounts. Thank you for considering my proposal—I’d be happy to assist with this project.
₹900 INR in 40 days
0.6
0.6

As a seasoned data analysis and visualization expert, I have the perfect skill set to tackle your task of converting bank statements from PDF to Excel format. My proficiency in relevant tools like Python, SQL, Power BI and Tableau will enable me to execute the project accurately and efficiently. In particular, my advanced Excel skills paired with my experience in cleaning and normalizing data will ensure that your datasets are error-free and well-structured for pivot tables and reconciliations. Further, I am no stranger to dealing with large datasets and creating comprehensive models and analyses, which further qualifies me to take on this task. Additionally, my commitment to providing data-driven solutions is also reflected in my ability to strictly adhere to specific formatting guidelines - ensuring the final layout matches your sample exactly. By the end of the project, you can expect a tidy, searchable .xlsx file that seamlessly balances each tab with its respective PDF ending balance. So let's collaborate!
₹750 INR in 40 days
0.3
0.3

Hello, My name is Laila Majid, and I am a beginner Virtual Assistant who is detail-oriented, reliable, and eager to help you manage your administrative tasks so you can focus on growing your business. Although I am new on Upwork, I am highly motivated, quick to learn, and committed to delivering quality work that meets your expectations. Services I can assist you with: Data entry and spreadsheet management Email and calendar management Internet research Basic customer support (email/chat) Other administrative tasks as required Tools I am familiar with: Google Docs & Google Sheets Microsoft Word & Excel Gmail Zoom / Google Meet Why should you hire me? Fast learner and easy to work with Clear and professional communication Strong attention to detail On-time delivery and responsibility Open to feedback and improvement I would be happy to discuss your project in more detail and am available to start immediately. Thank you for your time and consideration. I look forward to the opportunity to work with you. Best regards, Laila Majid
₹1,000 INR in 40 days
0.0
0.0

Thank you for sharing the details of your project. As a freelance specialist in data organization. I'm excited to deliver a clean, pivot-ready spreadsheet from your three years of PDF statements across five accounts. I want to see your PDFs first. My Approach Review your sample sheet and PDFs upon receipt. Use reliable PDF extraction tools. Standardize data in Excel. Test for reconciliations. Deliver via secure file share. Thank you!
₹900 INR in 40 days
0.0
0.0

Hi there, I understand you need 3 years of bank and credit card data (2022–2024) across 5 accounts converted into a meticulously organized Excel workbook. You are looking for more than just a data dump; you need a reconciled, error-free dataset ready for immediate analysis. I have extensive experience in financial data processing and understand that in accounting, a difference of even ₹1.00 is a failed job. I am committed to delivering a "tidy" file with zero broken formulas or mismatched columns. I am ready to start immediately and can provide a quick sample of one month’s data to ensure the layout meets your expectations before I proceed with the full three years. Looking forward to working with you! Best regards,
₹800 INR in 40 days
0.0
0.0

Hi, you want all transactions from three years of PDFs across five bank/credit card accounts extracted, cleaned, and normalized into an Excel workbook with consistent headers and per-account, per-year tabs that reconcile exactly to the statement balances. I work with Python-based data processing and automation (tabula/other PDF extractors + pandas) and have done similar structured extraction/cleanup tasks before, including an automation project on Freelancer with a 5★ rating. I’d build a small Python pipeline to batch-parse your PDFs, normalize dates, enforce your sample sheet layout (date, description, amount, balance, categories, notes, etc.), separate credits/debits into correct signed columns, and remove blanks/OCR artefacts. Then I’ll validate each tab by checking that running totals reconcile with the ending balance in the corresponding PDF, and spot-check random entries for description and amount accuracy. For this scope, I can deliver in about 2–3 days for a fixed 2500 INR. Can you share the sample Excel layout and a couple of representative PDFs (including the “worst” quality) so I can confirm column mapping and OCR handling before starting?
₹7,500 INR in 40 days
0.0
0.0

Hi, I’ll turn your three years of bank and credit-card PDFs into a clean, audit-ready Excel workbook you can trust from day one. Every transaction will be extracted, cleaned, and structured exactly to your template—separate tabs per account and year, normalized dates, correct debit/credit signs, and zero OCR noise. Before delivery, each tab is fully reconciled to the statement ending balance, so pivots and reconciliations work instantly. You’ll receive a polished, searchable .xlsx with consistent headers and no formula issues—ready to use the moment you open it.
₹800 INR in 40 days
0.0
0.0

Hello, I have read your project details carefully. I can accurately fill all 80 rows in Excel by following your instructions. I am new on Freelancer but very dedicated and detail-oriented. I can deliver within 5 days. Thank you.
₹750 INR in 5 days
0.0
0.0

Hello, I can help you convert your 3 years of bank and credit-card PDF statements into clean, well-structured Excel workbooks exactly as you described. I have experience with PDF-to-Excel extraction, data cleaning, and financial transaction formatting using Excel, Power Query, and Python-based tools when needed. My approach will be: • Extract all transactions accurately from each PDF • Create separate workbook tabs for each account and each year • Standardize date formats and column structure • Correct credit/debit signs and remove blank or broken rows • Fix OCR issues and mismatched columns • Verify each tab’s ending balance with the original PDF • Deliver a tidy, pivot-ready .xlsx file matching your sample layout Before starting, I’d be happy to test a few sample pages to confirm extraction quality and give you an accurate time estimate. I focus on accuracy, consistency, and quick turnaround. Ready to start immediately. Thank you.
₹1,000 INR in 36 days
0.0
0.0

Varanasi, India
Member since Oct 17, 2020
₹1500-12500 INR
$10-30 USD
₹100-400 INR / hour
£2-5 GBP / hour
₹600-1500 INR
₹1500-2500 INR
$250-750 USD
$15-25 USD / hour
$15-25 USD / hour
$750-1500 USD
£10-15 GBP / hour
$15-25 USD / hour
$250-750 USD
$750-1500 USD
₹1500-12500 INR
₹750-1250 INR / hour
₹75000-150000 INR
₹12500-37500 INR
$30-250 CAD
$250-750 CAD