Systems and methods for parsing unknown codes obtained from a customizable spreadsheet application interface

An apparatus having a server, the apparatus for providing an interface between a customizable spreadsheet application and a third party financial institution Bank Administration Institute, version 2 (“BAI2”) file-generating application, the server comprising:

• a server storage device;
• a server processor connected to the server storage device, the server storage device storing a server program for controlling the server processor;
• and
• the server processor operative with the server program to:
• receive a BAI2 file from the file-generating institution;
• in response to receiving the BAI2 file, determine whether the third party financial institution associated with the financial institution application is recognized by the server program;
• in response to a determination that the third party financial institution is recognized by the server program, then determine whether any customized codes associated with third party financial institution exist in the BAI2 file;
• in response to a determination that any customized codes associated with the third party financial institution exist in the BAI2 file, determine whether said customized codes have already been interpreted, by the server program;
• and
• in response to a determination that said customized codes have already been interpreted, then parse the BAI2 file.

One or more computer-readable storage media having computer-readable program code embodied in or on the storage media, the code when executed by one or more processors for configuring a computer to execute a method for using a customizable spreadsheet application, the method for interfacing between the customizable spreadsheet application and a third party financial institution application, the method comprising:

• providing an application programming interface (“API”) for use with the spreadsheet, the API that is configured to:
• receive a Bank Administration Institute, version 2 (“BAI2”) file;
• in response to receiving the BAI2 file, query whether the identity of the third party financial institution associated with the financial institution application is recognized by the API;
• in response to a determination that the identity of the third party financial institution is recognized by the API, then query whether any customized codes associated with third party financial institution exist in the BAI2 file;
• in response to a determination that any customized codes associated with the third party financial institution exist in the BAI2 file, determine whether said customized codes have already been associated, by the API, with interpretations;
• in response to a determination that said customized codes have already been associated with interpretations, then parse the BAI2 file based on the interpretations;
• in response to a determination that said customized codes have not already been associated with interpretations;
• then prompt a user to provide a descriptor of each of the customized codes and identify whether each of the customized codes is a credit or debit transaction.