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. BUYING AND CANCELLING • Sold by Onibaku Limited (company 16480716), 48 Buckingham Road, Cadishead, Manchester M44 5HG, not by Google. Payments are processed by Stripe. • Monthly and yearly plans renew automatically until you cancel. We'll tell you at least 30 days before any price change affects your renewal. • Cancel at any time from "Manage subscription" in the add-on, or with a single email to admin@onibaku.co.uk. Pro stays active until the end of the period you've paid for. • UK consumers have a legal right to cancel within 14 days (the cooling-off period). On top of that, email us within 14 days of any payment and we'll refund that payment in full. • Terms of sale, including refunds: https://apps.onibaku.co.uk/terms 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.