QuickBooks Export Tips - Bluehost.com by lanyuehua

VIEWS: 12 PAGES: 8

									                                                         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 yo
          the new worksheet is placed in front of the last active sheet where it will be named "SheetX" using the next available


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 data
                      >> 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 link
         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 Invent
                                 You might have moved or deleted accounts from accounts list which gets used in a report lik
                      >> You are using a report related to accounts and have account(s) with no activity associated and did no
                                 TIP: Choose display All rows (available for most of the reports), Select Modify report->Displa
                      >> Deleted exported data sheet which serves as data source.
ckBooks data


orted data goes to Sheet 1. When you export to an existing workbook,
med "SheetX" using the next available number in the series.


 final workbook?
e the instruction worksheet.



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

 port QuickBooks data. Then create another worksheet where you can
ource worksheet.
the current data so that the new data is used by any Excel links and formulas.
 nother worksheet in the workbook.



 rt that you used when setting up links, can cause mismatch
ed worksheet, then you may have:
ort in some way? For example:
 hich gets used in a report like Inventory Valuation report.
nts list which gets used in a report like Profit and Loss standard report.
 with no activity associated and did not choose to display "All rows".
eports), Select Modify report->Display->Advanced->Display Rows->All rows
10:54 PM                         McNeil High School Track & XC Booster Club
05/05/10
Accrual Basis                                         Profit & Loss
                                             August 1, 2009 through May 6, 2010

                                              McNeil High School Track & XC Booster Club
                                             Cash Flow Statement     2009-2010 School Year
                                                          As of May 6, 2010


                                                          Aug 1, '09 - Apr 6, 10       Aug 1, '09 - Apr 6, 10
                                                                   Actual                     Budget


        Cash In
            Club Dues                                                        740.00                      0.00
            Consession Sales
                  Mav Relays                                                3,561.21                     0.00
                  MS Meet                                                   3,170.37                     0.00
                  XC Meet                                                   1,981.60                     0.00
            Donations                                                       6,630.00                     0.00
            Interest Income                                                    0.57                      0.00
            T-Shirt Sales
                  MS Track                                                  1,267.00                     0.00
                  T-Shirt Sales - Other                                      140.00                      0.00
            Uniform Income
                  Girls Sweats                                              2,626.00                     0.00
            Yard Signs Sales                                                  14.00                      0.00

        Total Cash In                                                   20,130.75                        0.00


        Cash Out
            Bank Service Charge                                                -0.03                     0.00
                  XC                                                         182.95                      0.00
            Consession Equipment                                             430.51                      0.00
            Consession Supplies
                  Mav Relays                                                1,706.93                     0.00
                  MS Meet                                                   2,181.57                     0.00
                  XC Meet                                                   1,084.70                     0.00
            Facilities and Equipment                                         119.01                      0.00
            Meet Officials                                                  1,950.00                     0.00
            Operations
                  Books, Subscriptions, Reference                             35.00                      0.00
                  Postage, Mailing Service                                    58.00                      0.00
                  Web Service                                                137.30                      0.00
            T-Shirt Expense
                  MS Track Meet                                              635.25                      0.00
                  T-Shirt Expense - Other                                    733.88                      0.00
            Uniforms
                  Boys Sweats                                               1,598.88                     0.00
                  Girls Sweats                                              2,760.65                     0.00
            Yard Signs                                                       324.75                      0.00
        Total Cash Out                                                  13,939.35                        0.00


    Net Cash In/(Out)                                                       6,191.40                     0.00




                                                                                                                Page 3 of 8
         10:54 PM                         McNeil High School Track & XC Booster Club
         05/05/10
         Accrual Basis                                         Profit & Loss
                                                      August 1, 2009 through May 6, 2010

McNeil High School Track & XC Booster Club             McNeil High School Track & XC Booster Club
Cash Flow Statement   2009-2010 School Year           Cash Flow Statement    2009-2010 School Year
            As of May 6, 2010                                      As of May 6, 2010


                                                                   Aug 1, '09 - Apr 6, 10
                                                                         Variance


                 Cash In
                      Club Dues                                                     740.00
                      Consession Sales
                           Mav Relays                                            3,561.21
                           MS Meet                                               3,170.37
                           XC Meet                                               1,981.60
                      Donations                                                  6,630.00
                      Interest Income                                                 0.57
                      T-Shirt Sales
                           MS Track                                              1,267.00
                           T-Shirt Sales - Other                                    140.00
                      Uniform Income
                           Girls Sweats                                          2,626.00
                      Yard Signs Sales                                               14.00

                 Total Cash In                                                  20,130.75


                 Cash Out
                      Bank Service Charge                                            -0.03
                           XC                                                       182.95
                      Consession Equipment                                          430.51
                      Consession Supplies
                           Mav Relays                                            1,706.93
                           MS Meet                                               2,181.57
                           XC Meet                                               1,084.70
                      Facilities and Equipment                                      119.01
                      Meet Officials                                             1,950.00
                      Operations
                           Books, Subscriptions, Reference                           35.00
                           Postage, Mailing Service                                  58.00
                           Web Service                                              137.30
                      T-Shirt Expense
                           MS Track Meet                                            635.25
                           T-Shirt Expense - Other                                  733.88
                      Uniforms
                           Boys Sweats                                           1,598.88
                           Girls Sweats                                          2,760.65
                      Yard Signs                                                    324.75
                 Total Cash Out                                                 13,939.35


             Net Cash In/(Out)                                                   6,191.40




                                                                                                     Page 4 of 8
                                        McNeil High School Track & XC Booster Club
                                    Cash Flow Statement        2009-2010 School Year
                                                    As of April 6, 2010


                                              Aug 1, '09 - Apr 6, 10      Aug 1, '09 - Apr 6, 10    Aug 1, '09 - Apr 6, 10
                                                     Actual                      Budget                   Variance


    Cash In
        Club Dues                                              720.00                        0.00                    720.00
        Consession Sales
              Mav Relays                                      3,561.21                       0.00                  3,561.21
           XC Meet                                            1,981.60                       0.00                  1,981.60
        Donations                                             6,630.00                       0.00                  6,630.00
        Interest Income                                          0.45                        0.00                      0.45
        T-Shirt Sales                                          110.00                        0.00                    110.00
        Uniform Income
              Girls Sweats                                    2,626.00                       0.00                  2,626.00


    Total Cash In                                          15,629.26                         0.00                 15,629.26


    Cash Out
        Bank Service Charge                                      -0.03                       0.00                     -0.03
        Banquet Expense
              XC                                               182.95                        0.00                    182.95
        Consession Equipment                                   430.51                        0.00                    430.51
        Consession Supplies
              Mav Relays                                      1,706.93                       0.00                  1,706.93
              XC Meet                                         1,084.70                       0.00                  1,084.70
        Facilities and Equipment                               119.01                        0.00                    119.01
        Meet Officials                                        1,950.00                       0.00                  1,950.00
        Operations
              Postage, Mailing Service                          58.00                        0.00                     58.00
              Web Service                                      137.30                        0.00                    137.30
        Other Expense                                            0.00                        0.00                      0.00
        T-Shirt Expense
              MS Track Meet                                    635.25                        0.00                    635.25
              T-Shirt Expense - Other                          733.88                        0.00                    733.88
        Uniforms
              Boys Sweats                                     1,598.88                       0.00                  1,598.88
              Girls Sweats                                    2,760.65                       0.00                  2,760.65
        Yard Signs                                             324.75                        0.00                    324.75
    Total Cash Out                                         11,722.78                         0.00                 11,722.78


Net Cash In/(Out)                                             3,906.48                       0.00                  3,906.48




                                                                                                                     Page 5 of 8
                              McNeil High School Track & XC Booster Club
                              Cash Flow Statement     2009-2010 School Year
                                        As of February 10, 2010


                                 Aug 1, '09 - Jan 19, 10       Aug 1, '09 - Jan 19, 10    Aug 1, '09 - Jan 19, 10
                                         Actual                       Budget                    Variance


   Cash In
       Club Dues                                   560.00                          0.00                    560.00
       Consession Sales                           1,981.60                         0.00                  1,981.60
       Donations                                  6,630.00                         0.00                  6,630.00
       Interest Income                               0.39                          0.00                       0.39
       Uniform Income                             2,273.00                         0.00                  2,273.00
   Total Cash In                               11,444.99                           0.00                 11,444.99


   Cash Out
       Bank Service Charge                           -0.03                         0.00                      -0.03
       Banquet Expense                             182.95                          0.00                    182.95
       Consession Equipment                        430.51                          0.00                    430.51
       Consession Supplies                        1,084.70                         0.00                  1,084.70
       T-Shirt Expense                             808.88                          0.00                    808.88
       Uniforms                                   1,598.88                         0.00                  1,598.88
   Total Cash Out                                 4,105.89                         0.00                  4,105.89


Net Cash                                          7,339.10                         0.00                  7,339.10




                                                                                                             Page 6 of 8
                              McNeil High School Track & XC Booster Club
                              Cash Flow Statement      2009-2010 School Year
                                         As of January 19, 2010


                                  Aug 1, '09 - Jan 19, 10      Aug 1, '09 - Jan 19, 10    Aug 1, '09 - Jan 19, 10
                                          Actual                      Budget                    Variance




   Cash In
       Club Dues                                    380.00                         0.00                    380.00
       Consession Sales                            1,981.60                        0.00                  1,981.60
       Donations                                   6,610.00                        0.00                  6,610.00
       T-Shirt Sales                                  0.00                         0.00                       0.00
       Interest Income                                0.33                         0.00                       0.33
   Total Cash In                                   8,971.93                        0.00                  8,971.93


   Cash Out
       Bank Service Charge                            -0.03                        0.00                       0.03
       Banquet Expense                              182.95                         0.00                    -182.95
       Consession Equipment                         430.51                         0.00                    -430.51
       Consession Supplies                         1,084.70                        0.00                 -1,084.70
       T-Shirt Expense                              808.88                         0.00                    -808.88
       Uniforms                                    1,598.88                        0.00                 -1,598.88
   Total Cash Out                                  4,105.89                        0.00                 -4,105.89


Net Cash                                           4,866.04                        0.00                  4,866.04




                                                                                                               Page 7 of 8
7:38 PM                         McNeil High School Track & XC Booster Club
11/17/09
Accrual Basis                                    Profit & Loss
                                      August 1 through November 17, 2009

                                      Aug 1 - Nov 17, 09
    Ordinary Income/Expense
        Income
             Club Dues                            380.00
             Consession Sales                   1,981.60
             Donations                          6,610.00
             Interest Income                        0.13
        Total Income                            8,971.73


        Expense
             Bank Service Charge                    -0.03
             Consession Equipment                 430.51
             Consession Supplies                1,139.23
             Uniforms                           1,598.88
        Total Expense                           3,168.59


    Net Ordinary Income                         5,803.14


Net Income                                      5,803.14




                                                                             Page 8 of 8

								
To top