您好,欢迎访问三七文档
当前位置:首页 > 办公文档 > 模板/表格 > 财务excel格式账表
*****公司财务管理系统四、选择科目,自动生成、查看明细帐六、核定会计科目,录入期初余额2019/9/2216:03五、计算报表底稿,自动生成会计报表二、选择月份,自动生成、查看科目汇总表三、点击按钮,自动生成总帐一、填制凭证,形成完整凭证后可打印必须保存填制凭证科目汇总表总帐明细帐报表底稿资产负债表损益表科目列表数据库*****公司财务管理系统2019年9月22日星期日21选择月份:亿阳汇智通借方金额科目名称贷方金额现金39338.4510000.00银行存款9551.36177503.33应收账款2281.31410.88其他应收款410.88原材料53768.1068407.10库存商品130722.9728420.33应付工资25158.338240.00应交税费16763.61其他应付款206.80157553.50本年利润172333.3368407.10生产成本68407.10172333.33主营业务收入172333.33130722.97主营业务成本130722.97517.00营业税金及附加517.001181.00销售费用1181.0017897.25管理费用17897.252308.67营业外支出2308.674926.61所得税4926.61848829.07合计848829.072011年1月份科目汇总表返回方向金额方向结转现金借方结转银行存款借方结转应收账款借方结转其他应收款借方结转原材料借方结转库存商品借方结转固定资产借方结转累计折旧借方结转应付账款贷方结转应付工资贷方结转应交税费贷方结转实收资本贷方结转利润分配贷方1现金39338.45借方-39338.45借方1银行存款10000.009551.36借方448.64借方1应收账款177503.332281.31借方175222.02借方1其他应收款410.88410.88借方1原材料53768.10借方-53768.10借方1库存商品68407.10130722.97借方-62315.87借方1应付工资28420.3325158.33贷方-3262.00贷方1应交税费8240.0016763.61贷方8523.61贷方1其他应付款206.80贷方206.80贷方1本年利润157553.50172333.33贷方14779.83贷方1生产成本68407.1068407.10贷方1主营业务收入172333.33172333.33贷方1主营业务成本130722.97130722.97借方1营业税金及附加517.00517.00借方1销售费用1181.001181.00借方1管理费用17897.2517897.25借方1营业外支出2308.672308.67借方1所得税4926.614926.61借方2现金90000.0096276.83借方-6276.83借方2银行存款8000.006137.00借方1863.00借方2应收账款191236.6790000.00借方101236.67借方2其他应收款3962.24410.88借方3551.36借方2原材料366316.0095403.62借方270912.38借方2库存商品115394.62153695.96借方-38301.34借方2应付账款306816.00贷方306816.00贷方2应付工资25158.3330510.33贷方5352.00贷方2应交税费6137.0011243.25贷方5106.25贷方2其他应付款1712.24贷方1712.24贷方2本年利润171667.92185666.67贷方13998.75贷方2生产成本115394.62115394.62贷方2主营业务收入185666.67185666.67贷方2主营业务成本153695.96153695.96借方累计余额公司总帐月份记帐科目借方金额贷方金额本月余额2营业税金及附加557.00557.00借方2销售费用529.38529.38借方2管理费用12219.3312219.33借方2所得税4666.254666.25借方3现金40078.47借方-40078.47借方3银行存款9102.3811274.81借方-2172.43借方3应收账款39945.18借方39945.18借方3其他应收款462.24462.24借方3原材料40270.90借方-40270.90借方3库存商品49685.9015749.39借方33936.51借方3应付工资30510.3319934.33贷方-10576.00贷方3应交税费6577.007723.54贷方1146.54贷方3其他应付款1919.0440.97贷方-1878.07贷方3本年利润31476.1434143.56贷方2667.42贷方3生产成本49685.9049685.90贷方3主营业务收入34141.1834141.18贷方3营业外收入2.382.38贷方3主营业务成本15749.3915749.39借方3营业税金及附加1841.501841.50借方3销售费用930.38930.38借方3管理费用12037.5012037.50借方3营业外支出28.2328.23借方3所得税889.14889.14借方4现金40332.61借方-40332.61借方4银行存款19000.0018416.81借方583.19借方4应收账款39945.18借方39945.18借方4其他应收款462.24462.24借方4原材料90524.48借方-90524.48借方4库存商品103159.0018728.37借方84430.63借方4应付工资19934.3323153.85贷方3219.52贷方4应交税费16866.407073.24贷方-9793.16贷方4其他应付款40.97贷方-40.97贷方4本年利润33424.6634141.18贷方716.52贷方4生产成本103159.00103159.00贷方4主营业务收入34141.1834141.18贷方4主营业务成本18728.3718728.37借方4营业税金及附加580.40580.40借方4销售费用1835.021835.02借方4管理费用12022.0312022.03借方4财务费用20.0020.00借方4所得税238.84238.84借方5现金39726.05借方-39726.05借方5银行存款15500.0015481.94借方18.06借方5应收账款45423.53借方45423.53借方5其他应收款462.24462.24借方5原材料47706.40借方-47706.40借方5库存商品57733.4022820.65借方34912.75借方5应付工资23153.8520546.33贷方-2607.52贷方5应交税费13984.4015037.63贷方1053.23贷方5其他应付款46.59贷方46.59贷方5本年利润37693.9438823.53贷方1129.59贷方5利润分配6700.00贷方-6700.00贷方5生产成本57733.4057733.40贷方5主营业务收入38823.5338823.53贷方5主营业务成本22820.6522820.65借方5营业税金及附加660.00660.00借方5销售费用1534.441534.44借方5管理费用12294.2212294.22借方5营业外支出8.108.10借方5所得税376.53376.53借方5以前年度损益调整6700.006700.00借方6现金1052.2034495.29借方-33443.09借方6银行存款8000.008090.09借方-90.09借方6应收账款45148.24借方45148.24借方6其他应收款462.243962.24借方-3500.00借方6原材料48709.00借方-48709.00借方6库存商品59263.0015489.48借方43773.52借方6应付工资20546.3321073.33贷方527.00贷方6应交税费7961.108030.63贷方69.53贷方6其他应付款46.591535.75贷方1489.16贷方6本年利润37494.3538588.24贷方1093.89贷方6生产成本59263.0059263.00贷方6主营业务收入38588.2438588.24贷方6主营业务成本15489.4815489.48借方6营业税金及附加656.00656.00借方6销售费用6411.206411.20借方6管理费用14490.6414490.64借方6财务费用82.4082.40借方6所得税364.63364.63借方7现金32307.09借方-32307.09借方7银行存款10200.0010181.75借方18.25借方7应收账款46800.00借方46800.00借方7其他应收款462.24462.24借方7原材料44137.30借方-44137.30借方7库存商品54272.3024659.47借方29612.83借方7应付工资21073.3320654.33贷方-419.00贷方7应交税费8646.008210.00贷方-436.00贷方7其他应付款1535.751537.44贷方1.69贷方7本年利润39160.0040000.00贷方840.00贷方7生产成本54272.3054272.30贷方7主营业务收入40000.0040000.00贷方7主营业务成本24659.4724659.47借方7营业税金及附加680.00680.00借方7销售费用1496.001496.00借方7管理费用12044.5312044.53借方7所得税280.00280.00借方8现金345000.00330925.00借方14075.00借方8银行存款9500.0011129.44借方-1629.44借方8应收账款47034.00345000.00借方-297966.00借方8其他应收款462.24462.24借方8原材料250000.0050560.20借方199439.80借方8库存商品61403.2025162.92借方36240.28借方8应付账款300000.00250000.00贷方-50000.00贷方8应付工资20654.3321362.33贷方708.00贷方8应交税费7930.008195.90贷方265.90贷方8其他应付款1537.441537.68贷方0.24贷方8本年利润39514.5040200.00贷方685.50贷方8利润分配1500.00贷方-1500.00贷方8生产成本61403.2061403.20贷方8主营业务收入40200.0040200.00贷方8主营业务成本25162.9225162.92借方8营业税金及附加683.40683.40借方8销售费用1232.911232.91借方8管理费用12044.7712044.77借方8营业外支出162.00162.00借方8所得税228.50228.50借方8以前年度损益调整1500.001500.00借方9现金21932.78借方-21932.78借方9银行存款15421.5015271.24借方150.26借方9应收账款47708.4715421.50借方32286.97借方9其他应收款462.24462.24借方9原材料60905.10借方-60905.10借方9库存商品71578.1025585.60借方45992.50借方9应付工资21362.3321192.33贷方-170.00贷方9应交税费13667.408413.54贷方-5253.86贷方9其他应付款1537.681538.37贷方0.69贷方9本年利润39761.4540776.47贷方1015.02贷方9生产成本71578.1071578.10贷方9主营业务收入40776.4740776.47贷方9主营业务成本25585.6025585.60借方9营业税金及附加693.20693.20借方9销售费用1032.691032.69借方9管理费用
本文标题:财务excel格式账表
链接地址:https://www.777doc.com/doc-1092558 .html