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 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 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. ivity associated and did not choose to display "All rows". lect Modify report->Display->Advanced->Diplay row->All rows
Ascend
12:22 PM 09/12/05
Customer Contact List September 12, 2005 Life
Therapist/
Skills
Counselor MW MW CP GS GS RM RM DS DS
Coach AM AM TP TP
OP CM
RSS DT TM
JS
LG MW
AR JS AR
OP
Balance Total 1,387.50 1,287.50 600.00 725.00 500.00 1,325.00 450.00 800.00 300.00 0.00 0.00 200.00 100.00 0.00 0.00 500.00 400.00 0.00 750.00 0.00 0.00 1,475.00 0.00 0.00 799.28 2,212.50 350.00 650.00 0.00 0.00 0.00 200.00 0.00
Ship to Hamp Anderson 8545 S. Kingston Chicago, IL 60617 Joshua Anderson 8545 S. Kingston Chicago, IL 60617 Lorenzo Antwi 7719 N. Ashland Chicago, IL Larry Ashley 544 W. 126th PL Chicago, IL 60628 Michael Ashley 544 W. 126th PL Chicago, IL 60628 Shawnte Barnett-Travis 14505 S. Cottage Grove Dolton, IL 60419 Jakita Barnett 14505 S. Cottage Grove Dolton, IL 60419 Patti Barnett 14505 S. Cottage Grove Dolton, IL 60419 Unique Barnett 14505 S. Cottage Grove Dolton, IL 60419 Beathea, Edward 9052 S. Laflin Chicago Precious Bell 14037 S. Tracey #B-2 Riverdale, IL 60827 Danielle Brown Sonita Brown 9814 S. Eggleston Chicago, IL 60628 Burks, Shyra 11425 S Calumet Ave Chicago, IL 60628 Burns Roberta 12416 S. Elizabeth St. Calumet Park, IL 60827 Adam Butts John Butts Anthony Callegari 18600 Walnut Country Club Hills, IL 60478 Walnetta Carpenter 15128 Dorchester Dolton, IL 60419 Daniel Chambers Demarion Chambers 421 Suwanee Park Forest, IL 60466 Rahmall Channon Crystal Coleman Devonte Coleman 14844 S. Michigan Avenue Dolton, IL 60419 Antoinette Collins Deville Collins Dontre Collins Katrena Collins Emily Cruz 4634 W 83rd Place Chicago, IL 60625 Garth, Darshay 4255 179th ST Country Club Hills Dickerson, Danielle 2707 Knollwood Place Hazl Crest, IL Maurecia Dixon Robery Doxy
Phone 773-731-4520 773-731-4520 773-262-4157 773-401-1938
773-665-4830 work 708-846-1744 (Cell) 773-239-8780 773-468-6374 773-416-0627
708-206-1196 708-201-1203
708-841-1425
708-841-7825 773-425-4634 708-647-6859 708-798-1452 708-503-8223
Page 3 of 6
Ascend
12:22 PM 09/12/05
Customer Contact List September 12, 2005
Counselor
Coach
LG LG TP
JS JS
LG LG LG JS JS
TP LG TP TM LG
RSS JS LG
Balance Total 0.00 0.00 3,650.00 4,050.00 1,200.00 0.00 600.00 0.00 500.00 600.00 0.00 1,750.00 1,050.00 0.00 0.00 0.00 0.00 0.00 925.00 500.00 1,075.00 750.00 2,225.00 0.00 0.00 0.00 250.00 0.00 850.00 700.00 0.00 0.00 0.00 0.00 0.00
Ship to James Elliott Stormy Ervin 6B Philip Esther 522 N. Springfield Chicago, IL 60624 Robert Esther 522 N. Springfield Chicago, IL 60624 Michael Ford Foster, Brando 8541 S. Seeley Ave Chicago, IL Jasmine Harris 6603 S. Champlain Chicago, IL Mahogany Harris Trevon Hrris 6603 S. Champlain Chicago, IL Marchetta Hawkins 6350 S. Rockwell Chicago, IL 60629 Hayes, Denzel Dwayne Henry 8018 S. Escanaba Chicago, IL Shanika Henry 8018 S. Escanaba Chicago, IL Anthony Hernandez Carlecia Hernandez Shirley Howard Humphrey, Alicja 317 W 107th Street Chicago, IL 60617 Humphrey, Angela Diamond Humprey 152 W. 157th Street Harvey, IL Trevon Johnson Larry Jones 2925 Peach Tree Sauk Village, IL 60415 Starris Jones 1250 Mackinaw Calumet City. IL 60409 Devonte McCray 7634 S. Phillips Chicago, IL 60649 McDonald Tony McDonald, Jonnelle Gwendolyn Mitchell 11917 S. Wallace Chicago, IL Carmela Nardi Newell, Janet 11425c S Calumet Chicago, Il 60628 Robert Orlando Geno Pitts 8111 S. Evans Chicago, IL Prater, Scott Jermaine Radcliffe Raine, Darius 15040 Irving Ave Dolton, IL 60419 Raine, Demitrius 15040 Irving Ave Dolton, IL 60419 Ratliff, Lakesha 429 W. 71 PL Chicago
Phone 708-597-2191 773-533-4681 home 773-239-5359
773-995-3560
773-947-8886 ext 228 773-947-8886 ext 228
773-732-4509 708- 339-0706 798-753-1628 708-868-4363 773-575-7802 708-957-0904 773-568-2742
773-874-4198
708-849-3540 708-849-3540 773-488-2076
Page 4 of 6
Ascend
12:22 PM 09/12/05
Customer Contact List September 12, 2005
Counselor DS DC DT DC DC
DC RM MW
LG LG
CP LG LG LG
RM RM
JS
JS
Coach
Balance Total 0.00 375.00 600.00 800.00 500.00 500.00 0.00 -588.75 600.00 1,300.00 600.00 0.00 0.00 900.00 850.00 0.00 0.00 525.00 500.00 900.00 500.00 0.00 0.00 0.00 0.00 0.00 400.00 300.00 0.00 0.00 1,950.00 0.00 0.00 1,725.00 0.00
Ship to Roby, Derrick 22552 Arquilla Drive Richton Park, IL 60471 Joseph Rodriguez 3856 W. 64th St. Chicago, IL 60629 Deaquin Ruth 1666 W. 103rd Street Chicago, IL James Ruth 1666 W. 103rd Street Chicago, IL Rayshon Ruth 1666 W. 103rd St. Chicago, IL Sylvia Ruth 1666 W. 103rd Street Chicago, IL Earlene Cox Alma Scott Mary Simmons Alexa Steward-Jones Christopher Strong Suter, Derrick 10356 S. Indiana Chicago, IL 60628 Erick Suter 10356 S. Indiana Chicago, IL 60628 Joshua Sutton 7716 S. Kingston Chicago, IL 60649 Donald Synowiec 2424 E. 223rd Chicago Heights, IL Glenna Synowiec Kimberly Synowiec 2424 E. 223rd Chicago Heights, IL Anicia Thomas 9026 S. Laflin #1E #1E Chicago, IL Thomas, Brittany Nathan Thomas Thomas, Tyrell Trim, Brianna 4255 179th ST Country Club Hills Trim, Devonte Trim, Jasmine 4255 179th ST Country Club Hills Trim, Lacresia Tyler, Curtis 8411 S. Sangamon CHicago, IL 60620 Donna Ward Stephanie Ward Warren, Tyrona Washington, Cornelius 10749 S Indiana Ave Chicago, IL 60628 Javonte Washington 520 W. 78th Street Chicago, IL 60620 Eden Watson Stephanie Watson Steven Webb Wilkins, Benjamin 10822 S Church St Chicago, IL 60643
Phone 708-503-8862 773-585-4672
773-239-8711 708-210-9231 708-889-0930 708-596-7511
773-264-7266 773-264-7266 773-978-6535 708-757-6631 708-757-6631 708-757-6631 773-779-6492 630-378-1525 708-647-6859 708-647-6859 773-483-0492
773-264-0128
312-846-5557
Page 5 of 6
Ascend
12:22 PM 09/12/05
Customer Contact List September 12, 2005
Counselor
JS JS
Coach
Balance Total 0.00 0.00 0.00 0.00 0.00 3,503.57 950.00
Ship to Wilkins, William 10822 S Church St Chicago, IL 60643 Williams, Angela 1820 W 78th street Chicago, IL 60620 Jeana Williamsen 762 Norte Dame Dr Matteson, IL 60440 Jonesha Williamsen 762 Norte Dame Drive Matteson, IL 60440 Williamsen, Justina 762 Norte Dame Dr Matteson, IL 60440 Anthony Wuokko 762 Norte Dame Dr. Matteson, IL 60440 Joseph Wuokko 762 Notre Dame Drive Matteson, IL 60440
Phone
708- 720-1562 708-720-1562 708-720-1562 708-720-1562 708-720-1562
Page 6 of 6