Method of reconciling credit union corporate accounts

• US 20040030621A1
• Filed: 08/07/2002
• Published: 02/12/2004
• Est. Priority Date: 08/07/2002
• Status: Abandoned Application

• Current Assignee: Keith B. Cobb
• Original Assignee: Keith B. Cobb
• Inventors: Cobb, Keith B.
• Application Number:
  US10/214,806
• Publication Number:
  US 20040030621A1
• Time in Patent Office: Days
• US Class Current: 705/35
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03

Abstract

A method implemented in software form for reconciling a credit union member'"'"'s monthly G/L Statement with the Corporate Statement of a corporate credit union. The method generally comprises the steps of inputting the G/L Statement and the Corporate Statement data, reformatting and indexing the same in a particular manner, and performing a sort routine on the indexed, thereby sorting said data into discrete records according to transaction type. A number of pre-determined reports are available inclusive of those in which each sorted and indexed record from the G/L Statement is compared with a corresponding sorted and indexed record from the Corporate Statement data, inclusive of preliminary reconciliation reports compiled from the matching record(s) and unmatched records. The preliminary reconciliation reports are canvassed for matching errors and, once corrected, final reconciliation reports are output. The segregating and indexing of the above-described method reduces the number of machine code comparisons significantly and speeds processing time.

Claims

1. A method for reconciling a G/L Statement to a Corporate Statement, comprising the steps of:

inputting member credit union transaction statement data and general ledger data;

reformatting said G/L Statement and Corporate Statement to unify the data fields and positions of the fields;

performing an indexing routine on said reformatted G/AL Statement and Corporate Statement and attaching an indicator to line items therein distinguishing as credit or debit, and by transaction type;

performing a sort routine on said reformatted and indexed G/L Statement and Corporate Statement, and thereby sorting said reformatted and indexed data into discrete records;

comparing each sorted and indexed record from the G/L Statement with a corresponding sorted and indexed record from the Corporate Statement and writing each matched transaction to one or more matching records, and writing each unmatched transaction to an unmatched record;

compiling a reconciliation report from said matching records and unmatched record.

2. The method for reconciling a G/L Statement to a Corporate Statement according to claim 1, wherein said step of performing an indexing routine categorizes said line items in any one of eighteen (18) defined transaction types plus a catch-all non-assigned category.

3. The method for reconciling a G/L Statement to a Corporate Statement according to claim 1, wherein said step of reformatting further comprises defining and populating at least the following fields from said G/L Statement and said Corporate Statement:

Transaction Date;

Effective Date;

Description, Debit;

Credit;

Balance.

4. The method for reconciling a G/L Statement to a Corporate Statement according to claim 1, further comprising the step of selectively displaying any one of a group of G/L Statement reports including a credit report, a debit report, a DB posting report, a matched transaction report, a matching debit report, a matching credit report, and an outstanding transaction report.

5. The method for reconciling a G/L Statement to a Corporate Statement according to claim 1, further comprising the step of selectively displaying any one of a group of Corporate Statement reports including a credit report, a debit report, an ADP Tx/fincl report, an Amex Travelers Cheques report, an ARP Settlement report, a Cash Letter Adjust report, a Cash Shipment report, a Currency Trans report, an ECSM Visa report, an EFS/single Point Clear report, an Electrical Present report, an FRB ACH report, a from Shares S91 report, an Incoming Wire report, and a Mixed report.

6. A method for reconciling a G/L Statement to a Corporate Statement, comprising the steps of:

inputting a G/L Statement and a Corporate Statement;

performing an indexing routine on said G/L Statement and Corporate Statement and classifying said line items as credit or debit, and categorizing said line items by transaction type and appending fields thereto in accordance with said categorization and classification;

performing a sort routine on said indexed G/L Statement and Corporate Statement, and thereby sorting said indexed data into discrete records;

comparing each sorted and indexed record from the G/L Statement with a corresponding sorted and indexed record from the Corporate Statement and writing each matched transaction to a matched transaction record, and writing each unmatched transaction to an unmatched transaction record;

compiling a reconciliation report from said matching records and unmatched record.

7. The method for reconciling a G/L Statement to a Corporate Statement according to claim 6, wherein said indexing routine categorizes said line items in any one of eighteen (18) defined categories plus a catch-all non-assigned category.

8. The method for reconciling a G/L Statement to a Corporate Statement according to claim 6, further comprising the step of reformatting said G/L Statement and said Corporate Statement to unify the data fields and positions of the fields.

9. The method for reconciling a G/L Statement to a Corporate Statement according to claim 8, wherein said step of reformatting further comprises defining and populating at least the following fields from said G/L Statement and said Corporate Statement:

Transaction Date;

Effective Date;

Description, Debit;

Credit;

Balance.

10. The method for reconciling a G/L Statement to a Corporate Statement according to claim 6, further comprising the step of selectively displaying any one of a group of G/L Statement reports including a credit report, a debit report, a DB posting report, a matched transaction report, a matching debit report, a matching credit report, and an outstanding transaction report.

11. The method for reconciling a G/L Statement to a Corporate Statement according to claim 6, further comprising the step of selectively displaying any one of a group of Corporate Statement reports including a credit report, a debit report, an ADP Tx/fincl report, an Amex Travelers Cheques report, an ARP Settlement report, a Cash Letter Adjust report, a Cash Shipment report, a Currency Trans report, an ECSM Visa report, an EFS/single Point Clear report, an Electrical Present report, an FRB ACH report, a from Shares S91 report, an Incoming Wire report, and a Mixed report.