User Tools

Site Tools


general:midyearpeimsbusiness_financedomain_financedata

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
general:midyearpeimsbusiness_financedomain_financedata [2025/11/19 18:49] – 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 22: Line 50:
  
 Use Exhibit C-3 from the annual audit report to compare amounts to the Finance > Inquiry > General Ledger Inquiry.  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}} {{: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]] 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|}}+{{: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.jpg|}}+{{:general:midyear_fin3050_board_report.png|FIN3050 Report}}
general/midyearpeimsbusiness_financedomain_financedata.1763578195.txt.gz · Last modified: 2025/11/19 18:49 by emoreno