Docstoc

Bal Sheet DEC 07

Document Sample
Bal Sheet DEC 07 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
10:11 AM                                               AIA Nebraska
02/25/08
Accrual Basis                                         Balance Sheet
                                                    As of December 31, 2007
                                                          Dec 31, 07
ASSETS
   Current Assets
       Checking/Savings
            A. Current Assets
                  1110 Union Bank Chk 6034713               89,800.49
                  1112 Union Bank Savings 2946718            6,347.91
                  1114 Wells Fargo SA 2000773077             9,361.81
                  1120 First Nat'l CD 70004389127           79,534.02
                  1130 First Nat'l CD 70004389128           10,193.93
                  1140 Union Bank CD 403787                 53,770.80
                  1420 First Nat'l CD 70004389126           18,738.69
            Total A. Current Assets                        267,747.65


         Total Checking/Savings                            267,747.65


         Accounts Receivable
              1200 Accounts Receivable                       6,135.65
         Total Accounts Receivable                           6,135.65


         Other Current Assets
              1205 Inventory Asset                           7,100.64
         Total Other Current Assets                          7,100.64


    Total Current Assets                                   280,983.94


    Fixed Assets
         1599 Fixed Assets
              1600 Property & Equipment-Cost                 5,653.61
              1610 Accum Depreciation                       -8,221.00
         Total 1599 Fixed Assets                            -2,567.39


    Total Fixed Assets                                      -2,567.39


TOTAL ASSETS                                               278,416.55


LIABILITIES & EQUITY
    Liabilities
          Current Liabilities
                Other Current Liabilities
                    B. Current Liabilities
                          2100 Sales Tax Payable               103.02
                          2105 Prepaid Income                2,500.00
                          2130 State Withholding             1,579.55
                          2175 Income Tax Payable              475.00
                          2400 Deferred Revenue             15,348.00
                    Total B. Current Liabilities            20,005.57


               Total Other Current Liabilities              20,005.57


         Total Current Liabilities                          20,005.57


    Total Liabilities                                       20,005.57


    Equity
         2940 Retained Earnings                            229,188.19
         Net Income                                         29,222.79
    Total Equity                                           258,410.98


TOTAL LIABILITIES & EQUITY                                 278,416.55




                                                                              Page 3 of 4
3:04 PM                                                AIA Nebraska
01/03/08
Accrual Basis                                         Balance Sheet
                                                    As of December 31, 2007
                                                          Dec 31, 07
ASSETS
   Current Assets
       Checking/Savings
            A. Current Assets
                  1110 Union Bank Chk 6034713               89,420.49
                  1112 Union Bank Savings 2946718            6,347.91
                  1114 Wells Fargo SA 2000773077             9,359.82
                  1120 First Nat'l CD 70004389127           74,131.21
                  1130 First Nat'l CD 70004389128            5,000.00
                  1140 Union Bank CD 403787                 53,770.80
                  1420 First Nat'l CD 70004389126           17,958.96
            Total A. Current Assets                        255,989.19


         Total Checking/Savings                            255,989.19


         Accounts Receivable
              1200 Accounts Receivable                       6,470.91
         Total Accounts Receivable                           6,470.91


         Other Current Assets
              1205 Inventory Asset                          10,649.59
         Total Other Current Assets                         10,649.59


    Total Current Assets                                   273,109.69


    Fixed Assets
         1599 Fixed Assets
              1600 Property & Equipment-Cost                 5,653.61
              1610 Accum Depreciation                       -8,221.00
         Total 1599 Fixed Assets                            -2,567.39


    Total Fixed Assets                                      -2,567.39


TOTAL ASSETS                                               270,542.30


LIABILITIES & EQUITY
    Liabilities
          Current Liabilities
                Other Current Liabilities
                    2100 Sales Tax Payable                     108.28
                    B. Current Liabilities
                          2130 State Withholding             1,579.55
                          2140 State Unemployment                3.58
                          2175 Income Tax Payable              475.00
                    Total B. Current Liabilities             2,058.13


               Total Other Current Liabilities               2,166.41


         Total Current Liabilities                           2,166.41


    Total Liabilities                                        2,166.41


    Equity
         2940 Retained Earnings                            229,188.19
         Opening Bal Equity                                  1,078.00
         Net Income                                         38,109.70
    Total Equity                                           268,375.89


TOTAL LIABILITIES & EQUITY                                 270,542.30




                                                                              Page 4 of 4

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:12/18/2011
language:
pages:4