|
|
|
|
|
by dkersten
3127 days ago
|
|
> Validation: I'm confident that I can catch duplicated rows and mistyped amounts because Excel formulas verify that the sum of all transactions for each account equals the account balance, and that transfers between accounts add up to $0. Do I need anything more? I'm sure that the people who made these billion dollar mistakes were pretty confident too... https://www.cio.com/article/2438188/enterprise-software/eigh... "The error occurred when the accountant omitted the minus sign on a net capital loss of $1.3 billion" (Fidelity) "There were honest mistakes made in a spreadsheet used in the implementation of a new accounting standard." (Fannie Mae, $1.36 billion loss) There's a bunch of lower (million dollar) losses listed in the linked page too. |
|
I think that you need to show that Excel requires more data entry, or riskier data entry, or that Excel can't catch as many errors, etc. For now I'm not convinced.
[1] https://www.accountingweb.com/aa/auditing/human-errors-the-t...