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 availab
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 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 n TIP: Choose display All rows (available for most of the reports), Select Modify report->Displa >> Deleted exported data sheet which serves as data source.
goes to Sheet 1. When you export to an existing workbook, tX" using the next available number in the series.
ction worksheet.
details about linking in Excel.) You can use this
Books data. Then create another worksheet where you can
data so that the new data is used by any Excel links and formulas. rksheet in the workbook.
used when setting up links, can cause mismatch eet, then you may have: way? For example: sed in a report like Inventory Valuation report. ch gets used in a report like Profit and Loss standard report. tivity associated and did not choose to display "All rows". lect Modify report->Display->Advanced->Diplay row->All rows
Jul 7, 07 A.N. PLASTIC
63,946.10
ABBAS KOTLAKHPAT
61,485.00
ACL AMBER CAPACITOR ANJUM UNCLE ANWAR MUGHAL
9,000.00 14,480.00 2,440.00 189,750.00
BABER AZIZ
-1,510.00 7,936.30
BERGMAN
-29,496.00
BUSH PAKISTAN
229,841.80
CASH MAJID CASH SALE FACTORY COOL INDUSTRIES
34,636.50 -22,032.50 4,700.00
DANI PLASTIC
23,750.00
DOCTOR MATERIAL
45,875.00
DOCTOR PLASTIC
20,752.93
GOLDEN TOYS HAJI AKHTAR SARGODHA HIRRA PLASTIC
5,932.00 1,950.00 1,122,314.00
IFTIKHAIR BUTT
103.20
IMRAN RUBBER
-700.00
IMRAN SHANSHAH
2,700.00
ISHAQ SAHIB NEW
52,855.00
JAWAD NEW MAH
23,600.00
KTC
-1,650.00
MAH PLASTIC (ISHAQ)
-41,155.00
MAJID
841,588.22
MILLAT PLASTICS MUGHAL SONS IRFAN NADEEM C/O MAJID NADEEM POM
-1,570.00 2,850.00 27,738.00 400.00
NADEEM SIALKOT
15,950.00
NAZIR SAHIB
68,570.60
NEW MAH PLASTIC INDUSTRIES ORBIT (MR DAWOOD) PERVAIZ BUTT SB PRIME PLASTIC NEW ACC
1,310,214.00 146,940.00 7,240.00 28,294.00
RASHID NYLON
6,150.00
RAVI PLASTIC
2,715.00
RIAZ SB
1,250.00
SHAHID G RAVI
5,218.00
SHAHID GOGI SHAHRUKH BACKALITE SHOP SALE SOHNI PLASTIC SONIC BACKALITE
277.00 4,200.00 21,572.12 227.00 -2,200.00
SPECTRO FIBER INDUSTRY
2,000.00
UBL FSD
5,000.00
YELLOW RIVER ZAFAR WASTE ZUBAIR SB TOTAL
BLK LIST
484,958.00
ASIM SAHIB BADSHAH PLASTIC
Page 3
-10.00 3,243.75 50,531.00 4,854,851.02
Page 3 of 4
Jul 7, 07
Page 4
BLK LIST
Page 4 of 4