Account # Account Name

1000 ASSETS
1100 Current Assets
1110 CASH - Petty Cash
1120 CASH - Operating Account
1130 Central Bank

1200 RECEIVABLES
1250 Account Receivables

1300 INVENTORIES
1310 Product Inventory
1360 Office Inventory

1400 PREPAID EXPENSES and OTHER CURRENT ASSETS

1410 PREPAID - Insurance
1420 PREPAID - Rent

1500 FIXED ASSETS

1510 PPE - Computer Equipment
1520 PPE - Machinery and Equipment
1530 PPE - Furniture and Fixtures
1540 PPE - Vehicles
1550 PPE - Leasehold Improvements

1600 ACCUMULATED DEPRECIATION and AMORTIZATION

1610 ACCUM DEPR - Computer Equipment
1620 ACCUM DEPR - Machinery and Equipment
1630 ACCUM DEPR - Furniture and Fixtures
1640 ACCUM DEPR - Vehicles

2000 LIABILITIES

2100 PAYABLES
2110 A/P - Trade
2120 Unearned Revenue
2130 VAT - Input
2140 VAT - Output

2700 DEBTS
2710 Central Bank Long Term Debts
2720 Financial Company Short Term Debts

3000 OWNER'S EQUITIES

3100 Owner's Capital
3200 Retained Earnings
3300 Current Earnings
3400 Owner's Withdrawal

4000 REVENUE
4100 REVENUE - All Products
4101 REVENUE - Product 1
4102 REVENUE - Product 2
4103 REVENUE - Product 3
4200 Sales Discounts - All Products
4201 Sales Discounts - Product 1
4202 Sales Discounts - Product 2
4203 Sales Discounts - Product 3
4300 Sales Returns and Allowances - All Products
4301 Sales Returns and Allowances - Product 1
4302 Sales Returns and Allowances - Product 2
4303 Sales Returns and Allowances - Product 3

5000 COST of GOODS SOLD

5100 COGS - All Products
5101 COGS - Product 1
5102 COGS - Product 2
5103 COGS - Product 3
5200 Purchase - All Products
5201 Purchase - Product 1
5202 Purchase - Product 2
5203 Purchase - Product 3
5300 Purchase Discounts - All Products
5301 Purchase Discounts - Product 1
5302 Purchase Discounts - Product 2
5303 Purchase Discounts - Product 3
5400 Purchase Returns and Allowances - All Products
5401 Purchase Returns and Allowances - Product 1
5402 Purchase Returns and Allowances - Product 2
5403 Purchase Returns and Allowances - Product 3

6000 OPERATING EXPENSES

6100 EXP - Salaries
6110 EXP - Administration
6120 EXP - Electricity, Water, Phone
6130 EXP - Rent
6140 EXP - Insurance
6150 EXP - Repair and Maintenance
6160 EXP - Office Supplies
6170 EXP - Depreciation Equipment
6180 EXP - Depreciation Vehicles
6190 EXP - Other

7000 OTHER INCOME

7100 Finance Charge Income

8000 OTHER EXPENSES

8100 EXP - Interests
8200 EXP - Bank Charges
CASH JOURNAL
Data last entry date 1/30/2020

Supplier/Cu
Transaction
Date stomer Description CoA
Code
Code
1/2/2020 PC-111 Petty Cash 1110
1/2/2020 PC-111 Petty Cash 1120
1/3/2020 CA-031 Cash Sales 1120
1/3/2020 CA-031 Cash Sales 4100
1/3/2020 CA-031 Cash Sales 2140
1/6/2020 DP-100 S001 Account Payable 2110
1/6/2020 DP-100 S001 Account Payable 1120
1/10/2020 PR-200 C004 Account Receivable 1120
1/10/2020 PR-200 C004 Account Receivable 1250
1/13/2020 IN-111 Purchase 1 Unit Laptop 1510
1/13/2020 IN-111 Purchase 1 Unit Laptop 1120
1/17/2020 PU-039 S004 Stock Inventory Purchase 5200
1/17/2020 PU-039 S004 Stock Inventory Purchase 2130
1/17/2020 PU-039 S004 Stock Inventory Purchase 1120
1/20/2020 S002 Account Payable 2110
1/20/2020 S002 Account Payable 1130
1/24/2020 C003 Account Receivable 1130
1/24/2020 C003 Account Receivable 1250
1/25/2020 Owner Capital 1130
1/25/2020 Owner Capital 3100
1/27/2020 Salary Payment 6100
1/27/2020 Salary Payment 1130
1/30/2020 Bank Admin 8200
1/30/2020 Bank Admin 1130
1/30/2020 Bank Interest 1130
1/30/2020 Bank Interest 7100
1/30/2020 Petty Cash 1360
1/30/2020 Petty Cash 6120
1/30/2020 Petty Cash 6150
1/30/2020 Petty Cash 6190
1/30/2020 Petty Cash 1120
© 2021 - ExcelTemplate.NET
 Debit Credit
Account Name
Balance
CASH - Petty Cash 200.00
CASH - Operating Account 200.00
CASH - Operating Account 2,447.50
REVENUE - All Products 2,225.00
VAT - Output 222.50
A/P - Trade 265.00
CASH - Operating Account 265.00
CASH - Operating Account 501.25
Account Receivables 501.25
PPE - Computer Equipment 400.00
CASH - Operating Account 400.00
Purchase - All Products 1,200.00
VAT - Input 120.00
CASH - Operating Account 1,320.00
A/P - Trade 320.00
Central Bank 320.00
Central Bank 373.00
Account Receivables 373.00
Central Bank 2,500.00
Owner's Capital 2,500.00
EXP - Salaries 600.00
Central Bank 600.00
EXP - Bank Charges 1.50
Central Bank 1.50
Central Bank 12.50
Finance Charge Income 12.50
Office Inventory 18.50
EXP - Electricity, Water, Phone 65.00
EXP - Repair and Maintenance 28.50
EXP - Other 27.60
CASH - Operating Account 139.60
PURCHASE JOURNAL
Data last entry date 1/19/2020

Transaction Supplier
Date Description CoA
Code Code
1/5/2020 AJ-0221 S001 Purchase 5200
1/5/2020 AJ-0221 S001 Purchase 2130
1/5/2020 AJ-0221 S001 Purchase 2110
1/5/2020 AJ-0221 S001 Purchase 5300
1/19/2020 876FU S003 Purchase 5200
1/19/2020 876FU S003 Purchase 2130
1/19/2020 876FU S003 Purchase 2110
1/19/2020 876FU S003 Purchase 5400
© 2021 - ExcelTemplate.NET
 Debit Credit
Account Name
Balance
Purchase - All Products 760.00
VAT - Input 64.60
A/P - Trade 710.60
Purchase Discounts - All Products 114.00
Purchase - All Products 1,145.00
VAT - Input 97.33
A/P - Trade 1,070.58
Purchase Returns and Allowances - All Products 171.75
SALES JOURNAL
Data last entry date 1/16/2020

Transaction Customer
Date Description CoA
Code Code
1/9/2020 FP-221 C002 Sales 1250
1/9/2020 FP-221 C002 Sales 4200
1/9/2020 FP-221 C002 Sales 4100
1/9/2020 FP-221 C002 Sales 2140
1/16/2020 FP-232 C005 Sales 1250
1/16/2020 FP-232 C005 Sales 4200
1/16/2020 FP-232 C005 Sales 4100
1/16/2020 FP-232 C005 Sales 2140
© 2021 - ExcelTemplate.NET
 Debit Credit
Account Name
Balance
Account Receivables 2,079.00
Sales Discounts - All Products 210.00
REVENUE - All Products 2,100.00
VAT - Output 189.00
Account Receivables 2,999.70
Sales Discounts - All Products 303.00
REVENUE - All Products 3,030.00
VAT - Output 272.70
Need help? Please see this page for information:
https://exceltemplate.net/support/