Appearance
Understanding Formulas on the AFS (Desktop)
What it is: An explanation of how Draftworx Desktop's AFS cells pull data from the Working Trial Balance using link-number formulas — so users can understand why a figure appears and how to change descriptions when needed.
What it's for
Most cells on the AFS are formula-driven, not free text. Understanding what the formula does helps users troubleshoot wrong figures, trace where a description comes from, and know whether changing a cell is safe. This guide explains the key formula patterns without requiring any technical knowledge.
How to do it
Reading formula patterns
The formulas use shorthand that tells you what data is being collected:
| Formula element | What it means |
|---|---|
| SUMIF | Total the sum of all matching WTB links in the formula |
| TBLink | Pull a figure from a specific Working Trial Balance link |
| ? (wildcard) | Include all link numbers 000–999 for that category |
| Final | Use the current year's WTB data |
| Prior / Prior1 | Use the prior year's WTB data |
| Disclosure, MATCH + link number | Description comes from the WTB Disclosure Description for that link |
Change a description that comes from the WTB
- Identify the link number in the cell's formula (look for "Disclosure, MATCH" + the link number).
- Navigate to the Working Trial Balance and filter for that link number.
- Edit the description in the Disclosure Description column.
- The updated description will appear on the relevant AFS cell automatically.