Building a Job-Costing Worksheet for Offshore Drafting Hours

Start each row with the job number the drafting hours belong to, pulled straight from your project accounting system rather than re-typed from memory. List the hours logged for that job in that billing period next to it.

This sounds obvious, but the firms that lose track of job-level cost are usually the ones where the drafting invoice arrives as one lump sum across several jobs, and someone has to split it after the fact instead of the split being built in from the start.

Record the local currency amount owed and the actual exchange rate used at the moment of conversion, not an estimated or budgeted rate. This is the number that lets you see, job by job, whether currency movement between when the work was done and when it was paid actually mattered.

Over several billing cycles, this column shows you whether your project budgets need a currency buffer built in, or whether the drift has been small enough to ignore.

This is the number your client actually sees, converted to your invoicing currency at whatever markup or pass-through policy your firm uses. Keeping this separate from the raw local currency amount in column two makes it easy to check that your markup policy is being applied consistently across jobs, rather than drifting job to job based on whoever prepared that particular invoice.

Track whether the drafting payment went through Wise or Payoneer for that billing period, since firms sometimes switch based on which market the drafting team is in that month. Over time, this column lets you compare the actual landed cost, fees plus spread, between the two platforms for genuinely similar transfers, instead of relying on a general impression of which one is cheaper.

When a project wraps and it's time to reconcile actual cost against the original fee proposal, this worksheet is what lets you answer the question a principal will eventually ask: did offshore drafting cost more or less than budgeted, and why. Pull every row for that job number and total column two, the actual local currency amounts converted, against whatever was budgeted for drafting support at proposal stage.

A gap that's mostly currency drift tells you to build a small buffer into future proposals for jobs with a similar drafting mix. A gap that's mostly more hours than budgeted is a scoping conversation, not a currency one, and the worksheet is what lets you tell the two apart instead of guessing.

Job-costing worksheets fail quietly when they live in one project manager's personal file and stop getting updated the moment that person is out for a week or moves to a new role. Keep the worksheet in a shared location that the whole project accounting function can see and update, with the job number as the field that ties it back to your actual project accounting system.

The firms that struggle to answer basic questions about offshore drafting cost at year-end are usually the ones where this worksheet existed for a while, in someone's head or someone's laptop, and then quietly stopped.

Some firms pay drafting invoices the day they arrive, others batch them at month end, and a few do both depending on who's handling AP that week. Mixing schedules within the same drafting relationship makes the worksheet's rate column noisy in a way that's hard to interpret later, since you can't tell whether a bad month was really bad or whether it just happened to fall on a bad conversion day.

Pick one schedule for a given drafting relationship and stick to it for at least a full quarter before changing it. Consistency in when you convert is what makes the worksheet's currency drift column actually mean something.

Keep the worksheet reliable with these habits:

• Pull the job number from your project accounting system instead of retyping it, and ask the drafting team to itemize hours by job on every invoice.
• Record the actual exchange rate at the payment date, not an estimated or budgeted rate.
• Apply your markup or pass-through policy consistently so the reimbursable column doesn't drift from job to job.
• Pay drafting invoices on one consistent schedule so the rate column stays easy to interpret.
• Keep the worksheet in a shared location that the whole project accounting function can update.