District Administration

User Tools

Site Tools

Trace: • Verify Finance data
general:midyearpeimsbusiness_financedomain_financedata

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
general:midyearpeimsbusiness_financedomain_financedata [2025/11/19 18:28] – created emorenogeneral:midyearpeimsbusiness_financedomain_financedata [2026/10/02 20:35] (current) – emoreno
Line 1: Line 1:
 ====Verify Finance data==== ====Verify Finance data====
 +
 +<color #ed1c24>****</color>
 +
 +<WRAP center round info>
 +**REMINDERS**: 
 +  * Ensure you are logged on to the prior file ID in Finance to verify information.
 +  * In the prior year file ID, verify that the **Previous Year File ID** field on the [[https://help.ascendertx.com/business/doku.php/finance/tables/districtfinanceoptions/financeoptions|Finance > Tables > District Finance Options > Finance Options]] tab is set to a number representing the previous file ID instead of a letter. 
 +</WRAP>
 +
 +
  
 [[https://help.ascendertx.com/business/doku.php/finance/inquiry/generalledgerinquiry/generalledgeraccountsummary|Finance > Inquiry > General Ledger Inquiry > General Ledger Account Summary]] [[https://help.ascendertx.com/business/doku.php/finance/inquiry/generalledgerinquiry/generalledgeraccountsummary|Finance > Inquiry > General Ledger Inquiry > General Ledger Account Summary]]
  
 Prior year financial data is extracted from Finance for applicable funds. The totals include actual amounts entered into the system in the prior file ID.  Prior year financial data is extracted from Finance for applicable funds. The totals include actual amounts entered into the system in the prior file ID. 
 +
 +<WRAP box> **Note**: The Auditor's adjusting entries must be posted to obtain accurate amounts. To verify this information, use the [[https://help.ascendertx.com/business/doku.php/finance/reports/financereports/journalschecksdetailledgers/generaljournal|Finance > Reports > Finance Reports > Journals, Checks, Detail Ledgers > FIN1150 - General Journal]]. 
 +</WRAP>
 +
 +**Debit/Credit Guide**
 +
 +^Account Code^Debit^Credit^
 +|Assets (1XXX)|Increase|Decrease|
 +|Liabilities (2XXX)|Decrease|Increase|
 +|Fund Balance (3XXX)|Decrease|Increase|
 +|Reserves (4XXX)|Decrease|Increase|
 +|Estimated Revenue|Increase|Decrease|
 +|Realized Revenue|Decrease|Increase|
 +|Appropriations|Decrease|Increase|
 +|Expenditures|Increase|Decrease|
 +
 +
 +If adjusting entries have not been posted to the prior file ID, use [[https://help.ascendertx.com/business/doku.php/finance/maintenance/postings/journalactual|Finance > Maintenance > Postings > Journal Actual]] or the {{ :general:import_jv_template.xlsx|Import JV Transactions Template}}.
  
 {{:general:finance_domain_general_ledger_midyear.png|General Ledger Account Summary Tab}} {{:general:finance_domain_general_ledger_midyear.png|General Ledger Account Summary Tab}}
Line 19: Line 47:
   * Amount (rounded to the nearest dollar)   * Amount (rounded to the nearest dollar)
  
 +\\
 +
 +Use Exhibit C-3 from the annual audit report to compare amounts to the Finance > Inquiry > General Ledger Inquiry. 
 +
 +The Finance and Audit Report data should match the PDM2-102-003 Statement of Revenues, Expenditures, & Changes in Fund Balances - Governmental Funds.
 +
 +<WRAP center round tip>
 +**TIP**: PDM2-100-011 Actual Expenditures by Program&Object Within Detail Function - General Fund, breaks down by PIC, object code, and function.
 +</WRAP>
 +
 +**Exhibit C-3**:
 +
 +{{:general:midyear_exhibit_c-3.jpg|Exhibit C-3}}
 +
 +
 +**Exhibit H-1**:
 +
 +{{:general:midyear_exhibit_h-1.jpg|Exhibit H-1}}
 +
 +
 +This data can also be verified by using the [[https://help.ascendertx.com/business/doku.php/finance/reports/financereports/summarymiscellaneousreports/boardreports|Finance > Reports > Finance Reports > Summary/Miscellaneous Reports > FIN3050 - Board Report]]
  
 +{{:general:midyear_fin3050.jpg|FIN3050 Report}}
  
 +At this point, data should match on the following four reports:
 +  * Prior Year GL
 +  * Audit Report
 +  * Extract Prior Year Reprint
 +  * PDM2-102-003
 +\\
 +In TSDS, PDM reports can extract up to four major funds at a time (excluding the General Fund). You may need to run the report multiple times to collect all required data.
  
  
 +{{:general:midyear_fin3050_board_report.png|FIN3050 Report}}
general/midyearpeimsbusiness_financedomain_financedata.1763576928.txt.gz · Last modified: 2025/11/19 18:28 by emoreno

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.