Apparatus, methods, and systems for tracking and accounting for data flow in a loan processing system

A system for auditing loan data, the system comprising:

• one or more databases in which loan origination data and loan payment data are aggregated;
• a data warehouse in which the aggregated loan origination data and loan payment data is normalized into first, second, or third normal form;
• a blockchain that:
• tracks the aggregation of the loan origination data in the one or more databases by creating a first block in the blockchain, the first block having:
• a first trace denoting a borrower and/or loan application from which the loan origination data was obtained;
• and
• a second trace denoting a location in the one or more databases in which the obtained loan origination data was stored upon aggregation;
• tracks the aggregation of the loan payment data in the one or more databases by creating a second block in the blockchain, the second block having:
• a third trace denoting a lender and/or loan statement from which the loan payment data was obtained;
• and
• a fourth trace denoting a location in the one or more databases in which the obtained loan payment data was stored upon aggregation;
• and
• tracks the normalization of the aggregated loan origination data with the aggregated loan payment data, and vice versa, into the first, second, or third normal form in the data warehouse by creating a third block in the blockchain, the third block having:
• a fifth trace denoting the respective locations in the one or more databases from which the aggregated loan origination data and loan payment data were obtained;
• and
• a sixth trace denoting respective locations in the data warehouse in which the obtained aggregated loan origination data and loan payment data were stored upon normalization into the first, second, or third normal form;
• and
• an output device that outputs, in a human-readable format, at least respective portions of the aggregated and normalized loan origination data and loan payment data, together with:
• the first trace;
• the second trace;
• the third trace;
• the fourth trace;
• the fifth trace;
• the sixth trace;
• or
• any combination of the first, second, third, fourth, fifth, and sixth traces.

An apparatus for auditing loan data, the apparatus comprising:

• a non-transitory computer readable medium;
• and
• a plurality of instructions stored on the non-transitory computer readable medium and executable by one or more processors, wherein, when the instructions are executed by the one or more processors, the following steps are executed:
• tracking, using a blockchain, an aggregation of loan origination data in one or more databases by creating a first block in the blockchain, the first block having:
• a first trace denoting a borrower and/or loan application from which the loan origination data was obtained;
• and
• a second trace denoting a location in the one or more databases in which the obtained loan origination data was stored upon aggregation;
• tracking, using the blockchain, an aggregation of loan payment data in the one or more databases by creating a second block in the blockchain, the second block having:
• a third trace denoting a lender and/or loan statement from which the loan payment data was obtained;
• and
• a fourth trace denoting a location in the one or more databases in which the obtained loan payment data was stored upon aggregation;
• tracking, using the blockchain, a normalization of the aggregated loan origination data with the aggregated loan payment data, and vice versa, into first, second, or third normal form in a data warehouse by creating a third block in the blockchain, the third block having:
• a fifth trace denoting the respective locations in the one or more databases from which the aggregated loan origination data and loan payment data were obtained;
• and
• a sixth trace denoting respective locations in the data warehouse in which the obtained aggregated loan origination data and loan payment data were stored upon normalization into the first, second, or third normal form;
• and
• outputting, in a human-readable format, at least respective portions of the aggregated and normalized loan origination data and loan payment data, together with:
• the first trace;
• the second trace;
• the third trace;
• the fourth trace;
• the fifth trace
• the sixth trace;
• or
• any combination of the first, second, third, fourth, fifth, and sixth traces.