proyeksi lapkeu mei 15.xls

Upload: ahmad-makmun-rosyid

Post on 03-Mar-2018

219 views

Category:

Documents


0 download

TRANSCRIPT

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    1/37

    klik pilihan Anda :

    1. BAGAN & SALDO AAKUN

    2. JURNAL TRANSA

    3. BUKU BESAR

    . NERA!A

    ". LA#ORAN LABA R

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    2/37

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    3/37

    :

    WAL

    SI

    UGI

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    4/37

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    5/37

    #T. $EGA ART%A KEN!ANA ENERBAGAN dan SALDO AWAL AKUN

    NO AKUN NA$A AKUN TI#E

    1-00000 AKTI'A Harta Debit

    1-10000 Ak(i)a Lan*a+ Harta Debit

    1-11000 Kas Harta Debit

    1-12000 Kas Kecil Harta Debit

    1-13000 Bank Harta Debit

    1-13001 Bank BCA Harta Debit

    1-13002 Bank BNI Harta Debit

    1-20000 #i,(an- Uaha Harta Debit

    1-20001 PT Flora Tjipta arana Harta Debit

    1-20002 ! Fat"a#ati Harta Debit

    1-20003 PT $nerta Pri"a ol%sin&o Harta Debit

    1-2000' PT Nin&(a Beton Harta Debit

    1-2000) PT H#a Hok teel Harta Debit

    1-2000* PT Brantas Abipra(a Harta Debit

    1-2000+ PT $lan, B%ana Harta Debit

    1-2000 PT Kara#an, Harta Debit

    1-2000. PT ins%n, Harta Debit

    1-20010 PT A&/i"i Harta Debit

    1-20011 Koperasi Nela(an 1 Harta Debit

    1-20012 koperasi Nela(an 2 Harta Debit

    1-20013 PT Cera"ics Harta Debit

    1-2001' PT ika Harta Debit

    1-2001) PT Ban,%n Pri"ata"a Harta Debit1-2001* acan Harta Debit

    1-200.. Pi%tan, 4sa/a Harta Debit

    1-30000 PP/ Pasal 22 Harta Debit

    1-'0000 PPN 5as%kan Harta Debit

    1-'1000 PP/ Pasal 2) Harta Debit

    1-'2000 PP/ Pasal 23 Harta Debit

    1-'3000 PP/ Pasal ' A(at 2 Harta Debit

    1-)0000 4an, 5%ka Pe"belian Harta Debit

    1-*0000 Ak(i)a T/(ap Harta Debit

    1-*1000 %a+-a #/+0l/han Ak(i)a T/(ap Harta Debit

    1-*1001 Ken&araan Harta Debit

    1-*1002 Co"p%ter 6 Co""%nication Harta Debit

    1-*1003 F%rnit%res 6 Fit%res Harta Debit

    1-*2000 Ak,,lai #/n,,(an Harta Debit

    1-*2001 Ak%" Pen(Ken&araan Harta Debit

    1-*2002 Ak%"Pen(Co"p%ter 6 Co""%nication Harta Debit

    1-*2003 Ak%"Pen(F%rnit%res 6 Fit%res Harta Debit

    2-00000 KEWAJIBAN Ke#ajiban Kre&it

    2-11000 K/a4i5an Lan*a+ Ke#ajiban Kre&it

    2-11100 H%tan, 7aji Ke#ajiban Kre&it

    2-11101 Pen&apatan Diteri"a Di"%ka Ke#ajiban Kre&it

    2-12000 %,(an- Uaha Ke#ajiban Kre&it

    2-12100 PT P$!TA5INA Ke#ajiban Kre&it

    2-12101 PT PAT!A NIA7A Ke#ajiban Kre&it

    2-12102 PT $8N4A Ke#ajiban Kre&it

    2-13000 %,(an- #a4ak Ke#ajiban Kre&it

    2-13100 PPN Kel%aran Ke#ajiban Kre&it

    2-13200 PP/ Pasal 2. Ke#ajiban Kre&it

    2-13300 PP/ Pasal 23 ap% Ke#ajiban Kre&it

    2-1'000 H%tan, Pajak Penj%alan Ke#ajiban Kre&it

    2-21000 K/a4i5an Jan-ka #an4an- Ke#ajiban Kre&it

    SALDONOR$AL

    $ENU

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    6/37

    )-00000 %ARGA #OKOK #ENJUALAN HPP Debit

    )-10000 Pe"belian BB5 HPP Debit

    )-20000 HPP 9asa Transportir HPP Debit

    )-30000 :n,kos An,k%t Pe"belian HPP Debit

    )-'0000 Bia(a PBBKB HPP Debit

    *-00000 BIAA Bia(a Debit

    *-11000 7aji Kar(a#an Bia(a Debit

    *-12000 Bia(a Pe"asaran Bia(a Debit

    *-13000 Bia(a A&"inistrasi 4"%" Bia(a Debit

    *-1'000 Pen(%s%tan Bia(a Debit

    *-1)000 A"ortisasi Bia(a Debit

    -00000 #ENDA#ATAN LAIN6LAIN Pen&apatan 8ainn(a Kre&it

    -10000 B%n,a Bank Pen&apatan 8ainn(a Kre&it

    -20000 8aba Penj%alan Akti;a Pen&apatan 8ainn(a Kre&it

    .-00000 BIAA LAIN6LAIN Bia(a 8ainn(a Debit

    .-10000 B%n,a 8easin, Bia(a 8ainn(a Debit

    .-20000 Pajak Atas Pen&apatan B%n,a Bia(a 8ainn(a Debit

    .-30000 !%,i Penj%alan Akti;a Bia(a 8ainn(a Debit

    A/"a& 5ak"%n !os(i&< Cop(ri,/t April 201)

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    7/37

    #ER 71 $/i 271"

    TINGKATAN SALDO AK%IR A#RIL

    1 89;77777 AKTI'A

    2 89;77777 Ak(i)a Lan*a+

    3 - Kas -

    3 - Kas Kecil -

    3 89;77777 Bank *+'

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    8/37

    1 - HA!7A P:K:K P$N94A8AN

    2 - HPP Peralatan 5%lti"e&ia -

    2 - HPP 9asa Transportir -

    2 - :n,kos An,k%t Pe"belian -

    2 - Bia(a PBBKB -

    1 - BIA?A

    2 - 7aji Kar(a#an -

    2 - Bia(a Pe"asaran -

    2 - Bia(a A&"inistrasi 4"%" -

    2 - Pen(%s%tan -

    2 - A"ortisasi -

    1 - P$NDAPATAN 8AIN-8AIN

    2 - B%n,a Bank -

    2 - 8aba Penj%alan Akti;a -

    1 - BIA?A 8AIN-8AIN

    2 - B%n,a Pinja"an Bank -

    2 - Pajak Atas Pen&apatan B%n,a -

    2 - !%,i Penj%alan Akti;a -

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    9/37

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    10/37

    8ABA !47I $B$845 PA9AK - $BT 1+'

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    11/37

    #T. $EGA A

    #E

    NO. BUKTI TANGGAL URAIAN TRANSAKSI

    BK000*@@1) 02 5a( 1) Pe"belian BB5 2'000 8tr ke Perta"ina 4tk PT Flora Tjipta arana 1-)0000

    IN00* 03 5a( 1) Penj%alan ke PT Flora Tjipta arana 1-20001

    IN00* 03 5a( 1) Penj%alan ke PT Flora Tjipta arana

    B5000*@@1) 0* 5a( 1) Peneri"aan Pi%tan, PT Flora Tjipta arana 1-13002

    BK000+@@1) 0+ 5a( 1) Pembelian BBM 20.000 Ltr utk RS Fatmawati 1-)0000

    IN00+ 0 5a( 1) Penj%alan ke ! Fat"a#ati 1-20002

    IN00+ 0 5a( 1) Penj%alan ke ! Fat"a#ati

    B5000+@@1) 11 5a( 1) Peneri"aan Pi%tan, ! Fat"a#ati 1-13002

    BK000@@1) 12 5a( 1) Pembelian BBM 24.000 Ltr utk PT Enerta Prima Solusindo 1-)0000

    IN00 13 5a( 1) Penj%alan ke PT $nerta Pri"a ol%sin&o 1-20003

    IN00 13 5a( 1) Penj%alan ke PT $nerta Pri"a ol%sin&o

    B5000@@1) 1* 5a( 1) Peneri"aan Pi%tan, PT $nerta Pri"a ol%sin&o 1-13002

    BK000@@1) 1 5a( 1) Pe"belian BB5 32000 8tr %tk PT Nin&(a Beton 1-)0000

    IN00. 1. 5a( 1) Penj%alan Ke PT Nin&(a Beton 1-2000'

    IN00. 1. 5a( 1) Penj%alan Ke PT Nin&(a Beton

    B5000.@@1) 21 5a( 1) Peneri"aan Pi%tan, PT Nin&(a Beton 1-13002

    BK000.@@1) 1 5a( 1) Pe"belian BB5 32000 8tr %tk PT H#a Hok teel 1-)0000

    IN010 1. 5a( 1) Penj%alan ke PT H#a Hok teel 1-2000)

    IN010 1. 5a( 1) Penj%alan ke PT H#a Hok teel

    B50010@@1) 21 5a( 1) Peneri"aan Pi%tan, PT H#a Hok teel 1-13002

    BK0010@@1) 22 5a( 1) Pe"belian BB5 10000 8tr %tk PT Brantas Abipra(a 1-)0000

    IN011 22 5a( 1) Penj%alan ke PT Brantas Abipra(a 1-2000*

    IN011 22 5a( 1) Penj%alan ke PT Brantas Abipra(a

    B50011@@1) 2) 5a( 1) Peneri"aan Pi%tan, PT Brantas Abipra(a 1-13002

    BK0011@@1) 2* 5a( 1) Pe"belian BB5 30000 8tr %tk PT $lan, B%ana 1-)0000

    IN012 2* 5a( 1) Penj%alan ke PT $lan, B%ana 1-2000+

    IN012 2* 5a( 1) Penj%alan ke PT $lan, B%ana

    B50012@@1) 30 5a( 1) Peneri"aan Pi%tan, PT $lan, B%ana 1-13002

    BK0012@@1) 30 5a( 1) 7aji B%lan 5ei 201) *-11000

    BK0013@@1) 30 5a( 1) Pen,a"bilan Kas 1-11000

    KK0001@@1) 30 5a( 1) Bia(a Pe"asaran %tk B%lan 5ei *-12000

    NO$OR AKUN

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    12/37

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    13/37

    A/"a& 5ak"%n !os(i&< Cop(ri,/t April 201)

    30 5a( 1)

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    14/37

    T%A KEN!ANA ENERG4!NA8 4545

    IODE : 71 $A 1" 6 37 $A 1"

    NA$A AKUN DEBET NA$A AKUN

    4an, 5%ka Pe"belian ### 1-13002 Bank BNI

    PT Flora Tjipta arana ### 1-)0000 4an, 5%ka Pe"belian

    '-30000 %ccess Fee

    Bank BNI 22

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    15/37

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    16/37

    DEBET "193"77777 KREDIT

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    17/37

    KREDIT

    213

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    18/37

    1-)0000

    1-*0000

    1-*1000

    1-*1001

    1-*1002

    1-*2000

    1-*2001

    1-*2002

    2-00000

    2-11000

    2-11100

    2-11101

    2-12000

    2-12100

    2-12101

    2-12102

    2-13000

    2-13100

    2-13200

    2-13300

    2-1'000

    2-21000

    2-21100

    2-21200

    3-00000

    3-10000

    3-20000

    3-30000

    '-00000

    '-10000

    '-20000

    '-30000

    '-'0000

    )-00000

    )-10000

    )-20000

    )-30000

    )-'0000

    *-00000

    *-11000

    *-12000

    *-13000

    -00000

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    19/37

    -10000

    -20000

    .-00000

    .-10000

    .-20000

    .-30000

    "193"77777

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    20/37

    #T. $EGA ART%A KEN!ANAB4K4 B$A!#ERIODE : 71 $A 1" 6 37 $A 1"

    N: AK4N 1613772

    NA5A AK4N Bank BNI

    NO. BUKTI TANGGAL URAIAN TRANSAKSI

    01 5a( 1) SALDO AWAL ...

    BK000*@@1) 02 5a( 1) Pe"bel ian BB5 2'000 8tr ke Perta"ina 4tk PT Flora Tjipta arana

    B5000*@@1) 0* 5a( 1) Peneri"aan Pi%tan, PT Flora Tjipta arana

    BK000+@@1) 0+ 5a( 1) Pe"belian BB5 20000 8tr %tk ! Fat"a#ati

    B5000+@@1) 11 5a( 1) Peneri"aan Pi%tan, ! Fat"a#ati

    BK000@@1) 12 5a( 1) Pe"bel ian BB5 2'000 8tr %tk PT $nerta Pri"a ol%sin&o

    B5000@@1) 1* 5a( 1) Peneri"aan Pi%tan, PT $nerta Pri"a ol%sin&o

    BK000@@1) 1 5a( 1) Pe"belian BB5 32000 8tr %tk PT Nin&(a Beton

    B5000.@@1) 21 5a( 1) Peneri"aan Pi%tan, PT Nin&(a Beton

    BK000.@@1) 1 5a( 1) Pe"belian BB5 32000 8tr %tk PT H#a Hok teel

    B50010@@1) 21 5a( 1) Peneri"aan Pi%tan, PT H#a Hok teel

    BK0010@@1) 22 5a( 1) Pe"belian BB5 10000 8tr %tk PT Brantas Abipra(a

    B50011@@1) 2) 5a( 1) Peneri"aan Pi%tan, PT Brantas Abipra(a

    BK0011@@1) 2* 5a( 1) Pe"belian BB5 30000 8tr %tk PT $lan, B%ana

    B50012@@1) 30 5a( 1) Peneri"aan Pi%tan, PT $lan, B%ana

    BK0012@@1) 30 5a( 1) 7aji B%lan 5ei 201)

    BK0013@@1) 30 5a( 1) Pen,a"bilan Kas

    $ENU

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    21/37

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    22/37

    TOTAL

    A/"a& 5ak"%n !os(i&< Cop(ri,/t April 201)

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    23/37

    NERG

    D/5i( A8D: AA8 89;77777

    71 $a 271" 37 $a 271"

    DEBET KREDIT SALDO

    *+'

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    24/37

    - - .+

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    25/37

    - - .+

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    26/37

    #T. $EGA ART%A KN$!A

    #ERIODE : 71 $A 1

    KETERANGAN

    AKTI'A

    Ak(i)a Lan*a+

    Kas - 7"377777

    Ak(i)a T/(ap

    %a+-a #/+0l/han Ak(i)a T/(ap 6 6 6

    Ken&araan - - -

    Co"p%ter 6 Co""%nication - - -

    F%rnit%res 6 Fit%res

    Ak,,lai #/n,,(an 6 6 6

    Ak%" Pen(Ken&araan - - -

    Ak%"Pen(Co"p%ter 6 Co""%nication - - -

    Ak%"Pen(F%rnit%res 6 Fit%res

    J,lah AKTI'A TETA# 6 6 6

    JU$LA% AKTI'A 89;77777 237"77777 >7"377777

    A/"a& 5ak"%n !os(i&< Cop(ri,/t April 201)

    AWAL#ERIODE

    #ERIODEBERJALAN

    AK%IR#ERIODE

    $ENU

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    27/37

    N!ANA ENERGCA 6 37 $A 1"

    KETERANGAN

    KEWAJIBAN

    K/a4i5an Lan*a+

    H%tan, 7aji - - -

    Pen&apatan Diteri"a Di"%ka - - -

    %,(an- Uaha 6 6 6

    PT P$!TA5INA - - -

    PT PAT!A NIA7A - - -

    PT $8N4A - - -

    %,(an- #a4ak 6 6 6

    PPN Kel%aran - - -PP/ Pasal 2. - - -

    PP/ Pasal 23 ap% - - -

    H%tan, Pajak Penj%alan

    J,lah KEWAJIBAN LAN!AR 6 6 6

    K/a4i5an Jan-ka #an4an-

    H%tan, 8easin, - - -

    H%tan, 9an,ka Panjan, 8ain - - -

    J,lah KEWAJIBAN JANGKA #ANJANG 6 6 6

    EKUITAS

    5o&al a/a" )00

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    28/37

    #T. $EGA ART%A KEN!ANA ENERG8AP:!AN 8ABA !47I#ERIODE : 71 $A 1" 6 37 $A 1"

    KETERANGAN

    #ENDA#ATAN

    Penj%alan BB5 - - -

    Pen&apatan 9asa Transportir - - -

    %ccess Fee 1+'

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    29/37

    A/"a& 5ak"%n !os(i&< Cop(ri,/t April 201)

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    30/37

    #T. $EGA ART%AN$

    #ERIODE : 71

    KETERANGAN

    AKTI'A

    Ak(i)a Lan*a+

    Kas - 7"377777

    Ak(i)a T/(ap

    %a+-a #/+0l/han Ak(i)a T/(ap 6 6 6

    Ken&araan - - -

    Co"p%ter 6 Co""%nication - - -

    F%rnit%res 6 Fit%res

    Ak,,lai #/n,,(an 6 6 6

    Ak%" Pen(Ken&araan - - -

    Ak%"Pen(Co"p%ter 6 Co" - - -

    Ak%"Pen(F%rnit%res 6 Fit%res

    J,lah AKTI'A TETA# 6 6 6

    JU$LA% AKTI'A 89;77777 237"77777 >7"377777

    A/"a& 5ak"%n !os(i&< Cop(ri,/t April 201)

    AKTIA

    Akti;a 8ancar

    AWAL#ERIODE

    #ERIODEBERJALAN

    AK%IR#ERIODE

    $ENU

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    31/37

    PT Brantas Abipra(a -

    PT $lan, B%ana -

    PT Kara#an, -

    PT ins%n, -

    PT A&/i"i -

    Koperasi Nela(an 1 -

    koperasi Nela(an 2 -

    PT Cera"ics -

    PT ika -

    PT Ban,%n Pri"ata"a -

    acan -

    PP/ Pasal 22 -

    PPN 5as%kan -

    PP/ Pasal 2) -

    PP/ Pasal 23 -

    PP/ Pasal ' A(at 2 -

    4an, 5%ka Pe"belian -

    Akti;a Tetap -

    Har,a Perole/an Akti;a Tetap -

    Ken&araan -

    Co"p%ter 6 Co""%nication -F%rnit%res 6 Fit%res -

    Ak%"%lasi Pen(%s%tan -

    Ak%" Pen(Ken&araan -

    Ak%"Pen(Co"p%ter 6 Co" -

    Ak%"Pen(F%rnit%res 6 Fit% -

    K$A9IBAN

    Ke#ajiban 8ancar

    H%tan, 7aji -

    Pen&apatan Diteri"a Di"%ka -

    H%tan, 4sa/a -

    PT P$!TA5INA -

    PT PAT!A NIA7A -

    PT $8N4A -H%tan, Pajak -

    PPN Kel%aran -

    PP/ Pasal 2. -

    PP/ Pasal 23 ap% -

    H%tan, Pajak Penj%alan

    Ke#ajiban 9an,ka Panjan,

    H%tan, 8easin, -

    H%tan, 9an,ka Panjan, 8ain -

    $K4ITA

    5o&al a/a" )00

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    32/37

    KEN!ANA ENERG!ACA

    A 1" 6 37 $A 1"

    KETERANGAN

    KEWAJIBAN

    K/a4i5an Lan*a+

    H%tan, 7aji - - -

    Pen&apatan Diteri"a Di"%ka - - -

    %,(an- Uaha 6 6 6

    PT P$!TA5INA - - -

    PT PAT!A NIA7A - - -

    PT $8N4A - - -

    %,(an- #a4ak 6 6 6

    PPN Kel%aran - - -PP/ Pasal 2. - - -

    PP/ Pasal 23 ap% - - -

    H%tan, Pajak Penj%alan

    J,lah KEWAJIBAN LAN!AR 6 6 6

    K/a4i5an Jan-ka #an4an-

    H%tan, Bank B!I N@A - N@A

    H%tan, 9an,ka Panjan, 8ain - - -

    J,lah KEWAJIBAN JANGKA #ANJANG @NA 6 @NA

    EKUITAS

    5o&al a/a" )00

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    33/37

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    34/37

    #T. $EGA ART%A KEN!ANA ENERG8AP:!AN 8ABA !47I#ERIODE : 71 $A 1" 6 37 $A 1"

    KETERANGAN

    #ENDA#ATAN

    Penj%alan BB5 - - -

    Pen&apatan 9asa Transportir - - -

    %ccess Fee 1+'

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    35/37

    A/"a& 5ak"%n !os(i&< Cop(ri,/t April 201)

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    36/37

    #T. $EGA ART%A KEN!ANA ENERG8AP:!AN 8ABA !47I#ERIODE : 71 $A 1" 6 37 $A 1"

    KETERANGAN

    #ENDA#ATAN

    Penj%alan BB5 - - -

    Pen&apatan 9asa Transportir - - -

    %ccess Fee 1+'

  • 7/26/2019 PROYEKSI LAPKEU Mei 15.xls

    37/37

    A/"a& 5ak"%n !os(i&< Cop(ri,/t April 201)

    P$NDAPATAN

    Penj%alan BB5 -

    Pen&apatan 9asa Transportir -

    %ccess Fee '20