Excel and finance-workflow automation

Less manual spreadsheet work. Clear checks. A process your team can run.

For controllers and finance managers at growing companies whose close still runs on spreadsheets one person understands.

MatchPass automates recurring Excel-based finance work, with built-in checks, clear explanations for exceptions, and documentation your team can use. We scope one workflow at a time, agree how success will be tested, and hand over the files and guidance to run it.

Free review of one workflow. If the fix won’t pay for itself within 3 months, based on numbers we agree with you, we don’t take it on.

Get a free workflow review See your payback in 2 minutes

No files or preparation needed for the initial conversation.

Checks · September closeSynthetic demo
Required columns present3 exportsPass
Duplicate rows counted once1 foundFlagged
Opening AR agrees to GL13,365.50Pass
Period invoices agree to GL17,095.25Pass
Receipts agree to GL12,160.00Pass
Difference explained by unapplied cash2,725.00Pass
Items requiring finance review4 itemsReview
Fictional distributor. Not a client result.Run it yourself →

Familiar workflow problems

The same spreadsheet work, every month

These are the workflows we look for. They repeat, they follow rules most of the time, and they cost more attention than they should.

01Combining the same exports every monthReceivables, receipts, the ledger or a bank file pasted into one workbook again, by hand, in a slightly different order each time.
02Repeating the same cleanup and matchingTrimming columns, fixing dates, then matching payments to invoices line by line with lookups and filters.
03Checking that totals agreeTicking subtotals back to the general ledger or a control report, and hoping nothing was pasted twice.
04Duplicates, missing items and unexplained differencesA difference shows up late in the close and someone spends an afternoon finding a duplicated row or a missing receipt.
05A workbook only one person understandsFormulas, hidden tabs and steps that live in someone’s head, which makes holidays and handovers risky.
If two or more of these sound familiar, the workflow is probably worth a conversation.

Examples

See it on a monthly AR reconciliation

A fictional distributor exports receivables, cash receipts and the general ledger every month. The demonstration refreshes them into a checked reconciliation. Every figure below is calculated from that synthetic data by the same logic the demo runs.

Before · monthly exports

  • 3 exports pasted together by hand
  • 14 invoice rows, one of them duplicated by the export
  • 7 receipts to match, some without a reference
  • A GL control balance of 18,300.75 to agree

After · one refresh

  • 5 receipts allocated by written rules
  • 2 receipts held for review, not forced
  • 4 items requiring finance review, plus 1 duplicate-source warning
  • Difference of 2,725.00 explained, 0.00 unexplained
Explore the Excel demo Synthetic data · not a client result

“Allocated” means matched within the synthetic reconciliation. The demonstration does not post receipts or journal entries to any accounting system.

Looking for the e-commerce reconciliation demo? The Northshore Supply Co. reference build, a multi-source payout and clearing-account reconciliation, now has its own page.

Open the reference build

What an engagement includes

Built, checked, documented and handed over

Each engagement covers one agreed workflow from start to finish. What you get is something your team can run, inspect and change, not a black box.

  1. Workflow mapping and scopeWe map the sources, steps, rules and judgment calls, and agree in writing what is in scope and how it will be accepted.
  2. Automation suited to your environmentBuilt in the tools your team already uses. Often formulas and Power Query, and a script or macro only where it genuinely helps.
  3. Validation and reconciliation checksRequired columns, duplicates, completeness and control totals checked every run. Missing or unreadable data stops the run. Differences are shown for investigation and the run is marked as needing review.
  4. Exceptions with reasonsAnything that does not satisfy a written rule is listed with the reason, the source rows and a suggested next step.
  5. Documented logic and change notesEvery rule and check written down, and a change log that records what changed, why and who approved it.
  6. User guide and handoverA short guide for the people who run it monthly, and a walkthrough so the workflow does not depend on us.
  7. Your review and acceptanceYou test it against the agreed criteria. The engagement is complete when it meets them, not when we say so.

How an engagement runs, step by step →

Who is responsible for what

Clear boundaries, agreed before work starts

Your team

  • Accounting policy and professional judgment
  • Approval of the rules and the treatment of exceptions
  • Access permissions, granted and revoked by you
  • Review of the output and final acceptance

MatchPass

  • Workflow analysis and mapping
  • Implementation in the agreed environment
  • The agreed tests and checks
  • Documentation and handover
  • Correction of defects in the agreed implementation, within scope

MatchPass is not an accounting firm and does not provide audit, assurance or accounting advice. The workflow supports your process. It does not certify it.

Guides

Practical guides on Excel finance automation

Written for the people who run the close. Each one says when the existing setup is already good enough.

Power QueryAutomate a monthly reconciliation in ExcelCombine the exports, clean them once, match with merges and keep the unmatched items visible.Read the guide → ControlsSeven checks every close spreadsheet should runRequired columns, duplicates, completeness and agreement to the ledger, built into the workbook.Read the guide → AI in ExcelCheck AI-generated formulas before you rely on themA review routine for formulas, queries and macros written by Copilot or other assistants.Read the guide →

Run the Workflow Payback CheckAll guides

Who you would work with

An industrial engineer’s approach to finance work

Karan Agrawal, founder of MatchPass Labs
Karan Agrawal
Founder · Industrial engineer · Lean Six Sigma Black Belt

Founder Karan Agrawal co-led the design of a multi-pass reconciliation engine, with every exception routed with a reason.

Industrial engineering is the study of how repeatable work should be structured, measured and improved. MatchPass applies it to finance workflows: understand the process before automating it, separate the rules from the judgment, and build something that can be tested and maintained by the people who use it.

The method was first developed in an industry-sponsored engineering capstone: a seven-pass matching engine that reached 99.01% auto-match on $1.475B in daily trades and cut reconciliation cycle time by 87.5%.

Read the background

How fees work

Pay once it’s running

Free review. Fee fixed in writing before we build. Half at go-live, fully refundable. The rest only if the agreed target is met over two month-ends.

How the fee is set, and fixed-price options →

Questions

Before you get in touch

After the free review, we agree in writing how many hours the workflow takes today, the hourly cost you use for that work, and the time target after the build. The fee is fixed so that, on those agreed numbers, it is recovered within about 3 months. You see the fee and the calculation before anything is built.
Half the fee is due at go-live and is fully refundable. The rest is due only if the agreed target is met over two month-ends. If the agreed target is not met, you choose a full refund of the go-live payment, in which case the build is removed and your files are deleted within 30 days, or you keep the build with nothing further owed. Exact terms are set out in the written agreement.
The hours your team spends on the agreed workflow each month, compared with the baseline we agree in writing before the build. We measure it together over two month-ends after go-live. We count hours, not headcount or cost reductions. What you do with the time is your decision.
No. The review is a screen-share. The build uses exports you choose to share, with personal or sensitive fields removed or masked where possible. Nothing is posted to your accounting system. Working files are deleted within 30 days of handover unless you ask us to keep them.
Yes. We’re happy to sign your NDA before you share any files.
No. Your accounting system stays the system of record and your team or accountant keeps all judgment, exception treatment and sign-off.
Yes. Most of these workflows stay in Excel, built with features your team can open and inspect, such as formulas, tables and Power Query. If another tool would genuinely serve you better we will say so, but changing tools is not the point.
With you. Accounting policy, the treatment of each exception and the final sign-off remain your team’s decisions. Rules handle what is genuinely repeatable, and anything ambiguous is routed to a person rather than guessed.
Nothing prepared. A description of the workflow, how often it runs and roughly how long it takes is enough. Please do not send files or data at this stage.

Free workflow review

Tell us about one recurring workflow

A few sentences is enough. We will reply with whether it looks worth automating and what a sensible first step would be. If it is not worth it, we will say so.

Please do not attach or paste files, exports, credentials, or customer or client data. A description of the workflow is all we need at this stage.

Please enter your name.
Please enter your organization.
Please enter a valid work email so we can reply.
Please describe the workflow so we can reply usefully.

Ran the Workflow Payback Check? Paste your result here.

Book a call instead

Submitted through Netlify Forms and delivered to our inbox. We use what you send only to reply about this enquiry. See the privacy notice.

Prefer to pick a time?

Book a call

Choose a time that suits you. Bring a description of the workflow, nothing more.

Calendar not loading? Book directly on cal.com or email karan@matchpasslabs.com