Transnational Transaction Reconciliation by Kevin Rutledge

Required Rock Version
9.4

Documentation
Documentation Link

Support
Support Link

Package Description

How it Works:

Reconciling Transnational Batches with Transactions in Rock and forming a fund activity report for accounting can be a pain of a process. This plugin makes that process signficantly easier.

The plugin will use your NMI gateway to send a webrequest to their servers. Then the response is processed sorted and paneled output is displayed. Each panel shows the NMI batch id, the date(offset using your financial gateway offest), and the fund total.

There are two tabs per batch. The first shows the fund activity for all funds represented in the transactions. The second tab shows the information from transnational and Rock for each transaction in the batch. Once you confirm that everything is right, you can click "Confirm Deposit. This adds the current date to the new entity attribute "Reconciled On".

Once a batch is reconciled, a checkbox appears labeled "Include in Print". Only when this box is checked will the fund activity tab appear on a print out of the page. This way you can be sure that any batches printed have been reconciled and that you only print the batches you want to print.

What is Installed

The following things are installed with this plugin:

• A Financial Transaction Attribute: Reconciled On
• A Lava Webhook in defined types. This checks to see if the person Guid included in the request is in a financial administrator security group or the rock admin security group. You can adjust the webhook to remove these groups or add to them.
• A Lava Shortcode: To run this lava you use the following short code to show the transactions. {[ batchlist daysback:'1' depositaccountname:'Citizens E-Checking' depositaccountglcode:'']} with three parameters:
  • daysback: the number of days to go back. The default is 15, but you can change this depending on your needs. Be aware, that a lot of information is downloaded and processed and the further back you go the longer it will take.
  • depositaccountname: this is the text that appears at the top of each batch and on the fund activity report.
  • depositaccountglcode: for accounting purposes, this is the gl code for the deposit account.
• A page title Transnational Bathes under Financial Adminsitration with the shortcode included in a block on the page.