Process
Time (EST)
Responsible
Description
Invoice Files
Every 15 min
Invoice Cloud
System sweeper fetches & loads invoice files from SFTP into Invoice Cloud (IC). Invoice Files are loaded 1-2 times a week.*
Adjustment File
Every 2 hours starting
@ 2:26am (EST)
Hernando
Provides customer account balances to Invoice Cloud. A scheduled job on the Utilities ‘Billing virtual pc’ runs a script to pull customer account balances from UB every 2 hours and places the file onto SFTP site. IC sweeper picks up the file to load into the IC biller portal. The first file each day is posted at 2:26am to the Invoice Cloud biller portal.
Payment File
Daily 2:09am
Invoice Cloud
Payments batch at 11:59pm & placed onto SFTP site at 2:09 am. Custom Payment Retrieval Tool program retrieves the file from SFTP when staff import the file.
Credit/Void File
Daily 2:09am
Invoice Cloud
Credit/Void batch at 11:59pm & placed onto SFTP site 2:09 am. A scheduled job runs at 3:00am to pick up the file from SFTP to place into Utilities Common Drive.
Delinquent API
Near Real Time
Hernando/IC
Hernando utilizes Invoice Cloud API call to pull payment information for accounts in Delinquent Manager
AutoPay
Near Real Time
Invoice Cloud
AutoPay payments are shown in near real time
ChangeLogs
Daily 2:10am
Invoice Cloud
Customer changes include: Email, phone, paperless, autopay. A scheduled job runs at 3:00am to pick up the file from SFTP to place into Utilities Common Drive
Paperless API
Near Real Time
Cathedral/IC
Cathedral utilizes Invoice Cloud API call to generate a list of paperless customers. The API call is performed before Cathedral mails customer invoices.
*Invoice file invoice date is coded to match with Cathedral invoice images. If the invoice files posting to the biller portal are delayed one or more business days, the invoice date information will need to be manually changed to reflect the information for the file (due date, etc)