Soal Spreadsheet PT Sejahtera
Soal Spreadsheet PT Sejahtera
Soal Spreadsheet PT Sejahtera
Trial Balance November,30, 2018 and Balance Sheet December, 31, 2017
No November 30, 2018 December 31, 2017
Account Title
Account DEBIT CREDIT DEBIT CREDIT
11100 Petty Cash 3.000.000 2.850.000
11120 Cash In Bank 182.811.550 190.381.547
11130 Marketable Equity Security 25.000.000
11210 Account Receivable 57.200.000 80.000.000
11220 Allowances For Bad Debts 4.000.000 4.000.000
11230 Employ Receivable 1.000.000 1.500.000
11310 Merchandise Inventory 82.000.000 85.000.000
11320 Store Supplies 6.800.000 7.500.000
11410 Prepaid Rent 10.000.000 6.000.000
11420 Prepaid Insurance 4.250.000 3.000.000
11430 Value Added taxes In 4.000.000 3.750.000
12100 Investment 56.000.000 56.000.000
13100 Land 275.000.000 225.000.000
13210 Building at Cost 288.000.000 288.000.000
13220 Accumulated DepreciationBuilding 52.800.000 39.600.000
13301 Vehicles at Cost 96.000.000 96.000.000
13302 Accumalated Depreciation Vehicles 38.000.000 27.000.000
13401 Equipment at Cost 60.000.000 60.000.000
13402 Accumalated Depreciation Equipment 13.750.000 -
21110 Credit Card 4.200.000 5.000.000
21210 Account Payable 56.100.000 90.000.000
21211 Accrued Expense 1.675.000 1.200.000
21212 Income Taxes Payable 125.000 250.000
21213 VAT Out 8.500.000 7.600.000
31100 Bank BNI'46 Medan Loan 135.331.547 225.331.547
31000 Command Stock 400.000.000 400.000.000
31001 Retained Earning 330.000.000 330.000.000
31002 Devidend 40.000.000
31003 Income Summary
41100 Sales 629.845.000
42100 Fregiht Collected 7.500.000
42200 Late Fee Collected 2.500.000
42300 Sales Discount 8.500.000
42400 Sales Returns 9.000.000
51100 Cost Of Good Sold 323.440.000
52000 Fregiht Paid 1.220.000
53000 Purchase Discount
61100 Wages & Salaries 51.550.000
61200 Advertising Expense 19.500.000
61400 Utility Expense 7.200.000
61500 Water, Telepon & Eelectricity Expense Expense 5.400.000
62100 Rent Expense 20.000.000
62200 Supplies Expense 7.600.000
62300 Maintenance and Repair Expense 10.000.000
62400 Bad Debts Expense
62500 Depreciation Building 13.200.000
62600 Depreciation Vehicles 11.000.000
62700 Depreciation Equipment 13.750.000
62800 Insurance Expense 8.950.000
62900 Late Fee Expense
81100 Interest Income 3.750.000
81200 Devidend Income 20.000.000
81300 Gain/Loss Sales Vehicles
91100 Interest Expense 17.981.547
91200 Bank Service Charge 7.500.000
93100 Income Taxes Expense 6.223.450
Debit Credit
Account Merchandise
DATE DOC. NO. Customer's Cost Of Good Sold Sales VAT Out Fregiht Collected
Receivable Inventory
2 FPJ12-1 Toko Benua Jaya Rp 32.485.000 Rp 19.000.000 Rp 29.500.000 Rp 2.950.000 Rp 19.000.000 Rp 35.000
9 FPJ12-2 Toko Serasi Rp 15.110.000 Rp 8.800.000 Rp 13.600.000 Rp 1.360.000 Rp 8.800.000 Rp 150.000
14 FPJ12-3 Toko Angel Rp 18.845.000 Rp 11.000.000 Rp 17.000.000 Rp 1.700.000 Rp 11.000.000 Rp 145.000
20 FPJ12-4 Toko Kencana Rp 24.235.000 Rp 13.500.000 Rp 22.000.000 Rp 2.200.000 Rp 13.500.000 Rp 35.000
Rp - Rp - Rp - Rp -
Rp 142.975.000 Rp 142.975.000
-
Keterangan Nama
Tanggal dan paraf
Dibuat oleh
Direview oleh
pt sejahtera
Cash Receipt Journal
December 2018 Page :
DEBIT CREDIT
OTHER OTHER
Account
DATE DOC. NO. ACCOUNT CREDITED Sales Discount Cash In Bank ACCT ACCT
Account Debited AMOUNT Receivable AMOUNT
NO. NO.
Dibuat oleh
Direview oleh
Purchase Journal
December 2018
DEBIT CREDIT
Merchandise Value Added taxes
DATE DOC. NO. VENDOR'S Account Payable
Inventory In
11310 11430 21210
Rp -
Rp -
Rp -
Rp -
Rp 44.220.000 Rp 44.220.000
Direview oleh
pt sejahtera
Cash Payment Journal
December 2018 Page :
DEBIT CREDIT
Docoument OTHER OTHER
DATE ACCOUNT DEBITED
Number Account Payable Cash In Bank
Acc No AMOUNT Acc No Acct Name AMOUNT
21210 11120
9 PT Dian Persada BKK12-1 33.000.000 32.340.000 53000 Purchase Discount Rp 660.000
10 Petty Cash BKK12-2 11100 Rp 2.475.000 Rp 2.475.000
13 VAT Out BKK12-3 21213 Rp 8.500.000 Rp 4.625.000 11430 Value Added taxes In Rp 4.000.000
Income Taxes Payable 21212 Rp 125.000
20 PT Nusa Indah BKK12-4 Rp 23.100.000 Rp 23.331.000
Late Fee Expense 62900 Rp 231.000
26 Bank BNI'46 Medan Loan BKK12-5 31100 Rp 9.849.682 Rp 11.000.000
Interest Expense 91100 Rp 1.150.318
30 Wages & Salaries BKK12-6 61100 Rp 13.250.000 Rp 12.633.800 21212 Income Taxes Payable Rp 116.200
11230 Employ Receivable Rp 500.000
30 Credit Card 21110 Rp 4.200.000 Rp 4.200.000
Dibuat oleh
Direview oleh
pt sejahtera
Memorial Journal
December 2018 Page :
Penerimaan Pengeluaran
DATE DESCRIPTION NO EVIDANCE NO BALANCE
11120 AMOUNT
ACCOUNT
1 Balance ˅ Rp 3.000.000
Dibuat oleh
Direview oleh