Spreadsheet: 102691d1300676916-index-match-fifthnpop
Sheet: Roll-UpTable

Category | Date | Amt |  | I put all your data into a Table that made if much easier to do a Pivot Table on
1530 · Computer Hardware | Dec 10 | 234 |  |  |  |  |  | Filter by [NAME] to only show what you want.
4050 · Sales | Jan 10 | 61553.44
4050 · Sales | Feb 10 | 3 |  |  | Sum of Amt | Column Labels
4050 · Sales | Dec 10 | 32424 |  |  | Row Labels | Dec 10 | Jan 10 | Feb 10 | Grand Total
5050 · Shop Supplies | Jan 10 | 1142.16 |  |  | 1530 · Computer Hardware | 234 |  |  | 234
5050 · Shop Supplies | Feb 10 | 356 |  |  | 4050 · Sales | 32424 | 61553.44 | 3 | 93980.44
5050 · Shop Supplies | Dec 10 | 6532 |  |  | 5050 · Shop Supplies | 6532 | 1142.16 | 356 | 8030.16
5070 · Member Services | Feb 10 |  |  |  | 5070 · Member Services
5070 · Member Services | Dec 10 |  |  |  | 5073 - Beer, Wine & Soda | 2312 |  | 1324 | 3636
5073 - Beer, Wine & Soda | Feb 10 | 1324 |  |  | 6020 · Advertising Expense | 5643 |  |  | 5643
5073 - Beer, Wine & Soda | Dec 10 | 2312 |  |  | 6120 · Bank Service Charges | 345 | 25 | 435 | 805
6020 · Advertising Expense | Dec 10 | 5643 |  |  | 6135 · Credit Card Merchant Fees | 3435 | 662.61 | 34 | 4131.61
6120 · Bank Service Charges | Jan 10 | 25 |  |  | 6170 · Equipment Rental |  | 779.94 |  | 779.94
6120 · Bank Service Charges | Feb 10 | 435 |  |  | 6180 · Insurance | 234 | 48.12 |  | 282.12
6120 · Bank Service Charges | Dec 10 | 345 |  |  | 6200 · Interest Expense
6135 · Credit Card Merchant Fees | Jan 10 | 662.61 |  |  | 6210 · Finance Charge |  | 74 |  | 74
6135 · Credit Card Merchant Fees | Feb 10 | 34 |  |  | 6235 · Maintenance & Cleaning | 634 |  |  | 634
6135 · Credit Card Merchant Fees | Dec 10 | 3435 |  |  | 6250 · Postage and Delivery | 13 |  |  | 13
6170 · Equipment Rental | Jan 10 | 779.94 |  |  | 6260 · Printing and Reproduction | 124 |  |  | 124
6180 · Insurance | Jan 10 | 48.12 |  |  | 6270 · Professional Fees |  |  | 5 | 5
6180 · Insurance | Dec 10 | 234 |  |  | 6280 · Legal Fees | 23 |  | 34 | 57
6200 · Interest Expense | Jan 10 |  |  |  | 6285 · Consulting Expense | 23 |  |  | 23
6210 · Finance Charge | Jan 10 | 74 |  |  | 6290 · Rent | 324 |  |  | 324
6235 · Maintenance & Cleaning | Dec 10 | 634 |  |  | 6335 · Salon Supply Expenses | 5234 | 726.77 | 638.91 | 6599.68
6250 · Postage and Delivery | Dec 10 | 13 |  |  | 6336 · Towels |  | 1000 |  | 1000
6260 · Printing and Reproduction | Dec 10 | 124 |  |  | 6340 · Telephone | 234 | 724.91 | 56 | 1014.91
6270 · Professional Fees | Feb 10 | 5 |  |  | 6341 · Website Services | 643 | 27 | 37 | 707
6270 · Professional Fees | Dec 10 |  |  |  | 6342 · Email & Internet Services | 5687 | 536 | 324 | 6547
6280 · Legal Fees | Feb 10 | 34 |  |  | 6350 · Travel & Ent
6280 · Legal Fees | Dec 10 | 23 |  |  | 6370 · Meals |  | 38.94 |  | 38.94
6285 · Consulting Expense | Dec 10 | 23 |  |  | 6390 · Utilities
6290 · Rent | Dec 10 | 324 |  |  | 6390 · Utilities - Other | 406.36 | 454.38 | 435 | 1295.74
6335 · Salon Supply Expenses | Jan 10 | 726.77 |  |  | 6393 - CAM | 65 |  |  | 65
6335 · Salon Supply Expenses | Feb 10 | 638.91 |  |  | 6400 · Gas and Electric | 234 |  | 47 | 281
6335 · Salon Supply Expenses | Dec 10 | 5234 |  |  | 6410 · Water | 5 |  |  | 5
6336 · Towels | Jan 10 | 1000 |  |  | 6415 · Cable | 675 | 104.8 | 7856 | 8635.8
6340 · Telephone | Jan 10 | 724.91 |  |  | 6550 · Office Supplies |  | 218.32 |  | 218.32
6340 · Telephone | Feb 10 | 56 |  |  | 6551 · Outsourced Services | 234 | 705.37 | 2431 | 3370.37
6340 · Telephone | Dec 10 | 234 |  |  | 6560 · Payroll Expenses | 456 | 38809.49 | 45 | 39310.49
6341 · Website Services | Jan 10 | 27 |  |  | 6820 · Taxes | 56 |  |  | 56
6341 · Website Services | Feb 10 | 37 |  |  | 6862 · To be indentified | 456 | 1630.89 |  | 2086.89
6341 · Website Services | Dec 10 | 643 |  |  | Employee Awards | 456 |  |  | 456
6342 · Email & Internet Services | Jan 10 | 536 |  |  | Total 5070 · Member Services | 1368 |  | 912 | 2280
6342 · Email & Internet Services | Feb 10 | 324 |  |  | Total 6200 · Interest Expense |  | 2280 |  | 2280
6342 · Email & Internet Services | Dec 10 | 5687 |  |  | Total 6270 · Professional Fees | 5928 |  | 3648 | 9576
6350 · Travel & Ent | Jan 10 |  |  |  | Total 6350 · Travel & Ent |  | 9576 |  | 9576
6370 · Meals | Jan 10 | 38.94 |  |  | Total 6390 · Utilities | 78888 | 19152 | 38304 | 136344
6390 · Utilities | Jan 10 |  |  |  | Grand Total | 153325.36 | 140270.14 | 56924.91 | 350520.41
6390 · Utilities | Feb 10
6390 · Utilities | Dec 10
6390 · Utilities - Other | Jan 10 | 454.38
6390 · Utilities - Other | Feb 10 | 435
6390 · Utilities - Other | Dec 10 | 406.36
6393 - CAM | Dec 10 | 65
6400 · Gas and Electric | Feb 10 | 47
6400 · Gas and Electric | Dec 10 | 234
6410 · Water | Dec 10 | 5
6415 · Cable | Jan 10 | 104.8
6415 · Cable | Feb 10 | 7856
6415 · Cable | Dec 10 | 675
6550 · Office Supplies | Jan 10 | 218.32
6551 · Outsourced Services | Jan 10 | 705.37
6551 · Outsourced Services | Feb 10 | 2431
6551 · Outsourced Services | Dec 10 | 234
6560 · Payroll Expenses | Jan 10 | 38809.49
6560 · Payroll Expenses | Feb 10 | 45
6560 · Payroll Expenses | Dec 10 | 456
6820 · Taxes | Dec 10 | 56
6862 · To be indentified | Jan 10 | 1630.89
6862 · To be indentified | Dec 10 | 456
Employee Awards | Dec 10 | 456
Total 5070 · Member Services | Feb 10
Total 5070 · Member Services | Dec 10
Total 6200 · Interest Expense | Jan 10
Total 6270 · Professional Fees | Feb 10
Total 6270 · Professional Fees | Dec 10
Total 6350 · Travel & Ent | Jan 10
Total 6390 · Utilities | Jan 10
Total 6390 · Utilities | Feb 10
Total 6390 · Utilities | Dec 10