Home Accounts

Document Sample
Home Accounts Powered By Docstoc
					                                                                                                                                                                                                                                                                           State of Wisconsin
                                                                                                                                                                                                                                                             Integrated Business Information System (IBIS)
                                                                                                                                                                                                                                                                  Subsystem Survey - AR Sub-Systems




                                                                                                                                                                                 WiSMART Interface
                                                                                                                                        Homegrown                                (Included
                                                                                                      Off the      Software Name         (included                               Interfaces to FMS
Agency System Name                        Brief Description of Function                                Shelf        If Purchased        contracted) Programming Language         or DOT systems)
   245 N/A                                Agency does not have subsystems.
   510 N/A                                Agency does not have subsystems.
   575 N/A                                Agency does not have subsystems.
                                          Badger State Industries Accounting System creates
                                          invoices to customers for items ordered, tracks
                                          amounts due by invoice number. CR transactions
      410 Proteus                         are created manually.                                         NO                                    YES                                Manual
                                          Waupun Central Warehouse Accounting System
                                          creates invoices to customers for items ordered,
                                          tracks amounts due by invoice number. CR
      410 Platinum                        transactions are created manually.                            YES                                   NO                                 Manual
                                          Division of Community Corrections system tracks
                                          offender amounts due for Supervision fees. US
                                          Bank lock box CR's to Wismart. CACU will be
      410 CACU - Supervision Fees         replaced by ICS.                                              NO                                    YES                                US Bank Lock Box
                                          Division of Community Corrections system tracks
                                          offender amounts due for Court Ordered
                                          Obligations such as Restitution and surcharges.
          CACU - Court Ordered            US Bank lock box CR's to Wismart. CACU will be
      410 Obligations                     replaced by ICS.                                              NO                                    YES                                US Bank Lock Box
                                          Division of Adult Institutions and Davison of
                                          Juvenile Corrections system tracks inmate funds
                                          due and Vending Stands (aka Canteen). WITS will
      410 WITS                            be replaced by ICS.                                           YES                                   YES                                Not on State Books
                                          Departmentwide Miscellaneous Invoices are
                                          created in EXCEL, posted and aged in EXCEL by
      410 Invoices -MISC                  Business Offices                                              YES                                   NO                                 Manual
                                          The UW System does not record accounts
                                          receivable in the state accounting system as
      285                                 requested by the SCO.
                                          All CR documents for the UW are prepared on line.
                                           The UW does not currently interface CR
      285                                 documents.
143                                       Fiscal system, manual process from Excel, Regulated Objects and Pearl
144         Verisign                      Credit card processing: Verisign runs payment through
                                          processor (Nova). Reconciliation between what is sent and
                                          received from Verisign done nightly. Verisign deposits
                                          funds received to US Bank.
145         COSMOS                        Generates invoices for copy fees, publications, annual
                                          assessments and license renewals. JV done monthly to
                                          allocate revenue received.
145         LGPIF                         Pinsoft P&C Policy and Premium System.
145         SLIF                          Policy administration system, sends out premium and loan
                                          interest billings monthly for appropriate policies.
145         IPFCP                         PCF Assessment System, traces sent bills, payments and
                                          receivables. Quarterly accrual entry to general ledger done
                                          monthly based on system reports.
      245 Counterpoint                    Tracks sales and produces receipts.
      245 VISTA                           Creates invoices through Crystal reports.
      515 Benefit Payment System          The OREL table is downloaded daily                            NO                                    Yes   Java                         ??
                                          This table is used for deductions from annuity,
                                          single cash sums, deaths, and other payments
      515                                 made to individuals.                                                                                                                   ??
      515                                 The OREL table is used for financial reporting.               yes              Helmsman                   Microsoft
                                          This system tracks all loans we make to our
                                          customers. Monthly it is reconciled to the
      507 BCPL Loan System                receivable balance on Wismart.                                 no                                   yes
                                          Our agency does not have any accounts receivable
                                          systems that interface with WiSMART. Our agency
                                          tracks its accounts receivables in SIRCON,
                                          however, we do not record any receivable in
                                          WiSMART. The Injured Patients and Families
                                          Compensation Fund tracks their accounts
                                          receivables and billings in their Oracle System.
      145                                 The State Life Fund and Local Government
            Cashier Lockbox               Remittance sheets for the sale of goods and                    No                                   Yes   Cobol, SAS, JCL              87
            Remittances (CRs)             services are entered by a data entry service. CR
                                          transactions are interfaced to WiSMART. (Note:
                                          This interface hasn't been used since FY2004. The
                                          current process is to upload $0 CRs. See the
                                          Macros and Upload Utilities worksheet.)
      370
            Licensing Lockbox             JRs are created to do the distribution from the                  No                                 Yes   Unix, Cobol, SAS, JCL        80
            Revenue Transfer (JRs)        lockbox clearing account to the appropriate
                                          revenue accounts for General Hunting & Fishing
                                          Licenses; Boat, Snowmobile & ATV renewals;
                                          Boat, Snowmobile & ATV registrations. Lockboxes
                                          are 1810, 6301, 7010. Data is entered by a data
                                          entry service. The Licensing sub-system is
                                          updated and JR transactions are interfaced to
      370
                                          WiSMART.
            Automated License             There is a weekly bank sweep from the lockbox for                No                                 Yes   Unix, Cobol, SAS, JCL        IW
            Issuance System (ALIS)        DNR's On Line License System. JR transactions
            (JRs)                         are created to do the distribution from the lockbox
                                          clearing account to the appropriate revenue
                                          accounts. JR transactions are interfaced to
      370                                 WiSMART.
                                                                                                                      Answers on
                                                                                                                     Demand/ But
                                                                                                                      upgrading in
                                                                                                                    contracting with
                                                                                                                   Keane at King and
          Veterans Home Accounts                                                                                  ECS (American Data)
      485 Receivable                      Generates billings based on patient census                       Yes       at Union Grove                                              Does not interface/manually reconciled. Summary data entered into wismart
          LAS currently will be fully
          converted to ILS in
          November. Info provided                                                                                   Interlinq Loan
      485 for ILS                         Loan accounting system for outside loan servicers                Yes     Servicing System                                              Does not interface/manually reconciled. Summary data entered into wismart
                                                                                                                   Mortgage Service
      485 MSS                             Loan accounting system for loans serviced by DVA                 Yes          System                                                   Does not interface/manually reconciled. Summary data entered into wismart

                                          Interfaces CR transactions to WiSMART via user
                                          initiated batch EHLLAPI screen scraping. Real Time                                                                                     To WiSMART (screen
                                          screen scraping is used to work WiSMART errors                                                                                         scraping). To FOS and
                                          and coding changes are updated in both DOA and                                                                                         LRS (interface
                                          DOT systems similtaneously. Interfaces Project                                                                                         program is COBOL;
      395 Receipts System                 level transactions to FOS, LRS and MRS.                          No                                 Yes   Smalltalk                    data is a flat file)

          Financial Operating
          System (FOS) (a project
      395 accounting system)              All transactions recorded at a Project level.                    No                                 Yes   COBOL

                                                                                                                                                                                 To Receipts (interface
          Locals Revenue System                                                                                                                                                  program is COBOL;
      395 (LRS)                           Interfaces Invoice/Project level coding to Receipts              No                                 Yes   COBOL                        data is a flat file)

                                                                                                                                                                                 To Receipts (interface
          Miscellaneous                                                                                                                                                          program is COBOL;
      395 Receivables System (MRS) Interfaces Invoice/Project level coding to Receipts                     No                                 Yes   MS Access                    data is a flat file)
                                         Interfaces to summarized project / object level
                                         receipt information to Receipts System. Also,                                                                                           To Receipts (interface
                                         interfaces batch refund payments to the                                                                                                 program is COBOL);
                                         Specialized Check Writer. For the associated                                                                                            To Specialized Check
                                         accounting entry, summarized MW is entered                                                                                              Writer (flat file created
      395 DMV Financial System           manually into WiSMART.                                            No                                 Yes   COBOL                        by COBOL)
                                         Interfaces to FHWA using mainframe batch FTP
      395 FHWA Electronic Bill           process                                                           No                                 Yes   COBOL                        To FHWA
      395 Aeronautics Bill               Manually keyed online using Federal system
      395 FRA                            Manual
      395 FTA                            Manually keyed online using Federal system
      395 NHTSA                          Manually keyed online using Federal system
      395 Damage Claims (AR)             Stand alone
      190 PeachTree                                                                                        Yes                                No
                                         Kids Information Data System – Child support tracking and
                                         disbursement system used by DWS, Bureau of Child
                                         Support. Collections are received and posted directly to                                                                                None - MW done manually
                                         KIDS by the child support CR&D vendor, currently ACS.                                                                                   on WISMART for check
      445 KIDS                           Collections are reported by the CR&                          No                                Yes         Visual Basic, Cobal          writers
                                         Aid tracking and disbursement system. There are multiple
                                         CARES check writers…Child Care Checks, Child Care                                                                                       None - MW done manually
                                         ACH, Daily, W-2 First Run, W-2 Second Run, W-2                                                                                          on WISMART for check
      445 CARES                          Benefits, W-2 Vendor, and W-C Delayed                        No                                Yes         Visual Basic, Cobal          writers
                                         Central Office Reporting - DWS - Grant Processing                                                                                       P1 - 13, WiSARD,
                                         system for sub-recipients of state and federal funds. This                                                                              FrontPage for Website
                                         sends flat file to WISMART w/ ACH information which is                                                                                  nightly publication, MW
                                         also manually keyed as a MW daily. This also records and                                                                                manually done on
      445 CORE                           processes spreadsheet uploads f                              Yes         CORE                  No          FoxPro                       WISMART for ACH
                                         Generates invoices for Uninsured Employers Fund & Work
                                         Injury Supplemental, these transactions are not interfaced
                                         to WISMART, but a manual summary JV is done at month
                                         end to recognize billings. Cash Receipts are entered into                                                                               Manual entries done on
      445 W/C A/R                        WISMART and W/C A/R                                          Yes         FARS                  No          Cobol                        WISMART in summary
                                         System calculated and initiates additional monthly Workers
                                         Comp payments. Interfaces to TED through two
                                         automated check writers: 2nd Injury and Children's Death
      445 W/C Children's & Second Injury Benefit                                                      No                              0 Yes         VB.Net, Guard FTP, Cobol     Interface to TED

                                          Labor Standards Information System - ER - this system
                                          tracks and calculates payment to employees through E/R.
                                          This then goes to a check writer that interfaces to TED.
                                          There is also an interface from WISMART to EIEP,                                                                                       Interface to TED,
      445 LSIS                            showing deposits made by employers.                         No                              0 Yes                                    0 Interface from WISMART
          CRES                            Central Recoveries Enhanced System for Public
                                          Assistance Collections, including AFDC, Food Stamps,
                                          Job Access Loans, Childcare, Medical Assistance and W-
      445                                 2. Recorded when funds received.




                                      4ca66981-4aad-41cc-87df-df0ed0741da0.xls                                                                                                                                                                                              Updated 6/13/2006                1 of 2
                                                                                                    State of Wisconsin
                                                                                      Integrated Business Information System (IBIS)
                                                                                      Subsystem Survey - Macros and Upload Utilities



                                                                                                                  Homegrown
                                                                                                                   (included
Agency    System or File Name                Brief Description of Function              Software Application      contracted)    Transfer Method
   245   N/A                       Agency does not have subsystems.
   510   N/A                       Agency does not have subsystems.
   575   N/A                       Agency does not have subsystems.
   410   N/A                       Agency does not use macros.
   285   N/A                       Agency does not use macros.
                                   P1 data is keyed into spreadsheet and then
                                   transferred to WiSMART using VBA. (Examples of
                                   transactions: Refunds and Payments for General
                                   Licenses + Permits, Solid Waste and Haz. Waste
                                   Fees, Managed Forest Lands Taxes, Fishing
                                   Licenses, Combination Licenses, Game Licenses,
                                   Sale of Goods + Services, ATV Registration +
                                   Fees, Boat Reg. + Fees, Snowmobile Reg. + Fees,
                                                                                                                                Transfers P1 data to
                                   Parks and Forests Stickers + Fees, Environmental
                                                                                                                                Smarterm Screen
                                   and Conservation Fees, Timber Sales, Payment of
                                                                                                                                using OLE
                                   Taxes, Gifts + Donations)
   370 Smarterm P1 Uploader                                                           Microsoft Excel 2003, VBA       yes       Automation
                                   P1 data is keyed into spreadsheet and then
                                   transferred to WiSMART using VBA. (Examples of
                                   transactions: Refunds and Payments for General
                                   Licenses + Permits, Solid Waste and Haz. Waste
                                   Fees, Managed Forest Lands Taxes, Fishing
                                   Licenses, Combination Licenses, Game Licenses,
                                   Sale of Goods + Services, ATV Registration +
                                   Fees, Boat Reg. + Fees, Snowmobile Reg. + Fees,
                                   Parks and Forests Stickers + Fees, Environmental
                                                                                                                                Transfers P1 data to
                                   and Conservation Fees, Timber Sales, Payment of
                                                                                                                                HOD Screen using
                                   Taxes, Gifts + Donations)
   370 HOD P1 Uploader                                                                Microsoft Excel 2003, VBA       yes       OLE Automation
                                   JR data is keyed into spreadsheet and then                                                   Transfers JR data to
                                   transferred to WiSMART using VBA                                                             Smarterm Screen
                                                                                                                                using OLE
   370 Smarterm JR Uploader                                                           Microsoft Excel 2003, VBA       yes       Automation
                                   JR data is keyed into spreadsheet and then
                                   transferred to WiSMART using VBA                                                             Transfers JR data to
                                                                                                                                HOD Screen using
   370 HOD JR Uploader                                                                Microsoft Excel 2003, VBA       yes       OLE Automation
                                   JV data is keyed into spreadsheet and then                                                   Transfers JV data to
                                   transferred to WiSMART using VBA                                                             Smarterm Screen
                                                                                                                                using OLE
   370 Smarterm JV Uploader                                                           Microsoft Excel 2003, VBA       yes       Automation
                                   JV data is keyed into spreadsheet and then
                                   transferred to WiSMART using VBA                                                             Transfers JV data to
                                                                                                                                HOD Screen using
   370 HOD JV Uploader                                                                Microsoft Excel 2003, VBA       yes       OLE Automation
                                   CR data is keyed into spreadsheet and then                                                   Transfers CR data to
                                   transferred to WiSMART using VBA                                                             Smarterm Screen
                                                                                                                                using OLE
   370 Smarterm CR Uploader                                                           Microsoft Excel 2003, VBA       yes       Automation
                                   CR data is keyed into spreadsheet and then
                                   transferred to WiSMART using VBA                                                             Transfers CR data to
                                                                                                                                HOD Screen using
   370 HOD CR Uploader                                                                Microsoft Excel 2003, VBA       yes       OLE Automation
                                   CR data is imported to distribute revenues to                                                Transfers CR data to
                                   specific revenue source codes from lockboxes and                                             Smarterm Screen
                                   then transferred to WiSMART using VBA                                                        using OLE
   370 Smarterm 0$ CR Uploader                                                        Microsoft Excel 2003, VBA       yes       Automation
                                   CR data is imported to distribute revenues to
                                   specific revenue source codes from lockboxes and                                             Transfers CR data to
                                   then transferred to WiSMART using VBA                                                        HOD Screen using
   370 HOD 0$ CR Uploader                                                             Microsoft Excel 2003, VBA       yes       OLE Automation




          4ca66981-4aad-41cc-87df-df0ed0741da0.xls                                                        Updated 6/13/2006                            2 of 2

				
DOCUMENT INFO
Description: Home Accounts document sample