0% found this document useful (0 votes)
27 views3 pages

Accounting Worksheet 1

The document is an accounting worksheet detailing various accounts, their adjustments, and balances for a specific business during an accounting period. It includes account codes, descriptions, and financial figures for assets, liabilities, income, and expenses, culminating in a net income/loss calculation. Instructions for editing the template and accessing customer support are also provided.

Uploaded by

Ibrahim Hussaini
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
27 views3 pages

Accounting Worksheet 1

The document is an accounting worksheet detailing various accounts, their adjustments, and balances for a specific business during an accounting period. It includes account codes, descriptions, and financial figures for assets, liabilities, income, and expenses, culminating in a net income/loss calculation. Instructions for editing the template and accessing customer support are also provided.

Uploaded by

Ibrahim Hussaini
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

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.

You might also like