Docstoc

Quickbooks Profit and Loss Account - Excel

Document Sample
Quickbooks Profit and Loss Account - Excel 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 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->Diplay row->All rows
9:40 AM                                     AAHAM Virginia Chapter
11/10/08
Cash Basis                                  Profit & Loss by Class
                                         January 1 through November 10, 2008

                                             Professional Certification      Technical Certification
                                             (Certification Committee)      (Certification Committee)
   Income
       Community Service                                             0.00                          0.00
       Interest Income                                               0.00                          0.00
       Membership Dues
             Chapter Dues - National                                 0.00                          0.00
             Chapter Dues - State Only                               0.00                          0.00
       Total Membership Dues                                         0.00                          0.00


       National Sales
             Technical Exam Fees                                     0.00                      1,390.00
       Total National Sales                                          0.00                      1,390.00


       Registration Fees                                             0.00                          0.00
       Sponsorship                                                   0.00                          0.00
       Vendor booths                                                 0.00                          0.00
   Total Income                                                      0.00                      1,390.00


   Expense
       ANI Registration                                              0.00                          0.00
       Bank Charges                                                  0.00                          0.00
       Board Meetings                                                0.00                          0.00
       Bond Insurance                                                0.00                          0.00
       Community Service Donations                                   0.00                          0.00
       Door Prizes                                                   0.00                          0.00
       Entertainment                                                 0.00                          0.00
       Meeting Facility Charges                                      0.00                          0.00
       Member Gifts                                                  0.00                          0.00
       Postage                                                       0.00                          0.00
       Printing                                                      0.00                          0.00
       Refund Examination Fees                                    875.00                           0.00
       Registration fees - Legislativ                                0.00                          0.00
       Scholorship                                                   0.00                          0.00
       Speakers                                                      0.00                          0.00
       Supplies                                                 1,615.66                           0.00
       Teleconference                                             204.77                          13.83
       Travel
             Hotel                                                   0.00                          0.00
             Meals                                                   0.00                          0.00
             Transportation                                          0.00                          0.00
       Total Travel                                                  0.00                          0.00


   Total Expense                                                2,695.43                          13.83


Net Income                                                      -2,695.43                      1,376.17




                                                                                                          Page 3 of 12
9:40 AM                                     AAHAM Virginia Chapter
11/10/08
Cash Basis                                  Profit & Loss by Class
                                         January 1 through November 10, 2008


                                             Total Certification Committee     Chapter Excellence Committee
   Income
       Community Service                                                0.00                             0.00
       Interest Income                                                  0.00                             0.00
       Membership Dues
             Chapter Dues - National                                    0.00                             0.00
             Chapter Dues - State Only                                  0.00                             0.00
       Total Membership Dues                                            0.00                             0.00


       National Sales
             Technical Exam Fees                                    1,390.00                             0.00
       Total National Sales                                         1,390.00                             0.00


       Registration Fees                                                0.00                             0.00
       Sponsorship                                                      0.00                             0.00
       Vendor booths                                                    0.00                             0.00
   Total Income                                                     1,390.00                             0.00


   Expense
       ANI Registration                                                 0.00                             0.00
       Bank Charges                                                     0.00                             0.00
       Board Meetings                                                   0.00                             0.00
       Bond Insurance                                                   0.00                             0.00
       Community Service Donations                                      0.00                             0.00
       Door Prizes                                                      0.00                             0.00
       Entertainment                                                    0.00                             0.00
       Meeting Facility Charges                                         0.00                             0.00
       Member Gifts                                                     0.00                             0.00
       Postage                                                          0.00                             5.49
       Printing                                                         0.00                             0.00
       Refund Examination Fees                                        875.00                             0.00
       Registration fees - Legislativ                                   0.00                             0.00
       Scholorship                                                      0.00                             0.00
       Speakers                                                         0.00                             0.00
       Supplies                                                     1,615.66                           118.08
       Teleconference                                                 218.60                             6.50
       Travel
             Hotel                                                      0.00                             0.00
             Meals                                                      0.00                             0.00
             Transportation                                             0.00                             0.00
       Total Travel                                                     0.00                             0.00


   Total Expense                                                    2,709.26                           130.07


Net Income                                                         -1,319.26                           -130.07




                                                                                                              Page 4 of 12
9:40 AM                                     AAHAM Virginia Chapter
11/10/08
Cash Basis                                  Profit & Loss by Class
                                         January 1 through November 10, 2008


                                              Community Service Committee      Corporate Partners Committee
   Income
       Community Service                                              87.00                               0.00
       Interest Income                                                  0.00                              0.00
       Membership Dues
             Chapter Dues - National                                    0.00                              0.00
             Chapter Dues - State Only                                  0.00                              0.00
       Total Membership Dues                                            0.00                              0.00


       National Sales
             Technical Exam Fees                                        0.00                              0.00
       Total National Sales                                             0.00                              0.00


       Registration Fees                                                0.00                              0.00
       Sponsorship                                                      0.00                         10,900.00
       Vendor booths                                                    0.00                              0.00
   Total Income                                                       87.00                          10,900.00


   Expense
       ANI Registration                                                 0.00                              0.00
       Bank Charges                                                     0.00                              0.00
       Board Meetings                                                   0.00                              0.00
       Bond Insurance                                                   0.00                              0.00
       Community Service Donations                                    87.00                               0.00
       Door Prizes                                                      0.00                              0.00
       Entertainment                                                    0.00                              0.00
       Meeting Facility Charges                                         0.00                              0.00
       Member Gifts                                                     0.00                              0.00
       Postage                                                          0.00                              0.00
       Printing                                                         0.00                              0.00
       Refund Examination Fees                                          0.00                              0.00
       Registration fees - Legislativ                                   0.00                              0.00
       Scholorship                                                      0.00                              0.00
       Speakers                                                         0.00                              0.00
       Supplies                                                         0.00                              0.00
       Teleconference                                                   0.00                              0.00
       Travel
             Hotel                                                      0.00                              0.00
             Meals                                                      0.00                              0.00
             Transportation                                             0.00                              0.00
       Total Travel                                                     0.00                              0.00


   Total Expense                                                      87.00                               0.00


Net Income                                                              0.00                         10,900.00




                                                                                                        Page 5 of 12
9:40 AM                                     AAHAM Virginia Chapter
11/10/08
Cash Basis                                  Profit & Loss by Class
                                         January 1 through November 10, 2008

                                              Charlottesville 2008         Richmond 2008
                                             (Education Committee)      (Education Committee)
   Income
       Community Service                                         0.00                       0.00
       Interest Income                                           0.00                       0.00
       Membership Dues
             Chapter Dues - National                             0.00                       0.00
             Chapter Dues - State Only                           0.00                       0.00
       Total Membership Dues                                     0.00                       0.00


       National Sales
             Technical Exam Fees                                 0.00                       0.00
       Total National Sales                                      0.00                       0.00


       Registration Fees                                     4,530.00                       0.00
       Sponsorship                                           2,800.00                       0.00
       Vendor booths                                             0.00                       0.00
   Total Income                                              7,330.00                       0.00


   Expense
       ANI Registration                                          0.00                       0.00
       Bank Charges                                              0.00                       0.00
       Board Meetings                                            0.00                       0.00
       Bond Insurance                                            0.00                       0.00
       Community Service Donations                               0.00                       0.00
       Door Prizes                                             214.79                       0.00
       Entertainment                                             0.00                       0.00
       Meeting Facility Charges                              3,561.60                      75.00
       Member Gifts                                              0.00                       0.00
       Postage                                                   0.00                       0.00
       Printing                                                  0.00                       0.00
       Refund Examination Fees                                   0.00                       0.00
       Registration fees - Legislativ                            0.00                       0.00
       Scholorship                                               0.00                       0.00
       Speakers                                                  0.00                       0.00
       Supplies                                                  0.00                       0.00
       Teleconference                                            0.00                       0.00
       Travel
             Hotel                                               0.00                       0.00
             Meals                                               0.00                       0.00
             Transportation                                      0.00                       0.00
       Total Travel                                              0.00                       0.00


   Total Expense                                             3,776.39                      75.00


Net Income                                                   3,553.61                    -75.00




                                                                                                   Page 6 of 12
9:40 AM                                     AAHAM Virginia Chapter
11/10/08
Cash Basis                                  Profit & Loss by Class
                                         January 1 through November 10, 2008

                                              Virginia Beach 2008       Virginia Beach 2009
                                             (Education Committee)     (Education Committee)
   Income
       Community Service                                        0.00                      0.00
       Interest Income                                          0.00                      0.00
       Membership Dues
             Chapter Dues - National                            0.00                      0.00
             Chapter Dues - State Only                          0.00                      0.00
       Total Membership Dues                                    0.00                      0.00


       National Sales
             Technical Exam Fees                                0.00                      0.00
       Total National Sales                                     0.00                      0.00


       Registration Fees                                    5,565.00                      0.00
       Sponsorship                                            550.00                      0.00
       Vendor booths                                          800.00                      0.00
   Total Income                                             6,915.00                      0.00


   Expense
       ANI Registration                                         0.00                      0.00
       Bank Charges                                             0.00                      0.00
       Board Meetings                                           0.00                      0.00
       Bond Insurance                                           0.00                      0.00
       Community Service Donations                              0.00                      0.00
       Door Prizes                                            448.42                      0.00
       Entertainment                                            0.00                      0.00
       Meeting Facility Charges                             7,993.02                    500.00
       Member Gifts                                             0.00                      0.00
       Postage                                                  0.00                      0.00
       Printing                                                 0.00                      0.00
       Refund Examination Fees                                  0.00                      0.00
       Registration fees - Legislativ                           0.00                      0.00
       Scholorship                                              0.00                      0.00
       Speakers                                             1,710.46                      0.00
       Supplies                                               131.68                      0.00
       Teleconference                                           0.00                      0.00
       Travel
             Hotel                                              0.00                      0.00
             Meals                                              0.00                      0.00
             Transportation                                     0.00                      0.00
       Total Travel                                             0.00                      0.00


   Total Expense                                           10,283.58                    500.00


Net Income                                                 -3,368.58                   -500.00




                                                                                                 Page 7 of 12
9:40 AM                                     AAHAM Virginia Chapter
11/10/08
Cash Basis                                  Profit & Loss by Class
                                         January 1 through November 10, 2008

                                             Warrenton Meeting 2008       Williamsburg 2007
                                             (Education Committee)      (Education Committee)
   Income
       Community Service                                         0.00                         0.00
       Interest Income                                           0.00                         0.00
       Membership Dues
             Chapter Dues - National                             0.00                         0.00
             Chapter Dues - State Only                           0.00                         0.00
       Total Membership Dues                                     0.00                         0.00


       National Sales
             Technical Exam Fees                                 0.00                         0.00
       Total National Sales                                      0.00                         0.00


       Registration Fees                                     5,345.00                   410.00
       Sponsorship                                            800.00                          0.00
       Vendor booths                                             0.00                         0.00
   Total Income                                              6,145.00                   410.00


   Expense
       ANI Registration                                          0.00                         0.00
       Bank Charges                                              0.00                         0.00
       Board Meetings                                            0.00                         0.00
       Bond Insurance                                            0.00                         0.00
       Community Service Donations                               0.00                         0.00
       Door Prizes                                            200.00                          0.00
       Entertainment                                             0.00                   157.50
       Meeting Facility Charges                                  0.00                         0.00
       Member Gifts                                              0.00                         0.00
       Postage                                                   0.00                         0.00
       Printing                                               122.33                          0.00
       Refund Examination Fees                                   0.00                         0.00
       Registration fees - Legislativ                            0.00                         0.00
       Scholorship                                               0.00                         0.00
       Speakers                                                  0.00                   325.00
       Supplies                                                  0.00                    83.92
       Teleconference                                           42.15                         0.00
       Travel
             Hotel                                               0.00                         0.00
             Meals                                               0.00                         0.00
             Transportation                                      0.00                   247.35
       Total Travel                                              0.00                   247.35


   Total Expense                                              364.48                    813.77


Net Income                                                   5,780.52                   -403.77




                                                                                                     Page 8 of 12
9:40 AM                                     AAHAM Virginia Chapter
11/10/08
Cash Basis                                  Profit & Loss by Class
                                         January 1 through November 10, 2008

                                               Willimasburg 2008
                                             (Education Committee)        Total Education Committee
   Income
       Community Service                                           0.00                          0.00
       Interest Income                                             0.00                          0.00
       Membership Dues
             Chapter Dues - National                               0.00                          0.00
             Chapter Dues - State Only                             0.00                          0.00
       Total Membership Dues                                       0.00                          0.00


       National Sales
             Technical Exam Fees                                   0.00                          0.00
       Total National Sales                                        0.00                          0.00


       Registration Fees                                           0.00                     15,850.00
       Sponsorship                                          4,650.00                         8,800.00
       Vendor booths                                               0.00                        800.00
   Total Income                                             4,650.00                        25,450.00


   Expense
       ANI Registration                                            0.00                          0.00
       Bank Charges                                                0.00                          0.00
       Board Meetings                                              0.00                          0.00
       Bond Insurance                                              0.00                          0.00
       Community Service Donations                                 0.00                          0.00
       Door Prizes                                                 0.00                        863.21
       Entertainment                                        1,425.00                         1,582.50
       Meeting Facility Charges                                    0.00                     12,129.62
       Member Gifts                                                0.00                          0.00
       Postage                                                     0.00                          0.00
       Printing                                                    0.00                        122.33
       Refund Examination Fees                                     0.00                          0.00
       Registration fees - Legislativ                              0.00                          0.00
       Scholorship                                                 0.00                          0.00
       Speakers                                                    0.00                      2,035.46
       Supplies                                                    0.00                        215.60
       Teleconference                                              0.00                         42.15
       Travel
             Hotel                                                 0.00                          0.00
             Meals                                                 0.00                          0.00
             Transportation                                        0.00                        247.35
       Total Travel                                                0.00                        247.35


   Total Expense                                            1,425.00                        17,238.22


Net Income                                                  3,225.00                         8,211.78




                                                                                                        Page 9 of 12
9:40 AM                                     AAHAM Virginia Chapter
11/10/08
Cash Basis                                  Profit & Loss by Class
                                         January 1 through November 10, 2008


                                             Executive Board Committee      Finance Committee
   Income
       Community Service                                            0.00                  0.00
       Interest Income                                              0.00               1,084.62
       Membership Dues
             Chapter Dues - National                                0.00                  0.00
             Chapter Dues - State Only                              0.00                  0.00
       Total Membership Dues                                        0.00                  0.00


       National Sales
             Technical Exam Fees                                    0.00                  0.00
       Total National Sales                                         0.00                  0.00


       Registration Fees                                         -175.00                  0.00
       Sponsorship                                                  0.00                  0.00
       Vendor booths                                                0.00                  0.00
   Total Income                                                  -175.00               1,084.62


   Expense
       ANI Registration                                           690.00                  0.00
       Bank Charges                                                 0.00                 40.00
       Board Meetings                                             178.55                  0.00
       Bond Insurance                                               0.00                199.00
       Community Service Donations                                  0.00                  0.00
       Door Prizes                                                  0.00                  0.00
       Entertainment                                                0.00                  0.00
       Meeting Facility Charges                                     0.00                  0.00
       Member Gifts                                                82.50                  0.00
       Postage                                                      0.00                  0.00
       Printing                                                     0.00                  0.00
       Refund Examination Fees                                      0.00                  0.00
       Registration fees - Legislativ                               0.00                  0.00
       Scholorship                                                  0.00                  0.00
       Speakers                                                     0.00                  0.00
       Supplies                                                     0.00                  0.00
       Teleconference                                             248.52                  5.84
       Travel
             Hotel                                              3,576.20                  0.00
             Meals                                                520.75                  0.00
             Transportation                                     1,461.78                  0.00
       Total Travel                                             5,558.73                  0.00


   Total Expense                                                6,758.30                244.84


Net Income                                                      -6,933.30               839.78




                                                                                                  Page 10 of 12
9:40 AM                                     AAHAM Virginia Chapter
11/10/08
Cash Basis                                  Profit & Loss by Class
                                         January 1 through November 10, 2008


                                              Government Relations Committee      Membership Committee
   Income
       Community Service                                                   0.00                     0.00
       Interest Income                                                     0.00                     0.00
       Membership Dues
             Chapter Dues - National                                       0.00                  2,460.00
             Chapter Dues - State Only                                     0.00                   905.00
       Total Membership Dues                                               0.00                  3,365.00


       National Sales
             Technical Exam Fees                                           0.00                     0.00
       Total National Sales                                                0.00                     0.00


       Registration Fees                                                   0.00                     0.00
       Sponsorship                                                         0.00                     0.00
       Vendor booths                                                       0.00                     0.00
   Total Income                                                            0.00                  3,365.00


   Expense
       ANI Registration                                                    0.00                     0.00
       Bank Charges                                                        0.00                     0.00
       Board Meetings                                                      0.00                     0.00
       Bond Insurance                                                      0.00                     0.00
       Community Service Donations                                         0.00                     0.00
       Door Prizes                                                         0.00                     0.00
       Entertainment                                                       0.00                     0.00
       Meeting Facility Charges                                            0.00                     0.00
       Member Gifts                                                        0.00                   267.14
       Postage                                                             0.00                     0.00
       Printing                                                            0.00                     0.00
       Refund Examination Fees                                             0.00                     0.00
       Registration fees - Legislativ                                    229.00                     0.00
       Scholorship                                                         0.00                     0.00
       Speakers                                                            0.00                     0.00
       Supplies                                                            0.00                    48.01
       Teleconference                                                      0.00                    21.85
       Travel
             Hotel                                                         0.00                     0.00
             Meals                                                        22.04                     0.00
             Transportation                                               86.99                     0.00
       Total Travel                                                      109.03                     0.00


   Total Expense                                                         338.03                   337.00


Net Income                                                              -338.03                  3,028.00




                                                                                                         Page 11 of 12
9:40 AM                                     AAHAM Virginia Chapter
11/10/08
Cash Basis                                  Profit & Loss by Class
                                         January 1 through November 10, 2008


                                             Newsletter Committee     Scholorship Committee     TOTAL
   Income
       Community Service                                       0.00                      0.00      87.00
       Interest Income                                         0.00                      0.00    1,084.62
       Membership Dues
             Chapter Dues - National                           0.00                      0.00    2,460.00
             Chapter Dues - State Only                         0.00                      0.00     905.00
       Total Membership Dues                                   0.00                      0.00    3,365.00


       National Sales
             Technical Exam Fees                               0.00                      0.00    1,390.00
       Total National Sales                                    0.00                      0.00    1,390.00


       Registration Fees                                       0.00                      0.00   15,675.00
       Sponsorship                                             0.00                      0.00   19,700.00
       Vendor booths                                           0.00                      0.00     800.00
   Total Income                                                0.00                      0.00   42,101.62


   Expense
       ANI Registration                                        0.00                      0.00     690.00
       Bank Charges                                            0.00                      0.00      40.00
       Board Meetings                                          0.00                      0.00     178.55
       Bond Insurance                                          0.00                      0.00     199.00
       Community Service Donations                             0.00                      0.00      87.00
       Door Prizes                                             0.00                      0.00     863.21
       Entertainment                                           0.00                      0.00    1,582.50
       Meeting Facility Charges                                0.00                      0.00   12,129.62
       Member Gifts                                            0.00                      0.00     349.64
       Postage                                                 0.00                      0.00        5.49
       Printing                                                0.00                      0.00     122.33
       Refund Examination Fees                                 0.00                      0.00     875.00
       Registration fees - Legislativ                          0.00                      0.00     229.00
       Scholorship                                             0.00                  1,000.00    1,000.00
       Speakers                                                0.00                      0.00    2,035.46
       Supplies                                                0.00                      0.00    1,997.35
       Teleconference                                         11.80                      0.00     555.26
       Travel
             Hotel                                             0.00                      0.00    3,576.20
             Meals                                             0.00                      0.00     542.79
             Transportation                                    0.00                      0.00    1,796.12
       Total Travel                                            0.00                      0.00    5,915.11


   Total Expense                                              11.80                  1,000.00   28,854.52


Net Income                                                   -11.80                 -1,000.00   13,247.10




                                                                                                      Page 12 of 12

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:28
posted:7/28/2011
language:English
pages:12
Description: Quickbooks Profit and Loss Account document sample