PAD Bank Reconciliation Automation

₹1500-12500 INR

Closed

Posted 25 days ago

₹1500-12500 INR

Paid on delivery

I keep each account’s transactions in separate Excel spreadsheets and want the reconciliation process fully automated with Microsoft Power Automate Desktop. The flow should let me pick which account file to work on, then: • read the ledger and corresponding bank statement sheets • match deposits and withdrawals line-by-line using date, amount and narration • flag anything that does not pair up within the tolerance I define • generate a clear reconciliation report (matched, unmatched, running balance) in Excel and save it to a folder of my choice • immediately e-mail or pop-up a notification summarising any discrepancies found Please deliver the PAD file plus a brief setup guide so I can adjust file paths, tolerance levels and add new accounts later. I’ll test the flow with two sample spreadsheets; acceptance is complete when both reconcile and the alert triggers correctly for any mismatches.

Software Architecture

Project ID: 40391740

About the project

4 proposals

Remote project

Active 25 days ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

4 freelancers are bidding on average ₹9,250 INR for this job

@nareshk44

With over 7 years of experience in providing reliable and efficient office support services, I am well-equipped to automate your bank reconciliation process using Microsoft Power Automate Desktop (PAD). My proficiency includes advanced data processing, Excel macros, VBA, and manipulation - all of which align perfectly with your project's requirements. In the past, I have worked on several projects involving extensive data entry, organizing, cross-referencing, and validating large datasets which will be highly applicable in reading ledger and bank statements line-by-line and matching transactions effectively by date, amount, and narration as you've requested. Moreover, my ability to implement data tolerances and generate comprehensive reports will help you pinpoint discrepancies faster. Transparency and user-friendliness is an integral part of my workflow. I assure you a streamlined PAD file that allows easy customization for file paths, tolerance levels, and account additions in the setup guide provided. Finally, as a testament to my dedication to quality delivery, I offer unlimited revisions until 100% satisfaction - guaranteeing the automation process performs smoothly with thorough testing using your sample spreadsheets. Choose me for timely support and top-notch quality.

₹7,000 INR in 1 day

5.0

(12 reviews)

4.3

@Hrolgar

Separate per-account sheets actually make this cleaner to build: you can validate each account's matching logic in isolation before running everything together. Plan is one reconciliation workbook per account with a normalized statement sheet, a ledger sheet, and a VBA or PAD pipeline that applies tiered matching: exact amount plus a configurable date window plus a reference token as the third tier. Matched rows go to one output sheet, clean unmatched to another, and anything ambiguous sits on a third sheet for your review before anything gets cleared. Every run writes a timestamped log entry for the audit trail. M1: Workbook structure + statement normalizer, INR 2625, 2d. M2: Matching engine (3-tier logic), INR 2625, 3d. M3: Output sheets + run log, INR 2625, 3d. M4: End-to-end test + handover, INR 2625, 2d. How many accounts are in scope, and are the statement files CSV exports or formatted Excel downloads?

₹10,500 INR in 10 days