Loading...
HomeMy WebLinkAboutAGENDA REPORT 2006 0215 CC REG ITEM 10IMOORPARK CITY COUNCIL AGENDA REPORT ITEM I ()• _ - .7r MOORPARK, CALIFORNIA ;I Cou" it Meeting -� o2- i.5 -aoob F_ Y: . . TO: Honorable City Council FROM: Johnny Ea Finance Director BY: Deanna Farnell, Finance /Accounting Manager �. DATE: February 9, 2006 (City Council meeting of February 15, 2006) SUBJECT: Consider Approval of Adjustments of Outstanding Accounts Receivable, Accounts Receivable Collection Policy and a Proposed Collection Agency Contract BACKGROUND A full accounts receivable reconciliation has been completed and the findings of this reconciliation were presented to the Budget & Finance Committee (Mayor Hunter and Councilmember Harper) on November 30, 2005. The Finance Department has prepared a proposed formal collection process and policy. In addition, recommendations for adjustment were also discussed with the Committee on both November 30, 2005 and February 1, 2006. The Committee supports the staff recommendation contained in this report. DISCUSSION As mentioned in the November 30, 2005 report to the Committee, payment responses to these old outstanding A/R were expected to be low. Since then, the City has only received $166 for NSF checks out of a total of $7,716 and $55 was received for false alarms out of a total of $56,460 for accounts that were originally billed prior to January 1, 2004. These balances have not been fully addressed in recent years due to staff vacancies in the Finance Department. In addition, other major projects such as complying with Governmental Accounting Standards Board (GASB) No. 34 requirements took precedence over accounts receivable. 000061 CITY COUNCIL MEETING FEBRUARY 15, 2006 PAGE 2 Due to the low payment responses and the age of these invoices, Finance is recommending adjustments to all outstanding NSF and false alarm invoices that were outstanding prior to January 1, 2004. In many cases customers have moved, businesses have been closed or filed for bankruptcy or there is no response to our collection efforts. Most of the invoices that make up these balances are not large enough to warrant any additional staff resources and /or collection agency involvement due to the cost would outweigh the benefit. These recommended adjustment amounts are as follows (See attached 'Customer Aging Reports'): Type Total NSF Checks Various $ 7,550 False Alarms 56,405 Total recommended adjustment $63,955 Total Outstanding A/R aging as of 1/12/06 $172,569 Finance staff will continue to make every attempt to collect, per the collection policy, on invoices dated after January 1, 2004 (pending recommended adjustments). The Finance Department has prepared an 'Accounts Receivable Collection Policy' which was also discussed at the February 1, 2006 Budget & Finance Committee meeting. This policy will serve as direction for staff to follow and will ensure timely collection and follow -up of delinquent accounts. (See attached 'Accounts Receivable Collection Policy'). We propose that late fees will be applied to all future invoices upon approval of this policy. Current staff resources are limited in allowing for a formal collection process and we would like to recommend that we commission a collection agency to take over when the Finance Department has exhausted all regular means of collection. Small claims court is another option for collection. However it is not always a cost effective alternative for smaller collection customers. Small claims court filings will take away from other staff priorities. Small claim proceedings do not guarantee collection even if a judgment is awarded in our favor. We would recommend that small claims court only be considered for larger delinquent accounts as approved by the City Manager consistent with City Council Policy. Staff recommends that the proposed policy be approved by minute action and that the next time the council considers revision to its Council Policies Resolution that this matter be include in such revision. 000062 CITY COUNCIL MEETING FEBRUARY 15, 2006 PAGE 3 STAFF RECOMMENDATION (Roll Call Vote Required) 1. Authorization by City Council to make recommended adjustments to outstanding accounts receivable prior to January 1, 2004. 2. Adopt 'Accounts Receivable Collection Policy' as noted in Exhibit "A ". 3. Direct staff to return to City Council for approval a proposed collection agency contract. ATTACHMENT(S) 1. City of Moorpark `Accounts Receivable Collection Policy' 2. NSF 'Customer Aging Report' (prior to January 1, 2004) 3. False Alarm `Customer Aging Report' (prior to January 1, 2004) 000063 Exhibit "A" CITY OF MOORPARK ACCOUNTS RECEIVABLE COLLECTION POLICY The City of Moorpark has the need to issue invoices for various types of services such as, but not limited to, false alarms, rent for City owned facilities, grant reimbursements, NSF checks and emergency response (DUI and property damage). Collection Policy shall be as follows: 1. The first notice to a debtor of an amount due is the issuance of the City of Moorpark invoice. 2. Past due accounts will be sent a past due statement at 30 and 60 days by the Finance Department. A one time penalty fee in the amount of ten percent (10 %) and a one and a half percent (1.5 %) monthly finance charge shall be added to any fee imposed in the event the fee is not paid within thirty (30) days after the billing date. The 60 day notice will state that the account will be turned over to a collection agency unless it is immediately cleared by the date specified. A. Where appropriate, debtor contact by telephone will be used during the collection process. The date and discussion will be noted on internal records. B. If the debtor responds, the Finance Department will make every effort to work out a solution for payment. (i.e. installment plan for larger amounts due). C. If the account is paid off or cleared by other means, the correspondence will be retained in the Finance Department customer files for such time period as required by applicable law. 3. When Finance has exhausted regular means of collections, accounts will be turned over to a collection agency in a final attempt to collect before the invoice is adjusted. Documentation required for the collection agency must include a copy of the original invoice or a list of charges. Other available information such as address, Social Security number and driver's license number will also be sent to the collection agency, if available. 4. Send Final Notice to the debtor noting that the account will be turned over to an appropriate external collection agency and collection costs may be charged if arrangements to pay are not made within 15 days. Note: If additional charges appeared for an account that has already been turned over to a collection agency, the new final notice should be for the same collection agency. 5. If the collection agency is not successful, further action will be considered as follows: A. Amounts between $500 and $5,000 will be presented to the City Manager for review and possible filing of a small claims court action, which may be instituted without further Council approval. 000064 Exhibit "A" City of Moorpark Accounts Receivable Collection Policy Page -2- B. Amounts in excess of $5,000 will be presented to the City Attorney by the City Manager for review and possible legal action, which may be instituted without further Council approval. 6. The Finance Department will keep the City Manager informed of any collection issues as part of the monthly report process. Should adjustments be necessary, after all attempts have been made to collect and the Finance Director has determined that it is not cost effective to continue with the collection process, he /she has the authority to authorize up to $100 per adjustment. A report of any adjustments authorized by the Finance Director shall be provided to the City Manager on a monthly basis. Any amount over $100 up to $1,000 may be approved for adjustment by the City Manager. A report of any adjustments made by the Finance Director and City Manager shall be provided to the City Council on a quarterly basis. Any amount over $1,000 must be presented semi - annually to the City Council for consideration of an adjustment or other action. Documentation of all adjustments will be kept in a separate file for year -end audit purposes. 7. Each department will be immediately informed, in writing, by the Finance Department of NSF check issues each time an NSF check is received. Backup documentation showing the name, date and type of service that the NSF check covered will be sent to the respective department. It will be the responsibility of each department to ensure that service is ceased for these individuals and /or companies until payment of NSF checks are collected. Only cash, cashier's check or money orders will be accepted as payment to satisfy NSF checks. 000065 PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 9 DATE: 12 /02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:16:08 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill -* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbiil cust_no AND mrcustomer.clnttype - "NSF" and mrcustbill.total_ due > "0.0" and mrcustbill 1 COST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 TOTAL REPORT: ON ACCOUNT. .00 .00 .00 .00 .00 7,550.21 C 0 0 0 0) 05 6^ PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 1 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:16:08 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust _ no AND mrcustomer.clnttype= "NSF" and mrcustbill.total due > "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 0000000433 ABEL AGUTLERA PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000149 01/07/04 02/06/04 665 65.00 .00 .00 .00 .00 65.00 TOTAL: 0000000433 ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 0000000180 AMY CAROLYN ASHFORD PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000053 02/09/01 03/11/01 1727 54.00 .00 .00 .00 .00 54.00 TOTAL: 0000000180 ON ACCOUNT: .00 54.00 .00 .00 .00 .00 54.00 0000000358 ANDREW J. SCHILLER PHONE: 949 -- 716 -4536x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000127 04/23/03 05/23/03 924 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000358 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000250 ANGELINA M JONES PHONE: 805 - 529 -6638x CONTACT. INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000085 11/29/01 12/29/01 1434 45.00 .00 .00 .00 .00 45.00 TOTAL: 0000000250 ON ACCOUNT: .00 45.00 .00 .00 .00 .00 45.00 0000000384 BARBARA GALLO PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000016 06/30/00 07/30/00 1951 178.00 .00 .00 .00 .00 178.00 TOTAL: 0000000384 ON ACCOUNT: .00 178.00 .00 .00 .00 .00 178.00 0000000112 BRIAN J. SIMONSGAARD PHONE: 805- 222 -7720x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000036 08/30/00 09/29/00 1890 65.00 .00 .00 .00 .00 65.00 TOTAL: 0000000112 ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 0000000394 BONNIE JEAN BRYCE PHONE: 805- 495 -8038x CONTACT: O ® INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000135 06/24/03 07/24/03 862 65.21 .00 .00 .00 .00 65.21 TOTAL 0000000394 ON ACCOUNT: .00 65.21 .00 65.21 .00 .00 .00 PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 2 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:16:08 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill Gust no AND mrcustomer.clnttype = "NSF" and mrcustbill.total_ due > "0.0" and mrcustbill.l CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 0000000265 CHARLES B. MERINO PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000090 01/23/02 02/22/02 1379 1,025.00 .00 .00 .00 .00 1,025.00 TOTAL: 0000000265 ON ACCOUNT: .00 1,025.00 .00 .00 .00 .00 1,025.00 0000000319 CHERYL ACKERMANN PHONE: 805 - 531 -0335x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000112 10/15/02 11/14/02 1114 64.00 .00 .00 .00 .00 64.00 TOTAL: 0000000319 ON ACCOUNT: .00 64.00 .00 .00 .00 .00 64.00 0000000379 COLIN HUMPHREY PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000013 04/30/00 05/30/00 2012 124.00 .00 .00 .00 .00 124.00 NSF0000024 07/07/00 08/06/00 1944 124.00 .00 .00 .00 .00 124.00 NSF0000125 04/02/03 05/02/03 945 81.00 .00 .00 .00 .00 81.00 TOTAL: 0000000379 ON ACCOUNT: .00 329.00 .00 .00 .00 .00 329.00 0000000413 DAWN LAPOLLA PHONE: 805 - 529 -581lx CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000144 10/01/03 10/31/03 763 81.00 .00 .00 .00 .00 81.00 TOTAL: 0000000413 ON ACCOUNT: .00 81.00 .00 .00 .00 .00 81.00 0000000211 DEBORAH J. CHERRY PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000001 08/24/99 09/23/99 2262 69.00 .00 .00 .00 .00 69.00 TOTAL: 0000000211 ON ACCOUNT: .00 69.00 .00 .00 .00 .00 69.00 0000000111 DELIA GONZALES PHONE: 805 - 529 -143lx CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000035 08/30/00 09/29/00 1890 65.00 .00 .00 .00 .00 65.00 TOTAL: 0000000111 ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 C 000009ig521 DENISE SAUNDERS �✓ PHONE: 805 - 529 -1479x 0 CONTACT: W PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 3 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:16:08 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n c = mrcustbill.cust _ no AND mrcustomer.clnttype = "NSF" and mrcustbill.total due> "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000006 10/22/99 11/21/99 2203 210.00 .00 .00 .00 .00 210.00 TOTAL: 0000000521 ON ACCOUNT: .00 210.00 .00 .00 .00 .00 210.00 0000000295 STEVEN M. DOONER PHONE: 805 - 523 -2209x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000100 07/12/02 08/11/02 1209 152.00 .00 .00 .00 .00 152.00 TOTAL: 0000000295 ON ACCOUNT: .00 152.00 .00 .00 .00 .00 152.00 0000000103 ELIA 0. HINKS PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000030 08/01/00 08/31/00 1919 185.00 .00 .00 .00 .00 185.00 TOTAL: 0000000103 ON ACCOUNT: .00 185.00 .00 .00 .00 .00 185.00 0000000322 ELISE K. HARTMAN PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000115 11/12/02 12/12/02 1086 64.00 .00 .00 .00 .00 64.00 TOTAL: 0000000322 ON ACCOUNT: .00 64.00 .00 .00 .00 .00 64.00 0000000294 ERNIE BRAVO PHONE: 805 - 523 -7204x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000099 06/26/02 07/26/02 1225 405.00 .00 .00 .00 .00 405.00 TOTAL: 0000000294 ON ACCOUNT: .00 405.00 .00 .00 .00 .00 405.00 0000000215 GAIL J. HASKINS PHONE: 805 - 529 -4416x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000073 08/02/01 09/01/01 1553 101.00 .00 .00 .00 .00 101.00 TOTAL: 0000000215 ON ACCOUNT: .00 101.00 .00 .00 .00 .00 101.00 0000000306 FRANCES M. GARRITY PHONE: 805 - 523 -9577x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000107 09/03/02 10/03/02 1156 495.00 .00 .00 .00 .00 495.00 TOTALQ000000306 ON ACCOUNT: .00 495.00 .00 .00 .00 .00 495.00 00000 25 GREG STOA PHONE: 495- 495 -7326x O CONTACT: W PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 4 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:16:08 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n e = mrcustbill.cust_no AND mrcustomer.clnttype= "NSF" and mrcustbill.total due> "0.0" and mrcustbill.l CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000079 08/31/01 09/30/01 1524 275.00 .00 .00 .00 .00 275.00 TOTAL: 0000000225 ON ACCOUNT: .00 275.00 .00 .00 .00 .00 275.00 0000000377 GUADALUPE DAVALOS PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000011 04/30/00 05/30/00 2012 63.00 .00 .00 .00 .00 63.00 TOTAL: 0000000377 ON ACCOUNT: .00 63.00 .00 .00 .00 .00 63.00 0000000401 HAYLEY V WHITE PHONE: 626 - 339 -4219x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000137 07/22/03 08/21/03 834 160.00 .00 .00 .00 .00 160.00 TOTAL: 0000000401 ON ACCOUNT: .00 160.00 .00 .00 .00 .00 160.00 0000000104 HEIDI HAGENDORN -KATZ PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000031 08 /01 /00 08/31/00 1919 123.00 .00 .00 .00 .00 123.00 TOTAL: 0000000104 ON ACCOUNT: .00 123.00 .00 .00 .00 .00 123.00 0000000326 INFANTE'S TRUCKING PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000122 01/28/03 02/27/03 1009 65.00 .00 .00 .00 .00 65.00 TOTAL: 0000000326 ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 0000000275 JAMISON EVANS PHONE: 805 - 532 -2495x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000093 03/25/02 04/24/02 1318 65.00 .00 .00 .00 .00 65.00 TOTAL- 0000000275 ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 0000000323 JAMES D. OWENS PHONE: 805 - 529 -4199x CONTACT: (� INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - -- --OVER 60 - - -- -OVER 90 NSF0000116 11/25/02 12/25/02 1073 65.00 .00 .00 .00 .00 65.00 TOTA ;0000000323 ON ACCOUNT: .00 65.00 .00 .00 65.00 .00 .00 0000(Z278 JAMES STEVENS PHONE: 805 - O PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 5 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:16:08 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust_no AND mrcustomer.clnttype = "NSF" and mrcustbill.total due > "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000095 04/11/02 05/11/02 1301 77.00 .00 .00 .00 .00 77.00 TOTAL: 0000000278 ON ACCOUNT: .00 77.00 .00 .00 .00 .00 77.00 0000000144 JASON ERB PHONE: 818 - 707 -1998x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000039 09/15/00 10/15/00 1874 65.00 .00 .00 .00 .00 65.00 TOTAL: 0000000144 ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 0000000194 JEFFREY D. MANORY PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000059 05/31/01 06/30/01 1616 65.00 .00 .00 .00 .00 65.00 TOTAL: 0000000194 ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 0000000145 JOSIE BROWN PHONE: 805- 241 - 5579x9 CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000040 09/20/00 10/20/00 1869 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000145 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000235 JUSTIN E. CHRISTENSEN PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000082 09/20/01 10/20/01 1504 65.00 .00 .00 .00 .00 65.00 TOTAL: 0000000235 ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 0000000205 JUSTIN PELOQUIN PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000064 06/30/01 07/30/01 1586 65.00 .00 .00 .00 .00 65.00 TOTAL: 0000000205 ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 0000000385 KEVIN LONGDEN PHONE: 805 - CONTACT: O INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000019 06/30/00 07/30/00 1951 454.00 .00 .00 .00 .00 454.00 TOTAL ON ACCOUNT: .00 454.00 .0o .00 .00 .00 454.00 A0000000385 0000 006 LEONARD J. SCROGGINS PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 6 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:16:08 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust _ no AND mrcustomer.clnttype = "NSF" and mrcustbill.total due > "O.0" and mrcustbill_1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 PHONE: 805 - 553 -9910x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000065 06/30/01 07/30/01 1586 133.00 .00 .00 .00 .00 133.00 TOTAL: 0000000206 ON ACCOUNT: .00 133.00 .00 .00 .00 .00 133.00 0000000380 LINDA A. BAKER PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000027 07/21/00 08/20/00 1930 128.00 .00 .00 .00 .00 128.00 TOTAL: 0000000380 ON ACCOUNT: .00 128.00 .00 .00 .00 .00 128.00 0000000195 LINDA L. STRATZ PHONE: 714 - 978 -7970x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000060 05/14/01 06/13/01 1633 50.00 .00 .00 .00 .00 50.00 TOTAL: 0000000195 ON ACCOUNT: .00 50.00 .00 .00 .00 .00 50.00 0000000217 LISA M. GOVORUHK PHONE: 805- 529 -5115x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000109 09/03/02 10/03/02 1156 146.00 .00 .00 .00 .00 146.00 TOTAL: 0000000217 ON ACCOUNT: .00 146.00 .00 .00 .00 .00 146.00 0000000434 LUKE WILSON PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000150 01/07/04 02/06/04 665 65.00 .00 .00 .00 .00 65.00 TOTAL: 0000000434 ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 0000000475 MARIA TERESA MAGANA PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000002 08/31/99 09/30/99 2255 73.00 .00 .00 .00 .00 73.00 TOTAL: 0000000475 ON ACCOUNT: .00 73.00 .00 .00 .00 .00 73.00 0000000161 MARK LYON PHONE: 805- 531 -9695x CONTACT: C INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000047 12/28/00 01/27/01 1770 65.00 .00 .00 .00 .00 65.00 TOTAL e- ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 O N PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 7 DATE: 1.2/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:16:08 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust _ no AND mrcustomer.clnttype = "NSF" and mrcustbill.total due > "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 0000000119 MELANIE J. LONGDEN PHONE: 805- 492 -8534x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000025 07/07/00 08/06/00 1944 99.00 .00 .00 .00 .00 99.00 TOTAL: 0000000119 ON ACCOUNT: .00 99.00 .00 .00 .00 .00 99.00 0000000204 MICHELLE D. ALVAREZ PHONE: 805 - 531 -5488x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000063 06/30/01 07/30/01 1586 65.00 .00 .00 .00 .00 65.00 TOTAL: 0000000204 ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 0000000203 MIGUEL ANGEL LOPEZ PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000062 06/30/01 07/30/01 1586 65.00 .00 .00 .00 .00 65.00 TOTAL: 0000000203 ON ACCOUNT: .00 65.00 .00 .00 .00 .00 65.00 0000000308 MIKE HAMMER PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSFO000110 09/11/02 10/11/02 1148 337.00 .00 .00 .00 .00 337.00 TOTAL: 0000000308 ON ACCOUNT: .00 337.00 .00 .00 .00 .00 337.00 0000000266 NANCY BOER MANNING PHONE: 805- 523 -864lx CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000121 01/07/03 02/06/03 1030 60.00 .00 .00 .00 .00 60.00 TOTAL: 0000000266 ON ACCOUNT: .00 60.00 .00 .00 .00 .00 60.00 0000000190 NICHOLAS A. MURO PHONE: 805 - 523 -273lx CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000058 04/25/01 05/25/01 1652 75.00 .00 .00 .00 .00 75.00 TOTAL: 0000000190 ON ACCOUNT: .00 75.00 .00 .00 .00 .00 75.00 0000000293 PAUL B. ANDREWS PHONE: 805 - CONTACT- C) INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 `AJ NSF0000098 06/26/02 07/26/02 1225 363.00 .00 .00 .00 .00 363.00 TOTAL'0000000293 ON ACCOUNT: .00 363.G0 .00 .00 .00 .00 363.00 ci PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 8 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:16:08 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust _ no AND mrcustomer.clnttype = "NSF" and mrcustbill.total due > "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 0000000184 REGGIE STANTON PHONE: 805 -- 533 -0937x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000056 03/31/01 04/30/01 1677 73.00 .00 .00 .00 .00 73.00 TOTAL: 0000000184 ON ACCOUNT: .00 73.00 .00 .00 .00 .00 73.00 0000000158 RICHARD W. BALTES PHONE: 805- 529 -815ox CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000044 12/28/00 01/27/01 1770 69.00 .00 .00 .00 .00 69.00 TOTAL: 0000000158 ON ACCOUNT: .00 69.00 .00 .00 .00 .00 69.00 0000000508 SANDI EVERETT PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000014 02/16/00 03/17/00 2086 50.00 .00 .00 .00 .00 50.00 TOTAL: 0000000508 ON ACCOUNT: .00 50.00 .00 .00 .00 .00 50.00 0000000519 STACY ALEXANDER GIBSON PHONE: 805 - 583 -0186x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000004 10/22/99 11/21/99 2203 155.00 .00 .00 .00 .00 155.00 TOTAL: 0000000519 ON ACCOUNT: .00 155.00 .00 .00 .00 .00 155.00 0000000163 TEASHA VALDEZ PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 NSF0000049 12/28/00 01/27/01 1770 45.00 .00 .00 .00 .00 45.00 TOTAL: 0000000163 ON ACCOUNTS .00 45.00 .00 .00 .00 .00 45.00 C AC A 0 PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 13 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:17:10 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust no AND mrcustomer.clnttype = "F /A" and mrcustbill.total_ due > "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 TOTAL REPORT: C AC O v 1 ON ACCOUNT: 55.00 56,405.00 .00 .00 .00 .00 56,405.00 Ll s- Y � i..c_V C+,_<� It PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 1 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:17:10 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomerrowid ,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust_no AND mrcustcmer.clnttype = "F /A" and mrcustbill.total_ due > "O.0" and mrcustbill 1 OUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 0000000227 ACCURATE WELDING PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000312 09/04/01 10/04/01 1520 55.00 .00 .00 .00 .00 55.00 F/A0000327 09/17/01 10/17/01 1507 110.00 .00 .00 .00 .00 110.00 TOTAL: 0000000227 ON ACCOUNT: .00 165.00 .00 .00 .00 .00 165.00 0000000210 ALTERRA MODEL GRAPH PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000402 03/20/02 04/19/02 1323 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000210 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000164 AMECI PIZZA PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000182 12/31/00 01/30/01 1767 150.00 .00 .00 .00 .00 150.00 F/A0000539 04/08/03 05/08/03 939 55.00 .00 .00 .00 .00 55.00 F /A0000562 04/14/03 05/14/03 933 110.00 .00 .00 .00 .00 110.00 TOTAL: 0000000164 ON ACCOUNT: .00 315.00 .00 .00 .00 .00 315.00 0000000438 AMERICAR PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000009 08/24/99 09/23/99 2262 150.00 .00 .00 .00 .00 150.00 F /A0000010 10/08/99 11/07/99 2217 250.00 .00 .00 .00 .00 250.00 F /A0000073 05/31/00 06/30/00 1981 350.00 .00 .00 .00 .00 350.00 TOTAL: 0000000438 ON ACCOUNT: 00 750.00 .00 .00 .00 .00 750.00 0000000153 AVETIFSIAN RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000162 11/08/00 12/08/00 1820 50.00 .00 .00 .00 .00 50.00 F /A0000184 12/31/00 01/30/01 176 "7 100.00 .00 .00 .00 .00 100.00 F /A0000261 05/31/01 06/30/01 1616 110.00 .00 .00 .00 .00 110.00 TOTAL: 0000000153 ON ACCOUNT: .00 260.00 .00 .00 .00 .00 260.00 0000000228 BALTAXE RESIDENCE PHONE: 805 - CONTACT: Cl INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 ® F /A0000313 09/04/01 10/04/01 1520 55.00 .00 .00 .00 .00 55.00 F /A0000414 03/20/02 04/19/02 1323 110.00 .00 .00 .00 .00 110.00 TOTAQ 0000000228 ON ACCOUNT: .00 165.00 .00 .00 .00 .00 165.00 O 0 n PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 2 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:17:10 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer.rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill cust_no AND mrcustomer.clnttype = "F /A" and mrcustbill.total_ due > "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 0000000440 BEAUWOOD CO PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000018 02/16/00 03/1.7/00 2086 150.00 .00 .00 .00 .00 150.00 F /A0000037 12/08/99 01/07/00 2156 150.00 .00 .00 .00 .00 150.00 TOTAL: 0000000440 ON ACCOUNT. .00 300.00 .00 .00 .00 .00 300.00 0000000284 BEHM RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000432 05/15/02 06/14/02 1267 55.00 .00 .00 .00 .00 55.00 F/A0000499 10/10/02 11/09/02 1119 110.00 .00 .00 .00 .00 110.00 TOTAL: 0000000284 ON ACCOUNT: .00 165.00 .00 .00 .00 .00 165.00 0000000417 BERKNSHAW RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000635 12/11/03 01/10/04 692 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000417 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000283 BLVD. MOTOR COMPANY (DO NOT US PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000580 06/09/03 07/09/03 877 660.00 .00 .00 .00 .00 660.00 F /A0000606 07/15/03 08/14/03 841 385.00 .00 .00 .00 .00 385.00 F /A0000619 08/13/03 09/12/03 812 495.00 .00 .00 .00 .00 495.00 TOTAL: 0000000283 ON ACCOUNT: .00 1,540.00 .00 .00 .00 .00 1,540.00 0000000441 BORDELLEN RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000038 12/30/99 01/29/00 2134 50.00 .00 .00 .00 .00 50.00 F /A0000086 07/21/00 08/20/00 1930 100.00 .00 .00 .00 .00 100.00 F /A0000118 09/01/00 10 /01 /00 1888 300.00 .00 .00 .00 .00 300.00 TOTAL: 0000000441 ON ACCOUNT: .00 450.00 .00 .00 .00 .00 450.00 0000000121 BRONSON BLVD. MOTORCARS CO. PHONE: 805 - CONTACT: C INVOICE NO INV DATE �d DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000119 09/01/00 10 /01 /00 1888 100.00 .00 .00 .00 .00 100.00 TOTAC0000000121 ON ACCOUNT: 55.00 100.00 .00 .00 .00 .00 100.00 PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER DATE: 12/02/05 CITY OF MOORPARK TIME: 11:17:10 CUSTOMER AGING REPORT PAGE NUMBER: 3 MODULE: mragerrp SELECTION CRITERIA, SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill,cust _ no AND mrcustomer.clnttype = "F /A" and mrcustbill.total_ due > 110.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 0000000443 BURGER KING PHONE: 818 - 244 -8237x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000012 03/31/00 04/30/00 2042 250.00 .00 .00 .00 .00 250.00 F /A0000149 10 /11 /00 11/10/00 1848 150.00 .00 .00 .00 .00 150.00 F /A0000173 11/22/00 12/22/00 1806 250.00 .00 .00 .00 .00 250.00 F /A0000186 12/31/00 01/30/01 1767 1,800.00 .00 .00 .00 .00 1,800.00 F /A0000206 01/31/01 03/02/01 1736 1,000.00 .00 .00 .00 .00 1,000.00 F/A0000234 03/31/01 04/30/01 1677 1,500.00 .00 .00 .00 .00 1,500.00 F /A0000288 06/30/01 07/30/01 1586 550.00 .00 .00 .00 .00 550.00 F /A0000314 09/04/01 10/04/01 1520 550.00 .00 .00 .00 .00 550.00 F /A0000315 09/04/01 10/04/01 1520 550.00 .00 .00 .00 .00 550.00 F/A0000473 09/12/02 10/12/02 1147 3,905.00 .00 .00 .00 .00 3,905.00 F /A0000488 09/13/02 10/13/02 1146 2,750.00 .00 .00 .00 .00 2,750.00 F/A0000495 10/10/02 11/09/02 1119 550.00 .00 .00 .00 .00 550.00 F /A0000500 10/11/02 11/10/02 1118 2,200.00 .00 .00 .00 .00 2,200.00 TOTAL: 0000000443 ON ACCOUNT: .00 16,005.00 .00 .00 .00 .00 16,005.00 0000000409 CALDER RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000634 09/25/03 10/25/03 769 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000409 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000132 CANTARA MODELS PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000433 05/15/02 06/14/02 1267 550.00 .00 .00 .00 .00 550.00 TOTAL: 00000001.32 ON ACCOUNT: .00 550.00 .00 .00 .00 .00 550.00 0000000368 CARNITAS MICHOACAN PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000029 03/31/00 04/30/00 2042 550.00 .00 .00 .00 .00 550.00 F /A0000064 04/30/00 05/30/00 2012 800.00 .00 .00 .00 .00 800.00 F /A0000122 09/01/00 10 /01 /00 1888 500.00 .00 .00 .00 .00 500.00 TOTAL: 0000000368 ON ACCOUNT: .00 1,850.00 .00 .00 .00 .00 1,850.00 0000000336 CARTER RESIDENCE PHONE: 805 - CONTACT: ® INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000543 04/08/03 05/08/03 939 55.00 .00 .00 .00 .00 55.00 TOTA0 0000000336 ON ACCOUNT .00 55.00 .00 .00 .00 .00 55.00 000000442 CHOLES MARKET W PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 4 DATE: 1.2/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:17:10 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust _ no AND mrcustomer.clnttype = "F /A" and mrcustbill.total _ due> 110.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000039 12/30/99 01/29/00 2134 50.00 .00 .00 .00 .00 50.00 F /A0000089 07/21/00 08/20/00 1930 100.00 .00 .00 .00 .00 100.00 F /A0000107 08 /01 /00 08/31/00 1919 150.00 .00 .00 .00 .00 150.00 F /A0000152 10 /11 /00 11 /10 /00 1848 150.00 .00 .00 .00 .00 150.00 F/A0000262 05/31/01 06/30/01 1616 165.00 .00 .00 .00 .00 165.00 TOTAL: 0000000442 ON ACCOUNT: .00 615.00 .00 .00 .00 .00 615.00 0000000166 COMMUNITY PEDIATRIC MEDICAL PHONE: 805 - 495 -084lx CONTACT: COOKIE INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000446 05/29/02 06/28/02 1253 110.00 .00 .00 .00 .00 110.00 F/A0000489 09/13/02 10/13/02 1146 165.00 .00 .00 .00 .00 165.00 F /A0000654 12/11/03 01/10/04 692 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000166 ON ACCOUNT: .00 330.00 .00 .00 .00 .00 330.00 0000000008 CREATIVE WOODWORK PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000188 12/31/00 01/30/01 1767 50.00 .00 .00 .00 .00 50.00 TOTAL: 0000000008 ON ACCOUNT: .00 50.00 .00 .00 .00 .00 50.00 0000000444 DEMBO RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - -- --OVER 90 F /A0000003 07/30/99 08/29/99 2287 100.00 .00 .00 .00 .00 100.00 TOTAL: 0000000444 ON ACCOUNT: .00 100.00 .00 .00 .00 .00 100.00 0000000371 DILWITH RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000066 04/30/00 05/30/00 2012 50.00 .00 .00 .00 .00 50.00 TOTAL: 0000000371 ON ACCOUNT: .00 50.00 .00 .00 .00 .00 50 .00 0000000372 DORCH RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE F/A0000067 04/30/00 DUE DATE 05/30/00 DAYS - 2012 -TOTAL DUE -- - CURRENT /< 50.00 .00 - - -- -OVER .00 - - -- -OVER 30 - - .00 -- -OVER 60 - - -- .00 -OVER 50.00 90 TOTALO000000372 ON ACCOUNT: .00 50.00 .00 .00 .00 .00 50.00 00000167 EXECUTIVE PAGE LTD PHONE: 805 - W PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 5 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:17:10 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust _ no AND mrcustomer.clnttype = "F /A" and mrcustbill.total_ due > "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000190 12/31/00 01/30/01 1767 50.00 .00 .00 .00 .00 50.00 F/A0000287 06/30/01 07/30/01 1586 110.00 .00 .00 .00 .00 110.00 TOTAL: 0000000167 ON ACCOUNT: .00 160.00 .00 .00 .00 .00 160.00 0000000254 EXOTO PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000624 09/11/03 10/11/03 783 1,870.00 .00 .00 .00 .00 1,870.00 TOTAL: 0000000254 ON ACCOUNT: .00 1,870.00 .00 .00 .00 .00 1,870.00 0000000446 EZ OIL PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000016 10/29/99 11/28/99 2196 100.00 .00 .00 .00 .00 100.00 TOTAL: 0000000446 ON ACCOUNT: .00 100.00 .00 .00 .00 .00 100.00 0000000156 FAMILY SPORTSWEAR PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000174 11/22/00 12/22/00 1806 50.00 .00 .00 .00 .00 50.00 F/A0000235 03/31/01 04/30/01 1677 250.00 .00 .00 .00 .00 250.00 TOTAL: 0000000156 ON ACCOUNT: .00 300.00 .00 .00 .00 .00 300.00 0000000021 GERY RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000684 12/11/03 01/10/04 692 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000021 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000280 GUADALAJARA SERVICE FOR LATINO PHONE: 805 - CONTACT INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000502 10/10/02 11/09/02 1119 275.00 .00 .00 .00 .00 275.00 F/A0000520 04/08/03 05/08/03 939 275.00 .00 .00 .00 .00 275.00 TOTAL: 0000000280 ON ACCOUNT: .00 550.00 .00 .00 .00 .00 550.00 0000000389 HARMONY SWEET C PHONE: 805 - Q CONTACT: OINVOICE NO INV DATE F/A0000596 07/02/03 DUE DATE 08/01/03 DAYS - 854 -TOTAL DUE 110.00 -- - CURRENT /< .00 - - -- -OVER .00 - - -- -OVER 30 - .00 - -- -OVER 60 .00 - - -- -OVER 110.00 90 O PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 6 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:17:10 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomex -. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill_cust no AND mrcustomer.clnttype = "F /A" and mrcustbill.total_due > "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 TOTAL: 0000000389 ON ACCOUNT: .00 110.00 .00 .00 .00 .00 110.00 0000000514 INDUSTRIA MUSICO PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000548 04/08/03 05/08/03 939 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000514 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000186 JOHANNESSEN RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000692 12/11/03 01/10/04 692 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000186 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000154 JOSEPH RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000166 11 /08 /00 12/08/00 1820 50.00 .00 .00 .00 .00 50.00 F/A0000177 11/22/00 12/22/00 1806 250.00 .00 .00 .00 .00 250.00 F/A0000238 03/31/01 04/30/01 1677 250.00 .00 .00 .00 .00 250.00 TOTAL: 0000000154 ON ACCOUNT: .00 550.00 .00 .00 .00 .00 550.00 0000000137 KASAAB RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000211 01/31/01 03/02/01 1736 150.00 .00 .00 .00 .00 150.00 TOTAL: 0000000137 ON ACCOUNT: .00 150.00 .00 .00 .00 .00 150.00 0000000317 KELLY RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000503 10/10/02 11/09/02 1119 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000317 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000448 KILLINS RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000041 12/08/99 01/07/00 2156 50.00 .00 .00 .00 .00 50.00 TOTAC0000000448 ON ACCOUNT .00 50.00 .00 .00 .00 .00 50.00 Q 000 0 231 KINKOS PHONE: 805 - O CONTACT: M M PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER DATE: 12/02/05 CITY OF MOORPARK TIME: 11:17:10 CUSTOMER AGING REPORT PAGE NUMBER: 7 MODULE: mragerrp SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill. - FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust _ no AND mrcustomer.clnttype = "F /A" and mrcustbill.total_ due > 110.0" and mrcustbill.l CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000332 09/17/01 10/17/01 1507 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000231 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000392 KOHL'S DEPARTMENT STORE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000588 06/25/03 07/25/03 861 110.00 .00 .00 .00 .00 110.00 F /A0000609 07/15/03 08/14/03 841 165.00 .00 .00 .00 .00 165.00 TOTAL: 0000000392 ON ACCOUNT: .00 275.00 .00 .00 .00 .00 275.00 0000000451 KRETEK IMPORTS PHONE: 805 - 531 -8888x CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000006 07/30/99 08/29/99 2287 250.00 .00 .00 .00 .00 250.00 F/A0000023 08/24/99 09/23/99 2262 350.00 .00 .00 .00 .00 350.00 F/A0000024 08/25/99 09/24/99 2261 450.00 .00 .00 .00 .00 450.00 F/A0000025 10/29/99 11/28/99 2196 1,000.00 .00 .00 .00 .00 1,000.00 F/A0000043 12/08/99 01/07/00 2156 500.00 .00 .00 .00 .00 500.00 F /A0000061 03/31/00 04/30/00 2042 1,000.00 .00 .00 .00 .00 1,000.00 F/A0000094 07/21/00 08/20/00 1930 500.00 .00 .00 .00 .00 500.00 F/A0000194 12/31/00 01/30/01 1767 500.00 .00 .00 .00 .00 500.00 F/A0000213 01/31/01 03/02/01 1736 350.00 .00 .00 .00 .00 350.00 F/A0000549 04/08/03 05/08/03 939 385.00 .00 .00 .00 .00 385.00 TOTAL: 0000000451 ON ACCOUNT: .00 5,285.00 .00 .00 .00 .00 5,285.00 0000000285 LEACH RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000437 05/15/02 06/14/02 1267 55.00 .00 .00 .00 00 55.00 F/A0000450 05/29/02 06/28/02 1253 110.00 .00 .00 .00 .00 110.00 F/A0000490 09/13/02 10/13/02 1146 165.00 .00 .00 .00 .00 165.00 F/A0000512 04/08/03 05/08/03 939 660.00 .00 .00 .00 .00 660.00 F/A0000550 04/06/03 05/08/03 939 55.00 .00 .00 .00 .00 55.00 F/A0000617 08/13/03 09/12/03 812 165.00 .00 .00 .00 .00 165.00 TOTAL: 0000000285 ON ACCOUNT: .00 1,210.00 .00 .00 .00 .00 1,210.00 0000000168 LONGS DRUG STORE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 ^ F/A0000577 05/21/03 06/20/03 896 385.00 .00 .00 .00 .00 385.00 TOTAL 0000000168 ON ACCOUNT: .00 385.00 .00 .00 .00 .00 385.00 Q 00001dO -QI49 MASTER COOLING O PHONE: 805 - CONTACT: N PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 8 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:17:10 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer.rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill cust_no AND mrcustomer.clnttype = "F /A" and mrcustbill.total_ due > "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000295 08/02/01 09/01/01 1553 550.00 .00 .00 .00 .00 550.00 TOTAL: 0000000149 ON ACCOUNT: .00 550.00 .00 .00 .00 .00 550.00 0000000453 MEISSNER RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000007 07/30/99 08/29/99 2287 150.00 .00 .00 .00 .00 150.00 F /A0000045 12/30/99 01/29/00 2134 250.00 .00 .00 .00 .00 250.00 TOTAL: 0000000453 ON ACCOUNT: .00 400.00 .00 .00 .00 .00 400.00 0000000454 MERCADO RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000046 12/08/99 01/07/00 2156 150.00 .00 .00 .00 .00 150.00 TOTAL: 0000000454 ON ACCOUNT: .00 150.00 .00 .00 .00 .00 150.00 0000000373 MOORPARK CENTRAL MARKET PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000068 04/30/00 05/30/00 2012 550.00 .00 .00 .00 .00 550.00 F /A0000078 05/31/00 06/30/00 1981 350.00 .00 .00 .00 .00 350.00 F /A0000096 07/21/00 08/20/00 1930 450.00 .00 .00 .00 .00 450.00 F /A0000132 09/01/00 10/01/00 1888 250.00 .00 .00 .00 .00 250.00 F/A0000256 04/30/01 05/30/01 1647 250.00 .00 .00 .00 .00 250.00 F/A0000367 12/03/01 01/02/02 1430 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000373 ON ACCOUNT: .00 1,905.00 .00 .00 .00 .00 1,905.00 0000000238 MOSLER ENGINEERING PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000425 04/17/02 05/17/02 1295 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000238 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000230 NAVARRO RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000399 01/10/02 02/09/02 1392 110.00 .00 .00 .00 .00 110.00 TOTAL: 0000000230 ON ACCOUNT: .00 110.00 .00 .00 .00 .00 110.00 C 00 00219 NORTH OAKS AUTO PARTS PHONE: 805 - CONTACT: (Q 'M W PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER DATE: 12/02/05 CITY OF MOORPARK TIME: 11:17:10 CUSTOMER AGING REPORT PAGE NUMBER: 9 MODULE: mragerrp SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust_no AND mrcustomer.clnttype = "F /A" and mrcustbill.total_due > "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000297 08/02/01 09/01/01 1553 55.00 .00 .00 .00 .00 55.00 F/A0000298 08/02/01 09/01/01 1553 110.00 .00 .00 .00 .00 110.00 F /AO000299 08/02/01 09/01/01 1553 165.00 .00 .00 .00 .00 165.00 F/A0000333 09/17/01 10/17/01 1507 385.00 .00 .00 .00 .00 385.00 F/A0000334 09/17/01 10/17/01 1507 495.00 .00 .00 .00 .00 495.00 TOTAL: 0000000219 ON ACCOUNT: .00 1,210.00 .00 .00 .00 .00 1,210.00 0000000193 ONSITE DESIGN PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000266 05/31/01 06/30/01 1616 440.00 .00 .00 .00 .00 440.00 F/A0000292 06/30/01 07/30/01 1586 385.00 .00 .00 .00 .00 385.00 F/A0000347 09/20/01 10/20/01 1504 495.00 .00 .00 .00 .00 495.00 F /A0000360 10 /11 /01 11 /10 /01 1483 550.00 .00 .00 .00 .00 550.00 F/A0000589 06/25/03 07/25/03 861 110.00 .00 .00 .00 .00 110.00 TOTAL: 00000001.93 ON ACCOUNT: .00 1,980.00 .00 .00 .00 .00 1,980.00 0000000287 PANADERIA BAKERY PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000440 05/15/02 06/14/02 1267 55.00 .00 .00 .00 .00 55.00 F /A0000480 09/12/02 10/12/02 1147 110.00 .00 .00 .00 .00 110.00 F/A0000507 10/10/02 11/09/02 1119 825.00 .00 .00 .00 .00 825.00 F/A0000536 04/08/03 05/08/03 939 165.00 .00 .00 .00 .00 165.00 TOTAL: 0000000287 ON ACCOUNT: .00 1,155.00 .00 .00 .00 .00 1,155.00 0000000138 PAYLESS SHOES PHONE: 805- CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000320 09/04/01 10/04/01 1520 165.00 .00 .00 .00 .00 165.00 F/A0000336 09/17/01 10/17/01 1507 165.00 .00 .00 .00 .00 165.00 F /A0000361 10 /11 /01 11 /10 /01 1483 110.00 .00 .00 .00 .00 110.00 F /A0000390 01/04/02 02/03/02 1398 165.00 .00 .00 .00 .00 165.00 TOTAL: 0000000138 ON ACCOUNT: .00 605.00 .00 .00 .00 .00 605.00 0000000347 PELLING RESIDENCE PHONE: 805 CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000640 09/25/03 10/25/03 769 165.00 .00 .00 .00 .00 165.00 TOTAL: 0000000347 ON ACCOUNT: .00 165.00 .00 .00 .00 .00 165.00 Q 00000'Q150 PFISTER RESIDENCE PHONE: 805 - CONTACT: O INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 10 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:17:10 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust _ no AND mrcustomer.clnttype = "F /A" and mrcustbill.total _ due> "0.0" and mrcustbill 1 OUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000158 10 /11 /00 11 /10 /00 1848 100.00 .00 .00 .00 .00 100.00 F /A0000217 01/31/01 03/02/01 1736 150.00 .00 .00 .00 .00 150.00 F/A0000269 05/31/01 06/30/01 1616 1,155.00 .00 .00 .00 .00 1,155.00 TOTAL: 0000000150 ON ACCOUNT. .00 1,405.00 .00 .00 .00 .00 1,405.00 0000000456 R &R DISCO PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000031 10/29/99 11/28/99 2196 300.00 .00 .00 .00 .00 300.00 TOTAL: 0000000456 ON ACCOUNT: .00 300.00 .00 .00 .00 .00 300.00 0000000063 ROLLS ROYCE MOTOR CARS PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000203 12/31/00 01/30/01 1767 950.00 .00 .00 .00 .00 950.00 F /A0000240 03/31/01 04/30/01 1677 500.00 .00 .00 .00 .00 500.00 F/A0000246 04/17/01 05/17/01 1660 3,000.00 .00 .00 .00 .00 3,000.00 F/A0000322 09/04/01 10/04/01 1520 550.00 .00 .00 .00 .00 550.00 F/A0000323 09/04/01 10/04/01 1520 550.00 .00 .00 .00 .00 550.00 F/A0000324 09/04/01 10/04/01 1520 550.00 .00 .00 .00 .00 550.00 F/A0000337 09/17/01 10/17/01 1507 550.00 .00 .00 .00 .00 550.00 TOTAL: 0000000063 ON ACCOUNT: .00 6,650.00 .00 .00 .00 .00 6,650.00 0000000348 SASENICK RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000523 04/06/03 05/08/03 939 165.00 .00 .00 .00 .00 165.00 F/A0000585 06/09/03 07/09/03 877 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000348 ON ACCOUNT: .00 220.00 .00 .00 .00 .00 220.00 0000000459 SAVAGE RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000033 10/29/99 11/28/99 2196 800.00 .00 .00 .00 .00 800.00 TOTAL: 0000000459 ON ACCOUNT: .00 800.00 .00 .00 .00 .00 800.00 0000000129 SPECIAL DEVICES PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000101 07/21/00 08/20/00 1930 150.00 .00 .00 .00 .00 150.00 (� F /A0000168 11/08/00 12/08/00 1820 100.00 .00 .00 .00 .00 100.00 TOTPo 0000000129 ON ACCOUNT: .00 250.00 .00 .00 .00 .00 250.00 0000460 SEIGAL RESIDENCE PHONE. 805 - MO /M r PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 11 DATE: 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:17:10 CUSTOMER AGING REPORT SELECTION CRITERIA: SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill.cust no AND mrcustomer.clnttype = "F /A" and mrcustbill.total due> "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000034 08/25/99 09/24/99 2261 50.00 .00 .00 .00 .00 50.00 TOTAL: 0000000460 ON ACCOUNT: .00 50.00 .00 .00 .00 .00 50.00 0000000374 SHERBINO RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000219 01/31/01 03/02/01 1736 50.00 .00 .00 .00 .00 50.00 TOTAL: 0000000374 ON ACCOUNT: .00 50.00 .00 .00 .00 .00 50.00 0000000108 STAR WEST INC PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000369 12/03/01 01/02/02 1430 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000108 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000359 T.N.D. PRECISION, INC PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000071 04/30/00 05/30/00 2012 350.00 .00 .00 .00 .00 350.00 F /A0000102 07/21/00 08/20/00 1930 450.00 .00 .00 .00 .00 450.00 F /A0000111 08/01/00 08/31/00 1919 500.00 .00 .00 .00 .00 500.00 F /A0000159 10 /11 /00 11 /10 /00 1848 350.00 .00 .00 .00 .00 350.00 F /A0000181 11/22/00 12/22/00 1806 350.00 .00 .00 .00 .00 350.00 TOTAL: 0000000359 ON ACCOUNT: .00 2,000.00 .00 .00 .00 .00 2,000.00 0000000151 TOTALLY POLISHED PHONE: 80s_ CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000160 10 /11 /00 11 /10 /00 1848 150.00 .00 .00 .00 .00 150.00 TOTAL: 0000000151 ON ACCOUNT: .00 150.00 .00 .00 .00 .00 150.00 0000000130 TURNING POINT RACING PHONE. 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000104 07/21/00 08/20/00 1930 150.00 .00 .00 .00 .00 150.00 TOTAL: 0000000130 ON ACCOUNT: .00 150.00 .00 .00 .00 .00 150.00 000 00087 VANESSA PANDERTA PHONE: 805 - (� CONTACT: M� INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 PENTAMATION ENTERPRISES - ACCOUNTS RECEIVABLE MANAGER PAGE NUMBER: 12 DATE. 12/02/05 CITY OF MOORPARK MODULE: mragerrp TIME: 11:17:10 CUSTOMER AGING REPORT SELECTION CRITERIA; SELECT mrcustomer. rowid,mrcustomer. *,mrcustbill.* FROM mrcustomer,mrcustbill WHERE mrcustomer.cust_n o = mrcustbill cust_no AND mrcustomer.clnttype = "F /A" and mrcustbill.total_ due > "0.0" and mrcustbill 1 CUST NO BILLING NAME - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000082 05/31/00 06/30/00 1981 300.00 .00 .00 .00 .00 300.00 F/A0000625 09/11/03 10/11/03 783 165.00 .00 .00 .00 .00 165.00 TOTAL: 0000000087 ON ACCOUNT: .00 465.00 .00 .00 .00 .00 465.00 0000000311 WEINSPERINN RESIDENCE PHONE: 805- CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F/A0000486 09/12/02 10/12/02 1147 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000311 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0000000351 WUNDERLICH RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /A0000515 04/08/03 05/08/03 939 165.00 .00 .00 .00 .00 165.00 TOTAL: 0000000351 ON ACCOUNT: .00 165.00 .00 .00 .00 .00 165.00 0000000357 ZIMMER RESIDENCE PHONE: 805 - CONTACT: INVOICE NO INV DATE DUE DATE DAYS - -TOTAL DUE -- - CURRENT /< - - -- -OVER - - -- -OVER 30 - - -- -OVER 60 - - -- -OVER 90 F /AO000563 04/14/03 05/14/03 933 55.00 .00 .00 .00 .00 55.00 TOTAL: 0000000357 ON ACCOUNT: .00 55.00 .00 .00 .00 .00 55.00 0 Q c r