METHOD FOR DETERMINISTIC RECONCILIATION AND MATCHING OF PAYMENTS WITH ACCOUNTS RECEIVABLE
A computer implemented method to implement deterministic reconciliation and matching of payments with accounts receivable revenue for a donation management system. The method includes receiving actual payment information from a fundraising system, determining a set of donations, installments, and fund allocations affected by the actual payment information, matching the actual payment information against the set of donations, installments, and fund allocations, and adjusting recorded revenue amounts for at least one fund allocation record and payment record, in response to mismatching of the actual payment information against the set of opportunities, installments, and fund allocations in at least one database of an accounting management system.
1 . A computer implemented method of deterministic reconciliation and matching of payments with accounts receivable revenue for a donation management system, the method comprising:
receiving actual payment information from a fundraising system;
determining a set of donations, installments, and fund allocations affected by the actual payment information;
matching the actual payment information against the set of donations, installments, and fund allocations; and
adjusting recorded revenue amounts for at least one fund allocation record and payment record, in response to mismatching of the actual payment information against the set of donations, installments, and fund allocations in at least one database of an accounting management system.
2 . The method of claim 1 , further comprising:
determining whether the actual payment information indicates an allocation change to funds of a donation.
3 . The method of claim 1 , further comprising:
adjusting revenue allocated to each fund associated with a donation in response to a difference in payment amount.
4 . The method of claim 1 , wherein the actual payment includes a negative amount, further comprising:
creating a Payment Transaction Ledger Entry (PaTLE) and at least one Pledge Allocation Payment Ledger Entry (PAPLE) to indicate a negation of previously received payments.
5 . The method of claim 1 , further comprising:
constructing a mapping of expected payments, received? payments, fund allocations and installments.
6 . The method of claim 1 , further comprising:
generating a set of positive and negative Payment Transaction Ledger Entries (PaTLEs) and Pledge Allocation Payment Ledger Entries (PAPLEs) that describe actual payments, allocations, and portions of revenue satisfied by the actual payments.
7 . The method of claim 1 , further comprising:
reversing recorded revenue records in response to changes in expected revenue based on the actual payment information.
8 . A non-transitory machine-readable storage medium that provides instructions that, if executed by a processor, will cause said processor to perform operations to implement a method of deterministic reconciliation and matching of payments with accounts receivable revenue for a donation management system, the operations comprising:
receiving actual payment information from a fundraising system;
determining a set of donations, installments, and fund allocations affected by the actual payment information;
matching the actual payment information against the set of donations, installments, and fund allocations; and
adjusting recorded revenue amounts for at least one fund allocation record and payment record, in response to mismatching of the actual payment information against the set of donations, installments, and fund allocations in at least one database of an accounting management system.
9 . The non-transitory machine-readable storage medium of claim 8 , the operations further comprise:
determining whether the actual payment information indicates an allocation change to funds of a donation.
10 . The non-transitory machine-readable storage medium of claim 8 , the operations further comprise:
adjusting revenue allocated to each fund associated with a donation in response to a difference in payment amount.
11 . The non-transitory machine-readable medium of claim 8 , wherein the actual payment includes a negative amount, further comprising:
creating a Payment Transaction Ledger Entry (PaTLE) and at least one Pledge Allocation Payment Ledger Entry (PAPLE) to indicate a negation of previously received payments.
12 . The non-transitory machine-readable storage medium of claim 8 , the operations further comprise:
constructing a mapping of expected payments, received? payments, fund allocations and installments.
13 . The non-transitory machine-readable storage medium of claim 8 , the operations further comprise:
generating a set of positive and negative Payment Transaction Ledger Entries (PaTLEs) and Pledge Allocation Payment Ledger Entries (PAPLEs) that describe actual payments, allocations, and portions of revenue satisfied by the actual payments.
14 . The non-transitory machine-readable storage medium of claim 8 , the operations further comprise:
reversing recorded revenue records in response to changes in expected revenue based on the actual payment information.
15 . A computing device in a donation management system, the computing device comprising:
a non-transitory machine-readable storage medium having stored therein a process to Split into Installments, Split into Allocations, Match to recognized revenue, and Reconcile (SISAMAR);
a processor coupled to the non-transitory machine-readable storage medium, the processor to execute the SISAMAR, the SISAMAR to receive actual payment information from a fundraising system, determine a set of donations, installments, and fund allocations affected by the actual payment information, match the actual payment information against the set of donations, installments, and fund allocations, and adjust recorded revenue amounts for at least one fund allocation record and payment record, in response to mismatching of the actual payment information against the set of donations, installments, and fund allocations in at least one database of an accounting management system.
16 . The computing device of claim 15 , wherein the SISAMAR is further to determine whether the actual payment information indicates an allocation change to funds of a donation.
17 . The computing device of claim 15 , wherein the SISAMAR is further to adjust revenue allocated to each fund associated with a donation in response to a difference in payment amount.
18 . The computing device of claim 15 , wherein the actual payment includes a negative amount, the SISAMAR to further create a Payment Transaction Ledger Entry (PaTLE) and at least one Pledge Allocation Payment Ledger Entry (PAPLE) to indicate a negation of previously received payments.
19 . The computing device of claim 15 , wherein the SISAMAR is further to construct a mapping of expected payments, received? payments, fund allocations and installments.
20 . The computing device of claim 15 , wherein the SISAMAR is further to generate a set of positive and negative Payment Transaction Ledger Entries (PaTLEs) and Pledge Allocation Payment Ledger Entries (PAPLEs) that describe actual payments, allocations, and portions of revenue satisfied by the actual payments.
21 . The computing device of claim 15 , wherein the SISAMAR is further to reverse recorded revenue records in response to changes in expected revenue based on the actual payment information.