Financial Subsystems

Receivables

The accounts receivable application processes all transactions on an open item basis. Transactions appear on a monthly statement at least once. All transactions for a given invoice number will be saved until they balance to zero. Balanced transactions may be purged after the customer's next statement.

Invoice transactions will automatically be posted to accounts receivable by billing.

Accounts receivable application supports customer inquiry to review summary or detail transactions.

Payments are applied to the customers detail invoices. A customer's invoices will be displayed and check amounts will be posted to each invoice transaction. Unapplied cash will be posted as separate transactions with check number and date within each customer.

The aged trial balance, as with A/R inquiry, will provide two levels of detail; either customer summary or invoice detail with all transactions. These reports can be in customer account number or name sequence.

Customer statements will include all open transactions in detail. Statements may be printed for all customers with balances or specific customers only. Optionally, customers with zero or credit balances may be printed. A customer message may be printed on statements and changed each month.

General Ledger

The General Ledger application will receive automatic journal entries from the daily sales journal, daily cash receipts journal, daily expense distribution journal and daily cash disbursements journal.

All standard journal entries will be maintained in a file which will update general ledger with detail transactions each month.

The general ledger application will maintain an audit trail of all transactions each month. A general ledger detail transaction report will be available at the end of each accounting period or at year end.

The general ledger application will also provide the ability to enter manual journal entries into the system. This procedure will be interactive and will allow the operator to balance debits and credits for each journal entry prior to proceeding to the next journal entry.

Accounts Payable

The accounts payable application is designed for the interactive entry of vendor invoices. These open payable items may then be listed in several sequences and formats for review. Open payables invoices may be selected for payment through screen review and cash disbursements journal which verifies selections and payment totals. Upon approval, the system prints checks and updates appropriate general ledger accounts if the general ledger is installed.

Prior to entry, all vendors invoices are coded for entry with all necessary information such as vendor number, expenses account numbers and discountable amounts. Voucher numbers may be pre-assigned or may be assigned by the system. A cash total of all invoices to be entered are used to balance each day's entries before payables and G/L distribution files are updated.

All entries on which discounts are applicable are written to the open payables file for the gross amount of the invoice. Discounts taken are distributed to the general ledger accounts when the invoices are selected and approved for payment.

Vendor invoice entry provided for the entry of prepaid invoices by allowing the operator to enter the check number and date. Prepaid invoice amounts are distributed to expense accounts with the current balances batch. During the next payment selection cycle, any prepaid invoices are automatically included and appear on the cash disbursement journal.

When entering vendor invoices, an invoice may be placed on hold status. This invoice may not be selected for payment until the hold condition is changed through the open payables update procedure.

The distribution of expense amounts is entered at initial invoice entry. Provision is made for the entry of account numbers and corresponding distribution amounts. The sum of all distribution amounts per invoice must balance to each gross invoice amount before the invoice will be accepted. General ledger account numbers may be assigned to a vendor and entered into the vendor master file. This default account number will be used if no account number is entered with the expense distribution.

The accounts payable cycle, both invoice entry and payment selection may be run as often as necessary. The following reports provide a daily audit trail: Daily Vendor Invoices Entered, Daily Expense Distribution, Daily Cash Distribution, Daily Cash Disbursements Journal. These reports are also available at month- end and contain all transactions for the month.

The Vendor master file is available for inquiry of dollar totals or total-purchase-to-date, purchase-year-to-date, previous-12-month's purchases, aged current open payables and vendor credit limit.

The open payables report contains summary information about each unpaid vendor invoice and manifest. This report may be produced for all payables aged by due date report and is used for cash requirements planning. All open payables reports are available by vendor category.

Open payable items may be selected for payment by individual vendor, individual invoice or due date. All selections are listed on a preliminary cash disbursements journal prior to printing checks. Invoices may be added to or deleted from the selection batch and the cash disbursements journal may be reprinted. Upon final approval, the payables checks are printed.

A recent enhancement to the Accounts Payable package is the refund interface with the DIRECTIONS system. Cash refunds are now made automatically by the system when other invoices are paid.

Functions

Invoices post automatically from billing
Payments posted to invoices or "on account"
Summary and detail aging
AR history available in call center order entry
GL transactions posted from billing, AR, inventory, payables, and journal entries
Unlimited income statement and balance sheet formats
Payables can start from received purchase orders
Could not access database usrpa.