Docstoc

June 2012

Document Sample
June 2012 Powered By Docstoc
					                                                         Instructions for Exporting QuickBooks data

Where did my worksheet go?
          When you export data to a new workbook, your new worksheet containing exported data goes to Sheet 1. When
          the new worksheet is placed in front of the last active sheet where it will be named "SheetX" using the next availa


How do I make sure this tips sheet isn't exported with the QuickBooks report in the final workbook?
          Before exporting, on the Export Report Basic tab, deselect the option to include the instruction worksheet.


How can I customize and update my worksheet?
           You can set up Excel links between 2 or more worksheets. (See Microsoft Excel Help for details about linking in Ex
           feature to setup links between a QuickBooks summary report and your customized sheet.
                       >> Choose one sheet as your source worksheet into which you'll export QuickBooks data. Then create a
                       customize your data and link the data between that sheet and the source worksheet.
                       >> Export your source data to an existing worksheet and overwrite the current data so that the new da
                       >> Create Excel links between a QuickBooks data worksheet and another worksheet in the workbook.


Troubleshooting: Why don't my links work correctly after exporting data?
          Be aware that any difference in the structure of the current report from the report that you used when setting up
          in the links between worksheets. If you are seeing wrong data in your customized worksheet, then you may have:
                       >> Moved or deleted elements, or changed the structure of the report in some way? For example:
                                  You might have moved or deleted items from item list which gets used in a report like Inve
                                  You might have moved or deleted accounts from accounts list which gets used in a report l
                       >> You are using a report related to accounts and have account(s) with no activity associated and did n
                                  TIP: Choose display All rows (available for most of the reports), Select Modify report->Disp
                       >> Deleted exported data sheet which serves as data source.
orted data goes to Sheet 1. When you export to an existing workbook,
med "SheetX" using the next available number in the series.




 the instruction worksheet.




 Help for details about linking in Excel.) You can use this

 rt QuickBooks data. Then create another worksheet where you can
 urce worksheet.
he current data so that the new data is used by any Excel links and formulas.
ther worksheet in the workbook.




ort that you used when setting up links, can cause mismatch
 d worksheet, then you may have:
t in some way? For example:
hich gets used in a report like Inventory Valuation report.
ts list which gets used in a report like Profit and Loss standard report.
th no activity associated and did not choose to display "All rows".
ports), Select Modify report->Display->Advanced->Display Rows->All rows
9:56 PM                             Early College High Schools, Inc.
08/20/12
                                            Check Detail
                   Type            Num
                                               June 2012
                                                Date                            Name                     Item


           Check             ACH              06/01/2012   Absolute Security


                                                           2600 - Operation and Maint. of School Svs
TOTAL




           Check             ACH              06/01/2012   Select125


                                                           1300 - Natural Science
                                                           1500 - Social Sciences
                                                           1100 - Mathematics
                                                           2400 - School Administration
                                                           2400 - School Administration
                                                           1300 - Natural Science
                                                           1500 - Social Sciences
                                                           2100 - Support Services - Students
                                                           2100 - Support Services - Students
                                                           0500 - English Language Arts
                                                           2400 - School Administration
TOTAL




           Check             ACH              06/06/2012   Lewan & Associates


                                                           0030 - General High School Education
TOTAL




           Check             ACH              06/08/2012   ADP, Inc.


                                                           2400 - School Administration
TOTAL




           Check             ACH              06/13/2012   Texas Roadhouse


                                                           2400 - School Administration
TOTAL




           Bill Pmt -Check   ACH              06/15/2012   Aflac


           Bill                               06/11/2012   0000 - Equity/Liability/Asset
                                                           0000 - Equity/Liability/Asset




                                                                                                       Page 3 of 22
9:56 PM                             Early College High Schools, Inc.
08/20/12
                                            Check Detail
                   Type            Num
                                               June 2012
                                                Date                            Name                     Item

                                                           0000 - Equity/Liability/Asset
TOTAL




           Bill Pmt -Check   ACH              06/20/2012   Ring Central, Inc


           Bill                               06/20/2012   2400 - School Administration
TOTAL




           Bill Pmt -Check   ACH              06/26/2012   VSP


           Bill                               07/01/2012   2400 - School Administration
                                                           1700 - Special Education
                                                           2400 - School Administration
                                                           2400 - School Administration
                                                           2100 - Support Services - Students
                                                           2100 - Support Services - Students
                                                           1300 - Natural Science
                                                           1500 - Social Sciences
                                                           1100 - Mathematics
                                                           0500 - English Language Arts
                                                           1500 - Social Sciences
                                                           1300 - Natural Science
                                                           2400 - School Administration
                                                           1300 - Natural Science
                                                           2100 - Support Services - Students
TOTAL




           Bill Pmt -Check   ACH              06/29/2012   Xcel Energy


           Bill                               06/01/2012   2600 - Operation and Maint. of School Svs
                                                           2600 - Operation and Maint. of School Svs
                                                           2600 - Operation and Maint. of School Svs
                                                           2600 - Operation and Maint. of School Svs
TOTAL




           Check             ACH              06/29/2012   Allied Waste Services


                                                           2600 - Operation and Maint. of School Svs
TOTAL




                                                                                                       Page 4 of 22
9:56 PM                              Early College High Schools, Inc.
08/20/12
                                             Check Detail
                  Type              Num
                                                June 2012
                                                 Date                            Name                     Item

           Bill Pmt -Check   1888              06/04/2012   City of Arvada


           Bill                                05/04/2012   2600 - Operation and Maint. of School Svs
TOTAL




           Bill Pmt -Check   1889              06/04/2012   Delta Dental


           Bill                                06/01/2012   0500 - English Language Arts
                                                            1300 - Natural Science
                                                            2100 - Support Services - Students
                                                            2100 - Support Services - Students
                                                            2100 - Support Services - Students
                                                            2400 - School Administration
                                                            2400 - School Administration
                                                            0500 - English Language Arts
                                                            1500 - Social Sciences
                                                            2400 - School Administration
                                                            0000 - Equity/Liability/Asset
                                                            0000 - Equity/Liability/Asset
                                                            2400 - School Administration
                                                            1300 - Natural Science
TOTAL




           Bill Pmt -Check   1890              06/04/2012   Kaiser Permanente


           Bill                                05/16/2012   0000 - Equity/Liability/Asset
                                                            1300 - Natural Science
                                                            2100 - Support Services - Students
                                                            2400 - School Administration
                                                            1500 - Social Sciences
                                                            1500 - Social Sciences
                                                            2100 - Support Services - Students
                                                            2400 - School Administration
                                                            2400 - School Administration
                                                            2100 - Support Services - Students
                                                            0500 - English Language Arts
                                                            1100 - Mathematics
                                                            0000 - Equity/Liability/Asset
                                                            2400 - School Administration
                                                            1300 - Natural Science
                                                            1200 - Music
TOTAL




                                                                                                        Page 5 of 22
9:56 PM                              Early College High Schools, Inc.
08/20/12
                                             Check Detail
                  Type              Num
                                                June 2012
                                                 Date                           Name                      Item




           Bill Pmt -Check   1891              06/04/2012   Security Plumbing


           Bill                                05/17/2012   2600 - Operation and Maint. of School Svs
TOTAL




           Bill Pmt -Check   1892              06/04/2012   Sixtieth, LLC


           Bill                                05/17/2012   2600 - Operation and Maint. of School Svs
                                                            2800 - Central Support Risk Mgmt.
                                                            2600 - Operation and Maint. of School Svs
TOTAL




           Bill Pmt -Check   1893              06/04/2012   Tatonka Capital Corporation


           Bill                                05/16/2012   2600 - Operation and Maint. of School Svs
TOTAL




           Bill Pmt -Check   1894              06/04/2012   Xcel Energy


TOTAL




           Bill Pmt -Check   1895              06/04/2012   YTD Charter Financial Services, LLC


           Bill                                06/04/2012   2500 - Business
TOTAL




           Bill Pmt -Check   1896              06/15/2012   Colorado Council for Economic Education


           Bill                                05/04/2012   1500 - Social Sciences
TOTAL




           Bill Pmt -Check   1897              06/15/2012   Security Plumbing


           Bill                                05/16/2012   2600 - Operation and Maint. of School Svs
TOTAL




                                                                                                        Page 6 of 22
9:56 PM                                 Early College High Schools, Inc.
08/20/12
                                                    Check Detail
                   Type               Num
                                                      June 2012
                                                       Date                            Name                     Item

           Check             1898                    06/15/2012   Security Plumbing


TOTAL




           Check             1899                    06/15/2012   Colorado Council for Economic Education


TOTAL




           Bill Pmt -Check   1900                    06/16/2012   ACT Finance


           Bill              Inv: 3108-1959, 1877    06/16/2012   2200 - Support Services Instructional St
                                                                  2200 - Support Services Instructional St
TOTAL




           Bill Pmt -Check   1901                    06/16/2012   Arrington Law Firm


           Bill                                      05/18/2012   2300 - BOD
TOTAL




           Bill Pmt -Check   1902                    06/16/2012   Century Link


           Bill                                      05/18/2012   2600 - Operation and Maint. of School Svs
TOTAL




           Bill Pmt -Check   1903                    06/16/2012   Colorado Council on High School & College


           Bill                                      05/31/2012   2100 - Support Services - Students
TOTAL




           Bill Pmt -Check   1904                    06/16/2012   Cross Cultural Business, Inc


           Bill                                      05/18/2012   0600 - Foreign Languages
TOTAL




           Bill Pmt -Check   1905                    06/16/2012   jostens


           Bill                                      06/16/2012   1900 - Cocurricular Activites-NonAthletic
TOTAL




                                                                                                              Page 7 of 22
9:56 PM                              Early College High Schools, Inc.
08/20/12
                                             Check Detail
                  Type              Num
                                                June 2012
                                                 Date                            Name                     Item




           Bill Pmt -Check   1906              06/16/2012   Kathleen Gaskins


           Bill                                06/03/2012   1900 - Cocurricular Activites-NonAthletic
TOTAL




           Bill Pmt -Check   1907              06/16/2012   Lewan & Associates


           Bill                                06/01/2012   0030 - General High School Education
                                                            0030 - General High School Education
TOTAL




           Bill Pmt -Check   1908              06/16/2012   National Honor Society


           Bill                                06/15/2012   2200 - Support Services Instructional St
TOTAL




           Bill Pmt -Check   1909              06/16/2012   Philadelphia Insurance Companies


           Bill                                05/11/2012   2800 - Central Support Risk Mgmt.
                                                            2800 - Central Support Risk Mgmt.
TOTAL




           Bill Pmt -Check   1910              06/16/2012   Pinnacol Assurance


           Bill                                05/18/2012   2800 - Central Support Risk Mgmt.
TOTAL




           Bill Pmt -Check   1911              06/16/2012   Revolution Foods, Inc


           Bill                                06/01/2012   3100 - Food Service Operations
TOTAL




           Bill Pmt -Check   1912              06/16/2012   Security Plumbing


           Bill                                05/31/2012   2600 - Operation and Maint. of School Svs
TOTAL




                                                                                                        Page 8 of 22
9:56 PM                              Early College High Schools, Inc.
08/20/12
                                             Check Detail
                  Type              Num
                                                June 2012
                                                 Date                            Name              Item




           Bill Pmt -Check   1913              06/15/2012   Select125


           Bill                                05/01/2012   2400 - School Administration
           Bill                                06/01/2012   2400 - School Administration
TOTAL




           Bill Pmt -Check   1914              06/27/2012   Delta Dental


           Bill                                07/01/2012   0500 - English Language Arts
                                                            1300 - Natural Science
                                                            2100 - Support Services - Students
                                                            2100 - Support Services - Students
                                                            2100 - Support Services - Students
                                                            2400 - School Administration
                                                            2400 - School Administration
                                                            0500 - English Language Arts
                                                            1500 - Social Sciences
                                                            2400 - School Administration
                                                            0000 - Equity/Liability/Asset
                                                            0000 - Equity/Liability/Asset
                                                            2400 - School Administration
                                                            1300 - Natural Science
TOTAL




           Bill Pmt -Check   1915              06/27/2012   Kaiser Permanente


           Bill                                07/01/2012   0000 - Equity/Liability/Asset
                                                            1300 - Natural Science
                                                            2100 - Support Services - Students
                                                            2400 - School Administration
                                                            1500 - Social Sciences
                                                            1500 - Social Sciences
                                                            2100 - Support Services - Students
                                                            2400 - School Administration
                                                            2400 - School Administration
                                                            2100 - Support Services - Students
                                                            0500 - English Language Arts
                                                            1100 - Mathematics
                                                            0000 - Equity/Liability/Asset
                                                            2400 - School Administration
                                                            1300 - Natural Science




                                                                                                 Page 9 of 22
9:56 PM                              Early College High Schools, Inc.
08/20/12
                                             Check Detail
                   Type             Num
                                                June 2012
                                                 Date                           Name                       Item

                                                            1200 - Music
TOTAL




           Bill Pmt -Check   1916              06/27/2012   Sixtieth, LLC


           Bill                                07/01/2012   2600 - Operation and Maint. of School Svs
                                                            2800 - Central Support Risk Mgmt.
                                                            2600 - Operation and Maint. of School Svs
TOTAL




           Bill Pmt -Check   1917              06/27/2012   Tatonka Capital Corporation


           Bill                                07/01/2012   2600 - Operation and Maint. of School Svs
TOTAL




           Bill Pmt -Check   1918              06/27/2012   VSP


TOTAL




           Bill Pmt -Check   1919              06/01/2012   Edward Ahumada


           Bill                                06/01/2012   0600 - Foreign Languages
TOTAL




           Bill Pmt -Check   1920              06/26/2012   YTD Charter Financial Services, LLC


           Bill                                06/13/2012   2500 - Business
TOTAL




           Check             2038              06/04/2012   Yvette Martinez


                                                            2600 - Operation and Maint. of School Svs
TOTAL




           Check             2041              06/06/2012   Jordans Building Center


                                                            2600 - Operation and Maint. of School Svs
TOTAL




                                                                                                        Page 10 of 22
9:56 PM                              Early College High Schools, Inc.
08/20/12
                                             Check Detail
                   Type             Num
                                                June 2012
                                                 Date                           Name                       Item




           Check             2042              06/04/2012   Oreck FCC of Arvada


                                                            2600 - Operation and Maint. of School Svs
TOTAL




           Bill Pmt -Check   2043              06/06/2012   Martha Caron


           Bill                                05/16/2012   1300 - Natural Science
                                                            1300 - Natural Science
TOTAL




           Bill Pmt -Check   2044              06/06/2012   Michael Porter


           Bill                                06/01/2012   2600 - Operation and Maint. of School Svs
TOTAL




           Check             2045              06/18/2012   Michael Porter


                                                            2600 - Operation and Maint. of School Svs
TOTAL




           Check             2046              06/21/2012   USPS/Post Office


                                                            2400 - School Administration
TOTAL




           Check             2047              06/21/2012   Steve Quintana Memorial Fund


                                                            2400 - School Administration
TOTAL




           Check             2048              06/28/2012   Michael Porter


                                                            2600 - Operation and Maint. of School Svs
TOTAL




                                                                                                        Page 11 of 22
9:56 PM                              Early College High Schools, Inc.
08/20/12
                                             Check Detail
                  Type              Num
                                                June 2012
                                                 Date                           Name                       Item

           Bill Pmt -Check   2049              06/29/2012   CBeyond


           Bill                                06/15/2012   2600 - Operation and Maint. of School Svs
           Bill                                06/30/2012   2600 - Operation and Maint. of School Svs
TOTAL




                                                                                                        Page 12 of 22
9:56 PM                                            Early College High Schools, Inc.
08/20/12
                                                           Check Detail
                              Account
                                                               June 2012
                                                             Paid Amount     Original Amount


           8101C · Sooper Credit Union                                                 -41.99


           0339 · Fire Alarm Monitoring                            -41.99               41.99
TOTAL                                                              -41.99               41.99




           8101B · Checking Account                                                  -1,057.32


           7471Flx · Flexible Spending Plan                        -50.00               50.00
           7471Flx · Flexible Spending Plan                        -50.00               50.00
           7471Flx · Flexible Spending Plan                        -50.00               50.00
           7471Flx · Flexible Spending Plan                       -225.00              225.00
           7471Flx · Flexible Spending Plan                        -14.00               14.00
           7471Flx · Flexible Spending Plan                       -291.66              291.66
           7471Flx · Flexible Spending Plan                        -41.66               41.66
           7471Flx · Flexible Spending Plan                        -90.00               90.00
           7471Flx · Flexible Spending Plan                       -100.00              100.00
           7471Flx · Flexible Spending Plan                        -20.00               20.00
           7471Flx · Flexible Spending Plan                       -125.00              125.00
TOTAL                                                            -1,057.32           1,057.32




           8101B · Checking Account                                                   -499.06


           0550 · Printing, Binding, Duplicating                  -499.06              499.06
TOTAL                                                             -499.06              499.06




           8101B · Checking Account                                                   -220.05


           0340 · Payroll Services                                -220.05              220.05
TOTAL                                                             -220.05              220.05




           8101B · Checking Account                                                    -27.27


           0630 · On-Site Meals                                    -27.27               27.27
TOTAL                                                              -27.27               27.27




           8101B · Checking Account                                                   -191.26


           7471A · Aflac                                           -89.44               89.44
           7471A · Aflac                                           -62.95               62.95




                                                                                                 Page 13 of 22
9:56 PM                                     Early College High Schools, Inc.
08/20/12
                                                    Check Detail
                             Account
                                                        June 2012
                                                      Paid Amount     Original Amount

           7471A · Aflac                                    -38.87               38.87
TOTAL                                                      -191.26              191.26




           8101C · Sooper Credit Union                                            -7.99


           0531 · Telephone, Telecommunications               -7.99               7.99
TOTAL                                                         -7.99               7.99




           8101B · Checking Account                                            -112.13


           0253 · Vision Insurance                            -7.36               7.36
           0253 · Vision Insurance                            -7.36               7.36
           0253 · Vision Insurance                            -7.36               7.36
           0253 · Vision Insurance                            -7.36               7.36
           0253 · Vision Insurance                            -7.36               7.36
           0253 · Vision Insurance                            -7.36               7.36
           0253 · Vision Insurance                            -7.36               7.36
           0253 · Vision Insurance                            -7.36               7.36
           0253 · Vision Insurance                            -7.36               7.36
           0253 · Vision Insurance                            -7.36               7.36
           0253 · Vision Insurance                            -7.36               7.36
           0253 · Vision Insurance                            -7.36               7.36
           0253 · Vision Insurance                            -7.36               7.36
           7471E · Vision                                   -12.03               12.03
           7471E · Vision                                     -4.42               4.42
TOTAL                                                      -112.13              112.13




           8101B · Checking Account                                           -3,248.01


           0620 · Electric/Gas                            -3,095.97           3,095.97
           0620 · Electric/Gas                              -40.24               40.24
           0620 · Electric/Gas                              -88.32               88.32
           0620 · Electric/Gas                              -23.48               23.48
TOTAL                                                     -3,248.01           3,248.01




           8101C · Sooper Credit Union                                         -146.79


           0424 · Outdoor Maintenance                      -146.79              146.79
TOTAL                                                      -146.79              146.79




                                                                                          Page 14 of 22
9:56 PM                                Early College High Schools, Inc.
08/20/12
                                               Check Detail
                             Account
                                                   June 2012
                                                 Paid Amount     Original Amount

           8101B · Checking Account                                       -907.10


           0411 · Water/Sewer                         -907.10              907.10
TOTAL                                                 -907.10              907.10




           8101B · Checking Account                                       -404.00


           0252 · Dental Insurance                     -26.16               26.16
           0252 · Dental Insurance                     -26.16               26.16
           0252 · Dental Insurance                     -26.16               26.16
           0252 · Dental Insurance                     -26.16               26.16
           0252 · Dental Insurance                     -26.16               26.16
           0252 · Dental Insurance                     -26.16               26.16
           0252 · Dental Insurance                     -26.16               26.16
           0252 · Dental Insurance                     -26.16               26.16
           0252 · Dental Insurance                     -26.16               26.16
           0252 · Dental Insurance                     -26.16               26.16
           7471D · Dental                              -60.33               60.33
           7471D · Dental                              -29.75               29.75
           0252 · Dental Insurance                     -26.16               26.16
           0252 · Dental Insurance                     -26.16               26.16
TOTAL                                                 -404.00              404.00




           8101B · Checking Account                                      -5,276.41


           7471H · Health                             -520.71              520.71
           0251 · Health Insurance                    -254.00              254.00
           0251 · Health Insurance                    -319.96              319.96
           0251 · Health Insurance                    -254.00              254.00
           0251 · Health Insurance                    -243.97              243.97
           0251 · Health Insurance                    -279.97              279.97
           0251 · Health Insurance                    -499.98              499.98
           0251 · Health Insurance                    -279.97              279.97
           0251 · Health Insurance                    -499.98              499.98
           0251 · Health Insurance                    -254.00              254.00
           0251 · Health Insurance                    -207.97              207.97
           0251 · Health Insurance                    -199.98              199.98
           7471H · Health                             -499.97              499.97
           0251 · Health Insurance                    -499.98              499.98
           0251 · Health Insurance                    -207.97              207.97
           0251 · Health Insurance                    -254.00              254.00
TOTAL                                                -5,276.41           5,276.41




                                                                                     Page 15 of 22
9:56 PM                                           Early College High Schools, Inc.
08/20/12
                                                          Check Detail
                               Account
                                                              June 2012
                                                            Paid Amount     Original Amount




           8101B · Checking Account                                                  -644.00


           0430 · Repairs & Maintenance                          -644.00              644.00
TOTAL                                                            -644.00              644.00




           8101B · Checking Account                                                -20,285.34


           0441 · Building Rental                              -19,000.00          19,000.00
           0522 · Property / Building Insurance                  -785.34              785.34
           8191a · Security Deposit                              -500.00              500.00
TOTAL                                                          -20,285.34          20,285.34




           8101B · Checking Account                                                 -8,000.00


           0900 · Loan Payment (Tatonka Loan)                   -8,000.00           8,000.00
TOTAL                                                           -8,000.00           8,000.00




           8101B · Checking Account                                                     0.00


TOTAL                                                               0.00                0.00




           8101B · Checking Account                                                 -1,700.00


           0332 · Audit / Accounting Services                   -1,700.00           1,700.00
TOTAL                                                           -1,700.00           1,700.00




           8101B · Checking Account                                                  -100.00


           1 · Instructional Supplies                            -100.00              100.00
TOTAL                                                            -100.00              100.00




           8101B · Checking Account                                                  -299.00


           0430 · Repairs & Maintenance                          -299.00              299.00
TOTAL                                                            -299.00              299.00




                                                                                                Page 16 of 22
9:56 PM                                        Early College High Schools, Inc.
08/20/12
                                                       Check Detail
                              Account
                                                           June 2012
                                                         Paid Amount    Original Amount

           8101B · Checking Account                                                 0.00


TOTAL                                                            0.00               0.00




           8101B · Checking Account                                                 0.00


TOTAL                                                            0.00               0.00




           8101B · Checking Account                                              -727.75


           2 · Testing Supplies                               -289.00             289.00
           2 · Testing Supplies                               -438.75             438.75
TOTAL                                                         -727.75             727.75




           8101B · Checking Account                                               -47.00


           0331 · Legal Services                               -47.00              47.00
TOTAL                                                          -47.00              47.00




           8101B · Checking Account                                               -64.18


           0339 · Fire Alarm Monitoring                        -64.18              64.18
TOTAL                                                          -64.18              64.18




           8101B · Checking Account                                               -15.00


           0580 · Travel, Registration & Entrance              -15.00              15.00
TOTAL                                                          -15.00              15.00




           8101B · Checking Account                                              -450.00


           0323 · Tutoring                                    -450.00             450.00
TOTAL                                                         -450.00             450.00




           8101B · Checking Account                                              -293.48


           0690 · Supplies - Other                            -293.48             293.48
TOTAL                                                         -293.48             293.48




                                                                                           Page 17 of 22
9:56 PM                                            Early College High Schools, Inc.
08/20/12
                                                           Check Detail
                              Account
                                                               June 2012
                                                             Paid Amount     Original Amount




           8101B · Checking Account                                                    -51.00


           0690 · Supplies - Other                                 -51.00               51.00
TOTAL                                                              -51.00               51.00




           8101B · Checking Account                                                   -499.06


           0550 · Printing, Binding, Duplicating                  -210.00              210.00
           0550 · Printing, Binding, Duplicating                  -289.06              289.06
TOTAL                                                             -499.06              499.06




           8101B · Checking Account                                                    -85.00


           0810 · Dues & Fees                                      -85.00               85.00
TOTAL                                                              -85.00               85.00




           8101B · Checking Account                                                  -2,865.00


           0521 · Philadelphia                                   -1,432.50           1,432.50
           8181 · Prepaid Expenses                               -1,432.50           1,432.50
TOTAL                                                            -2,865.00           2,865.00




           8101B · Checking Account                                                   -599.00


           0526 · Worker's Compensation Insurance                 -599.00              599.00
TOTAL                                                             -599.00              599.00




           8101B · Checking Account                                                  -3,204.47


           0630 · On-Site Meals                                  -3,204.47           3,204.47
TOTAL                                                            -3,204.47           3,204.47




           8101B · Checking Account                                                   -289.00


           0430 · Repairs & Maintenance                           -289.00              289.00
TOTAL                                                             -289.00              289.00




                                                                                                 Page 18 of 22
9:56 PM                                 Early College High Schools, Inc.
08/20/12
                                                Check Detail
                              Account
                                                    June 2012
                                                  Paid Amount    Original Amount




           8101B · Checking Account                                       -210.00


           0340 · Payroll Services                     -105.00             105.00
           0340 · Payroll Services                     -105.00             105.00
TOTAL                                                  -210.00             210.00




           8101B · Checking Account                                       -404.00


           0252 · Dental Insurance                      -26.16              26.16
           0252 · Dental Insurance                      -26.16              26.16
           0252 · Dental Insurance                      -26.16              26.16
           0252 · Dental Insurance                      -26.16              26.16
           0252 · Dental Insurance                      -26.16              26.16
           0252 · Dental Insurance                      -26.16              26.16
           0252 · Dental Insurance                      -26.16              26.16
           0252 · Dental Insurance                      -26.16              26.16
           0252 · Dental Insurance                      -26.16              26.16
           0252 · Dental Insurance                      -26.16              26.16
           7471D · Dental                               -60.33              60.33
           7471D · Dental                               -29.75              29.75
           0252 · Dental Insurance                      -26.16              26.16
           0252 · Dental Insurance                      -26.16              26.16
TOTAL                                                  -404.00             404.00




           8101B · Checking Account                                      -5,276.41


           7471H · Health                              -520.71             520.71
           0251 · Health Insurance                     -254.00             254.00
           0251 · Health Insurance                     -319.96             319.96
           0251 · Health Insurance                     -254.00             254.00
           0251 · Health Insurance                     -243.97             243.97
           0251 · Health Insurance                     -279.97             279.97
           0251 · Health Insurance                     -499.98             499.98
           0251 · Health Insurance                     -279.97             279.97
           0251 · Health Insurance                     -499.98             499.98
           0251 · Health Insurance                     -254.00             254.00
           0251 · Health Insurance                     -207.97             207.97
           0251 · Health Insurance                     -199.98             199.98
           7471H · Health                              -499.97             499.97
           0251 · Health Insurance                     -499.98             499.98
           0251 · Health Insurance                     -207.97             207.97




                                                                                     Page 19 of 22
9:56 PM                                           Early College High Schools, Inc.
08/20/12
                                                          Check Detail
                              Account
                                                              June 2012
                                                            Paid Amount     Original Amount

           0251 · Health Insurance                               -254.00              254.00
TOTAL                                                           -5,276.41           5,276.41




           8101B · Checking Account                                                -20,285.34


           0441 · Building Rental                              -19,000.00          19,000.00
           0522 · Property / Building Insurance                  -785.34              785.34
           8191a · Security Deposit                              -500.00              500.00
TOTAL                                                          -20,285.34          20,285.34




           8101B · Checking Account                                                 -8,000.00


           0900 · Loan Payment (Tatonka Loan)                   -8,000.00           8,000.00
TOTAL                                                           -8,000.00           8,000.00




           8101B · Checking Account                                                     0.00


TOTAL                                                               0.00                0.00




           8101B · Checking Account                                                 -1,640.00


           0552 · UCD Tuition                                   -1,640.00           1,640.00
TOTAL                                                           -1,640.00           1,640.00




           8101B · Checking Account                                                 -1,700.00


           0332 · Audit / Accounting Services                   -1,700.00           1,700.00
TOTAL                                                           -1,700.00           1,700.00




           8101C · Sooper Credit Union                                                 -26.00


           1600 · Student Lunches                                  -26.00              26.00
TOTAL                                                              -26.00              26.00




           8101C · Sooper Credit Union                                               -450.00


           0430 · Repairs & Maintenance                          -450.00              450.00
TOTAL                                                            -450.00              450.00




                                                                                                Page 20 of 22
9:56 PM                                      Early College High Schools, Inc.
08/20/12
                                                     Check Detail
                             Account
                                                         June 2012
                                                       Paid Amount     Original Amount




           8101C · Sooper Credit Union                                           -46.52


           0612 · Office Supplies                            -46.52               46.52
TOTAL                                                        -46.52               46.52




           8101C · Sooper Credit Union                                         -1,250.00


           0552 · UCD Tuition                               -800.00              800.00
           0552 · UCD Tuition                               -450.00              450.00
TOTAL                                                      -1,250.00           1,250.00




           8101C · Sooper Credit Union                                          -150.00


           0424 · Outdoor Maintenance                       -150.00              150.00
TOTAL                                                       -150.00              150.00




           8101C · Sooper Credit Union                                          -150.00


           0424 · Outdoor Maintenance                       -150.00              150.00
TOTAL                                                       -150.00              150.00




           8101C · Sooper Credit Union                                           -18.20


           0533 · Postage, Mailing Service                   -18.20               18.20
TOTAL                                                        -18.20               18.20




           8101C · Sooper Credit Union                                           -30.00


           0690 · Supplies - Other                           -30.00               30.00
TOTAL                                                        -30.00               30.00




           8101C · Sooper Credit Union                                          -110.00


           0424 · Outdoor Maintenance                       -110.00              110.00
TOTAL                                                       -110.00              110.00




                                                                                           Page 21 of 22
9:56 PM                                    Early College High Schools, Inc.
08/20/12
                                                   Check Detail
                             Account
                                                       June 2012
                                                     Paid Amount    Original Amount

           8101C · Sooper Credit Union                                       -886.16


           0338 · Networking Services T1                  -439.78             439.78
           0338 · Networking Services T1                  -446.38             446.38
TOTAL                                                     -886.16             886.16




                                                                                       Page 22 of 22

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:11/16/2012
language:English
pages:22