流耘EXCEL账务处理系统

1、,核算单位：,流耘财务软件有限公司,启用年月：,201101,试算平衡,平衡,103,353.05 ,103,353.05 ,年月科目编码,年,月,日,凭证号,结转标记,年-月-日,凭证号,摘要,科目编码,总帐科目,明细科目,借方,贷方,数量,单价,外币,汇率,附件张数,现金流量2011015502,2011,01,06,1,2011/1/6,1,购办公用品,550206,管理费用,办公费,600.00 ,2011011001,2011,01,06,1,2011/1/6,1,购办公用品,1001,现金,600.00 ,2011013131,2011,01,06,2,1,2011/1/6,2,结

2、转期间损益,3131,本年利润,600.00 ,2011015502,2011,01,06,2,1,2011/1/6,2,结转期间损益,550206,管理费用,办公费,600.00 ,2011025502,2011,02,01,1,2011/2/1,1,付差旅费,550208,管理费用,差旅费,800.00 ,2011021001,2011,02,01,1,2011/2/1,1,付差旅费,1001,现金,800.00 ,2011025502,2011,02,01,2,2011/2/1,2,购办公用品,550206,管理费用,办公费,700.00 ,2011021001,2011,02,01,2

3、,2011/2/1,2,购办公用品,1001,现金,700.00 ,2011021211,2011,02,03,3,2011/2/3,3,购原材料,1211,原材料,1,000.00 ,80,12.5,2011022171,2011,02,03,3,2011/2/3,3,购原材料,21710101,应交税金,应交增值税/进项税额,170.00 ,2011021001,2011,02,03,3,2011/2/3,3,购原材料,1001,现金,1,170.00 ,2011023131,2011,02,03,4,1,2011/2/3,4,结转期间损益,3131,本年利润,1,500.00 ,2011

4、025502,2011,02,03,4,1,2011/2/3,4,结转期间损益,550206,管理费用,办公费,700.00 ,2011025502,2011,02,03,4,1,2011/2/3,4,结转期间损益,550208,管理费用,差旅费,800.00 ,2011035502,2011,03,06,1,2011/3/6,1,付管理水电费,550207,管理费用,水电费,1,200.00 ,2011031001,2011,03,06,1,2011/3/6,1,付管理水电费,1001,现金,1,200.00 ,2011035502,2011,03,06,2,2011/3/6,2,付差旅费,

5、550208,管理费用,差旅费,500.00 ,2011031001,2011,03,06,2,2011/3/6,2,付差旅费,1001,现金,500.00 ,2011031131,2011,03,07,3,2011/3/7,3,本月收入,1131,应收账款,11,700.00 ,2011035101,2011,03,07,3,2011/3/7,3,本月收入,510101,主营业务收入,国内销售,10,000.00 ,2011032171,2011,03,07,3,2011/3/7,3,本月收入,21710105,应交税金,应交增值税/销项税额,1,700.00 ,2011031002,201

6、1,03,09,4,2011/3/9,4,收回货款,100201,银行存款,基本户,6,000.00 ,2011031131,2011,03,09,4,2011/3/9,4,收回货款,1131,应收账款,6,000.00 ,2011031131,2011,03,19,5,2011/3/19,5,坏账准备转回,1131,应收账款,500.00 ,2011031141,2011,03,19,5,2011/3/19,5,坏账准备转回,1141,坏账准备,500.00 ,2011031111,2011,03,19,6,2011/3/19,6,收到票据,1111,应收票据,3,000.00 ,20110

7、31131,2011,03,19,6,2011/3/19,6,收到票据,1131,应收账款,3,000.00 ,2011031001,2011,03,19,7,2011/3/19,7,收回票据货款,1001,现金,1,000.00 ,2011031111,2011,03,19,7,2011/3/19,7,收回票据货款,1111,应收票据,1,000.00 ,2011031001,2011,03,19,8,2011/3/19,8,预收货款,1001,现金,3,600.00 ,2011032131,2011,03,19,8,2011/3/19,8,预收货款,2131,预收账款,3,600.00 ,

8、2011031001,2011,03,19,9,2011/3/19,9,贷方退货分录,1001,现金,500.00 ,2011032171,2011,03,19,9,2011/3/19,9,贷方退货分录,21710101,应交税金,应交增值税/进项税额,85.00 ,2011031211,2011,03,19,9,2011/3/19,9,贷方退货分录,1211,原材料,585.00 ,46.8,12.5,2011031211,2011,03,19,10,2011/3/19,10,借方负数退货分录,1211,原材料,(335.00),-26.8,12.5,2011032171,2011,03,1

9、9,10,2011/3/19,10,借方负数退货分录,21710101,应交税金,应交增值税/进项税额,(56.95),2011031001,2011,03,19,10,2011/3/19,10,借方负数退货分录,1001,现金,(391.95),2011031211,2011,03,19,11,2011/3/19,11,另类购货分录,1211,原材料,(20,000.00),-1600,12.5,2011032171,2011,03,19,11,2011/3/19,11,另类购货分录,21710101,应交税金,应交增值税/进项税额,(3,400.00),2011031001,2011,03

10、,19,11,2011/3/19,11,另类购货分录,1001,现金,(23,400.00),2011031211,2011,03,20,12,2011/3/20,12,正常购货分录,1211,原材料,40,000.00 ,3200,12.5,2011032171,2011,03,20,12,2011/3/20,12,正常购货分录,21710101,6,800.00 ,2011031001,2011,03,20,12,2011/3/20,12,正常购货分录,1001,现金,46,800.00 ,2011031001,2011,03,20,13,2011/3/20,13,本月收入,1001,现金

11、,5,850.00 ,2011035101,2011,03,20,13,2011/3/20,13,本月收入,510101,主营业务收入,国内销售,5,000.00 ,2011032171,2011,03,20,13,2011/3/20,13,本月收入,21710105,应交税金,应交增值税/销项税额,850.00 ,2011031002,2011,03,20,14,2011/3/20,14,本月收入,100201,银行存款,基本户,14,040.00 ,2011035101,2011,03,20,14,2011/3/20,14,本月收入,510101,主营业务收入,国内销售,12,000.00 ,2011032171,2011,03,20,14,2011/3/20,14,本月收入,21710105,应交税金,应交增值税/销项税额,2,040.00 ,2011035101,2011,03,20,15,1,2011/3/20,15,结转期间损益,510101,主营业务收入,国内销售,27,000.00 ,2011033131,2011,03,20,15,1,20