Catch duplicate IDs
Check the inputs before a merge multiplies your rows and distorts the result.
From “aha” to “I can.”
First practice pack · Power Query
Build a repeatable month-end reconciliation.
Use Power Query to compare two exports, find missing records and duplicate IDs, and check amount differences. Refresh the same workflow next month.
- About 90 minutes
- Windows Excel + Power Query
- Basic Power Query skills needed
In preparation · Planned price $49 USD · No payment today
Month-end reconciliationCONTROL CHECK
export-a.csv ↔ export-b.csv
| Invoice ID | Result | Difference |
|---|---|---|
| A101 | Matched | 0.00 |
| A102 | Matched | 0.00 |
| A103 | Missing in Export B | 150.00 |
| A104 | Missing in Export A | −150.00 |
Equal totals. Two missing records.A103 and A104 cancel out in the total. Both need investigation.
Sample result after correcting a confirmed duplicate.
One focused practice session
Excel + two supplied exports
A check you can run next month
The outcome
Three checks.
One repeatable workflow.
Build the controls that tell you when your reconciliation needs a second look.
Find missing records
Keep records from both exports so unmatched transactions stay visible.
Refresh with confidence
Check amounts, row counts and exceptions when the next month’s files arrive.
Free sample · 80 seconds
See what matching
totals can hide.
A silent, text-based walkthrough. Follow the changing tables or move through each step at your own pace.
EXPORT A
| Invoice ID | Amount |
|---|---|
| A101 | 100.00 |
| A102 | 200.00 |
| A103 | 150.00 |
Total450.00
EXPORT B
| Invoice ID | Amount |
|---|---|
| A101 | 100.00 |
| A102 | 200.00 |
| A102 | 200.00 |
| A104 | 150.00 |
Total650.00
Expected rule: one row per invoice ID.
STEP 01 / 05
Start with the inputs.
These two exports should contain the same invoices. Each invoice ID should appear once. Export A totals 450. Export B totals 650. Before comparing totals, check whether the IDs are unique.
Ready · 5 steps · silent demo
Check your understanding
One-question check
Both exports now total 450.
What should you do next?
A contains A101, A102 and A103.
B contains A101, A102 and A104.
The self-paced pilot
Build the check.
Keep the workflow.
A self-paced practice pack for accountants and finance analysts who already know basic Power Query.
- Guided practice using two supplied exports
- Worked solution and reconciliation checklist
- A fresh dataset to check your skills
- Around 90 minutes, at your own pace
Planned practice pack price
$49USD · one-time
Planned price for the practice pack. Joining the launch list is free; nothing is charged today.
Get a free launch notification
Inside the practice pack
Your planned
90-minute practice.
One currency. Two exports. A transaction ID expected to be unique in each file.
- 01
Inspect the inputs
Check column types and identify duplicate IDs.
- 02
Build the comparison
Keep both sides of the story with a Full Outer join.
- 03
Add the controls
Separate missing records from amount differences.
- 04
Refresh and check your work
Run a new dataset through your reconciliation.
Before you start
Built for accountants
and finance analysts.
You regularly compare Excel or CSV exports. You can already import a table and change column types in Power Query. You’ll need Windows desktop Excel with Power Query.
The pilot uses supplied sample data. It does not include custom company-file fixes, live coaching or a professional certification.
A few practical details
Before you join.
Is this a live workshop?
No. This pilot is being prepared as a self-paced practice pack. There is no scheduled class or live instructor.
Can I buy it today?
Sales are not open yet. You can try the free sample and join the launch list. We will only open orders after the required approvals and delivery details are confirmed.
Do I need to share work files?
No. You’ll use supplied example exports. Keep confidential company data on your own device.
Is this a full Power Query course?
No. It focuses on one reconciliation workflow. You should already be comfortable importing data and applying basic transformations.
Who operates Ahavvy?
Ahavvy is operated by UBN Ltd Sti.
For website and privacy enquiries, email ubn@ubngida.com.
How is my email used?
UBN Ltd Sti uses your email, with your permission, to notify you when this practice pack opens for orders.
We store your email, the displayed price, signup time, source campaign and consent record. Our website and registration storage are hosted using OpenAI Sites and Cloudflare. This is a free notification request, not a purchase. There are no advertising trackers or tracking cookies. Aggregate page and lesson events help us understand interest; they are not proof of payment.
To withdraw consent or request removal from the list, email ubn@ubngida.com.
We keep launch registrations until the pilot launch follow-up is complete, unless you request deletion sooner. We do not sell your email or add it to an unrelated mailing list. Short-lived hashed network identifiers are used to limit spam.