AccountingExplained
Home > Financial Accounting > Accounting Cycle > Accounting Worksheet
Accounting Worksheet
An accounting worksheet is large table of data which may be prepared by accountants as an optional intermediate
step in an accounting cycle. The main purpose of a worksheet is that it reduces the likelyhood of forgeting an
adjustment and it reveals arithmatic errors. A worksheet acts as a tool for an accountant and it is not usually intented
to be used by third parties. It is an informal document.
A typical worksheet consists of a column on the left showing main account titles and 10 more columns of debits and
credits showing trial balance, adjustments, adjusted trial balance, incomes statement and balancesheet.
Example
The following example shows a worksheet based on the data from various pages of this chapter. Scroll the worksheet
to the right to view all columns.
Account Title Unadjusted Trial Adjustments Adjusted Trial Income Statement Balance Sheet
Balance Balance
Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
Cash $20,430 $20,430 $20,430
Accounts 5,900 5,900 5,900
Receivable
Office 22,800 $18,48 4,320 4,320
Supplies 0
Prepaid Rent 36,000 12,000 24,000 24,000
Equipment 80,000 80,000 80,000
Accumulated 1,100 $1,100 $1,100
Depreciation
Accounts $5,200 5,200 5,200
Payable
Notes 20,000 20,000 20,000
Payable
Utilities 3,964 3,964 3,964
Payable
Interest 150 150 150
Payable
Unearned 4,000 $3,000 1,000 1,000
Revenue
Common 100,000 100,000 100,000
Stock
Service 82,600 3,000 85,600 $85,60
Revenue 0
Wages 38,200 38,200 $38,20
Expense 0
Supplies 18,480 18,480 18,480
Expense
Rent Expense 12,000 12,000 12,000
Depreciation 1,100 1,100 1,100
Expense
Miscellaneou 3,470 3,470 3,470
s Expense
Electricity 2,470 2,470 2,470
Expense
Telephone 1,494 1,494 1,494
Expense
Dividend 5,000 5,000 5,000
Interest 150 150 150
Expense
Totals $215,76 $215,76 $34,73 $34,73 $217,01 $217,01 $77,36 $85,60 $139,65 $131,41
4 4 0 0 4 4 4 0 0 4
Net Income 8,236 8,236
$85,60 $85,60 $139,65 $139,65
0 0 0 0
Written by Irfanullah Jan
Related Topics
Financial Statements
Balance Sheet
Income Statement
Financial Accounting
Managerial Accounting
Corporate Finance
Current Chapter
Accounting Cycle
Journal Entries
Ledger Accounts
Unadjusted Trial Balance
Adjusting Entries
Adjusted Trial Balance
Closing Entries
Income Summary Account
Post-Closing Trial Balance
Reversing Entries
Compound Entries
Accounting Worksheet
Accruals & Prepayments
Copyright © 2011 - 2013 AccountingExplained.com | All Rights Reserved
No part of this website may be reproduced without a prior written permission.
Contact Us | Privacy Policy | Disclaimer
