Cancel-after-verification system with function of automatically calculating carbon emission of employee on business trip and process thereof
By designing a verification system that automatically calculates the carbon emissions of employees' business trips, the problem of inaccurate calculation of corporate emissions on employees in the existing technology is solved, and automatic calculations of land transportation, air transportation and combined with business trips are realized, which improves the accuracy and efficiency of calculations. , support enterprises in achieving carbon reduction goals.
Patent Information
- Application Number
- CN202411021947.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Priority Date
- 2023-08-14
- Filing Date
- 2024-07-29
- Publication Date
- 2025-02-21
AI Technical Summary
The existing technology cannot effectively and automatically calculate the carbon emissions of employees when traveling on business trips, making it difficult for companies to accurately count and reduce the carbon emissions of employees when traveling on business trips, affecting the realization of carbon reduction goals.
A verification system with automatic calculation of carbon emissions for employees' business trips is designed, including input unit, comparison calculation unit, operation unit, output unit, audit unit and verification unit. The system automatically calculates the value of the business trip carbon emission coefficient comparison module and the automatic calculation module for travel distance, and supports land transportation, air transportation and business trip calculations combined with land transportation and air transportation.
It realizes automatic calculation and verification of employee business trip carbon emissions, improves calculation accuracy and efficiency, helps enterprises quickly and conveniently calculate employee business trip carbon emissions and write off business trip funds, and enhances the realization of carbon reduction goals. ability.
Smart Images

Figure CN119494738A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to a write-off system and a process thereof, and in particular to a write-off system and a process thereof with a function of automatically calculating carbon emissions of employees on business trips. Background Art
[0003] Traditional employee travel reimbursement application process, such as Figure 1 As shown, first, an input unit 91 inputs the employee's business trip reimbursement application form 911 and business trip document 912, and an output unit 92 outputs the employee's business trip reimbursement expense report 921, followed by an audit unit 93 for supervisor review 931, and then a reimbursement unit 94 for accounting reimbursement 941.
[0004] The traditional employee application for business trip reimbursement process is only used for employees to apply for and reimburse business trip expenses. However, the problem of global warming is becoming more and more serious, causing changes in the earth's climate and environment, affecting the survival of various organisms on the earth in the future. The problem of global warming is closely related to the carbon emissions generated by humans. Countries around the world are actively calling for the reduction of carbon emissions and formulating various methods. Among the carbon emissions of various types of pollution, the carbon emissions of transportation tools are second only to industrial pollution. Therefore, if the carbon emissions of the transportation tools used by each employee on business trips can be reduced, it will have an effective impact on the reduction of carbon emissions. Therefore, countries around the world are actively calling for the reduction of carbon emissions and formulating various "Carbon Footprint Verification" methods.
[0005] World-class brands such as APPLE have successively required their supply chains to achieve carbon neutrality. The first step to carbon neutrality is carbon inventory, which uses scientific methods that meet international standards to calculate the carbon emissions of various activities operated by the company / organization itself. Although the carbon inventory report only needs to be disclosed once a year, if you want to determine whether the direction of carbon reduction is correct, you should always pay attention to the status of carbon emissions. If the digital and automated system tools of carbon inventory can be further developed to conduct carbon emission statistics, more accurate, complete and transparent scientific data on greenhouse gas emissions can be obtained more efficiently.
[0006] The three major emission categories of carbon inventory refer to the three major categories of greenhouse gas emissions divided according to the source of greenhouse gas emissions. Category 1 refers to direct emissions from processes or facilities; Category 2 refers to indirect emissions from energy use such as purchased electricity, heat or steam; Category 3 refers to emissions from emission sources that are not owned or controlled by the company, such as other indirect emissions caused by leasing, outsourcing, employee commuting and employee business trips.
[0007] When most companies conduct annual greenhouse gas inventory, they focus only on Scope 1 and Scope 2 greenhouse gases. Many companies ignore Scope 3 carbon inventory. However, many industries emit the most carbon in Scope 3, such as manufacturing and service industries. The more upstream and downstream supply chains, or frequent transportation, employee commuting and business trips, the more difficult it is to accurately calculate and control Scope 3 greenhouse gas emissions.
[0008] Although each company currently has a traditional employee travel reimbursement process (such as Figure 1 ), but it is limited to the business trip expense report and accounting write-off. For the statistics of employees' business trip carbon emissions, the company must manually collect the employees' business trip transportation documents (such as land transportation tickets, air tickets or gas invoices) for each trip of the year and roughly calculate the corresponding carbon emissions. Because the country, region or city of each employee's business trip is different due to the mission, and the means of transportation they take are also different (such as high-speed rail, Taiwan Railway, driving or taking a taxi), the manual collection of statistics and preparation of relevant supporting materials are quite cumbersome and time-consuming. At present, there is no digital system that can simultaneously integrate carbon emissions for employees to apply for business trip reimbursement to conduct employee business trip carbon inventory. Enterprises are unable to formulate incentives and rewards for employees to reduce carbon emissions during business trips, resulting in the call for employees to reduce carbon emissions during business trips being implemented ineffectively within the company.
[0009] Taiwan Utility Model Patent No. M639863, “Carbon Emission Management Device for Travel Expenses”, is signal-connected to a user device belonging to at least one user, and provides a receiving device for claiming travel expenses transmitted by the user device. The carbon emission management device for travel expenses includes: an application module, signal-connected to the user device, for providing a claiming interface to the user device according to the claiming application for travel expenses, wherein after the user fills in relevant data in the claiming interface through the user device, the application module generates a claiming information for travel expenses; a classification module, signal-connected to the application module, for classifying the claiming information for travel expenses according to a classification standard, and generating travel classification information; a data collection module, signal-connected to the classification module, storing at least one map information, for comparing the map information according to the travel classification information, and integrating to generate a route and transportation tool information; and a carbon emission calculation module, signal-connected to the data collection module, for calculating the route and transportation tool information according to a carbon emission conversion standard, and generating a travel carbon emission information.
[0010] However, the above-mentioned prior art carbon emission management device has the following disadvantages:
[0011] 1. It is only applicable to the carbon emission calculation of employees' land transportation type errands, and cannot be applied to the carbon emission calculation of employees' air transportation type errands, and has the problems of poor applicability and practicality.
[0012] 2. Its carbon emission calculation module calculates the route and transportation information based on a carbon emission conversion benchmark, and therefore still relies on manual comparison and calculation, or signal connection to an external carbon emission calculation tool, wherein the route and transportation information still relies on manual input into the external carbon emission calculation tool to calculate the carbon emission coefficient of the transportation tool, which is quite troublesome, inconvenient, labor-consuming and time-consuming to use.
[0013] 3. Its data collection module stores at least one map information and compares the map information according to the attendance classification information. However, it does not clearly disclose how to automatically calculate the distance between the two places of attendance and the means of transportation. Summary of the invention
[0014] The present invention provides a verification system with a function of automatically calculating carbon emissions of employees on business trips and a process thereof. The verification system with a function of automatically calculating carbon emissions of employees on business trips comprises: an input unit for inputting data of a business trip verification application form and a business trip document, wherein the business trip document comprises a land transportation business trip document or / and an air transportation business trip document; a comparison and calculation unit, linked to the input unit, comprising a vehicle carbon emission coefficient comparison module and a business trip distance automatic calculation module, wherein the vehicle carbon emission coefficient comparison module comprises a vehicle per extended distance carbon emission coefficient comparison module (for example, per extended kilometer or per extended mile, depending on the unit used in the country of the business trip), wherein the vehicle per extended distance carbon emission coefficient comparison module is used to compare and obtain the carbon emission coefficient information of the vehicle per extended distance of the business trip, wherein the business trip distance automatic calculation module is an external program, and the input unit is linked to the business trip distance automatic calculation module through a network interface setting, thereby automatically calculating the distance information of two places of the business trip (for example, kilometers or miles); and a calculation unit, linked to the input unit and the comparison and calculation unit. The business trip document is used to calculate a business trip expense and a business trip carbon emission value, wherein the business trip expense includes a business trip land transportation expense and / or a business trip air transportation expense, and the business trip carbon emission value includes a business trip land transportation carbon emission value and / or a business trip air transportation carbon emission value, wherein the business trip land transportation carbon emission value is calculated by calculating the carbon emission coefficient information of each extended distance of the business trip vehicle and the distance information of the two places of the business trip, and the business trip air transportation carbon emission value is calculated by connecting to the carbon emission calculation module of the external airline through the network; an output unit is connected to the calculation unit A meta-link is used to generate a business trip reimbursement report based on the calculated land transportation expenses and / or the air transportation expenses, and to generate a business trip carbon emission report based on the calculated land transportation carbon emission value and / or the air transportation carbon emission value; an audit unit includes a supervisor audit and a carbon emission audit, the supervisor audit audits the business trip reimbursement report, and the carbon emission audit audits the business trip carbon emission report; and a write-off unit includes an accounting write-off, and the accounting write-off performs fund write-off based on the business trip reimbursement report.
[0015] The use process of the verification system with the function of automatically calculating the carbon emissions of employees on business trips includes the following steps: (a1) an input step, in which the business trip verification application form data and the land transportation business trip documents are input by the input unit; (a2) a transportation vehicle carbon emission coefficient comparison step, in which the business trip country or region, energy type and transportation vehicle input by the business trip verification application form data and the land transportation business trip documents are compared with the carbon emission coefficient information of each extended distance of the transportation vehicle through the transportation vehicle carbon emission coefficient comparison module according to the transportation vehicle carbon emission coefficient database of various countries; (a3) a step of automatically calculating the business trip distance, in which the business trip verification application form data and the land transportation business trip documents are input by the business trip verification application form data and the land transportation business trip documents. The departure place, destination and means of transportation input by the data and the land transportation business trip document are automatically calculated by the automatic calculation module of the business trip distance through the network link; (a4) a calculation step, a business trip land transportation fee is calculated by the calculation unit according to the land transportation business trip document, and a business trip land transportation carbon emission value is calculated by the calculation unit according to the compared carbon emission coefficient information of each extended distance of the business trip vehicle and the automatically calculated distance between the two places of the business trip; (a5) an output step, the output unit generates a business trip write-off report according to the above-mentioned business trip land transportation fee, and generates a business trip carbon emission report according to the above-mentioned business trip land transportation carbon emission value.
[0016] The use process of the verification system with the function of automatically calculating the carbon emissions of employees on business trips includes the following steps: (b1) an input step, in which the business trip verification application form data and the land transportation business trip documents are input by the input unit; (b2) a transportation vehicle carbon emission coefficient comparison step, in which the business trip country or region, energy type and transportation vehicle input by the business trip verification application form data and the land transportation business trip documents are compared with the carbon emission coefficient per energy unit of the transportation vehicle energy type through the carbon emission coefficient comparison module according to the transportation vehicle carbon emission coefficient database of various countries. (b3) a calculation step, in which a business trip land transportation fee is calculated by a calculation unit based on the land transportation business trip receipt, and a business trip land transportation carbon emission value is calculated by a calculation unit based on the compared carbon emission coefficient information per energy measurement unit of the business trip vehicle and the total energy of the land transportation business trip receipt; (b4) an output step, in which an output unit generates a business trip write-off report based on the above-mentioned business trip land transportation fee, and generates a business trip carbon emission report based on the above-mentioned business trip land transportation carbon emission value.
[0017] The use process of the verification system with the function of automatically calculating the carbon emissions of employees on business trips includes the following steps: (c1) an input step, in which the business trip verification application form data and air travel documents are input by the input unit; (c2) a calculation step, in which the business trip air transportation expenses are calculated by the calculation unit based on the air travel documents, and based on the business trip verification application form data and the air travel documents, the airline, flight, departure airport, relay airport, landing airport, cabin class and flight category input by the air travel documents, the calculation unit network is connected to the external airline carbon emission calculation module for calculation, and a business trip air transportation carbon emission value is calculated; (c3) an output step, in which the output unit generates a business trip verification report based on the above-mentioned business trip air transportation expenses, and generates a business trip carbon emission report based on the above-mentioned business trip air transportation carbon emission value.
[0018] Furthermore, the use process of the verification system with the function of automatically calculating the carbon emissions of employees on business trips includes the following steps: (d1) an input step, in which the business trip verification application form data, land transportation business trip documents and air transportation business trip documents are input by the input unit; (d2) a step of comparing the carbon emission coefficients of transportation vehicles, in which the business trip country or region and transportation input by the business trip verification application form data and the land transportation business trip documents are compared with the carbon emission coefficient information of each extended distance of the transportation vehicle through the carbon emission coefficient comparison module of each extended distance of the transportation vehicle according to the carbon emission coefficient database of each country, or the carbon emission coefficient information of each energy unit of the transportation vehicle is compared with the carbon emission coefficient database of each country through the carbon emission coefficient comparison module of each energy type of the transportation vehicle according to the carbon emission coefficient database of each country; (d3) a step of automatically calculating the business trip distance, in which the departure place, destination and transportation input by the business trip verification application form data and the land transportation business trip documents are automatically calculated by the business trip distance automatic calculation module through the network link; (d4) A calculation step, in which a land transportation fee for a business trip is calculated by a calculation unit based on the land transportation business trip receipt, and an air transportation fee for a business trip is calculated by a calculation unit based on the air transportation business trip receipt. A land transportation carbon emission value for a business trip is calculated by a calculation unit based on the compared carbon emission coefficient information of each extended distance of the business trip vehicle and the automatically calculated distance between the two places of the business trip, or the compared carbon emission coefficient information of each energy measurement unit of the business trip vehicle and the total energy of the land transportation business trip receipt, and a carbon emission value for a business trip air transportation is calculated by connecting to an external airline carbon emission calculation module through a calculation unit network based on the data of the business trip cancellation application form and the information inputted in the air transportation business trip receipt, and the land transportation fee for the business trip is added to the air transportation fee to obtain the business trip fee, and the land transportation carbon emission value for the business trip is added to the air transportation carbon emission value to obtain the business trip carbon emission value; (d5) An output step, in which the output unit generates a business trip cancellation report based on the above-mentioned business trip expenses, and generates a business trip carbon emission report based on the above-mentioned business trip carbon emission value.
[0019] The main purpose of the verification system and its process with the function of automatically calculating the carbon emissions of employees' business trips is that it can be applied to the carbon emissions calculation of employees' land transportation business trips, the carbon emissions calculation of employees' air transportation business trips, and the carbon emissions calculation of employees' combined land and air transportation business trips, so as to achieve improved applicability and practicality.
[0020] Another purpose of the verification system and its process with the function of automatically calculating employee business trip carbon emissions of the present invention is that by inputting the business trip verification application form data and business trip documents, the employee business trip expenses and the employee business trip carbon emissions value can be automatically calculated, which is beneficial for enterprises to quickly and conveniently calculate the employee business trip carbon emissions and verify the business trip expenses at the same time. BRIEF DESCRIPTION OF THE DRAWINGS
[0021] Figure 1 Flowchart for applying for business trip reimbursement for traditional employees.
[0022] Figure 2 It is a schematic diagram of the architecture of the verification system of the present invention which has the function of automatically calculating the carbon emissions of employees on business trips.
[0023] Figure 3 It is a schematic diagram of the business trip write-off application form data of the present invention.
[0024] Figure 4 It is a schematic diagram of the transportation vehicle of the present invention.
[0025] Figure 5 It is a schematic diagram of the land transportation business trip document of the present invention.
[0026] Figure 6 It is a schematic diagram of the air travel document of the present invention.
[0027] Figure 7 It is a schematic diagram of the vehicle carbon emission coefficient comparison module of the present invention.
[0028] Figure 8 It is a schematic diagram of the automatic calculation module of the business trip distance of the present invention.
[0029] Fig. 9 Based on Figure 8 The corresponding Google Maps map diagram generated.
[0030] Fig.10 It is a schematic diagram of the airline carbon emission calculation module of the present invention.
[0031] Fig.11 This is a flow chart of the automatic calculation of carbon emissions and expense write-off for land transportation business trips according to the present invention.
[0032] Fig.12 This is another flow chart of the present invention for automatically calculating carbon emissions and expense write-offs for land transportation business trips.
[0033] Fig.13 This is a flow chart of the automatic calculation of carbon emissions and expense write-off for air travel according to the present invention.
[0034] Fig.14 This is a flow chart of the present invention for automatically calculating carbon emissions and expense write-offs for business trips combining land and air transportation.
[0035] Reference numerals
[0036] 10 Input unit
[0037] 11 Business trip write-off application form data
[0038] 111 Business Travelers
[0039] 112 Purpose of business trip
[0040] 113 Business trip location
[0041] 114 Business trip start and end date
[0042] 115 Transportation
[0043] 12 Business trip documents
[0044] 121 Land transportation business trip documents
[0045] 121a Ticket receipt
[0046] 121b Invoice
[0047] 122 Air Freight Business Trip Documents
[0048] 20 Comparison calculation unit
[0049] 21 Transportation Carbon Emission Coefficient Comparison Module
[0050] 211 Transportation Carbon Emission Coefficient Comparison Module per Person Extended Distance
[0051] 212 Transportation Energy Types Carbon Emission Coefficient Comparison Module for Each Energy Unit
[0052] 22 Automatic calculation module for business trip distance
[0053] 221 Google Maps
[0054] 30 Arithmetic Units
[0055] 31 Business trip expenses
[0056] 311 Business trip land transportation expenses
[0057] 312 Business trip air freight costs
[0058] 32Carbon emissions from business trips
[0059] 321 Carbon emissions from business trips
[0060] 322 Carbon emissions from business trips
[0061] 33 Airline Carbon Emission Calculation Module
[0062] 40 Output Units
[0063] 41 Business trip write-off report
[0064] 42 Business trip carbon emissions report
[0065] 50 audit units
[0066] 51 Supervisor Review
[0067] 52 Carbon Emissions Audit
[0068] 60 write-off units
[0069] 61 Accounting Write-off
[0070] S101 Input Steps
[0071] S102 Steps for comparing carbon emission coefficients of transportation vehicles
[0072] S103 Automatically calculate the difference distance step
[0073] S104 operation steps
[0074] S105 Output Step
[0075] S201 Input Steps
[0076] S202 Steps for comparing carbon emission coefficients of transportation vehicles
[0077] S203 operation steps
[0078] S204 Output Step
[0079] S301 Input Steps
[0080] S302 Operation steps
[0081] S303 Output Step
[0082] S401 Input Steps
[0083] S402 Steps for comparing carbon emission coefficients of transportation vehicles
[0084] S403 Automatically calculate the difference distance step
[0085] S404 operation steps
[0086] S405 Output Steps
[0087] 91 Input Units
[0088] 911 Business Trip Exemption Application Form
[0089] 912 Business trip receipt
[0090] 92 output units
[0091] 921 Business trip expense reimbursement report
[0092] 93 audit units
[0093] 931 Supervisor Review
[0094] 94 write-off units
[0095] 941 Accounting Write-off DETAILED DESCRIPTION
[0096] The following is a further description of the preferred embodiments of the present invention in conjunction with the drawings, so that those skilled in the art who are familiar with the present invention can implement it according to the description of this specification.
[0097] First, see Figures 2 to 10 The present invention provides a verification system with a function of automatically calculating carbon emissions of employees on business trips, comprising: an input unit 10, a comparison and calculation unit 20, a calculation unit 30, an output unit 40, a review unit 50 and a verification unit 60.
[0098] The input unit 10 is used to input the business trip cancellation application form data 11 and the business trip receipt 12. The business trip cancellation application form data 11 includes the business trip personnel 111, the business trip purpose 112, the business trip location 113 (including the country or region, the departure place, and the destination), the business trip start and end dates 114, and the transportation 115. The transportation 115 includes aircraft, high-speed rail, train, MRT, long-distance bus, bus, gasoline car, taxi, diesel car, hybrid car and electric car. The business trip receipt 12 includes a land transportation business trip receipt 121 and / or an air transportation business trip receipt 122. The land business trip document 121 includes a ticket document 121a and an invoice document 121b. The ticket document 121a includes the date, means of transportation, departure place, destination and ticket price. The invoice document 121b includes the date, energy type (such as gasoline, diesel or charging), total energy (such as the number of liters of fuel or the number of degrees of charging, etc.) and invoice price. The air business trip document 122 includes the airline, flight, departure airport, relay airport, landing airport, cabin class, flight type (round trip or one way) and air ticket price, etc.
[0099] The comparison calculation unit 20 is linked to the input unit 10, and includes a vehicle carbon emission coefficient comparison module 21 and a business trip distance automatic calculation module 22. The vehicle carbon emission coefficient comparison module 21 includes a vehicle carbon emission coefficient comparison module 211 per extended distance and a vehicle energy type per energy measurement unit carbon emission coefficient comparison module 212. The vehicle carbon emission coefficient comparison module 211 per extended distance is used to compare and obtain the carbon emission coefficient information of the business trip vehicle per extended distance, and the vehicle energy type per energy measurement unit carbon emission coefficient comparison module 212 is used to compare and obtain The carbon emission coefficient per energy unit of the means of transportation for business trips, and the carbon emission coefficient comparison module 211 for each extended distance of the means of transportation and the carbon emission coefficient comparison module 212 for each energy unit of the means of transportation energy type can be edited or updated according to the carbon emission coefficient of the country or region of the business trip that is newly announced. The built-in database of this system, the business trip distance automatic calculation module 22 is an external program, and the input unit 10 is linked to the business trip distance automatic calculation module 22 through the network, thereby automatically calculating the distance information between the two places of the business trip. In this embodiment, the business trip distance automatic calculation module 22 is a program that uses Google Spreadsheet (such as Figure 8 As shown in the figure, the Google spreadsheet can be combined with Google Maps to automatically calculate the distance between two places and other information (the unit can be metric kilometers or imperial miles). The following formula can be entered to let the Google function automatically calculate the "Distance" field: =GOOGLEMAPS_DISTANCE("Departure Place", "Destination"), for example: =GOOGLEMAPS_DISTANCE(A2,B2), or: =GOOGLEMAPS_DISTANCE("Taichung High Speed Rail Station, Taiwan", "Changbin Industrial Park"), which can automatically calculate that the distance between the two places is 31.9KM.
[0100] The operation unit 30 is linked to the input unit 10 and the comparison calculation unit 20, and is used to perform operations based on the business trip document 12 to calculate a business trip expense 31 and a business trip carbon emission value 32. The business trip expense 31 includes a business trip land transportation expense 311 and a business trip air transportation expense 312. The business trip carbon emission value 32 includes a business trip land transportation carbon emission value 321 and a business trip air transportation carbon emission value 322. The business trip land transportation carbon emission value 321 is obtained by calculating the carbon emission coefficient information of each extended distance of the business trip vehicle and the distance information between the two places of the business trip. , or calculated from the carbon emission coefficient per energy unit of the business trip transportation vehicle and the total energy of the land transportation business trip receipt 121. The business trip air transport carbon emission value 322 is obtained by calculating the carbon emission calculation module 33 of the external airline connected to the network. In this embodiment, the airline carbon emission calculation module 33 takes Taiwan China Airlines as an example of a carbon footprint calculation tool. The employee takes Taiwan China Airlines economy class direct flight from Taiwan Taoyuan Airport to Incheon Airport in South Korea and back. The carbon emissions generated by the business trip air transport flight are 0.28 tons CO2e.
[0101] In order to automatically calculate the carbon emissions generated by air travel, airlines around the world will use the flight carbon footprint calculation method proposed by the International Civil Aviation Organization (ICAO) and the International Air Transport Association (IATA). The key coefficient uses the actual flight fuel, the number of seats on the aircraft type, and the passenger / cargo data of the actual revenue of each cabin class (excluding non-revenue personnel such as crew members and employees, and empty seats: RTK) to calculate the carbon emissions generated by the flight service transportation of "actual" paying passengers. At present, the websites of airlines around the world will gradually establish their own carbon footprint calculation tool systems. This system can be obtained by connecting to the external airline carbon emission calculation module 33 for calculation.
[0102] Regarding the above-mentioned connection external travel distance automatic calculation module 22 (such as Figure 8 Using Google Spreadsheet as an example) or external airline carbon emissions calculation module33 (such as Fig.10 Taking the carbon footprint calculation tool of China Airlines in Taiwan as an example), the entire calculation process is automatically carried out through the XML (eXtensible Markup Language) interface that is connected in series with the input unit of this carbon emission calculation system, and the interface design based on XML (eXtensible Markup Language) completes automatic data storage and data transmission.
[0103] First, take the business trip distance automatic calculation module 22 using Google spreadsheet as an example. Figure 8As shown in the dashed block diagram on the left, the data of the fields such as the departure place (A) and the destination (B) are manually input from the input unit 10. Through the XML interface design, the (A) and (B) data can be stored and transmitted to the business trip distance automatic calculation module 22, and the distance information between the two places can be automatically calculated and stored in the (C) field (such as Figure 8 As shown in the dashed block diagram on the right), the (C) field data is stored and transmitted to the computing unit 30 through the XML interface design, and the corresponding Google Maps map 221 (such as Fig. 9 As shown in the figure, the map image is captured as supporting data for carbon emission calculation. In the face of the company's large number of employee business trip data for the year, a series of departure (A) and destination (B) fields can be generated in sequence from the input unit 10 through programming, and a series of "distance" fields (C) can be automatically calculated by the Google function.
[0104] Taking the airline carbon emission calculation module 33 as an example, the carbon footprint calculation tool of Taiwan China Airlines is used. Fig.10 As shown in the dashed box diagram on the left, the fields such as the departure airport, the relay airport, the landing airport, the number of passengers, the cabin class and the flight type (round trip or one-way) are manually input from the input unit 10. Through the XML interface design, these data can be stored and transmitted to the network connection external airline carbon emission calculation module 33, and the corresponding carbon emission value generated by the flight can be automatically calculated (such as Fig.10 As shown in the dashed block diagram on the right), the business trip air transport carbon emission value 322 is stored and transmitted to the computing unit 30 through the XML interface design, and the capture of the carbon emission value 322 can be further generated. Fig.10 Images are used as supporting data for carbon emissions calculations.
[0105] Regarding the carbon emission coefficient comparison module 211 for each extended passenger distance of the transportation tool and the carbon emission coefficient comparison module 212 for each energy unit of the transportation tool energy type, the carbon emission coefficient of the transportation tool varies according to different countries or regions and years. Taking the greenhouse gas emission inventory operation guidelines and carbon emission coefficients published by the Taiwan Environmental Protection Agency as an example, the emission coefficient of automobiles is 0.173kgCO2e per person per kilometer (per extended passenger kilometer), the emission coefficient of hybrid vehicles is 0.088kgCO2e per person per kilometer (per extended passenger kilometer), the emission coefficient of electric vehicles is 0.078kgCO2e per person per kilometer (per extended passenger kilometer), and the emission coefficient of buses is 0.173kgCO2e per person per kilometer (per extended passenger kilometer). The emission coefficient of MRT is 0.04kgCO2e per person per kilometer (per extended person-kilometer), the emission coefficient of high-speed rail is 0.04kgCO2e per person per kilometer (per extended person-kilometer), the emission coefficient of train is 0.06kgCO2e per person per kilometer (per extended person-kilometer), 2.373kgCO2e per liter of gasoline, 2.66kgCO2e per liter of diesel, and 0.554kgCO2e per kilowatt-hour of electricity. The emission coefficient data of different means of transportation in each country or region will be dynamically updated over time and with technological progress. This system can edit or update the system's built-in database based on the latest carbon emission coefficient announced by the country or region of the business trip.
[0106] The output unit 40 is linked to the calculation unit 30 to generate a business trip reimbursement report 41 based on the calculated business trip land transportation expenses 311 and / or the business trip air transportation expenses 312, and to generate a business trip carbon emission report 42 based on the calculated business trip land transportation carbon emission value 321 and / or the business trip air transportation carbon emission value 322.
[0107] The audit unit 50 includes a supervisor audit 51 and a carbon emission audit 52 . The supervisor audit 51 audits the business trip write-off report 41 , and the carbon emission audit 52 audits the business trip carbon emission report 42 .
[0108] The write-off unit 60 includes an accounting write-off 61 , which performs expense write-off according to the business trip write-off report 41 .
[0109] The present invention has a usage process of the write-off system with the function of automatically calculating the carbon emissions of employees on business trips, such as Fig.11 As shown, the process of using land transportation business trips includes the following steps:
[0110] (a1) Input step S101, the input unit 10 inputs the business trip cancellation application form data 11 and the land transportation business trip document 121.
[0111] (a2) Step S102 of comparing the carbon emission coefficient of transportation means, using the business trip country or region, energy type and transportation means inputted in the business trip verification application form data 11 and the land transportation business trip receipt 121, the carbon emission coefficient per extended distance of the transportation means is compared with the carbon emission coefficient per extended distance of the business trip transportation means through the carbon emission coefficient per extended distance comparison module 211 according to the built-in database of carbon emission coefficients of transportation means of various countries.
[0112] (a3) Automatically calculate the business trip distance step S103, based on the departure place, destination and means of transportation input in the business trip cancellation application form data 11 and the land transportation business trip document 121, the business trip distance automatic calculation module 22 is linked to the external network to automatically calculate the distance information between the two business trip locations (the unit can be metric kilometers or imperial miles).
[0113] (a4) Operation step S104, based on the land transportation business trip receipt 121, a business trip land transportation fee 311 is calculated by the operation unit 30, and based on the compared carbon emission coefficient information per extended distance of the business trip vehicle and the automatically calculated distance information between the two business trip locations, a business trip land transportation carbon emission value 321 is calculated by the operation unit 30.
[0114] (a5) Output step S105 , the output unit 40 generates a business trip write-off report 41 based on the business trip land transportation expenses 311 , and generates a business trip carbon emission report 42 based on the business trip land transportation carbon emission value 321 .
[0115] The present invention has a usage process of the write-off system with the function of automatically calculating the carbon emissions of employees on business trips, such as Fig.12 As shown, another process of using land transportation for business trips is disclosed, which includes the following steps:
[0116] (b1) Input step S201, the input unit 10 inputs the business trip cancellation application form data 11 and the land transportation business trip document 121.
[0117] (b2) Step S202 of comparing the carbon emission coefficient of transportation means, using the business trip country or region, energy type and transportation means inputted in the business trip verification application form data 11 and the land transportation business trip receipt 121, and using the carbon emission coefficient per energy unit of transportation means energy type comparison module 212 to compare the carbon emission coefficient per energy unit of the transportation means on the business trip with the carbon emission coefficient database of various countries.
[0118] (b3) Operation step S203, a business trip land transportation fee 311 is calculated through the operation unit 30 based on the land transportation business trip receipt 121, and a business trip land transportation carbon emission value 321 is calculated through the operation unit 30 based on the compared carbon emission coefficient information per energy measurement unit of the business trip vehicle and the total energy amount of the land transportation business trip receipt 121.
[0119] (b4) Output step S204, the output unit 40 generates a business trip write-off report 41 according to the business trip land transportation expenses 311, and generates a business trip carbon emission report 42 according to the business trip land transportation carbon emission value 321.
[0120] The present invention has a usage process of the write-off system with the function of automatically calculating the carbon emissions of employees on business trips, such as Fig.13 As shown, the process of using air transportation for business trips includes the following steps:
[0121] (c1) In the input step S301, the input unit 10 inputs the business trip cancellation application form data 11 and the air travel document 122.
[0122] (c2) Operation step S302, based on the air travel receipt 122, a business trip air transport fee 312 is calculated through the operation unit 30, and based on the business trip verification application form data 11 and the information inputted in the air travel receipt 122 (airline, flight, departure airport, relay airport, landing airport, cabin class and flight category), the operation unit 30 is connected to the external airline carbon emission calculation module 33 through the network to calculate a business trip air transport carbon emission value 322.
[0123] (c3) Output step S303, the output unit 40 generates a business trip write-off report 41 according to the business trip air transportation fee 312, and generates a business trip carbon emission report 42 according to the business trip air transportation carbon emission value 322.
[0124] The present invention has a usage process of the write-off system with the function of automatically calculating the carbon emissions of employees on business trips, such as Fig.14 As shown, the process of combining land and air transportation for business trips is revealed, which includes the following steps:
[0125] (d1) Input step S401, the business trip cancellation application form data 11, the land transportation business trip document 121 and the air transportation business trip document 122 are input by the input unit.
[0126] (d2) Comparison of the carbon emission coefficient of the means of transport in step S402, using the business trip verification application form data 11 and the land transport business trip receipt 121 to input the business trip country or region and the means of transport, and using the carbon emission coefficient per extended distance of the means of transport comparison module 211 to compare the carbon emission coefficient per extended distance of the means of transport according to the carbon emission coefficient database of various countries, or using the carbon emission coefficient per energy unit of the means of transport comparison module 212 to compare the carbon emission coefficient per energy unit of the means of transport according to the carbon emission coefficient database of various countries.
[0127] (d3) Automatically Calculate Business Trip Distance Step S403, based on the departure place, destination and means of transportation inputted in the business trip cancellation application form data 11 and the land transportation business trip receipt 121, the business trip distance automatic calculation module 22 is linked to the network to automatically calculate the distance information between the two places of the business trip.
[0128] (d4) Operation step S404, a land transportation fee 311 is calculated by the operation unit 30 based on the land transportation business trip receipt 121, and an air transportation fee 312 is calculated by the operation unit 30 based on the air transportation business trip receipt 122. A land transportation carbon emission value 321 is calculated by the operation unit 30 based on the compared carbon emission coefficient information per extended distance of the business trip vehicle and the automatically calculated distance between the two places of the business trip, or the compared carbon emission coefficient information per energy measurement unit of the business trip vehicle and the total energy of the land transportation business trip receipt 121. , and based on the information entered in the business trip verification application form data 11 and the air travel document 122 (airline, flight, departure airport, relay airport, landing airport, cabin class and flight category), the calculation unit 30 is connected to the external airline carbon emission calculation module 33 through the network to calculate a business trip air transport carbon emission value 322, and the business trip land transportation fee 311 and the business trip air transportation fee 312 are added to the business trip fee 31, and the business trip land transportation carbon emission value 321 and the business trip air transportation carbon emission value 322 are added to the business trip carbon emission value 32.
[0129] (d5) Output step S405, the output unit 40 generates a business trip write-off report 41 according to the business trip expense 31, and generates a business trip carbon emission report 42 according to the business trip carbon emission value 32.
[0130] The structure of the above specific embodiment can achieve the following beneficial effects:
[0131] 1. The present invention has a write-off system and its process with the function of automatically calculating the carbon emissions of employees on business trips. It can be applied to the carbon emissions calculation of employees on business trips by land transportation, the carbon emissions calculation of employees on business trips by air transportation, and the carbon emissions calculation of employees on business trips combining land transportation and air transportation, so as to achieve improved applicability and practicality.
[0132] 2. The present invention has a write-off system and process for automatically calculating employee business trip carbon emissions. By inputting the business trip write-off application form data 11 and the business trip document 12, the employee business trip expenses 31 and the employee business trip carbon emissions value 32 can be automatically calculated, which is conducive to the enterprise to quickly and conveniently calculate the employee business trip carbon emissions and write off the business trip expenses.
Claims
1. A write-off system with the function of automatically calculating carbon emissions from business trips of employees, comprising: An input unit for inputting the business trip cancellation application form data and the business trip document, wherein the business trip document includes a land transportation business trip document and / or an air transportation business trip document; a comparison and calculation unit, linked to the input unit, including a transportation carbon emission coefficient comparison module and a business trip distance automatic calculation module, the transportation carbon emission coefficient comparison module includes a transportation carbon emission coefficient per extended distance comparison module, the transportation carbon emission coefficient per extended distance comparison module is used to compare and obtain the carbon emission coefficient information per extended distance of the transportation for business trips, the business trip distance automatic calculation module is an external program, the input unit is linked to the business trip distance automatic calculation module through the network, thereby automatically calculating the distance information between the two places of the business trip; the emission coefficient data of different transportation tools in each country will be dynamically updated over time, and the comparison and calculation unit can edit or update the system built-in database according to the latest carbon emission coefficient announced by the business trip country; a calculation unit, linked to the input unit and the comparison calculation unit, for calculating according to the business trip document, calculating a business trip expense and a business trip carbon emission value, the business trip expense includes a business trip land transportation expense and / or a business trip air transportation expense, the business trip carbon emission value includes a business trip land transportation carbon emission value and / or a business trip air transportation carbon emission value, the business trip land transportation carbon emission value is calculated and obtained by calculating the carbon emission coefficient information of each extended distance of the business trip vehicle and the distance information between the two places of the business trip, the business trip air transportation carbon emission value is calculated and obtained by connecting to the network external airline carbon emission calculation module, the business trip air transportation carbon emission value is stored and transmitted to the calculation unit, and its image can be further generated and captured as carbon emission calculation supporting data; an output unit, linked to the calculation unit, for generating a business trip write-off report based on the calculated business trip land transportation expenses and / or the business trip air transportation expenses, and for generating a business trip carbon emission report based on the calculated business trip land transportation carbon emission value and / or the business trip air transportation carbon emission value; An audit unit, including a supervisor audit and a carbon emission audit, wherein the supervisor audit audits the business trip write-off report, and the carbon emission audit audits the business trip carbon emission report; and A write-off unit includes an accounting write-off, and the accounting write-off performs fund write-off based on the business trip write-off report.
2. According to the verification system with the function of automatically calculating the carbon emissions of employees on business trips as described in claim 1, the transportation carbon emission coefficient comparison module further includes a transportation energy type per energy unit carbon emission coefficient comparison module, and the transportation energy type per energy unit carbon emission coefficient comparison module is used to compare and obtain the carbon emission coefficient per energy unit of the business trip transportation.
3. According to claim 1, the verification system with the function of automatically calculating the carbon emissions of employees on business trips, wherein the data in the business trip verification application form includes the business trip personnel, the purpose of the business trip, the business trip location (including the country, departure place, and destination), the start and end dates of the business trip, and the means of transportation, and the means of transportation include aircraft, high-speed rail, trains, MRT, long-distance buses, public buses, gasoline vehicles, taxis, diesel vehicles, hybrid vehicles, and electric vehicles.
4. According to claim 1, a verification system with the function of automatically calculating carbon emissions of employees on business trips, wherein the land transportation business trip document includes a ticket document and / or an invoice document, the ticket document includes the date, means of transportation, departure place, destination and ticket fee, and the invoice document includes the date, energy type, total energy and invoice fee.
5. The verification system with automatic calculation function of carbon emissions of employees on business trips according to claim 1, wherein the air travel document includes the airline, flight, departure airport, relay airport, landing airport, cabin class, flight type (round trip or one way) and air ticket price.
6. According to claim 1, the write-off system with the function of automatically calculating employee business trip carbon emissions, wherein the business trip distance automatic calculation module is a Google spreadsheet, and its input = GOOGLEMAPS_DISTANCE("departure place", "destination") formula allows the Google function to automatically calculate the distance. The business trip distance automatic calculation module and the airline carbon emissions calculation module use XML (eXtensible Markup Language)-based interface design to complete data storage and data transmission, so that the entire calculation process is automatically performed through the serialized XML interface.
7. A process for using a verification system with a function of automatically calculating carbon emissions from business trips of employees, using the verification system with a function of automatically calculating carbon emissions from business trips of employees as claimed in any one of claims 1 to 6, comprising the following steps: (a1) Input step, inputting the business trip cancellation application form data and land transportation business trip documents by the input unit; (a2) The step of comparing the carbon emission coefficient of transportation means is to compare the carbon emission coefficient information of each extended distance of the transportation means of the business trip with the business trip country and transportation means entered in the business trip cancellation application form and the land transportation business trip document through the carbon emission coefficient comparison module of each extended distance of the transportation means according to the carbon emission coefficient database of each country; (a3) Automatically calculating the business trip distance step, using the business trip cancellation application form data and the departure place, destination and means of transportation entered in the land transportation business trip document, and automatically calculating the distance information between the two places of the business trip through a network-linked business trip distance automatic calculation module; (a4) a calculation step, calculating a land transportation fee for the business trip through a calculation unit based on the land transportation business trip document, and calculating a land transportation carbon emission value for the business trip through a calculation unit based on the compared carbon emission coefficient information per extended distance of the business trip vehicle and the automatically calculated distance information between the two places of the business trip; (a5) An output step, in which an output unit generates a business trip write-off report based on the business trip land transportation expenses, and generates a business trip carbon emission report based on the business trip land transportation carbon emission value.
8. A process for using a verification system with a function of automatically calculating carbon emissions from business trips of employees, using the verification system with a function of automatically calculating carbon emissions from business trips of employees as claimed in any one of claims 1 to 6, comprising the following steps: (b1) an input step, in which the data of the business trip cancellation application form and the land transportation business trip documents are inputted by the input unit; (b2) The step of comparing the carbon emission coefficient of transportation means is to compare the carbon emission coefficient information of each energy unit of the transportation means on the business trip with the business trip country, energy type and transportation means entered in the business trip cancellation application form and the land transportation business trip document through the carbon emission coefficient comparison module of each energy unit of the transportation means on the business trip according to the carbon emission coefficient database of each country's transportation means; (b3) a calculation step, calculating a land transportation fee for the business trip through a calculation unit based on the land transportation business trip receipt, and calculating a land transportation carbon emission value for the business trip through a calculation unit based on the compared carbon emission coefficient information per energy measurement unit of the business trip vehicle and the total energy amount of the land transportation business trip receipt; (b4) an output step, in which an output unit generates a business trip write-off report based on the business trip land transportation expenses, and generates a business trip carbon emission report based on the business trip land transportation carbon emission value.
9. A process for using a verification system with a function of automatically calculating carbon emissions from business trips of employees, using the verification system with a function of automatically calculating carbon emissions from business trips of employees as claimed in any one of claims 1 to 6, comprising the following steps: (c1) an input step, in which the business trip cancellation application form data and air travel documents are input by the input unit; (c2) a calculation step, calculating an air travel expense through a calculation unit based on the air travel document, and calculating an air travel carbon emission value through a calculation unit network connected to an external airline carbon emission calculation module based on the business trip write-off application form data and the information input on the air travel document; (c3) an output step, in which an output unit generates a business trip write-off report based on the business trip air transportation expenses, and generates a business trip carbon emission report based on the business trip air transportation carbon emission value.
10. A process for using a verification system with a function of automatically calculating carbon emissions from business trips of employees, using the verification system with a function of automatically calculating carbon emissions from business trips of employees as claimed in any one of claims 1 to 6, comprising the following steps: (d1) an input step, in which the business trip cancellation application form data, land transportation business trip documents and air transportation business trip documents are inputted by the input unit; (d2) The step of comparing the carbon emission coefficient of transportation means is to compare the carbon emission coefficient information of each extended distance of the transportation means with the business trip country and transportation means inputted in the business trip cancellation application form and the land transportation business trip document through the carbon emission coefficient comparison module of each extended distance of the transportation means according to the carbon emission coefficient database of various countries, or to compare the carbon emission coefficient information of each energy unit of the transportation means according to the carbon emission coefficient database of various countries through the carbon emission coefficient comparison module of each energy type of the transportation means; (d3) Automatically calculating the business trip distance step, using the business trip cancellation application form data and the departure place, destination and means of transportation entered in the land transportation business trip document, and automatically calculating the distance information between the two places of the business trip through a network-linked business trip distance automatic calculation module; (d4) a calculation step, calculating a land transportation fee for a business trip through a calculation unit based on the land transportation business trip document, calculating an air transportation fee for a business trip through a calculation unit based on the air transportation business trip document, calculating a land transportation carbon emission value for a business trip through a calculation unit based on the compared carbon emission coefficient information per extended distance of the business trip vehicle and the automatically calculated distance between the two places of the business trip, or the compared carbon emission coefficient information per energy measurement unit of the business trip vehicle and the total energy of the land transportation business trip document, and calculating a carbon emission value for air transportation by connecting to an external airline carbon emission calculation module through a calculation unit network based on the business trip cancellation application form data and the information input on the air transportation business trip document, and adding the land transportation fee for the business trip to the air transportation fee to obtain the business trip fee, and adding the land transportation carbon emission value for the business trip to the air transportation carbon emission value to obtain the business trip carbon emission value; (d5) An output step, in which an output unit generates a business trip write-off report based on the business trip expenses, and generates a business trip carbon emission report based on the business trip carbon emission value.