Demo data
Start Here
Setup in 5 steps: about 10 minutes, plus about 1 minute per row. The sheet map lists every sheet in tab order, with what it is for.
Nothing here is typed in. Your settings are on Setup. The status in row 3 of every sheet reads OK, CHECK (n) or SAMPLE.
Demo data
Setup
Each setting has its allowed values and its default beside it.
Change a setting at any time: the month lists, the Work Log checks and the results use it straight away.
Demo data
Dashboard
The report month is picked at the top (leave it blank for the latest month). Net fees, delivery cost, contribution before overhead, contribution margin and rows needing review follow it, in your report currency.
Do this next gives one step for the file as it stands. Ten checks, such as totals reconcile, rates present and no duplicate keys, give one overall status: OK, CHECK (n) or SAMPLE.
Demo data
Work Log
Record ID, client, project, month, fee currency, fees billed (before sales tax), credits, cost currency, external delivery costs, delivery hours, internal hourly cost and an optional note.
Holds 1,000 rows; the Guide gives the steps to add more. A row that fails a check reads Review and is left out of the totals until you fix it.
Demo data
FX Rates
Report in USD, EUR, GBP, AUD, CAD, NZD, JPY, SGD, HKD or CHF. The report currency is set on Setup.
Rates are typed as Australian dollars per 1 unit of each currency, so one rate per currency covers every pair. AUD is always 1. A source note is optional.
Demo data
Summary
Net fees, delivery cost, contribution before overhead, margin, delivery hours and contribution per delivery hour, for the report month and for all months.
Rows marked Review are counted and left out of the totals until they are fixed.
Demo data
Reference
Type each client name once; the Work Log client dropdown reads this list. It holds 200 clients.
The currency, month and theme lists and the fixed values, such as capacity and the reconcile tolerance, are shown in grey.
Demo data
Guide
Setup steps, every input and calculated column, every check and how to fix it, printing, protection, adding capacity and clearing sample data.
The changelog is the last section. Read it in Excel, or print it.