月份中英文对照表
月份中英文对照表
月份中英文对照表
一月：January 简写 Jan.
二月：February 简写 Feb.
三月：March 简写 Mar.
四月：April 简写 Apr.
五月：May 简写 May.
六月：June 简写 Jun.
七月：July 简写 Jul.
八月：August 简写 Aug.
九月：September 简写 Sep. / Sept.
十月：October 简写 Oct.
十一月：November 简写 Nov.
十二月：December 简写 Dec
中英文颜色，月份，星期天对照表
中英文颜色，月份，星期天对照表
粉红 pink 杏色 skin 黃色 yellow 橙色 orange 紫色的、蓝色的 violet
蓝色 bluc 绿色 green 桃红 peachblow 炭灰 anthrazit 紫红色 mauve
克色 black 银色 silver 灰色 grey 军绿 armanigreen 银色的 silver
深红 rubycarmine 棕色 brown 枣红 aubergine 沙色 sand 浅湖蓝 ltturo
海蓝 electricblue 红色 red 灰绿 greygreen 湖蓝 ruro 枣红、酒红 burgundy
百色 white 卡其 khaki 花灰 greymarl 桔色 orange 宝蓝、深蓝 navy
米白米色 ivore 印花 printing 紫色 lilac 文字 letter 丝绸、丝带 silk
紫色的 purpic 绿叶 greenery 淡色 lavender 尼龙 nylon 浅绿色 aqua
灰色灰白 gray 墨水 ink 暗红 red 乳白色 milk 橙红的、浅红的 salmon
咖啡色 coffee 蛇 snake 彩蓝 turo 桔黃、金黃 saffron 浅绿 turquoise
玫红 rose 格子 grid 米白 geram 梅红、深红 strawberry 美国 Ameri
杏色米色 beige 星 star 深紫 purple 灰色的 dusty 日本 Japan
软的、温和的 soit 菱形 rhombus 黑色 black 淡黃色 primrose 工 厂 factory
一月 January 二月 February 三月 March 四月 April 五月 May
七月 July 八月 August 九月 September 十月 October 六月 June
香港制造 Made in Hongkong 玫瑰红 rose 十一月 November 十二月 December
中国制造 Made in China 公司 company 车间 workshop
星期一 星期二 星期三 星期四 星期五 星
期六 星期日
Monday Tuesday Wednesday Thursday
Friday Saturday Sunday
英文版EXCEL中英文对照
激活(activate)数组(array)数组公式(array formula)相关联的数据透视表(associated PivotTable report) 自动套用格式(autoformat)坐标轴(axis)基础地址(base address)“合并计算”表(consolidation table)比较条件(comparison criteria)比较运算符(comparison operator)常量(constant)单元格引用(cell reference)当前区域(current region)分类轴(category axis)分类字段(category field)复制区域(copy area)计算列(calculated column)计算项(calculated item)计算字段（数据库）(calculated field)计算字段（数据透视表）(calculated field)列标题(column heading)列标题(column heading)列字段(column field)条件(criteria)条件窗格(criteria pane)条件格式(conditional format)图表工作表(chart sheet)图表区(chart area)修订记录(change history)约束条件(constraints)证书验证机构(certifying authority)自定义计算(custom calculation)垂直线(drop lines)从属单元格(dependents)明细数据(detail data)默认工作表模板(default worksheet template)默认工作簿模板(default workbook template)默认启动工作簿(default startup workbook)目标区域(destination area)数据标签(data label)数据标志(data marker)数据表(data table)数据表单(data form)数据窗格(data pane)数据点(data points)数据库(database)数据区域(data region)数据系列(data series)数据系列(data series)数据有效性(data validation)数据源(data source)数据源驱动程序(data source driver)图表数据表(data table in charts)下拉列表框(drop-down list box)值区域(values area)值字段(value field)表达式(expression)嵌入图表(embedded chart)外部数据(external data)外部数据(external data)外部数据区域(external data range)外部引用(external reference)误差线(error bars)编辑栏(formula bar)公式(formula)公式选项板(Formula Palette)函数(Microsoft Query)(function)函数(Office Excel)(function)筛选(filter)填充柄(fill handle)字段（数据库）(field)字段（数据透视表）(field)单变量求解(goal seek)图表中的网格线(gridlines in charts)组(group)冲突日志工作表(History worksheet)高低点连线(high-low lines)插入行(Insert row)迭代(iteration)绝对交集(implicit intersection)内部连接(inner join)输入单元格(input cell)索引(index)项(item)连接(join)连接线(join line)连接线(join line)锁定的字段或记录(locked field or record)图例(legend)图例项标示(legend keys)合并单元格(merged cell)活动选定框(moving border)矩阵(matrix)移动平均(moving average)映射范围(mapped range)操作数(operand)分级显示(outline)分级显示符号(outline symbols)分级显示数据(outline data)脱机多维数据集文件(offline cube file)外部连接(outer join)外部连接(outer join)运算符(operator)磅(point)保护(protect)报表筛选(report filter)参数(parameter)参数查询(parameter query)打印标题(print titles)打印区域(print area)分页符(page break)分页预览(page break preview)绘图区(plot area)密码(password)数据透视表(PivotTable report)数据透视表(PivotTable report)数据透视表分类汇总(PivotTable subtotal)数据透视表列表(PivotTable list)数据透视表数据(PivotTable data)数据透视表总计(PivotTable grand totals)数据透视图报表(PivotChart report)数据透视图分类字段(PivotChart category field)数据透视图系列字段(PivotChart series field)透视区域(pivot area)引用单元格(precedents)粘贴区域(paste area)主键(primary key)属性字段(property fields)查询(query)详细出处参考：/office/excel/16273.htmlEXCEL函数大全数据库和清单管理函数DA VERAGE 返回选定数据库项的平均值DCOUNT 计算数据库中包含数字的单元格的个数DCOUNTA 计算数据库中非空单元格的个数DGET 从数据库中提取满足指定条件的单个记录DMAX 返回选定数据库项中的最大值DMIN 返回选定数据库项中的最小值DPRODUCT 乘以特定字段（此字段中的记录为数据库中满足指定条件的记录）中的值DSTDEV 根据数据库中选定项的示例估算标准偏差DSTDEVP 根据数据库中选定项的样本总体计算标准偏差DSUM 对数据库中满足条件的记录的字段列中的数字求和DV AR 根据数据库中选定项的示例估算方差DV ARP 根据数据库中选定项的样本总体计算方差GETPIVOTDA TA 返回存储在数据透视表中的数据日期和时间函数DATE 返回特定时间的系列数DATEDIF 计算两个日期之间的年、月、日数DATEV ALUE 将文本格式的日期转换为系列数DAY 将系列数转换为月份中的日DAYS360 按每年360天计算两个日期之间的天数EDATE 返回在开始日期之前或之后指定月数的某个日期的系列数EOMONTH 返回指定月份数之前或之后某月的最后一天的系列数HOUR 将系列数转换为小时MINUTE 将系列数转换为分钟MONTH 将系列数转换为月NETWORKDAYS 返回两个日期之间的完整工作日数NOW 返回当前日期和时间的系列数SECOND 将系列数转换为秒TIME 返回特定时间的系列数TIMEV ALUE 将文本格式的时间转换为系列数TODAY 返回当天日期的系列数WEEKDAY 将系列数转换为星期WORKDAY 返回指定工作日数之前或之后某日期的系列数YEAR 将系列数转换为年YEARFRAC 返回代表START_DATE（开始日期）和END_DATE（结束日期）之间天数的以年为单位的分数DDE 和外部函数CALL 调用动态链接库(DLL)或代码源中的过程REGISTER.ID 返回已注册的指定DLL或代码源的注册IDSQL.REQUEST 连接外部数据源，并从工作表中运行查询，然后将结果作为数组返回，而无需进行宏编程。
大会计报表：资产负债表、损益表、现金流量表中英文对照
英文会计报表:F I N A N C I A L R E P O R T C O V E R报表所属期间之期末时间点 Period Ended所属月份 Reporting Period报出日期 Submit Date记账本位币币种 Local Reporting Currency审核人 Verifier填表人 Preparer所属月份Reporting Period报出日期Submit Date资产负债表Balance Sheet资产?Assets流动资产?Current Assets货币资金?Bank and Cash短期投资?Current Investment一年内到期委托贷款 Entrusted loan receivable due within one year减：一年内到期委托贷款减值准备?Less: Impairment for Entrusted loan receivable due within one year 减：短期投资跌价准备?Less: Impairment for current investment短期投资净额?Net bal of current investment应收票据?Notes receivable应收股利?Dividend receivable应收利息 Interest receivable应收账款?Account receivable减：应收账款坏账准备?Less: Bad debt provision for Account receivable应收账款净额?Net bal of Account receivable其他应收款?Other receivable减：其他应收款坏账准备 Less: Bad debt provision for Other receivable其他应收款净额 Net bal of Other receivable预付账款?Prepayment应收补贴款?Subsidy receivable存货?Inventory减：存货跌价准备?Less: Provision for Inventory存货净额 Net bal of Inventory已完工尚未结算款 Amount due from customer for contract work待摊费用?Deferred Expense一年内到期的长期债权投资?Long-term debt investment due within one year一年内到期的应收融资租赁款 Finance lease receivables due within one year其他流动资产?Other current assets流动资产合计?Total current assets长期投资 Long-term investment长期股权投资?Long-term equity investment委托贷款 Entrusted loan receivable长期债权投资 Long-term debt investment长期投资合计 Total for long-term investment减：长期股权投资减值准备?Less: Impairment for long-term equity investment 减：长期债权投资减值准备?Less: Impairment for long-term debt investment 减：委托贷款减值准备 Less: Provision for entrusted loan receivable长期投资净额 Net bal of long-term investment其中：合并价差?Include: Goodwill (Negative goodwill)固定资产?Fixed assets固定资产原值?Cost减：累计折旧 Less: Accumulated Depreciation 固定资产净值?Net bal减：固定资产减值准备?Less: Impairment for fixed assets固定资产净额?NBV of fixed assets工程物资?Material holds for construction of fixed assets在建工程?Construction in progress减：在建工程减值准备?Less: Impairment for construction in progress 在建工程净额 Net bal of construction in progress固定资产清理?Fixed assets to be disposed of 固定资产合计?Total fixed assets无形资产及其他资产?Other assets & Intangible assets无形资产 Intangible assets减：无形资产减值准备?Less: Impairment for intangible assets无形资产净额 Net bal of intangible assets长期待摊费用?Long-term deferred expense融资租赁——未担保余值Finance lease – Unguaranteed residual values 融资租赁——应收融资租赁款Finance lease –?Receivables其他长期资产 Other non-current assets无形及其他长期资产合计Total other assets & intangible assets递延税项?Deferred Tax递延税款借项?Deferred Tax assets资产总计 Total assets负债及所有者（或股东）权益 Liability & Equity 流动负债 Current liability短期借款?Short-term loans应付票据?Notes payable应付账款?Accounts payable已结算尚未完工款预收账款?Advance from customers应付工资?Payroll payable应付福利费?Welfare payable应付股利?Dividend payable应交税金?Taxes payable其他应交款?Other fees payable其他应付款?Other payable预提费用?Accrued Expense预计负债?Provision递延收益?Deferred Revenue一年内到期的长期负债Long-term liability due within one year其他流动负债?Other current liability流动负债合计?Total current liability长期负债 Long-term liability长期借款?Long-term loans应付债券?Bonds payable长期应付款?Long-term payable专项应付款?Grants & Subsidies received其他长期负债?Other long-term liability长期负债合计 Total long-term liability递延税项 Deferred Tax递延税款贷项?Deferred Tax liabilities负债合计 Total liability少数股东权益?Minority interests所有者权益（或股东权益）Owners’ Equity实收资本（或股本） Paid in capital减；已归还投资 Less: Capital redemption 实收资本（或股本）净额 Net bal of Paid in capital资本公积 Capital Reserves盈余公积?Surplus Reserves其中：法定公益金?Include: Statutory reserves 未确认投资损失?Unrealised investment losses未分配利润 Retained profits after appropriation其中：本年利润?Include: Profits for the year 外币报表折算差额?Translation reserve 所有者（或股东）权益合计 Total Equity 负债及所有者（或股东）权益合计Total Liability & Equity损益表Income statement and profit appropriation一、主营业务收入?Revenue减：主营业务成本?Less: Cost of Sales主营业务税金及附加?Sales Tax二、主营业务利润（亏损以“—”填列） Gross Profit ( - means loss)加：其他业务收入?Add: Other operating income减：其他业务支出 Less: Other operating expense减：营业费用?Selling & Distribution expense管理费用?G&A expense财务费用?Finance expense三、营业利润（亏损以“—”填列） Profit from operation ( - means loss)加：投资收益（亏损以“—”填列） Add: Investment income补贴收入?Subsidy Income营业外收入?Non-operating income减：营业外支出?Less: Non-operating expense四、利润总额（亏损总额以“—”填列） Profit before Tax减：所得税?Less: Income tax少数股东损益?Minority interest加：未确认投资损失 Add: Unrealised investment losses五、净利润（净亏损以“—”填列） Net profit ( - means loss)加：年初未分配利润 Add: Retained profits其他转入 Other transfer-in六、可供分配的利润 Profit available for distribution( - means loss)减：提取法定盈余公积?Less: Appropriation of statutory surplus reserves提取法定公益金 Appropriation of statutory welfare fund提取职工奖励及福利基金 Appropriation of staff incentive and welfare fund提取储备基金 Appropriation of reserve fund提取企业发展基金?Appropriation of enterprise expansion fund利润归还投资?Capital redemption七、可供投资者分配的利润 Profit available for owners' distribution减：应付优先股股利?Less: Appropriation of preference share's dividend提取任意盈余公积?Appropriation of discretionary surplus reserve应付普通股股利?Appropriation of ordinary share's dividend转作资本（或股本）的普通股股利 Transfer from ordinary share's dividend to paid in capital八、未分配利润 Retained profit after appropriation补充资料： Supplementary Information:1．出售、处置部门或被投资单位收益 Gains on disposal of operating divisions or investments 2．自然灾害发生损失 Losses from natural disaster3．?会计政策变更增加（或减少）利润总额?Increase (decrease) in profit due to changes in accounting policies4．?会计估计变更增加（或减少）利润总额 Increase (decrease) in profit due to changes in accounting estimates5．?债务重组损失?Losses from debt restructuring流量表编辑Cash Flow Statement一、经营活动产生的现金流量： Cash Flow from Operating Activities:销售商品、提供劳务收到的现金 Cash received from sales of goods or rendering services 收到的税费返还 Refunds of taxes收到的其他与经营活动有关的现金 Cash received relating to other operating activities现金流入小计 Sub-total of cash inflows购买商品、接受劳务支付的现金 Cash paid for goods or receiving services支付给职工以及为职工支付的现金 Cash paid to and on behalf of employees支付的各项税费 Tax payments支付的其他与经营活动有关的现金 Cash paid relating to other operating activities现金流出小计 Sub-total of cash outflows经营活动产生的现金流量净额?Net Cash Flow from Operating Activities二、投资活动产生的现金流量： Cash Flow from Investing Activities:收回投资所收到的现金 Cash received from disposal of investments处置子公司和其他经营单位收到的现金 Cash received from disposal of subsidiary or other operating business units取得投资收益所收到的现金 Cash received from investments income处置固定资产、无形资产和其他长期资产而收到的现金净额 Net cash received from disposal of fixed assets, intangible assets and other long-term assets购买子公司所收到的现金 Cash received by acquisition of subsidiary收到的其他与投资活动有关的现金 Cash received relating to other investing activities现金流入小计 Sub-total of cash inflows购建固定资产、无形资产和其他长期资产所支付的现金 Cash paid to acquire fixed assets, intangible assets and other long-term assets投资所支付的现金 Cash paid to acquire investments支付的其他与投资活动有关的现金 Cash payments relating to other investing activities现金流出小计 Sub-total of cash outflows投资活动产生的现金流量净额 Net Cash Flow from Investing Activities三、筹资活动产生的现金流量： Cash Flow from Financing Activities:吸收投资所收到的现金 Cash received by investors借款所收到的现金 Cash received from borrowings其中：从金融机构借款所收到的现金 Include: Cash received from financial institution borrowings收到的其他与筹资活动有关的现金 Cash received relating to other financing activities现金流入小计 Sub-total of cash inflows偿还债务所支付的现金 Repayments of borrowings其中：偿还金融机构债务所支付的现金 Include: Repayments of financial institution borrowings 分配股利、利润和偿付利息所支付的现金 Dividends paid, profit distributed or interest paid 支付的其他与筹资活动有关的现金 Cash payments relating to other financing activities现金流出小计 Sub-total of cash outflows筹资活动产生的现金流量净额 Net Cash Flow from Financing Activities四、汇率变动对现金的影响额 Effect of Foreign Currency Translation五、现金及现金等价物净增加额 Net Increase (Decrease) in Cash and Cash Equivalents现金流量附表： Supplementary Information:1.将净利润调节为经营活动的现金流量： Reconciliation of Net Profit to Cash Flow from Operating Activities:净利润 Net Profit加：少数股东损益 Add: Minority interest加：计提的资产减值准备?Impairment losses on assets固定资产折旧?Depreciation of fixed assets无形资产摊销?Amortisation of intangible assets长期待摊费用摊销 Amortisation of long-term deferred expenses待摊费用减少（减：增加） Decrease (increase) in deferred expenses预提费用增加（减：减少） Increase (decrease) in accrued expenses处置固定资产、无形资产和其他长期资产的损失（减、收益） Losses (gains) on disposal of fixed assets, intangible assets and other long-term assets固定资产报废损失 Losses on write-off of fixed assets财务费用 Finance expense (income)投资损失（减、收益） Losses (gains) arising from investments递延税款贷款（减、借项） Deferred tax credit (debit)存货的减少（减、增加） Decrease (increase) in inventories经营性应收项目的减少（减、增加） Decrease (increase) in receivables under operating activities经营性应付项目的增加（减、减少） Increase (decrease) in payables under operating activities 其他 Others经营活动产生的现金流量净额?Net cash flow from operating activities2.不涉及现金收支的投资和筹资活动： Investing and Financing Activities that do not Involve Cash Receipts and Payments:债务转为资本 Conversion of debt into capital一年内到期的可转换公司债券?Reclassification of convertible bonds expiring within one year as current liability融资租入固定资产 Fixed assets acquired under finance leases3.现金及现金等价物净增加情况： Net Increase in Cash and Cash Equivalents:现金的期末余额 Cash at the end of the period减：现金的期初余额?Less: cash at the beginning of the year加：现金等价物的期末余额?Add: cash equivalents at the end of the period减：现金等价物的期初余额 Less: cash equivalents at the beginning of the period现金及现金等价物净增加额 Net increase in cash and cash equivalents。
会计报表中英文对照
一、企业财务会计报表封面 FINANCIAL REPORT COVER 报表所属期间之期末时间点 PeriodEnded 所属月份 Reporting Period 报出日期 Submit Date 记账本位币币种 Local Reporting Currency 审核人 Verifier 填表人 Preparer 二、资产负债表 Balance Sheet资产 Assets流动资产 Current Assets货币资金 Bank and Cash短期投资 Current Investment 一年内到期委托贷款 Entrusted loan receivable due within one year 减：一年内到期委托贷款减值准备 Less: Impairment for Entrusted loan receivable due within oneyear 减：短期投资跌价准备 Less: Impairment for current investment 短期投资净额 Net bal of current investment 应收票据 应收股利 应收利息 应收账款 减：应收账款坏账准备 Less: Bad debt provision for Account receivable 应收账款净额 Net bal of Account receivable 其他应收款 Other receivable 减：其他应收款坏账准备 Less: Bad debtprovisionfor Other receivable 其他应收款净额 Net bal of Other receivable 预付账款 Prepayment 应收补贴款 Subsidy receivable 存货 Inventory 减：存货跌价准备 Less: Provision for Inventory 存货净额 Net bal of Inventory 已完工尚未结算款 Amount due from customer for contract work 待摊费用 Deferred Expense 一年内到期的长期债权投资 Long-term debt investment due within one year 一年内到期的应收融资租赁款 Finance lease receivables due within one year 其他流动资产 Other current assets 流动资产合计 Total current assets 长期投资 Long-term investment 长期股权投资 Long-term equity investment 委托贷款 Entrusted loan receivable长期债权投资 Long-term debt investment 长期投资合计 Total for long-term investmentNotes receivable Dividend receivable Account receivable减：长期股权投资减值准备 Less: Impairment for long-term equity investment 减：长期债权投资减值准备 Less: Impairment for long-term debt investment 减：委托贷款减值准备 Less: Provision for entrusted loan receivable 长期投资净额 Net bal of long-term investment 其中：合并价差 Include: Goodwill (Negative goodwill) 固定资产 Fixed assets 固定资产原值固定资产净值 减：固定资产减值准备 Less: Impairment for fixed assets 固定资产净额 NBVof fixed assets 工程物资 Material holds for construction of fixed assets 在建工程 Construction in progress 减：在建工程减值准备 Less: Impairment for construction in progress 在建工程净额 Net bal of construction in progress 固定资产清理 Fixed assets to be disposed of 固定资产合计 无形资产及其他资产 Other assets & Intangible assets 无形资产Intangibleassets 减：无形资产减值准备 Less: Impairment for intangible assets 无形资产净额 Net bal of intangible assets 长期待摊费用 Long-term deferred expense融资租赁 -- 未担保余值 Finance lease - Unguaranteed residual values融资租赁 -- 应收融资租赁款 Finance lease - Receivables其他长期资产 Other non-current assets无形及其他长期资产合计 Total other assets & intangible assets 递延税项 Deferred Tax 递延税款借项 Deferred Tax assets 资产总计 Total assets 负债及所有者(或股东)权益 Liability & Equity 流动负债 短期借款 应付票据 应付账款 已结算尚未完工款 预收账款 Advancefrom customers 应付工资 Payroll payable 应付福利费 Welfare payable 应付股利 Dividend payable 应交税金 Taxes payable 其他应交款 Other fees payable 其他应付款 Other payable 预提费用 Accrued Expense 预计负债 Provision Cost减：累计折旧 Less: AccumulatedDepreciationTotal fixed assetsCurrentliabilityShort-term loans Notes递延收益 Deferred Revenue 一年内到期的长期负债 Long-term liability due within one year 其他流动负债 Other current liability 流动负债合计 Total current liability 长期负债 Long-term liability 长期借款 Long-term loans 应付债券 Bonds payable 长期应付款Long-term payable 专项应付款 Grants & Subsidies received 其他长期负债 Other long-term liability 长期负债合计 Total long-term liability 递延税项 Deferred Tax 递延税款贷项 Deferred Tax liabilities 负债合计 Total liability 少数股东权益 Minority interests 所有者权益（或股东权益） Owners' Equity 实收资本（或股本） Paid in capital 减；已归还投资 Less: Capital redemption 实收资本（或股本）净额 Net bal of Paid in capital 资本公积 Capital Reserves 盈余公积 Surplus Reserves 其中：法定公益金Include: Statutory reserves 未确认投资损失 Unrealised investment losses 未分配利润Retained profits after appropriation 其中：本年利润 Include: Profits for the year 外币报表折算差额 Translation reserve 所有者（或股东）权益合计 Total Equity 负债及所有者（或股东）权益合计Total Liability & Equity三、利润及利润分配表 Income statement and profit appropriation 一、主营业务收入Revenue 减：主营业务成本 Less: Cost of Sales 主营业务税金及附加 Sales Tax二、主营业务利润（亏损以“—”填列）Gross Profit （ - means loss）加：其他业务收入 Add: Other operating income 减：其他业务支出 Less: Other operating expense 减：营业费用 Selling & Distribution expense 管理费用 G&A expense 财务费用Finance expense三、营业利润（亏损以“—”填列）加：投资收益（亏损以“—”填列）补贴收入 Subsidy Income 营业外收入 Non-operatingincome 减：营业外支出 Less: Non-operating expense Profit from operation （ - means loss） Add: Investment四、利润总额(亏损总额以“—”填列)减：所得税 Less: Income tax 少数股东损益 Minority interest 加：未确认投资损失 Add: Unrealised investment losses五、净利润(净亏损以“—”填列) Net profit ( - means loss)加：年初未分配利润 Add: Retained profits 其他转入 Other transfer-in六、可供分配的利润 Profit available for distribution( - means loss) 减：提取法定盈余公积 Less: Appropriation of statutory surplus reserves 提取法定公益金 Appropriation of statutory welfare fund 提取职工奖励及福利基金 Appropriation of staff incentive and welfare fund 提取储备基金 Appropriation of reserve fund 提取企业发展基金 Appropriation of enterprise expansion fund 利润归还投资 Capital redemption七、可供投资者分配的利润 Profit available for owners' distribution 减：应付优先股股利 Less: Appropriation of preference share's dividend 提取任意盈余公积 Appropriation of discretionary surplus reserve 应付普通股股利 Appropriation of ordinary share's dividend 转作资本(或股本)的普通股股利 Transfer from ordinary share's dividend to paid in capital八、未分配利润 Retained profit after appropriationSupplementary Information: 出售、处置部门或被投资单位收益 自然灾害发生损失 会计政策变更增加Profit before Tax补充资料：1． 2．Gains on disposal of operating divisions or investments Losses from natural disaster 或减少) 利润总额 Increase (decrease) in profit due to changes in accounting 3．policies4． 会计估计变更增加 或减少) 利润总额 Increase (decrease) in profit due to changes in accounting。
英文excel 中英文对照表
英文版Excel 中英文对照表激活（activate）数组（array）数组公式（array formula）相关联的数据透视表(associated PivotTable report )自动套用格式(autoformat)坐标轴(asix)基础地址(base address)“合并计算”表(consolidation table)比较条件(comparison criteria)比较运算符（comparison operator）常量(constant)单元格引用(cell reference)当前区域(current region)分类轴(category asix)分类字段(category field)复制区域(copy area)计算列(calculated column)计算项(calculated item)计算字段（数据库）(calculated field)计算字段（数据透视表）(calculated field)列标题(column heading)列字段(column field)条件(criteria)条件窗格((criteria pane)条件格式(conditional format)图表工作表(chart sheet)图表区(chart area)修订记录(change history)约束条件(constraints)证书验证机构(certifying authority)自定义计算(custom calculation)垂直线(drop lines)从属单元格(dependents)明细数据(detail data)默认工作表模板(default worksheet template)默认工作簿模板(default workbook template)默认启动工作簿(default startup workbook )目标区域（destination area）数据标签 (data label)数据标志(data marker)数据表(data table)数据表单(data form)数据窗格(data pane)数据点(data points)数据库(database)数据区域(data region)数据系列(data series)数据有效性(data validation)数据源(data source)数据源驱动程序(data source driver)图表数据表(data table in charts)下拉列表框(drop-down list box)值区域(values area)值字段(value field)表达式(expression)嵌入图表(embedded chart)外部数据(external data)外部数据区域 (external data range)外部引用(external reference)误差线(error bars)编辑栏(formula bar)公式(formula)公式选项板(Formula Palette)函数(function)函数筛选(filter)填充柄(fill handle)字段（数据库）(field)字段（数据透视表）(field)单变量求解(goal seek)图表中的网络线(gridlines charts)组(group)冲突日志工作表(history worksheet)高低点连线(high-low lines)插入行(Insert row)迭代(iteration)绝对交集(implicit intersection)内部连接(inner join)输入单元格(imput cell)索引(index)项(item)连接(join)连接线(join line)锁定的字段或记录(locked field or record)图例（legend）图例项标示（legend keys）合并单元格(merged cell)活动选定框(moving border)矩阵(matrix)移动平均(moving average)映射范围(mapped range)操作数(operand)分级显示(outline)分级显示符号(outline symbols)分级显示数据(outline data)脱机多维数据集文件(offline cube file)外部连接(outer join)运算符(operator)磅(point)保护(protect)报表筛选(reporter filter)参数 parameter参数查询 parameter query打印标题 print totles打印区域 print area分页符 page break分页预览 page break preview绘图区 plot area密码 password数据透视表 PivotTable report数据透视表分类汇总 PivotTable sobtotal数据透视表列表 PivotTable list数据透视表数据 PivotTable data数据透视表总计 PivotTable grand totals数据透视图报表 Pivotchart report数据透视图分类字段 Pivotchart category field 数据透视图系列字段 Pivotchart series field 透视区域 pivot area引用单元格 precedents粘贴区域 paste area主键 primary key属性字段 property fields查询 queryExcel函数大全数据库和清单管理函数DAVERAGE (daverage) 返回选定数据库项的平均值DCOUNT (dcount) 记算数据库中包含数字的单元格的个数DCOUNTA (dcounta) 记算数据库中非空单元格的个数DGET (dget) 从数据库中提取满足指定条件的单个记录DMAX (dmax) 返回选定数据库项中的最大值DMIN (dmin) 返回选定数据库项中的最小值DPRODUCT (dproduct) 乘以特定字段（此字段中的记录为数据库中满足指定条件的记录）中的值DSTDEV (dstdev) 根据数据库中选定项的示例估算标准偏差DSTDEVP (dstdevp) 根据数据库中选定项的样本总体计算标准偏差DSUM (dsum) 对数据库中满足条件的记录的字段列中的数字求和DVAR (dvar) 根据数据库中选定项的示例估算方差DVARP (dvarp) 根据数据库中选定项的样本总体计算方差GETPIVOTDATA(getpivotdata)返回存储在数据透视表中的数据日期和时间函数DATE (date) 返回特定时间的系列数DATEDIF (datedif) 计算两个日期之间的年、月、日数DATEVALUE (datevalue) 将文本格式的日期转换为系列数DAY(day) 将系列数转换为月份中的日DAYS360 (days360) 按每年360天计算两个日期之间的天数EDATE (edate) 返回在开始日期之前或之后指定月数的某个日期的系列数EOMONTH (eomonth) 返回指定月份数之前或之后某月的最后一天的系列数HOUR （hour）将系列数转换为小时MINITE (minite) 将系列数转换为分钟MONTH (month) 将系列数转换为月NETWORKDAYS (networkdays) 返回两个日期之间的完整工作日数NOW (now) 返回当前日期和时间的系列数SECOND (second) 将系列数转换为秒TIME (time) 返回特定时间的系列数TIMEVALUE (timevalue) 将文本格式的时间转换为系列数TODAY (today) 返回当天日期的系列数WEEKDAY (weekday) 将系列数转换为星期WORKDAY (workday) 返回指定工作日数之前或之后某日期的系列数YEAR(year) 将系列数转换为年YEARFRAC(yearfrac)（返回代表START_DATE（开始日期）和END_DATE（结束日期）之间天数的以年为单位的分数DDE 和外部函数CALL(call) 调用动态链接库(DLL)或代码源中的过程返回已注册的指定DLL或代码源的注册ID连接外部数据源，并从工作表中运行查询，然后将结果作为数组返回，而无需进行宏编程。
英文版Excel 中英文对照表
英文版Excel 中英文对照表激活（activate）数组（array）数组公式(array formula）相关联的数据透视表（associated PivotTable report ）自动套用格式(autoformat)坐标轴(asix)基础地址(base address)“合并计算”表（consolidation table)比较条件(comparison criteria）比较运算符（comparison operator）常量(constant）单元格引用（cell reference)当前区域(current region）分类轴（category asix)分类字段(category field)复制区域(copy area）计算列（calculated column）计算项（calculated item)计算字段(数据库)(calculated field）计算字段(数据透视表)（calculated field)列标题（column heading）列字段(column field)条件(criteria）条件窗格（（criteria pane）条件格式（conditional format)图表工作表（chart sheet)图表区(chart area）修订记录（change history）约束条件(constraints)证书验证机构(certifying authority）自定义计算(custom calculation)垂直线（drop lines)从属单元格(dependents)明细数据(detail data）默认工作表模板(default worksheet template）默认工作簿模板（default workbook template)默认启动工作簿(default startup workbook ）目标区域（destination area）数据标签（data label）数据标志（data marker）数据表(data table)数据表单（data form)数据窗格（data pane)数据点（data points)数据库（database）数据区域（data region）数据系列(data series）数据有效性(data validation)数据源(data source）数据源驱动程序（data source driver)图表数据表（data table in charts）下拉列表框(drop—down list box)值区域（values area）值字段(value field)表达式（expression）嵌入图表(embedded chart)外部数据（external data)外部数据区域（external data range)外部引用(external reference）误差线（error bars）编辑栏(formula bar)公式(formula）公式选项板（Formula Palette）函数(function）函数筛选（filter)填充柄(fill handle)字段（数据库）(field)字段(数据透视表）(field)单变量求解（goal seek)图表中的网络线（gridlines charts）组(group）冲突日志工作表（history worksheet）高低点连线（high-low lines)插入行(Insert row)迭代（iteration)绝对交集（implicit intersection)内部连接(inner join)输入单元格(imput cell)索引（index）项（item)连接(join)连接线(join line)锁定的字段或记录（locked field or record）图例（legend)图例项标示（legend keys)合并单元格(merged cell）活动选定框(moving border）矩阵（matrix)移动平均（moving average)映射范围(mapped range）操作数（operand)分级显示(outline)分级显示符号（outline symbols）分级显示数据（outline data)脱机多维数据集文件（offline cube file）外部连接（outer join）运算符（operator）磅（point)保护(protect)报表筛选（reporter filter）参数parameter参数查询parameter query打印标题print totles打印区域print area分页符page break分页预览page break preview绘图区plot area密码password数据透视表PivotTable report数据透视表分类汇总PivotTable sobtotal数据透视表列表PivotTable list数据透视表数据PivotTable data数据透视表总计PivotTable grand totals数据透视图报表Pivotchart report数据透视图分类字段Pivotchart category field 数据透视图系列字段Pivotchart series field透视区域pivot area引用单元格precedents粘贴区域paste area主键primary key属性字段property fields查询queryExcel函数大全数据库和清单管理函数DA VERAGE（daverage）返回选定数据库项的平均值DCOUNT(dcount）记算数据库中包含数字的单元格的个数DCOUNTA （dcounta）记算数据库中非空单元格的个数DGET （dget) 从数据库中提取满足指定条件的单个记录DMAX (dmax）返回选定数据库项中的最大值DMIN （dmin）返回选定数据库项中的最小值DPRODUCT （dproduct）乘以特定字段（此字段中的记录为数据库中满足指定条件的记录）中的值DSTDEV (dstdev）根据数据库中选定项的示例估算标准偏差DSTDEVP （dstdevp) 根据数据库中选定项的样本总体计算标准偏差DSUM (dsum）对数据库中满足条件的记录的字段列中的数字求和DV AR (dvar）根据数据库中选定项的示例估算方差DV ARP （dvarp）根据数据库中选定项的样本总体计算方差GETPIVOTDATA(getpivotdata）返回存储在数据透视表中的数据日期和时间函数DATE (date）返回特定时间的系列数DATEDIF （datedif）计算两个日期之间的年、月、日数DATEV ALUE (datevalue) 将文本格式的日期转换为系列数DAY（day) 将系列数转换为月份中的日DAYS360 (days360）按每年360天计算两个日期之间的天数EDATE （edate）返回在开始日期之前或之后指定月数的某个日期的系列数EOMONTH (eomonth)返回指定月份数之前或之后某月的最后一天的系列数HOUR (hour）将系列数转换为小时MINITE （minite）将系列数转换为分钟MONTH （month）将系列数转换为月NETWORKDAYS (networkdays)返回两个日期之间的完整工作日数NOW （now)返回当前日期和时间的系列数SECOND （second）将系列数转换为秒TIME (time)返回特定时间的系列数TIMEV ALUE (timevalue)将文本格式的时间转换为系列数TODAY （today）返回当天日期的系列数WEEKDAY (weekday）将系列数转换为星期WORKDAY (workday）返回指定工作日数之前或之后某日期的系列数YEAR(year)将系列数转换为年YEARFRAC(yearfrac)（返回代表START_DATE（开始日期）和END_DATE（结束日期）之间天数的以年为单位的分数DDE 和外部函数CALL(call）调用动态链接库（DLL）或代码源中的过程REGISTER。
中英文财务报表对照.
中英文财务报表对照摘自《首席财务官》 2008年12月11日一、企业财务会计报表封面 FINANCIAL REPORT COVER报表所属期间之期末时间点 Period Ended所属月份 Reporting Period报出日期 Submit Date记账本位币币种 Local Reporting Currency审核人 Verifier填表人 Preparer二、资产负债表 Balance Sheet资产 Assets流动资产 Current Assets货币资金 Bank and Cash短期投资 Current Investment一年内到期委托贷款 Entrusted loan receivable due within one year减：一年内到期委托贷款减值准备 Less: Impairment for Entrusted loan receivable due within one year 减：短期投资跌价准备 Less: Impairment for current investment短期投资净额 Net bal of current investment应收票据 Notes receivable应收股利 Dividend receivable应收利息 Interest receivable应收账款 Account receivable减：应收账款坏账准备 Less: Bad debt provision for Account receivable应收账款净额 Net bal of Account receivable其他应收款 Other receivable减：其他应收款坏账准备 Less: Bad debt provision for Other receivable其他应收款净额 Net bal of Other receivable预付账款 Prepayment应收补贴款 Subsidy receivable存货 Inventory减：存货跌价准备 Less: Provision for Inventory存货净额 Net bal of Inventory已完工尚未结算款 Amount due from customer for contract work待摊费用 Deferred Expense一年内到期的长期债权投资 Long-term debt investment due within one year 一年内到期的应收融资租赁款 Finance lease receivables due within one year 其他流动资产 Other current assets流动资产合计 Total current assets长期投资 Long-term investment长期股权投资 Long-term equity investment委托贷款 Entrusted loan receivable长期债权投资 Long-term debt investment长期投资合计 Total for long-term investment减：长期股权投资减值准备 Less: Impairment for long-term equity investment 减：长期债权投资减值准备 Less: Impairment for long-term debt investment 减：委托贷款减值准备 Less: Provision for entrusted loan receivable长期投资净额 Net bal of long-term investment其中：合并价差 Include: Goodwill (Negative goodwill)固定资产 Fixed assets固定资产原值 Cost减：累计折旧 Less: Accumulated Depreciation固定资产净值 Net bal减：固定资产减值准备 Less: Impairment for fixed assets固定资产净额 NBV of fixed assets工程物资 Material holds for construction of fixed assets在建工程 Construction in progress减：在建工程减值准备 Less: Impairment for construction in progress在建工程净额 Net bal of construction in progress固定资产清理 Fixed assets to be disposed of固定资产合计 Total fixed assets无形资产及其他资产 Other assets & Intangible assets无形资产 Intangible assets减：无形资产减值准备 Less: Impairment for intangible assets无形资产净额 Net bal of intangible assets长期待摊费用 Long-term deferred expense融资租赁——未担保余值 Finance lease – Unguaranteed residual values 融资租赁——应收融资租赁款 Finance lease – Receivables其他长期资产 Other non-current assets无形及其他长期资产合计 Total other assets & intangible assets递延税项 Deferred Tax递延税款借项 Deferred Tax assets资产总计 Total assets负债及所有者(或股东)权益 Liability & Equity流动负债 Current liability短期借款 Short-term loans应付票据 Notes payable应付账款 Accounts payable已结算尚未完工款预收账款 Advance from customers应付工资 Payroll payable应付福利费 Welfare payable应付股利 Dividend payable应交税金 Taxes payable其他应交款 Other fees payable其他应付款 Other payable预提费用 Accrued Expense预计负债 Provision递延收益 Deferred Revenue一年内到期的长期负债 Long-term liability due within one year 其他流动负债 Other current liability流动负债合计 Total current liability长期负债 Long-term liability长期借款 Long-term loans应付债券 Bonds payable长期应付款 Long-term payable专项应付款 Grants & Subsidies received其他长期负债 Other long-term liability长期负债合计 Total long-term liability递延税项 Deferred Tax递延税款贷项 Deferred Tax liabilities负债合计 Total liability少数股东权益 Minority interests所有者权益(或股东权益) Owners’ Equity实收资本(或股本) Paid in capital减;已归还投资 Less: Capital redemption实收资本(或股本)净额 Net bal of Paid in capital资本公积 Capital Reserves盈余公积 Surplus Reserves其中：法定公益金 Include: Statutory reserves未确认投资损失 Unrealised investment losses未分配利润 Retained profits after appropriation其中：本年利润 Include: Profits for the year外币报表折算差额 Translation reserve所有者(或股东)权益合计 Total Equity负债及所有者(或股东)权益合计 Total Liability & Equity三、利润及利润分配表 Income statement and profit appropriation一、主营业务收入 Revenue减：主营业务成本 Less: Cost of Sales主营业务税金及附加 Sales Tax二、主营业务利润(亏损以“—”填列) Gross Profit ( - means loss)加：其他业务收入 Add: Other operating income减：其他业务支出 Less: Other operating expense减：营业费用 Selling & Distribution expense管理费用 G&A expense财务费用 Finance expense三、营业利润(亏损以“—”填列) Profit from operation ( - means loss)加：投资收益(亏损以“—”填列) Add: Investment income补贴收入 Subsidy Income营业外收入 Non-operating income减：营业外支出 Less: Non-operating expense四、利润总额(亏损总额以“—”填列) Profit before Tax减：所得税 Less: Income tax少数股东损益 Minority interest加：未确认投资损失 Add: Unrealised investment losses五、净利润(净亏损以“—”填列) Net profit ( - means loss)加：年初未分配利润 Add: Retained profits其他转入 Other transfer-in六、可供分配的利润 Profit available for distribution( - means loss)减：提取法定盈余公积 Less: Appropriation of statutory surplus reserves提取法定公益金 Appropriation of statutory welfare fund提取职工奖励及福利基金 Appropriation of staff incentive and welfare fund提取储备基金 Appropriation of reserve fund提取企业发展基金 Appropriation of enterprise expansion fund利润归还投资 Capital redemption七、可供投资者分配的利润 Profit available for owners distribution减：应付优先股股利 Less: Appropriation of preference shares dividend提取任意盈余公积 Appropriation of discretionary surplus reserve应付普通股股利 Appropriation of ordinary shares dividend转作资本(或股本)的普通股股利 Transfer from ordinary shares dividend to paid in capital 八、未分配利润 Retained profit after appropriation补充资料： Supplementary Information:1. 出售、处置部门或被投资单位收益 Gains on disposal of operating divisions or investments2. 自然灾害发生损失 Losses from natural disaster3. 会计政策变更增加(或减少)利润总额 Increase (decrease) in profit due to changes in accounting policies4. 会计估计变更增加(或减少)利润总额 Increase (decrease) in profit due to changes in accounting estimates5. 债务重组损失 Losses from debt restructuring中英文对照利润表利润表Income Statement编制单位：年月Prepared by: Month: year: Monetary unit: RMB yuan项目行次本月数本年累计数Item Line No ．Current month Current year cumulative一、主营业务收1 Ⅰ ． Revenue from main operations减：主营业各成本4 Less ： Cost of main operations主营业务税金及附加5 Taxes and surcharge for main operations二、主营业务利润 ( 亏损以“ - ”号填列 )10 Ⅱ． Profit/Loss from main operations加：其他业务利润 ( 亏损以“ - ”号填列 ) 11Add ： Profit/Loss from other operations减：营业费用14 Less ： Operating expenses管理费用15 General and administrative expenses财务费用16 Financial expenses三、营业利润 (( 亏损以“ - ”号填列 )18 Ⅲ． Operating profit/loss加：投资收益 ( 亏损以“ - ”号填列 )19 Add ： Investment income/losses补贴收入22 Revenue from subsidies营业外收入23 Non-operating revenue减：营业外支出25 Less ： Non-operating expenditures四、利润总额 ( 亏损以“ - ”号填列 )27 Ⅳ． Income/Loss before tax减：所得税28 Less ： Income tax五、净利润 ( 亏损以“ - ”号填列 )30 V ． Net income/loss补充资料 Supplementary information:项目本年累计数上年实际数Item Current yearcumulativePrior year actual1．出售、处置部门或被投资单位所得收益Gain on sale and disposal of a department or an invested enterprise 2 ．自然灾害发生的损失Losses arising from natural disasters3. 会计政策变更增加 ( 或减少 ) 利润总额Increase ／ decrease in income before tax due to a change in accounting policy4. 会计估计变更增加 ( 或减少 ) 利润总额Increase/decrease in income before tax due to a change in accounting estimate5 ．债务重组损失Losses arising from debt restructurings6 ．其他Others。
电缆常用中英文对照
一、 COLOR TYPE〈颜色类>Black<黑色> Brown〈棕色> Yellow〈黄色> Green〈绿色>White<白色〉 Gray/Grey<灰色> Red〈红色> Orange<橙色>Blue<蓝色〉 Pink<粉红色〉 Purple/Violet〈紫色>Beige<贝吉色> Ivory<象牙色〉 Frost White〈霜白〉 Light Green<浅绿色〉二、Month Type<月份类〉January 一月 February 二月 March 三月April 四月 May 五月 June 六月July 七月 August 八月 September 九月October 十月 November 十一月 December 十二月三、Week Type〈星期类〉Monday星期一 Tuesday星期二 Wednesday星期三Thursday星期四 Friday星期五 Saturday星期六Sunday星期日铜包铝镁英文全称：Copper clad aluminum magnesium wire四、Length Type〈长度类〉1foot<英尺>=12inches〈英寸>=0.3048meter〈米〉1yard〈码>=3feet〈英尺〉=0。
9144meter<米〉1mile〈英里>=1760yards〈码>=1。
609kilometers<千米>1meter<米〉=10dm<分米〉=1.0936yards〈码〉=3.2808〈英尺〉1centimeter<厘米>=10mm<亳米>=0。
3937inch<英寸>五、Cable Type〈电线类〉Cable<电缆线> Jacket<外被> Conductor〈导体/芯线〉 Braid〈编织〉 Spiral〈缠绕> Drain Wire〈地线〉 Al—Foil/Mylar<铝箔/麦拉> Paper〈包纸〉 P-P-Foamed〈发泡P.P> Paper + Braid〈包纸+编织〉 Paper + Spiral<包纸+缠绕〉 Matted〈雾面〉 Slot〈直条文>Smooth<光滑面> Tape〈包带> Al-Mylar + Braid〈铝箔麦拉+编织〉 Coaxial〈同轴线〉Aluminum Foil〈铝箔> Foamed PP + AL-Mylar +Braid<发泡pp+铝箔/唛拉+编织>Jump Wire〈跳线〉 Insulator〈绝缘> Tissue Paper〈棉纸〉 Impedance〈特性阻抗> Overall〈总隔离> Contact Resistance〈导通阻抗〉 Insulance<绝缘阻抗> Dupont〈小杜邦〉Non migration〈非移性〉 Flexible〈柔软〉 Filler〈填充物〉 Color Chip〈色板〉Dentation〈齿状> Insulator Color<胶芯颜色〉 Shield〈隔离> Spiral Shield〈缠绕隔离〉Twisted〈对绞〉 ABS Non—Migration Twisted Pairs<对绞线>Round Cable<圆线> A.W.G美国线规 S.W.G<英国线规>U.L〈美国认证〉 C.S.A<加拿大认证〉 J。
分享：外贸中英文词汇对照表
外贸中英文词汇对照表Shipping Marks 箱唛Style No. 款号C/no. 箱号Invoice 发票Quantity(QTY) 数量Country 国家Origin 起源Goods 货物Packing list 装箱单Size 尺寸（大小）Color 颜色Total 合计Vessel 船名From 从...To 到...Measurement / Dimensions 尺寸Supplier 供货商Company 公司Summary 摘要Breakdown 明细Assortment 分类Per 每，每一Unit 单位CBM 立方Vendor 卖主Contract No. 合同号Market 市场Remarks 备注Item No. 项号Knitted 针织Garment衣服Manufacturer 厂商Destination 目的地Date 日期Address 地址Information 消息Final 最终Order No. 订单号Detail 详情Retail 零售Season 季节Licence 许可证Delivery交货Quality 品质Specifications 规格Descifications 说明Standard；Type 标准Catalogue 商品目录Pamphlet 宣传小册Literature 说明书Leaflet 宣传单页Article No.（Art.No.）货号Sample 样品Representative Sample 代表性样品Original Sample 原样Duplicate Sample 复样Counter-Sample 对等样品Reference Sample 参考样品Sealed Sample 封样Brand 牌号Trade Mark 商标Fair Average Quality（F.A.Q.）大路货（良好平均质量）Grade 等级Assortment 花色（搭配）Tolerance 公差5% more or less 5%上下5% Plus or minus 5% 增减5% Plus or minus ±5%5% maximum(max.) 5%最高5% maximum(max.) 5%高大5% maximum(max.) 5%最多5% minimum(min.) 5%最低5% minimum(min.) 5%最小5% minimum(min.) 5%最少Range 幅度Quantity数量Weight 重量Number 个数Area 面积Length 长度Capacity 容积V olume 体积Gross Weight 毛重Net Weight 净重Gross for Net 毛作凈Tare 皮重Actual Tare 实际重量Quantity Tolerance 数量公差More or Less Clause 溢短装条款About；Appr；Approximately；Circa 约；大约Package 件Piece 个Piece 只Case；Chest；Carton 箱Piece 匹Bale(Bales) 包Drum；Barrel；Cask(Casks)；Keg 桶Bag；Sack(Sacks) 袋Bundle 捆Basket 篓Basket 筐Jar 甏Pair 双Dozen 打Gross 罗Great Gross 大罗Sheet 张Ream 令Roll 卷Box 合Tin；Can 听Tin；Can 罐Bottle 瓶Packing 包装Bulk Cargo 散装货Nude Cargo 裸装货Packed Cargo 包装货Outer Packing 外包装Inner Packing 内包装Small Packing 小包装Immediate Packing 直接包装Packed in Cases 箱装Wooden Case 木箱Plywood Case 三夹板箱Fibre Board Case纤维板箱Crate；Skeleton Case 板条箱Carton；Cardboard Case 纸板箱Packed in Drums 桶装Iron Drum 铁桶Wooden Keg 小木桶Wooden Barrel 木桶Plywood keg 三夹板桶Packed in cloth-bales 布包装Machine Press-packed Bale 机器紧压包、机包Packed in Bags 袋装Gunny Bay；Jute Bag 麻袋Cloth Bag 布袋Kraft Paper Bag 牛皮纸袋Plastic Bag 塑料袋Polythene Bag 聚乙烯袋Cardboard Box 纸板盒Corrugated Paper Box 瓦楞板盒Kraft Paper 牛皮纸Cellophane 玻璃纸Tarred Paper 柏油纸Oiled Paper 油纸Filling and Lining Material 衬垫物Excelsior 木丝Paper Wool 纸条Straw 稻草Saw Dust 木屑Paper Scrap 纸屑Packing Suitable for ocean transportation 适合海洋运输的包装Usual Packing；Customary Packing 习惯包装Price 价格Trade Term(Price Term) 价格术语（价格条件）Unit Price 单价Total Value 总值Amount(Total Amount) 金额（总金额）Net Price 凈价Commission 佣金Price including Commission 含佣价Return Commission 回佣Discount，Allowance 折扣FOB--Free on Board 离岸价（船上交货价）C&F--Cost and Freight 成本加运费价（离岸加运费价）CIF--Cost，Insureance and freight到岸价（成本加运费、保险费价）Feight 运费Port of shipment；Port of loading 装运港Port of discharge 卸货港Port of destination 目的港Wholesale Price 批发价Retail Price 零售价Spot Price 现货价格Forward Price 期货价格Current Price；Prevailing Price 现行价格（时价）World(International)Market Price 国际市场价格Wharfage 码头费Landing Charges 卸货费（起货费）Customs Duty 关税Stanp Duty 印花税Port Dues；Harbour Dues 港口税Import Licence 进口许可证Export Licence 出口许可证Delivery交货Shipment 装运、装船Time of delivery 交货时间Time of shipment 装运期限Shipper；Consignor 托运人neutral packing 中性包装customary packing 习惯包装cargo in bulk 散装货nuded cargo 裸装货shipment packing 运输包装consumer packing 消费包装packaging industry 包装工业pack test 包装试验package design 包装设计package engineering 打包工程package in damaged condition 破损包装package materials (packing supplies) 包装材料packing cost 包装成本"packing extra" 包装费用另计packing and presentation 包装装潢及外观packing credit 打包放款，包装信用证packing letter of credit 包装信用证，红条标信用证packing list/note/slip 装箱单packing specification 包装标准化seller's usual packing 卖方习惯包装seaworthy packing 适合海运包装case 箱carton 纸板箱，纸箱wooden case 木箱crate 板条箱chest 箱casket 小箱box 盒子cask 桶keg 小桶wooden cask 木桶barrel 琵琶桶drum 圆桶iron drum 铁桶to be packed in bag 用袋装to be packed in paper bag 用纸袋装gunny bag 麻袋plastic bag 塑料袋foam plastic bag 泡沫塑料袋balse 包件canvas 帆布bundle 捆，束can/tin 罐装，听装coil 捆，盘装glass jar 玻璃瓶装container 集装箱pallet 托盘breakage-proof 防破损shakeproof 防震leakage-proof 防漏water-proof 防水sound-proof 隔音metal strap 铁箍Consignee 收货人Shipping Space 舱位Clearance of goods 报关to take delivery of goods 提货Shipment during January / January shipment 一月份装船Shipment not later than Jan.31st / Shipment on or before Jan.31st 一月底装船Shipment during Jan./Feb. / Jan./feb. Shipment 一/二月份装船...Shipment during...in two lots 在...（时间）分两批装船...Shipment during...in two equal lots 在...（时间）平均分两批装船in three monthly shipments 分三个月装运in three equal monthly shipments 分三个月，每月平均装运Immediate shipment 立即装运Prompt shipment 即期装运Shipment within 30 days after receipt of L/C 收到信用证后30天内装运Partial shipment allowed(permitted/acceptable) 允许分批装船Partial shipment not allowed(permitted) / unacceptable 不允许分批装船Optional Port 选择港（任意港）Optional Charges 选港费Optional Charges to be borne by the Buyers / Optional Charges for Byuers' account 先港费由买方负担Steamship(S.S) 轮船Charter(the Chartered Ship) 租船V oyage Charter；Trip Charter 定程租船Time Charter 定期租船Regular shipping liner(Liner) 班轮Lighter 驳船Tanker 油轮Cargo Receipt 陆运收据Air Waybill 空运提单Original Bills of Lading(B/L) 正本提单Payment支付Letter of Credit (L/C) 信用证Documentary L/C 跟单信用证Draft / Bill of Exchange 汇票Shipping Documents 货运单证Clean L/C 光票信用证Revocable L/C 可撤销信用证Irrevocable L/C 不可撤销信用证Confirmed L/C 保兑信用证Unconfirmed L/C 不保兑信用证Sight L/C 即期信用证Usance L/C 远期信用证Transferable L/C 可转让信用证Revolving L/C 循环信用证Amendment of L/C 修改信用证Margin 保证金（押金）Negotiation 议付Settlement of Exchange 结汇Collection 托收Documents against payment(D/P) 付款交单Documents against Acceptance (D/A) 承兑交单D/P at sight 即期付款交单D/P at days sight 见票后XX天付款交单D/A at XX days sight XX天承兑交单Payment in advance 预付货款Endorsement 背书Endorsement in blank 空白背书Drawer 出票人Endorser 背书人Drawee 付款人Payee 受款人Holder 持票人Beneficiary 受益人Accountee (for account of XXX) 申请开证人Foreign Exchange 外汇Foreign Currency 外币Rate of Payment 汇率Direct Quotation 国际收支Indirect Quotation 直接收支Buying Rate 间接标价Selling Rate 买入汇率Gold Standard 金本位制度Mint Par 铸币平价Gold Standard 黄金输送点Paper Money System 纸币制度Gold Parity 金平价Inflation 通货膨胀Fixed Rate 固定汇率Official Upper and Lower Limits of Fluctuation 汇率波动的官定上下限Gold and Foreign Exchange Reserve 黄金外汇储备International Monetary Fund 国际货币基金Devaluation 法定贬值Revaluation 法定升值Floating Rate 浮动汇率HardCurrency 硬通货Soft Currency 软通货Business Negotiation 交易磋商Business Discussion 业务洽谈Inquiry；Enquiry 询盘（词价）Offer 发盘（发价）Firm Offer 实盘Offer Firm 发实盘Time of validity 有效期限Subject to replyXX 限XX复Subject to reply reaching here XX 限XX复到Valid tillXX 有效至XXCable reply 电复Reply immediately 速复General Terms and Conditions 一般交易条件Usual practice 习惯做法Bid；Bidding 递盘Bid firm 递实盘Book；Booking 订货；订购Order；Ordering 定货；定购Subject to our final confirmation 需经我方最后确认Subject to seller's confirmation 需经卖方确认Without engagement 不受约束Subject to prior sale 以未售出为准Reference Price 参考价Price indication 指示性价格Quotation；Quote 报价Counter-offer 还盘（还价）Acceptance；accept 接受Contirmation；Confirm 确认Sales Contract 销售合同Sales Confirmation 销售确认书Purchase Contract 购货合同Purchase Confirmation 购货确认书Indent 订单Order 定单XX Commodity Inspection Bureau (X.C.I.B) XX商品检验局Inspection Certificate 质量、重量检验证书Inspection Certificate of Quality 质量检验证书Inspection Certificate of Weight(Quantity) 重量检验证书Certificate of Origin 产地证明书Claim 索赔Disputes 争议Penalty 罚金条款Discrepency and Claim clause 异议与索赔条款Force Majeure 不可抗力Arbitration 仲裁Foreigh Trade Artitration Commission of the China 中国国际贸易促进委员会Council for the Promotion of International Trade 对外贸易仲裁委员会Arbitral Tribunal 仲裁庭Aword 裁决Exclusive right 独家经营权Exclusive right 独家专营权Exclusivity Agreement 独家经营协议Exclusivity Agreement 独家包销协议Exclusivity Agreement 独家代理协议Agency 代理Sole Agency；Exclusive Agency 独家代理Agency Agreement 代理协议General Agent 总代理人Agent 一般代理人Cormmission Agent 佣金代理人Cormmission Merchant 佣金商Middleman 中间人Broker 掮客Accumulative Commission 累计佣金Quantity Discount 数量折扣Trade Discount 商业折扣The Chinese Export Commodities Fair 中国出口商品交易会Guangzhou Export Commodities Fair 广州出口商品交易会Kwangchou Export Commodities Fair 广州出口商品交易会Guangzhou Fair 广交会Kwangchou Fair 广交会Consignment 寄售Auction 拍卖Invitation to Tender 招标Tender 投标Submission of Tender投标Compensation Trade (Compensatory Trade / Counter Trade) 补偿贸易（抵偿贸易/ 往返贸易）Compensation Agreement 补偿协定Processing on Giving Materials 来料加工Assembling on Provided Parts 来料装配International Trade 国际贸易Foreign Trade 对外贸易Import 进口Export 出口Favorable Balance of Trade 贸易顺差Unfavorable Balance of Trade 贸易逆差Value of Foreign Trade 对外交易值Value of International Trade 国际贸易值Quantum of International Trade 国际贸易量Free Port 自由港Free Trade Zone 自由贸易区Bonded Warehouse 保税仓库Customs Duties 关税General Agerrment on Tariff and Trade-GATT 关税与贸易总协议Import Duties 进口税Export Duties 出口税Special Preferences 优惠关税Generalized System of Preferences-GSP 普遍优惠制Import Quotas 进口配额制Export Credit 出口信贷Export Subsidy 出口津贴Dumping 商品倾销Exchange Dumping 外汇倾销Most-favored Nstion Treatment-MFNT 最惠国待遇kraft paper 牛皮纸flexible container 集装包parcel 小包，一批货packed cargo 包装货parcel post 包裹邮寄packet (pkt.) 包裹，封套，袋single packing 单件包装collective packing 组合包装outer packing 大包装，外包装inner packing 内包装，小包装substantial 坚固的ocean transportation 远洋运输smaller container 小容器polythene 聚乙烯the canned goods 罐装货satin-covered 缎包装的silk ribbon 绸带pack 包装，装罐packing 包装packing charge 包装费用package 包装（指包、捆、束、箱等）；打包packing clause 包装条款packaging 包装方法packing expenses 包装费用ORC (Origen Recevie Charges) 本地收货费用（广东省收取）THC (Terminal Handling Charges) 码头操作费（香港收取）BAF (Bunker Adjustment Factor) 燃油附加费CAF (Currency Adjustment Factor) 货币贬值附加费YAS (Yard Surcharges) 码头附加费EPS (Equipment Position Surcharges) 设备位置附加费DDC (Destination Delivery Charges) 目的港交货费PSS (Peak Season Sucharges) 旺季附加费PCS (Port Congestion Surcharge) 港口拥挤附加费DOC (Document charges) 文件费O/F (Ocean Freight) 海运费B/L (Bill of Lading) 海运提单MB/L(Master Bill of Lading) 船东单MTD (Multimodal Transport Document) 多式联运单据L/C (Letter of Credit) 信用证C/O (Certificate of Origin) 产地证S/C (Sales Confirmation)、（Sales Contract) 销售确认书、销售合同S/O (Shipping Order) 装货指示书W/T (Weight Ton) 重量吨（即货物收费以重量计费）M/T (Measurement Ton) 尺码吨（即货物收费以尺码计费）W/M(Weight or Measurement ton) 即以重量吨或者尺码吨中从高收费CY (Container Yard) 集装箱（货柜）堆场FCL (Full Container Load) 整箱货LCL (Less than Container Load) 拼箱货（散货）CFS (Container Freight Station) 集装箱货运站TEU (Twenty-feet Equivalent Units) 20英尺换算单位（用来计算货柜量的多少）A/W (All Water) 全水路（主要指由美国西岸中转至东岸或内陆点的货物的运输方式）MLB(Mini Land Bridge) 迷你大陆桥（主要指由美国西岸中转至东岸或内陆点的货物的运输方式）NVOCC(Non-Vessel Operating Common Carrier) 无船承运人。
中英文对照版财务报表
一、企业财务会计报表封面 FINANCIAL REPORTCOVER报表所属期间之期末时间点 Period Ended所属月份 Reporting Period报出日期 Submit Date记账本位币币种 Local Reporting Currency审核人 Verifier填表人 Preparer二、资产负债表 Balance Sheet资产 Assets流动资产 Current Assets货币资金 Bank and Cash短期投资 Current Investment一年内到期委托贷款 Entrusted loan receivable due within one year减:一年内到期委托贷款减值准备 Less: Impairment for Entrusted loan receivable due within one year 减:短期投资跌价准备 Less: Impairment for current investment短期投资净额 Net bal of current investment应收票据 Notes receivable应收股利 Dividend receivable应收利息 Interest receivable应收账款 Account receivable减:应收账款坏账准备 Less: Bad debt provision for Account receivable 应收账款净额 Net bal of Account receivable其他应收款 Other receivable减:其他应收款坏账准备 Less: Bad debt provision for Other receivable 其他应收款净额 Net bal of Other receivable预付账款 Prepayment应收补贴款 Subsidy receivable存货 Inventory减:存货跌价准备 Less: Provision for Inventory存货净额 Net bal of Inventory已完工尚未结算款 Amount due from customer for contract work待摊费用 Deferred Expense一年内到期的长期债权投资 Long-term debt investment due within one year一年内到期的应收融资租赁款 Finance lease receivables due within one year其他流动资产 Other current assets流动资产合计 Total current assets长期投资 Long-term investment长期股权投资 Long-term equity investment委托贷款 Entrusted loan receivable长期债权投资 Long-term debt investment。
英文版Excel 中英文对照表
英文版Excel 中英文对照表激活（activate）数组（array）数组公式（array formula）相关联的数据透视表（associated PivotTable report ）自动套用格式(autoformat）坐标轴（asix）基础地址(base address)“合并计算”表（consolidation table)比较条件（comparison criteria）比较运算符（comparison operator）常量（constant）单元格引用(cell reference)当前区域（current region)分类轴（category asix）分类字段（category field)复制区域（copy area)计算列（calculated column）计算项（calculated item）计算字段（数据库）（calculated field)计算字段（数据透视表）（calculated field）列标题（column heading）列字段（column field）条件(criteria)条件窗格（(criteria pane）条件格式（conditional format)图表工作表（chart sheet)图表区(chart area）修订记录(change history）约束条件(constraints）证书验证机构（certifying authority）自定义计算(custom calculation）垂直线（drop lines)从属单元格（dependents）明细数据（detail data)默认工作表模板(default worksheet template)默认工作簿模板（default workbook template)默认启动工作簿（default startup workbook ）目标区域（destination area）数据标签（data label）数据标志（data marker）数据表(data table）数据表单（data form）数据窗格（data pane）数据点(data points）数据库（database)数据区域（data region）数据系列（data series）数据有效性（data validation）数据源（data source）数据源驱动程序(data source driver）图表数据表（data table in charts)下拉列表框（drop-down list box)值区域(values area）值字段(value field）表达式(expression）嵌入图表（embedded chart)外部数据(external data)外部数据区域（external data range)外部引用(external reference）误差线(error bars)编辑栏(formula bar)公式（formula)公式选项板（Formula Palette)函数（function）函数筛选（filter)填充柄（fill handle)字段(数据库)（field)字段（数据透视表)（field)单变量求解（goal seek）图表中的网络线(gridlines charts）组（group）冲突日志工作表（history worksheet）高低点连线(high—low lines)插入行（Insert row)迭代(iteration)绝对交集（implicit intersection）内部连接(inner join）输入单元格（imput cell)索引（index）项（item）连接(join）连接线(join line）锁定的字段或记录（locked field or record）图例（legend)图例项标示（legend keys)合并单元格(merged cell)活动选定框(moving border）矩阵(matrix）移动平均(moving average）映射范围（mapped range）操作数(operand)分级显示（outline)分级显示符号(outline symbols)分级显示数据（outline data)脱机多维数据集文件（offline cube file）外部连接（outer join)运算符(operator）磅（point）保护（protect)报表筛选(reporter filter）参数parameter参数查询parameter query打印标题print totles打印区域print area分页符page break分页预览page break preview绘图区plot area密码password数据透视表PivotTable report数据透视表分类汇总PivotTable sobtotal数据透视表列表PivotTable list数据透视表数据PivotTable data数据透视表总计PivotTable grand totals数据透视图报表Pivotchart report数据透视图分类字段Pivotchart category field数据透视图系列字段Pivotchart series field透视区域pivot area引用单元格precedents粘贴区域paste area主键primary key属性字段property fields查询queryExcel函数大全数据库和清单管理函数DA VERAGE(daverage) 返回选定数据库项的平均值DCOUNT（dcount）记算数据库中包含数字的单元格的个数DCOUNTA （dcounta）记算数据库中非空单元格的个数DGET （dget）从数据库中提取满足指定条件的单个记录DMAX （dmax）返回选定数据库项中的最大值DMIN (dmin）返回选定数据库项中的最小值DPRODUCT (dproduct)乘以特定字段（此字段中的记录为数据库中满足指定条件的记录）中的值DSTDEV （dstdev）根据数据库中选定项的示例估算标准偏差DSTDEVP （dstdevp）根据数据库中选定项的样本总体计算标准偏差DSUM (dsum）对数据库中满足条件的记录的字段列中的数字求和DV AR （dvar）根据数据库中选定项的示例估算方差DV ARP （dvarp）根据数据库中选定项的样本总体计算方差GETPIVOTDATA（getpivotdata）返回存储在数据透视表中的数据日期和时间函数DATE (date）返回特定时间的系列数DATEDIF （datedif）计算两个日期之间的年、月、日数DATEV ALUE (datevalue) 将文本格式的日期转换为系列数DAY(day) 将系列数转换为月份中的日DAYS360 （days360）按每年360天计算两个日期之间的天数EDATE （edate）返回在开始日期之前或之后指定月数的某个日期的系列数EOMONTH (eomonth)返回指定月份数之前或之后某月的最后一天的系列数HOUR （hour)将系列数转换为小时MINITE （minite)将系列数转换为分钟MONTH (month)将系列数转换为月NETWORKDAYS (networkdays）返回两个日期之间的完整工作日数NOW (now)返回当前日期和时间的系列数SECOND (second）将系列数转换为秒TIME (time）返回特定时间的系列数TIMEV ALUE （timevalue）将文本格式的时间转换为系列数TODAY （today）返回当天日期的系列数WEEKDAY （weekday）将系列数转换为星期WORKDAY (workday）返回指定工作日数之前或之后某日期的系列数YEAR（year）将系列数转换为年YEARFRAC(yearfrac)(返回代表START_DATE（开始日期)和END_DATE（结束日期）之间天数的以年为单位的分数DDE 和外部函数CALL(call) 调用动态链接库（DLL)或代码源中的过程REGISTER.ID(register.id）返回已注册的指定DLL或代码源的注册IDSQL。