Spreadsheet Design: An Optimal Checklist For Accountants

Abstract

Just as good grammar, punctuation, style, and content organization are important to well-written documents, basic fundamentals of spreadsheet design are essential to clear communication. In fact, the very principles of good writing should be integrated into spreadsheet workpaper design and organization. The unique contributions of this paper are an integration of a review of the literature on spreadsheet design, with the results of a convenience survey of CPAs, and a “Spreadsheet Design Checklist” for pedagogy. The checklist is intended as a reference for use until the student or professional becomes proficient in basic spreadsheet design and organization and the checklist becomes just as  “second nature” as creating well-written memoranda.