Invoice Ledger

Using the Sample Reports › Invoice Ledger

Invoice Ledger

This report is a summarization by user of the charges for resource use. It is a record of the invoices sent and shows management utilization of the resources by user.

I N V O I C E L E D G E R BEGIN DATE - 02/02/98 RUN DATE - 02/13/98 END DATE - 02/10/98 PAGE 1 TOTAL OVER-UNDER PERCNT COST CENTER DEBIT CREDIT CHARGE BUDGET BUDGET BUDGET ACCOUNTING DEPT. $898.50 $.00 $1,135.93 $6,000 $4,864.07 18.9 SALES AUDIT DEPT. $431.00 $.00 $512.20 $10,000 $9,487.80 5.1 $116.00 $123.69 $23.27 $16,000 $15,976.73 .1 INVENTORY CONTROL $57.00 $610.70 $512.10- $10,000 $10,512.10 5.1 $120.00 $.00 $120.00 $20,000 $19,880.00 .6 $36.50 $96.18 $59.68- $8,000 $8,059.68 .7 $120.00 $.00 $120.00 $30,000 $29,880.00 .4 $18.00 $21.20 $3.20- $17,000 $17,003.20 .0 $17.50 $11.45 $6.42 $30,000 $29,993.58 .0 ADMINISTRATION $2,016.30 $.00 $2,375.94 $15,000 $12,624.06 15.8 $.00 $.00 $11.42 $0 $11.42- .0 CUSTOMER SUPPORT $.00 $.00 $35.54 $0 $35.54- .0 ENGINEERING SUPPORT $.00 $.00 $190.77 $0 $190.77- .0 $.00 $.00 $3.08 $0 $3.08- .0 $.00 $.00 $429.65 $0 $429.65- .0 $.00 $.00 $6.57 $0 $6.57- .0 PERSONNEL DEPT. $.00 $.00 $75.59 $0 $75.59- .0 PRODUCTION DEPT. $.00 $.00 $196.13 $0 $196.13- .0 LIBRARIAN $.00 $.00 $90.24 $0 $90.24- .0 $.00 $.00 $.01 $0 $.01- .0 $.00 $.00 $2.53 $0 $2.53- .0 $3,830.80 $863.22 $4,760.31 $162,000 $157,239.69 2.9

Invoice Ledger: Report 1

           1    1    2    2    3    3    4    4    5    5    6    6    7    7
 0....5....0....5....0....5....0....5....0....5....0....5....0....5....0....5
  |1HEADER  037I N V O I C E   L E D G E R
1 |1SORT    01601A2
2 |1DISPLAY   002280279246281382383
3 |1RATE     1000          100                        200         050050
4 |1TSORATE  1000              100                                 050050
5 |1FORMRATE B        0200
  |1FORMRATE          0100
6 |1TITLE   02                    COST CENTER
7 |1DESCRIPT1A       ACCOUNTING DEPT.
 |1DESCRIPT1B       SALES AUDIT DEPT.
8 |1CREDIT                                 C                            012369
  |1CREDIT                                 D                            061070
9 |1DEBIT                                  A                            089850
  |1DEBIT                                  B                            043100
10|1BUDGET                                 A                            006000
  |1BUDGET                                 B                            010000

Notes:

SORT:
FIRST SORT LEVEL - 1st character of JOB NAME (Cost Center)
Print summary
DISPLAY:
Fields Printed: DESCRIPTION, DEBIT AMOUNT, CREDIT AMOUNT, TOTAL CHARGE, BUDGET AMOUNT, OVER-UNDER BUDGET AMOUNT, PER CENT BUDGET SPENT
RATE:
$1000 per CPU Hour
$2.00 per 1000 Cards Read
$0.50 per Tape Drive Allocation
$0.50 per Private Disk Drive Allocation
TSORATE:
$1000 per CPU Hour
$0.50 per Tape Drive Allocation
$0.50 per Private Disk Drive Allocation
FORMRATE:
FORMRATE CARD for Punch
$2.00 per 2,000 cards punched
FORMRATE CARD for Print
$1.00 per 2,000 lines printed
TITLE:
Rename DESCRIPTION to COST CENTER (Bottom)
DESCRIPT:
Appropriate names for each Cost Center in FIRST SORT FIELD
For example:
A is ACCOUNTING DEPT.
CREDIT:
Credits to each Cost Center
For example:
$123.69 to Cost Center C
DEBIT:
Debits to each Cost Center
For example:
$898.50 to Cost Center A
BUDGET:
Budget amount to each Cost Center
For example:
$6000.00 for Cost Center A

Note: DESCRIPT statements are included for sample cost centers. CREDIT, DEBIT, and BUDGET statements are included as examples.