University of Calgary

...Library Accounting Department Required Reports

BILLBALANCE

  • WHAT is our Accounts Receivable account balance?
    
                 SUGGESTED USES: list of bills
                USER SELECTIONS: bill, user, [useracnt]
                        SORTING: user ID, user name
                     FORMATTING: full detail or just system total
    
    
    • Sample output:
      
                          Current Outstanding System Wide Balance                    
                               Produced 2000-04-01  04:42:39                         
       
       
       
                       SYSTEM TOTAL OUTSTANDING BALANCE:  $134984.38 
      
      


    BILLITEMPAID

  • bill and item selections
                 SUGGESTED USES: list of bills with SUM AMT PAID
                USER SELECTIONS: bill, item
                        SORTING: none
    

    • Sample output:
                           Bills Associated with DOUCETTE ITEMS                      
                              Summary Bill List With Totals                
        Bill will be selected if any date of payment is not earlier than 6/1/1999 and not later than 6/30/1999
        Item will be selected if category2 is DOUCETTE
      
                        Produced on Mon Apr  3 12:58:36 MDT 2000
      
      
      $    715.90          SUBTOTALS_FOR_CASH      
      $     87.00          SUBTOTALS_FOR_CHECK     
      $    674.75          SUBTOTALS_FOR_FORGIVEN  
      $    102.75          SUBTOTALS_FOR_CANCEL    
      $     63.25          SUBTOTALS_FOR_CREDITCARD
      $      0.00          SUBTOTALS_FOR_FCAPAID   
      $      0.00          SUBTOTALS_FOR_FCAWRITOFF
      
       AMT PAID TOTAL:
       _______________
      $   1643.65
      
      * * * END OF SUMMARY OF Bills Associated with DOUCETTE ITEMS, BASED ON 
      CRITERIA LISTED IN LOG!* * * * 
      

    BILLASSESBAL

  • Ever wonder HOW much your library has billed in a month? ... Accounts Receivable

                 SUGGESTED USES: list of bills with SUM AMT BILLED
                USER SELECTIONS: bill
                        SORTING: none
                     FORMATTING: generate 2nd detail report option, prtbill option
    
    This report is set up to produce:
    A list of bills with TOTAL BILLED.
    
    • The output gives both what was assessed for time period selected and the current outstanding balance:

      
                       Fines Assessed Last Month--AMT TOTAL: column                  
                              Summary Bill List With Totals                
        Bill will be selected if date billed is not earlier than 4/1/2000 and not 
      later than 4/30/2000
                        Produced on Fri May  5 05:03:22 MDT 2000
      $  44829.00          $  20325.00          SUBTOTALS_FOR_OVERDUE   
      $  10452.60          $   4521.45          SUBTOTALS_FOR_FINAL     
      $      0.00          $      0.00          SUBTOTALS_FOR_RESERVEOVD
      $      0.00          $      0.00          SUBTOTALS_FOR_RECALLOVD 
      $   1058.65          $    380.85          SUBTOTALS_FOR_LOSTBOOK  
      $    152.45          $     92.45          SUBTOTALS_FOR_DAMAGED   
      $      0.00          $      0.00          SUBTOTALS_FOR_PRIVILEGE 
      $      0.00          $      0.00          SUBTOTALS_FOR_SERVCHG1  
      $    870.00          $    640.00          SUBTOTALS_FOR_WITHHOLD  
      $      0.00          $      0.00          SUBTOTALS_FOR_LOSTCARD  
      $    180.00          $    180.00          SUBTOTALS_FOR_FCA       
      $    262.00          $    149.00          SUBTOTALS_FOR_MANUAL    
       AMT TOTAL:             BAL.TOTAL
       __________             _________
      $  57804.70          $  26288.75
      * * * END OF SUMMARY OF Fines Assessed Last Month--AMT TOTAL: column, BASED ON 
      CRITERIA:* * * * 
        Bill will be selected if date billed is not earlier than 4/1/2000 and not 
      later than 4/30/2000
                        Produced on Fri May  5 05:03:22 MDT 2000
                                       Page 1 of 1         
      
      


    BILLITEMTOTAL

  • variation of billassesbal with item selection.


    CASHBYWS

  • Frustrated with the cash report's lack of sorting? Our library groups named stations by the station's location and wants totals for each group.

    • Sample output:
      
                              Summary Workstation Cash Report                         
                              PRODUCED 2000-12-19 at 07:45:03                         
                             FOR FINES PRODUCED FOR 2000/12/18                        
                                                                                      
                                                                                      
               cash/chq/credit cd                                                     
      STATION          PAYMENT  FORGIVEN    CANCEL  FCA PAID   FCA W/O     TOTAL
       
      BRANCH: DOUC-CIRC
      CIRCDOUC-1         33.00      0.00      0.00      0.00      0.00     33.00
       
      Subtotal           33.00      0.00      0.00      0.00      0.00     33.00
       
      BRANCH: MACK-CIRC
      CIRCMAC-1          90.00      0.00    168.00      0.00      0.00    258.00
      CIRCMAC-2         203.00      0.00     27.00      0.00      0.00    230.00
      CIRCMAC-3         195.00      0.00    215.80      0.00      0.00    410.80
      CIRCMAC-4         171.00      0.00     38.00      0.00      0.00    209.00
      CIRCMAC-7         148.00      0.00    119.00      0.00      0.00    267.00
       
      Subtotal          807.00      0.00    567.80      0.00      0.00   1374.80
       
      BRANCH: MED-CIRC
      CIRCMED-1           4.00      0.00      0.00      0.00      0.00      4.00
      CIRCMED-2          47.00      0.00     15.00      0.00      0.00     62.00
       
      Subtotal           51.00      0.00     15.00      0.00      0.00     66.00
       
      BRANCH: MGMT-CIRC
      CIRCMGMT-1         30.00      0.00      1.00      0.00      0.00     31.00
       
      Subtotal           30.00      0.00      1.00      0.00      0.00     31.00
       
      BRANCH: UNKNOWN
      CIRCMACK            0.00      0.00      7.00      0.00      0.00      7.00
       
      Subtotal            0.00      0.00      7.00      0.00      0.00      7.00
       
       
       
      TOTAL             921.00      0.00    590.80      0.00      0.00   1511.80
      
      

    BILLYREND

  • variation on Emory's billusersum-allows sort and subtotals of initial summary report
                             List of Users with Bills & total.
        Bills will be selected if the date billed is later than 6/1/2000.
                 Number of Bills and Total Balance Owed for Each User
      
                        Produced on Tue Sep  5 08:15:45 MDT 2000
      
       Bill Total          USER NAME                   USER ID         #Bills
       __________         ___________                  _______         ______
      
      $      7.00     ADEDEJI, JADESOLA OLUBUNMI      011075852       2 bill(s)
      $     10.00     AMIN, ZAHIR SHABBIR             011043566       1 bill(s)
      $     10.00     Anderson, David Theodore        011079260       1 bill(s)
      
      
      ....
      
      $     10.00     WRIGHT, KEVIN STEWART           011057513       5 bill(s)
      $     14.00     Yeung, Sophy                    011090287       1 bill(s)
      $     69.60     YOUNG, DARREN                   011025170       1 bill(s)
      
       GRAND SUM:
       __________
      $   3448.50
      
                                        Page 4 of 4
      
      

    --------------------------------------------------

    Back to: Main API presentation page

    Back to: TOP of page

    --------------------------------------------------


    Nella Lall
    University of Calgary Library, ITS