Every dollar in any document
Loading records…
Loading records…
24,141 financial figures extracted across all council records, ordinances, and the city code. Each row carries the surrounding paragraph that explains the number, the page citation, and anAuto-extracted badge so you remember these are AI-extracted and ready for human review, not the official budget baseline.
Financial figure index, not official budget truth.
These rows are for discovery and audit. The simulator only uses rows promoted into the official budget baseline after an admin confirms the number against an official source.
Showing 1–48 of 48 figures.
| Amount | Category | Direction | Purpose | Where | Year |
|---|---|---|---|---|---|
| $3,290,962.47 Cash per CTAS
07-31/19 SCHEDULE 1 Ending Balance:
$ 3,290,962.47 | other | unknown | CTAS Schedule 1 ending balance as of July 31, 2019 Cash per CTAS ending balance on Schedule 1 as of July 31, 2019. Bucket: July 2019 Treasurer's Report Auto-extracted | July 2019 Treasurer's Report p.1 Aug 13, 2019 | 2019 |
| $2,933,584.79 Total of all Cash in ALL accounts:
$ 3,293,584.79 | other | unknown | Total cash in all accounts as of July 31, 2019 Total cash in all accounts reported as of July 31, 2019. Bucket: July 2019 Treasurer's Report Auto-extracted | July 2019 Treasurer's Report p.1 Aug 13, 2019 | 2019 |
| $2,379,475.47 Cash per CTAS
08-31/19 SCHEDULE 1 Ending Balance:
$ 2,379,475.47 | other | unknown | August 2019 CTAS cash ending balance August 31, 2019 CTAS ending balance in treasurer's report. Bucket: Cash per CTAS Auto-extracted | August 2019 Financial Report p.1 Sep 10, 2019 | 2019 |
| $2,379,464.79 Total of all Cash in ALL accounts:
$ 2,383,237.43
YTD Outstanding Chks as of 08-31-2019:
$ 3,772.64
Adjusted Bank Total
$ 2,379,464.79 | other | unknown | August 2019 adjusted bank total August 31, 2019 adjusted bank total in treasurer's report. Bucket: Adjusted Bank Total Auto-extracted | August 2019 Financial Report p.1 Sep 10, 2019 | 2019 |
| $2,244,578 Total City Cash & Investments
$ 2,244,578
$ 1,904,111
$ 340,467 | other | unknown | September 30, 2019 total cash and investments September 30, 2019 cash and investments in September financial report. Bucket: Total City Cash & Investments Auto-extracted | September 2019 Financial Report Nov 12, 2019 | 2019 |
| $2,181,435.45 Total of all Cash in ALL accounts:
$ 2,181,435.45 | other | unknown | Total cash in all accounts 11-30-2019 Total cash in all accounts as of November 30, 2019. Bucket: Treasurer's report Auto-extracted | November 2019 Treasurer's Report p.1 Dec 10, 2019 | 2019 |
| $2,178,727.79 October 2019 Treasurer's Report total cash | other | unknown | October 2019 Treasurer's Report total cash October 31, 2019 Treasurer's Report total of all cash in all accounts approved with the consent agenda. Bucket: Total cash in all accounts Auto-extracted | 2019 | |
| $2,167,434.14 Cash per CTAS
11/30/19 SCHEDULE 1 Ending Balance:
$ 2,167,434.14 | other | unknown | CTAS Schedule 1 ending balance 11-30-2019 Cash per CTAS Schedule 1 ending balance as of November 30, 2019. Bucket: Treasurer's report Auto-extracted | November 2019 Treasurer's Report p.1 Dec 10, 2019 | 2019 |
| $1,998,535.18 Total of all Cash in ALL accounts:
$ 1,998,535.18 | other | unknown | treasurer_total_cash_all_accounts Treasurer's Report as of February 28, 2019. Bucket: Total cash in all accounts Auto-extracted | 2019-02-28 Treasurers Report p.1 Mar 12, 2019 | 2019 |
| $1,930,581.5 Total of all Cash in ALL accounts: $ 1,930,581.50 | other | unknown | treasurer_total_cash Treasurer's Report total of all cash in all accounts. Bucket: Total cash in all accounts Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-04-09) Apr 9, 2019 | 2019 |
| $1,894,257.49 Adjusted Bank Total $ 1,894,257.49 | other | unknown | treasurer_adjusted_bank_total Treasurer's Report adjusted bank total. Bucket: Adjusted bank total Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-04-09) Apr 9, 2019 | 2019 |
| $1,857,383.42 F002 | other | unknown | F002 Total of all cash in all accounts as of April 30, 2019. Bucket: Treasurer's Report Auto-extracted | 2019 | |
| $1,855,516.84 F003 | other | unknown | F003 Final CTAS Schedule 1 ending balance as of April 30, 2019. Bucket: Treasurer's Report Auto-extracted | 2019 | |
| $1,653,278.48 Total of all Cash in ALL accounts: | other | unknown | Total cash in all accounts Total of all cash in all accounts as of June 30, 2019. Bucket: Treasurer's report Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-07-07) p.5 Jul 7, 2019 | 2019 |
| $1,633,970.26 Cash per CTAS 06-30/19 SCHEDULE 1 Ending Balance: | other | unknown | Cash per CTAS ending balance Cash per CTAS Schedule 1 ending balance as of June 30, 2019. Bucket: Treasurer's report Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-07-07) p.5 Jul 7, 2019 | 2019 |
| $1,224,243 7/31/2019
4M & 4MP Funds
Money Market Fund
$2,070.46
$1,224,243.00 | other | unknown | 4M & 4MP funds balance 4M & 4MP money market fund balance on the July 2019 Treasurer's Report. Bucket: 4M & 4MP Funds Auto-extracted | July 2019 Treasurer's Report p.1 Aug 13, 2019 | 2019 |
| $1,217,880.05 3/31/2019 4M & 4MP Funds Money Market Fund $2,275.72 $1,217,880.05 | other | unknown | treasurer_4m_balance Treasurer's Report money market balance as of 03-31-19. Bucket: 4M & 4MP Funds money market balance Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-04-09) Apr 9, 2019 | 2019 |
| $1,215,604.33 2/28/2019 4M & 4MP Funds Money Market Fund $2,065.19 $1,215,604.33 | other | unknown | treasurer_4m_4mp_balance Treasurer's Report 4M/4MP money market fund balance as of February 28, 2019. Bucket: 4M & 4MP Funds money market balance Auto-extracted | 2019-02-28 Treasurers Report p.1 Mar 12, 2019 | 2019 |
| $956,828.23 7/31/2019
2019 AGO Improvement Bonds
Money Market Fund
(see attached 4M Fund Current Portfolio)
$ 956,828.23 | other | unknown | 2019A G.O. Improvement Bonds 4M ending balance 2019 G.O. Improvement Bonds money market fund balance. Bucket: 2019A G.O. Improvement Bonds 4M account Debt Service FundAuto-extracted | July 2019 Treasurer's Report p.1 Aug 13, 2019 | 2019 |
| $815,000 7/31/2019
PMA Financial Network
(5) C.D.s
(see attached 4M Fund Current Portfolio)
$ 815,000.00 | other | unknown | PMA Financial Network CD balance Five certificates of deposit through PMA Financial Network. Bucket: PMA Financial Network CDs Auto-extracted | July 2019 Treasurer's Report p.1 Aug 13, 2019 | 2019 |
| $647,462.17 3/31/2019 Pine River State Bank Checking Acct. $26.60 $ 647,462.17 | other | unknown | treasurer_checking_balance Treasurer's Report cash balance as of 03-31-19. Bucket: Pine River State Bank checking balance Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-04-09) Apr 9, 2019 | 2019 |
| $606,112.82 2/28/2019 Pine River State Bank Checking Acct. $23.72 $ 606,112.82 | other | unknown | treasurer_prsb_checking_balance Treasurer's Report checking account balance as of February 28, 2019. Bucket: Pine River State Bank checking balance Auto-extracted | 2019-02-28 Treasurers Report p.1 Mar 12, 2019 | 2019 |
| $280,130 $280,130 | other | projected | 2019 budgeted use of fund balance. <tr> <td>Sources (Uses) of Fund Balance</td> <td>$280,130</td> <td>($562,414)</td> <td>-200.77%</td> </tr> General FundAuto-extracted | Meeting City Council Meeting — Agenda Packet (2019-08-13) p.9 Aug 13, 2019 | 2019 |
| $250,000 combine w/Pine River State Bank CD in
March to reach the $250,000. | other | unknown | F9 Target amount discussed for combining CDs ("reach the $250,000") Bucket: cd_transfer_target Auto-extracted | City Council Meeting Minutes 02-12-2019 - Draft p.2 Feb 12, 2019 | 2019 |
| $206,585 206,585 | other | reported | 2019 actual ending fund balance for Equipment Replacement capital fund. Ending Fund Balance 206,585 257,107 1,133,607 302,687 Capital Projects FundAuto-extracted | Meeting City Council Work Session — Agenda Packet (2021-09-2 p.17 Sep 27, 2021 | 2019 |
| $176,818.03 2/28/2019 Pine River State Bank (2) C.D.' S (see attached Current Investments sheet) $ 176,818.03 | other | unknown | treasurer_prsb_cds_balance Treasurer's Report CD balance as of February 28, 2019. Bucket: Pine River State Bank CDs balance Auto-extracted | 2019-02-28 Treasurers Report p.1 Mar 12, 2019 | 2019 |
| $36,324.01 YTD Outstanding Chks as of 02-28-2018: - $ 36,324.01 | other | unknown | treasurer_outstanding_checks Treasurer's Report outstanding checks amount. Bucket: Outstanding checks Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-04-09) Apr 9, 2019 | 2019 |
| $33,935 $33,935 | other | historical | Actual or budgeted amount for 2019 (purpose not specified in excerpt). <table> <tr> <th>2022 draft</th> <th>2021</th> <th>2020</th> <th>2019</th> <th>2018</th> </tr> <tr> <td>$42,656</td> <td>$44,218</td> <td>$52,943</td> <td>$33,935</td> <td>$32,000</td> </tr> </table> Auto-extracted | Meeting City Council Meeting — Agenda Packet (2021-02-09) p.1 Feb 9, 2021 | 2019 |
| $28,065 28,065 | other | reported | 2019 actual change in fund balance for Equipment Replacement capital fund. Changes in Fund Balance 28,065 50,522 876,500 (246,500) (830,920) Capital Projects FundAuto-extracted | Meeting City Council Work Session — Agenda Packet (2021-09-2 p.17 Sep 27, 2021 | 2019 |
| $19,297.54 $ 19,297.54 | other | reported | Year-to-date outstanding checks as of 6/30/2019. YTD Outstanding Chks as of 06-30-2019: $ 19,297.54 Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-07-07) p.5 Jul 7, 2019 | 2019 |
| $17,056.66 $ 17,056.66 | other | reported | Year-to-date outstanding checks as of October 31, 2019. YTD Outstanding Chks as of 10-31-2019: $ 17,056.66 Auto-extracted | Meeting City Council Meeting — Agenda (2019-11-12) p.5 Nov 12, 2019 | 2019 |
| $17,056.66 $ 17,056.66 | other | reported | Year-to-date outstanding checks as of 10/31/2019. YTD Outstanding Chks as of 10-31-2019: $17,056.66 Auto-extracted | Meeting City Council Meeting — Agenda (2019-11-12) p.4 Nov 12, 2019 | 2019 |
| $8,749 2019 Audit
Audit
$8,749 | other | out_from_city | 2019 audit cost Amount paid for the 2019 audit, listed in the RFP attachment. Bucket: Current audit and accounting service hours Auto-extracted | Meeting City Council Work Session — Agenda Packet (2021-09-2 p.46 Sep 27, 2021 | 2019 |
| $8,457.41 $ 8,457.41 | other | reported | Unreconciled amount as of 11/30/2019. <td></td> <td>Unreconciled</td> <td>$ 8,457.41</td> Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-12-10) p.7 Dec 10, 2019 | 2019 |
| $5,543.9 $ 5,543.90 | other | reported | Year-to-date outstanding checks as of 11/30/2019. <td colspan="2">YTD Outstanding Chks as of 11-30-2019:</td> <td>$ 5,543.90</td> Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-12-10) p.7 Dec 10, 2019 | 2019 |
| $5,000 $5,000 | other | reference | Bond denomination for Series 2019A. in the denomination of $5,000 each or any integral multiple thereof, numbered No. R-1, upward, bearing interest as determined by the Pricing Committee, and maturing on February 1 in the years and amounts as determined by the Pricing Committee. Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-06-11) p.29 Jun 11, 2019 | 2019 |
| $2,611.64 $ 2,611.64 | other | reported | Year-to-date outstanding checks as of July 31, 2019. YTD Outstanding Chks as of 07-31-2019: $ 2,611.64 Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-08-13) p.7 Aug 13, 2019 | 2019 |
| $1,485.38 $ 1,485.38 | other | reported | Year-to-date outstanding checks as of April 30, 2019. Total of all Cash in ALL accounts: $ 1,857,383.42 YTD Outstanding Chks as of 04-30-2018: $ 1,485.38 Adjusted Bank Total $ 1,855,898.04 Unreconciled $ 381.20 Cash per CTAS 04-30/19 SCHEDULE 1 Ending Balance: $ 1,855,516.84 Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-05-07) p.10 May 7, 2019 | 2019 |
| $1,000 $1,000 | other | in_to_city | Credit offered by City Planner for April & May billing. Liz Stockman offered a maximum $1,000 credit for her April & May billing after reducing the hourly rate charge for time spent subbing for Ms. Lendt in the city offices. The Council thanked her and accepted her offer. Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-06-11) p.10 Jun 11, 2019 | 2019 |
| $381.2 $ 381.20 | other | reported | Unreconciled amount as of April 30, 2019. Total of all Cash in ALL accounts: $ 1,857,383.42 YTD Outstanding Chks as of 04-30-2018: $ 1,485.38 Adjusted Bank Total $ 1,855,898.04 Unreconciled $ 381.20 Cash per CTAS 04-30/19 SCHEDULE 1 Ending Balance: $ 1,855,516.84 Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-05-07) p.10 May 7, 2019 | 2019 |
| $381.2 $ 381.20 | other | reported | Unreconciled amount as of 4/30/2019. Unreconciled $ 381.20 Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-05-07) p.10 May 7, 2019 | 2019 |
| $65.24 Remaining CD is at Pine River State Bank, maturing on December 13, 2019 (Park Fund, $65,239.28). | other | unknown | treasurer_cd_balance The OCR separated the comma in $65,239.28; captured as $65,239.28. Bucket: Pine River State Bank CD balance Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-04-09) Apr 9, 2019 | 2019 |
| $10.68 $ 10.68 | other | reported | Unreconciled amount as of 6/30/2019. Unreconciled $ 10.68 Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-07-07) p.5 Jul 7, 2019 | 2019 |
| $10.68 $ 10.68 | other | reported | Unreconciled amount as of July 31, 2019. Unreconciled $ 10.68 Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-08-13) p.7 Aug 13, 2019 | 2019 |
| $0 $0.00 | other | reported | No pre-written checks for August 2019. Pre-Written Checks $0.00 Checks to be Generated by the Computer $93,659.39 Total $93,659.39 Auto-extracted | Meeting City Council Meeting — Agenda Packet (2019-09-10) p.12 Sep 10, 2019 | 2019 |
| $-9,697.55 $ (9,697.55) | other | reported | Unreconciled difference in bank reconciliation. Unreconciled $ (9,697.55) Auto-extracted | Meeting City Council Meeting — Agenda (2019-11-12) p.5 Nov 12, 2019 | 2019 |
| $-9,697.55 $ (9,697.55) | other | reported | Unreconciled amount as of 10/31/2019. Unreconciled $ (9,697.55) Auto-extracted | Meeting City Council Meeting — Agenda (2019-11-12) p.4 Nov 12, 2019 | 2019 |
| $-562,414 ($562,414) | other | out_from_city | Year-to-date use of fund balance as of June 30, 2019. <tr> <td>Sources (Uses) of Fund Balance</td> <td>$280,130</td> <td>($562,414)</td> <td>-200.77%</td> </tr> General FundAuto-extracted | Meeting City Council Meeting — Agenda Packet (2019-08-13) p.9 Aug 13, 2019 | 2019 |