Accounts Payable template
Vendors, bills, and payments with validated IBAN, BIC/SWIFT, and EU VAT fields, a computed total and overdue flag, a due-date calendar — and a deliberately wrong IBAN (BG80BNBG96611020345679) in the sample data: paste it into the IBAN field and the checksum refuses it live.
Tables
Vendors
Vendor, VAT number, IBAN, BIC / SWIFT, Country, Category, Billing email, Phone, Registered address, Payment terms, Account owner, Vendor since, Reliability, Credit limit and 5 more
Bills
Bill #, Vendor, Received, Due, Net amount, VAT %, Total, Status, Paid on, Vendor record, Payment terms, PO reference, Currency, Approval and 4 more
Payments
Reference, Bill, Date, Amount, Method, Bill record, Vendor, Receiving IBAN, Receiving BIC, Currency, Bank fee, Net paid, Cleared, Made by and 1 more
Views
- All bills (grid)
- By status (kanban)
- Due dates (calendar)
- Unpaid & overdue (grid)
- Payment log (grid)
Forms
- Record a payment
Automations
- Notify when a bill is added
- Email finance on payment
- “Bills” reached “Overdue”
- Daily sweep — still open in “Bills”
- “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.