CN115239500A - Foreign exchange processing method and system - Google Patents
Foreign exchange processing method and system Download PDFInfo
- Publication number
- CN115239500A CN115239500A CN202210928409.4A CN202210928409A CN115239500A CN 115239500 A CN115239500 A CN 115239500A CN 202210928409 A CN202210928409 A CN 202210928409A CN 115239500 A CN115239500 A CN 115239500A
- Authority
- CN
- China
- Prior art keywords
- transaction record
- transaction
- accounting code
- amount
- unit
- 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; CALCULATING OR 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/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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/12—Accounting
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a foreign exchange processing method and a foreign exchange processing system, which can be applied to the fields of finance and business processing. The invention can obtain a transaction record set to be processed; the transaction record set comprises at least one transaction record, each transaction record comprises account information, transaction amount and exchange rate, and the account information of each transaction record comprises an accounting code; acquiring a preset foreign exchange accounting code group, wherein the foreign exchange accounting code group consists of at least one foreign exchange accounting code; searching each transaction record with the accounting code being the foreign exchange accounting code from the transaction record set; determining each transaction record with the accounting code as the foreign exchange accounting code as a target transaction record; and carrying out foreign exchange summarization based on the transaction amount and the exchange rate of each transaction record in the target transaction record, and determining the final summarized amount. The invention can realize the summarizing calculation of the amount of the foreign exchange without manual calculation, effectively reduces the manpower consumption and improves the summarizing efficiency.
Description
Technical Field
The invention relates to the field of finance and business processing, in particular to a foreign exchange processing method and system.
Background
With the progress of the globalization of economy, the communication between countries is increasingly close, and the number of foreign exchange transactions is increasing.
In which, if there is an open foreign exchange in a financial institution such as a bank, the change of the exchange rate may bring economic loss to the financial institution, forming an exchange rate risk. In this regard, the financial institution needs to collect the foreign exchange transaction amount and make a transfer of the foreign exchange according to the collected finance.
However, the current collection of the foreign exchange transaction amount is completed by manual calculation, and the efficiency is low.
Disclosure of Invention
In view of the above problems, the present invention provides a method and a system for processing foreign exchange, which overcome the above problems or at least partially solve the above problems, and the technical solution is as follows:
a method of foreign exchange processing, comprising:
obtaining a transaction record set to be processed; the transaction record set comprises at least one transaction record, each transaction record comprises account number information, transaction amount and exchange rate, and the account number information of each transaction record comprises an accounting code;
obtaining a preset foreign exchange accounting code group, wherein the foreign exchange accounting code group consists of at least one foreign exchange accounting code;
searching each transaction record with an accounting code as a foreign currency accounting code from the transaction record set;
determining each transaction record with the accounting code as the foreign exchange accounting code as a target transaction record;
and carrying out foreign exchange summarization based on the transaction amount and the exchange rate of each transaction record in the target transaction record, and determining the final summarized amount.
Optionally, the account information in each transaction record is composed of multiple characters, and the characters in the order of the preset position in the account information are accounting codes; said searching each said transaction record whose accounting code is a foreign exchange accounting code from said transaction record set comprises:
for any of the transaction records in the set of transaction records: determining characters in a preset position sequence in account information of the transaction record as an accounting code of the transaction record, determining whether the accounting code of the transaction record is included in the foreign exchange accounting code group, and if so, determining the transaction record as the transaction record with the accounting code as the foreign exchange accounting code.
Optionally, the performing of the foreign exchange aggregation based on the transaction amount and the exchange rate of each transaction record in the target transaction record includes:
in the target transaction record, summing transaction amounts in the transaction records with exchange rates of 1 to obtain a first sum amount;
in the target transaction record, respectively carrying out exchange rate conversion calculation on transaction amounts in the transaction records with exchange rates different from 1 to obtain corresponding converted amounts, and summing the obtained converted amounts to obtain a second sum amount;
summing the first and second aggregate amounts;
the determining a final aggregate amount includes:
determining a sum obtained by summing the first and second aggregate amounts as the final aggregate amount.
Optionally, in the target transaction record, performing exchange rate conversion calculation on the transaction amount in each transaction record with an exchange rate different from 1 respectively, includes:
for any of the target transaction records: and carrying out exchange rate conversion calculation on the transaction amount in the transaction record based on the exchange rate in the transaction record.
Optionally, after the determining the final summary amount, the method for processing foreign exchange further includes:
and if the final summary amount is a positive number, identifying the summary result as the income.
Optionally, after the determining the final summary amount, the method for processing foreign exchange further includes:
and if the final sum is negative, identifying the sum as a loss.
A foreign exchange processing system comprising: the device comprises a first obtaining unit, a second obtaining unit, a first searching unit, a first determining unit, a first summarizing unit and a second determining unit, wherein:
the first obtaining unit is used for obtaining a transaction record set to be processed; the transaction record set comprises at least one transaction record, each transaction record comprises account number information, transaction amount and exchange rate, and the account number information of each transaction record comprises an accounting code;
the second obtaining unit is configured to obtain a preset foreign currency accounting code group, where the foreign currency accounting code group is formed by at least one foreign currency accounting code;
the first searching unit is used for searching each transaction record of which the accounting code is the foreign exchange accounting code from the transaction record set;
the first determining unit is used for determining each transaction record with the foreign exchange accounting code as a target transaction record;
the first summarizing unit is used for summarizing foreign exchanges based on the transaction amount and the exchange rate of each transaction record in the target transaction record;
the second determining unit is used for determining the final sum.
Optionally, the account information in each transaction record is composed of multiple characters, and the characters in the preset position order in the account information are the accounting codes;
the first search unit is configured to, for any one of the transaction records in the transaction record set: determining characters in a preset position sequence in account information of the transaction record as an accounting code of the transaction record, determining whether the accounting code of the transaction record is included in the foreign exchange accounting code group, and if so, determining the transaction record as the transaction record with the accounting code as the foreign exchange accounting code.
Optionally, the first summarizing unit includes: the device comprises a first summing unit, a third obtaining unit, a first calculating unit, a fourth obtaining unit, a second summing unit, a fifth obtaining unit and a third summing unit; wherein:
the first summing unit is used for summing transaction amounts in the transaction records with exchange rates of 1 in the target transaction records;
the third obtaining unit is used for obtaining the first summary amount;
the first calculating unit is used for respectively carrying out exchange rate conversion calculation on the transaction amount in each transaction record with the exchange rate not being 1 in the target transaction record;
the fourth obtaining unit is used for obtaining corresponding converted money amounts;
the second summing unit is used for summing the obtained converted money amounts;
the fifth obtaining unit is used for obtaining a second summary amount;
the third summing unit is configured to sum the first and second aggregate amounts;
the second determination unit is configured to determine a sum obtained by summing the first and second aggregate amounts as the final aggregate amount.
Optionally, the first computing unit is configured to, for any one of the target transaction records: and performing exchange rate conversion calculation on the transaction amount in the transaction record based on the exchange rate in the transaction record.
Optionally, the foreign exchange processing system further includes: a first identification unit;
the first identification unit is used for identifying the summary result as the profit if the final summary amount is a positive number after the final summary amount is determined.
Optionally, the foreign exchange processing system further includes: a second identification unit;
and the second identification unit is used for identifying the summary result as a loss if the final summary amount is a negative number after the final summary amount is determined.
The foreign exchange processing method and the system can obtain a transaction record set to be processed; the transaction record set comprises at least one transaction record, each transaction record comprises account information, transaction amount and exchange rate, and the account information of each transaction record comprises an accounting code; obtaining a preset foreign exchange accounting code group, wherein the foreign exchange accounting code group consists of at least one foreign exchange accounting code; searching each transaction record with the accounting code being the foreign exchange accounting code from the transaction record set; determining each transaction record of which the accounting code is the foreign currency accounting code as a target transaction record; and carrying out foreign exchange aggregation based on the transaction amount and the exchange rate of each transaction record in the target transaction record, and determining the final aggregated amount. The invention can realize the summarizing calculation of the amount of the foreign exchange without manual calculation, effectively reduces the manpower consumption and improves the summarizing efficiency.
The foregoing description is only an overview of the technical solutions of the present invention, and the following detailed description of the present invention is provided to enable the technical means of the present invention to be more clearly understood, and to enable the above and other objects, features, and advantages of the present invention to be more clearly understood.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
Fig. 1 is a flowchart illustrating a first method for processing foreign currencies according to an embodiment of the present invention;
FIG. 2 is a flow chart illustrating a third method for foreign exchange processing according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram illustrating a foreign exchange processing system according to an embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the invention are shown in the drawings, it should be understood that the invention can be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the invention to those skilled in the art.
As shown in fig. 1, the present embodiment proposes a first foreign exchange processing method, which may include the following steps:
s101, obtaining a transaction record set to be processed; the transaction record set comprises at least one transaction record, each transaction record comprises account information, transaction amount and exchange rate, and the account information of each transaction record comprises an accounting code;
specifically, the transaction record set may include transaction records for recording foreign exchange transactions, and may also include transaction records for recording non-foreign exchange transactions.
Specifically, each transaction record may store account information, transaction amount, and exchange rate.
It is understood that the exchange rate may be less than 1, equal to 1, or greater than 1. When the exchange rate is equal to 1, the currency used for the transaction may be Renminbi.
The account information of each transaction record may include an accounting code. The audit code may be a transaction record identifying whether the transaction record is a foreign exchange transaction.
S102, obtaining a preset foreign exchange accounting code group, wherein the foreign exchange accounting code group is composed of at least one foreign exchange accounting code;
the foreign currency accounting code can be an accounting code for performing foreign currency transaction.
Specifically, the foreign exchange accounting code group may be preset by the staff. The set of foreign currency accounting codes may include a plurality of foreign currency accounting codes.
S103, searching each transaction record with the accounting code being the foreign exchange accounting code from the transaction record set;
specifically, after the transaction record set and the foreign exchange accounting code group are obtained, each transaction record with the accounting code as the foreign exchange accounting code can be found from the transaction record set.
S104, determining each transaction record with the accounting code as the foreign exchange accounting code as a target transaction record;
specifically, the invention can determine all transaction records with the accounting code as the foreign exchange accounting code as the target transaction record. For example, if the transaction record set includes a first transaction record, a second transaction record, and a third transaction record, the accounting codes in the first transaction record and the second transaction record are both the foreign exchange accounting codes, and the accounting code in the third transaction record is not the foreign exchange accounting code, the invention may determine the first transaction record and the second transaction record as the target transaction record.
S105, carrying out foreign exchange summarization based on the transaction amount and the exchange rate of each transaction record in the target transaction record;
specifically, the method and the device can perform exchange rate conversion calculation on the transaction amount of each transaction record respectively based on the transaction amount and the exchange rate of each transaction record in the target transaction record after the target transaction record is determined, convert the transaction amount of each transaction record into the amount of the same currency, such as Renminbi (RMB), obtain the converted amount of each transaction record, and then perform summary calculation on the converted amount of each transaction record.
And S106, determining the final sum.
Specifically, the invention can sum the converted sum of each transaction record in the target transaction record to obtain the sum, and determine the sum as the final sum.
Optionally, in another foreign exchange processing method proposed in this embodiment, after step S106, the method may further include:
if the final summary amount is positive, the summary result is identified as revenue.
Specifically, if the final sum is greater than 0, the method can determine that the current foreign exchange transaction obtains a profit, identify the summarized result as the profit, and realize automatic identification of the summarized result.
Optionally, in another foreign exchange processing method proposed in this embodiment, after step S106, the method may further include:
if the final summary amount is negative, the summary result is identified as a deficit.
Specifically, if the final sum is less than 0, the method can determine that the loss occurs in the current foreign exchange transaction, identify the summary result as the loss, and realize automatic identification of the summary result.
It should be noted that the present invention can be applied to the financial field and the business processing field.
It should be noted that, by executing steps S101 to S106, the present invention can realize the summary calculation of the foreign exchange transaction amount without manual calculation, thereby effectively reducing the manpower consumption and improving the summary efficiency.
The foreign exchange processing method provided by the embodiment can obtain a transaction record set to be processed; the transaction record set comprises at least one transaction record, each transaction record comprises account information, transaction amount and exchange rate, and the account information of each transaction record comprises an accounting code; acquiring a preset foreign exchange accounting code group, wherein the foreign exchange accounting code group consists of at least one foreign exchange accounting code; searching each transaction record with the accounting code being the foreign exchange accounting code from the transaction record set; determining each transaction record with the accounting code as the foreign exchange accounting code as a target transaction record; and carrying out foreign exchange aggregation based on the transaction amount and the exchange rate of each transaction record in the target transaction record, and determining the final aggregated amount. The invention can realize the summarizing calculation of the amount of the foreign exchange without manual calculation, effectively reduces the manpower consumption and improves the summarizing efficiency.
Based on fig. 1, the present embodiment proposes a second foreign exchange processing method. In the method, account information in each transaction record is composed of multiple characters, and the characters in a preset position sequence in the account information are accounting codes; at this time, step S103 may include:
for any transaction record in the set of transaction records: determining characters in the preset position sequence in the account information of the transaction record as an accounting code of the transaction record, determining whether the accounting code group of the foreign exchange comprises the accounting code of the transaction record, and if so, determining the transaction record as the transaction record with the accounting code as the foreign exchange accounting code.
Specifically, the accounting codes may be characters in a specified position order in the account information. For example, when the account information includes 26-digit characters, the accounting code may be the 13 th to 16 th digit characters in the order of the account information.
Specifically, if the accounting code in a certain transaction record does not exist in the foreign exchange accounting code group, the present invention can prohibit the transaction record from being determined as the transaction record with the accounting code being the foreign exchange accounting code.
It should be noted that the invention can effectively realize the search of the transaction record of which the accounting code is the foreign exchange accounting code, and ensure the realization of the subsequent summary calculation.
The foreign exchange processing method provided by the embodiment can effectively search the transaction record of which the accounting code is the foreign exchange accounting code, and ensure the realization of the subsequent summary calculation.
Based on fig. 1, as shown in fig. 2, the present embodiment proposes a third foreign exchange processing method. In the method, step S105 may include steps S201, S202, S203, S204, S205, S206, and S207, and step S106 may be step S208; wherein:
s201, in the target transaction record, summing transaction amounts in the transaction records with exchange rate of 1;
it is understood that, when the exchange rate is 1, it can be said that the transaction is performed by using the currency, such as Renminbi; when the exchange rate is not 1, it can be said that the transaction is performed using a foreign currency.
Specifically, the present invention may first divide the target transaction record into transaction records with an exchange rate of 1 and transaction records with an exchange rate of not 1.
Specifically, the invention can sum up the transaction amounts in the transaction records with the exchange rate of 1 in advance.
S202, obtaining a first summary amount;
the first sum is a sum obtained by summing up the transaction amounts in the transaction records with the exchange rate of 1.
S203, in the target transaction record, respectively carrying out exchange rate conversion calculation on the transaction amount in each transaction record with the exchange rate not being 1;
specifically, the invention can respectively perform exchange rate conversion calculation on each transaction record with exchange rate not 1 in the target transaction record.
Specifically, step S203 may include:
for any of the target transaction records: and carrying out exchange rate conversion calculation on the transaction amount in the transaction record based on the exchange rate in the transaction record.
S204, obtaining corresponding converted money amounts;
specifically, the converted amount may be an amount obtained by performing rate conversion calculation on the transaction amount in a certain transaction record. It should be noted that the present invention can obtain the converted amounts corresponding to different transaction records respectively.
It will be appreciated that each converted amount is of the same currency, such as Renminbi.
S205, summing the obtained converted money amounts;
specifically, the present invention may sum each converted amount after obtaining each converted amount.
S206, obtaining a second sum;
and the second sum is the sum obtained by summing the converted sums.
S207, summing the first sum and the second sum;
specifically, the present invention may further sum the first and second summarized amounts after obtaining the first and second summarized amounts.
And S208, determining the sum obtained by summing the first sum and the second sum as a final sum.
It should be noted that, in the present invention, through steps S201 to S208, the accuracy of the foreign exchange summarizing calculation can be effectively ensured, so as to effectively ensure the realization of the foreign exchange summarizing calculation.
The foreign exchange processing method provided by the embodiment can effectively ensure the accuracy of the foreign exchange summarizing calculation, thereby effectively ensuring the realization of the foreign exchange summarizing calculation.
Corresponding to the method shown in fig. 1, as shown in fig. 3, the present embodiment provides a foreign exchange processing system. The foreign exchange processing system may include: a first obtaining unit 101, a second obtaining unit 102, a first searching unit 103, a first determining unit 104, a first summarizing unit 105, and a second determining unit 106, wherein:
a first obtaining unit 101, configured to obtain a transaction record set to be processed; the transaction record set comprises at least one transaction record, each transaction record comprises account information, transaction amount and exchange rate, and the account information of each transaction record comprises an accounting code;
specifically, the transaction record set may include transaction records for recording foreign exchange transactions, and may also include transaction records for recording non-foreign exchange transactions.
Specifically, account information, transaction amount and exchange rate may be correspondingly stored in each transaction record.
It is understood that the exchange rate may be less than 1, equal to 1, or greater than 1. When the exchange rate is equal to 1, the currency used for the transaction may be renminbi.
The account information of each transaction record may include an accounting code. The audit code may be a transaction record identifying whether the transaction record is a foreign exchange transaction.
A second obtaining unit 102, configured to obtain a preset foreign currency accounting code group, where the foreign currency accounting code group is formed by at least one foreign currency accounting code;
the foreign currency accounting code can be an accounting code for performing foreign currency transaction.
Specifically, the foreign exchange accounting code group may be preset by the staff. The set of foreign currency accounting codes may include a plurality of foreign currency accounting codes.
The first searching unit 103 is used for searching each transaction record of which the accounting code is the foreign exchange accounting code from the transaction record set;
specifically, after the transaction record set and the foreign exchange accounting code group are obtained, each transaction record with the accounting code as the foreign exchange accounting code can be found from the transaction record set.
A first determining unit 104, configured to determine each transaction record with the accounting code being the foreign exchange accounting code as a target transaction record;
specifically, the invention can determine all transaction records with the accounting code as the foreign exchange accounting code as the target transaction record. For example, if the transaction record set includes a first transaction record, a second transaction record, and a third transaction record, the accounting codes in the first transaction record and the second transaction record are both the foreign exchange accounting codes, and the accounting code in the third transaction record is not the foreign exchange accounting code, the invention may determine the first transaction record and the second transaction record as the target transaction record.
A first summarizing unit 105, configured to summarize foreign exchanges based on the transaction amount and the exchange rate of each transaction record in the target transaction record;
specifically, after the target transaction record is determined, the exchange rate conversion calculation is performed on the transaction amount of each transaction record respectively based on the transaction amount and the exchange rate of each transaction record in the target transaction record, the transaction amount of each transaction record is converted into the amount of the same currency, such as RMB currency, the converted amount of each transaction record is obtained, and then the converted amount of each transaction record is subjected to summary calculation.
A second determination unit 106 for determining the final aggregated amount.
Specifically, the invention can sum the converted sum of each transaction record in the target transaction record to obtain the sum, and determine the sum as the final sum.
Optionally, in the other foreign exchange processing system provided in this embodiment, the method may further include: a first identification unit;
and the first identification unit is used for identifying the summarized result as the income if the final summarized amount is a positive number after the final summarized amount is determined.
Specifically, if the final sum is greater than 0, the method can determine that the current foreign exchange transaction obtains income, identify the summarized result as income, and realize automatic identification of the summarized result.
Optionally, in other foreign exchange processing systems provided in this embodiment, the foreign exchange processing system may further include: a second identification element;
and the second identification unit is used for identifying the summary result as a loss if the final summary amount is a negative number after the final summary amount is determined.
Specifically, if the final sum is less than 0, the method can determine that the loss occurs in the current foreign exchange transaction, identify the summary result as the loss, and realize automatic identification of the summary result.
It should be noted that, according to the present invention, by using the first obtaining unit 101, the second obtaining unit 102, the first searching unit 103, the first determining unit 104, the first summarizing unit 105, and the second determining unit 106, the summarizing calculation of the foreign exchange transaction amount can be implemented, manual calculation is not required, manpower consumption is effectively reduced, and summarizing efficiency is improved.
The foreign exchange processing system provided by the embodiment can obtain a transaction record set to be processed; the transaction record set comprises at least one transaction record, each transaction record comprises account information, transaction amount and exchange rate, and the account information of each transaction record comprises an accounting code; acquiring a preset foreign exchange accounting code group, wherein the foreign exchange accounting code group consists of at least one foreign exchange accounting code; searching each transaction record with the accounting code being the foreign exchange accounting code from the transaction record set; determining each transaction record with the accounting code as the foreign exchange accounting code as a target transaction record; and carrying out foreign exchange aggregation based on the transaction amount and the exchange rate of each transaction record in the target transaction record, and determining the final aggregated amount. The invention can realize the summarizing calculation of the amount of the foreign exchange without manual calculation, effectively reduces the manpower consumption and improves the summarizing efficiency.
Based on fig. 3, the present embodiment proposes a second foreign exchange processing system. In the system, account information in each transaction record is composed of multiple characters, and the characters in a preset position sequence in the account information are accounting codes; a first lookup unit 103, configured to, for any transaction record in the set of transaction records: determining characters in the preset position sequence in the account information of the transaction record as an accounting code of the transaction record, determining whether the accounting code group of the foreign exchange comprises the accounting code of the transaction record, and if so, determining the transaction record as the transaction record with the accounting code as the foreign exchange accounting code.
Specifically, the accounting codes may be characters in a specified position order in the account information. For example, when the account information includes 26-digit characters, the accounting code may be the 13 th to 16 th digit characters in the order of the account information.
Specifically, if the accounting code in a certain transaction record does not exist in the foreign exchange accounting code group, the present invention can prohibit the transaction record from being determined as the transaction record with the accounting code being the foreign exchange accounting code.
It should be noted that the invention can effectively realize the search of the transaction record of which the accounting code is the foreign exchange accounting code, and ensure the realization of the subsequent summary calculation.
The foreign exchange processing system provided by the embodiment can effectively search the transaction record of which the accounting code is the foreign exchange accounting code, and ensure the realization of the subsequent summary calculation.
Based on fig. 3, the present embodiment proposes a third foreign exchange processing system. In this system, the first aggregation unit 105 includes: the device comprises a first summing unit, a third obtaining unit, a first calculating unit, a fourth obtaining unit, a second summing unit, a fifth obtaining unit and a third summing unit; wherein:
the first summation unit is used for summing the transaction amount in each transaction record with the exchange rate of 1 in the target transaction record;
a third obtaining unit configured to obtain the first summary amount;
the first calculation unit is used for respectively carrying out exchange rate conversion calculation on the transaction amount in each transaction record with the exchange rate not being 1 in the target transaction record;
a fourth obtaining unit configured to obtain respective converted amounts;
a second summing unit for summing the obtained converted amounts;
a fifth obtaining unit configured to obtain the second summary amount;
a third summing unit for summing the first and second summed amounts;
a second determination unit 106 for determining a sum value obtained by summing the first and second sum amounts as a final sum amount.
It is understood that, when the exchange rate is 1, it can indicate that the transaction is performed by using the currency, such as Renminbi; when the exchange rate is not 1, it can be said that the transaction is performed using a foreign currency.
Specifically, the invention can divide the transaction records with the exchange rate of 1 and the transaction records with the exchange rate of not 1 from the target transaction records in advance.
Specifically, the invention can sum the transaction amounts in the transaction records with the exchange rate of 1 in advance.
The first sum is a sum obtained by summing up the transaction amounts in the transaction records with the exchange rate of 1.
Specifically, the invention can respectively perform exchange rate conversion calculation on each transaction record with exchange rate not 1 in the target transaction record.
Optionally, the first computing unit is configured to, for any one of the target transaction records: and performing exchange rate conversion calculation on the transaction amount in the transaction record based on the exchange rate in the transaction record.
Specifically, the converted amount may be an amount obtained by performing rate conversion calculation on the transaction amount in a certain transaction record. It should be noted that the present invention can obtain the converted amounts corresponding to different transaction records respectively.
It will be appreciated that each converted amount is of the same currency, such as Renminbi.
Specifically, the present invention may perform a summation operation on each converted amount after each converted amount is obtained.
And the second sum is the sum obtained by summing the converted sums.
Specifically, the present invention may further sum the first summary amount and the second summary amount after obtaining the first summary amount and the second summary amount.
The foreign exchange processing system provided by the embodiment can effectively ensure the accuracy of the foreign exchange summarizing calculation, thereby effectively ensuring the realization of the foreign exchange summarizing calculation.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrases "comprising a," "8230," "8230," or "comprising" does not exclude the presence of additional identical elements in the process, method, article, or apparatus comprising the element.
The above are merely examples of the present application and are not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement or the like made within the spirit and principle of the present application shall be included in the scope of the claims of the present application.
Claims (10)
1. A method for processing foreign currencies, comprising:
obtaining a transaction record set to be processed; the transaction record set comprises at least one transaction record, each transaction record comprises account number information, transaction amount and exchange rate, and the account number information of each transaction record comprises an accounting code;
obtaining a preset foreign exchange accounting code group, wherein the foreign exchange accounting code group consists of at least one foreign exchange accounting code;
searching each transaction record with an accounting code as a foreign currency accounting code from the transaction record set;
determining each transaction record with the accounting code as the foreign exchange accounting code as a target transaction record;
and carrying out foreign exchange aggregation based on the transaction amount and the exchange rate of each transaction record in the target transaction record, and determining the final aggregated amount.
2. The foreign exchange processing method according to claim 1, wherein the account information in each transaction record is composed of a plurality of characters, and the characters in the account information in a preset position sequence are accounting codes; said searching each said transaction record whose accounting code is a foreign exchange accounting code from said transaction record set comprises:
for any of the transaction records in the set of transaction records: determining characters in a preset position sequence in the account information of the transaction record as an accounting code of the transaction record, determining whether the accounting code group of the transaction record comprises the accounting code of the transaction record, and if so, determining the transaction record as the transaction record with the accounting code as the accounting code.
3. The foreign exchange processing method according to claim 1, wherein the step of performing foreign exchange aggregation based on the transaction amount and the exchange rate of each transaction record in the target transaction record comprises:
in the target transaction record, summing transaction amounts in the transaction records with exchange rates of 1 to obtain a first sum amount;
in the target transaction record, respectively carrying out exchange rate conversion calculation on transaction amounts in the transaction records with exchange rates different from 1 to obtain corresponding converted amounts, and summing the obtained converted amounts to obtain a second sum amount;
summing the first and second aggregate amounts;
the determining a final aggregate amount includes:
determining a sum obtained by summing the first aggregate amount and the second aggregate amount as the final aggregate amount.
4. The foreign exchange processing method according to claim 3, wherein the performing rate conversion calculation on the transaction amount in each transaction record with the exchange rate different from 1 in the target transaction record comprises:
for any of the target transaction records: and carrying out exchange rate conversion calculation on the transaction amount in the transaction record based on the exchange rate in the transaction record.
5. The fx processing method according to claim 1, wherein after the determining of the final summary amount, the fx processing method further comprises:
and if the final sum is a positive number, identifying the sum as the income.
6. The method of claim 1, wherein after the determining the final summary amount, the method further comprises:
and if the final sum is negative, identifying the sum as a loss.
7. A foreign exchange processing system, comprising: the device comprises a first obtaining unit, a second obtaining unit, a first searching unit, a first determining unit, a first summarizing unit and a second determining unit, wherein:
the first obtaining unit is used for obtaining a transaction record set to be processed; the transaction record set comprises at least one transaction record, each transaction record comprises account number information, transaction amount and exchange rate, and the account number information of each transaction record comprises an accounting code;
the second obtaining unit is configured to obtain a preset foreign currency accounting code group, where the foreign currency accounting code group is formed by at least one foreign currency accounting code;
the first searching unit is used for searching each transaction record of which the accounting code is the foreign exchange accounting code from the transaction record set;
the first determining unit is used for determining each transaction record with the foreign exchange accounting code as a target transaction record;
the first summarizing unit is used for summarizing foreign exchanges based on the transaction amount and the exchange rate of each transaction record in the target transaction record;
the second determining unit is used for determining the final sum.
8. The fx processing system according to claim 7, wherein the account information in each transaction record is composed of a plurality of characters, and the characters in the account information in a preset position sequence are accounting codes;
the first searching unit is configured to, for any one of the transaction records in the transaction record set: determining characters in a preset position sequence in account information of the transaction record as an accounting code of the transaction record, determining whether the accounting code of the transaction record is included in the foreign exchange accounting code group, and if so, determining the transaction record as the transaction record with the accounting code as the foreign exchange accounting code.
9. The foreign exchange processing system according to claim 7, wherein the first aggregation unit includes: the device comprises a first summing unit, a third obtaining unit, a first calculating unit, a fourth obtaining unit, a second summing unit, a fifth obtaining unit and a third summing unit; wherein:
the first summation unit is used for summing the transaction amount in each transaction record with the exchange rate of 1 in the target transaction record;
the third obtaining unit is used for obtaining the first summary amount;
the first calculating unit is used for respectively carrying out exchange rate conversion calculation on the transaction amount in each transaction record with the exchange rate not being 1 in the target transaction record;
the fourth obtaining unit is used for obtaining corresponding converted money amounts;
the second summing unit is used for summing the obtained converted money amounts;
the fifth obtaining unit is used for obtaining a second summary amount;
the third summing unit is configured to sum the first and second aggregate amounts;
the second determination unit is configured to determine a sum obtained by summing the first and second aggregate amounts as the final aggregate amount.
10. The fx processing system according to claim 9, wherein the first computing unit is configured to, for any of the target transaction records: and carrying out exchange rate conversion calculation on the transaction amount in the transaction record based on the exchange rate in the transaction record.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210928409.4A CN115239500A (en) | 2022-08-03 | 2022-08-03 | Foreign exchange processing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210928409.4A CN115239500A (en) | 2022-08-03 | 2022-08-03 | Foreign exchange processing method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115239500A true CN115239500A (en) | 2022-10-25 |
Family
ID=83677855
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210928409.4A Pending CN115239500A (en) | 2022-08-03 | 2022-08-03 | Foreign exchange processing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115239500A (en) |
-
2022
- 2022-08-03 CN CN202210928409.4A patent/CN115239500A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111126828A (en) | Knowledge graph-based multilayer fund abnormal flow direction monitoring method | |
| EP1359525A1 (en) | Device for integrating transaction information on finantial transaction | |
| CN101847235A (en) | Be used to optimize system, method and the computer product of financial payment approach | |
| CN102081781A (en) | Finance modeling optimization method based on information self-circulation | |
| US20070255651A1 (en) | Batch processing of financial transactions | |
| CN110245879A (en) | A kind of risk rating method and device | |
| CN112950290A (en) | Mining method and device for economic dependence clients, storage medium and electronic equipment | |
| US11727412B2 (en) | Systems and methods for optimizing transaction authorization request message to reduce false declines | |
| CN113191130A (en) | Bank electronic flow data preprocessing method | |
| CN112365352A (en) | Anti-cash-out method and device based on graph neural network | |
| CN115239500A (en) | Foreign exchange processing method and system | |
| CN110910002A (en) | Account receivable default risk identification method and system | |
| CN114971637A (en) | Risk early warning method, device, equipment and medium | |
| CN112035406A (en) | Conversion processing method of paper capital data file | |
| CN113191872A (en) | Non-standard behavior judgment method based on bank flow balance and balance overlap ratio | |
| CN112508702A (en) | Capital flow direction analysis method, apparatus, electronic device and medium | |
| CN112418600A (en) | Enterprise policy scoring method and system based on index set | |
| CN108765152B (en) | Method and device for generating delivery instruction | |
| CN114240610B (en) | Automatic fund collection method, device, computer equipment and storage medium | |
| CN114004412B (en) | Financial data optimization method based on RPA | |
| KR102308098B1 (en) | An apparatus and method for providing user interfaces of managing transaction information based on automatic matching between accounts receivables and deposit information | |
| CN115168375A (en) | Data updating method and related device | |
| CN115358739A (en) | Information processing method and device | |
| CN113344693A (en) | Method, device and storage medium for charging and deducting based on prediction of account balance | |
| CN111401850A (en) | Method for realizing financial architecture of mapping type accounting without account management |
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 |