AR BATCH PROCESSES

Process / Description / Batch Runs At
Inter-Agency Pending Item Inbound Interface / An interface to import receivables for DRS. Items brought in through the interface will have a Group Type of 'B' for Billing and an Origin of 'XBILL' for External Billing System. / Tuesday -Saturday
6:30am
Lockbox Deposit / A lockbox is a bank account that is used as a remit-to for other agencies. The bank receives payments and applies them to that lockbox bank account, making the funds available to your agency as soon as the payments are processed by the bank. Core-CT will electronically load the deposit and payment information from the lockbox account. GIRO payments are handled this way. / Monday – Friday
overnight
( beginning at 7pm)
Payment Predictor / Payment Predictor is an automatic process that applies cash for payments entered through Lockbox deposits. Payment Predictor uses structured query language (SQL) commands that are defined at the Business Unit or customer level. All payments applied to open items can be handled this way. / Monday – Friday
2pm and overnight
(beginning at 7pm)
Bank Statement Interface / The movement of data electronically between the bank and Core-CT Receivables, in a structured computer processable data format that permits data to be transferred without re-keying. All monies that have been deposited through the bank (Bank of America, Webster and First Union) will be interfaced into CORE and the deposit will be created based upon the information the bank has sent on the bank statement. The accounts that deposits are created for are determined by OTT. / Monday – Saturday
7am
Receivable Update / The Receivables posting process in Core-CT. All information entered into or created by Core-CT are pending items until Receivable Update is run to post them. When this process has run, these items are posted and finalized. Posts pending items that have been entered online, interfacedor sent through the Billing Interface’s processes, payments, and processes item maintenance activities. Processes groups of pending items in order to update a customer's balance (subsidiary ledger) and system-defined history elements. / Monday – Friday
10am, 2pm, and overnight (beginning at 7pm)
Process / Description / Batch Runs At
Automatic Maintenance / This is a stand-alone process that uses Maintenance Worksheets to match debits and credits then leaves them for the user to match, add reason codes, and close out / Monday – Friday
2pm and overnight
(beginning at 7pm)
Revenue Estimate / Uses the revenue accounting lines in the Item Distribution (ITEM_DST) table to generate the source transactions for the Control Budget Ledger. Generates one source transaction for each revenue line. If the activity does not generate a revenue line, it searches the previous activity for a revenue account.The entry type or the combination of the entry type and reason define how and when to generate source transactions based on preset values in the system function (activity). If it is not user-defined, the system function (activity) specifies whether to:A) Update Recognized Revenue B) Update Collected Revenue,or C) Update both Revenue buckets. (see AR Reversal) / Monday – Friday
10am, 2pm, and overnight (beginning at 7pm)
AR Reversal / Entries that are created in the Accounts Receivable module recognize revenue when posted to the General Ledger. These entries debit AR and credit Revenue in the MOD_ACCRL ledger. Most agencies in the State recognize revenue when cash is actually deposited.Therefore, the State of Connecticut requires reversing the AR entries thatare made in the MOD_ACCRL ledger with entries in the MOD_CASH ledger that debit Revenueand credit AR. This allows the State to report by combining these two ledgers (MOD_ACCRL andMOD_CASH) and view the appropriate revenue amount. This process takes the results of the Revenue Estimate process and creates the reversing accounting entries in the delivered ITEM_DST table to the Modified Cash Ledger based on the activity (system function) of each AR transaction. / Monday – Friday
Overnight
(beginning at 7pm)
Runs for Projects- 2AM
Process / Description / Batch Runs At
Budget Checking / Reviews the control budget entries, updates the two revenue estimate buckets (Recognized Revenue and Collected Revenue), and creates the commitment control budget lines. / Monday – Friday
10am, 2pm, and overnight (beginning at 7pm)
Journal Generator / Creates General Ledger journal entries from accounting entries created in AR. Edits and posts the journals created. Supports negative DR/CR (debit/credit) entries for correcting entries. Validates journals according to the criteria set up in the General Ledger. Populates the journal ID and journal date fields after it distributes the accounting entry to a General Ledger journal. Populates the accounting period and fiscal year fields after it distributes the accounting entry to a General Ledger journal based on the journal date. / Monday – Friday
3pm and overnight (beginning at 7pm)

Revised 1/3/2013