Excel表格模板：财务收支管理系统-(2).xlsx
财务收支管理系统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水电费5566778899101011111212131314141515161617171818191920202121222223232424252526262727282829293030313132323333343435353636373738383939404041414242434344444545464647474848494950505151525253535454555556565757585859596060PAGE:51 1 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额1,00012017/1/2工资10002,000期初余额22017/1/3奖金5002,50032017/1/5生活费502,450区分415263748596107118129131014111512161317141815191620172118221923202421252226232724282529263027312832293330343135323633373438353936403741384239434044414542464347444845494650475148PAGE:6524953505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106PAGE:7107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161PAGE:8162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216PAGE:9217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271PAGE:10272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326PAGE:11327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381PAGE:12382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436PAGE:13437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491PAGE:14492493494495496497498499500PAGE:151,000收入科目合计金额区分支出科目合计金额工资1,0001生活费50奖金5002杂费0其 他 收 入03伙食费004水电费0050060070080090010001100120013001400150016001700180019002000210022002300240025002600270028002900300031003200330034003500360037003800390040004100420043004400450046004700480期初余额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区分4152637485961071181291310141115121613171418151916201721182219232024212522262327242825292630273128322933303431353236333734383539364037413842394340444145424643474448454946504751485249PAGE:1853505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:19108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162PAGE:20163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217PAGE:21218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272PAGE:22273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327PAGE:23328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382PAGE:24383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437PAGE:25438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492PAGE:26493494495496497498499500PAGE:272,450收入科目合计金额区分支出科目合计金额工资01生活费50奖金1,5002杂费0其 他 收 入03伙食费004水电费00500600700800900100011001200130014001500160017001800190020002100220023002400250026002700280029003000310032003300340035003600370038003900400041004200430044004500460047004800490期初余额PAGE:2805000510052005300540055005600570058005900600收入合计1,500支出合计503,900期末余额PAGE:293 3 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额3,90012017/3/2工资10004,900期初余额22017/3/3奖金5005,40032017/3/5生活费505,350区分4152637485961071181291310141115121613171418151916201721182219232024212522262327242825292630273128322933303431353236333734383539364037413842394340444145424643474448454946504751485249PAGE:3053505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:31108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162PAGE:32163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217PAGE:33218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272PAGE:34273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327PAGE:35328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382PAGE:36383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437PAGE:37438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492PAGE:38493494495496497498499500PAGE:393,900收入科目合计金额区分支出科目合计金额工资1,0001生活费50奖金5002杂费0其 他 收 入03伙食费004水电费00500600700800900100011001200130014001500160017001800190020002100220023002400250026002700280029003000310032003300340035003600370038003900400041004200430044004500460047004800490期初余额PAGE:4005000510052005300540055005600570058005900600收入合计1,500支出合计505,350期末余额PAGE:414 4 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额5,35012017/4/2工资10006,350期初余额22017/4/3奖金5006,85032017/4/5生活费506,800区分4152637485961071181291310141115121613171418151916201721182219232024212522262327242825292630273128322933303431353236333734383539364037413842394340444145424643474448454946504751485249PAGE:4253505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:43108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162PAGE:44163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217PAGE:45218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272PAGE:46273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327PAGE:47328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382PAGE:48383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437PAGE:49438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492PAGE:50493494495496497498499500PAGE:515,350收入科目合计金额区分支出科目合计金额工资1,0001生活费50奖金5002杂费0其 他 收 入03伙食费004水电费00500600700800900100011001200130014001500160017001800190020002100220023002400250026002700280029003000310032003300340035003600370038003900400041004200430044004500460047004800490期初余额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区分4152637485961071181291310141115121613171418151916201721182219232024212522262327242825292630273128322933303431353236333734383539364037413842394340444145424643474448454946504751485249PAGE:5453505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:55108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162PAGE:56163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217PAGE:57218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272PAGE:58273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327PAGE:59328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382PAGE:60383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437PAGE:61438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492PAGE:62493494495496497498499500PAGE:636,800收入科目合计金额区分支出科目合计金额工资1,0001生活费50奖金5002杂费0其 他 收 入03伙食费004水电费00500600700800900100011001200130014001500160017001800190020002100220023002400250026002700280029003000310032003300340035003600370038003900400041004200430044004500460047004800490期初余额PAGE:6405000510052005300540055005600570058005900600收入合计1,500支出合计508,250期末余额PAGE:656 6 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额8,25012017/6/2工资10009,250期初余额22017/6/3奖金5009,75032017/6/4生活费509,700区分4152637485961071181291310141115121613171418151916201721182219232024212522262327242825292630273128322933303431353236333734383539364037413842394340444145424643474448454946504751485249PAGE:6653505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:67108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162PAGE:68163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217PAGE:69218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272PAGE:70273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327PAGE:71328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382PAGE:72383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437PAGE:73438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492PAGE:74493494495496497498499500PAGE:758,250收入科目合计金额区分支出科目合计金额工资1,0001生活费50奖金5002杂费0其 他 收 入03伙食费004水电费00500600700800900100011001200130014001500160017001800190020002100220023002400250026002700280029003000310032003300340035003600370038003900400041004200430044004500460047004800490期初余额PAGE:7605000510052005300540055005600570058005900600收入合计1,500支出合计509,700期末余额PAGE:777 7 月月份份No.日期收入科目收入金额支出科目支出金额余额摘要前月余额9,70012017/7/2工资100010,700期初余额22017/7/3奖金50011,20032017/7/4生活费5011,150区分4152637485961071181291310141115121613171418151916201721182219232024212522262327242825292630273128322933303431353236333734383539364037413842394340444145424643474448454946504751485249PAGE:7853505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:79108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162PAGE:80163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217PAGE:81218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272PAGE:82273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327PAGE:83328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382PAGE:84383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437PAGE:85438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492PAGE:86493494495496497498499500PAGE:879,700收入科目合计金额区分支出科目合计金额工资1,0001生活费50奖金5002杂费0其 他 收 入03伙食费004水电费00500600700800900100011001200130014001500160017001800190020002100220023002400250026002700280029003000310032003300340035003600370038003900400041004200430044004500460047004800490期初余额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区分4152637485961071181291310141115121613171418151916201721182219232024212522262327242825292630273128322933303431353236333734383539364037413842394340444145424643474448454946504751485249PAGE:9053505451555256535754585559566057615862596360646566期末余额676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107PAGE:9110810911
