Docstoc

Profit and Loss Spreadsheet template

Document Sample
Profit and Loss Spreadsheet template 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->Diplay row->All rows
11:13 AM                               TowerSearch, LLC
10/02/07
Cash Basis                              Profit & Loss
                              Jan 08
                                          January 2007 Mar 08
                                            Feb 08                 Apr 08      May 08

Revenue
Gross Sales
Other Income
Affilliate Income
Advertising Income
Total Income                       0.00         0.00        0.00        0.00       0.00


Expense
Advertising
Credit Card Processing Fees
Bank Service Charges
Cost of Goods Sold [COGS]
Domain Fees
Dues & Subscriptions
Hosting
SEO & Programming
Office Suppies
Shipping & Handling
Photos
Research
Telephone
Travel & Ent
Miscellaneous
Total Expense                      0.00         0.00        0.00        0.00       0.00


Net Income                         0.00         0.00        0.00        0.00       0.00




                                                                                          Page 3 of 6
11:13 AM                               TowerSearch, LLC
10/02/07
Cash Basis                              Profit & Loss
                              Jun 08
                                          January 2007 Aug 08
                                            Jul 08                 Sep 08     Oct 08

Revenue
Gross Sales
Other Income
Affilliate Income
Advertising Income
Total Income                       0.00         0.00        0.00       0.00        0.00


Expense
Advertising
Credit Card Processing Fees
Bank Service Charges
Cost of Goods Sold [COGS]
Domain Fees
Dues & Subscriptions
Hosting
SEO & Programming
Office Suppies
Shipping & Handling
Photos
Research
Telephone
Travel & Ent
Miscellaneous
Total Expense                      0.00         0.00        0.00       0.00        0.00


Net Income                         0.00         0.00        0.00       0.00        0.00




                                                                                          Page 4 of 6
11:13 AM                               TowerSearch, LLC
10/02/07
Cash Basis                              Profit & Loss
                              Nov 08
                                          January 2007
                                            Dec 08        2008          Jan 09      Feb 09

Revenue
Gross Sales                                                      0.00
Other Income                                                     0.00
Affilliate Income                                                0.00
Advertising Income                                               0.00
Total Income                      0.00          0.00             0.00        0.00        0.00


Expense
Advertising                                                      0.00
Credit Card Processing Fees                                      0.00
Bank Service Charges                                             0.00
Cost of Goods Sold [COGS]                                        0.00
Domain Fees                                                      0.00
Dues & Subscriptions                                             0.00
Hosting                                                          0.00
SEO & Programming                                                0.00
Office Suppies                                                   0.00
Shipping & Handling                                              0.00
Photos                                                           0.00
Research                                                         0.00
Telephone                                                        0.00
Travel & Ent                                                     0.00
Miscellaneous                                                    0.00
Total Expense                     0.00          0.00             0.00        0.00        0.00


Net Income                        0.00          0.00             0.00        0.00        0.00




                                                                                        Page 5 of 6
11:13 AM                               TowerSearch, LLC
10/02/07
Cash Basis                              Profit & Loss
                              Mar 09
                                          January 2007 09
                                           Apr 09    May      Jun 09

Revenue
Gross Sales
Other Income
Affilliate Income
Advertising Income
Total Income                      0.00        0.00     0.00      0.00


Expense
Advertising
Credit Card Processing Fees
Bank Service Charges
Cost of Goods Sold [COGS]
Domain Fees
Dues & Subscriptions
Hosting
SEO & Programming
Office Suppies
Shipping & Handling
Photos
Research
Telephone
Travel & Ent
Miscellaneous
Total Expense                     0.00        0.00     0.00      0.00


Net Income                        0.00        0.00     0.00      0.00




                                                                        Page 6 of 6

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:39
posted:9/29/2011
language:English
pages:6