Freelancer invoices
Hours worked in Connecteam against the invoices received — who still has to invoice which month.
/ Hours worked vs invoiced Click a person for shifts, invoices and actions
/ Invoices to check Totals that do not add up, hours that differ from the registered shifts, dates billed twice, a different rate
/ Who is this? Invoicing companies not yet linked to a person
Data sources Connecteam and Yuki are pulled automatically every night; buttons below run it now
Beerbike planning sheet
—
The Google Sheet with the ride planning pushes its rows to this page through a small script (PushBeerbikePlanning.gs) on a schedule; every driver in the planning becomes a person here, followed automatically. Drivers invoice per hour, so the hours come from the planned start and end times.
Connecteam (API)
—
Yuki / Nmbrs Accounting (API)
—
+ Manual uploads (fallback when the APIs are not available)
Connecteam timesheet (.xlsx)
Time Clock → Timesheets → export "Timesheet overview" for the period (all employees). Shifts already known are updated, new people are added.
Yuki / Nmbrs Accounting transactions (.csv)
Financials → Transactions → export for the year (the tab-separated file). Only the "Purchase of services" lines (60200) are used.
HubSpot tickets already stored
New tickets are classified as they arrive. Tickets stored before this page existed are only recognised by company name — press this after linking companies under "Who is this?" to tag them too (they move to "Handled without a PO" on the PO page).