Free tool

Supplier bill tracker free Excel template

Every supplier invoice in one sheet, with the due date, what is still unpaid and what is overdue. Built for UAE shops, with 5% VAT.

SupplierInvoice no.Invoice dateBefore VATVAT 5%TotalDue dateBalanceStatus
Example Trading LLCINV-10423 Mar1,200.0060.001,260.002 Apr1,260.00Due

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.
Download free Excel template

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 WhatsApp

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

More free tools

See all free tools