Cash Reconciliation

Menu Summary Sys. Req. Compatibility Request Demo Downloads Ask Question

The Cash Reconciliation module is designed to allow full control over the processing of checks, deposits and adjustments to multiple cash accounts within the accounting and financial system. This cash reconciliation system comes fully integrated with the accounts payable, payroll and accounts receivable modules. Reconciling your bank accounts is simply a matter of checking off the cleared checks and entering any additional bank charges, manual deposits or interest income. The system will automatically carry ending balances over to the next cycle and update the general ledger with any new transactions entered. The system will provide a register at the end of each cycle showing all the cleared checks, cleared deposits and other activity. A final outstanding register will be printed at posting time.

Multiple Companies Multiple Cash Accounts Multi-user capable Full integration with the accounts receivable system Full integration with the payroll system Full integration with the accounts payable system Ability to archive reports Ability to email any report Ability to fax any report Unlimited transaction history User level security, with company/location permissions Toll-free telephone support during warranty On-line technical support Source code included Three-month warranty

All CSS software is currently compatible with OS/400 V4R5M0 – V6R1M0. As new releases are installed older ones will be replaced. CSS will always ensure that our software remains compatible with any OS/400 operating system IBM is shipping.

There are several features in our software that will not work on machines below V5R3M0. Some of these features include:

Advanced output options Archiving reports in PDF format Emailing reports

The Cash Reconciliation system is designed to integrate with several other modules. Clients wanting to interface this module with existing in-house systems can do so easily. Contact our office for more information.

The cash reconciliation requires that you purchased at least one of the following modules:

Accounts Receivable Accounts Payable Payroll Point of Sale

Optional modules you may want to consider:

General Ledger Fixed Assets Faxing, Email and Archiving

Here is a summary of how this module interfaces with our other modules:

Accounts Receivable	The C/R module will be updated with the deposits and adjustments made from the A/R module. The system will create entries in the CSREQ file.
General Ledger	The general ledger transaction file will be updated with entries made from the cash reconciliation posting procedure. The system will create records in the GLTRX file.
Accounts Payable	The A/P system will update the C/R module with all the checks and voided checks created in that system. The system will create entries in the CSREQ file.
Payroll System	The payroll module will update the C/R module with all the payroll checks created in that system. The system will create entries in the CSREQ file.
Point of Sale	The POS system will update the C/R module with any payment information from that system. The system will create entries in the CSREQ file.
Faxing System	CSS has integrated our interactive faxing software with the C/R module to allow faxing of any report. The faxing system is for outbound faxing only. This option requires that you purchase the CSS faxing system and provide a phone line.
Email System	CSS has integrated our emailing software with the C/R module to allow emailing of any report. The document will be sent as a PDF attachment. This email system is for outbound emailing only.
Archiving System	Interfacing with this module will allow archiving any C/R report or postings to the iSeries IFS.

The Cash Reconciliation System has one menu that contains the check process along with the print and purging facilities. The following is a summary of each menu option available to the cash reconciliation user. You can find more detailed information for each option in our software users manuals.

CSHMENU1              Cash Reconciliation Select one of the following:    1. Reconcile Cash Account    2. Print Reconciliation Activity    3. Post Reconciliation Activity    4.    5. Print Cash Activity Report    6. Purge Cash Activity    7.    8.    9. Enter Manual Deposits   10.   11. Cash Parameter Maintenance   12. Return to CSS Main Menu                                    30. Display A/R Documentation Selection or command               90. Signoff ===> ___________________________________________________

C/R Menu 1 Option 1 – Reconcile Cash Account
This procedure will allow selection of a cash account to reconcile. You may reconcile as many accounts as needed. The program will allow selection of checks, deposits, and entry of any adjustments needed. The system will guide the user through reconciling the cash account with the bank statement.

C/R Menu 1 Option 2 – Print Reconciliation Activity
This procedure will print all activity entered in the maintenance program. Users can verify all data and correct any mistakes. The edit can be ran as many times as needed before posting the activity.

C/R Menu 1 Option 3 – Post Reconciliation Activity
This procedure will post all activity to the cash account. A report will be generated showing what was posted.

C/R Menu 1 Option 5 – Print Cash Activity Report
This program will print the activity history for any cash account for a selected date range.

C/R Menu 1 Option 6 – Purge Cash Activity
This program will delete unwanted cash activity history records for the selected date range.

C/R Menu 1 Option 9 – Enter Manual Deposits
This procedure will allow entry of manual deposits into the cash accounts. This would include any deposits that were not made through the accounts receivable system.

C/R Menu 1 Option 11 – Cash Parameter Maintenance
This procedure will allow setup of the cash reconciliation system parameters. These parameters must be setup before using the cash reconciliation system.

C/R Menu 1 Option 12 – Return To Main CSS Menu
This option will take you back to the CSS main menu.