Farmacta: a pharmacy’s back office, built on its paperwork

A pharmacy receives hundreds of supplier invoices and delivery notes every month and reconciles them by hand. Farmacta reads them, reconciles them and leaves in view only what does not match.

Farmacta: A pharmacy’s back office, built on its paperwork
We did
Product, design and development
With
Next.js, Postgres, pdf.js and Claude
Status
In use at its first pharmacy

1The problem

A pharmacy buys from wholesalers and laboratories, and every purchase leaves a delivery note and, later, an invoice. Each supplier uses its own format, credit notes and discounts arrive separately and due dates are spread across the month.

Reconciling all of it is usually done by hand, with the PDF on one screen and the spreadsheet on the other. It is slow, invisible work, and mistakes are found late, once they have already affected cash flow.

2What we built

Farmacta starts from the paperwork the pharmacy already receives, without asking anyone to change supplier or format:

  • It reads PDF delivery notes and invoices from wholesalers and laboratories.
  • It extracts the accounting data from each document and leaves it ready for review in an inbox.
  • It reconciles what was invoiced with what was ordered and received, and flags what does not match.
  • From that data it organises due dates, cash flow and purchasing analytics.

3How it was tested

Reading documents from many different suppliers can only be validated with real documents. Farmacta has been validated with more than 1,600 real documents covering five years, with formats that change from supplier to supplier and year to year.

The design rule is that automatic reading proposes and a person confirms. Every extracted figure can be checked against the original PDF, and anything not read with confidence stays in the inbox flagged for review instead of going straight into the accounts.

4Status

Farmacta is in use at its first pharmacy. It is our own product: we designed and built it. The screens we show use a sample pharmacy, with real suppliers as examples and invented amounts.

5Which companies could use something similar

Any business that receives many supplier invoices and delivery notes and reconciles them by hand: distributors, shops with a wide range, workshops or restaurants with many suppliers. The technical piece is the same; what changes are each company’s documents and reconciliation rules.

6Related projects

  • Securacta: A device that detects shoplifting in pharmacies

    Securacta

    A device that detects shoplifting in pharmacies

    Another product for pharmacies, this one for detecting shoplifting at the shelf.

    In development. The camera already recognises poses and the web panel runs on sample data; gesture detection is the next phase.

    See the project page

  • Certero: Tender intelligence for public works

    Certero

    Tender intelligence for public works

    The same idea of reading long documents and checking every figure against the original, applied to public works tenders.

    Live at certero.es. Accepted into NVIDIA Inception.

    See the project page

See all projects

7Frequently asked questions

Do we have to change suppliers or management software?

No. Farmacta works with the PDFs the pharmacy already receives from its wholesalers and laboratories.

What happens if a document is not read correctly?

It stays in the inbox flagged for review. No doubtful figure reaches the accounts without a person confirming it.

Can I use Farmacta in my pharmacy?

Today it is in use at its first pharmacy. If you are interested, write to us and we will tell you where it stands.

Could you build something similar for another sector?

Yes. Reading and reconciling invoices and delivery notes works for any company that buys from many suppliers.

How many hours go into reconciling invoices each month?

Send us a sample invoice and delivery note from your suppliers and we will tell you which part can be read and reconciled automatically.

Tell us your problem