format laporan keuangan excel

8/20/2019 Format Laporan Keuangan Excel

1/10

LAPORAN KEUANGAN

SUMBER DANA : APBN / DIPA - IPB TAHUN 20

Judu Penel!"n : ####################################################

####################################################

Ke!u" Penel! : ####################################################

T$!"l K$n!%"& : R'( ##############

Re"l)") Pene%*""nD"n" T"+"' I : 10,000,000 nl" &$n!%"&.

D"n" T"+"' II : -

Ju*l"+ : 10,000,000

Re"l)") Bel"n" : ,20,000 nl" el"n" '""& 4"n5 d'un5u! KPPN.

S)" : 670,000

PENERIMAAN

N$ T"n55"l U%""n Ke5"!"n N$ Bu&! Ju*l"+ R'. N$ T"n55"l

1 13 A'%l 2012 P$!$n5"n P""& PPN 1-" 1,000,000 1 13 A'%l 2012

2 13 A'%l 2012 P$!$n5"n P""& PP+ 1- 200,000 2 13 A'%l 2012

3 13 A'%l 2012 Pen8"%"n d"n" !"+"' I 90. 2 7,700,000 3 19 A'%l 2012

6 3 - 6 20 A'%l 2012

6 - 23 A'%l 2012

; - ; 23 A'%l 20129 ; - 9 2 A'%l 2012

7 d)! d)! 7 30-A'%-12

d)! d)! d)!

JUMLAH 10,000,000

Men5e!"+u

Ke'"l" LPPM

P%$


2/10

=$%*"!-2

13

############################

############################

############################

PENGELUARANSALDO

U%""n Ke5"!"n N$ Bu&! Ju*l"+ R'.

P$!$n5"n P""& PPN 1-" 1,000,000 ,000,000

P$!$n5"n P""& PP+ 1- 200,000 7,700,000

>?( An!"%" Jul., 'e*el"n "+"n &*" 2 6,000,000 6,700,000

M"nd"l" => E&$., "4" 'e%"n4"&"n *"!e% 3 120,000 6,;70,000

6 1,000,000 3,;70,000

2,00,000 1,170,000; 20,000 30,000

P%$


3/10

SURAT PERNATAAN TANGGUNG JAAB BELANJA


1( K$de S"!u"n Ke%" : 17992

2( N"*" S"!u"n Ke%" : INSTITUT PERTANIAN BOGOR

3( T"n55"l/N$ DIPA : 0 De)e*e% 2011 / N$ : 07/023-06(2(01/12/2012

6( Judu Penel!"n : #####################################

#####################################

N$ T"n55"l Pene%*" U%""n Ju*l"+ R'.

1 13 A'%l 2012 P$!$n5"n P""& PPN 1-" 1,000,000

2 13 A'%l 2012 P$!$n5"n P""& PP+ 1- 200,000

3 13 A'%l 2012 >?( An!"%" 'e*el"n "+"n &*" 2 6,000,0006 20 A'%l 2012 M"nd"l" => E&$. "4" 'e%"n4"&"n *"!e% 3 120,000

23 A'%l 2012 P%$


4/10

=$%*"!-1

############

############

P""& 4"n5 d'un5u!

PPN PP+

###

###

##((

trategis

l d"n *e!e%"l )e%!" "!")"5" e%&u! :

"n Ke'"d"$n"l(


5/10

REKAPITULASI PENGGUNAAN DANA


Judul Penel!"n : #################################

Ke!u" Penel! : #############((

Nl" K$n!%"& : #############((

Re"l)")

T"+"' I : 7,700,000 )e!el"+ d&u%"n5 '""&.

T"+"' II : -

Ju*l"+ : 7,700,000

Re"l)") Pen55un""n : 7,320,000

S)"/S"ld$ D"n" : 670,000

Re&"'!ul") Bel"n" :

NO URAIAN

1 G" d"n U'"+

2 B"+"n H") P"&"

3 Pe%"l"n"n

6 L"n-l"n

JUMLAH BELANJA

B$5$%,

Ke!u" Penel!

########

NIP( ######

Ke5"!"n Penel!"n Hibah Bersaing/Fundamental/Hibah Pascasarjana/Unggula


6/10

=$%*"!-3

########

JUMLAH R'.

3,90,000

6,000,000

60,000

120,000

7,320,000

########((

#########

Strategis.


7/10

CASH FLOW


Judul Penelitian : ………………………………………………

Na!a Peneliti : ………………………………………………

Nilai "#nt$a% : 60,000,000

N& URAIAN TAHUN AN''ARAN 2011

MEI JUNI JUNI JU(I A'UST SEPT &"T

1 Sald# )ulan *an+ lalu - ,0.000 0.000 0.000 0.000 0.000 0.000

2 Pene$i!aan )ulan ini .00.000 .00.000 - - - - -

3 Pen++unaan )ulan ini .320.000 .320.000 - - - - -

1 'ai/ua 3.450.000 3.450.000 - - - - -

2 Baan ,.000.000 ,.000.000 - - - - -

3 Pe$alanan ,50.000 ,50.000 - - - - -

, (ain-lain 120.000 120.000 - - - - -

, Sald# )ulan ini ,0.000 0.000 0.000 0.000 0.000 0.000 0.000

B#+#$.

"etua Peneliti

……………………… NIP …………………

Ke5"!"n Penel!"n : Hibah Bersaing/Fundamental/Hibah Pascasarjana/Unggulan S


8/10

6#$!at-,

JUM(AH 7 DES

0.000

- 14.00.000 2337

- 1.,0.000 ,557

- 4.500.000 ,217

- .000.000 ,5,57

- 00.000 5117

- 2,0.000 137

0.000 0.000

…………………………………


9/10

BERITA A>ARA PENUTUPAN KAS


Judu Penel!"n :#############################

T"n55"l Penu!u'"n : #############################

N"*" Penu!u' K") : #############################

T$!"l Pene%*""n : R'( 10,000,000

T$!"l Pen5elu"%"n : R'( ,20,000

T$!"l S"ld$ : R'( 670,000

- S"ld$ d B"n& : R'( 0

- S"ld$ &") !un" : R'( 670,000

S"ld$ &") !un" !e%d% d"% :

1 Le*"% u"n5 &e%!") R'( 100,000 2 le*"% R'( 200,0002 Le*"% u"n5 &e%!") R'( 0,000 6 le*"% R'( 200,0003 Le*"% u"n5 &e%!") R'( 20,000 2 le*"% R'( 60,0006 Le*"% u"n5 &e%!") R'( 10,000 2 le*"% R'( 20,000 Le*"% u"n5 &e%!") R'( ,000 0 le*"% R'( -; Le*"% u"n5 &e%!") R'( 2,000 7 le*"% R'( 1;,0009 Le*"% u"n5 &e%!") R'( 1,000 3 le*"% R'( 3,0007 Ke'n5 u"n5 l$5"* R'( 00 2 &e'n5 R'( 1,000

Ke'n5 u"n5 l$5"* R'( 200 0 &e'n5 R'( -10 Ke'n5 u"n5 l$5"* R'( 100 0 &e'n5 R'( -11 Ke'n5 u"n5 l$5"* R'( 0 0 &e'n5 R'( -

JUMLAH R'( 670,000

Men5e!"+u B$5$%,

Ke'"l" LPPM Ke!u" Penel!

P%$


10/10

=$%*"!-

##########

######

#####

n Strategis

format laporan keuangan excel

Documents