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)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ADDRDATAAddress CodeIF
ATTENDHISTEmployee Attendance HistoryTM
EMDEDMASTREmployee DeductionPR
EMPACHDISTEmployee ACH DistributionPR
FBDETAILBudget DetailGL
FBFUNDAMTBudget Fund BalanceGL
FBTRANSBudget TransactionsGL
FBYETRNo description in the Lawson data dictionaryGL
GLCOMMITGL CommitmentsGL
GLCOMMITXGL commitment DetailGL
GLHISCOMBLNo description in the Lawson data dictionaryGL
GLHISCOMXNo description in the Lawson data dictionaryGL
GMLABDISTXGrant Labor Distribution DtlGM
GMTRANEFRTGrant Effort TransactionGM
LPPENDREQNo description in the Lawson data dictionaryLP
PAYDEDUCTNEmployee Payment DeductionsPR
PAYMASTREmployee Payment MasterPR
PR1099RHSTNo description in the Lawson data dictionaryPR
PR1099RSLHNo description in the Lawson data dictionaryPR
PRCHECKEmployee PaymentPR
PRDEDDTLNo description in the Lawson data dictionaryPR
PRDISTRIBEmployee Payment DistributionPR
PREMDEDHSTEmployee Deduction HistoryPR
PREMPGARNUsed to store information to identify a particular garnishment per employee per company.PR
PRGARNHISTContains the history for a particular garnishment (case number and file number).PR
PRPAYCODEPay CodePR
PRPENFSRCNo description in the Lawson data dictionaryPR
PRPENFSRCHNo description in the Lawson data dictionaryPR
PRPENHISTNo description in the Lawson data dictionaryPR
PRSYSTEMHR Company and Process LevelsHR
PRTIMEEmployee Pay/Hours HistoryPR
QUARTDEDQuarterly DeductionPR
QUARTWAGEQuarterly WagePR
SUBCKPOINTSubledger Check PointIF
TAEMPSERVEmployee LP Service RecordLP
TIMERECORDEmployee Time RecordsPR
TIPPAYEmployee Tip PayPR
TPPARAMTip ParametersTP

Referenced files (37)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACCALActivity CalendarAC
ACCALXActivity Calendar DetailAC
ACCATSUMXAccount Category Summ DetailAC
ATTENDCODEAttendance CodeTM
BANKACCTBank AccountPR
BANKFILEBank CodePR
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
DEDCODEDeductionPR
EMDISTMASTEmp Acct Distribution OverridePR
EMPLOYEEEmployeeHR
FBFUNDDTLBudget Fund DetailGL
GLADDRESSGeneral Ledger Company AddressIF
GLCHARTGeneral Ledger ChartIF
GLMASTERGeneral Ledger Account MasterIF
GLNAMESGeneral Ledger NamesIF
GLSYSTEMGeneral Ledger CompanyIF
GMCONTROLNo description in the Lawson data dictionaryGM
GMLABDISTGrant Labor DistributionGM
GMLABDISTXGrant Labor Distribution DtlGM
HRSECLEVEmployee Security LevelHR
INSTCTRYCDIntrastat Country CodesTX
PAEMPLOYEEEmployee Personnel InformationHR
PAYSUMGRPPay Summary GroupsPR
PCODESDTLContains contact information detail (address and phone number) for specific types of PCODES.HR
PRDEDACCTSNo description in the Lawson data dictionaryPR
PRFUNDSRCNo description in the Lawson data dictionaryPR
PROTACCTSThis file contains expense accounts for premium portions of pay by job codes.PR
PRPENPAYNo description in the Lawson data dictionaryPR
PRSHIFTTBLThis detail file contains shift differential rates by shift code and can be assigned by job code, grade range schedule…PR
PRTAXAUTHTax AuthorityPR
PSGRELATEPay Class/Pay Sum Grp RelationHR
SYSTEMCODESystem CodeIF
TRSGBLCKThis 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