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

Portfolio AIS

Who owes whom, at a glance

A custom internal system for invoices, client payments and contractor payouts in several currencies. It produces invoices and acceptance certificates in PDF, sets payment status on its own and shows the balance with every client and contractor.

Project

AIS

AIS · project Financial accounting
Client
An IT services company It builds and maintains digital products and provides clients with servers, databases and hosting.
System
Invoices, payments, contractors and services in one system Amounts are kept in hryvnias, dollars, euros and zlotys, and currencies are never mixed in totals.
Our part
Process analysis, design and development Also loading historical payments from bank statements and moving to a new interface without changing the accounting rules.
Stack
  • PHP
  • Laravel
  • Filament
  • Livewire
  • MariaDB
Documents
Invoices and acceptance certificates in PDF Each seller has its own document template, the amount is written out in words, and invoices for foreign clients come out bilingual.

The task

Money moving both ways

The company invoices from several sellers and in different currencies, pays contractors and provides clients with servers every month. The system had to bring all of this together and show the balance with every client and contractor without manual recalculation.

Invoices from several sellers

Invoices are issued on behalf of different sole proprietors and companies, each with its own details, default currency and document layout.

One payment, several invoices

A client may settle several invoices with one payment or pay an invoice in parts. An invoice’s status has to match the money actually received.

Contractors in three currencies

Contractors’ work is priced in hryvnias, dollars and euros and paid in any of them, sometimes in advance. An overpayment must not get lost.

Monthly services

Clients receive servers, databases, backups and websites in monthly packages. The company needs to know how much to invoice each client and how much it earns on that.

Solution

Statuses and balances worked out by the system

Money sets the invoice status

An incoming payment is split across one or more invoices. The system marks an invoice as paid or partly paid itself and dates the certificate by the last payment.

Overpayment becomes an advance

An expense records its amount in three currencies at once, at the rate of the day it was created, so it can be paid in any of them. Any surplus moves to the next unpaid expense, and if there is none it stays as an advance and is credited as soon as an expense appears.

Monthly service records

The system builds a monthly record from the client’s packages, one per currency. Cost and price are fixed when the record is created, so history doesn’t shift when prices change, and the margin is visible for every package.

Capabilities

Invoices, payouts and services on record

01 · 6

Invoices and certificates

  • Automatic invoice numbering within the year
  • Invoice lines and a discount as a percentage or an amount
  • PDF invoices and acceptance certificates
  • A document template for each seller
  • Bilingual invoices for foreign clients
  • Duplicate an invoice in one click

02 · 4

Payments and contractors

  • One payment split across several invoices
  • Automatic payment status for invoices and expenses
  • Expenses with amounts in hryvnias, dollars and euros
  • Overpayment moved to the next expense or kept as an advance

03 · 4

Services and packages

  • Service catalogue with cost and client price
  • Service packages assigned to clients
  • Monthly records with the margin for each package
  • “Invoiced” and “paid” flags

04 · 4

Balances and control

  • Client and contractor balance in each currency
  • Dashboard of unpaid invoices and debts
  • Change history for every record
  • Contracts and scans attached to records

Result

Every balance up to date, no recalculation

An invoice’s status now follows the money received: partial payments and several invoices paid at once are counted automatically, and each client’s balance is shown per currency.

Overpayments to contractors don’t get lost but become advances, monthly service records are built from clients’ packages together with the margin, and invoices and certificates export to PDF.