PR85.1 – Bank Account Reconciliation
- System
- Payroll (PR)
- Type
- Online screen — form 85
- Updates
- 40 tables
- References
- 37 tables
PR85.1 (Bank Account Reconciliation) is a Lawson Payroll online screen (form 85, subform 1). It updates ACCOMMIT, ACCOMMITX, ADDRDATA, ATTENDHIST, EMDEDMASTR, EMPACHDIST, FBDETAIL, FBFUNDAMT and 32 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ATTENDCODE, BANKACCT and 29 more.
About PR85.1
Use Bank Account Reconciliation (PR85.1) to reconcile and void payments closed by running PR197 (Payroll Close). You can reconcile individual payments or a range of payments. You can also void partial payments. **Processing Effect Direct deposit payments are automatically assigned a reconciled status when you run PR197. If the bank provides account activity on magnetic tape, run PR165 (Bank Reconciliation Tape Processing) to update PR85.1 with all bank activity that occurred during a specific period of time. To void a payment, select line action Void next to the appropriate payment. You can type a date for the void, or allow the system date to default. The system updates payroll history files based on the void date. The system also uses the void date when creating reversing general ledger entries for a voided payment or partial voided payment. To void a partial payment, select P in the Type field. Choose the direct deposit void button (asterisk) to indicate the general ledger offset accounts. If you enter No in the Create Distributions field on the company or process level record, or if payroll history is purged, the system creates general ledger distributions based on current distribution information.
More information: The Sub-Status field is optional. This field is designed for Reconciled payments only. When you reconcile the payment as 'unclaimed' wages, asub-status field can be entered so that the payment can be flagged as an 'escheated' payment. Sub-status values were defined to allow the user to flag a payment with different sub-statuses to 'track' the payment at different points in the 'escheatment' process. Here is a summary of the sub-status values and when they could be used. 1 (Escheated payment) - Payment becomes stale dated and flagged as unclaimed property. Reconciled payments with this sub-status can not be purged (PR300). 2 (Escheated pymt filed with govt) - Unclaimed funds are reported/turned-over to the state 3 (Hold) - Note: this is a valid sub-status value in the database, but is not provided as an option to clients on PR85 at this time. 4 (Reissued) - Employee claims payment - funds not turned over to the state and another payment issued in its place 5 (Cashed) - Employee cashes check after payment flagged as '1' (Escheated). Sub-status could either be removed or flagged with sub-status of '5'. Run PR197 (Payroll Close) in report mode to produce a listing of distribution transactions. To update history files for the voided payment, run PR197. If you do not run PR197 specifically to close voided payments, the voided payments are updated when you run PR197 for the next payroll cycle.
Updated files (40)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ADDRDATA | Address Code | IF |
| ATTENDHIST | Employee Attendance History | TM |
| EMDEDMASTR | Employee Deduction | PR |
| EMPACHDIST | Employee ACH Distribution | PR |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| GMLABDISTX | Grant Labor Distribution Dtl | GM |
| GMTRANEFRT | Grant Effort Transaction | GM |
| LPPENDREQ | No description in the Lawson data dictionary | LP |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| PAYMASTR | Employee Payment Master | PR |
| PR1099RHST | No description in the Lawson data dictionary | PR |
| PR1099RSLH | No description in the Lawson data dictionary | PR |
| PRCHECK | Employee Payment | PR |
| PRDEDDTL | No description in the Lawson data dictionary | PR |
| PRDISTRIB | Employee Payment Distribution | PR |
| PREMDEDHST | Employee Deduction History | PR |
| PREMPGARN | Used to store information to identify a particular garnishment per employee per company. | PR |
| PRGARNHIST | Contains the history for a particular garnishment (case number and file number). | PR |
| PRPAYCODE | Pay Code | PR |
| PRPENFSRC | No description in the Lawson data dictionary | PR |
| PRPENFSRCH | No description in the Lawson data dictionary | PR |
| PRPENHIST | No description in the Lawson data dictionary | PR |
| PRSYSTEM | HR Company and Process Levels | HR |
| PRTIME | Employee Pay/Hours History | PR |
| QUARTDED | Quarterly Deduction | PR |
| QUARTWAGE | Quarterly Wage | PR |
| SUBCKPOINT | Subledger Check Point | IF |
| TAEMPSERV | Employee LP Service Record | LP |
| TIMERECORD | Employee Time Records | PR |
| TIPPAY | Employee Tip Pay | PR |
| TPPARAM | Tip Parameters | TP |
Referenced files (37)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ATTENDCODE | Attendance Code | TM |
| BANKACCT | Bank Account | PR |
| BANKFILE | Bank Code | PR |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| DEDCODE | Deduction | PR |
| EMDISTMAST | Emp Acct Distribution Override | PR |
| EMPLOYEE | Employee | HR |
| FBFUNDDTL | Budget Fund Detail | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GMCONTROL | No description in the Lawson data dictionary | GM |
| GMLABDIST | Grant Labor Distribution | GM |
| GMLABDISTX | Grant Labor Distribution Dtl | GM |
| HRSECLEV | Employee Security Level | HR |
| INSTCTRYCD | Intrastat Country Codes | TX |
| PAEMPLOYEE | Employee Personnel Information | HR |
| PAYSUMGRP | Pay Summary Groups | PR |
| PCODESDTL | Contains contact information detail (address and phone number) for specific types of PCODES. | HR |
| PRDEDACCTS | No description in the Lawson data dictionary | PR |
| PRFUNDSRC | No description in the Lawson data dictionary | PR |
| PROTACCTS | This file contains expense accounts for premium portions of pay by job codes. | PR |
| PRPENPAY | No description in the Lawson data dictionary | PR |
| PRSHIFTTBL | This detail file contains shift differential rates by shift code and can be assigned by job code, grade range schedule… | PR |
| PRTAXAUTH | Tax Authority | PR |
| PSGRELATE | Pay Class/Pay Sum Grp Relation | HR |
| SYSTEMCODE | System Code | IF |
| TRSGBLCK | This file contains segment block data for employee time records. | PR |
Program calls
Invoked programs (13)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, PREN, SLSE, SLSU