Skip to main content
Discuss your project Custom business systems & automation

Portfolio Zvitno

Every client dollar, down to the hryvnia and the receipt

A custom system for tracking purchases between a client and the person buying on their behalf: the client sends money in dollars, the buyer pays in hryvnias and reports on every payment. It replaced an Excel spreadsheet kept since 2022.

Project

Zvitno

Zvitno · project Purchase accounting
Client
A client funding purchases in Ukraine Sends money in dollars, while the buyer purchases goods from Ukrainian sellers in hryvnias and reports on every expense.
System
Purchases, balances and settlements in one panel Several clients, each with their own account and balance; role-based access for the client, the buyer and the payer.
Our part
Analysis of the accounting spreadsheet, design and development Also moving the history over from Excel, adapting the system for phones, and rollout.
Stack
  • PHP
  • Laravel
  • Filament
  • Livewire
  • MariaDB
Access
Everyone sees only their own The client sees their own account and orders; a payer sees only the payments assigned to them.

The task

Accounting that outgrew a spreadsheet

For years, purchases were tracked in Excel, with each sheet covering the period between two incoming transfers. The spreadsheet had to become a system without losing either its familiar logic or its history.

Hryvnias, rate and dollars

The client provides dollars, while sellers are paid in hryvnias. Each payment needs its hryvnia amount, the exchange rate and the dollar amount, and the totals have to add up exactly as they did in the spreadsheet.

One payment, several items

A single payment to a seller often covers the goods, delivery and a bank fee. The service fee is tracked separately, in dollars only.

Periods between transfers

Reporting runs in periods from one incoming transfer to the next: you need to see how each period closed and what is left right now.

Who pays and who owes whom

Some purchases are paid not by the buyer but by another person with their own money, which needs separate settlements. And the client must see only their own account.

Solution

The spreadsheet became a system with roles

Any two numbers out of three

Enter any two of the three values (hryvnias, rate or dollars) and the system calculates the third. Dollars are kept to four decimal places without rounding to cents, as in the spreadsheet, so totals don’t drift.

Periods and balance calculate themselves

Periods aren’t stored anywhere: incoming transfer dates define them, and the database calculates the running balance. Each period opens as a familiar spreadsheet sheet and exports to Excel.

Orders from the client

The client creates orders and assigns a buyer, who in turn assigns a payer. An unpaid order doesn’t affect the balance until it is paid with a date and a rate.

A separate ledger with the payer

Purchases paid by a payer and money returned to them are brought together in a separate ledger that shows how much the buyer owes the payer.

A QR code for payment

From a seller’s bank details, the system builds a payment QR code to the National Bank of Ukraine standard: scan it with a banking app and the details and amount fill in by themselves.

Receipts from a phone camera

Receipts, delivery notes and product photos are attached to expenses and transfers, straight from a phone camera if needed. Files are stored privately and open only for those allowed to see them.

Capabilities

From order to receipt

01 · 5

Accounting

  • Incoming transfers and expenses in dollars and hryvnias
  • Amounts calculated from the exchange rate
  • Expenses split into goods, delivery, bank fees and service fee
  • Periods between transfers, with totals
  • Running balance for every account

02 · 5

Orders and payment

  • Orders created by the client
  • Buyer and payer assignment
  • Payment with a date and rate
  • Settlement ledger with the payer
  • National Bank of Ukraine payment QR code from seller details

03 · 4

Sellers and documents

  • Seller directory with bank details and IBAN validation
  • Warnings about similar sellers, and merging them
  • Receipts, delivery notes and photos from a phone camera
  • Expense search by amount

04 · 5

Access and reports

  • Administrator, buyer, payer and client roles
  • The client sees only their own account
  • Full change history for every record
  • Cash flow and period sheet export to Excel
  • Comfortable to use on a phone

Result

A system instead of a spreadsheet

The purchase history has moved from Excel into the system, and the balance, periods and totals are now calculated automatically by the same rules as in the spreadsheet.

The client creates orders and sees their balance, the buyer pays them by QR code and adds receipts from a phone, and settlements with the payer are kept in a separate ledger.