Pages tagged “invoice”

6 pages in Cellwise.

1. Add VAT to a price: net, VAT and total formulas

   Two cells that turn a net price and a rate into VAT and a gross total.

   invoice vat arithmetic

2. Auto-number invoices (INV-0001, INV-0002) with a formula

   Generate invoice numbers that count up as you fill in rows, with leading zeros.

   invoice text freelancer

3. Calculate days overdue for an invoice in Excel and Google Sheets

   One formula that returns how many days an unpaid invoice is past its due date, and zero if paid.

   invoice dates freelancer

4. Days overdue and a simple late fee for unpaid invoices

   Count days past due (zero if paid or not yet due) and work out a simple monthly late fee.

   invoice dates freelancer

5. Flag overdue invoices and colour the row red automatically

   A TRUE/FALSE overdue test and how to use it as a conditional formatting rule in Excel and Google Sheets.

   invoice conditional-formatting freelancer

6. Highlight overdue invoices automatically in Excel and Google Sheets

   One conditional-formatting formula that colours every unpaid invoice past its due date.

   invoice conditional-formatting freelancer

All pages