Compare Statement Accounts Utility (Stmnt-Acct-Compare.p)

 

The Compare Statement Accounts Utility allows a user to compare the accounts in a range of rows for two different statements. For example, if you have one statement that should be pulling in the same amount as another statement, but the amounts between the two statements differ, you can run this utility to compare a range of rows in each statement. The utility will display to the screen a list of the accounts that are different between the two statements. You also have the option of printing this list out.

1) Access from the main General Ledger screen >Statements> Utilities >Analysis and select the  button.

 

2) The Statement Compare Utility screen will appear. You will be required to enter in the Statements and the rows in each that you would like to compare.

 

Outlined below is an explanation of each field. Use these to guide you through the entry screen above.
Stmnt 1:

Click on  and select the Row Code for the Statement you wish to compare.

From Row Seq:

Click on  and select the first Row Sequence in the range that you wish to compare.

Thru Row Seq:

Click on  and select the last Row Sequence in the range that you wish to compare.

Stmt 2:

Click on  and select the Row Code for the statement you wish to compare to the first statement you selected above.

From Row Seq:

Click on  and select the first Row Sequence in the range that you wish to compare.

Thru Row Seq:

Click on  and select the last Row Sequence in the range that you wish to compare.

Form/Queue

The system will automatically default to Lists / Lists, and the report will print Portrait. However, if you wish the report to print Landscape, you may select a different Form / Queue.

Once you have made your selections, press F2 to continue.

 

4) The utility will generate a report that lists the Accounts in Statement 1, but not in Statement 2 AND Accounts in Statement 2, but not in Statement. You may view the report on the screen and/or print it to your printer.

 

Sample Report