会计财务常用Excel表格-英文财务报表.xls
《会计财务常用Excel表格-英文财务报表.xls》由会员分享,可在线阅读,更多相关《会计财务常用Excel表格-英文财务报表.xls(9页珍藏版)》请在启牛文库网上搜索。
1、Your Company NameBalance SheetsDateTYLY资产Assets流动资产Currentassets:货币资金BankandCash-短期投资CurrentInvestmentInventories一年内到期委托贷款Entrustedloanreceivableduewithinoneyear减:一年内到期委托贷款减值准备Less:ImpairmentforEntrustedloanreceivableduewithinoneyear减:短期投资跌价准备Less:Impairmentforcurrentinvestment短期投资净额Netbalofcurrenti
2、nvestment应收票据Notesreceivable应收股利Dividendreceivable应收利息Interestreceivable应收账款Less:BaddebtprovisionforAccountreceivable -减:应收账款坏账准备NetbalofAccountreceivable应收账款净额Otherreceivable-其他应收款Less:BaddebtprovisionforOtherreceivable减:其他应收款坏账准备NetbalofOtherreceivable其他应收款净额Prepayment预付账款Subsidyreceivable-应收补贴款In
3、ventory存货Less:ProvisionforInventory-减:存货跌价准备NetbalofInventory存货净额Amountduefromcustomerforcontractwork已完工尚未结算款DeferredExpense待摊费用Long-termdebtinvestmentduewithinoneyear一年内到期的长期债权投资Financeleasereceivablesduewithinoneyear-一年内到期的应收融资租赁款Othercurrentassets-其他流动资产流动资产合计Totalcurrentassets$-$-长期投资Long-termin
4、vestment长期股权投资Long-termequityinvestment委托贷款Entrustedloanreceivable长期债权投资Long-termdebtinvestment长期投资合计Totalforlong-terminvestment减:长期股权投资减值准备Less:Impairmentforlong-termequityinvestment减:长期债权投资减值准备Less:Impairmentforlong-termdebtinvestment减:委托贷款减值准备Less:Provisionforentrustedloanreceivable长期投资净额Netbalof
5、long-terminvestment其中:合并价差Include:Goodwill(Negativegoodwill)固定资产Fixedassets固定资产原值Cost减:累计折旧Less:AccumulatedDepreciation固定资产净值Netbal减:固定资产减值准备Less:Impairmentforfixedassets固定资产净额NBVoffixedassets工程物资Materialholdsforconstructionoffixedassets在建工程Constructioninprogress减:在建工程减值准备Less:Impairmentforconstruct
6、ioninprogress在建工程净额Netbalofconstructioninprogress固定资产清理Fixedassetstobedisposedof固定资产合计Netfixedassets$-$-无形资产及其他资产Otherassets&Intangibleassets无形资产Intangibleassets减:无形资产减值准备Less:Impairmentforintangibleassets无形资产净额Netbalofintangibleassets长期待摊费用Long-termdeferredexpense融资租赁未担保余值FinanceleaseUnguaranteedre
7、sidualvalues融资租赁应收融资租赁款FinanceleaseReceivables其他长期资产Othernon-currentassets无形及其他长期资产合计Totalotherassets&intangibleassets递延税项DeferredTax递延税款借项DeferredTaxassets资产总计Total assets$-$-负债及所有者(或股东)权益Liabilities and owners equity流动负债Currentliability短期借款Short-termloans-应付票据Notespayable应付账款Accountspayable-已结算尚未完
8、工款-预收账款Advancefromcustomers-应付工资Payrollpayable-应付福利费Welfarepayable应付股利Dividendpayable应交税金Taxespayable其他应交款Otherfeespayable-其他应付款Otherpayable预提费用AccruedExpense预计负债Provision递延收益DeferredRevenue-一年内到期的长期负债Long-termliabilityduewithinoneyear其他流动负债Othercurrentliability流动负债合计Totalcurrentliabilities长期负债Long-
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 会计 财务 常用 Excel 表格 英文 财务报表