home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The Unsorted BBS Collection
/
thegreatunsorted.tar
/
thegreatunsorted
/
texts
/
term_papers
/
columbia.#ia
< prev
next >
Wrap
Text File
|
1993-06-03
|
17KB
|
390 lines
"1.0"
"09/01/--"," "," ","Columbia River Nursery"," "
1,2,1,2,1
1,3
"100 "
"199 "
"200 "
"299 "
"300 "
"399 "
"400 "
"499 "
"500 "
"519 "
"520 "
"599 "
"600 "
"699 "
"700 "
"799 "
" "
" "
"121"
"199"
"221"
"299"
"111 "
"120 "
"Total Current Assets"
"121 "
"199 "
"Total Plant Assets"
"211 "
"220 "
"Total Current Liabilities"
"520 "
"529 "
"Total Selling Expenses"
"530 "
"539 "
"Total Administrative Expenses"
" "
" "
""
" "
" "
""
" "
" "
""
" "
" "
""
""
""
""
"111 "
"112 "
"113 "
" "
" "
"211 "
"311 "
"312 "
" "
"313 "
" "
" "
""
""
""
37
"111 ","Cash "," ",54256,54256,0
"112 ","Accounts Receivable "," ",34990,34990,0
"113 ","Merchandise Inventory "," ",122963,122963,0
"114 ","Store Supplies "," ",1242,1242,0
"115 ","Prepaid Insurance "," ",1698,1698,0
"121 ","Land "," ",22500,22500,0
"122 ","Building "," ",142000,142000,0
"123 ","Accum. Depr.--Building "," ",-126900,-126900,0
"124 ","Office Equipment "," ",28730,28730,0
"125 ","Accum. Depr.--Ofc. Eqpt. "," ",-18612,-18612,0
"126 ","Store Equipment "," ",29850,29850,0
"127 ","Accum. Depr.--Store Eqpt."," ",-22620,-22620,0
"211 ","Accounts Payable "," ",-44787,-44787,0
"212 ","Salaries Payable "," ",0,0,0
"221 ","Notes Payable "," ",-60000,-60000,0
"311 ","Ann Noble, Capital "," ",-165310,-165310,0
"312 ","Ann Noble, Drawing "," ",0,0,0
"313 ","Income Summary "," ",0,0,0
"411 ","Sales "," ",0,0,0
"412 ","Sales Returns & Allow. "," ",0,0,0
"413 ","Sales Discounts "," ",0,0,0
"510 ","Purchases "," ",0,0,0
"511 ","Purchases Ret. & Allow. "," ",0,0,0
"512 ","Purchases Discounts "," ",0,0,0
"513 ","Transportation In "," ",0,0,0
"520 ","Sales Salaries Expense "," ",0,0,0
"521 ","Advertising Expense "," ",0,0,0
"522 ","Depr. Exp.--Store Eqpt. "," ",0,0,0
"523 ","Store Supplies Expense "," ",0,0,0
"529 ","Misc. Selling Expense "," ",0,0,0
"530 ","Office Salaries Expense "," ",0,0,0
"532 ","Depr. Exp.--Ofc. Eqpt. "," ",0,0,0
"533 ","Insurance Expense "," ",0,0,0
"535 ","Depr. Expense--Building "," ",0,0,0
"539 ","Misc. Administrative Exp."," ",0,0,0
"610 ","Rent Income "," ",0,0,0
"710 ","Interest Expense "," ",0,0,0
6
"210","Chin's Orchards ",-25970,-25970
"220","Northwest Fertilizer Co. ",0,0
"230","Tri-City Equipment Co. ",-3192,-3192
"240","Umpqua River Greenhouses ",0,0
"250","Weber & Hill ",-8425,-8425
"260","Willamette Cedar Products",-7200,-7200
8
"310","Blue Mountain Co-op ",5423,5423
"320","Central Community College",6950,6950
"330","Kurt's Cash & Carry ",0,0
"340","M & D Landscape Design ",0,0
"350","McBurns Landscapers ",0,0
"360","Pine River Mall ",6450,6450
"370","Valley Home Improvement ",10475,10475
"380","West Valley Country Club ",5692,5692
0
7,0,7,0,15
0,7,0,7,15
7,0,7,0,15
0
Instructions:
-------------
Listed below are the step-by-step instructions for solving "Columbia
River Nursery" using Solutions Software. If you have a printer
attached, press the F9 key to print the instructions now. Once the
instructions are dismissed from the screen, they can only be retrieved
by reloading the opening balances file.
Press the Esc key to return to the accounting program.
Step 1: In the General Information data entry window, key the run
date to September 30 of the current year. Key your name in
the Student Name field.
Operating Procedure: Key the run date to September 30 of the
current year. Press the Insert key to overwrite the existing
date. Key your name in the Student Name field. Press
Ctrl-Enter to select the Ok button.
Step 2: Save the opening balances file you just loaded to your drive
and directory with a file name of XXXCRN (where XXX are your
initials and CRN indicates "Columbia River Nursery."
Operating Procedure: Press the Alt key to access the Menu
bar. Press Enter to pull down the File menu. Use the
down arrow key to choose the Save As command. Press Enter.
Key the path to the drive and directory that contains your
data files (for example, if you wish to save your data to
Drive B, key B: as the path name). Key a file name of
XXXCRN where XXX are your initials and CRN indicates Columbia
River Nursery. Press Ctrl-Enter to select the Ok button.
Step 3: Key the journal entries. Use the appropriate journals.
Operating Procedure: Press the Alt key to access the Menu
bar. Press the right arrow key to Journals and press Enter
to pull down the Journals menu. To choose a journal, use
the down arrow key and press Enter.
In the General Journal, key the date of each transaction.
Key the general journal entries. Press F1 to review
the chart of accounts. After the entries are keyed, press
Ctrl-Enter to select the Ok button. When the Posting
Summary appears, press Ctrl-Enter to select Post.
Note: To record the transactions involving sales returns
and purchases returns, key the memorandum number in the
Reference field.
In the Purchases Journal, for each entry, key the date of
the transaction and the vendor number. Press F2 to review
the vendor list. Leave the invoice number field blank. Key
the invoice amount. The credit entry to Accounts Payable
is automatically made by the computer. Key the account
number(s) and debit amount(s). After each entry is keyed,
press Ctrl-Enter to select the Ok button. When the Posting
Summary appears, press Ctrl-Enter to select Post.
In the Cash Payments Journal, for each entry, key the date
of the transaction, vendor number and check number. Press
F2 to review the vendor list. Key the debit amount to the
Accounts Payable Debit field. The credit entry to Cash is
automatically made by the computer. After each entry is
keyed, press Ctrl-Enter to select the Ok button. When the
Posting Summary appears, press Ctrl-Enter to select Post.
Note: An entry to the Purchases Discounts account must be
keyed in the debit column as a negative amount.
In the Sales Journal, for each entry, key the date of the
transaction. Key the customer number, invoice number and
invoice amount. Press F3 to review the customer list. Key
the account number of the credit entry. The debit entry to
Accounts Receivable is automatically made by the computer.
After each entry is keyed, press Ctrl-Enter to select the Ok
button. When the Posting Summary appears, press Ctrl-Enter
to select Post.
In the Cash Receipts Journal, for each entry, key the date of
the transaction. Key the customer number. Press F3 to review
the customer list. Leave the Reference field blank. Key the
credit amount in the Accounts Receivable credit field. The
debit entry to Cash is automatically made by the computer.
After each entry is keyed, press Ctrl-Enter to select the Ok
button. When the Posting Summary appears, press Ctrl-Enter to
select Post.
Note: An entry to the Sales Discounts account must be keyed
in the credit column as a negative amount.
Step 4: Display the journal entries.
Operating Procedure: Press the Alt key to access the Menu
bar. Use the right arrow key to select Reports and press Enter
to pull down the Reports menu. Use the down arrow key to
choose the Journals command. Press Enter. When the Report
Selection window appears, place an "X" in the boxes of the
Journals to display. Press Ctrl-Enter.
When the Selection Options window appears, verify the date
range of 09/01/YY to 09/30/YY (where YY is the current year).
Leave the Reference restriction field blank. Press Ctrl-Enter.
When each of Journal reports is displayed, press the F9 key
to print. Press Esc to close the windows.
Step 5: Make corrections to the journal entries, if necessary.
Operating Procedure: Select the List option in each of the
Journal screens by pressing the End key, then use the left
arrow key to choose List at the bottom of the screen.
Press Enter to review the list of journal entries. To
choose the journal entry to correct, use the arrow keys to
move to the entry, then press Enter. Make the correction(s)
and press Ctrl-Enter to select the Ok button. Press Enter
to Post.
Step 6: Display a trial balance, schedule of accounts payable, and
schedule of accounts receivable.
Operating Procedure: Press the Alt key to access the Menu
bar. Use the right arrow key to choose Reports and press
Enter to pull down the Reports menu. Use the down arrow key
to choose the Ledgers command. Press Enter. Press the space
bar to place an "X" in the Trial Balance box. Use the down
arrow key to choose Schedule of Accounts Payable and Schedule
of Accounts Receivable. Press the space bar to place an "X"
in each box. Press Ctrl-Enter. When each of the reports is
displayed, press the F9 key to print. Press Esc to close the
windows.
Step 7: Key the adjusting entries. Use the trial balance report
prepared in Step 6 as the basis for preparing the adjusting
entries.
Operating Procedure: Use the General Journal. Key
September 30 as the date of each entry. Key ADJ.ENT. in the
Reference field. Key the adjusting entries. Press F1 to
review the chart of accounts.
After the adjusting entries are keyed, press Ctrl-Enter to
select the Ok button. When the Posting Summary appears,
press Ctrl-Enter to select Post.
Step 8: Display the adjusting entries.
Operating Procedure: Press the Alt key to access the Menu
bar. Use the right arrow key to select Reports and press Enter
to pull down the Reports menu. Use the down arrow key to
choose the Journals command. Press Enter. When the Report
Selection window appears, select General Journal by using the
down arrow key. Press the space bar to place an "X" in the
General Journal box. Press Ctrl-Enter.
When the Selection Options window appears, verify the date
range of 09/01/YY to 09/30/YY (where YY is the current year).
Key ADJ.ENT. in the Reference restriction field so that only
the adjusting entries are reported. Press Ctrl-Enter. When
the General Journal report is displayed, press the F9 key to
print. Press Esc to close the window.
The Report Selection and Selection Options screens appear below.
=═════ Report Selection ══════╗
║ ║
║ [ ] Opening Balances ║
║ [X] General Journal ║
║ [ ] Purchases Journal ║
║ [ ] Cash Payments Journal ║
║ [ ] Sales Journal ║
║ [ ] Cash Receipts Journal ║
╠═════════════════════════════╣
║ [ Ok ] < Cancel > ║
╚═════════════════════════════╝
=░░░░░░░░░░░ Selection Options ░░░░░░░░░░░╗
║ ║
║ Journals: ║
║ ║
║ Date range: 09/01/YY to 06/30/YY ║
║ ║
║ Reference restriction: ADJ.ENT. ║
║ ║
╠═════════════════════════════════════════╣
║ [ Ok ] < Cancel > ║
╚═════════════════════════════════════════╝
Step 9: Make corrections to the adjusting entries, if necessary.
Operating Procedure: Select the List option in the General
Journal screen by pressing the End key, then use the left
arrow key to choose List at the bottom of the screen.
Press Enter to review the list of adjusting entries. To
choose the adjusting entry to correct, use the arrow keys to
move to the entry, then press Enter. Make the correction(s)
and press Ctrl-Enter to select the Ok button. Press Enter
to Post.
Step 10: Display the income statement, balance sheet, and statement of
owner's equity.
Operating Procedure: Press the Alt key to access the Menu
bar. Use the right arrow key to choose Reports and press
Enter to pull down the Reports menu. Use the down arrow key
to select the Financial Statements command. Press Enter.
Press the space bar to place an "X" in the box for each
financial statement. Press Ctrl-Enter. When each of the
financial statements is displayed, press the F9 key to
print. Press Esc to close the windows.
Step 11: Save your data file.
Operating Procedure: Press the Alt key to access the Menu
bar. Press Enter to pull down the File menu. Use the down
arrow key to choose the Save Accounting File command. Press
Enter.
Step 12: Perform period-end closing.
Operating Procedure: Press the Alt key to access the Menu
bar. Use the right arrow key to choose Options and press
Enter to pull down the Options menu. Use the down arrow key
to choose the Period-End Closing command. Press Enter. When
the dialog box appears, press Ctrl-Enter to select the Ok
button.
Step 13: Display a post-closing trial balance.
Operating Procedure: Press the Alt key to access the Menu
bar. Use the right arrow key to choose Reports and press
Enter to pull down the Reports menu. Use the down arrow key
to choose the Ledgers command. Press Enter. Press the space
bar to place an "X" in the Trial Balance box. Press Ctrl-
Enter. When the post-closing trial balance is displayed,
press the F9 key to print. Press Esc to close the window.
Step 14: Use the Save As command to save your data file to disk.
Operating Procedure: Press the Alt key to access the Menu
bar. Press Enter to pull down the File menu. Use the down
arrow key to choose the Save As command. Press Enter. Key
the path to the drive and directory that contains your data
files (for example, if you wish to save your data to Drive B,
key B: as the path name). Key a file name of XXXCRNP where
XXX are your initials, CRN identifies the problem, and P
indicates "post" closing.
Step 15: End the session.
Operating Procedure: Press the Alt key to access the Menu
bar. Press Enter to pull down the File menu. Use the down
arrow key to choose the Quit command. Press Enter.