ACCOUNTING WORKSHEET
BUSINESS NAME: ACCOUNTING PERIOD:
ADJUSTMENT ADJUSTED INCOME STATEMENT BALANCE SHEET
ACCOUNT CODE ACCOUNT DEBIT CREDIT
Debit Credit Debit Credit Debit Credit Debit Credit
AC-0001 Cash at Bank $ 21,900.00 $ 21,900.00 $ 21,900.00
AC-0002 Accounts Receivable $ 2,000.00 $ 2,000.00 $ 2,000.00
AC-0003 Prepaid Rent $ 879.00 $ 879.00 $ 879.00
AC-0004 Inventory $ 6,789.00 $ 4,000.00 $ 10,789.00 $ 10,789.00
AC-0005 Account Payable $ 21,899.00 $ 21,899.00 $ 21,899.00
AC-0006 Bank Loan $ 3,000.00 $ 6,400.00 $ 9,400.00 $ 1,100.00 $ 9,400.00
AC-0007 Paid Up Capital $ 4,000.00 $ 4,000.00 $ 4,000.00
AC-0008 Retained Earnings $ 2,000.00 $ 2,000.00 $ 2,000.00
AC-0009 Revenue $ 10,000.00 $ 200.00 $ 10,200.00 $ 10,200.00 $ 10,200.00
AC-0010 Long term Liabilities $ 5,000.00 $ 5,000.00 $ 5,000.00
AC-0011 Stock $ 2,000.00 $ 2,000.00 $ 2,000.00
AC-0012 Dividends $ 100.00 $ 100.00 $ 100.00
AC-0013 Depreciation Expense $ 5,000.00 $ 5,000.00 $ 5,000.00
AC-0014 Rent Expenses $ 5,000.00 $ 5,000.00 $ 5,000.00
AC-0015 Wages Expenses $ 2,500.00 $ 400.00 $ 2,900.00 $ 2,900.00
AC-0016 Interest Expenses $ 267.00 $ 267.00 $ 267.00 $ 100.00
AC-0017 Salary Expenses $ 10,000.00 $ 10,000.00 $ 10,000.00 $ 100.00
AC-0018 Office Supplies $ 200.00 $ 200.00 $ 200.00
AC-0019 Cash at hand $ 8,000.00 $ 8,000.00 $ 8,000.00
AC-0020 Machinery $ 20,000.00 $ 20,000.00 $ 20,000.00
AC-0021 Telephone Expenses $ 200.00 $ 200.00 $ 200.00
SUB-TOTAL: $ 76,956.00 $ 47,899.00 $ 10,479.00 $ 6,400.00 $ 87,235.00 $ 54,499.00 $ 51,567.00 $ 11,500.00 $ 45,868.00 $ 44,299.00
NET INCOME/LOSS: $ 40,067.00 $ - $ - $ 40,067.00
TOTAL: $ 91,634.00 $ 10,200.00 $ 45,868.00 $ 91,634.00
The following are instructions on how to use the template.
1. Edit or add content like inserting rows and columns to the template.
2. There are no locked-up cells for easier editing of cell names.
3. Feel free to change any formula available.
Should you need assistance, please contact our Customer Support Team using the chat box found on
g the chat box found on the website.