簡(jiǎn)潔明了的家庭收支記賬表格-2018版

家庭收支明細(xì),,,,,,,,,,,,,

月份,日期,支出,屬性,備注,收入,屬性,備注,,,,,,

上月轉(zhuǎn)入,,305.00,,,,,,,,,,,

2018年1月,2018.1.9,20.00,我的生活費(fèi),午餐,5000.00,老公工資,,,,,,,

,2018.1.10,200.00,社交支出,請(qǐng)朋友吃飯,2000.00,微信理財(cái)通,老公工資轉(zhuǎn)入微信理財(cái)通,,,,,,

,2018.1.11,2.00,交通支出,公交上班,3000.00,余額寶,老公工資轉(zhuǎn)入余額寶,,,,,,

,2018.1.12,50.00,旅游支出,公園門票,800.00,獎(jiǎng)金,,,,,,,

,2018.1.13,10.00,我的生活費(fèi),給可憐的老人,200.00,網(wǎng)絡(luò)收入,,,,,,,

,2018.1.21,-200.00,中信信用卡,,,,,,,,,,

,,200.00,我的生活費(fèi),買口紅,3000.00,我的工資,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,本月合計(jì),282.00,,,14000.00,,,,,,,,

本月結(jié)余,,14023.00,,,,,,,,,,,

存入銀行,,5000.00,,,,,,,,,,,

,,,,,,,,,,,,,,

上月轉(zhuǎn)入,,9023.00,,,,,,,,,,,

2018年2月,2018.2.1,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,本月合計(jì),0.00,,,0.00,,,,,,,,

本月結(jié)余,,9023.00,,,,,,,,,,,

存入銀行,,0.00,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

家庭支出匯總表,,,,,,,,信用卡賬目,,,,,

月份,家庭生活費(fèi),我的生活費(fèi),老公生活費(fèi),孩子支出,交通支出,旅游支出,社交支出,中信信用卡,交行信用卡,廣發(fā)信用卡,工行信用卡,花唄,負(fù)債

2018年1月,0.00,230.00,0.00,0.00,2.00,50.00,200.00,-200.00,0.00,0.00,0.00,0.00,0.00

2018年2月,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

合計(jì),0.00,230.00,0.00,0.00,2.00,50.00,,-200.00,0.00,0.00,0.00,0.00,0.00

,,,,,,,,,,,,,,

,,,,,,,額度,30000,50000,50000,10000,1000,

,,,,,,,剩余額度,29800,50000,50000,10000,1000,

家庭收入?yún)R總表,,,,,,,資產(chǎn)類賬目,,,,,,

月份,老公工資,我的工資,理財(cái)收益,兼職,網(wǎng)絡(luò)收入,其他,存入銀行,微信零錢,微信理財(cái)通,余額寶,基金,股票,加油卡

2018年1月,5000.00,3000.00,0.00,0.00,200.00,0.00,5000.00,0.00,2000.00,3000.00,0.00,0.00,0.00

2018年2月,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

合計(jì),5000.00,3000.00,0.00,0.00,200.00,0.00,,0.00,2000.00,3000.00,0.00,0.00,0.00

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

說(shuō)明：,,,,,,,備注：,,,,,,

1、在家庭收支明細(xì)中選擇收入/支出屬性，即可在家庭收支匯總表中生成匯總。,,,,,,,1.家庭收支明細(xì)增加表格方法：選中兩個(gè)小黃色橫條之間的區(qū)域（此處最好把下方的黃條選入），復(fù)制，在最下方的黃條后面插入所復(fù)制的表格。,,,,,,

2、明細(xì)增加行可以直接復(fù)制每個(gè)月的一套表插入即可。,,,,,,,,,,,,,

3、家庭收支匯總表增加表格，需在各屬性下方表格內(nèi)修改計(jì)算公式。把計(jì)算范圍計(jì)入相應(yīng)的月份中。,,,,,,,,,,,,,

,,,,,,,"2.家庭收支匯總表增加表格的方法:復(fù)制上一月份，在下方插入所復(fù)制的表格，雙擊各表格修改公式。如將1月份改為2月份的“SUMIF($D$4:$D$14,$B38,C$4:C$14)”（D4變?yōu)镈20,D14變?yōu)镈30，C4變?yōu)镃20，C14變?yōu)镃30。）最終變?yōu)椤癝UMIF($D$20:$D$30,$B38,C$20:C$30)”特別注意：此處只更改相應(yīng)數(shù)字，其余符號(hào)不要變更。",,,,,,

4、現(xiàn)在網(wǎng)絡(luò)掙錢很方便，網(wǎng)絡(luò)收入我是真的有網(wǎng)絡(luò)收入。如果大家沒有，可以替換成其他的。,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

5、月份表格不夠用，直接在此月的最后一欄表格上方插入行即可。,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,3.如還不明白的，建議上網(wǎng)查查sumif函數(shù)的使用方法。,,,,,,

,,,,,,,,,,,,,,

,,,,,,,"4.修改或增加、刪除屬性：

修改：需要修改的屬性直接在匯總表中藍(lán)色區(qū)域修改，會(huì)自動(dòng)生成到收支明細(xì)的匯總表中。

增加或刪除：選中屬性下方需要修改的表格-工具欄“數(shù)據(jù)”-“有效性”-設(shè)置選項(xiàng)卡-允許下選中序列-即可在來(lái)源框中右側(cè)重新選取對(duì)應(yīng)的序列。增加刪除后收支表中“屬性”的下拉選項(xiàng)菜單會(huì)自動(dòng)變更。",,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,,,,,,,

,,,,,,,,