Multi-source liquidity tracking
In an example, a computer implemented method includes obtaining respective transactional data from each financial data source of a plurality of financial data sources, where the respective transactional data is each associated with a posting time. The method also includes determining a net liquidity amount from the respective transactional data based on the posting time of each of the respective transactional data. The method also includes outputting net liquidity data that is representative of the determined net liquidity amount.
1. A method of processing financial data, the method comprising:
obtaining respective transactional data from each financial account of a plurality of financial accounts, wherein the respective transactional data from a given financial account comprises one or more transactions each associated with a posting time to the given financial account, and wherein the posting time of a transaction to the given financial account comprises a time at which a value of the transaction is applied to outstanding debts or credits of the given financial account;
determining a net liquidity amount for one or more of the financial accounts at a given time based on posting times of the transactions included in the respective transactional data from the one or more of the financial accounts, wherein determining the net liquidity amount for the given financial account comprises:
determining that a first transaction included in the respective transaction data obtained from the given financial account has a first posting time prior to the given time,
determining that a second transaction included in the respective transaction data obtained from the given financial account has a second posting time after the given time, and
determining the net liquidity amount for the given financial account at the given time by including a first value of the first transaction and not including a second value of the second transaction; and
outputting net liquidity data that is representative of the determined net liquidity amount for the one or more of the financial accounts at the given time, wherein the net liquidity data comprises a reporting format that satisfies net liquidity reporting requirements.
2. The method of claim 1 , wherein determining the net liquidity amount comprises aggregating the respective transactional data from the one or more of the financial accounts.
3. The method of claim 1 , wherein obtaining the respective transactional data comprises obtaining respective intraday transactional data, and wherein determining the net liquidity amount comprises determining an intraday net liquidity amount.
4. The method of claim 1 , further comprising:
determining a threshold liquidity amount;
comparing the determined net liquidity amount to the threshold liquidity amount; and
outputting an alert based on the comparison of the determined net liquidity amount to the threshold liquidity amount.
5. The method of claim 4 , wherein determining the threshold liquidity amount comprises determining an intraday threshold liquidity amount.
6. The method of claim 1 , wherein obtaining the respective transactional data and determining the net liquidity amount occurs in real time or near real time.
7. The method of claim 1 , wherein obtaining the respective transactional data comprises obtaining transactional data from each of two or more of a federal securities account, a payment broker account, an international funds account, a check debit account, a check credit account, or an automated clearing house account.
8. The method of claim 1 , wherein obtaining the respective transactional data comprises obtaining unconverted transactional data having a plurality of file formats, the method further comprising converting the unconverted transactional data to a single format and storing the data to a memory in the single format.
9. The method of claim 1 , wherein outputting the net liquidity data that is representative of the determined net liquidity amount comprises generating a graph that includes the determined net liquidity amount.
10. The method of claim 1 , further comprising:
determining a subcategory of transactional data from the respective transactional data; and
outputting an indication of the subcategory of transactional data.
11. The method of claim 10 , further comprising:
determining a threshold subcategory amount;
aggregating data from the subcategory of transactional data to generate an aggregate subcategory amount;
comparing the aggregate subcategory amount to the threshold subcategory amount; and
outputting an alert based on the comparison of the aggregate subcategory amount to the threshold subcategory amount.
12. A computing device comprising:
a memory configured to store respective transactional data from each financial account of a plurality of financial accounts; and
one or more processors configured to:
obtain the respective transactional data from each financial account of the plurality of financial accounts, wherein the respective transactional data from a given financial account comprises one or more transactions each associated with a posting time to the given financial account, and wherein the posting time of a transaction to the given financial account comprises a time at which a value of the transaction is applied to outstanding debts or credits of the given financial account;
determine a net liquidity amount for one or more of the financial accounts at a given time based on posting times of the transactions included in the respective transactional data from the one or more of the financial accounts, wherein to determine the net liquidity amount for the given financial account, the one or more processors are configured to:
determine that a first transaction included in the respective transaction data obtained from the given financial account has a first posting time prior to the given time,
determine that a second transaction included in the respective transaction data obtained from the given financial account has a second posting time after the given time, and
determine the net liquidity amount for the given financial account at the given time by including a first value of the first transaction and not including a second value of the second transaction; and
output net liquidity data that is representative of the determined net liquidity amount for the one or more of the financial accounts at the given time, wherein the net liquidity data comprises a reporting format that satisfies net liquidity reporting requirements.
13. The computing device of claim 12 , wherein to determine the net liquidity amount, the one or more processors are configured to aggregate the respective transactional data from the one or more of the financial accounts.
14. A non-transitory computer-readable medium having instructions stored thereon that, when executed, cause one or more processors to:
obtain respective transactional data from each financial account of a plurality of financial accounts, wherein the respective transactional data from a given financial account comprises one or more transactions each associated with a posting time to the given financial account, and wherein the posting time of a transaction to the given financial account comprises a time at which a value of the transaction is applied to outstanding debts or credits of the given financial account;
determine a net liquidity amount for one or more of the financial accounts at a given time based on posting times of the transactions included in the respective transactional data from the one or more financial accounts, wherein to determine the net liquidity amount for the given financial account, the instructions further cause the one or more processors to:
determine that a first transaction included in the respective transaction data obtained from the given financial account has a first posting time prior to the given time,
determine that a second transaction included in the respective transaction data obtained from the given financial account has a second posting time after the given time, and
determine the net liquidity amount for the given financial account at the given time by including a first value of the first transaction and not including a second value of the second transaction; and
output net liquidity data that is representative of the determined net liquidity amount for the one or more of the financial accounts at the given time, wherein the net liquidity data comprises a reporting format that satisfies net liquidity reporting requirements.
15. The non-transitory computer-readable medium of claim 14 , wherein to determine the net liquidity amount, the instructions cause the one or more processors to aggregate the respective transactional data from the one or more of the financial accounts.