PRCHKSCN Payroll Check Reconciliation Report

Check Reconciliation Report

Application Overview

 

The Check Reconciliation Report application provides a report of all outstanding checks as of a particular date.  The report will also, optionally, print all checks, which were reconciled on a particular bank statement.

In order to generate these reports, you must answer "Y" to the Reconcile Checks field in Payroll Setup.

The following is one procedure to use in reconciling checks:

1.    After all the checks are entered via Check Reconciliation in the Processing pull down window, you can print the Check Recon­ciliation Report.

       Select the range of dates for which you wish to show checks (the ending date should be the same as the statement date), and select only unpaid checks.

2.    This report displays all outstanding checks (those that the bank has not paid yet).

3.    Find out what the checkbook total was for the account on the statement ending date.  This total, plus the total outstanding checks shown on the report, minus any charges shown in the state­ment should equal the account ending balance shown on the statement.

4.    If these amounts are not equal, then you must figure out why.  First, compare the total of reconciled checks to the figure on the bank statement.  If they do not match, find which check amount is incorrect.  Make sure that the last statement was properly recon­ciled.  Make sure that there are no arithmetic errors in the checkbook.  Correct any errors found.

5.    Enter the charges shown on the statement into the checkbook.

6.    The statement is now reconciled.

Run Instructions

 Select Check Reconciliation Report from the pull down PR Reports window.  The following screen will then be displayed:

 

 

Check Reconciliation Report Entry Screen

 

 The following options are available:

    • Select the desired mode from the Check Reconciliation Report menu bar
    • Enter the data requested on the screen

     To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.

     

    Entry Field Descriptions

     

    Name

    Type and Description

    1.  Show Unpaid Checks?

    Y or N.

    Enter Y if you wish to have checks, which have not been reconciled to appear on the report.

    The default is Y.

    2.  Show Paid Checks?

    Y or N.

    Enter Y if you wish to have checks, which have already been reconciled to appear on the report.

    The default is Y.

    3.  Reconciliation Date

    A date in the standard date format.

    This field is not needed if the answer to Show Paid Checks? was N.

    Press the F1 key to show all reconciliation dates.  If All is selected, then all reconciled checks will appear on the report.

    If a specific date is entered, then any reconciled checks on file with this reconciliation date will appear on the report.

    This field defaults to the current date.

    4.  Purge Reconciled Checks

    Y or N.

    Enter Y if you wish to purge those reconciled checks, which appeared on the report.  This will conserve disk space.

    Enter N if you do not want anything purged from the Check Reconciliation file.

    Normally, you do not want to purge reconciled checks until the bank statement is verified.

    The default is N.

     

    5.  Starting Check Date

    A date in the standard date format.

    This is the starting date of the range of checks that will be printed on the report.

    The default is All dates.

    6.  Ending Check Date

    A date in the standard date format.

    This is the ending date of the range of checks that will be printed on the report.

    The default is the starting check date.

     

     

    Screens

     

     

    Print Check Reconciliation Report

     

     

     

     

    Paryroll

    1. Employer-Sponsored Health Coverage Cost on W-2 Form
    2. Does Elliott Provide Payroll Report to Be Compliant with "Obama Care"?
    3. Feature - Add CSV Support to Payroll History Reports
    4. CHECKREC Payroll Processing Check Reconciliation Overview
    5. CLEAREMP Payroll Processing Clear Employee Totals Overview
    6. DEDCDMNT Payroll Deduction/Earning Code File Maintenance
    7. EMPAUD Payroll Employee Audit Trail Report
    8. EMPTXMNT Employee Tax Code File Maintenance
    9. PRACTMNT Payroll PR Account File Maintenance
    10. PRCHECKS Payroll Post Payroll Checks
    11. PRCHKSCN Payroll Check Reconciliation Report
    12. PRDSTSCN Payroll PR Distribution to G/L Report
    13. PRFRQENT Payroll Calculate Payroll
    14. PRHSTMNT Payroll L and I Code History File Maintenance
    15. PRJBASCN Payroll Job Analysis Report
    16. PRJBDSCN Payroll Job Distribution Report
    17. PRJOBMNT Payroll Job Code File Maintenance
    18. PRLIMNT Payroll L and I Code File Maintenance
    19. PRQTRSCN Payroll Quarterly Payroll Report
    20. PRRPTMNU Payroll Employee Reports
    21. PRSFTMNT Payroll Shift Code File Maintenance
    22. PRW2SCN Payroll W-2 Information File Maintenance
    23. EMPMNT Payroll Employee File Maintenance 1
    24. EMPMNT Payroll Employee File Maintenance 2
    25. EMPMNT Payroll Employee File Maintenance 3
    26. EMPMNT Payroll Employee File Maintenance 4
    27. EMPMNT Payroll Employee File Maintenance 5
    28. EMPMNT Payroll Employee File Maintenance 6
    29. EMPMNT Payroll Employee File Maintenance 7
    30. EMPMNT Payroll Employee File Maintenance 8
    31. EMPMNT Payroll Employee File Maintenance 9
    32. EMPMNT Payroll Employee File Maintenance: Index
    33. PRCTLMNT Payroll PR Setup 1
    34. PRCTLMNT Payroll PR Setup 2
    35. PRCTLMNT Payroll PR Setup 3
    36. PRCTLMNT Payroll PR Setup 4
    37. PRCTLMNT Payroll PR Setup: Index
    38. PRHISTSC Payroll History Reports 1
    39. PRHISTSC Payroll History Reports 2
    40. PRHISTSC Payroll History Reports 3
    41. PRHISTSC Payroll History Reports 4
    42. PRHISTSC Payroll History Reports: Index
    43. PRMANMNU Payroll Manual Transaction Processing 1
    44. PRMANMNU Payroll Manual Transaction Processing 2
    45. PRMANMNU Payroll Manual Transaction Processing 3
    46. PRMANMNU Payroll Manual Transaction Processing 4
    47. PRMANMNU Payroll Manual Transaction Processing: Index
    48. PRMENU Payroll Package Overview 1
    49. PRMENU Payroll Package Overview 2
    50. PRMENU Payroll Package Overview 3
    51. PRMENU Payroll Package Overview 4
    52. PRMENU Payroll Package Overview 5
    53. PRMENU Payroll Package Overview 6
    54. PRMENU Payroll Package Overview 7
    55. PRMENU Payroll Package Overview: Index
    56. PRTAXMNT Payroll State/City Tax Code File Maintenance 1
    57. PRTAXMNT Payroll State/City Tax Code File Maintenance 2
    58. PRTAXMNT Payroll State/City Tax Code File Maintenance 3
    59. PRTAXMNT Payroll State/City Tax Code File Maintenance 4
    60. PRTAXMNT Payroll State/City Tax Code File Maintenance: Index
    61. PRTIMMNU Payroll Time Transaction Processing 1
    62. PRTIMMNU Payroll Time Transaction Processing 2
    63. PRTIMMNU Payroll Time Transaction Processing 3
    64. PRTIMMNU Payroll Time Transaction Processing 4
    65. PRTIMMNU Payroll Time Transaction Processing: Index
    66. 2018 Tax Law Changes

    Feedback and Knowledge Base