Database, Templates

An Active Invoice Notion Template With Unique ID Property

Screen Shot 2020-06-02 at 7.45.14 PM.png

โญ•๏ธ Active Invoices

This Notion template is intended for those seeking a layout for simple invoices, deadlines, overdue status and more. I also provide task grading to keep track of quality of jobs for a re-hire probability (especially useful for those working with remote contractors regularly).

Properties included in this Notion template:

Unique Invoice ID โ†’ slice(prop("STATUS โœ…"), 0, 2) + ((prop("AMOUNT PAID") == 0) ? "000" : "111") + formatDate(prop("DUE ๐Ÿ”ฅ"), "MDYY")

Corrections โ†’ Parent-Child relation

Assigned To โ†’ Name

Due Date โ†’ Date

Job Cost โ†’ Number

Amount Paid โ†’ Number

Status โ†’

  • if(date(dateSubtract(prop("DUE ๐Ÿ”ฅ"), 5, "days")) == date(now()), "FOLLOW UP NOW", if(date(now()) >= date(prop("DUE ๐Ÿ”ฅ")), "๐Ÿ“ฉINVOICE NOW", if(now() < prop("DUE ๐Ÿ”ฅ"), "๐Ÿƒโ€โ™‚๏ธWORKING", if(now() > prop("DUE ๐Ÿ”ฅ") and prop("TOTAL ๐Ÿ’ธ") == prop("AMOUNT PAID"), "โœ…COMPLETE", ""))))

Rating โ†’ 1-5 Stars

Job Type โ†’ Select

Hourly Rate โ†’ Number

Email โ†’ Worker's email

Complete? โ†’ Checkbox

Screen Shot 2020-03-17 at 2.25.43 PM.png