Red Gregory

View Original

Freelance Hourly-Rate Log In Notion

This little template can be paired with a master sprint plan, content calendar or general workspace dashboard if so desired. I would get creative with relations in this case. I have not implemented it as of yet into my work page due to a pause to my client work, but I will be using it in the future. This is something I’ve always wanted - an hours logged per task database. My log has only one property for hourly-rate of which requires an amount of money earned per hour input, however, I’m aware some freelancers have multiple hourly rates for certain projects. In this case I would turn the hourly-rate formula into an “IF statement” (example below).

Hours Logged Formula:

dateBetween(prop("Clock Out"), prop("Clock In"), "hours")

Pay-Out Formula:

prop("Hours Logged") * prop("Hourly-Rate")

Customize hourly-rate formula in relation to certain project type:

if(prop("Job") == "INSERT JOB HERE", #, if(prop("Job") == "INSERT JOB HERE", #, 0))

COPY TEMPLATE