Spreadsheet: 167363d1341961555-excel-2007-copying-editing-conditional-sum-formulas-check-register
Sheet: CHECK REGISTER

Date | Check # | Type | Account | Debt | Credit | Balance
Beginning Balance |  |  |  |  |  | 6300.61000000001
2012-06-01 00:00:00 | 1510 | Check | Glazer/Olinger |  | 115.02
2012-06-01 00:00:00 | 1511 | Check | Calumet |  | 247.7
2012-06-01 00:00:00 |  | Deposit | 2012-06-01 00:00:00 | 969
2012-06-01 00:00:00 |  | Credit Cards | 2012-06-01 00:00:00 | 3983.2
2012-06-02 00:00:00 |  | Deposit | 2012-06-02 00:00:00 | 1592
2012-06-02 00:00:00 |  | Credit Cards | 2012-06-02 00:00:00
2012-06-03 00:00:00 |  | Deposit | 2012-06-03 00:00:00 | 641
2012-06-03 00:00:00 |  | Credit Cards | 2012-06-03 00:00:00 | 2089.79
2012-06-04 00:00:00 |  |  | Payroll |  | 4249.15
2012-06-04 00:00:00 | 1512 | Check | BoA (Ufc PPV) |  | 1000
2012-06-04 00:00:00 | 1513 | Check | Northcoast |  | 553.45
2012-06-04 00:00:00 | 1514 | Check | Roasted Tomato |  | 1944.91
2012-06-04 00:00:00 | 1515 | Check | Brenmark |  | 40
2012-06-04 00:00:00 | 1516 | Check | Rent |  | 6600
2012-06-04 00:00:00 |  | Deposit | 2012-06-04 00:00:00 | 306
2012-06-04 00:00:00 |  | Credit Cards | 2012-06-04 00:00:00 | 555.06
2012-06-05 00:00:00 | 1516 | Check | VOID
2012-06-05 00:00:00 |  | Deposit | 2012-06-05 00:00:00 | 228
2012-06-05 00:00:00 |  | Credit Cards | 2012-06-05 00:00:00 | 850.05
2012-06-06 00:00:00 | 1517 | Check | Republic National
2012-06-06 00:00:00 | 1518 | Check | Dust Catchers |  | 65.56
2012-06-06 00:00:00 | 1519 | Check | Southern Wine and Spirits |  | 1786
2012-06-06 00:00:00 | 1520 | Check | Republic National |  | 1259.26
2012-06-06 00:00:00 |  | Deposit | 2012-06-06 00:00:00 | 894
2012-06-06 00:00:00 |  | Credit Cards | 2012-06-06 00:00:00 | 729.27
2012-06-07 00:00:00 | 1521 | Check | Glazer/Olinger |  | 2132.9
2012-06-07 00:00:00 | 1522 | Check | Pepsi |  | 134.79
2012-06-07 00:00:00 | 1523 | Check | Able Paper |  | 93.25
2012-06-07 00:00:00 |  | Deposit | 2012-06-07 00:00:00 | 546
2012-06-07 00:00:00 |  | Credit Cards | 2012-06-07 00:00:00 | 910.69
2012-06-08 00:00:00 | 1524 | Check | Calumet |  | 396.7
2012-06-08 00:00:00 |  | Deposit | 2012-06-08 00:00:00 | 133
2012-06-08 00:00:00 |  | Credit Cards | 2012-06-08 00:00:00 | 3526.94
2012-06-09 00:00:00 |  | Deposit | 2012-06-09 00:00:00 | 993
2012-06-09 00:00:00 |  | Credit Cards | 2012-06-09 00:00:00 | 1638.16
2012-06-10 00:00:00 |  | Deposit | 2012-06-10 00:00:00 | 520
2012-06-10 00:00:00 |  | Credit Cards | 2012-06-10 00:00:00 | 0
2012-06-11 00:00:00 | 1525 | Check | Roasted Tomato |  | 2322.86
2012-06-11 00:00:00 | 1526 | Check | 1st capital leasing |  | 1880
2012-06-13 00:00:00 |  | Deposit | 2012-06-11 00:00:00 | 347.5
2012-06-13 00:00:00 |  | Credit Cards | 2012-06-11 00:00:00
2012-06-13 00:00:00 |  | Deposit | 2012-06-12 00:00:00 | 189
2012-06-13 00:00:00 |  | Credit Cards | 2012-06-12 00:00:00 | 485.64
2012-06-11 00:00:00 | 1527 | Check | Brenmark |  | 40
2012-06-11 00:00:00 | 1528 | Check | Northcoast |  | 1087.36
2012-06-13 00:00:00 |  |  | Credit Card Fees |  | 874.06
2012-06-13 00:00:00 | OL | Check | Kankakee Valley REMC |  | 1189.63
2012-06-13 00:00:00 | 1529 | Check | Republic National |  | 709.5
2012-06-13 00:00:00 | 1530 | Check | MTA |  | 128.72
2012-06-13 00:00:00 | 1531 | Check | Society Insurance |  | 1739.52
2012-06-13 00:00:00 | 1532 | Check | Dust Catchers |  | 65.54
2012-06-13 00:00:00 | 1533 | Check | Sprint |  | 24.84
2012-06-13 00:00:00 | 1534 | Check | [NAME] |  | 61.54
2012-06-13 00:00:00 | 1535 | Check | Allied Waste |  | 205
2012-06-13 00:00:00 | 1536 | Check | Mahoney Environmental |  | 145
2012-06-13 00:00:00 | 1537 | Check | [NAME] |  | 79.95
2012-06-13 00:00:00 | 1538 | Check | [NAME] |  | 702.87
2012-06-13 00:00:00 | 1539 | Check | Cut Rite Lawn Care |  | 350
2012-06-13 00:00:00 | 1540 | Check | Fast Lane Foods Inc. |  | 236.5
2012-06-13 00:00:00 | 1541 | Check | TNT |  | 702.87
2012-06-14 00:00:00 |  | Deposit | 2012-06-13 00:00:00 | 311
2012-06-14 00:00:00 |  | Credit Cards | 2012-06-13 00:00:00 | 706.38
2012-06-14 00:00:00 | 1542 | Check | Direct Tv |  | 309.2
2012-06-14 00:00:00 | 1543 | Check | [NAME]. Water |  | 785.88
2012-06-14 00:00:00 | 1544 | Check | [NAME]'s HVAC |  | 180
2012-06-14 00:00:00 | 1545 | Check | MTA |  | 257.63
2012-06-14 00:00:00 | 1546 | Check | Glazer/Olinger |  | 335
2012-06-14 00:00:00 | 1547 | Check | Southern Wine and Spirits |  | 132
2012-06-15 00:00:00 |  | Deposit | 2012-06-14 00:00:00 | 838
2012-06-15 00:00:00 |  | Credit Cards | 2012-06-14 00:00:00 | 692.94
2012-06-15 00:00:00 | 1548 | Check | Calumet |  | 238.3
2012-06-15 00:00:00 |  | Deposit | 2012-06-15 00:00:00 | 1128
2012-06-15 00:00:00 |  | Credit Cards | 2012-06-15 00:00:00 | 1190.93
2012-06-18 00:00:00 |  | Deposit | 2012-06-16 00:00:00 | 348
2012-06-18 00:00:00 |  | Credit Cards | 2012-06-16 00:00:00 | 0
2012-06-18 00:00:00 |  | Deposit | 2012-06-17 00:00:00 | 413
2012-06-18 00:00:00 |  | Credit Cards | 2012-06-17 00:00:00 | 2726.89
2012-06-18 00:00:00 |  |  | Payroll |  | 4098.45
2012-06-18 00:00:00 | 1549 | Check | VOID
2012-06-18 00:00:00 | 1550 | Check | The Plumber |  | 199
2012-06-18 00:00:00 | 1551 | Check | Northcoast |  | 1600.7
2012-06-18 00:00:00 | 1552 | Check | Quality Kitchen |  | 85
2012-06-18 00:00:00 | 1553 | Check | [NAME] |  | 687
2012-06-18 00:00:00 | 1554 | Check | Roasted Tomato |  | 2336.9
2012-06-18 00:00:00 | 1555 | Check | Indiana Dept of Workforce Development |  | 49.83
2012-06-18 00:00:00 | 1556 | Check | [NAME] |  | 72
2012-06-18 00:00:00 |  | Deposit | 2012-06-18 00:00:00 | 546
2012-06-18 00:00:00 |  | Credit Cards | 2012-06-18 00:00:00 | 1122.96
2012-06-12 00:00:00 | 1557 | Check* | Monroe Pest Control |  | 35
2012-06-19 00:00:00 | 1558 | Check | Able Paper |  | 124.82
2012-06-19 00:00:00 | 1559 | Charity | LOFS Lions Club |  | 50
2012-06-19 00:00:00 |  | Deposit | 2012-06-19 00:00:00 | 313
2012-06-19 00:00:00 |  | Credit Cards | 2012-06-19 00:00:00 | 1122.96
2012-06-20 00:00:00 | 1560 | Check | Southern Wine and Spirits |  | 2152.41
2012-06-20 00:00:00 | 1561 | Check | Dust Catchers |  | 65.54
2012-06-20 00:00:00 | 1562 | Check | National |  | 1600.55
2012-06-20 00:00:00 | 1563 | Check | Brenmark |  | 40
2012-06-21 00:00:00 |  | Deposit | 2012-06-20 00:00:00 | 379.86
2012-06-21 00:00:00 |  | Credit Cards | 2012-06-20 00:00:00 | 593.17
2012-06-21 00:00:00 | 1564 | Check | Glazer/Olinger |  | 269.4
2012-06-21 00:00:00 | 1565 | Check | Pepsi |  | 157.62
2012-06-21 00:00:00 |  | Deposit | 2012-06-21 00:00:00 | 830
2012-06-21 00:00:00 |  | Credit Cards | 2012-06-21 00:00:00 | 1156.31
2012-06-22 00:00:00 | 1566 | Check | VOIDED
2012-06-22 00:00:00 | 1567 | Check | Calumet |  | 962.95
2012-06-22 00:00:00 |  | Deposit | 2012-06-22 00:00:00 | 645
2012-06-22 00:00:00 |  | Credit Cards | 2012-06-22 00:00:00 | 0
2012-06-23 00:00:00 |  | Deposit | 2012-06-23 00:00:00 | 1528
2012-06-23 00:00:00 |  | Credit Cards | 2012-06-23 00:00:00 | 3530.35
2012-06-25 00:00:00 |  | Deposit | 2012-06-24 00:00:00 | 816
2012-06-25 00:00:00 |  | Credit Cards | 2012-06-24 00:00:00 | 730.09
2012-06-25 00:00:00 | 1568 | Check | Quality Kitchen |  | 1428.16
2012-06-25 00:00:00 | 1569 | Check | Void
2012-06-25 00:00:00 | 1570 | Check | Roasted Tomato |  | 2159.43
2012-06-25 00:00:00 | 1571 | Check | Kankakee Valley REMC |  | 1343
2012-06-25 00:00:00 | 1572 | Check | Ondrovich & Assoc |  | 2630
2012-06-25 00:00:00 | 1573 | Check | [NAME] |  | 84.74
2012-06-26 00:00:00 |  | Deposit | 2012-06-25 00:00:00 | 519
2012-06-26 00:00:00 |  | Credit Cards | 2012-06-25 00:00:00 | 431.34
2012-06-27 00:00:00 |  | Deposit | 2012-06-26 00:00:00 | 588
2012-06-27 00:00:00 |  | Credit Cards | 2012-06-26 00:00:00 | 816.92
2012-06-27 00:00:00 | 1574 | Check | Republic National |  | 785.17
2012-06-27 00:00:00 | 1575 | Check | Dust Catchers |  | 65.54
2012-06-27 00:00:00 | 1576 | Check | Northcoast |  | 2761.4
2012-06-28 00:00:00 |  | Deposit | 2012-06-27 00:00:00
2012-06-28 00:00:00 |  | Credit Cards | 2012-06-27 00:00:00 | 685.29
2012-06-28 00:00:00 | 1577 | Check | Serv-U |  | 45
2012-06-28 00:00:00 | 1578 | Check | Calumet |  | 218.45
2012-06-29 00:00:00 |  | Deposit | 2012-06-28 00:00:00 | 498
2012-06-29 00:00:00 |  | Credit Cards | 2012-06-28 00:00:00 | 0
2012-06-30 00:00:00 |  | Deposit | 2012-06-29 00:00:00 | 1683
2012-06-30 00:00:00 |  | Credit Cards | 2012-06-29 00:00:00 | 0
2012-07-01 00:00:00 |  | Deposit | 2012-06-30 00:00:00 | 638
2012-07-01 00:00:00 |  | Credit Cards | 2012-06-30 00:00:00 | 0
2012-07-01 00:00:00 |  | Credit Cards | 2012-07-01 00:00:00 | 3608.92
2012-07-02 00:00:00 |  | Deposit | 2012-07-01 00:00:00 | 595
2012-07-02 00:00:00 |  | Credit Cards | 2012-07-01 00:00:00 | 1472.05
2012-07-02 00:00:00 |  |  | AMEX Fees |  | 56.67
2012-07-02 00:00:00 | 1579 | Check | Roasted Tomato |  | 2782.88
2012-07-02 00:00:00 | 1580 | Check | Allied Waste |  | 205
2012-07-02 00:00:00 | 1581 | Check | Society Insurance |  | 1739.52
2012-07-02 00:00:00 | 1582 | Check | Ondrovich & Assoc
2012-07-02 00:00:00 | 1583 | Check | Brenmark |  | 40
2012-07-02 00:00:00 |  | Deposit | 2012-07-02 00:00:00 | 783
2012-07-02 00:00:00 |  | Credit Cards | 2012-07-02 00:00:00 | 749.86
2012-07-03 00:00:00 | 1584 | Check | SESAC |  | 331.65
2012-07-03 00:00:00 | 1585 | Check | [NAME] |  | 388
2012-07-03 00:00:00 | 1586 | Check | Brenmark |  | 40
2012-07-03 00:00:00 | 1587 | Check | Swanel |  | 63
2012-07-03 00:00:00 | 1588 | Check | Dust Catchers |  | 65.54
2012-07-03 00:00:00 |  | Deposit | Tuesday 7/3 dep | 909
2012-07-03 00:00:00 |  | Credit Cards | Tuesday 7/3 cc | 1525.96
2012-07-03 00:00:00 | 1589 | Check | Ried's Fire & Safety Equip. |  | 227.41
2012-07-05 00:00:00 | 1590 | Check | Pepsi |  | 174.75
2012-07-05 00:00:00 | 1591 | Check | Swanel |  | 419
2012-07-05 00:00:00 | 1592 | Check | [NAME] |  | 79.95
2012-07-05 00:00:00 | 1593 | Check | [NAME] |  | 706.71
2012-07-05 00:00:00 |  |  | Payroll |  | 3759.52
2012-07-06 00:00:00 |  | Deposit | Thursday 7/5 dep | 571
2012-07-06 00:00:00 |  | Credit Cards | Thursday 7/5 cc | 966.51
2012-07-07 00:00:00 |  | Deposit | Friday 7/6 dep | 1192
2012-07-07 00:00:00 |  | Credit Cards | Friday 7/6 cc | 2049.33
2012-07-07 00:00:00 |  |  | Rent |  | 6600
2012-07-07 00:00:00 | 1594 | Check | Calumet |  | 133.75
2012-07-07 00:00:00 | 1595 | Check | [NAME]'s HVAC |  | 250
2012-07-07 00:00:00 |  | Deposit | Saturday 7/7 dep | 1617
2012-07-07 00:00:00 |  | Credit Cards | Saturday 7/7 cc | 2014.1
2012-07-07 00:00:00 | 1596 | Check | Roasted Tomato Supplies |  | 49.5
2012-07-09 00:00:00 | 1597 | Check | Law Office of [NAME] |  | 625
2012-07-09 00:00:00 | 1598 | Check | [NAME] |  | 500
2012-07-09 00:00:00 | 1599 | Check | Southern Wine and Spirits |  | 228
2012-07-09 00:00:00 | 1600 | Check | Northcoast |  | 2405.7
2012-07-09 00:00:00 | 1601 | Check | Brenmark |  | 40
2012-07-09 00:00:00 | 1602 | Check | Roasted Tomato Supplies |  | 29.5
2012-07-09 00:00:00 | 1603 | Check | Roasted Tomato |  | 2142.99
2012-07-09 00:00:00 | 1604 | Check | Town of Winfield |  | 96.2
2012-07-09 00:00:00 | 1605 | Check | Personnel Concepts |  | 15.9
2012-07-09 00:00:00 |  | Deposit | Sunday 7/8 dep | 640
2012-07-09 00:00:00 |  | Credit Cards | Sunday 7/8 cc | 778.63
2012-07-09 00:00:00 |  | Deposit | Monday 7/9 dep | 416
2012-07-09 00:00:00 |  | Credit Cards | Monday 7/9 cc | 498.82