超级简易财务记账管理系统EXCEL版本

1、财务记账管理系统使使用用说说明明凭凭证证录录入入账账户户余余额额账账户户查查询询基基础础信信息息科科目目查查询询科科目目余余额额财务记账管理系统收收支支凭凭证证记记录录日期凭证号科目摘要账户收入2017/11/11销售收入工行8674￥2,000.002017/11/32其他收入微信￥500.002017/11/103水电房租现金2017/11/154销售收入微信￥1,800.00支出备注￥1,000.00收收支支凭凭证证记记录录账账户户余余额额表表账户期初金额收入金额支出金额余额合合计计100001000043004300100010001330013300现金10000010009000微

2、信230002300支付宝000工行8674200002000建行3562000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000科科目目余余额额表表科目期初金额收入金额支出金额余额合合计计0 0430043001000100033003300销售收入380003800其他收入5000500水电房租01000-1000000000000000000000000000000000000000000

3、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

4、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000科科目目明明细细查查询询科目：销售收入起止时间：2017/11/1日期凭证号科目摘要账户收入2017/11/11销

5、售收入工行8674￥2,000.002017/11/154销售收入微信￥1,800.002017/11/30支出备注科科目目明明细细查查询询账账户户明明细细查查询询账户：微信起止时间：2017/11/1日期凭证号科目摘要账户收入2017/11/32其他收入微信5002017/11/154销售收入微信18002017/11/30支出备注账账户户明明细细查查询询基基础础信信息息设设置置科目账户销售收入现金其他收入微信水电房租支付宝工行8674建行3562使使用用说说明明1、【基础信息】，先在该表中录入科目名称和账户2、【收支凭证记录】，输入记录表中的记录内容，科目和账户可下拉选择3、【账户余额表】，该表自动进行统计，只需填入期初金额即可，若无期初金额则无需填写4、【科目余额表】，该表自动进行统计，只需填入期初金额即可，若无期初金额则无需填写5、【账户查询表】，