SUA Spreadsheet Instructions

SUA Spreadsheet Instructions - SYSTEMS UNDERSTANDING AID...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
SYSTEMS UNDERSTANDING AID INSTRUCTIONS AND ASSIGNMENT SCHEDULE FOR USING THE ELECTRONIC SPREADSHEET PORTION OF THE ASSIGNMENT Option 1 The purpose of this exercise is to show you that the preparation of a year-end worksheet, financial statements, and a post-closing trial balance with the use of an electronic spreadsheet is extremely simple and is an important way to save time. 1. Do not begin the spreadsheet application until the entire Systems Understanding Aid project is completed, including "WRAPPING UP" on page 15 of the Instructions, Flowcharts, and Ledgers book. 2. Obtain instructions from your course instructor on how to obtain a copy of the SUA spreadsheet file. This file will be used to prepare Waren's year-end worksheet, financial statements, and post-closing trial balance. The spreadsheet is available in Microsoft Excel 97. Your instructor will provide you with the appropriate file. 3. After obtaining the appropriate file from your instructor, open it using MS Excel. If you are using transactions list A for the SUA project, the file you will use is named “SUA version A.xls.” If you are using transactions list B for the project, the file you will use is named “SUA version B.xls.” After opening the file, you will be in the year-end worksheet portion [sheet 1] of the file. The financial statements [sheets 2, 3, and 4] and the post-closing trial balance [sheet 5] are separate sheets stacked behind this front sheet. Notice the tabs at the lower left portion of the screen identifying each of these separate
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/31/2008 for the course ACCT 3013 taught by Professor Romi during the Spring '08 term at Arkansas.

Page1 / 3

SUA Spreadsheet Instructions - SYSTEMS UNDERSTANDING AID...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online