完整版总账模板

合集下载

Excel全套账财务账模板(超实用)

Excel全套账财务账模板(超实用)

凭证字 凭证号 月
第 4 页,共 42 页
记 账 凭 证
财务期间:2016年2月
公司名称: 南京超车道服饰贸易有限公司
日 摘要 总账科目
试算平衡: 借贷平衡
会计科目 明细科目 借方金额
凭证字 凭证号 月
第 5 页,共 42 页
记 账 凭 证
财务期间:2016年2月
公司名称: 南京超车道服饰贸易有限公司
凭证字 凭证号 月 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 3 3
第 1 页,共 42 页
记 账 凭 证
财务期间:2016年2月
公司名称: 南京超车道服饰贸易有限公司
日 摘要 总账科目
试算平衡: 借贷平衡
会计科目 明细科目 借方金额
凭证字 凭证号 月
第 2 页,共 42 页
பைடு நூலகம்
记 账 凭 证
试算平衡: 借贷平衡
会计科目 借方金额 明细科目 -10,759.32 安徽宣城朗溪百大-童话故事 13,944.86 常州溧阳董文娟-童话故事 10,371.05 和燕路-童话故事 -187.32 河南-童话故事 -3,655.53 江苏南洋高淳百货-童话故事 江苏南京江宁加盟商(高小勇)-童话故事 -892.98 -9,137.04 江苏南京山百加盟商(张海燕)-童话故事 童话故事 2,990.46 江苏南京加盟商(钱超)-童话故事 10,334.86 江苏桥北奥林加盟商(张海燕)-童话故事 -4,639.47 南京大观天地钱银燕-童话故事 4,792.56 南京石林苏辉-童话故事 5,814.76 桥北太平自营店-童话故事 166.82 苏州泉屋于文娟-童话故事 童话故事 5,366.32 童话故事 童话故事

总分类账模板

总分类账模板

508,500.00
12 24 记 90 收到南宁长远物资公司前欠货款
贷方
625,623.00 452,000.00 5,145,000.00 41,800.00 485,600.00 500,000.00
156,000.00 412,800.00 258,301.00

√或

借 借 借 借 借
贷 贷 借 借 借



2007年 凭证


借方
月日字号
12 1
期初余额
12 7 记 2扬0 物资公司代销宏远 1号及 2号拖拉机各
12 31 记 ##
完工产品入库
3669605.11
12 31 记 ##
结转本月销售成本
总第


分第

会计科目或编号 库存商品
√贷 方
1,332,980.00 3,329,859.33
2,313,552.00 6,360.00
2,319,912.00

√或

借 借 借 借 借 借 借 借 借 贷
余额 √
1,021,517.20 1,976,717.20 1,504,501.20 1,503,101.20 1,498,301.20 3,472,801.20 1,159,249.20 1,152,889.20 1,304,549.20 1,015,362.80
油漆盘亏
12 30 记 ##
21-30 日收料凭证汇总
12 30 记 ##
结转发出材料成本差异
12 30 记 ## 结转发出周转材料应分摊的差异
借方 √ 贷 方
9,780.00 8,706.00

商业银行总账模板

商业银行总账模板

448,035.70


科目名
称: 2301[预

提费用]
上年结转

6
本月凭证 汇总
2,000.00 贷
2,000.00
本年累计
2,000.00 贷
2,000.00


科目名
称:
3101[非

限定性净
资产]
上年结转

8,398.92
1
本月凭证 汇总
16,734.19

8,335.27
本年累计
16,734.19
2,353.33
本年累计
2,353.33 贷
2,353.33
8
本月凭证 汇总
336.19 贷
2,689.52
本年累计
2,689.52 贷
2,689.52
9
本月凭证 汇总
336.19 贷
3,025.71
本年累计
3,025.71 贷
3,025.71
10
本月凭证 汇总
336.19 贷
3,361.90
本年累计
13,078.00 平
6
本月凭证 汇总
5,000.00 贷
5,000.00
本年累计
13,078.00
18,078.00 贷
5,000.00
7
本月凭证 汇总
13,475.00
8,475.00 平
本年累计
26,553.00
26,553.00 平
8
本月凭证 汇总
8,480.00 13,480.00 贷
5,000.00
3,361.90 贷

Excel全套账财务账模板(超实用)

Excel全套账财务账模板(超实用)

3、所有表中基本上只需填写绿色单元格,填写后自动变色,其余均为公式部分。

各表均启用了公式保护,未设密码,如需更改公式,请自行撤销保护。

4、本表设有凭证打印模板,只需输入需要打印的凭证号即自动调出该凭证号的内容,因每张凭证只设了8行分录,所以在录入凭证时请尽量保持每号凭证分录在8行以内,以便打印。

若实在要超出8行,如结转类凭证,则打印该凭证时需在凭证模板最后一行分录后插入若干行,再将公式下拉即可,操作前需撤销工作保护。

1、使用方法:只需在“凭证录入”表中逐笔录入会计分录,其他表格数据即自动生成(科目余额表期初数、损益表本年累计数请参照表中说明录入,资产负债表年初数需手工输入)。

如需生成现金流量表还须手工完成“表外数据录入”工作表。

2、录入凭证时,请在每行会计分录前输入“凭证号”,会计科目可在下拉菜单中选择或手动输入两种方式,先录总账科目再录明细科目,明细科目会自动根据已录总账科目而调出与之对应的预设明细科目。

编制及使用说明:5、本表会计科目设置采用旧“企业会计制度”使用科目,所有总账科目均已列入“会计科目”表中,如非必要,请勿修改总账科目,如需修改,则相应报表关联公式也要作相应修改。

6、明细科目可在总账科目之后自行增减或修改,科目之间不可有空单元格。

7、资产负债表和损益表的取数公式适用于账结法,录入凭证时需严格按照“科目余额表”中科目借贷方性质录入,否则报表数据将会出错。

如:管理费用,科目性质为借方,冲减时不可做在贷方,而应该做借方红字;主营业务收入,科目性质为贷方,冲减时不可做在借方,而应该做贷方红字。

8、关于“现金流量表”的编制: ①本套财务账表中“现金流量表”为参照网上所搜寻资料而编制,编制办法主要是依据两大主表各帐户的变动情况进行分析,并补充若干表外数据(见“表外数据录入”工作表),然后将这些科目的分析结果分别归入现金流量表的各项目,以此自动生成现金流量表。

由于两大主表反映的是各科目余额,无法反映各科目的发生额及明细,因此根据本办法编制的现金流量表并不能完全反映公司现金流量的真实情况,只能反映大概状况,仅供对外使用,如公司决策需要,则须按明细账簿认真分析,另行编制。

总账、明细账(三栏、多栏、数量金额)、日记账格式

总账、明细账(三栏、多栏、数量金额)、日记账格式

现金日记账年记账凭证号数摘要对方科目页数借 方贷 方借或贷余 额月日百十万千百十元角分百十万千百十元角分百十万银行存款日记账户名:帐号:年记账凭证号数摘要对方科目页数借 方贷 方借或贷余 额月日百十万千百十元角分百十万千百十元角分百十万三栏式明细账格式:(应收账款为例)应收账款明细账年记账凭证号数摘要页数借 方贷 方借或贷余 额月日百十万千百十元角分百十万千百十元角分百十万千数量金额式明细账格式:(原材料为例)原材料明细账存货仓名:规格:单位:年记账凭证号数摘要页数收 入发 出数量单价金 额数量单价金 额数量月日百十万千百十元角分百十万千百十元角分借方贷方多栏式明细账格式:(以增值税为例)应交税金(增值税)年记账凭证号数摘要页数借 方合 计进 项 税 额 已 交 税 额 计月日万千百十元角分万千百十元角分万千百十元角分万千总账格式(三栏式):总 账会计科目及编号名称:年记账凭证号数摘要页数借 方贷 方借或贷余 额月日百十万千百十元角分百十万千百十元角分百十万千余 额千百十元角分余 额千百十元角分余 额百十元角分结 存单价金 额百十万千百十元角分(增值税)明细账贷 方借或贷余 额合 计销 项 税 额进 项 税 额 转 出百十元角分万千百十元角分万千百十元角万千百十元角分余 额百十元角分。

  1. 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
  2. 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
  3. 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。

总账单位名称:___________________________ 班级:_______________________________ 姓名:_______________________________ 学号:_______________________________账簿名称:________________________________ 企业名称:________________________________ 账簿页数:____号至____ 号共___页账簿年度:自___年__月__日至___年__月__日会计主管:________________________________ 记账人员:________________________________企业盖章:税务局盖章:财政局建账监管专用章:贴印花处:目录库存现金............................................................................................................................................. 银行存款............................................................................................................................................. 交易性金融资产................................................................................................................................. 应收票据............................................................................................................................................. 应收账款............................................................................................................................................. 坏账准备............................................................................................................................................. 应收股利............................................................................................................................................. 其他应收款......................................................................................................................................... 原材料 ................................................................................................................................................ 周转材料............................................................................................................................................. 库存商品............................................................................................................................................. 生产成本............................................................................................................................................. 长期股权投资..................................................................................................................................... 持有至到期投资................................................................................................................................. 固定资产............................................................................................................................................. 累计折旧............................................................................................................................................. 在建工程............................................................................................................................................. 无形资产............................................................................................................................................. 短期借款............................................................................................................................................. 应付票据............................................................................................................................................. 应付账款............................................................................................................................................. 应付职工薪酬..................................................................................................................................... 应交税费............................................................................................................................................. 应付利息............................................................................................................................................. 长期借款............................................................................................................................................. 实收资本............................................................................................................................................. 盈余公积............................................................................................................................................. 资本公积............................................................................................................................................. 本年利润............................................................................................................................................. 利润分配............................................................................................................................................. 固定资产清理..................................................................................................................................... 管理费用............................................................................................................................................. 销售费用............................................................................................................................................. 在途物资............................................................................................................................................. 主营业务收入..................................................................................................................................... 财务费用............................................................................................................................................. 营业外支出......................................................................................................................................... 制造费用............................................................................................................................................. 资产减值损失..................................................................................................................................... 应付股利............................................................................................................................................. 所得税费用......................................................................................................................................... 营业税金及附加................................................................................................................................. 主营业务成本..................................................................................................................................... ............................................................................................................................................................明细账单位名称:___________________________ 班级:_______________________________ 姓名:_______________________________ 学号:_______________________________账簿名称:________________________________ 企业名称:________________________________ 账簿页数:____号至____ 号共___页账簿年度:自___年__月__日至___年__月__日会计主管:________________________________ 记账人员:________________________________企业盖章:税务局盖章:财政局建账监管专用章:贴印花处:目录应收票据.............................................................................................................................................上海机电设备有限公司............................................................................................................. 应收账款.............................................................................................................................................长春五金公司.............................................................................................................................上海数控机床公司.....................................................................................................................三环传动设备厂......................................................................................................................... 坏账准备............................................................................................................................................. 应收股利.............................................................................................................................................北方轴承厂................................................................................................................................. 其他应收款.........................................................................................................................................太平洋保险公司.........................................................................................................................王军............................................................................................................................................. 长期股权投资.....................................................................................................................................北方轴承厂................................................................................................................................. 持有至到期投资.................................................................................................................................国债............................................................................................................................................. 固定资产.............................................................................................................................................房屋.............................................................................................................................................机器设备.....................................................................................................................................其他.............................................................................................................................................机床............................................................................................................................................. 累计折旧............................................................................................................................................. 在建工程.............................................................................................................................................办公楼......................................................................................................................................... 无形资产.............................................................................................................................................专利权......................................................................................................................................... 累计摊销............................................................................................................................................. 短期借款.............................................................................................................................................银行............................................................................................................................................. 应付票据.............................................................................................................................................中原特钢厂................................................................................................................................. 应付账款.............................................................................................................................................重庆智飞动力有限公司.............................................................................................................哈尔滨亚麻厂.............................................................................................................................电话局.........................................................................................................................................沈阳奥飞电气............................................................................................................................. 应付职工薪酬.....................................................................................................................................职工工资.....................................................................................................................................职工福利..................................................................................................................................... 应交税费.............................................................................................................................................应交营业税.................................................................................................................................应交城市维护建设税.................................................................................................................应交教育费附加.........................................................................................................................代扣代缴个人所得税.................................................................................................................应交所得税................................................................................................................................. 应付利息............................................................................................................................................. 营业税金及附加................................................................................................................................. 长期借款............................................................................................................................................. 实收资本............................................................................................................................................. 盈余公积.............................................................................................................................................法定盈余公积.............................................................................................................................提取任意盈余公积..................................................................................................................... 资本公积.............................................................................................................................................资本溢价..................................................................................................................................... 利润分配.............................................................................................................................................未分配利润.................................................................................................................................提取法定盈余公积.....................................................................................................................提取任意盈余公积.....................................................................................................................向股东分配利润......................................................................................................................... 主营业务收入.....................................................................................................................................甲产品.........................................................................................................................................乙产品......................................................................................................................................... 销售费用.............................................................................................................................................广告费.........................................................................................................................................人工.............................................................................................................................................福利费......................................................................................................................................... 应付股利............................................................................................................................................. 本年利润............................................................................................................................................. 在途物资.............................................................................................................................................角钢............................................................................................................................................. 营业外支出.........................................................................................................................................报废损失.....................................................................................................................................罚款............................................................................................................................................. 财务费用.............................................................................................................................................现金转账支票............................................................................................................................. 资产减值损失..................................................................................................................................... 主营业务成本.....................................................................................................................................甲产品.........................................................................................................................................乙产品......................................................................................................................................... 所得税费用.........................................................................................................................................日记账(银行存款日记账现金日记账)单位名称:___________________________ 班级:_______________________________ 姓名:_______________________________ 学号:_______________________________账簿名称:________________________________ 企业名称:________________________________ 账簿页数:____号至____ 号共___页账簿年度:自___年__月__日至___年__月__日会计主管:________________________________ 记账人员:________________________________企业盖章:税务局盖章:贴印花处:财务报表单位名称:___________________________ 班级:_______________________________ 姓名:_______________________________ 学号:_______________________________。

相关文档
最新文档