Time write-off review across time tracker, ERP and billing: a system map of records and linking keys

Short answer

Five linking keys join a time write-off review across systems: the time entry ID that ties hours to their narrative, the original project and task code, the adjustment ID that pairs a reversal with its replacement lines, the reason code with the reviewer's name, and the invoice or credit note number that shows what the client was finally charged. The entry ID is the hinge. If a system rewrites the entry in place, the move between projects disappears.

Visual briefFull-size diagram
Five systems arranged around one write-off case, time tracker, project accounting, adjustment journal, review notes and billing, with the linking keys entry ID, project code, adjustment ID, reason code and invoice number travelling along the spokes to join the case.
Illustrative system map for a fictional engineering firm; real keys and systems vary by firm.

This system map is part of the time write-off review guide, which covers what to inventory before a platform change. This page does a narrower job for an accountant advising a professional services firm: it names each system, the record it holds, the key that should carry across, and who owns it, then joins one Illustrative case end to end.

Five systems that each hold part of the decision

A write-off decision is rarely made in one tool. In a typical consultancy, engineering practice or agency, the pieces sit in five places:

  • Time tracker. The timekeeper's entry: hours, date, task and the free-text narrative. The narrative is often the only clue that the work served a second project. The time entry narratives page explains why that text carries so much.
  • Project accounting in the ERP. The project, phase and budget the hours were charged to, plus the fee arrangement that decides whether extra hours can be billed at all.
  • Adjustment or correction journal. The record of change. In Microsoft's project accounting, an adjustment marks the original transaction Adjusted, posts a reversal and posts a new transaction with the change; only statuses the firm has enabled can be adjusted. A correction journal for approved time does the same for actuals.
  • Review notes. The reviewer's reason and sign-off. Sometimes a reason code on the adjustment; often a comment on the pre-bill worksheet, or a thread in email.
  • Billing. The invoice that carried the replacement lines, and any credit note. Microsoft documents that an entry already invoiced, or sitting on a draft invoice, cannot be recalled unless a corrective invoice issues a full credit on the original, so late write-offs leave a credit as well as a journal line.

System, record, linking key and owner

The table is the map itself. Fill it from the firm's answers; write "unknown" where nobody can confirm.

SystemRecordLinking key it should carryOwner
Time trackerTime entry and narrativeEntry ID, timekeeper, original project and task codePractice operations head
ERP project accountingProject, phase, budget, fee typeProject codeController
Adjustment journalReversal lineOriginal entry ID, adjustment IDBilling manager
Adjustment journalReplacement linesAdjustment ID, new project codeBilling manager
Review notesReason and reviewer sign-offAdjustment ID or entry ID, reviewer, dateEngagement or project manager
Billing moduleInvoice linesInvoice number, replacement line IDsBilling manager
Billing moduleCredit noteCredit number, original invoice numberController
EmailClient query or acceptanceInvoice number in the subject or bodyEngagement partner

Two rows decide whether the case can be rebuilt. The reversal line must keep the original entry ID, and the reason must be stored against the adjustment, not just in someone's inbox. A firm that kept both has a decision trail; a firm that kept neither has net hours.

One fully joined case (Illustrative)

Fictional data for a fictional 260-person engineering consultancy. Not a real firm, client or engagement.

A senior engineer logs 16 hours across a week to project P-2210, a hospital fit-out. The narrative reads "load calcs for level 3 risers, shared with clinic annex scope." At pre-bill review the project manager notices the clinic annex is a separate project, P-2231, under a different fee arrangement.

StepSystemRecordKey that joins it to the next
1Time trackerEntry TE-48812, 16 hours on P-2210Entry ID TE-48812
2Time trackerNarrative mentions the clinic annexEntry ID TE-48812
3Adjustment journalReversal of 16 hours on P-2210, original marked AdjustedAdjustment ID ADJ-0917 references TE-48812
4Adjustment journalReplacement: 8 hours on P-2210, 6 hours on P-2231, 2 hours written offAdjustment ID ADJ-0917
5Review notesReason code "served two projects", approved by the project managerADJ-0917, reviewer, date
6BillingInvoice INV-7731 carries 8 hours for P-2210; INV-7745 carries 6 hours for P-2231Invoice numbers to replacement lines
7EmailAnnex client accepts INV-7745 without queryInvoice number INV-7745

The arithmetic holds: 8 plus 6 plus 2 is the original 16 hours. Every key is present, so the case reads from narrative to accepted invoice. Remove step 3's reference to TE-48812 and the case looks like three unrelated entries. Remove step 5 and nobody can say why 2 hours were absorbed.

Where the chain usually breaks

Entry to project. Some trackers let users or administrators change the project code on an entry in place. The move then leaves no reversal, and the original code is gone. Ask the billing manager whether a moved entry keeps a history.

Adjustment to reason. Reason codes are often optional. Ask what share of adjustments carry one, and where reviewers wrote reasons before a code list existed.

Billing to client outcome. Acceptance is usually implied by payment, while queries sit in email. If the engagement partner's mailbox was not kept, the outcome is only partly recorded.

Tool changes. A previous time tracker kept for audit may hold the early years under different entry IDs. Ask whether a mapping between old and new IDs was kept. A firm already reviewing utilization and realization often knows the answer, because realization reports depend on the same history. The workflow map template is a general format for recording these answers.

Qualification and what stays unknown

The map describes records and owners. It does not decide who may license them. Narratives and invoices name clients and describe their projects, so engagement letters matter, and why data rights matter explains why SourceX reviews rights first. The who can say yes decision tree covers whom to introduce, and the worked exception case follows a similar split decision by decision, with who acted at each step.

The introduced firm needs 50+ full-time employees at peak (contractors excluded), a documented operating history, rights to license and an authorized contact. Companies in the U.S., Canada and the EU qualify, as do companies in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia when at least 90% of the data is in English. Partners sign the Channel Partner Agreement before submitting introductions; the first valid introduction within the 90-day window is credited when the company submits a verified application, and one partner is credited per company. Keep discovery at metadata level: never request entries, narratives or invoices. Buyer interest, the rights outcome, the de-identification required and any offer stay unknown until SourceX reviews the opportunity.

Next step

Refer a company. Earn up to $100,000. Default reward: 25% of Actual Supplier Payout, capped at $100,000 cumulatively per referred company. Eligibility and payment conditions apply, and a signed Schedule A or addendum can differ. A lead, meeting or signature alone does not trigger payment.

If the map shows a firm whose adjustments still point to their original entries and carry a reviewer's reason, register as a partner, check the firm against who qualifies, and read the program terms before introducing its leadership.

  1. Step 1Share your linkSend your personal link to a company you know.
  2. Step 2Company appliesThe company applies itself at /apply.
  3. Step 3Company signs and is paidThe company signs, delivers its data and is paid by SourceX under its agreement.
  4. Step 4You get your rewardYour 25% of the actual supplier payout. A reward becomes payable after SourceX has paid the referred company under its signed agreement and the payout conditions in the program terms are met, including finance approval and your tax and payment details.

Common questions

Can a time tracker export alone rebuild a write-off decision?

Rarely. The export usually shows hours as they stand today. The reversal pair, the reviewer's reason and the invoice or credit that followed often sit in the ERP, the billing module or email, so the export gives the result without the decision.

What if the firm edits entries in place instead of posting adjustments?

Then the move from one project to another may leave no trace in the system at all. Write that down as a gap. The firm may still hold pre-bill worksheets or reviewer emails that record the change, and SourceX's review decides whether those are usable.

Should I ask the billing manager for an example export to check the keys?

No. Ask the billing manager to describe, or show on screen within the firm, whether an adjustment points to its original entry. Never take a copy. The map is filled from answers, not files.

Sources

  1. refer.sourcex.si/terms
  2. learn.microsoft.com/en-us/dynamics365/project-operations/approva…
  3. learn.microsoft.com/en-us/dynamics365/project-operations/project…
  4. learn.microsoft.com/en-us/dynamics365/project-operations/psa/bul…

Free resources

Know a company with valuable proprietary data?

Become a referral partner, get your link and introduce the company’s CEO (in an owner-run company, usually the owner). Referral partners can join from most countries. We can't work with partners in countries or regions under U.S. sanctions or on U.S. restricted-party lists. The companies you introduce should be based in the U.S., Canada and the EU, or in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia with at least 90% of their data in English.

Refer a company →

I own a business

Explore licensing your company's data directly to SourceX for AI training and evaluation. Start a short assessment; no uploads needed.

Start an assessment