会计账务系统(excel版)

会计账务系统(excel版)
会计账务系统(excel版)

2007-01-011收货款113110应收账款2007-01-011收货款113110应收账款2007-01-0110付货款212106应付账款2007-01-0110付货款212116应付账款2007-01-0110付货款100201银行存款2007-01-0111购委托书550208管理费用2007-01-0111购委托书100101现金

2007-01-0112付电汇费550208管理费用2007-01-0112付电汇费100101现金

2007-01-0113付小车费550209管理费用2007-01-0113付小车费100101现金

2007-01-0114付工资2151应付工资2007-01-0114付工资100101现金

2007-01-0115付伙食费2153应付福利费2007-01-0115付伙食费100101现金

2007-01-0116付记帐费550204管理费用2007-01-0116付记帐费100101现金

2007-01-0117付厂租410502制造费用2007-01-0117付水电410503制造费用2007-01-0117付厂租水电100101现金

2007-01-0118付电话费550202管理费用2007-01-0118付电话费100101现金

2007-01-0119计提伙食费410508制造费用2007-01-0119计提伙食费2153应付福利费2007-01-012收货款100201银行存款2007-01-012收货款113103应收账款2007-01-012收货款113112应收账款2007-01-012收货款113107应收账款2007-01-0121购料121102原材料2007-01-0121购料21710101应交税金2007-01-0121购料212118应付账款2007-01-0122购助焊剂121106原材料2007-01-0122购助焊剂21710101应交税金2007-01-0122购助焊剂212119应付账款2007-01-0123购铜线121101原材料2007-01-0123购铜线21710101应交税金2007-01-0123购铜线212106应付账款2007-01-0124购铜线121101原材料2007-01-0124购铜线21710101应交税金2007-01-0124购铜线212106应付账款2007-01-0125购胶料121102原材料2007-01-0125购胶料21710101应交税金2007-01-0125购胶料212117应付账款2007-01-0126销售113107应收账款

2007-01-0126销售21710105应交税金

2007-01-0126销售5101主营业务收入2007-01-0127销售113110应收账款

2007-01-0127销售21710105应交税金

2007-01-0127销售5101主营业务收入2007-01-0128销售113109应收账款

2007-01-0128销售21710105应交税金

2007-01-0128销售5101主营业务收入2007-01-0129销售113109应收账款

2007-01-0129销售21710105应交税金

2007-01-0129销售5101主营业务收入2007-01-013交税款217102应交税金

2007-01-013交税款100201银行存款

2007-01-0130销售113112应收账款

2007-01-0130销售21710105应交税金

2007-01-0130销售5101主营业务收入2007-01-0131销售113112应收账款

2007-01-0131销售21710105应交税金

2007-01-0131销售5101主营业务收入2007-01-0132销售113112应收账款

2007-01-0132销售21710105应交税金

2007-01-0132销售5101主营业务收入2007-01-0133转出未交税金21710105应交税金

2007-01-0133转出未交税金21710101应交税金

2007-01-0133转出未交税金217102应交税金

2007-01-0134计提税金5402主营业务税金及附加2007-01-0134计提税金217107应交税金

2007-01-0134计提税金217601其他应交款2007-01-0135计提税金5701所得税

2007-01-0135计提税金217111应交税金

2007-01-0136计提税金550210管理费用

2007-01-0136计提税金217602其他应交款2007-01-0137领料410101生产成本

2007-01-0137领料121101原材料

2007-01-0137领料121102原材料

2007-01-0137领料121103原材料

2007-01-0138领料410101生产成本

2007-01-0138领料121106原材料

2007-01-0138领料122101包装物

2007-01-0138领料122102包装物

2007-01-0138领料122103包装物

2007-01-0139半成品入库124101自制半成品2007-01-0139半成品入库124102自制半成品2007-01-0139半成品入库124104自制半成品2007-01-0139半成品入库410101生产成本

2007-01-0139半成品入库410102生产成本

2007-01-0139半成品入库410103生产成本

2007-01-014交税款217107应交税金

2007-01-014交税款217105应交税金

2007-01-014交税款100201银行存款

2007-01-0140半成品出库410104生产成本

2007-01-0140半成品出库124101自制半成品2007-01-0140半成品出库124102自制半成品2007-01-0140半成品出库124104自制半成品2007-01-0141成品入库1243库存商品

2007-01-0141成品入库410104生产成本

2007-01-0142计提折旧费410507制造费用

2007-01-0142计提折旧费550109营业费用

2007-01-0142计提折旧费1502累计折旧

2007-01-0143结转制造费用410103生产成本

2007-01-0143结转制造费用410507制造费用

2007-01-0143结转制造费用410503制造费用

2007-01-0143结转制造费用410502制造费用

2007-01-0143结转制造费用410508制造费用

2007-01-0144结转产成品5401主营业务成本2007-01-0144结转产成品1243库存商品

2007-01-0145结转损益5101主营业务收入2007-01-0145结转损益3131本年利润

2007-01-0146结转损益3131本年利润

2007-01-0146结转损益5401主营业务成本2007-01-0146结转损益5402主营业务税金及附加2007-01-0147结转损益3131本年利润

2007-01-0147结转损益550201管理费用

2007-01-0147结转损益550202管理费用

2007-01-0147结转损益550204管理费用

2007-01-0147结转损益550208管理费用

2007-01-0148结转损益3131本年利润

2007-01-0148结转损益550210管理费用

2007-01-0148结转损益550211管理费用

2007-01-0148结转损益550212管理费用

2007-01-0148结转损益550209管理费用

2007-01-0148结转损益550109营业费用

2007-01-0149结转损益3131本年利润

2007-01-0149结转损益5701所得税

2007-01-015交税款217601其他应交款2007-01-015交税款217602其他应交款2007-01-015交税款100201银行存款

2007-01-0150计提工资410102生产成本

2007-01-0150计提工资550201管理费用

2007-01-0150计提工资2151应付工资

2007-01-016交税款550211管理费用

2007-01-016交税款550212管理费用

2007-01-016交税款100201银行存款

2007-01-017收货款100201银行存款

2007-01-017收货款113115应收账款2007-01-017收货款113109应收账款2007-01-018购发票550208管理费用2007-01-018购发票100201银行存款2007-01-019提现100101现金2007-01-019提现100201银行存款2007-02-011提现100101现金2007-02-011提现100201银行存款

TCL 39601.71hanjinjun TCL 65851.92hanjinjun 永辉昌50000.00hanjinjun 泽力3701.25hanjinjun 工商行53701.25hanjinjun 其他费 4.50hanjinjun 人民币 4.50hanjinjun 其他费42.50hanjinjun 人民币42.50hanjinjun 运输费1382.00hanjinjun 人民币1382.00hanjinjun

27139.80hanjinjun 人民币27139.80hanjinjun

4067.00hanjinjun 人民币4067.00hanjinjun 记帐费4400.00hanjinjun 人民币4400.00hanjinjun 厂租金8110.00hanjinjun 水电费7105.95hanjinjun 人民币15215.95hanjinjun 办公费2050.30hanjinjun 人民币2050.30hanjinjun 福利费4079.50hanjinjun

4079.50hanjinjun 工商行282741.57hanjinjun 富格22573.50hanjinjun 步步高257657.33hanjinjun 开利2510.74hanjinjun 胶料77476.03hanjinjun 应交增值税_进项税金13170.93hanjinjun 荣洲90646.96hanjinjun 助焊剂940.17hanjinjun 应交增值税_进项税金159.83hanjinjun 金箭1100.00hanjinjun 铜线83760.68hanjinjun 应交增值税_进项税金14239.32hanjinjun 永辉昌98000.00hanjinjun 铜线71794.87hanjinjun 应交增值税_进项税金12205.13hanjinjun 永辉昌84000.00hanjinjun 胶料81495.95hanjinjun 应交增值税_进项税金13854.31hanjinjun 中南95350.26hanjinjun 开利3658.34hanjinjun

应交增值税_销项税金531.55hanjinjun

3126.79hanjinjun TCL 70027.10hanjinjun 应交增值税_销项税金10174.90hanjinjun

59852.20hanjinjun 中天信52249.79hanjinjun 应交增值税_销项税金7591.86hanjinjun

44657.93hanjinjun 中天信63958.00hanjinjun 应交增值税_销项税金9293.05hanjinjun

54664.95hanjinjun 未交增值税19678.00hanjinjun 工商行19678.00hanjinjun 步步高107297.58hanjinjun 应交增值税_销项税金15590.29hanjinjun

91707.29hanjinjun 步步高115636.83hanjinjun 应交增值税_销项税金16801.93hanjinjun

98834.90hanjinjun 步步高34722.92hanjinjun 应交增值税_销项税金5045.18hanjinjun

29677.74hanjinjun 应交增值税_销项税金65028.76hanjinjun 应交增值税_进项税金53629.52hanjinjun 未交增值税11399.24hanjinjun

911.94hanjinjun 应交城市维护建设税569.96hanjinjun 教育费附加341.98hanjinjun

5737.83hanjinjun 应交个人所得税5737.83hanjinjun 堤围防护费382.52hanjinjun 堤围防护费382.52hanjinjun 直接材料262405.26hanjinjun 铜线172994.45hanjinjun 胶料64101.01hanjinjun 插件25309.80hanjinjun 直接材料1298.86hanjinjun 助焊剂940.17hanjinjun 大纸箱103.69hanjinjun 中纸箱172.50hanjinjun 小纸箱82.50hanjinjun 白排129731.15hanjinjun 灰排129500.19hanjinjun 导线54073.00hanjinjun 直接材料267328.05hanjinjun 直接人工20880.84hanjinjun 制造费用25095.45hanjinjun

应交城市维护建设税983.90hanjinjun 应交所得税7635.99hanjinjun 工商行8619.89hanjinjun 半成品307050.13hanjinjun 白排122661.55hanjinjun 灰排130315.58hanjinjun 导线54073.00hanjinjun

329920.49hanjinjun 半成品329920.49hanjinjun 折旧费5800.00hanjinjun 折旧费75.00hanjinjun

5875.00hanjinjun 制造费用25095.45hanjinjun 折旧费5800.00hanjinjun 水电费7105.95hanjinjun 厂租金8110.00hanjinjun 福利费4079.50hanjinjun

329920.49hanjinjun

329920.49hanjinjun

382521.80hanjinjun

382521.80hanjinjun

330832.43hanjinjun

329920.49hanjinjun

911.94hanjinjun

12486.70hanjinjun 工资5982.40hanjinjun 办公费2050.30hanjinjun 记帐费4400.00hanjinjun 其他费54.00hanjinjun

2273.12hanjinjun 堤围防护费382.52hanjinjun 个人税20.00hanjinjun 社保费413.60hanjinjun 运输费1382.00hanjinjun 折旧费75.00hanjinjun

5737.83hanjinjun

5737.83hanjinjun 教育费附加590.34hanjinjun 堤围防护费509.07hanjinjun 工商行1099.41hanjinjun 直接人工20880.00hanjinjun 工资5982.40hanjinjun

26862.40hanjinjun 个人税20.00hanjinjun 社保费413.60hanjinjun 工商行433.60hanjinjun 工商行154511.92hanjinjun

金万46751.92hanjinjun 中天信107760.00hanjinjun 其他费7.00hanjinjun 工商行7.00hanjinjun 人民币60000.00hanjinjun 工商行60000.00hanjinjun 人民币10000.00hanjinjun 工商行10000.00hanjinjun

附件张数分录序号账薄查询索引凭证查询索引

1100201_11_1_1

2113110_11_1_2

3113110_11_1_3

1212106_11_10_1

2212116_11_10_2

3100201_11_10_3

1550208_11_11_1

2100101_11_11_2

1550208_11_12_1

2100101_11_12_2

1550209_11_13_1

2100101_11_13_2

12151_11_14_1

2100101_11_14_2

12153_11_15_1

2100101_11_15_2

1550204_11_16_1

2100101_11_16_2

1410502_11_17_1

2410503_11_17_2

3100101_11_17_3

1550202_11_18_1

2100101_11_18_2

1410508_11_19_1

22153_11_19_2

1100201_11_2_1

2113103_11_2_2

3113112_11_2_3

4113107_11_2_4

1121102_11_21_1

221710101_11_21_2

3212118_11_21_3

1121106_11_22_1

221710101_11_22_2

3212119_11_22_3

1121101_11_23_1

221710101_11_23_2

3212106_11_23_3

1121101_11_24_1

221710101_11_24_2

3212106_11_24_3

1121102_11_25_1

221710101_11_25_2

3212117_11_25_3

1113107_11_26_1

35101_11_26_3 1113110_11_27_1 221710105_11_27_2 35101_11_27_3 1113109_11_28_1 221710105_11_28_2 35101_11_28_3 1113109_11_29_1 221710105_11_29_2 35101_11_29_3 1217102_11_3_1 2100201_11_3_2 1113112_11_30_1 221710105_11_30_2 35101_11_30_3 1113112_11_31_1 221710105_11_31_2 35101_11_31_3 1113112_11_32_1 221710105_11_32_2 35101_11_32_3 121710105_11_33_1 221710101_11_33_2 3217102_11_33_3 15402_11_34_1 2217107_11_34_2 3217601_11_34_3 15701_11_35_1 2217111_11_35_2 1550210_11_36_1 2217602_11_36_2 1410101_11_37_1 2121101_11_37_2 3121102_11_37_3 4121103_11_37_4 1410101_11_38_1 2121106_11_38_2 3122101_11_38_3 4122102_11_38_4 5122103_11_38_5 1124101_11_39_1 2124102_11_39_2 3124104_11_39_3 4410101_11_39_4 5410102_11_39_5 6410103_11_39_6

2217105_11_4_2 3100201_11_4_3 1410104_11_40_1 2124101_11_40_2 3124102_11_40_3 4124104_11_40_4 11243_11_41_1 2410104_11_41_2 1410507_11_42_1 2550109_11_42_2 31502_11_42_3 1410103_11_43_1 2410507_11_43_2 3410503_11_43_3 4410502_11_43_4 5410508_11_43_5 15401_11_44_1 21243_11_44_2 15101_11_45_1 23131_11_45_2 13131_11_46_1 25401_11_46_2 35402_11_46_3 13131_11_47_1 2550201_11_47_2 3550202_11_47_3 4550204_11_47_4 5550208_11_47_5 13131_11_48_1 2550210_11_48_2 3550211_11_48_3 4550212_11_48_4 5550209_11_48_5 6550109_11_48_6 13131_11_49_1 25701_11_49_2 1217601_11_5_1 2217602_11_5_2 3100201_11_5_3 1410102_11_50_1 2550201_11_50_2 32151_11_50_3 1550211_11_6_1 2550212_11_6_2 3100201_11_6_3 1100201_11_7_1

3113109_11_7_3 1550208_11_8_1 2100201_11_8_2 1100101_11_9_1 2100201_11_9_2 1100101_22_1_1 2100201_22_1_2

相关文档
最新文档