클래식 파일 유형은 2020 년 12 월 Flash가 종료되면서 지원이 중단됩니다. 중단을 방지하려면 파일을 다음 세대로 전환하십시오. 더 알아보기

Is it best to do Variances in the Document directly or link to a spreadsheet

댓글

댓글 3개

  • Jonathan Dapeer

    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.

    0
  • Jill Yaspan

    We perform all of our calculations in a master spreadsheet, including rounding and check totals. Thus, the amounts in the spreadsheet are linked to the document, including summations and any other calculations.

    0
  • Edith Li

    Like Jill, we perform our calculations in a master 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.

    0

댓글을 남기려면 로그인하세요.