Excel表格模板：财务收支管理系统-(2).xlsx

《Excel表格模板：财务收支管理系统-(2).xlsx》由会员分享，可在线阅读，更多相关《Excel表格模板：财务收支管理系统-(2).xlsx（152页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、财务收支管理系统Docer 稻稻壳壳儿儿-凌凌寒寒设设计计出出品 月 月 月6 月4 月5 年9 月7 月8 年12 月0 月11 年使使用用说说明明月月份份汇汇总总表表使用说明:1.基本设定录入收支项目2.1-12对应每月收支表格,根据业务发生月份录入对应表格,收入科目,支出科目可以下来选择,余额自动生成3.1-12 J-P列自动统计4.月份汇总表自动汇总1-12月收支项目,无须手录2.1-12对应每月收支表格,根据业务发生月份录入对应表格,收入科目,支出科目可以下来选择,余额自动生成科目一览表区分收入项目区分支出项目1工资1生活费2奖金2杂费3其他收入3伙食费44水电费5566778899

2、101011111212131314141515161617171818191920202121222223232424252526262727282829293030313132323333343435353636373738383939404041414242434344444545464647474848494950505151525253535454555556565757585859596060PAGE:51 1 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额1,00012017/1/2工资10002,000期初余额22017/1/3奖金5002,50032017

3、/1/5生活费502,450区分415263748596107118129131014111512161317141815191620172118221923202421252226232724282529263027312832293330343135323633373438353936403741384239434044414542464347444845494650475148PAGE:6524953505451555256535754585559566057615862596360646566期末余额6768697071727374757677787980818283848586878

4、88990919293949596979899100101102103104105106PAGE:7107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161PAGE:81621631641651661671681691701711721731741751761771781791801811821831841851861871

5、88189190191192193194195196197198199200201202203204205206207208209210211212213214215216PAGE:9217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271PAGE:10272273274275276277278279280281282283

6、284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326PAGE:1132732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038

7、1PAGE:12382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436PAGE:13437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476

8、477478479480481482483484485486487488489490491PAGE:14492493494495496497498499500PAGE:151,000收入科目合计金额区分支出科目合计金额工资1,0001生活费50奖金5002杂费0其 他 收 入03伙食费004水电费0050060070080090010001100120013001400150016001700180019002000210022002300240025002600270028002900300031003200330034003500360037003800390040004100420043

9、004400450046004700480期初余额PAGE:16049005000510052005300540055005600570058005900600收入合计1,500支出合计502,450期末余额PAGE:172 2 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额2,45012017/2/2奖金10003,450期初余额22017/2/3奖金5003,95032017/2/5生活费503,900区分41526374859610711812913101411151216131714181519162017211822192320242125222623272428

10、25292630273128322933303431353236333734383539364037413842394340444145424643474448454946504751485249PAGE:1853505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:1910810911011111211311411511611711811912012112

11、2123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162PAGE:20163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217PAGE:21

12、218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272PAGE:2227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431

13、5316317318319320321322323324325326327PAGE:23328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382PAGE:24383384385386387388389390391392393394395396397398399400401402403404405406407408409410

14、411412413414415416417418419420421422423424425426427428429430431432433434435436437PAGE:25438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492PAGE:26493494495496497498499500PAGE:272,450收入科目

15、合计金额区分支出科目合计金额工资01生活费50奖金1,5002杂费0其 他 收 入03伙食费004水电费00500600700800900100011001200130014001500160017001800190020002100220023002400250026002700280029003000310032003300340035003600370038003900400041004200430044004500460047004800490期初余额PAGE:2805000510052005300540055005600570058005900600收入合计1,500支出合计503,

16、900期末余额PAGE:293 3 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额3,90012017/3/2工资10004,900期初余额22017/3/3奖金5005,40032017/3/5生活费505,350区分415263748596107118129131014111512161317141815191620172118221923202421252226232724282529263027312832293330343135323633373438353936403741384239434044414542464347444845494650475148524

17、9PAGE:3053505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:31108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154

18、155156157158159160161162PAGE:32163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217PAGE:332182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492

19、50251252253254255256257258259260261262263264265266267268269270271272PAGE:34273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327PAGE:3532832933033133233333433533633733833934034134234334434

20、5346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382PAGE:36383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437PAGE:37438439440

21、441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492PAGE:38493494495496497498499500PAGE:393,900收入科目合计金额区分支出科目合计金额工资1,0001生活费50奖金5002杂费0其 他 收 入03伙食费004水电费0050060070080090010001100120013001400150016

22、0017001800190020002100220023002400250026002700280029003000310032003300340035003600370038003900400041004200430044004500460047004800490期初余额PAGE:4005000510052005300540055005600570058005900600收入合计1,500支出合计505,350期末余额PAGE:414 4 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额5,35012017/4/2工资10006,350期初余额22017/4/3奖金5006

23、,85032017/4/5生活费506,800区分4152637485961071181291310141115121613171418151916201721182219232024212522262327242825292630273128322933303431353236333734383539364037413842394340444145424643474448454946504751485249PAGE:4253505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828

24、384858687888990919293949596979899100101102103104105106107PAGE:43108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162PAGE:441631641651661671681691701711721731741751761771781791801811821831

25、84185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217PAGE:45218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272PAGE:4627327427527627727827

26、9280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327PAGE:473283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763

27、77378379380381382PAGE:48383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437PAGE:4943843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147

28、2473474475476477478479480481482483484485486487488489490491492PAGE:50493494495496497498499500PAGE:515,350收入科目合计金额区分支出科目合计金额工资1,0001生活费50奖金5002杂费0其 他 收 入03伙食费004水电费005006007008009001000110012001300140015001600170018001900200021002200230024002500260027002800290030003100320033003400350036003700380039004

29、00041004200430044004500460047004800490期初余额PAGE:5205000510052005300540055005600570058005900600收入合计1,500支出合计506,800期末余额PAGE:535 5 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额6,80012017/5/2工资10007,800期初余额22017/5/3奖金5008,30032017/5/4生活费508,250区分4152637485961071181291310141115121613171418151916201721182219232024212

30、522262327242825292630273128322933303431353236333734383539364037413842394340444145424643474448454946504751485249PAGE:5453505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:551081091101111121131141151161171

31、18119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162PAGE:56163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215

32、216217PAGE:57218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272PAGE:582732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103

33、11312313314315316317318319320321322323324325326327PAGE:59328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382PAGE:6038338438538638738838939039139239339439539639739839940040140240340440540

34、6407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437PAGE:61438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492PAGE:62493494495496497498499500PAG

35、E:636,800收入科目合计金额区分支出科目合计金额工资1,0001生活费50奖金5002杂费0其 他 收 入03伙食费004水电费00500600700800900100011001200130014001500160017001800190020002100220023002400250026002700280029003000310032003300340035003600370038003900400041004200430044004500460047004800490期初余额PAGE:6405000510052005300540055005600570058005900600收入

36、合计1,500支出合计508,250期末余额PAGE:656 6 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额8,25012017/6/2工资10009,250期初余额22017/6/3奖金5009,75032017/6/4生活费509,700区分415263748596107118129131014111512161317141815191620172118221923202421252226232724282529263027312832293330343135323633373438353936403741384239434044414542464347444845

37、4946504751485249PAGE:6653505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:67108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149

38、150151152153154155156157158159160161162PAGE:68163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217PAGE:692182192202212222232242252262272282292302312322332342352362372382392402412422432442

39、45246247248249250251252253254255256257258259260261262263264265266267268269270271272PAGE:70273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327PAGE:7132832933033133233333433533633733833934

40、0341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382PAGE:72383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437P

41、AGE:73438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492PAGE:74493494495496497498499500PAGE:758,250收入科目合计金额区分支出科目合计金额工资1,0001生活费50奖金5002杂费0其 他 收 入03伙食费004水电费0050060070080090010001100120

42、0130014001500160017001800190020002100220023002400250026002700280029003000310032003300340035003600370038003900400041004200430044004500460047004800490期初余额PAGE:7605000510052005300540055005600570058005900600收入合计1,500支出合计509,700期末余额PAGE:777 7 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额9,70012017/7/2工资100010,700期初余

43、额22017/7/3奖金50011,20032017/7/4生活费5011,150区分4152637485961071181291310141115121613171418151916201721182219232024212522262327242825292630273128322933303431353236333734383539364037413842394340444145424643474448454946504751485249PAGE:7853505451555256535754585559566057615862596360646566期末余额676869707172737

44、475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:79108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162PAGE:801631641651661671681691701711721731741751761771

45、78179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217PAGE:81218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272PAGE:8227

46、3274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327PAGE:833283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703

47、71372373374375376377378379380381382PAGE:84383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437PAGE:8543843944044144244344444544644744844945045145245345445545645745845946046146246346446546

48、6467468469470471472473474475476477478479480481482483484485486487488489490491492PAGE:86493494495496497498499500PAGE:879,700收入科目合计金额区分支出科目合计金额工资1,0001生活费50奖金5002杂费0其 他 收 入03伙食费004水电费005006007008009001000110012001300140015001600170018001900200021002200230024002500260027002800290030003100320033003400350

49、03600370038003900400041004200430044004500460047004800490期初余额PAGE:8805000510052005300540055005600570058005900600收入合计1,500支出合计5011,150期末余额PAGE:898 8 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额11,15012017/8/2工资100012,150期初余额22017/8/3奖金50012,65032017/8/4生活费5012,600区分41526374859610711812913101411151216131714181519

50、16201721182219232024212522262327242825292630273128322933303431353236333734383539364037413842394340444145424643474448454946504751485249PAGE:9053505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:9110810911