Excel bill tracker template

Record the description, stated date, amount and status. Use clear labels for pending, paid and unconfirmed.

Ready to print 1 printable

View preview

Currency

US dollar ($)
Pound sterling (£)

Recording example

Record the description, stated date, amount and status. Use clear labels for pending, paid and unconfirmed. When an amount changes, keep the update date so you know which information you are viewing.

Check the data

Do not confuse a planned date with payment confirmation. The sheet records your notes; it does not send payments or confirm bank transactions. Check entries against the relevant document.

Check formulas and units

Test the sheet with two or three simple amounts and check the total manually. Distinguish input cells from calculated cells. Do not add amounts from different currencies or periods as though they were equivalent; the template organizes the data you enter.