Timesheet import

Import a timesheet

You already hold the work record — that is what self-billing means. Drop the file in and each row becomes an invoice line, matched to your register by the contractor’s CTR-000n reference and grouped into one draft invoice per contractor. Nothing is issued: every draft still goes through approve → issue → supplier acceptance.

Showing sample data — connect Supabase to persist imported drafts beyond this session.

Used only where the file has no date column — row dates set each invoice’s period when they are there.

Columns

contractor_ref — required
Matches the register (CTR-0001)
description — required
Becomes the line description
unit_price — required
Also read as rate / price
quantity — optional
Also hours/units; defaults to 1
date — optional
Sets each invoice’s period span
unit_code — optional
UN/ECE Rec 20; defaults to C62

VAT is never taken from the file. Each line’s VAT comes from that supplier’s registration status, so an unregistered contractor’s lines stay category O whatever a spreadsheet says.

← Back to the invoice register