Skip to content
Free Consultation

Case study 02 / 06

Replacing a Paid Cashbook App With One the Business Owns

A villa rental company logged every cash movement in a subscription cashbook app. It did the basics, but the data sat in someone else's product and nothing else could use it. We rebuilt everything the app did on a database the company owns, then fixed what the app could not do.

01At a glance

Client
Villa rental company
Sector
Hospitality
Challenge
A paid app with per-book setup, no cross-book reports, no audit trail and no way for automation to read or write.
What we built
A cashbook web app with shared categories, flexible reports, receipts, soft delete and an interface for the AI assistant.
Stack
  • Web app, works on phone and desktop
  • Postgres with row-level security
  • File storage for receipts
  • API the AI assistant writes to

What was getting in the way

The old app was fine for writing down cash in and cash out. The problems showed up around it:

  • Sign-in needed a phone number and an SMS code, or a Google account, which did not suit every member of staff
  • Categories and contacts had to be set up again in every book, so no report could cross books
  • Receipts could only come from the photo gallery, one at a time
  • A deleted entry was gone for good, with no record of who changed what
  • Reports came in a fixed set, and nothing outside the app could read or write an entry

Like for like first

A switch only works if nobody loses anything. So the first rule was parity: multiple books, cash in and cash out with date, time, remark, category, contact and payment mode, running balance, search, filters, PDF and Excel export, members with roles, and per-book restrictions. Everything the team relied on is there.

Then what the old app could not do

  • Sign-in with any email address, by password or a one-time link
  • One list of categories and contacts for the whole business, so reports cross books
  • Amounts typed the way the team says them, in shorthand, with the full figure shown as you type
  • Receipts by drag and drop, pasted screenshot or phone camera, several per entry
  • Soft delete with a restore list, and an audit trail on every change
  • Reports grouped by category, contact, payment mode, book, month, day or person, over any date range and any selection of books

Ready for automation

The part that matters most for the future is the smallest on screen. The cashbook has an interface the company's AI assistant uses directly: it can write entries and read balances. A transfer someone mentions in a chat can become a cashbook line without anyone opening the app, and a question like "what is left in the maintenance book this month" gets an answer from the real data.

The company now owns the software, the database and the history, and pays no per-seat subscription for them.

The takeaway

When a tool holds data your business runs on, owning it is what makes automation possible. Match the old tool feature for feature before adding anything new.

Next step

Want something like this for your business?

Tell us what takes up your team's time. In a free 30-minute call we will say plainly whether AI can help, and what it would take.