Peactree Project
Peactree Project
Asset Liability
218,930.0
Cash At Abyssinia Bank 242,000.00 Account Payable 0
Account Receivable 203,030.00 Mortgage Payable 84,200.00
Note Receivable 15,000.00 Vat Payable 35,000.00
338,130.0
Inventory Of Computer 136,000.00 Total Liability 0
Inventory Of Printer 47,200.00
Inventory Of Scanner 21,120.00
Inventory Of
Photocopiers 128,400.00
Office Supplies 14,000.00
Store Supplies 13,200.00
Prepaid Insurance 16,660.00 Capital
500,000.0
Office Equipment 100,800.00 Capital 0
Acc .[Link] Office
Equipment (20,160.00) Retained Earning 79,120.00
579,120.0
Total Capital 0
Total Liability & capital 917,250.0
Total Asset 917,250.00 0
7
Ethio Computer Training Center
8
Ethio Computer Training Center
Task 4. Maintaining of credit customer Credit Term
Credit customer Default: the standard credit term select Due in number of days, enter Net due 30 days,
enter discount 0 days, discount percent 0 and credit Br. 500,000 respectively.
In the G/L sales account box selected 41000-010(Sales of computer) and in G/L
Discount Account box 43000(Sales Discount). The following table gives
information about credit customers' balance as of Dec 31, 2018
Maintain ……………………………………Customer/Prospect
Account type
Customer Account
no Customer Name Invoice No Invoice Date Amount Receivable
ID
(11500)
1 EC-01 Ethio Computer plc CRSI-01517 12/24/2018 64,450.00 11500
2 KT-02 KidTech plc CRSI-01502 12/11/2018 12380.00 11500
3 LT-03 Lucy Technology plc CRSI-01509 12/15/2018 49450.00 11500
4 MC-04 Max Computer plc CRSI-01520 12/30/2018 58,250.00 11500
5 SG-05 Sheger G/Trading plc CRSI-01501 12/5/2018 18,500.00 11500
Total 203,030.00
9
Ethio Computer Training Center
Credit Vendor Default: The standard credit term select Due in number of days, Net due in 30 days, and
discount in 0 days, discount percent 0 and credit Br. 500,000 respectively. In the
G/L Expense Account box select 12000-010(Inventory of Computers). And in
the G/L Discount Account box select 52000(Purchase Discount). The following
table gives information about credit Vendors' balance as of Dec 31, 2018
Inventory In the default item class box select Stock Item, click on G/L Accts/Costing in the
Items Default: Stock Item row G/L Sales Account Box select 41000-010 (Sales of Computer), in
the G/L Inventory Account Box select 12000-010 (Inventory of Computer), in the
G/L Cost of Sales Account Box select 51000-010 (Cost of Computer), in the
Costing method Box select Average and in the G/L Freight Account Box select
53000(Freight Charge). The following table gives information about Inventory items'
balance as of Dec 31, 2018
UM/Unit
Selling
no Item ID Description Price/Price Level
Item Type of Quantity Unit Cost Total Cost
Measure
Dell Computer
1 DEL-2512 PIV17LCD 16,800.00 Computer PCS 10 10,450.00 104,500.00
Compaq computer
2 COMPAQ204 PIV17NCR 8,900.00 Computer PCS 5 6,300.00 31,500.00
UM/Unit
Selling
No Item ID Description Price/Price Level
Item Type of Quantity Unit Cost Total Cost
Measure
TOTAL 332,720.00
12
Ethio Computer Training Center
13
Ethio Computer Training Center
Jan. 5, Purchase of 2 pcs of Dell Computer at 10,450.00 each plus 15% which is
3,135.00 each from Shewa Computer. Invoice no GRN 061
Jan. 15, Purchase of 5 pcs of cannon 6317photocopy machine at 6,300.00 each,4 pcs
of HP-Laser Jet printer at 2,800.00 each and2pcs of KTCE Scanner at 480.00
each plus 15% which is 6,549.00 each from Habesha Trading. Invoice no GRN
062.
Jan.20, Purchase of 3pcs of Compaq Computer invoice [Link] 063 at 6,300 each
from Dire Trading plus 15% vat which is 2,835.00 with down payment of
10,000 ref CK no. 14604/CPV0001.
Jan. 30, Purchase of 2pcs HP laser jet at 2,800 each from new supplier Hi-Per Tech
“vendor ID HP-06, vendor name Hi-PerTech PLC Tell 0112798067 plus
15%vat which is 840.00 Invoice no. GRN 064.
Purchase order Transaction
Jan. 20, Send purchase order to Habesha Trading for the purchase 1pcs of
cannon6317 photocopy machine at Br. 6,300 plus vat which is Br.945.00
purchase order# 001 Good Thru. By January.31/2019
Jan. 31, Received 1pcs of cannon 6317 photocopy machine at Br. 6,300 plus vat which
is Br. 945.00 from Habesha Trading invoice no. GRN [Link] 001
Jan.10 Payment made after deducting withholding tax 1,256.52 birr for
Addis Computer for settlement of GRN 054 fully ref [Link]
14605/CPV0002.
Jan.20 Payment made for Sage computer br. 30,000.00 for partial
settlement of GRN 058 [Link].14607/CPV0004.
Payment Transaction
Jan.15. Paid Br. 300.00 Employee advance for Aster Kebede [Link].
14611/CPV0008
Jan. 20 15,000.00 plus 15% vat which 2,250.00 birr payment is made
after deducting withholding tax 2% which is 300.00 birr for
advertisement to NechsarAdvertising PLC ref. [Link]
16
Ethio Computer Training Center
14612/CPV0009.
17
Ethio Computer Training Center
Jan.25 20,000.00 birr payment made for Mortgage Payable to Buna
International Bank [Link].no14613/CPV00IO.
Jan 10. Sold 4pcs of Sonny scanner at 1,800.00 each& 2pcs of cannon 7161
Photocopy machine at 16,200.00 each to Ethio Computer Invoice
no. CRSI 01522 plus 15% VAT.
Jan 13. Sold 2pcs of Dell computer at 16,800.00 each,3pcs of HP laser jet at
3,200/ each , 4pcs of KTC scanner at 900.00 each& l pcs of Cannon
6317 photocopier at 9,000.00 each to KID TECH PLC Invoice no.
18
Ethio Computer Training Center
CRSI 01523 plus 15% VAT.
Jan 31. Sold on account 2pcs of HpInkJet at 2,100.00 each to new credit
[Link] customer ID WT-06,Customer name World Tech Plc
address Arada k/k kebele08 HN 869 Tell 0111-57-64-77 by Invoice
no. CRSI 01525 plus 15%VAT
Jan.5 Received sales order SO 001 from Ethio Computer 1pcs of Dell
tab
Jan.31 Shipped Sales order SO 001 from Ethio Computer Ipcs of Dell
Computer
16.800.0 Plus 15% vat Invoice [Link] 01530.
Customer
Invoice
Jan. 22 Received 18,178.26 cash from Sheger G/Trading plc for fully
settlement of CRSI 01501 reference and receipt no. CRV0848.
Sheger G/Trading plc withheld withholding tax 2% which is
321.74 birr. Deposit ticket id 1/22
Jan. 25 Received 12,164.70 cash for fully settlement of CRSI 01502 &
received 63,054.00 cash for fully settlement of CRSI 01523 from
Kid tech PLC reference and receipt no. CRV0849. Kid Tech Plc
withheld withholding tax 2% which is 1,331.30 birr. Deposit
ticket id 1/25A
Jan. 26 Received 10,000.00 birr from Lucy Technology plc for partial
settlements of CRSI 01524 reference and receipt no. CRV 0850
Deposit ticket id 1/26.
Jan.31 Received 4,830.00 cash from World tech PLC for fully settlements
of CRSI 01525 reference and receipt [Link] 0851. Deposit
ticket id 1/31
Cash Sales Transaction
Task……………………Receipt……………………….use Apply to Revenue
Jan. 15 Sold by cash 2pcs of sonny scanner at 1800 each to cash customer Ato
Kassahun Belay reference CSL 0446 and RECEIPT [Link] 001 plus 15%
vat Deposit ticket id 1/15.
Jan.20 Sold 2pcs of Dell computer at 16,800.00 each & 4pcs of cannon photocopy
6317 at 9,000.00 birr each reference CSI 0447 and [Link].0002 on each to
Ministry of Health plus 15% vat. Ministry of Health with held 1,392.00 birr
withholding tax& deduced 10,440.00 birr VAT. Deposit ticket id 1/20.
20
Ethio Computer Training Center
Jan. 29, Sold 3pcs of Hp laser jet at 3,200.00 each and 2pcs of KTCE Scanner at 900
at each to Kid Tech Plc on cash plus 15% vat reference CSI 0448 and
[Link].000 Kid Tech PLC Withheld tax 2%which is 228.00 birr. Deposit tick
id 1/29.
Jan. 31 Collection of interest income 2,500.00 from CBE Addis Ababa Branch reference
no.CRV0852. Deposit ticket id 1/31B.
Jan.31, 1,000.00 cash collected from Cash Customer for repair & maintenance of
photocopy machine (repair & maintenance considered as other income)
reference and receipt [Link] 0853 deposit ticket id 1/31c.
Apply income tax to all Employee and pension from employee 7% and pension
from employer 11%
Jan. 31, Paid salary for employees Reference cheek no. 14616 & CPV 0013.
Balance 242,000.00
1/5/2017 [Link].14608 6,900.00 235,1000.00
The following Bank Reconciliation adjustment incurred for the mouth if January
31 /2019. Reference JV01/19
Debit Credit
Debit Credit
Cash at Abyssinia Bank……………………………………………….15,000.00
Note Receivable………………………………………………………………….15,000.00
The following inventory adjustment occurred during for the month of January
31 2019 reference Jv03/19 2pcs of HP ink jet failed to use.
Debit Credit
The following expense incurred for the month of January 31 2019assuming that
all assets are initially recorded as an assets reference JV04/19
Debit Credit
Office supplies expense……………………………………………….4, 200.00
Office supplies …………………………………………………………………..…4,200.00
The following adjustment incurred for the month of January 31/2019 reference
JV05/17. Book value office equipment is equal to cost minus accumulated
depreciation (100,800.00-20,160.00=80,640). Depreciation expense is equal to
book value times 80,640.00*20%= 16,128.00
The following adjustment incurred to offset vat receivable for the month of
January 31/2019. Reference JV06 /19.