Is it best to do Variances in the Document directly or link to a spreadsheet
Typically we put the change in line items in our MDA in the document. Is it better to do it in the document or in the spreadsheet
-
We find it best to perform all the math in the document (summations, $ or % variances). Those calculations can be linked from the document back to the spreadsheet to perform additional validations/check figures.
0We perform all of our calculations in a primary spreadsheet, including rounding and check totals. Thus, the amounts in the spreadsheet are linked to the document, including summations and any other calculations.
0Like Jill, we perform our calculations in a primary spreadsheet. We include rounding there as well. That way those calculations update automatically when we update trial balances, those amounts can be linked to other documents quickly and updated from one file, and we can perform validation checks quickly.
0Please sign in to leave a comment.
Comments
3 comments