T-Accounts v2.3.3

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 7

All amounts are EUR

All entries refer to current period

T-accounts
ASSETS EQUITIES REVENUES
Land Paid-in capital Service revenue
Reference Dr Cr Reference Reference Dr Cr Reference Reference Dr Cr
O.B. € 3,600.00 € 7,100.00 O.B. € 3,000.00
C.B.1 € 3,000.00

Total Dr € 3,600.00 € 0.00 Total Cr Total Dr € 0.00 € 7,100.00 Total Cr Total Dr € 3,000.00 € 3,000.00

Equipment Retained earnings Advertisement service revenue


Reference Dr Cr Reference Reference Dr Cr Reference Reference Dr Cr
O.B. € 2,500.00 € 250.00 13) € 2,500.00 O.B. € 200.00
4) € 640.00 € 3,584.90 Profit (Dec.31,2023) C.B.2 € 200.00

Total Dr € 3,140.00 € 250.00 Total Cr Total Dr € 0.00 € 6,084.90 Total Cr Total Dr € 200.00 € 200.00

Office supplies inventory Tax payable Consulting service revenue


Reference Dr Cr Reference Reference Dr Cr Reference Reference Dr Cr
O.B. € 2,500.00 € 500.00 12) 1) € 1,300.00 € 1,300.00 O.B. € 640.00
8) € 200.00 € 2,000.00
C.B.3 € 2,640.00

Total Dr € 2,700.00 € 500.00 Total Cr Total Dr € 1,300.00 € 1,300.00 Total Cr Total Dr € 2,640.00 € 2,640.00

Accounts receivable Loan payable Account Name (edit this to change)


Reference Dr Cr Reference Reference Dr Cr Reference Reference Dr Cr
O.B. € 5,000.00 11) € 1,000.00 € 3,000.00 O.B.
5) € 200.00
9) € 2,000.00
All amounts are EUR
All entries refer to current period

Total Dr € 7,200.00 € 0.00 Total Cr Total Dr € 1,000.00 € 3,000.00 Total Cr Total Dr € 0.00 € 0.00

Cash, Bank Accounts payable Account Name (edit this to change)


Reference Dr Cr Reference Reference Dr Cr Reference Reference Dr Cr
O.B. € 3,800.00 € 1,300.00 1) 2) € 1,500.00 € 3,500.00 O.B.
3) € 3,000.00 € 1,500.00 2)
6) € 640.00 € 640.00 4)
€ 500.00 7)
€ 200.00 8)
€ 1,000.00 10)
€ 1,000.00 11)
€ 5.10 11)
Total Dr € 7,440.00 € 6,145.10 Total Cr Total Dr € 1,500.00 € 3,500.00 Total Cr Total Dr € 0.00 € 0.00

Account Name (edit this to change) Account Name (edit this to change) Account Name (edit this to change)
Reference Dr Cr Reference Reference Dr Cr Reference Reference Dr Cr

Total Dr € 0.00 € 0.00 Total Cr Total Dr € 0.00 € 0.00 Total Cr Total Dr € 0.00 € 0.00

Account Name (edit this to change) Account Name (edit this to change) Account Name (edit this to change)
Reference Dr Cr Reference Reference Dr Cr Reference Reference Dr Cr

Total Dr € 0.00 € 0.00 Total Cr Total Dr € 0.00 € 0.00 Total Cr Total Dr € 0.00 € 0.00

Income Statement
Reference Dr Cr Reference
C.B.4 - Rent expense € 500.00 € 3,000.00 C.B.1 - Service revenue
C.B.5 - Salaries expense € 1,000.00 € 200.00 C.B.2 - Advertisement service revenue
C.B.6 - Interest expense € 5.10 € 2,640.00 C.B.3 - Consulting service revenue
C.B.7 - Office supplies expense € 500.00
All amounts are EUR
All entries refer to current period

C.B.8 - Depreciation expense € 250.00


Profit (Dec.31, 2023) € 3,584.90

Total Dr € 5,840.00 € 5,840.00 Total Cr

Closing Balance Sheet


Assets Owner`s equity and liabilities
Land € 3,600.00 Paid-in capital € 7,100.00
Equipment € 2,890.00 Retained earnings € 6,084.90
Office supplies inventory € 2,200.00 Tax payable € 0.00
Acconts receivable € 7,200.00 Loan payable € 2,000.00
Cash, Bank € 1,294.90 Acconts payable € 2,000.00

Total assets € 17,184.90 Total equities € 17,184.90


All amounts are EUR
All entries refer to current period

File version: 2.3.3


EXPENSES
evenue Rent expense
Reference Reference Dr Cr Reference
3) 7) € 500.00
€ 500.00 C.B.4

Total Cr Total Dr € 500.00 € 500.00 Total Cr

ervice revenue Salaries expense


Reference Reference Dr Cr Reference
5) 10) € 1,000.00
€ 1,000.00 C.B.5

Total Cr Total Dr € 1,000.00 € 1,000.00 Total Cr

vice revenue Interest expense


Reference Reference Dr Cr Reference
6) 11) € 5.10
9) € 5.10 C.B.6

Total Cr Total Dr € 5.10 € 5.10 Total Cr

it this to change) Office supplies expense


Reference Reference Dr Cr Reference
12) € 500.00
€ 500.00 C.B.7
All amounts are EUR
All entries refer to current period

Total Cr Total Dr € 500.00 € 500.00 Total Cr

it this to change) Depreciation expense


Reference Reference Dr Cr Reference
13) € 250.00
€ 250.00 C.B.8

Total Cr Total Dr € 250.00 € 250.00 Total Cr

it this to change) Account Name (edit this to change)


Reference Reference Dr Cr Reference

Total Cr Total Dr € 0.00 € 0.00 Total Cr

it this to change) Account Name (edit this to change)


Reference Reference Dr Cr Reference

Total Cr Total Dr € 0.00 € 0.00 Total Cr


All amounts are EUR
All entries refer to current period

Hints & Instructions:


1. You can use this row (row 3) to add headings for account groups. You can share a column for more than one group.
2. Otherwise, You can edit white cells only.
3. Use the 5th row of T-accounts for accounts with many transactions (like Cash account)
4. Make sure your references are balanced
5. Below the T-accounts section are special Income Statement account and the closing Balance Sheet forms
6. You can add other sheets for Trial Balance or other calculations. They may be evaluated, but You will not receive feedback on their contents.
7. Wherever possible, reuse information instead of retyping:
For example: an Account Name can be reused in another cell: just type "=" in the cell where you need the reference, then point to an
Account Name with a mouse or keyboard movement.
All amounts are EUR
All entries refer to current period

heir contents.

You might also like