VSS

CLIENT CONNECTION

FEBRUARY, 2003

 

GENERAL LEDGER ACCOUNT ANALYSIS

VSS has developed a series of programs that allow you to analyze General Ledger Accounts quickly and conveniently.  This information can be displayed, printed or transferred to your PC:

 

In the initial screen you enter the G/L account number as well as the date range for which you would like to see information:

 

 

 

 

 

 

 

MON 10 FEB 03                                       GL INQUIRY                                     VSS

__________________________________________________________________________________

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ENTER ACCOUNT NUMBER:

6728

 - POSTAGE/BULK MAIL

 

 

ENTER STARTING MMVV:

102

 

 

 

 

 

ENTER ENDING MMVV…..:

103

 

 

 

 

 

(S=SUMMARY) (D=DETAIL):

 

 

 

 

 

 

 

 

 

 

 

 

__________________________________________________________________________________

 

The next screen shows summary information.  For each month it shows the total amount from A/P, A/R and Journal Entries:

 

Mon 10 Feb 03                              GL INQUIRY                                          VSS

 

 

 

 

 

 

 

6728  -  POSTAGE/BULK MAIL        

 

 

 

 

 

 

 

 

 

 

YYMM

TYPE

BR#…

BEG-BALANCE……..

DEBIT…..

CREDIT….

ENDING BAL

=====

======

=====

================

=======

=======

=============

0201

AP

ALL

$0.00

$1,068.00

$0.00

$1,068.00

0202

AP

ALL

$1,068.00

$2,000.00

$520.00

$2,548.00

0203

AP

ALL

$2,548.00

$2,548.00

$0.00

$3,548.00

0204

AP

ALL

$3,548.00

$3,548.00

$0.00

$4,602.00

0205

AP

ALL

$4,602.00

$4,602.00

$0.00

$8,245.00

0206

AP

ALL

$8,245.00

$8,245.00

$0.00

$9,245.00

0206

JE

ALL

$9,245.00

$9,245.00

$0.00

$9,765.00

0207

AP

ALL

$9,765.00

$9,765.00

$0.00

$11,767.46

0208

AP

ALL

$11,767.46

$11,767.46

$0.00

$12,944.12

0209

AP

ALL

$12,944.12

$12,944.12

$0.00

$14,981.12

0210

AP

ALL

$14,981.12

$14,981.12

$0.00

$17,501.12

0211

AP

ALL

$17,501.12

$17,501.12

$0.00

$19,515.82

0212

AP

ALL

$19,515.82

$19,515.82

$0.00

$22,089.82

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

=================================================================

(AP det.)  (AR.det.)  (JE det.)   (CASH det.)  (P=PRINT)

(T=XFER TO PC)(E=END)

 

 

 

 

 

 

 

The following screen shows the AP Detail for this account/date range

This information can be printed or transferred to a spreadsheet.  Additionally specific vouchers or checks can be displayed.

 

These same screens are available for A/R information as well as Journal Entry information.  In each case the specific Invoice, Journal Entry can be displayed and the information can be transferred to a spreadsheet.

 

 

 

 

 

 

 

 

 

 

MON 10 FEB 03                         AP GL INQUIRY                                 SS VSS

 

 

 

 

 

 

 

 

 

 

 

ACCOUNT:  6728 POSTAGE/BULK MAIL                                              FOR BRANCH:  ALL

======================================================================

MMYY

BR

SC

VENDOR

VENDOR-NAME

INV#/CH#

DEBIT

CREDIT

DESC

0102

1

IN

18260

US POST OFFICE

CK77260

$480.00

 

 

0202

1

IN

18260

US POST OFFICE

CK77769

$480.00

 

 

0202

1

IN

18261

US POST OFFICE

CK78019

$480.00

 

 

0302

1

IN

18260

US POST OFFICE

CK78539

$480.00

 

 

0402

1

IN

18261

US POST OFFICE

22187

$480.00

 

 

0502

1

IN

18260

US POST OFFICE

22269

$480.00

 

 

0502

1

IN

18260

US POST OFFICE

CK79012

$480.00

 

 

0502

1

IN

18260

US POST OFFICE

CK79012C

$200.00

 

 

0502

1

IN

18260

US POST OFFICE

INV-BOX#29

$125.00

 

 

0502

1

IN

18261

US POST OFFICE

2270

$480.00

 

 

0602

1

IN

18260

US POST OFFICE

CK79774

$480.00

 

 

0702

1

IN

18260

US POST OFFICE

23326

$480.66

 

 

0702

1

IN

18260

US POST OFFICE

23341

$480.00

 

 

======================================================================

 

 

 

 

                       TOTALS              

$22,089.82

$520.00

 

======================================================================

(F=FORWARD)  (PAGE)  (L=LOCKED)  (P=PRINT)   (E=END)

(V=VOUCHER) (T=XFER TO PC)

 

 

 

 

 

 

 

 

 

 

 

 

 

MODIFICATION TO VOUCHERS/CHECKS

This modification posts a date/time/user stamp to each Voucher, void voucher, void check and Check record.  The purpose of this is to facilitate finding problems caused by people entering bad dates (for example, entering a fiscal period of 01/02 rather than 01/03.

 

MIS TIP:

HOW TO SAVE THE G/L INFORMATION SO THAT YOU CAN CONTINUE CLOSING JANUARY, FEBRUARY, 2003 (ETC.), AND THEN GO BACK TO FINISH CLOSING DECEMBER 2002:

 

1.      Make a copy of the GL file and the GL-YTD file, and the JOURNAL-ENTRY file, put them someplace else. (Because you are going to want them back later.)

 

  1. Run the January 2003 statement, etc. whatever you want to do.

 

  1. When you’re ready for the final entries in December.

 

a.      Save the January 2003 journal entries into another file (so that you don’t end up having to re-enter them).

 

b.      Clear the GL file, GL-YTD & JOURNAL-ENTRY files.

 

c.      Copy those 3 files back from where you saved them.

 

d.      Make whatever additional journal entries you have for December and run the reports, etc.

 

 

  1. Now re-close January 2003 (starting from the very beginning where you copy from AP & AR, etc.).

 

 

  1. Copy back the January 2003 Journal Entries  - and now you are back to square one, with all the December Journal Entries.

 

 

 

 

 

 

VENDIG SOFTWARE SOLUTIONS

1017 CATAMARAN #3,  FOSTER CITY, CA 94404

PHONE/FAX:  (800) 942-2496

EMAIL ADDRESSES:

Betty Vendig:  bvendig@aol.com

Gary Adamietz:  gpadam@aol.com

Nancy Rosenblad:  nrbug@aol.com