Notion For Finance: A Timesheet With Invoice Sum
The Project Database
Insert all projects and client info here including:
Hourly rate for each project
Client and client email
Hourly or flat rate
If a project is not an hourly gig and is being done at a flat rate, the Final Invoice will generate the flat rate you provide if the Done checkbox is true.
The To Invoice property will tally up a total suggested dollar amount for every project as sessions are completed.
There is another database view for archived projects. Just because a project is done doesn’t mean it’s finalized. Archive a project when all payments are made. Archived projects will disappear from the main database view into this one.
The Timesheet Database
Record tasks and assign Start and End Times to record time spent on each. Here you’ll record how long each session was. A reference to the project’s Hourly Rate will appear, and an invoice suggestion too.
Hours between the end and start time always round up. (ex. 4.2 hours = 5)