1001 Freelance Projects -- 5-Year Multi-Source Reconciliation

Latest Projects from Freelance Marketplaces

Today is: 07-Mar-2026 18:49 GMT

View this project in detail (Note: you will be redirected to external marketplace)
Project title:	5-Year Multi-Source Reconciliation
Posted by:	External project from PeoplePerHour
Started:	10-Aug-2025 01:51 GMT
Description:	Expected duration: Not sure We need to reconcile 5 years of financial transactions from multiple sources. Sources include: Bank statements Card processor reports (3 types) Cheque deposit records There are thousands of transactions for each month. Core Requirements: Import multiple CSV/XLSX files from data sources Standardize formats (date, amount, reference, payment method). Apply exact and fuzzy matching rules (date tolerance, payer name similarity). Produce exceptions list (unmatched transactions) with reasons. Build monthly reconciliation summaries (matched %, unmatched count/value). Document process so our team can refresh monthly. Must Have: Strong Power Query/ETL experience (in Excel or Power BI). Financial data reconciliation knowledge. Experience with fuzzy matching in Power Query. Deliverable: Working file + instructions. Outcome: Automated matching for 80–95% of transactions, exceptions for review, and month-by-month reconciliation status for all 5 years.
Project ID:	3444425
Project category:
Project budget:
View this project in detail (Note: you will be redirected to external marketplace)

Project	Started
Product Design Engineer Category: CAD / CAM, Circuit Design, Electrical Engineering, Electronic Design, Electronics, Manufacturing Design, Mechanical Design, PCB Layout, Product Design, Prototyping Budget: min £36 GBP	07-Mar-2026 17:04 GMT
Remote Actor Bookkeeping Training Category: Accounting, Bookkeeping, Data Entry, Excel, Finance, Financial Analysis, Financial Consulting, Training Budget: $250 - $750 USD	07-Mar-2026 17:04 GMT
Translate Immigration Papers (Dari/Pashto) Category: Dari Translator, Editing, English (UK) Translator, English (US) Translator, Legal Translation, Pashto Translator, Translation Budget: $30 - $250 USD	07-Mar-2026 17:04 GMT
Logo Branding Mockups x10 Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Print Design, Vector Design, Visual Design Budget: $30 - $250 CAD	07-Mar-2026 17:04 GMT
Epic Puranic Mythology Novel Category: Book Writing, Creative Writing, Editing, Fiction, Ghostwriting, Proofreading, Research, Script Writing Budget: ₹12500 - ₹37500 INR	07-Mar-2026 17:03 GMT
Instagram Growth & Management Specialist Category: Account Management, Analytics, Brand Management, Content Creation, Content Strategy, Digital Marketing, Graphic Design, Instagram Marketing, Social Media Management, Social Media Marketing Budget: ₹12500 - ₹37500 INR	07-Mar-2026 17:02 GMT
Set Up 34 Test Accounts Category: Data Entry, Google Sheets, Virtual Assistant Budget: $10 - $30 USD	07-Mar-2026 17:02 GMT
Diseño de tracksuits lujo Category: Adobe Illustrator, Corporate Identity, Covers & Packaging, Fashion Design, Graphic Design, Logo Design, Sketching, Textile Design Budget: €18 - €36 EUR	07-Mar-2026 17:01 GMT
Excel-Based Monthly Bookkeeper - Project for Jalal Category: Accounting, Bookkeeping, Data Entry, Data Management, Excel, Excel Macros, Excel VBA, Financial Analysis, Intuit QuickBooks, Xero Budget: ₹100 - ₹400 INR	07-Mar-2026 17:01 GMT
Vintage Texas Souvenir T-Shirt Design Category: Adobe Illustrator, Photoshop, Creative Design, Graphic Design, Illustration, Photoshop Design, T Shirts, Typography, Vector Design Budget: $15 - $25 USD	07-Mar-2026 17:00 GMT
Engaging Content Writer Needed Category: Article Writing, Content Creation, Content Development, Content Writing, Copywriting, Ghostwriting, Keyword Research, SEO Budget: ₹12500 - ₹37500 INR	07-Mar-2026 17:00 GMT
Удалённый HR-SMM менеджер Category: Analytics, Content Creation, Digital Marketing, Facebook Marketing, Internet Marketing, Social Media Management, Social Media Marketing, Twitter Budget: $15 - $25 USD	07-Mar-2026 16:59 GMT
Discord Movie-Night Upgrade by switching to Discord Screenshare from Watch Party Category: Discord, Performance Tuning, Technical Documentation, Technical Support, Video Conferencing, Video Production, Video Streaming Budget: $99 - $100 USD	07-Mar-2026 16:58 GMT
Well-being Focused Office Architecture Category: 3D Modelling, 3D Rendering, Architectural Engineering, AutoCAD, SketchUp Budget: ₹600 - ₹1500 INR	07-Mar-2026 16:57 GMT
ESP32 NFC Audio Player – PCB Audit + Firmware Completion (No Hardware Prototype) Category: Arduino, Audio Engineering, Debugging, Electrical Engineering, Electronics, Embedded Systems, Project Management, Software Development, Technical Documentation Budget: €30 - €250 EUR	07-Mar-2026 16:57 GMT

Browse All Projects

Projects by Skills ...
Projects for 'android' Projects for 'ajax' Projects for 'asp' Projects for 'aspnet' Projects for 'cms' Projects for 'cpp' Projects for 'csharp' Projects for 'css' Projects for 'delphi' Projects for 'design' Projects for 'drupal'	Projects for 'excel' Projects for 'facebook' Projects for 'flash' Projects for 'html' Projects for 'java' Projects for 'javascript' Projects for 'joomla' Projects for 'iphone' Projects for 'mysql' Projects for 'photoshop' Projects for 'php' Projects for 'python'	Projects for 'ruby' Projects for 'seo' Projects for 'sql' Projects for 'sysadm' Projects for 'translate' Projects for 'typing' Projects for 'twitter' Projects for 'vbnet' Projects for 'xml' Projects for 'wordpress' Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android' RSS feed for 'ajax' RSS feed for 'asp' RSS feed for 'aspnet' RSS feed for 'cms' RSS feed for 'cpp' RSS feed for 'csharp' RSS feed for 'css' RSS feed for 'delphi' RSS feed for 'design' RSS feed for 'drupal'	RSS feed for 'excel' RSS feed for 'facebook' RSS feed for 'flash' RSS feed for 'html' RSS feed for 'java' RSS feed for 'javascript' RSS feed for 'joomla' RSS feed for 'iphone' RSS feed for 'mysql' RSS feed for 'photoshop' RSS feed for 'php' RSS feed for 'python'	RSS feed for 'ruby' RSS feed for 'seo' RSS feed for 'sql' RSS feed for 'sysadm' RSS feed for 'translate' RSS feed for 'typing' RSS feed for 'twitter' RSS feed for 'vbnet' RSS feed for 'xml' RSS feed for 'wordpress' RSS feed for 'writing'

New!
Проекты на русском (Projects in Russian)	Short URL: 1001fp.com	Mobile version: m.1001freelanceprojects.com