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
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->Display Rows->All rows
HOLLY SPRINGS FIRE RESCUE SERVICES
Num Date Name Description Paid Amount
DRAFTS and ONLINE PAYMENTS
Draft 9/1 Duke Energy Power (7/18 - 8/17) 740.12
Draft 9/1 Duke Energy Flood light (7/18 - 8/17) 15.64
Draft 9/1 S.J.W.D Water (7/15 - 8/14) 52.47
Draft 9/8 Charter Communications Internet & TV( 8/27 - 9/26) 86.25
Draft 9/9 Ach Corp Debit ADP- Fees ADP Payroll Fees Payroll processing August 2011 76.05
Draft 9/20 Weldors Supply House, Inc. August O2 cylinder rental 15.90
Draft 9/21 BB&T Service Charge 18.00
Draft 9/23 Weldors Supply House, Inc. O2 regulator gauge 12.72
Draft 9/26 BB&T Debit Card Purchases Mathis Tire Service Install and balance tires on V-1 50.00
Draft 9/27 BB&T Debit Card Purchases Advance Auto Lights for Truck 27.51
Draft 9/28 BB&T Debit Card Purchases Office Depot Label Maker tape 48.74
Draft 9/28 ACH CORP Debit ADP Payroll Taxes September 2011 812.41
Draft 9/28 ACH CORP Debit ADP Payroll September 2011 Non Direct Deposit 2,582.48
Draft 9/29 ACH CORP Debit ADP Payroll September 2011 Direct Deposit 752.69
2432 9/1 George Johnson Insurance Installment Policy #S (8/2/11 - 8/2/12) 1,438.00
2433 9/1 Holly Springs General Store 29.17
Soap Dispenser 16.47
Truck Wash 12.70
2434 9/1 Patton, Tony 1st Responder / CPR class (3 students) 180.00
2435 9/1 Petty Cash / Kelly Waters June - August 2011 141.12
4 Key FOBs 50.00
Plastic Totes 19.08
Business Cards 39.20
Appointment planner & tablet 32.84
2436 9/10 Zep Sales & Service Truck soap & dispenser 480.12
2437 9/10 Upstate EMS Council, Inc. Farm Medic class May 2011 720.00
2438 9/10 Megabytes Computer & Bookkeeping Services Accounting services (8/16 - 9/9/2011) 213.46
2439 9/10 Mark's Lock & Key Change locks on Chief's door 232.64
2440 9/10 Carolina Fire Service, Inc. Extinguisher inspection & testing 536.63
2441 9/10 California Contractors Supplies, Inc 3 Sawz All Blades 138.90
2442 9/15 Ward Motor Company Towing, tire & spare 65.00
2443 9/15 Pope Zeigler LLC 8,926.64
FOIA through July 30, 2011 1,972.50
Referendum & Election through July 31, 2011 6,954.14
2444 9/15 Holly Springs General Store 2 Bottles of degreaser 10.49
2445 9/29 Carolina Fire Service, Inc. VOID: 0.00
2446 9/29 Mansfield Oil Company August Fuel 323.396 Gl 1,134.61
2447 9/29 Carolina Fire Service, Inc. 1,572.57
Yearly testing on SCBA's 1,472.39
Hydrotesting & parts 100.18
2448 9/29 Harrison's Workwear Shirt with sewn on patches (S Bagwell) 32.85
2449 9/29 Wally's Fire & Safety Equipment Reel Lite booster hose for E-4 318.94
Total Cash Disbursement September 2011 21,462.12
Page 3 of 3