Align comparison grain
Aggregate many receipts before comparing them with one invoice.
Python and data workflows · EDITION 1.0.0
Reconcile Business Data with SQL
Build an inspectable SQLite reconciliation that aggregates receipts at invoice grain and separates mismatches, unpaid invoices and orphan receipts.
By Sanjaay Gowda T S · For analysts who can read basic sql and need to compare two business extracts.
You need: Basic SELECT and GROUP BY; Python dictionaries and lists; Understanding primary keys
Runtime and hardware details
Python 3.10 or later and a terminal. The supplied project runs locally and uses the Python standard library.
No model, API key, cloud account or network calls are used by the companion.
Basic SELECT and GROUP BY; Python dictionaries and lists; Understanding primary keys.
Full setup and scope ↓$2.99USD · one-time purchase
Prepared with AI assistance. Independent human technical, editorial and assistive-technology reader review remains pending. Automated checks and agent review are not certification.
PDF + EPUB + companion project. Any applicable tax is shown at checkout. Single-reader ebook terms; companion code is MIT licensed.
TRY THE FREE SAMPLE
See how the guide teaches.
Read 6 sample pages to explore the introduction, first chapter and teaching approach before you choose the complete edition.
Read free sample PDF · No checkout required
WHAT YOU WILL LEARN
Understand each part.
Inspect every boundary.
Classify every difference
Distinguish underpayment, overpayment, unpaid invoices and orphan receipts.
Retain an audit trail
Prove conservation and preserve identifiers behind every summary.
INSIDE THE BOOK
9 focused chapters.
- Define the reconciliation contract
- Stage both extracts with constraints
- Find duplicates before joining
- Aggregate the many side
- Classify invoice differences
- Expose records without a partner
- Prove conservation with controls
- Test SQL boundary cases
- Review and release the reconciliation
Your download includes
- 22-page tagged PDF with linked contents
- Reflowable EPUB for ebook readers
- Local Python project, fictional input, recorded expected JSON output and 14 companion tests
- 3 explanatory diagrams
- 9 chapters with exercises and worked answers
Before you begin
Python 3.10 or later and a terminal. The supplied project runs locally and uses the Python standard library.
No model, API key, cloud account or network calls are used by the companion.
Learning prerequisites: Basic SELECT and GROUP BY; Python dictionaries and lists; Understanding primary keys.
Prepared with AI assistance. Independent human technical, editorial and assistive-technology reader review is pending.
The included examples are synthetic teaching material. Model access, software subscriptions, hosting, ongoing updates and consulting are not included.
CLEAR EXPECTATIONS
Before you buy.
What will I build?
Build an inspectable SQLite reconciliation that aggregates receipts at invoice grain and separates mismatches, unpaid invoices and orphan receipts. The local companion uses fictional teaching fixtures. Project limits: One teaching currency, no refunds or fees; One invoice reference per receipt; Small fixed in-memory extracts, no durable approval record.
What was tested?
The 14 companion tests passed on the packaged project. The supplied fictional fixture produced its recorded expected JSON output. EPUBCheck reported no errors or warnings; DAISY Ace and PDF/UA automated checks passed. These local teaching checks are not production accuracy claims or certification. Independent human technical, editorial and assistive-technology reader review remains pending.
How do I get the files?
Complete the secure Lemon Squeezy checkout to access the PDF, EPUB and companion ZIP. Keep your receipt and download access private. This is a one-time purchase of edition 1.0.0; ongoing updates and consulting are not included.
Can I share the book or the companion code?
The full ebook is licensed to one reader. The labelled free sample may be shared unchanged. The companion project is MIT licensed and may be adapted or shared with its licence notice. See the exact ebook terms.
Explain invoice and receipt differences without hiding duplicates or missing records
One book. A complete learning project. Evidence you can inspect.
AI-assisted · Independent human review pending
$2.99USDBuy ebook