CN111127018A - Method for automatically calculating locked exchange rate profit and loss - Google Patents
Method for automatically calculating locked exchange rate profit and loss Download PDFInfo
- Publication number
- CN111127018A CN111127018A CN201911385389.5A CN201911385389A CN111127018A CN 111127018 A CN111127018 A CN 111127018A CN 201911385389 A CN201911385389 A CN 201911385389A CN 111127018 A CN111127018 A CN 111127018A
- Authority
- CN
- China
- Prior art keywords
- exchange rate
- locked
- loss
- information
- profit
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/38—Payment protocols; Details thereof
- G06Q20/381—Currency conversion
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Marketing (AREA)
- Technology Law (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Taking a locked exchange rate application list as a reference, and performing temporary estimation profit and loss calculation on the locked exchange rate application list in a locked exchange rate period to obtain temporary estimation information; when the locked exchange rate is expired, transaction information is obtained, settlement processing is carried out on the transaction information to obtain posting information, the tentative estimation information and the posting information are automatically generated through calculation, the problem that the locked exchange rate is poor and difficult to calculate manually is solved, the generated tentative estimation information and the generated posting information can generate a statistical analysis report in real time, manual calculation under the line is changed into automatic calculation on the line of the locked exchange rate, the problem that data analysis is difficult is solved, and quantitative assessment of all departments is achieved.
Description
Technical Field
The invention relates to the field of finance, in particular to a method for automatically calculating locked exchange rate profit and loss.
Background
In the international trade collection, payment, remittance and settlement process, in order to reduce the risk of rate caused by frequent fluctuation of foreign currency rate, import and export enterprises usually go to banks to handle the operation of locking rate (called locking rate for short). On the day of the exchange, the exchange is carried out according to the exchange rate determined before instead of the price of the foreign exchange on the day.
With more and more businesses for locking the exchange rate of an enterprise, the disadvantages caused by offline manual management of the data of the locking exchange rate are more and more: lack of risk management and control, high offline management cost, untimely data registration, asymmetric information feedback, incapability of sharing data, difficult data analysis, complex logic for checking and calculating the locking exchange rate of business departments in trade enterprises, and difficult manual calculation. Therefore, original information of the locked exchange rate is automatically registered on line, loss and gain of the current-period locked exchange rate and final posting information are automatically and temporarily estimated, offline manual calculation is changed into online automatic calculation of the loss and gain of the locked exchange rate, a real-time statistical analysis report is generated, the problems that data analysis of a trade enterprise is difficult, and loss and gain of the locked exchange rate are difficult to calculate manually are solved, and quantitative assessment of all departments is realized.
Disclosure of Invention
The invention provides a method for automatically calculating the loss and gain of a locked exchange rate, which aims to solve the problems that data analysis is difficult and the loss and gain of the locked exchange rate is difficult to calculate manually in the prior art and realize quantitative assessment on each department.
In order to achieve the purpose, the invention adopts the following technical scheme:
the invention discloses a method for automatically calculating the locked exchange rate profit and loss, which comprises the following steps:
acquiring a locked exchange rate application form, and processing the acquired locked exchange rate application form to obtain a locked exchange rate application list;
taking the locked exchange rate application list as a reference, and performing temporary estimation profit and loss calculation on the locked exchange rate application list in a locked exchange rate period to output temporary estimation information;
and when the locked exchange rate is expired, acquiring transaction information, settling the transaction information and outputting posting information.
The method comprises the steps of taking a locked exchange rate application list obtained by processing a locked exchange rate application form as a reference, carrying out temporary estimation profit and loss calculation on the locked exchange rate application list in a locked exchange rate period, outputting temporary estimation information, acquiring transaction information when the locked exchange rate is expired, carrying out settlement processing on the transaction information, and outputting posting information, so that the problems of difficult data analysis and difficult manual calculation of locked exchange rate profit and loss are solved, the locked exchange rate profit and loss calculation can be carried out automatically, the temporary estimation information and the posting information are generated in the process, the problems of difficult data analysis and incorrect information feedback are solved, and quantitative assessment on each department is realized.
Preferably, the performing tentative estimation profit-and-loss calculation on the locked exchange rate application list during the locked exchange rate period by using the locked exchange rate application list as a standard and outputting tentative estimation information includes:
calculating the tentatively estimated amount of money according to the invoice exchange rate and the lock exchange rate;
and carrying out tentatively estimated posting processing according to the tentatively estimated amount, and outputting a tentatively estimated voucher.
Preferably, the acquiring transaction information when the locked exchange rate expires, performing settlement processing on the transaction information, and outputting posting information includes:
carrying out leveling judgment processing according to the transaction information;
and (4) calculating the profit and loss amount according to the flat warehouse judgment, finishing settlement processing and outputting posting information.
Preferably, the acquiring one of the orders in the order pool as a reference order, the acquiring a lock-in rate application form, processing the lock-in rate application form, and outputting a lock-in rate application list includes:
and acquiring a locked exchange rate application form, filling the original information into the locked exchange rate application form for processing, and outputting a locked exchange rate application list.
An apparatus for automatically calculating lockstep profits, comprising:
the acquisition module acquires a locked exchange rate application form, processes the acquired locked exchange rate application form to obtain a locked exchange rate application list;
the temporary estimation module is used for carrying out temporary estimation profit and loss calculation on the locking exchange rate application list in the locking exchange rate period by taking the locking exchange rate application list as a standard and outputting temporary estimation information;
and the bill module acquires the transaction information when the locking exchange rate is expired, settles the transaction information and outputs the posting information.
Preferably, the provisional estimation module includes:
the temporary estimated amount unit calculates the temporary estimated amount according to the invoice exchange rate and the lock exchange rate;
and the temporary estimation voucher unit is used for carrying out temporary estimation posting processing according to the temporary estimation amount and outputting a temporary estimation voucher.
Preferably, the billing module includes:
the leveling judgment unit is used for carrying out leveling judgment processing according to the transaction information;
and the posting information unit is used for judging and calculating the profit and loss amount according to the flat bin, finishing settlement processing and outputting posting information.
Preferably, the acquiring module includes:
and the application list unit is used for acquiring the locked exchange rate application form, filling the original information into the locked exchange rate application form for processing and outputting the locked exchange rate application list.
An electronic device comprising a memory and a processor, the memory storing one or more computer instructions, wherein the one or more computer instructions are executable by the processor to implement a method of automatically calculating a lock exchange rate profit-and-loss as recited in any one of the above.
A computer readable storage medium having stored thereon a computer program for causing a computer to perform a method of automatically calculating a lock exchange rate profit or loss as defined in any one of the preceding claims.
The invention has the following beneficial effects:
taking a locked exchange rate application list as a reference, and performing temporary estimation profit and loss calculation on the locked exchange rate application list in a locked exchange rate period to obtain temporary estimation information; when the locked exchange rate is expired, transaction information is obtained, settlement processing is carried out on the transaction information to obtain posting information, the tentative estimation information and the posting information are automatically generated through calculation, the problem that the locked exchange rate is poor and difficult to calculate manually is solved, the generated tentative estimation information and the generated posting information can generate a statistical analysis report in real time, manual calculation under the line is changed into automatic calculation on the line of the locked exchange rate, the problem that data analysis is difficult is solved, and quantitative assessment of all departments is achieved.
Drawings
FIG. 1 is a first flowchart of a method for automatically calculating a locked rate gain and loss according to an embodiment of the present invention;
FIG. 2 is a second flowchart of a method for automatically calculating the locked exchange rate profit and loss according to an embodiment of the present invention;
FIG. 3 is a third flowchart of a method for automatically calculating lock-out rate penalties and penalties according to an embodiment of the present invention;
FIG. 4 is a flowchart illustrating an embodiment of a method for automatically calculating the gain and loss of a locked exchange rate according to the present invention;
FIG. 5 is a schematic diagram of an apparatus for automatically calculating the gain and loss of the locked exchange rate according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of a temporary estimation module of an apparatus for automatically calculating the gain and loss of the locked exchange rate according to an embodiment of the present invention;
FIG. 7 is a schematic diagram of a billing module of an apparatus for automatically calculating the locked exchange rate profit and loss according to an embodiment of the present invention;
fig. 8 is a flowchart illustrating an embodiment of an apparatus for automatically calculating the locked exchange rate profit and loss according to the present invention.
FIG. 9 is a schematic diagram of an electronic device implementing a method for automatically calculating a locked exchange rate profit and loss according to an embodiment of the present invention;
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Before the technical solution of the present invention is introduced, a scenario to which the technical solution of the present invention may be applicable is exemplarily described.
The following are exemplary: the calculation of the loss and gain of the locked exchange rate in international trade is a process in the process of payment, exchange and settlement. The locked exchange rate is a means for settling the exchange rate determined before, and avoiding the risk of exchange rate variation.
Illustratively, a temporary estimation module and a bill module are indispensable in international trade collection and payment settlement, automatic calculation of locked exchange rate profit and loss is realized by the temporary estimation module and the bill module in the collection and payment settlement, temporary estimation information and posting information are generated, and the problems that data analysis is difficult and manual calculation of locked exchange rate profit and loss is difficult in the prior art are solved.
Obviously, the number of temporary estimation modules and the number of bill modules in international trade receipt and payment settlement are large, and in the prior art, each temporary estimation module and each bill module need to be manually calculated, so that the problems that the locked exchange rate is difficult to calculate, a statistical analysis report cannot be generated in real time, and data analysis is difficult are caused.
The device for automatically calculating the locked exchange rate loss and gain can automatically calculate the temporary estimation module and the bill module to generate temporary estimation information and posting information, solves the problems that the locked exchange rate loss and gain is difficult to calculate manually and data analysis is difficult, changes offline manual calculation into online automatic calculation of the locked exchange rate loss and gain, generates a statistical analysis report in real time, and realizes quantitative assessment of all departments.
Example 1
As shown in fig. 1, a method for automatically calculating the exchange rate damage includes the following steps:
s100, acquiring a locked exchange rate application form, and processing the acquired locked exchange rate application form to obtain a locked exchange rate application list;
s110, taking the locked exchange rate application list as a reference, performing temporary estimation profit and loss calculation on the locked exchange rate application list in the period of locking the exchange rate, and outputting temporary estimation information;
and S120, acquiring transaction information when the locked exchange rate is expired, settling the transaction information, and outputting posting information.
According to the embodiment 1, when the system obtains the locked exchange rate application form, a locked exchange rate application list is selected as a reference, and in the period of locked exchange rate, the locked exchange rate application list is subjected to temporary estimation profit and loss calculation to output temporary estimation information; and when the locked exchange rate is expired, acquiring transaction information, settling the transaction information and outputting posting information. The method can automatically calculate the loss and gain of the locked exchange rate, automatically generate a statistical analysis report and solve the problems that the loss and gain of the locked exchange rate is difficult to calculate manually and data analysis is difficult.
Example 2
As shown in fig. 2, a method for automatically calculating the lock exchange rate profit and loss includes:
s210, obtaining a locked exchange rate application form, and processing the obtained locked exchange rate application form to obtain a locked exchange rate application list;
s220, taking the locked exchange rate application list as a reference, performing temporary estimation profit and loss calculation on the locked exchange rate application list in the period of locking the exchange rate, and outputting temporary estimation information;
s230, calculating the tentatively estimated amount according to the invoice exchange rate and the lock exchange rate;
s240, carrying out temporary estimation posting processing according to the temporary estimation amount, and outputting a temporary estimation voucher.
According to the embodiment 2, the tentatively estimated amount is calculated according to the invoice exchange rate and the lock exchange rate, tentatively estimated posting processing is performed according to the tentatively estimated amount, and a tentatively estimated voucher is output, so that the calculation of the tentatively estimated profit and loss in the process can be realized. Compared with manual calculation for temporarily estimating profit and loss, the method solves the problems that the exchange rate locking profit and loss is difficult to calculate manually and data analysis is difficult, and statistically analyzes reports in the automatic generation process to reduce the asymmetry of information feedback.
Example 3
As shown in fig. 3, a method for automatically calculating the lock exchange rate profit and loss includes:
s310, obtaining a locked exchange rate application form, and processing the obtained locked exchange rate application form to obtain a locked exchange rate application list;
s320, taking the locked exchange rate application list as a reference, performing temporary estimation profit and loss calculation on the locked exchange rate application list in the period of locking the exchange rate, and outputting temporary estimation information;
s330, carrying out leveling judgment processing according to the transaction information;
s340, calculating the profit and loss amount according to the flat bin judgment, finishing settlement processing and outputting posting information;
according to the embodiment 2, during the lock transfer, the amount is claimed according to the sequence of the receipt and payment dates, the transaction information is used for processing whether the bunkering judgment is needed or not, the profit and loss amount is calculated, the settlement processing is completed, the posting information is obtained, and therefore the final posting information calculation can be achieved. The method solves the problems that the exchange rate loss and gain locking is difficult to calculate manually and data analysis is difficult, automatically generates a final statistical analysis report, reduces information feedback asymmetry, and realizes quantitative assessment of all departments.
Example 4
As shown in fig. 4, one specific embodiment may be:
s410, entry of locked exchange rate application form in ERP system
Selecting the type of the locked exchange rate application, filling in original information, wherein the original information comprises a specific locked exchange rate contract, a locked exchange rate application period, a psychological exchange rate and information of a service staff, after the completion of filling, submitting by a service department, transmitting the locked exchange rate application information to an OA system for approval, and after the application of the OA system is completed, changing the locked exchange rate application state in the ERP system into an approved state. And processing the locked exchange rate service according to the information of the locked exchange rate application. And after the processing is successful, recording the information of the actual locking exchange rate in the system. At which point the locked exchange rate state becomes more active.
The locked exchange rate application form, namely the receipt ERP system which does not fill the application quantity corresponding to the contract automatically judges the locked exchange rate application quantity corresponding to the contract of the locked exchange rate application, if the locked exchange rate contract only has one locked exchange rate application form, the payment and receipt information corresponding to the contract is automatically accepted under the locked exchange rate application; if the exchange rate locking contract corresponds to a plurality of exchange rate locking application forms, the collection and payment information corresponding to the exchange rate locking contract needs to be manually identified under the exchange rate locking application; and outputting a locked exchange rate application list, namely filling the documents of the application quantity corresponding to the contract.
S420, calculating the tentatively estimated amount by taking the locked exchange rate application list as a reference;
the ERP system provides a locked exchange rate application list, all the locked exchange rate application information is checked in the locked exchange rate application list, and the temporary estimated profit and loss are automatically calculated.
When the invoice exchange rate and the lock exchange rate are bought, the business contract is imported, and the amount and the exchange rate of the purchased invoice need to be acquired in the ERP system. And (6) temporarily estimating the amount of the invoice, (namely the purchase invoice rate-the locked rate) and the purchase invoice amount.
When the locked exchange rate type is selling, the business contract is export, and the amount and the exchange rate of the sales invoice need to be obtained in the ERP system. And (locking rate-sales invoice rate) selling invoice amount.
S430, calculating a temporary estimation voucher according to the temporary estimation amount, and outputting temporary estimation information;
and the financial department clicks the temporary estimate posting after checking the temporary estimate amount provided by the ERP, and the ERP system automatically generates a temporary estimate voucher.
And when the tentatively estimated amount is more than zero, the representative business department is overflow. The certificate entry is:
amount of profit or loss in credit business department
Amount of profit and loss from public profit center
And when the tentatively estimated amount of money is less than zero, the representative business department is loss. The certificate entry is:
borrowing profit and loss amount of business department
Credit to profit and loss amount of public profit center
The tentative estimation information comprises a tentative estimation amount and a tentative estimation voucher.
S440, when the locked exchange rate is expired, carrying out leveling judgment processing according to the transaction information;
and during the lock remittance, carrying out amount claiming according to the sequence of the receipt and payment dates, wherein the earlier the receipt and payment date is, carrying out the amount claiming. Before settlement processing, the ERP system judges whether the locked exchange rate application of the settlement data needs to be leveled or not. The transaction information comprises actual payment amount, locked exchange rate amount, flat exchange rate and locked exchange rate.
The flat warehouse judgment comprises flat warehouse judgment, and if the actual payment amount of the locked exchange rate contract is less than the locked exchange rate amount, the flat warehouse judgment is needed.
S450, calculating the profit and loss amount according to the flat bin judgment, finishing settlement processing and outputting posting information;
and after the locked exchange rate is expired, the system calculates the profit and loss amount according to the transaction information, and if the lock exchange application is temporarily estimated and posted, the temporarily estimated voucher is cancelled. If the actual amount of the received payment is smaller than the amount of the locked exchange rate, calculating the amount of the loss and the benefit of the locked exchange rate according to the comparison between the exchange rate of the actual received payment and the exchange rate of the locked exchange rate; and if the actual amount of the receipt and payment is more than or equal to the locked exchange rate amount, calculating the locked exchange rate profit and loss condition according to the actual fund receipt and payment condition and the current settlement exchange rate. And outputting the calculated loss and benefit conditions of the locked exchange rate to a profit list of departments to realize quantitative assessment of each department.
Example 5
As shown in fig. 5, an apparatus for automatically calculating the lock exchange rate profit and loss includes:
the acquisition module 10 acquires a lock-in rate application form, and processes the acquired lock-in rate application form to obtain a lock-in rate application list;
the temporary estimation module 20 is configured to perform temporary estimation profit-and-loss calculation on the locked exchange rate application list in the locked exchange rate period by using the locked exchange rate application list as a reference, and output temporary estimation information;
and the billing module 30 acquires the transaction information when the locking exchange rate is expired, settles the transaction information and outputs the posting information.
One embodiment of the above apparatus may be: the obtaining module 10 obtains the locked exchange rate application form, and obtains the locked exchange rate application list after processing, the temporary estimation module 20 performs temporary estimation profit and loss calculation on the locked exchange rate application list, and outputs temporary estimation information, and finally the billing module 30 obtains the transaction information when the locked exchange rate is expired, and performs settlement processing on the transaction information, and outputs posting information.
Example 6
As shown in fig. 6, a tentative estimation module 20 of an apparatus for automatically calculating the lock exchange rate profit and loss includes:
a temporarily estimated amount unit 22 for calculating a temporarily estimated amount according to the invoice exchange rate and the lock exchange rate;
and a temporary estimation voucher unit 24 for performing temporary estimation posting processing according to the temporary estimation amount and outputting a temporary estimation voucher.
One embodiment of the provisional module 20 of the above apparatus may be: the tentatively estimated amount unit 22 calculates a tentatively estimated amount according to the invoice exchange rate and the lock exchange rate, and then the tentatively estimated voucher unit 24 performs tentatively estimated posting processing according to the tentatively estimated amount and outputs a tentatively estimated voucher.
Example 7
As shown in fig. 7, a billing module 30 of an apparatus for automatically calculating the locked exchange rate profit and loss comprises:
a leveling judgment unit 32 for performing leveling judgment according to the transaction information;
and an posting information unit 34 which calculates the profit and loss amount according to the bunk judgment, completes settlement processing, and outputs posting information.
One embodiment of the billing module 30 of the above device may be: the bunkering judgment unit 32 performs bunkering judgment processing according to the transaction information, and then the posting information unit 34 calculates the profit and loss amount according to the bunkering judgment, completes settlement processing and outputs posting information.
Example 8
As shown in fig. 8, one specific implementation may be:
s810, entry of locked exchange rate application form in ERP system
Selecting the type of the locked exchange rate application, filling in original information, wherein the original information comprises a specific locked exchange rate contract, a locked exchange rate application period, a psychological exchange rate and information of a service staff, after the completion of filling, submitting by a service department, transmitting the locked exchange rate application information to an OA system for approval, and after the application of the OA system is completed, changing the locked exchange rate application state in the ERP system into an approved state. And processing the locked exchange rate service according to the information of the locked exchange rate application. And after the processing is successful, recording the information of the actual locking exchange rate in the system. At which point the locked exchange rate state becomes more active.
The locked exchange rate application form, namely the receipt ERP system which does not fill the application quantity corresponding to the contract automatically judges the locked exchange rate application quantity corresponding to the contract of the locked exchange rate application, if the locked exchange rate contract only has one locked exchange rate application form, the payment and receipt information corresponding to the contract is automatically accepted under the locked exchange rate application; if the exchange rate locking contract corresponds to a plurality of exchange rate locking application forms, the collection and payment information corresponding to the exchange rate locking contract needs to be manually identified under the exchange rate locking application; and outputting a locked exchange rate application list, namely filling the documents of the application quantity corresponding to the contract.
S820, calculating the tentatively estimated amount of money by taking the locked exchange rate application list as a reference;
the ERP system provides a locked exchange rate application list, all the locked exchange rate application information is checked in the locked exchange rate application list, and the temporary estimated profit and loss are automatically calculated.
When the invoice exchange rate and the lock exchange rate are bought, the business contract is imported, and the amount and the exchange rate of the purchased invoice need to be acquired in the ERP system. And (6) temporarily estimating the amount of the invoice, (namely the purchase invoice rate-the locked rate) and the purchase invoice amount.
When the locked exchange rate type is selling, the business contract is export, and the amount and the exchange rate of the sales invoice need to be obtained in the ERP system. And (locking rate-sales invoice rate) selling invoice amount.
S830, calculating a temporary estimation voucher according to the temporary estimation amount, and outputting temporary estimation information;
and the financial department clicks the temporary estimate posting after checking the temporary estimate amount provided by the ERP, and the ERP system automatically generates a temporary estimate voucher.
And when the tentatively estimated amount is more than zero, the representative business department is overflow. The certificate entry is:
amount of profit or loss in credit business department
Amount of profit and loss from public profit center
And when the tentatively estimated amount of money is less than zero, the representative business department is loss. The certificate entry is:
borrowing profit and loss amount of business department
Credit to profit and loss amount of public profit center
The tentative estimation information comprises a tentative estimation amount and a tentative estimation voucher.
S840, when the locked exchange rate is over, the leveling judgment is processed according to the information of the transaction;
and during the lock remittance, carrying out amount claiming according to the sequence of the receipt and payment dates, wherein the earlier the receipt and payment date is, carrying out the amount claiming. Before settlement processing, the ERP system judges whether the locked exchange rate application of the settlement data needs to be leveled or not. The transaction information comprises actual payment amount, locked exchange rate amount, flat exchange rate and locked exchange rate.
The flat warehouse judgment comprises flat warehouse judgment, and if the actual payment amount of the locked exchange rate contract is less than the locked exchange rate amount, the flat warehouse judgment is needed.
S850, calculating the profit and loss amount according to the flat bin judgment, finishing settlement processing and outputting posting information;
and after the locked exchange rate is expired, the system calculates the profit and loss amount according to the transaction information, and if the lock exchange application is temporarily estimated and posted, the temporarily estimated voucher is cancelled. If the actual amount of the received payment is smaller than the amount of the locked exchange rate, calculating the amount of the loss and the benefit of the locked exchange rate according to the comparison between the exchange rate of the actual received payment and the exchange rate of the locked exchange rate; if the actual amount of money received and paid is larger than or equal to the locked exchange rate amount, calculating the locked exchange rate profit and loss condition according to the actual fund receiving and paying condition and the current settlement exchange rate, and outputting the calculated locked exchange rate profit and loss condition to a profit list of departments to realize quantitative assessment of all departments.
Example 9
As shown in fig. 9, an electronic device comprises a memory 901 and a processor 902, wherein the memory 901 is used for storing one or more computer instructions, and wherein the one or more computer instructions are executed by the processor 902 to implement one of the above-mentioned methods for automatically calculating the lockexchange rate profit and loss.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the electronic device described above may refer to the corresponding process in the foregoing method embodiment, and is not described herein again.
A computer-readable storage medium storing a computer program which, when executed by a computer, implements a method of automatically calculating a lock exchange rate profit or loss as described above.
Illustratively, a computer program can be partitioned into one or more modules/units, which are stored in the memory 901 and executed by the processor 902 to implement the present invention. One or more modules/units may be a series of computer program instruction segments capable of performing certain functions, the instruction segments being used to describe the execution of a computer program in a computer device.
The computer device may be a desktop computer, a notebook, a palm computer, a cloud server, or other computing devices. The computer device may include, but is not limited to, a memory 901, a processor 902. Those skilled in the art will appreciate that the present embodiments are merely exemplary of a computing device and are not intended to limit the computing device, and may include more or fewer components, or some of the components may be combined, or different components, e.g., the computing device may also include input output devices, network access devices, buses, etc.
The processor 902 may be a Central Processing Unit (CPU), other general-purpose processor 902, a digital signal processor 902 (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf programmable gate array (FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware component, etc. The general purpose processor 902 may be a microprocessor 902 or the processor 902 may be any conventional processor 902 or the like.
The storage 901 may be an internal storage unit of the computer device, such as a hard disk or a memory of the computer device. The memory 901 may also be an external storage device of the computer device, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) card, a flash card (FlashCard), and the like provided on the computer device. Further, the memory 901 may also include both an internal storage unit and an external storage device of the computer device. The memory 901 is used for storing computer programs and other programs and data required by the computer device. The memory 901 may also be used to temporarily store data that has been output or is to be output.
The above description is only an embodiment of the present invention, but the technical features of the present invention are not limited thereto, and any changes or modifications within the technical field of the present invention by those skilled in the art are covered by the claims of the present invention.
Claims (9)
1. A method for automatically calculating the locked exchange rate profit and loss is characterized by comprising the following steps:
acquiring a locked exchange rate application form, and processing the acquired locked exchange rate application form to obtain a locked exchange rate application list;
taking the locked exchange rate application list as a reference, and performing temporary estimation profit and loss calculation on the locked exchange rate application list in a locked exchange rate period to output temporary estimation information;
and when the locked exchange rate is expired, acquiring transaction information, settling the transaction information and outputting posting information.
2. The method according to claim 1, wherein the step of performing tentative estimation profit-and-loss calculation on the lock exchange rate application list during a lock exchange rate period based on the lock exchange rate application list to output tentative estimation information comprises:
calculating the tentatively estimated amount of money according to the invoice exchange rate and the lock exchange rate;
and carrying out tentatively estimated posting processing according to the tentatively estimated amount, and outputting a tentatively estimated voucher.
3. The method for automatically calculating the exchange rate loss according to claim 1, wherein the step of acquiring transaction information when the exchange rate loss expires, performing settlement processing on the transaction information, and outputting posting information comprises:
carrying out leveling judgment processing according to the transaction information;
and (4) calculating the profit and loss amount according to the flat warehouse judgment, finishing settlement processing and outputting posting information.
4. The method according to claim 1, wherein the obtaining a lock exchange rate request form, processing the lock exchange rate request form, and outputting a lock exchange rate request list comprises:
and acquiring a locked exchange rate application form, filling the original information into the locked exchange rate application form for processing, and outputting a locked exchange rate application list.
5. An apparatus for automatically calculating lockstep profit and loss, comprising:
the acquisition module acquires a locked exchange rate application form, processes the acquired locked exchange rate application form to obtain a locked exchange rate application list;
the temporary estimation module is used for carrying out temporary estimation profit and loss calculation on the locking exchange rate application list in the locking exchange rate period by taking the locking exchange rate application list as a reference, and outputting temporary estimation information;
and the bill module acquires the transaction information when the locking exchange rate is expired, settles the transaction information and outputs the posting information.
6. The apparatus of claim 5, wherein the temporary estimation module comprises:
the temporary estimated amount unit calculates the temporary estimated amount according to the invoice exchange rate and the lock exchange rate;
and the temporary estimation voucher unit is used for carrying out temporary estimation posting processing according to the temporary estimation amount and outputting a temporary estimation voucher.
7. The apparatus of claim 5, wherein the billing module comprises:
the leveling judgment unit is used for carrying out leveling judgment processing according to the transaction information;
and the posting information unit is used for judging and calculating the profit and loss amount according to the flat bin, finishing settlement processing and outputting posting information.
8. An electronic device comprising a memory and a processor, the memory configured to store one or more computer instructions, wherein the one or more computer instructions are executable by the processor to implement a method of automatically calculating a lockexchange rate profit-and-loss as recited in any one of claims 1-4.
9. A computer-readable storage medium having a computer program stored thereon, wherein the computer program is configured to cause a computer to perform a method of automatically calculating a lock exchange rate profit or loss according to any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911385389.5A CN111127018A (en) | 2019-12-28 | 2019-12-28 | Method for automatically calculating locked exchange rate profit and loss |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911385389.5A CN111127018A (en) | 2019-12-28 | 2019-12-28 | Method for automatically calculating locked exchange rate profit and loss |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111127018A true CN111127018A (en) | 2020-05-08 |
Family
ID=70504201
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911385389.5A Pending CN111127018A (en) | 2019-12-28 | 2019-12-28 | Method for automatically calculating locked exchange rate profit and loss |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111127018A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101964104A (en) * | 2009-07-22 | 2011-02-02 | 中国工商银行股份有限公司 | Financial product risk inspection method and system |
| CN103299333A (en) * | 2010-07-13 | 2013-09-11 | 埃姆-数据采集私人有限公司 | Method and system of trading a security in a foreign currency |
| CN104951976A (en) * | 2014-03-26 | 2015-09-30 | 金蝶软件（中国）有限公司 | System and method for obtaining exchange gains/losses during bill verification |
| CN110033372A (en) * | 2019-02-19 | 2019-07-19 | 阿里巴巴集团控股有限公司 | A kind of method, system and equipment optimizing transaction cost |
| CN110473107A (en) * | 2019-08-26 | 2019-11-19 | 北京三快在线科技有限公司 | Transaction data processing method, device, equipment and storage medium |
-
2019
- 2019-12-28 CN CN201911385389.5A patent/CN111127018A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101964104A (en) * | 2009-07-22 | 2011-02-02 | 中国工商银行股份有限公司 | Financial product risk inspection method and system |
| CN103299333A (en) * | 2010-07-13 | 2013-09-11 | 埃姆-数据采集私人有限公司 | Method and system of trading a security in a foreign currency |
| CN104951976A (en) * | 2014-03-26 | 2015-09-30 | 金蝶软件（中国）有限公司 | System and method for obtaining exchange gains/losses during bill verification |
| CN110033372A (en) * | 2019-02-19 | 2019-07-19 | 阿里巴巴集团控股有限公司 | A kind of method, system and equipment optimizing transaction cost |
| CN110473107A (en) * | 2019-08-26 | 2019-11-19 | 北京三快在线科技有限公司 | Transaction data processing method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8429068B1 (en) | Data aggregation for transaction banking partnerships | |
| US20120078790A1 (en) | Real-time interchange fee estimation | |
| US20130117159A1 (en) | Transaction platform data processing method and system | |
| CN106779562A (en) | A trading platform-based proxy procurement system and method | |
| US20180330351A1 (en) | System and method for allocating charges away from a tax account | |
| US12321993B1 (en) | Automated systems and methods for an electronic ledger | |
| CN107730390B (en) | Data processing method and device, computer readable medium and electronic equipment | |
| KR102141848B1 (en) | Loan system for paying in advance electronic payment sales of small business owners in real time | |
| CN112184418A (en) | Inter-company loan processing method, inter-company loan processing device, computer equipment and storage medium | |
| CN116228381A (en) | Payment payment method, device, computer equipment and readable storage medium | |
| CN118537153B (en) | Account reconciliation method, device, system, storage medium and program product | |
| AU2007240205A1 (en) | Automated Reconciliation of Transaction Records | |
| EP4246406A1 (en) | Method and apparatus for facilitating merchant cash advances on the basis of forecasted return volume | |
| KR102160676B1 (en) | Card sales win-win managing and calculating system for small business owners | |
| CN119444389A (en) | Method, device, equipment and storage medium for generating accounting vouchers | |
| CN115456747B (en) | Automatic intelligent account settling method and device for ERP system and storage medium | |
| CN111127018A (en) | Method for automatically calculating locked exchange rate profit and loss | |
| CN111967987B (en) | Transaction data processing method and transaction data processing system | |
| CN115526721A (en) | Method, device, medium and computer program product for automatically checking dynamic limit | |
| CN109636406B (en) | Resource settlement method and device and electronic equipment | |
| CN110827161A (en) | Policy handling fee management method, device, medium and electronic equipment | |
| KR20200042817A (en) | Card sales win-win managing and calculating method for small business owners | |
| TWI811004B (en) | System and method for automatically checking finance | |
| CN116362776A (en) | Asset scrapped damage calculation method, device, equipment and storage medium | |
| Yetter et al. | No Excuses: Automation Advances Make Sales Tax Collection Easier for Everyone |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200508 |
|
| RJ01 | Rejection of invention patent application after publication |