payroll accruals txeis payroll accruals region xviii information systems
TRANSCRIPT
![Page 1: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/1.jpg)
Payroll Accruals
TxEIS Payroll AccrualsRegion XVIII Information Systems
![Page 2: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/2.jpg)
I. Accrue = Accumulate
Why do we accrue?
1. From the TEA Accounting Guide: “Expenditures should be recorded and reported in the period in which they are incurred. Therefore, unpaid salaries and related benefits that have been earned but not yet paid should be recorded as accrued expenditures” (liabilities).
2. The process of accruing salaries enables a school district to accurately reflect expenses after each payday.
3. Enables the district to maintain earned but unpaid salary amounts in School YTD for each employee.
4. All businesses and city and state governments accrue pay earned in one fiscal year and not paid until the next fiscal year.
5. Accruing enables districts to fully expense salaries paid out of federal funds by June.
![Page 3: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/3.jpg)
II. Calculation
Formulas:Standard Pay Rate = Contract Amount ÷ 12Daily Rate = Contract Amount ÷ Number of Days in ContractMonthly Amount Expensed = Daily Rate X Number of Days WorkedMonthly Amount Accrued = Monthly Amount Expensed – Standard Pay Rate
-or-
Monthly Amount Accrued= Number of Days Worked X (Contract Amount ÷ Number of Days in Contract) – (Contract Amount ÷ 12)
![Page 4: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/4.jpg)
IllustrationAnnual Salary $36,000.00
Months in Contract 10
Days Employed 187
Standard Pay Rate 36000/12 $3,000.00
Daily Rate 36000/187 192.513
ACCRUAL CALENDAR STAFF JOB/PAY DATA>JOB INFO TAB
PAYDATEDAYS
EARNED DAILY RATE EXPENSESTANDARD
PAY RATE ACCRUED LIABILITY SCHOOL YTD ACCRUAL Notes
Object 61XX Object 2161 Object 2161
8/31/2012 10 X 192.513 = 1925.13 - 0.00 = 1925.13 1925.13 EOY Accruals: Not a Pay Date, No Pay
9/20/2012 20 X 192.513 = 3850.27 - 3000.00 = 850.27 2775.40
10/20/2012 21 X 192.513 = 4042.78 - 3000.00 = 1042.78 3818.18
11/20/2012 20 X 192.513 = 3850.27 - 3000.00 = 850.27 4668.45
12/20/2012 14 X 192.513 = 2695.19 - 3000.00 = (304.81) 4363.64
1/20/2013 20 X 192.513 = 3850.27 - 3000.00 = 850.27 5213.90
2/20/2013 20 X 192.513 = 3850.27 - 3000.00 = 850.27 6064.17
3/20/2013 21 X 192.513 = 4042.78 - 3000.00 = 1042.78 7106.95
4/20/2013 20 X 192.513 = 3850.27 - 3000.00 = 850.27 7957.22
5/20/2013 20 X 192.513 = 3850.27 - 3000.00 = 850.27 8807.49
6/20/2013 1 X 192.513 = 192.51 - 3000.00 = (2807.49) 6000.00 Fully Expensed
7/20/2013 0 X 192.513 = 0.00 - 3000.00 = (3000.00) 3000.00 No Expense
8/20/2013 0 X 192.513 = 0.00 - 3000.00 = (3000.00) 0.00 Payoff Date, No Expense
Total 187 36000.00 36000.00 0.00 0.00 Liability (2161) is eliminated.
![Page 5: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/5.jpg)
III. Accounts
![Page 6: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/6.jpg)
IV. TxEIS End-of-Year (August) Accruals
![Page 7: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/7.jpg)
Step 1
![Page 8: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/8.jpg)
Step 2
![Page 9: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/9.jpg)
Step 5
![Page 10: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/10.jpg)
Step 5 (continued)
![Page 11: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/11.jpg)
Step 5 (continued)
![Page 12: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/12.jpg)
Step 6
![Page 13: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/13.jpg)
Step 6 (continued)
![Page 14: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/14.jpg)
Step 6 (continued)
![Page 15: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/15.jpg)
Step 7
![Page 16: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/16.jpg)
Step 8
![Page 17: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/17.jpg)
Step 9
![Page 18: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/18.jpg)
Step 9 (continued)
![Page 19: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/19.jpg)
Step 10
![Page 20: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/20.jpg)
Step 10 (continued)
![Page 21: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/21.jpg)
Step 11
![Page 22: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/22.jpg)
STOP
![Page 23: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/23.jpg)
Step 12
![Page 24: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/24.jpg)
Step 12 (continued)
![Page 25: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/25.jpg)
Step 13
![Page 26: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/26.jpg)
Step 14
![Page 27: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/27.jpg)
Step 15
![Page 28: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/28.jpg)
V. TxEIS Monthly Payroll Accruals
![Page 29: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/29.jpg)
Step 1
The Pay Dates must match the Pay Dates Table.
![Page 30: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/30.jpg)
Step 2
![Page 31: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/31.jpg)
Step 2 (continued)
![Page 32: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/32.jpg)
Step 2 (continued)
![Page 33: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/33.jpg)
Step 3
![Page 34: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/34.jpg)
XI. Balancing Accruals Monthly
![Page 35: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/35.jpg)
HRS3050: School YTD Report
![Page 36: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/36.jpg)
Finance GL Account Summary: Object 2161
![Page 37: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/37.jpg)
XIII. Correcting Accruals
![Page 38: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/38.jpg)
1. Accrual Variance Extract
![Page 39: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/39.jpg)
1. Accrual Variance Extract (continued)
![Page 40: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/40.jpg)
1. Accrual Variance Report (continued)
![Page 41: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/41.jpg)
1. Accrual Variance Extract (continued)
![Page 42: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/42.jpg)
2. Zero School YTD Accruals
![Page 43: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/43.jpg)
2. Zero School YTD Accruals (continued)
![Page 44: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/44.jpg)
2. Zero School YTD Accruals (continued)
![Page 45: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/45.jpg)
3. Special Adjustments
![Page 46: Payroll Accruals TxEIS Payroll Accruals Region XVIII Information Systems](https://reader035.vdocuments.us/reader035/viewer/2022062408/56649f125503460f94c263f0/html5/thumbnails/46.jpg)
Finished!!
Questions