Balance Sheet

Document Sample
Balance Sheet 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->Display Rows->All rows
2:14 PM                                         Rock Castle Construction
12/15/12
Accrual Basis                                         Balance Sheet
                                                    As of December 15, 2012

                                                            Dec 15, 12
ASSETS
    Current Assets
         Checking/Savings
             10100 · Checking                                 19,419.39
             10300 · Savings                                  17,910.19
             10400 · Petty Cash                                 500.00
         Total Checking/Savings                               37,829.58


         Accounts Receivable
             11000 · Accounts Receivable                      93,007.93
         Total Accounts Receivable                            93,007.93


         Other Current Assets
             12800 · Employee Advances                          832.00
             12000 · Undeposited Funds                         2,440.00
             13100 · Pre-paid Insurance                        4,050.00
             12100 · Inventory Asset                          30,241.33
             13400 · Retainage Receivable                      3,703.02
         Total Other Current Assets                           41,266.35


    Total Current Assets                                     172,103.86


    Fixed Assets
         15000 · Furniture and Equipment                      34,326.00
         15100 · Vehicles                                     78,936.91
         15200 · Buildings and Improvements                  325,000.00
         15300 · Construction Equipment                       15,300.00
         16900 · Land                                         90,000.00
         17000 · Accumulated Depreciation                   -110,344.60
    Total Fixed Assets                                       433,218.31


    Other Assets
         18700 · Security Deposits                             1,720.00
    Total Other Assets                                         1,720.00


TOTAL ASSETS                                                 607,042.17


LIABILITIES & EQUITY
    Liabilities
         Current Liabilities
             Accounts Payable
                   20000 · Accounts Payable                   12,011.30
             Total Accounts Payable                           12,011.30


             Credit Cards
                   20500 · QuickBooks Credit Card                94.20
                   20600 · CalOil Credit Card                   335.10
             Total Credit Cards                                 429.30


             Other Current Liabilities




                                                                              Page 3 of 4
2:14 PM                                           Rock Castle Construction
12/15/12
Accrual Basis                                              Balance Sheet
                                                       As of December 15, 2012

                                                               Dec 15, 12
                   24000 · Payroll Liabilities
                        24010 · Federal Withholding               1,364.00
                        24020 · FICA Payable                      2,118.82
                        24040 · FUTA Payable                       100.00
                        24050 · State Withholding                  299.19
                        24060 · SUTA Payable                       110.00
                        24070 · State Disability Payable            48.13
                        24080 · Worker's Compensation             1,214.31
                        24100 · Emp. Health Ins Payable            150.00
                   Total 24000 · Payroll Liabilities              5,404.45

                   25500 · Sales Tax Payable                       957.63
             Total Other Current Liabilities                      6,362.08


        Total Current Liabilities                                18,802.68


        Long Term Liabilities
             23000 · Loan - Vehicles (Van)                       10,501.47
             23100 · Loan - Vehicles (Utility Truck)             19,936.91
             23200 · Loan - Vehicles (Pickup Truck)              22,641.00
             28100 · Loan - Construction Equipment               13,911.32
             28200 · Loan - Furniture/Office Equip               21,000.00
             28700 · Note Payable - Bank of Anycity               2,693.21
             28900 · Mortgage - Office Building                 296,283.00
        Total Long Term Liabilities                             386,966.91


    Total Liabilities                                           405,769.59


    Equity
        30000 · Opening Bal Equity                               38,773.75
        30100 · Capital Stock                                      500.00
        32000 · Retained Earnings                                61,756.76
        Net Income                                              100,242.07
    Total Equity                                                201,272.58


TOTAL LIABILITIES & EQUITY                                      607,042.17




                                                                                 Page 4 of 4

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:11
posted:2/18/2012
language:
pages:4