Spreadsheet: 217653d1362142664-subtotal-ignoring-intermediate-sumif-dummy-data-excel-help
Sheet: What I'd Like

ABC CO
FINANCIAL PERIOD: | 2012-11-30 00:00:00
 |  | ABC CO |  | ABC CO Adjustments |  | ABC CO ACCRUAL
 |  | 001 |  | 085 |  | ACCRUAL BASIS
Account Type | Account #
INVESTMENTS | 156-005 | 0 | 0 | 0 | 0
FIXED ASSETS | 161-000 | 0 | 747000 | 0 | 0
FIXED ASSETS | 164-001 | 0 | 690358.31 | 0 | 0
FIXED ASSETS | 164-002 | 973.13 | 230179.67 | 0 | 0
FIXED ASSETS | 164-003 | 0 | 1082300.99 | 0 | 0
FIXED ASSETS | 164-005 | 0 | 160634.05 | 0 | 0
FIXED ASSETS | 164-010 | 0 | 187539.85 | 0 | 0
FIXED ASSETS | 164-011 | 2533.25 | 46659.24 | 0 | 0
FIXED ASSETS | 164-012 | 0 | 7129.94 | 0 | 0
FIXED ASSETS | 164-013 | 0 | 11492.3 | 0 | 0
FIXED ASSETS | 164-014 | 0 | 523180.01 | 0 | 0
FIXED ASSETS | 164-015 | 0 | 6454.47 | 0 | 0
FIXED ASSETS | 164-016 | 13105.44 | 272127.57 | 0 | 0
FIXED ASSETS | 164-017 | 0 | 99968.88 | 0 | 0
FIXED ASSETS | 164-018 | 0 | 44667.66 | 0 | 0
FIXED ASSETS | 164-019 | 0 | 310517.85 | 0 | 0
FIXED ASSETS | 164-020 | 0 | 245681.76 | 0 | 0
FIXED ASSETS | 164-021 | 150 | 119130.63 | 0 | 0
FIXED ASSETS | 164-022 | 0 | 12993.19 | 0 | 0
FIXED ASSETS | 165-000 | 0 | 3213690.67 | 0 | 0
FIXED ASSETS | 165-001 | 0 | 17161.49 | 0 | 0
FIXED ASSETS | 167-000 | 0 | 0 | 0 | 0
FIXED ASSETS | 169-000 | 0 | 25857.92 | 0 | 0
ACCUMULATED DEPR. | 171-000 | 0 | 0 | 0 | 0
ACCUMULATED DEPR. | 174-001 | 0 | -690358.31 | 0 | 0
ACCUMULATED DEPR. | 174-002 | -127.89 | -222223.87 | 0 | 0
ACCUMULATED DEPR. | 174-003 | -13.24 | -1082188.28 | 0 | 0
ACCUMULATED DEPR. | 174-005 | -6.75 | -160576.63 | 0 | 0
ACCUMULATED DEPR. | 174-010 | -389.48 | -175892.1 | 0 | 0
ACCUMULATED DEPR. | 174-011 | -92.65 | -35245.3 | 0 | 0
ACCUMULATED DEPR. | 174-012 | 0 | -5917.54 | 0 | 0
ACCUMULATED DEPR. | 174-013 | -40.68 | -10768.52 | 0 | 0
ACCUMULATED DEPR. | 174-014 | -1630.88 | -456564.55 | 0 | 0
ACCUMULATED DEPR. | 174-015 | -27.85 | -6047.32 | 0 | 0
ACCUMULATED DEPR. | 174-016 | -780 | -228649.88 | 0 | 0
ACCUMULATED DEPR. | 174-017 | 0 | 0 | 0 | 0
ACCUMULATED DEPR. | 174-018 | -14.15 | -43773.59 | 0 | 0
ACCUMULATED DEPR. | 174-019 | -39.71 | -310260.2 | 0 | 0
ACCUMULATED DEPR. | 174-020 | 0 | -237923.48 | 0 | 0
ACCUMULATED DEPR. | 174-021 | -148.81 | -111760.61 | 0 | 0
ACCUMULATED DEPR. | 174-022 | -15.06 | -12948.04 | 0 | 0
ACCUMULATED DEPR. | 175-000 | -644.93 | -3167484.37 | 0 | 0
ACCUMULATED DEPR. | 175-001 | 0 | -17161.49 | 0 | 0
ACCUMULATED DEPR. | 177-000 | 0 | 0 | 0 | 0
 | ACCUMULATED DEPR.
[NAME] | 191-000 | 0 | 500 | 0 | 0
[NAME] | 191-001 | 0 | 200 | 0 | 0
[NAME] | 191-002 | 0 | 33851.25 | 0 | 0
[NAME] | 191-004 | 0 | 174.72 | 0 | 0
[NAME] | 191-005 | 0 | 52227.6 | 0 | 0
[NAME] | 191-006 | 0 | 0 | 0 | 0
[NAME] | 191-007 | 0 | 5000 | 0 | 0
[NAME] | 191-008 | 0 | 400 | 0 | 0
[NAME] | 191-009 | 0 | 31335 | 0 | 0
[NAME] | 191-010 | 0 | 2500 | 0 | 0
[NAME] | 191-011 | 0 | 18538 | 0 | 0
[NAME] | 191-900 | 0 | 0 | 0 | 0
CURRENT PAYABLES | 200-000 | 0 | 0 | 0 | 0
CURRENT PAYABLES | 200-101 | 0 | 0 | 0 | 0
CURRENT PAYABLES | 200-111 | 0 | 0 | 0 | 0
CURRENT PAYABLES | 200-118 | 0 | 0 | 0 | 0
CURRENT PAYABLES | 201-000 | 0 | 0 | -48008.75 | -48008.75
CURRENT PAYABLES | 201-001 | 0 | 0 | 0 | 0
 | INTEREST PAYABLE | 0 | 0 | -48008.75 | -48008.75
CURRENT PAYABLES | 203-000 | 0 | 0 | 0 | 0
CURRENT PAYABLES | 203-001 | 0 | 0 | -37500 | -412500
CURRENT PAYABLES | 203-002 | 0 | 0 | -55918.11 | -193278.94
CURRENT PAYABLES | 204-000 | 0 | 0 | 0 | 0
CURRENT PAYABLES | 205-002 | -146122 | 437533 | 0 | 0
CURRENT PAYABLES | 205-004 | 0 | 0 | 0 | 0
 | PROFIT SHARING PLAN | -146122 | 437533 | 0 | 0
CURRENT PAYABLES | 206-000 | 0 | 0 | 0 | 0
CURRENT PAYABLES | 208-000 | 0 | 0 | 0 | 0
CAPITAL GAIN/(LOSS) | 421-000 | 0 | -11.38 | 0 | 0
CAPITAL GAIN/(LOSS) | 421-001 | 0 | 0 | 0 | 0
CAPITAL GAIN/(LOSS) | 421-002 | 0 | -1392647.31 | 0 | 0
CAPITAL GAIN/(LOSS) | 421-003 | 0 | 0 | 0 | 0
CAPITAL GAIN/(LOSS) | 422-000 | 0 | 0 | 0 | 0
CAPITAL GAIN/(LOSS) | 422-001 | 0 | 0 | 0 | 0
CAPITAL GAIN/(LOSS) | 422-002 | 0 | 0 | 0 | 0
 | CAPITAL GAINS | 0 | -1392658.69 | 0 | 0
[NAME] | 491-000 | 0 | -850 | 0 | 0
[NAME] | 491-001 | 0 | 96.64 | 0 | 0
[NAME] | 491-100 | 0 | 0 | 0 | 0
[NAME] | 491-200 | 0 | 0 | 0 | 0
 | MISC INC | 0 | -753.36 | 0 | 0
CONTRIBUTIONS | 501-000 | 7120 | 402370 | 0 | 0
FEDERAL TAX EXPENSE | 595-000 | 0 | 0 | 520848 | 8693837
NON-TAX INCOME/LOSS | 599-000 | 0 | 0 | 855260.71 | 853048.94
NON-TAX INCOME/LOSS | 599-001 | 0 | 0 | 0 | 0
TIES TO INCOME STMT AFTER | TOTAL INCOME | -7291904.560000001 | -74197980.47 | 1247873.79 | 3392413.06
INTERCO ELIM | TOTAL EXPENSES | 4699726.82 | 36731962.58 | 796353.57 | 8446084.65
 | NET INCOME(LOSS) | -2592177.74 | -37466017.89 | 2044227.36 | 11838497.71