| Supplier | Invoice no. | Invoice date | Before VAT | VAT 5% | Total | Due date | Balance | Status |
|---|---|---|---|---|---|---|---|---|
| Example Trading LLC | INV-1042 | 3 Mar | 1,200.00 | 60.00 | 1,260.00 | 2 Apr | 1,260.00 | Due |
Example row only. The file you download is empty and ready to use. VAT at 5%, the total, the due date, the balance and Due / OVERDUE / Paid fill in by themselves.
- •One row per supplier invoice, room for 200 bills.
- •Enter the amount before VAT and the credit days your supplier gives.
- •The sheet totals what you still owe and the VAT you paid on purchases.
Works in Excel, Google Sheets and Numbers. No signup, no email.
Want this done for you every day, without a sheet? Ask for a quick demo for your shop on WhatsApp.
Ask for a demo on WhatsAppHow to keep track of supplier bills
Supplier invoices arrive with every delivery, often on thin paper handed over at the counter in the middle of a sale. They end up in a drawer, and the first reminder that one was due is the salesman standing in the shop asking for payment. A shop that pays late loses credit terms; a shop that pays twice loses money. Both happen when bills are not written down in one place.
Enter each invoice on the day it arrives: supplier, invoice number, date and the amount before VAT. The sheet adds VAT at 5% and the total. Enter the credit days your supplier gives, for example 30, and the sheet works out the due date. If an invoice has no VAT or a different amount, simply type over the VAT cell.
When you pay, enter the amount and date. The balance and status update: Due, OVERDUE once the due date has passed, or Paid. A part payment keeps the invoice open with the remaining balance. At the side, the sheet totals everything you still owe, which is the number to look at before you place the next big order.
It also totals the VAT you paid on purchases. If your shop is registered for VAT, that figure matters for your VAT return, and you must keep the supplier's tax invoice as proof; the sheet does not replace it. When the drawer of paper becomes too much, Tallium AI reads a photo of each supplier bill, records it, tracks the due date and prepares the VAT figures for you.
Frequently asked questions
Stop juggling spreadsheets. Tallium AI runs invoicing, VAT & corporate tax, POS and inventory in one simple app.