Loading...
HomeMy WebLinkAboutEOM GL Reconciliation Summary 10.31.25 Page: 1 City of St JosephGL Reconciliation Report - Date Summary Nov 03, 2025 8:50AM Report Dates: 10/01/2025 - 10/31/2025 Report Criteria: Including amounts updated to General Ledger Date Summary DateDebit AmountCredit AmountTotal Amount 001-10107 (BUILDING PERMIT CASH CLEARING) 10/02/20259,627.00.009,627.00 10/03/2025102.00.00102.00 10/06/2025192.00.00192.00 10/07/2025371.20.00371.20 10/10/2025204.00.00204.00 10/13/2025102.00.00102.00 10/15/20251,625.00.001,625.00 10/20/2025244.00.00244.00 10/21/2025131,337.00.00131,337.00 10/22/202551.00.0051.00 10/23/202560.00.0060.00 10/24/20251,427.02.001,427.02 10/29/202517,446.00.0017,446.00 10/30/2025121.00.00121.00 10/31/2025132.00.00132.00 101-22200 (Unearned Revenue) 10/02/20259,627.009,627.00-.00 10/03/2025102.00102.00-.00 10/06/2025192.00192.00-.00 10/07/2025371.20371.20-.00 10/10/2025204.00204.00-.00 10/13/2025102.00102.00-.00 10/15/20251,625.001,625.00-.00 10/20/2025244.00244.00-.00 10/21/2025131,337.00131,337.00-.00 10/22/202551.0051.00-.00 10/23/202560.0060.00-.00 10/24/20251,427.021,427.02-.00 10/29/202517,446.0017,446.00-.00 10/30/2025121.00121.00-.00 10/31/2025132.00132.00-.00 101-41430-32210 (Building Permits) 10/02/2025.003,250.00-3,250.00- 10/03/2025.00102.00-102.00- 10/06/2025.00192.00-192.00- 10/07/2025.00371.20-371.20- 10/10/2025.00204.00-204.00- 10/13/2025.00102.00-102.00- 10/15/2025.001,625.00-1,625.00- 10/20/2025.00244.00-244.00- 10/21/2025.0040,050.00-40,050.00- 10/22/2025.0051.00-51.00- 10/24/2025.001,427.02-1,427.02- 10/29/2025.004,692.00-4,692.00- 10/30/2025.0061.00-61.00- 10/31/2025.00132.00-132.00- 101-41430-32261 (Rental Housing Registration) 10/21/2025.00100.00-100.00- 101-41430-34107 (Assessments Search) 10/23/2025.0060.00-60.00- Page: 2 City of St JosephGL Reconciliation Report - Date Summary Nov 03, 2025 8:50AM Report Dates: 10/01/2025 - 10/31/2025 DateDebit AmountCredit AmountTotal Amount 10/30/2025.0060.00-60.00- 210-42210-36300 (Reimbursement) 10/21/2025.00210.00-210.00- 501-49440-37170 (WAC) 10/02/2025.002,750.00-2,750.00- 10/21/2025.0045,000.00-45,000.00- 10/29/2025.005,500.00-5,500.00- 501-49440-37173 (Water Trunk - CR 121) 10/02/2025.00150.00-150.00- 502-49471-37175 (Sewer Trunk - DBL Labs) 10/21/2025.00400.00-400.00- 502-49472-37172 (Sewer Trunk - Northland) 10/29/2025.00600.00-600.00- 502-49473-37173 (Sewer Trunk - CR 121) 10/02/2025.00150.00-150.00- 502-49490-37251 (SAC) 10/02/2025.002,750.00-2,750.00- 10/21/2025.0045,000.00-45,000.00- 10/29/2025.005,500.00-5,500.00- 601-00000-37171 (Water Meter) 10/02/2025.00577.00-577.00- 10/21/2025.00577.00-577.00- 10/29/2025.001,154.00-1,154.00- Grand Totals: 326,082.44326,082.44-.00 Page: 3 City of St JosephGL Reconciliation Report - Date Summary Nov 03, 2025 8:50AM Report Dates: 10/01/2025 - 10/31/2025 Account Summary GL AccountDebit AmountCredit AmountTotal Amount 001-10107 (BUILDING PERMIT CASH CLEARING)163,041.22.00163,041.22 101-22200 (Unearned Revenue)163,041.22163,041.22-.00 101-41430-32210 (Building Permits).0052,503.22-52,503.22- 101-41430-32261 (Rental Housing Registration).00100.00-100.00- 101-41430-34107 (Assessments Search).00120.00-120.00- 210-42210-36300 (Reimbursement).00210.00-210.00- 501-49440-37170 (WAC).0053,250.00-53,250.00- 501-49440-37173 (Water Trunk - CR 121).00150.00-150.00- 502-49471-37175 (Sewer Trunk - DBL Labs).00400.00-400.00- 502-49472-37172 (Sewer Trunk - Northland).00600.00-600.00- 502-49473-37173 (Sewer Trunk - CR 121).00150.00-150.00- 502-49490-37251 (SAC).0053,250.00-53,250.00- 601-00000-37171 (Water Meter).002,308.00-2,308.00- Grand Totals: 326,082.44326,082.44-.00 Page: 4 City of St JosephGL Reconciliation Report - Date Summary Nov 03, 2025 8:50AM Report Dates: 10/01/2025 - 10/31/2025 Balances GL AccountBeginning BalanceDebit AmountCredit AmountEnding Balance 001-10107 (BUILDING PERMIT CASH CLEARING)1,433,801.22163,041.22.001,596,842.44 101-22200 (Unearned Revenue)2,161.90-163,041.22163,041.22-2,161.90- 101-41430-32210 (Building Permits)678,314.26-.0052,503.22-730,817.48- 101-41430-32261 (Rental Housing Registration)107,900.00-.00100.00-108,000.00- 101-41430-34107 (Assessments Search)1,260.00-.00120.00-1,380.00- 210-42210-36300 (Reimbursement)3,660.00-.00210.00-3,870.00- 501-49440-37170 (WAC)322,500.00-.0053,250.00-375,750.00- 501-49440-37173 (Water Trunk - CR 121)600.00-.00150.00-750.00- 502-49471-37175 (Sewer Trunk - DBL Labs)50,482.23-.00400.00-50,882.23- 502-49472-37172 (Sewer Trunk - Northland)3,600.00-.00600.00-4,200.00- 502-49473-37173 (Sewer Trunk - CR 121)1,050.00-.00150.00-1,200.00- 502-49490-37251 (SAC)245,830.10-.0053,250.00-299,080.10- 601-00000-37171 (Water Meter)15,001.00-.002,308.00-17,309.00- Grand Totals: 1,441.73326,082.44326,082.44-1,441.73