Spreadsheet: 0a18d81d-1413-4f00-b523-427d9b73a623
Sheet: Sheet1

Finance Summary - Lewisville City Council - 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Reporting Period Summary
Candidate | Period | Contributions | Loans | Expenses | Expected Balance | Reported Balance | Difference
Hill | 2/12-2011 - 4/4/2011 | 257.88 | 0 | 2081.59 | -1823.71 | 0 | 1823.71
 | 4/5/2011 - 5/6/2011 | 1624 | 0 | 1302.63 | -1502.34 | 0 | 1502.34
 | 5/7/2011 - 7/15/2011 | 0 | 0 | 0 | -1502.34 | 0 | 1502.34
 | 9/20/2011 - 10/31/2011 | 5714.89 | 0 | 4009.89 | 202.6600000000003 | 1705 | 1502.34
 |  | 0 | 0 | 0 |  |  | 0
 | Totals | 7596.77 | 0 | 7394.110000000001 | 202.6599999999999 | 1705 | 1502.34
Ledger as reported
Date | Type | Amount | Accounting Balance | Cash Balance | Reported Cash | Cash Difference | Comment |  | Reimbursement Intended?
2011-02-12 00:00:00 | Exp | -107.88 | -107.88 | 0
2011-02-12 00:00:00 | Exp | -507.99 | -615.87 | 0 |  |  |  |  | 507.99
2011-02-15 00:00:00 | Exp | -10 | -625.87 | 0 |  |  |  |  | 10
2011-02-21 00:00:00 | Cont | 107.88 | -517.99 | 107.88
2011-03-05 00:00:00 | Exp | -116.23 | -634.22 | 0 |  |  |  |  | 116.23
2011-03-07 00:00:00 | Cont | 100 | -534.22 | 100
2011-03-07 00:00:00 | Exp | -1322.82 | -1857.04 | 0 |  |  |  |  | 1322.82
2011-03-17 00:00:00 | Exp | -14.02 | -1871.06 | 0
2011-03-18 00:00:00 | Exp | -2.65 | -1873.71 | 0
2011-04-02 00:00:00 | cont | 50 | -1823.71 | 50 | 0 | -50 | Reported 0 on-hand
2011-04-14 00:00:00 | Cont | 25 | -1798.71 | 75
2011-04-15 00:00:00 | Exp | -100 | -1898.71 | 0
2011-04-15 00:00:00 | Exp | -1123.63 | -3022.34 | 0
2011-04-21 00:00:00 | Cont | 1500 | -1522.34 | 1500 |  |  | TREPAC contribution
2011-04-26 00:00:00 | Cont | 79 | -1443.34 | 1579
2011-04-26 00:00:00 | Exp | -79 | -1522.34 | 1500
2011-04-30 00:00:00 | Cont | 20 | -1502.34 | 1520 | 0 | -1520
2011-09-21 00:00:00 | Cont | 14.89 | -1487.45 | 1534.89 |  |  | Self-contribution
2011-09-21 00:00:00 | Exp | -3995 | -5482.45 | 0 |  |  | Consulting expense reported from personal funds - no reimbursement intended
2011-10-06 00:00:00 | Cont | 100 | -5382.45 | 100
2011-10-17 00:00:00 | Cont | 5000 | -382.4499999999998 | 5100 |  |  | Self-contribution
2011-10-17 00:00:00 | Exp | -14.89 | -397.3399999999998 | 5085.11
2011-10-27 00:00:00 | Cont | 500 | 102.6600000000002 | 5585.11
2011-10-28 00:00:00 | Cont | 100 | 202.6600000000002 | 5685.11 | 1705 | -3980.11
 | Total | -1502.34 | 202.6600000000002 | 5685.11 |  |  |  |  | 1957.04
* Negative cash difference indicates either: |  |  | ** Positive Cash difference indicates either:
 | Unreported expenses |  |  | Unreported contributions
 | Unreported loan repayment |  |  | Unreported loan proceeds
 | Losses of funds |  |  | Investment gain
 | Withdrawal to personal use |  |  | Math mistake
 | Investment loss
 | Unreported refund
 | Math mistake
Ledger corrected to account for suspected unreported loans and repayments, or mistakes
Date | Type | Amount | Accounting Balance | Cash Balance | Reported Cash | Cash Difference | Comment
2011-02-12 00:00:00 | Loan / in-kind | 625.87 | 625.87 | 625.87
2011-02-12 00:00:00 | Exp | -107.88 | 517.99 | 517.99
2011-02-12 00:00:00 | Exp | -507.99 | 10 | 10
2011-02-15 00:00:00 | Exp | -10 | 0 | 0
2011-02-21 00:00:00 | Cont | 107.88 | 107.88 | 107.88
2011-03-05 00:00:00 | Loan / in-kind | 8.35 | 116.23 | 116.23
2011-03-05 00:00:00 | Exp | -116.23 | 0 | 0
2011-03-07 00:00:00 | Cont | 100 | 100 | 100
2011-03-07 00:00:00 | Loan / in-kind | 1239.49 | 1339.49 | 1339.49
2011-03-07 00:00:00 | Exp | -1322.82 | 16.67000000000007 | 16.67000000000007
2011-03-17 00:00:00 | Exp | -14.02 | 2.650000000000073 | 2.650000000000073
2011-03-18 00:00:00 | Exp | -2.65 | 7.327471962526033e-14 | 7.327471962526033e-14
2011-04-02 00:00:00 | cont | 50 | 50.00000000000007 | 50.00000000000007 | 50 | -7.105427357601002e-14 | Reported 0 on-hand
2011-04-14 00:00:00 | Cont | 25 | 75.00000000000007 | 75.00000000000007
2011-04-15 00:00:00 | Loan / in-kind | 1148.63 | 1223.63 | 1223.63
2011-04-15 00:00:00 | Exp | -100 | 1123.63 | 1123.63
2011-04-15 00:00:00 | Exp | -1123.63 | 0 | 0
2011-04-21 00:00:00 | Cont | 1500 | 1500 | 1500 |  |  | TREPAC contribution
2011-04-26 00:00:00 | Cont | 79 | 1579 | 1579
2011-04-26 00:00:00 | Exp | -79 | 1500 | 1500
2011-04-30 00:00:00 | Cont | 20 | 1520 | 1520
2011-04-30 00:00:00 | [NAME] | -1520 | 0 | 0 | 0 | 0 | Hill neglected to report a loan repayment
2011-09-21 00:00:00 | Cont | 5000 | 5000 | 5000 |  |  | Hill transposed dates in report
2011-09-21 00:00:00 | Exp | -3995 | 1005 | 1005
2011-10-06 00:00:00 | Cont | 100 | 1105 | 1105
2011-10-17 00:00:00 | Cont | 14.89 | 1119.89 | 1119.89 |  |  | Hill transposed dates in report
2011-10-17 00:00:00 | Exp | -14.89 | 1105 | 1105
2011-10-27 00:00:00 | Cont | 500 | 1605 | 1605
2011-10-28 00:00:00 | Cont | 100 | 1705 | 1705 | 1705 | 0
 | Total | 1705 |  |  | 0 | 0