Spreadsheet: 22794d1211952262-include-account-code-in-pivot-table-book2_pivot
Sheet: PRE_Detailed

Prepayments - Insurances
General | Accounts | Total | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00
[NAME] | 01-100-3650 | 837.3263333333334 | 93.03625925925927 | 93.03625925925927 | 93.03625925925927 | 93.03625925925927 | 93.03625925925927 | 93.03625925925927 | 93.03625925925927 | 93.03625925925927 | 93.03625925925927
Gosford | 01-110-3650 | 180.1063333333333 | 20.01181481481482 | 20.01181481481482 | 20.01181481481482 | 20.01181481481482 | 20.01181481481482 | 20.01181481481482 | 20.01181481481482 | 20.01181481481482 | 20.01181481481482
East | 00-211-3650 | 295.4913333333333 | 32.83237037037037 | 32.83237037037037 | 32.83237037037037 | 32.83237037037037 | 32.83237037037037 | 32.83237037037037 | 32.83237037037037 | 32.83237037037037 | 32.83237037037037
GOSFORD | 00-212-3650 | 768.3313333333333 | 85.37014814814816 | 85.37014814814816 | 85.37014814814816 | 85.37014814814816 | 85.37014814814816 | 85.37014814814816 | 85.37014814814816 | 85.37014814814816 | 85.37014814814816
KINCUMBER | 00-213-3650 | 274.1913333333333 | 30.46570370370371 | 30.46570370370371 | 30.46570370370371 | 30.46570370370371 | 30.46570370370371 | 30.46570370370371 | 30.46570370370371 | 30.46570370370371 | 30.46570370370371
UMINA | 00-214-3650 | 284.9213333333333 | 31.65792592592593 | 31.65792592592593 | 31.65792592592593 | 31.65792592592593 | 31.65792592592593 | 31.65792592592593 | 31.65792592592593 | 31.65792592592593 | 31.65792592592593
WOY WOY | 00-215-3650 | 800.1213333333334 | 88.90237037037038 | 88.90237037037038 | 88.90237037037038 | 88.90237037037038 | 88.90237037037038 | 88.90237037037038 | 88.90237037037038 | 88.90237037037038 | 88.90237037037038
AVOCA DRIVE | 00-216-3650 | 271.3913333333334 | 30.15459259259259 | 30.15459259259259 | 30.15459259259259 | 30.15459259259259 | 30.15459259259259 | 30.15459259259259 | 30.15459259259259 | 30.15459259259259 | 30.15459259259259
ERINA | 00-217-3650 | 285.9313333333334 | 31.77014814814815 | 31.77014814814815 | 31.77014814814815 | 31.77014814814815 | 31.77014814814815 | 31.77014814814815 | 31.77014814814815 | 31.77014814814815 | 31.77014814814815
EPPING | 00-222-3650 | 654.5613333333336 | 72.72903703703705 | 72.72903703703705 | 72.72903703703705 | 72.72903703703705 | 72.72903703703705 | 72.72903703703705 | 72.72903703703705 | 72.72903703703705 | 72.72903703703705
GALSTON | 00-223-3650 | 259.4813333333334 | 28.83125925925926 | 28.83125925925926 | 28.83125925925926 | 28.83125925925926 | 28.83125925925926 | 28.83125925925926 | 28.83125925925926 | 28.83125925925926 | 28.83125925925926
HORNSBY | 00-224-3650 | 806.6213333333333 | 89.62459259259259 | 89.62459259259259 | 89.62459259259259 | 89.62459259259259 | 89.62459259259259 | 89.62459259259259 | 89.62459259259259 | 89.62459259259259 | 89.62459259259259
PENNANT [NAME] | 00-225-3650 | 427.6513333333335 | 47.51681481481482 | 47.51681481481482 | 47.51681481481482 | 47.51681481481482 | 47.51681481481482 | 47.51681481481482 | 47.51681481481482 | 47.51681481481482 | 47.51681481481482
Brookvale | 00-231-3650 | 3425.561333333334 | 380.617925925926 | 380.617925925926 | 380.617925925926 | 380.617925925926 | 380.617925925926 | 380.617925925926 | 380.617925925926 | 380.617925925926 | 380.617925925926
DEE WHY | 00-232-3650 | 336.9613333333333 | 37.44014814814815 | 37.44014814814815 | 37.44014814814815 | 37.44014814814815 | 37.44014814814815 | 37.44014814814815 | 37.44014814814815 | 37.44014814814815 | 37.44014814814815
MANLY | 00-233-3650 | 268.6013333333333 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926
[NAME] | 00-234-3650 | 276.1013333333333 | 30.67792592592593 | 30.67792592592593 | 30.67792592592593 | 30.67792592592593 | 30.67792592592593 | 30.67792592592593 | 30.67792592592593 | 30.67792592592593 | 30.67792592592593
NARABEEN | 00-235-3650 | 268.6013333333333 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926 | 29.8445925925926
CHATSWOOD | 00-242-3650 | 562.0313333333334 | 62.44792592592593 | 62.44792592592593 | 62.44792592592593 | 62.44792592592593 | 62.44792592592593 | 62.44792592592593 | 62.44792592592593 | 62.44792592592593 | 62.44792592592593
 |  | 11283.98533333334 | 1253.776148148148 | 1253.776148148148 | 1253.776148148148 | 1253.776148148148 | 1253.776148148148 | 1253.776148148148 | 1253.776148148148 | 1253.776148148148 | 1253.776148148148
 |  | 11283.98533333333
check | must be zero | 0
General | Accounts | Total | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00
CRC | 00-200-3650 | 56.26865671641792 | 0 | 0 | 0 | 9.37810945273632 | 9.37810945273632 | 9.37810945273632 | 9.37810945273632 | 9.37810945273632 | 9.37810945273632
East Gosford | 00-212-3650 | 58.51940298507463 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515
Gosford | 00-213-3650 | 58.51940298507463 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515 | 6.502155887230515
[NAME] | 00-214-3650 | 38.26268656716418 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798
Umina | 00-215-3650 | 40.51343283582091 | 4.501492537313434 | 4.501492537313434 | 4.501492537313434 | 4.501492537313434 | 4.501492537313434 | 4.501492537313434 | 4.501492537313434 | 4.501492537313434 | 4.501492537313434
Woy Woy | 00-216-3650 | 60.77014925373135 | 6.752238805970149 | 6.752238805970149 | 6.752238805970149 | 6.752238805970149 | 6.752238805970149 | 6.752238805970149 | 6.752238805970149 | 6.752238805970149 | 6.752238805970149
[NAME], [NAME] | 00-217-3650 | 31.51044776119404 | 3.501160862354892 | 3.501160862354892 | 3.501160862354892 | 3.501160862354892 | 3.501160862354892 | 3.501160862354892 | 3.501160862354892 | 3.501160862354892 | 3.501160862354892
Erina | 00-217-3650 | 33.76119402985075 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528
Turramurra | 00-223-3650 | 22.50746268656717 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352
Epping | 00-224-3650 | 141.7970149253732 | 15.75522388059702 | 15.75522388059702 | 15.75522388059702 | 15.75522388059702 | 15.75522388059702 | 15.75522388059702 | 15.75522388059702 | 15.75522388059702 | 15.75522388059702
Galston | 00-225-3650 | 38.26268656716418 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798 | 4.251409618573798
Hornsby | 00-224-3650 | 85.52835820895524 | 9.503150912106138 | 9.503150912106138 | 9.503150912106138 | 9.503150912106138 | 9.503150912106138 | 9.503150912106138 | 9.503150912106138 | 9.503150912106138 | 9.503150912106138
Pennant Hills | 00-225-3650 | 119.289552238806 | 13.25439469320066 | 13.25439469320066 | 13.25439469320066 | 13.25439469320066 | 13.25439469320066 | 13.25439469320066 | 13.25439469320066 | 13.25439469320066 | 13.25439469320066
Brookvale | 00-234-3650 | 94.53134328358212 | 10.50348258706468 | 10.50348258706468 | 10.50348258706468 | 10.50348258706468 | 10.50348258706468 | 10.50348258706468 | 10.50348258706468 | 10.50348258706468 | 10.50348258706468
[NAME] | 00-235-3650 | 33.76119402985075 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528
Manly | 00-233-3650 | 45.01492537313433 | 5.001658374792703 | 5.001658374792703 | 5.001658374792703 | 5.001658374792703 | 5.001658374792703 | 5.001658374792703 | 5.001658374792703 | 5.001658374792703 | 5.001658374792703
[NAME] | 00-234-3650 | 33.76119402985075 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528
Narabeen | 00-241-3650 | 33.76119402985075 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528 | 3.751243781094528
Northbridge | 00-245-3650 | 22.50746268656717 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352 | 2.500829187396352
Chatswood | 00-246-3650 | 126.0417910447762 | 14.00464344941957 | 14.00464344941957 | 14.00464344941957 | 14.00464344941957 | 14.00464344941957 | 14.00464344941957 | 14.00464344941957 | 14.00464344941957 | 14.00464344941957
Orchard Arcade | 00-243-3650 | 20.25671641791045 | 2.250746268656717 | 2.250746268656717 | 2.250746268656717 | 2.250746268656717 | 2.250746268656717 | 2.250746268656717 | 2.250746268656717 | 2.250746268656717 | 2.250746268656717
Grand Total |  | 1195.146268656717 | 126.5419568822554 | 126.5419568822554 | 126.5419568822554 | 135.9200663349917 | 135.9200663349917 | 135.9200663349917 | 135.9200663349917 | 135.9200663349917 | 135.9200663349917
 |  | 1195.146268656717
check | must be zero | 0