Back to home

Compare two lists and see exactly where they don’t match

Cuadra is web software: you give it two lists, such as the bank statement and the invoices, and it tells you what matches, what’s missing and what doesn’t add up, with the difference explained. I designed and built it myself, from start to finish, between July and September 2026. The interface is in Spanish.

Type
Personal project
Status
Online as a demo application
My role
Design, programming, testing and publishing

Jaume Pérez SentísWeb developer in Barcelona

Cuadra summary with the difference explainedEnlarge the screenshot
A − B summary with the difference explained. Sample data, Spanish interface.

Two lists that should match

A bank statement and the month’s invoicing. Two exports from different programs. A list from the accountant and another from your own system. They should match and almost never fully do.

The usual fix is to open two spreadsheets, sort, search by hand and mark with colours. It takes time, mistakes happen, and afterwards nobody can explain where the difference comes from.

I built Cuadra to solve that: import both files and get, without formulas, the list of what matches, what’s missing on each side and what differs in amount.

Five steps, no formulas

  1. Import both sources

    Excel or CSV files, just as they come out of the bank or the software. Cuadra works out how they’re laid out without you touching them.

  2. Say which column is which

    You say which column is the reference, which the amount and which the date. Cuadra suggests it and you confirm; it can be saved for next time.

  3. Process and compare

    Cuadra matches the two lists while you get on with your work. You see how far along it is and can cancel it.

  4. Review matches and discrepancies

    A summary with the total difference and its explanation, plus separate lists: only in A, only in B, different amount, duplicates and invalid rows. Each discrepancy can be reviewed, annotated or paired by hand.

  5. Export

    Summary and discrepancies as CSV, ready to share with whoever has to close the month.

Cuadra asking which column is the reference, which the amount and which the dateEnlarge the screenshot
02 · Where you say which column is which. Sample data, Spanish interface.
Cuadra’s list of discrepancies with reviewEnlarge the screenshot
04 · List of discrepancies with review. Sample data, Spanish interface.

From idea to live application

I built all of it: how it works inside, the screens, the tests, publishing and the demo. Some decisions you notice when you use it:

  • The cents always add up

    It adds up like an accountant: 0.10 + 0.20 gives 0.30, with no odd rounding.

  • Same file, same result

    No guessing: with the same files you always get the same result, and it tells you why.

  • Big files without waiting

    While it compares, you keep working and see how far along it is. If you picked the wrong file, you cancel it.

  • Each company sees only its own

    Several companies can use it at once without seeing each other’s data. And comparisons delete themselves after 30 days.

  • Every change tested before it goes live

    Before a change reaches the people using it, it passes a battery of automatic checks.

  • Understands other people’s spreadsheets

    Excel dates, amounts with the sign flipped or debit and credit columns. And what it exports carries no dangerous hidden formulas.

What you can expect from me

  • Turning a manual, confusing process into an application anyone can use.
  • Taking care of the whole cycle, not just the visible part.
  • Handling sensitive data and edge cases with care.

Status and limits

  • Demo application, free and with sample data.
  • It doesn’t accept real data and isn’t intended, today, as a commercial product.
  • I don’t publish savings figures because I haven’t measured them.
Technical details, for developers
BackendPHP 8.3, Laravel 12
InterfaceLivewire 3, Blade, Tailwind CSS
DataPostgreSQL 16, Redis for queues, cache and sessions
TestsPest (unit, integration and concurrency), Playwright
DeliveryGitHub Actions with automatic deployment to a VPS via Laravel Forge
FilesCSV and XLSX with a custom reader, storage in the EU

Do you have two sources that should match and don’t?

Or any other process still done by hand that calls for its own software. Tell me about it and I’ll say where I’d start.

Tell me about your case