Filetype Excel XLSX | Posted on 10 Aug 2022 | 4 years ago
Authentication
digital resources
330x Filetype XLSX File size 0.17 MB Source: www.ofm.wa.gov
Sheet 1: RECONCILIATION
| AGENCY NAME | ||||||||
| FISCAL OFFICE | ||||||||
| ACCOUNT 035 RECONCILIATION | ||||||||
| xx-xx BIENNIUM, FM xx, (Mo/Yr) | ALL GL's IN ACCOUNT 035 | |||||||
| AFRS | WORKSHEET | DIFFERENCE | ||||||
| BALANCE | BALANCE | SHOULD BE | ||||||
| GL # | TITLE | (CR) | (CR) | ZERO | NOTES | |||
| 1324 | SALARIES AND FRINGE BENEFITS RECEIVABLE | 0.00 | 0.00 | 0.00 | ||||
| 5111 | ACCOUNTS PAYABLE | 0.00 | 0.00 | 0.00 | ||||
| 5124 | ACCRUED SALARIES AND FRINGE BENEFITS PAYABLE | 0.00 | 0.00 | 0.00 | ||||
| 5145 | DUE TO DECEASED EMPLOYEES' ESTATES | 0.00 | 0.00 | 0.00 | ||||
| 5180 | PAID FAMILY AND MEDICAL LEAVE DEDUCTIONS PAYABLE | 0.00 | 0.00 | 0.00 | ||||
| 5181 | EMPLOYEE INSURANCE DEDUCTIONS PAYABLE | 0.00 | 0.00 | 0.00 | ||||
| 5183 | LONG-TERM SUPPORT SERVICES DEDUCTIONS PAYABLE | 0.00 | 0.00 | 0.00 | ||||
| 5187 | INDUSTRIAL INS. AND MEDICAL AID DEDUCTIONS PAYABLE | 0.00 | 0.00 | 0.00 | ||||
| 5189 | GARNISHMENT DEDUCTIONS PAYABLE | 0.00 | 0.00 | 0.00 | ||||
| 5194 | LIABILITY FOR CANCELLED WARRANTS/CHECKS | 0.00 | 0.00 | 0.00 | ||||
| 5199 | OTHER SHORT TERM LIABILITIES | 0.00 | 0.00 | 0.00 | ||||
| AGENCY TOTAL | 0.00 | 0.00 | 0.00 | |||||
| AFRS | ||||||||
| BALANCE | ||||||||
| GL # | TITLE | (CR) | ||||||
| 4310 | CURRENT TREASURY CASH ACTIVITY (OST ONLY) | 0.00 | ||||||
| 4325 | BEGINNING TREASURY CASH BALANCE | 0.00 | ||||||
| 7110 | RECEIPTS IN-PROCESS | 0.00 | ||||||
| 7120 | WARRANTS IN-PROCESS | 0.00 | ||||||
| 7130 | WARRANT CANCELLATIONS IN-PROCESS | 0.00 | ||||||
| 7140 | JOURNAL VOUCHERS IN-PROCESS | 0.00 | ||||||
| 9920 | CURRENT PERIOD CLEARING ACCOUNT | 0.00 | ||||||
| OST TOTAL | 0.00 | |||||||
| AGENCY + OST SHOULD BE ZERO | 0.00 | |||||||
| Enter data from General Ledger Trial Balance in column C entitled REPORT BALANCE |
| AGENCY NAME | |||||||
| FISCAL OFFICE | |||||||
| ACCOUNT 035 RECONCILIATION | GL 1324 | ||||||
| xx-xx BIENNIUM, FM xx, (Mo/Yr) | SALARIES AND FRINGE BENEFITS RECEIVABLE | ||||||
| FM | BIEN | DOC # | AMT (CR) | NOTES | |||
| TOTAL (CR) | 0.00 | ||||||
| Amt per Reconciliation Tab | 0.00 | ||||||
| Difference S/B ZERO | 0.00 | ||||||
| Source documents: | |||||||
| ● | Payroll Posting Report ZHR_RPTPY126 | ||||||
| ● | Negative Summary Report ZHR_RPTPY455 | ||||||
| ● | System generated JV's (Negative Summary JV ZHR_RPTPY376) | ||||||
| ● | A-19's, A-8's and agency JV's | ||||||
| ● | WebIntelligence | ||||||
| ● | Enterprise Reporting (ER) General Ledger Account Analysis | ||||||
| GL definition/use: | |||||||
| ● | The balance of this account represents receivables due from individuals or organizations for salaries and fringe benefits. | ||||||
| ● | System generated receivables from overpayments and net negative deductions | ||||||
| ● | Agency receivables for manual/emergency payroll warrants, receivables from the IRS | ||||||
| Typical Transcodes: | |||||||
| System Generated: | |||||||
| 024 | 1324/5124 | Record Payroll Receivable & Lia | |||||
| 186 | 7140/1324 | JV Recpt - Collect Payroll Receivable (transfer from operating) | |||||
| Agency Generated: | |||||||
| 955 | 1324v/5111 | Request Warrant (OST 397 5111/7120) | |||||
| 932 | 1324v/7120 | Hnd Warr-GL File Only (Clear DES Walk-Through) | |||||
| 025 | 1324v/7140 | Interfund GL Transfer (transfer between funds - no OST) | |||||
| 026 | 7140/1324v | Interfund GL Transfer (transfer between funds - no OST) | |||||
| 669 | 6510/7140 | Interfund Expenditure Transfer (transfer between funds - no OST) | |||||
| 670 | 7140/6510 | Interfund Expenditure Transfer (transfer between funds - no OST) | |||||
| 263 | 6510/7140 | JV Trsf Incr Agency Expend (transfer between funds) | |||||
| 264 | 7140/6510 | JV Trsf Reduce Agency Expend (transfer between funds) | |||||
| 965 | 1324v/7140 | JV Disbursement (transfer between funds) | |||||
| 966 | 7140/1324v | JV Receipt (transfer between funds) | |||||
| 347 | 9920/1324v | Lcl Trsf Credit General Ledger (transfer within 035) | |||||
| 348 | 1324v/9920 | Lcl Trsf Debit General Ledger (transfer within 035) | |||||
| AGENCY NAME | |||||||
| FISCAL OFFICE | |||||||
| ACCOUNT 035 RECONCILIATION | GL 5111 | ||||||
| xx-xx BIENNIUM, FM xx, (Mo/Yr) | ACCOUNTS PAYABLE | ||||||
| FM | BIEN | DOC # | AMT (CR) | NOTES | |||
| TOTAL (CR) | 0.00 | ||||||
| Amt per Reconciliation Tab | 0.00 | ||||||
| Difference S/B ZERO | 0.00 | ||||||
| Source documents: | |||||||
| ● | Enterprise Reporting (ER) General Ledger Account Analysis | ||||||
| GL definition/use: | |||||||
| ● | The balance of this account represents amounts owing on open accounts for goods and services received by June 30. | ||||||
| ● | Should be system generated transactions only | ||||||
| ● | OFM does not recommend manual transactions to this GL in Account 035 | ||||||
| Typical Transcodes: | |||||||
| System Generated: | |||||||
| 763 | 5124/5111 | PR Vendor Payments | |||||
| 397 | 5111/7120 | Pay Acct/Vou Payable (Trea) | |||||
no reviews yet
Please Login to review.
