Invoice & Payment Tracker template
Invoices, clients, and payments with validated IBAN, BIC/SWIFT, and EU VAT fields, a computed total and overdue flag, and a due-date calendar.
Tables
Clients
Client, VAT number, IBAN, BIC / SWIFT, Country, Billing email, Country code, Billing currency, DUNS, Payment terms, Account owner, Finance contact, Phone, Registered address and 8 more
Invoices
Invoice #, Client, Issued, Due, Net amount, VAT %, Total, Status, Paid on, Client record, Payment terms, Client PO, Currency, Raised by and 7 more
Payments
Invoice, Date, Amount, Method, Reference, Invoice record, Client, Received by, Receiving IBAN, Receiving BIC, Currency, FX rate, Bank fee, Cleared and 4 more
Views
- All invoices (grid)
- Pipeline (kanban)
- Due dates (calendar)
- Unpaid (grid)
- Payment log (grid)
Forms
- Record a payment
Automations
- Notify when an invoice is added
- Email finance on payment
- “Invoices” reached “Overdue”
- Daily sweep — still open in “Invoices”
- “Cleared” was ticked in “Payments”
- Large value in “Net amount”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.