Build a timesheet from your Google Calendar™ in seconds, ready to invoice.

Pick your calendars and a date range (last month, this month, last week, this week or custom dates), tell the add-on which events belong to which client, and press Build. You get two tabs in your sheet:

• Timesheet: one row per event per day, with date, start, end, hours, client, event, calendar, rate and amount.
• Client summary: entries, hours, rate and amount for each client, with totals.

The summary is built from formulas, so if you change a client, hours or a rate on the timesheet, the totals update straight away.

ACCURATE HOURS
• Events are clipped to the dates you choose. A meeting that runs past the end of the month only counts the part inside it, and nothing outside the range is ever included.
• Overnight events are split at midnight, so each day's hours are right.
• The same meeting on two of your calendars is only counted once.
• Declined events, cancelled events, out-of-office blocks and working-location entries are skipped.
• Optional rounding to 6, 15 or 30 minutes or an hour, to the nearest step or always up.

CLIENTS AND RATES
• Match events to clients by keyword in the title, description or location, by attendee email domain, by a particular attendee, by event colour, or by calendar.
• Each client has its own hourly rate, with a default rate for everything else.
• Events that match no client can be included as "(No client)" or left out.
• Settings are saved with the spreadsheet, so next month it's one click: Extensions → Calendar Timesheets & Billing → Rebuild with saved settings.

PLANS
• Free: one calendar at a time, this month or last month, with clients, rates, rounding and the summary included.
• Pro, $5 a month or $39 a year: every calendar at once and any date range up to two years. Upgrading happens in the sidebar and unlocks within seconds, on the Google account you're using. Your receipt includes a licence key, so you can move Pro to another account at any time. Cancel whenever you like from "Manage subscription".

PRIVACY
• Read-only calendar access: the add-on can't create, change or delete events.
• Your events never leave Google. They're read and written into your sheet by Google Apps Script™.
• It only opens the spreadsheet you're using it in, never your other files, Gmail™ or Google Drive™.
• To check your plan it sends only your Google account's email address to our licence server, along with anonymous counts of how often the add-on is used.

Help: https://apps.onibaku.co.uk/calendar-timesheets/ · Support: admin@onibaku.co.uk

Google Calendar™, Google Sheets™, Gmail™, Google Drive™ and Google Apps Script™ are trademarks of Google LLC.