ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
PRE-AUDIT vs POST-AUDIT RECOVERY DASHBOARD
3
Freight Invoice Audit · Prevention vs Recovery Cost Analysis · v5 — Domain-Corrected
4
5
WHAT CHANGED IN v5
6
Five domain corrections applied: (1) Duplicate invoices now have asymmetric catch rates — Pre-Audit struggles with batch complexity (1-2 real duplicates hidden among 4-25 similar invoices), Post-Audit recovers more via cross-reference. (2) Demurrage splits into Confirmed (resolvable) vs Pending Client Review (SOP-routed). (3) Fuel Surcharge catch rate is now a blend of domestic (~54%, geography billing issues) and international (~72%, advance notice of changes). (4) Accessorial error RATE spikes Jun-Aug, not just volume. (5) Client mix is now 30% domestic / 40% Asian / 30% European, with Chinese New Year (Jan-Mar) and European slowdown (Oct-Jan) seasonality.
7
8
9
10
11
PRE-AUDIT TEAM
12
Paid a flat $0.85 per invoice reviewed. Value = avoided cost — money that never leaves the building because the error was caught before the carrier was paid.
13
14
15
16
POST-AUDIT TEAM
17
Contingency-based recovery firm paid 28% of recovered dollars. Value = recovered cost — money already paid out, clawed back via a slower, more expensive claim process.
18
19
20
21
HOW TO USE THE DASHBOARD
22
Go to 🎯 Dashboard. Use the month dropdown (cell O5) to switch months — every KPI, chart, and the error-type breakdown updates automatically via INDEX/MATCH formulas.
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100