The Analysis Process

An example of a payee analysis for a specified time period is demonstrated, step by step, as follows:

A date range has been specified to only include the 4th quarter of year 2000 (From: 10/1/2000 Thru: 12/31/2000).  The "Payee / Description" heading has been clicked, to sort the line items by ascending Payee sequence.  A line item for "ALBERTSONS" (without an apostrophe) has been selected.  Notice that "ALBERTSONS" appears in the "Sort group" field.

The "Sort group" has been clicked, so now only those lines having "ALBERTSONS" in the first 10 characters are displayed.  They are still in Payee sequence.

The highlighted line has been right clicked.  A box with two options has been displayed.

The "Change sort group" has been clicked, either in the box, or the button at the bottom right.  A "Change a Payee Record" screen has appeared.  More line items have appeared because this screen is not date constrained.  Any changes will be made to all appropriate line items in the data base.

 

The Sort Group length field has been clicked.  The length of the leftmost portion of the Payee name, to be used to group similar line items together, can be changed by typing a different number, by using the spinner, or by using the up and down arrow.  The length has been shortened, so now "ALBERTSONS" and "ALBERTSON'S" are members of the group "ALBERTSON".  Fifty seven line items will now be changed if the "OK" button is clicked.  At this point, the ellipse (the box with 3 dots in it) to the right of the "Category" or "User Defined" fields could be clicked, to browse, add, and select values.  Since "groceries" is already present, it will be left as-is.

The "OK" button has been clicked.  Now 17 line items are in the Sort group for the 4th quarter of 2000.  They are still in Payee sequence.

The "Sale Date" heading has been clicked.  The line items are now in chronological sequence.  Notice that line items from two credit cards (a Visa and a Master Card) are included, so if all "ALBERTSONS" purchases were made with credit cards, a complete review of purchases from this payee is presented here.

The "Print" button has been clicked.  We view a report that reflects the data and order we selected.  We can see it on the monitor, and have the option to print a hard copy if we like what we see.

 

 
Copyright © 2000-2010 Verify Charges, All rights reserved.
Feedback webmaster@verifycharges.com