Data Mayoub 1

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 19

ACCOUNT NO ACCOUNT NAME HEADER

10000 ASSET
11000 CURRENT ASSET
11101 CASH IN BANK
11102 PETTY CASH
11200 ACCOUNTS RECEIVABLE
11300 PROVISION FOR DOUBTFUL DEBT
11400 MERCHANDISE INVENTORY
11500 SUPPLIES
11600 PREPAID RENT
11700 PREPAID INSURANCE
11800 VAT INCOME
12000 FIXED ASSET H
12100 LAND
12200 VEHICLE
12201 Acc. Depr. VEHICLE
12300 EQUIPMENT
12301 Acc. Depr. Equipment
20000 LIABILITY H
21000 CURRENT LIABILITY H
21100 CREDIT CARD
21200 ACCOUNT PAYABLE
21300 ACCRUED EXPENSE
21400 WAGES AND SALARIES PAYABLE
21500 INCOME TAX PAYABLE
21600 VAT PAYABLE
21700 VAT OUTCOME
22000 LONG TERM LIABILITY H
22100 BRI'S LOAN
30000 EQUITY H
31100 MRS. ANDA'S CAPITAL
31200 MRS. ANDA'S DRAWING
31300 RETAINED EARNING
40000 REVENUE H
41000 SALES REVENUE
41100 FREIGHT COLLECTED
41200 SALES DISCOUNT
41300 SALES RETURN
50000 COST OF GOODS SOLD H
51100 COST OF GOODS SOLD
51200 FREIGHT PAID
51300 PURCHASE DISCOUNT
60000 EXPENSE H
61100 ADVERTISEMENT EXPENSE
61200 TLP, WATER, ELEC. EXPENSE
61300 SUPPLIES EXPENSE
61400 REPAIR & MAINTENANCE EXPENCE
61500 BAD DEBT EXPENSE
61600 DEPRETIATION EXPENSE
61700 RENT EXPENSE
61800 WAGES AND SALARIES EXPENSE
61900 OTHER EXPENSE
80000 OTHER REVENUE H
81100 INTEREST REVENUE
81200 LATE FEES COLLECTED
90000 OTHER EXPENSE H
91100 BRI CHARGE EXPENSE
91200 TAX EXPENSE
91300 LOSS / GAIN ON SALE OF VEHICLE
91400 OTHER EXPENSE
91500 LATE FEES PAID
BALANCE ACCOUNT TYPE
ASSET
ASSET
BANK
BANK
ACCOUNT RECEIVABLE
OTHER CURRENT ASSET
OTHER CURRENT ASSET
OTHER CURRENT ASSET
OTHER CURRENT ASSET
OTHER CURRENT ASSET
OTHER CURRENT ASSET
ASSET
FIXED ASSET
FIXED ASSET
FIXED ASSET
FIXED ASSET
FIXED ASSET
LIABILITY
LIABILITY
OTHER CURRENT LIABILITY
ACCOUNTS PAYABLE
OTHER CURRENT LIABILITY
OTHER CURRENT LIABILITY
OTHER CURRENT LIABILITY
OTHER CURRENT LIABILITY
OTHER CURRENT LIABILITY
LIABILITY
LONG TERM LIABILITY
EQUITY
EQUITY
EQUITY
EQUITY
INCOME
INCOME
INCOME
INCOME
INCOME
COST OF SALES
COST OF SALES
COST OF SALES
COST OF SALES
EXPENSE
EXPENSE
EXPENSE
EXPENSE
EXPENSE
EXPENSE
EXPENSE
EXPENSE
EXPENSE
EXPENSE
OTHER INCOME
OTHER INCOME
OTHER INCOME
OTHER EXPENSE
OTHER EXPENSE
OTHER EXPENSE
OTHER EXPENSE
OTHER EXPENSE
OTHER EXPENSE
ACCOUNT NO ACCOUNT NAME HEADER
10000 ASSET H
11000 CURRENT ASSET H
11101 CASH IN BANK
11102 PETTY CASH
11200 ACCOUNTS RECEIVABLE
11300 PROVISION FOR DOUBTFUL DEBT
11400 MERCHANDISE INVENTORY
11500 SUPPLIES
11600 PREPAID RENT
11700 PREPAID INSURANCE
11800 VAT INCOME
12000 FIXED ASSET H
12100 LAND
12200 VEHICLE
12201 Acc. Depr. VEHICLE
12300 EQUIPMENT
12301 Acc. Depr. Equipment
20000 LIABILITY H
21000 CURRENT LIABILITY H
21100 CREDIT CARD
21200 ACCOUNT PAYABLE
21300 ACCRUED EXPENSE
21400 WAGES AND SALARIES PAYABLE
21500 INCOME TAX PAYABLE
21600 VAT PAYABLE
21700 VAT OUTCOME
22000 LONG TERM LIABILITY H
22100 BRI'S LOAN
30000 EQUITY H
31100 MRS. ANDA'S CAPITAL
31200 MRS. ANDA'S DRAWING
31300 RETAINED EARNING
40000 REVENUE H
41000 SALES REVENUE
41100 FREIGHT COLLECTED
41200 SALES DISCOUNT
41300 SALES RETURN
50000 COST OF GOODS SOLD H
51100 COST OF GOODS SOLD
51200 FREIGHT PAID
51300 PURCHASE DISCOUNT
60000 EXPENSE H
61100 ADVERTISEMENT EXPENSE
61200 TLP, WATER, ELEC. EXPENSE
61300 SUPPLIES EXPENSE
61400 REPAIR & MAINTENANCE EXPENCE
61500 BAD DEBT EXPENSE
61600 DEPRETIATION EXPENSE
61700 RENT EXPENSE
61800 WAGES AND SALARIES EXPENSE
61900 OTHER EXPENSE
80000 OTHER REVENUE H
81100 INTEREST REVENUE
81200 LATE FEES COLLECTED
90000 OTHER EXPENSE H
91100 BRI CHARGE EXPENSE
91200 TAX EXPENSE
91300 LOSS / GAIN ON SALE OF VEHICLE
91400 OTHER EXPENSE
91500 LATE FEES PAID
BALANCE ACCOUNT TYPE
ASSET
ASSET
Rp29,500,000.00 BANK
Rp3,500,000.00 BANK
Rp2,665,000.00 ACCOUNT RECEIVABLE
OTHER CURRENT ASSET
Rp14,900,000.00 OTHER CURRENT ASSET
Rp1,000,000.00 OTHER CURRENT ASSET
Rp3,200,000.00 OTHER CURRENT ASSET
OTHER CURRENT ASSET
OTHER CURRENT ASSET
ASSET
FIXED ASSET
Rp25,800,000.00 FIXED ASSET
(Rp16,800,000.00) FIXED ASSET
Rp22,080,000.00 FIXED ASSET
(Rp6,875,000.00) FIXED ASSET
LIABILITY
LIABILITY
Rp5,500,000.00 OTHER CURRENT LIABILITY
Rp1,400,000.00 ACCOUNTS PAYABLE
Rp6,000,000.00 OTHER CURRENT LIABILITY
Rp9,000,000.00 OTHER CURRENT LIABILITY
OTHER CURRENT LIABILITY
OTHER CURRENT LIABILITY
OTHER CURRENT LIABILITY
LIABILITY
Rp20,000,000.00 LONG TERM LIABILITY
EQUITY
Rp30,000,000.00 EQUITY
Rp100,000,000.00 EQUITY
EQUITY
INCOME
Rp12,620,000.00 INCOME
INCOME
INCOME
INCOME
COST OF SALES
Rp3,600,000.00 COST OF SALES
COST OF SALES
COST OF SALES
EXPENSE
Rp200,000.00 EXPENSE
Rp350,000.00 EXPENSE
Rp300,000.00 EXPENSE
EXPENSE
EXPENSE
EXPENSE
EXPENSE
Rp500,000.00 EXPENSE
Rp700,000.00 EXPENSE
OTHER INCOME
OTHER INCOME
OTHER INCOME
OTHER EXPENSE
OTHER EXPENSE
OTHER EXPENSE
OTHER EXPENSE
OTHER EXPENSE
OTHER EXPENSE
KODE NAMA PELANGGAN
C001 Istana Boneka
C002 Bear Toys
C003 Dunia Boneka
C004 Sandanwawa
C005 Pelanggan Tunai
DAFTAR PELANGGAN QUEEN TOYS

ALAMAT NO . TELEPON
Jl. Raya Kranggan No. 50, Bekasi 021- 87894534
Jl. Albaido No. 112, Jakarta 021- 80884556
Jl. Tebet Utara dalam, Blok E12, jakarta 021- 80657432
Jl. Raya Pondok Gede No. 59, Bekasi 021- 80545587
KODE NAMA PEMASOK
S001 CV Raya
S002 PT Funny Plastic
DAFTAR PEMASOK QUEEN TOYS

ALAMAT NO. TELEPON NPWP


Jl. Kebagusan No.2, Jakarta 021- 80885888 6,347,351,071,000
Jl. Diponegoro No. 78 , Jakarta 021- 81456709 5,247,851,041,000
KODE NAMA PELANGGAN
C001 Istana Boneka
C002 Bear Toys
C003 Dunia Boneka
C004 Sandanwawa
DAFTAR SALDO PIUTANG QUEEN TOYS

NO. FAKTUR TANGGAL TERMIN SALDO


FQ-078 8/15/2017 2/10, n/30 Rp435,000.00
FQ-088 8/20/2017 2/10, n/30 Rp445,000.00
FQ-093 8/28/2017 2/10, n/30 Rp850,000.00
FQ-096 8/30/2017 2/10,n/30 Rp935,000.00
KODE NAMA PEMASOK
S001 CV Raya
S002 PT Funny Plastic
DAFTAR SALDO UTANG QUEEN TOYS

NO. FAKTUR TANGGAL TERMIN SALDO


FR-670 8/25/2017 3/10,n/30 Rp650,000.00
FP-548 8/28/2017 3/10,n/30 Rp750,000.00
DAFTAR PERSEDIAAN BARANG DAGANG

KODE NAMA PERSEDIAAN


B001 Uno Staco
B002 Monopoli
B003 Scrabble
B004 Play-Doh
B005 Lego
B006 Yoyo
B007 Puzzle
B008 Hot Wheel
B009 Tamiya
B010 Bola Karet
B011 Boneka Barbie
B012 Boneka Pony
B013 Boneka Tedy Bear
B014 Boneka Pororo
B015 Bantal frozen
KODE NAMA PERSEDIAAN
B001 Uno Staco
B002 Monopoli
B003 Scrabble
B004 Play-Doh
B005 Lego
B006 Yoyo
B007 Puzzle
B008 Hot Wheel
B009 Tamiya
B010 Bola Karet
B011 Boneka Barbie
B012 Boneka Pony
B013 Boneka Teddy Bear
B014 Boneka Pororo
B015 Bantal frozen
TOTAL
DAFTAR SALDO AWAL PERSEDIAAN BARANG QUEEN TOYS

KUANTITAS HARGA / PS TOTAL


10 Rp90,000.00 Rp900,000.00
30 Rp25,000.00 Rp750,000.00
10 Rp90,000.00 Rp900,000.00
15 Rp40,000.00 Rp600,000.00
25 Rp80,000.00 Rp2,000,000.00
40 Rp20,000.00 800,000.00
40 Rp35,000.00 Rp1,400,000.00
40 Rp25,000.00 Rp1,000,000.00
20 Rp45,000.00 Rp900,000.00
40 Rp10,000.00 Rp400,000.00
15 Rp50,000.00 Rp750,000.00
15 Rp65,000.00 Rp975,000.00
15 Rp80,000.00 Rp1,200,000.00
15 Rp95,000.00 Rp1,425,000.00
15 Rp60,000.00 Rp900,000.00
Rp14,900,000.00

You might also like