Package Exports
- @nqminds/fin-genie-gl-reconciliator
This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (@nqminds/fin-genie-gl-reconciliator) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.
Readme
Fin Genie General Ledger Reconciliator
This databot groups general ledger entries into transactions. It does this by grouping entries in the general ledger on a few key properties identified by inspection of the data and conversations with NIAO.
Once entries have been grouped into a set of provisional transactions using an aggregate query the following rule is applied to verify if a transaction is "correct":
- The sum of balances for entries within the group must be zero
These rules do not catch all cases of a correct transaction sequence.
PO transactions
Transactions that have a purchase order number may be accurately grouped on this value. These transactions vary greatly in length but can be validated by finding account codes in which activity is non-zero and comparing this with the value found in the corresponding purchase order.
Invoice transactions
Transactions that have an invoice number but no purchase order can be grouped on invoice number. As with PO transactions these vary in length but for each entry there should be an invoice with a matching balance.
Journal transactions
Journal transactions are grouped on journal description, again a check of balances summing to zero is used to verify completeness.