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
- 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.