A method of detecting duplicate payments, the method comprising:
- providing a user interface to a display device of a user device associated with a user, the user interface to receive a first payment attribute via a first user input, a second payment attribute via a second user input, and a third user input selecting an input option to submit a payment request corresponding to the first payment attribute and the second payment attribute;
- establishing, via a network interface, a secure encrypted communication session with the user device over a network, the network interface to communicate with a provider computing system and the user device via a cryptographic method, the provider computing system including a memory, at least one processor, a filtering circuit, and a comparison circuit, the memory storing instructions that are executable by the at least one processor;
- receiving, from the user device via the secure encrypted communication session, the first payment attribute associated with the first user input and a second payment attribute associated with the second user input, the first user input and the second user input indicating the user's desire to transfer funds from an account held by the user with an accounts provider, wherein receiving the first payment attribute and the second payment attribute occurs prior to receiving the third user input to submit the payment request and does not comprise submitting the payment request to a provider computing system for processing over the network;
- retrieving, based on receiving at least one of the first payment attribute and the second payment attribute, a subset of a plurality of first rules to apply to a first database to retrieve a first plurality of payment records, the subset of the plurality of first rules varying according to an account type associated with a first requested payment records, wherein the first plurality of payment records is a subset of payment records stored in the first database;
- selectively retrieving, based on the retrieved subset of the plurality of first rules, a first plurality of payment records from a first database associated with the provider computing system by applying at least a first rule to retrieve processed payments, a second rule to retrieve pending payments, and a third rule to retrieve schedule payments, wherein the plurality of first rules are specific to the first database;
- performing, by the comparison circuit of the provider computing system, a first comparison to determine if the first payment attribute and the second payment attribute represent an exact duplicate payment request, wherein performing the first comparison comprises comparing the first payment attribute and the second payment attribute to one or more attributes of each of the retrieved first plurality of payment records;
- retrieving, based receiving on at least one of the first payment attribute and the second payment attribute and in response to determining that the first payment attribute and the second payment attribute do not represent an exact duplicate payment request, a subset of a plurality of second rules to apply to a second database that is external to the provider computing system to retrieve a second plurality of payment records, the subset of the plurality of second rules varying according to an account type associated with a second requested payment record, wherein the second plurality of payment records is a subset of payment records stored in the second database;
- selectively retrieving, via a second secure encrypted communication session with the database based on the retrieved subset of the second plurality of second rules, the second plurality of payment records from the second database by applying at least a fourth rule to retrieve future payments, wherein the plurality of second rules are specific to the second database and different from the plurality of first rules;
- in response to determining that the first payment attribute and the second payment attribute do not represent an the exact duplicate payment request, filtering, by the filtering circuit of the provider computing system and based on a type of payment record in accordance with the plurality of second rules, the second plurality of payment records to exclude one or more payment records from the second plurality of payment records, wherein the type of payment record comprises at least one of a one-time payment, recurring payment, or automatic payment;
- producing by the filtering circuit of the provider computing system, a subset of the filtered second plurality of payment records for a second comparison including an aggregated payment record, wherein the subset of the filtered second plurality of payment records is produced by:
- determining that two or more payment records of the filtered second plurality of payment records are associated with a given time period, wherein each payment record of the subset has a respective payment amount;
- and
- producing the aggregated payment record by aggregating the payment amounts of the two or more payment records of the filtered second plurality of payment records associated with the time period to create a total payment amount for the two or more payment records of the filtered second plurality of payment records, wherein the total payment amount of the aggregated payment record does not match a single payment record stored on the second database;
- transmitting, from the filtering circuit of the provider computing system to the comparison circuit of the provider computing system, the produced subset of the filtered second plurality of payment records, wherein the produced subset of the filtered second plurality of payment records includes fewer payment records than the second plurality of payment records or the filtered second plurality of payment records;
- performing, by the comparison circuit of the provider computing system, a second comparison, wherein performing the second comparison comprises comparing the first payment attribute and the second payment attribute to one or more attributes of the subset of the filtered second plurality of payment records, wherein at least a first of the one or more attributes of the subset of the filtered second plurality of payment records comprises an aggregated payment amount, and wherein at least a second of the one or more attributes of the subset of the filtered second plurality of payment records comprises a type of the payment record;
- determining, based on the second comparison, if the first payment attribute or the second payment attribute represent is a duplicate payment request with the aggregated payment record;
- in response to determining that the first payment attribute or the second payment attribute represent is a potential duplicate payment request, providing to the user, via the user interface provided to the display device of the user device, a pop-up notification describing the aggregated payment record, the potential duplicate payment request, and a specific payment attribute causing a potential duplicate condition, the pop-up notification comprising the input option to submit the payment request that is temporarily unselectable and grayed out to indicate that the user must change one or more of the first payment attribute and the second payment attribute to submit the payment request, wherein the input option is inoperable until a user input altering the first payment attribute via a first editable field or the second payment attribute via a second editable field is received within the pop-up notification;
- receiving, from the user via the user interface provided to the display device, a user input altering the first payment attribute or the second payment attribute within the pop-up notification, wherein the user input altering the first payment attribute or the second payment attribute alters the payment request such that the payment request is not a potential duplicate payment request of the aggregated payment record;
- allowing, based on the received user input, the user to select the input option to submit the payment request within the pop-up notification;
- submitting, by the network interface based on the user input selecting the input option, the payment request to the provider computing system.