Item List
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Item List as PDF for free.
More details
- Words: 926
- Pages: 5
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 Invento You might have moved or deleted accounts from accounts list which gets used in a report like >> 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->Display >> Deleted exported data sheet which serves as data source.
goes to Sheet 1. When you export to an existing workbook, etX" using the next available number in the series.
uction worksheet.
r details about linking in Excel.) You can use this
kBooks data. Then create another worksheet where you can
t data so that the new data is used by any Excel links and formulas. rksheet in the workbook.
u used when setting up links, can cause mismatch heet, then you may have: e way? For example: used 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". elect Modify report->Display->Advanced->Diplay row->All rows
ISWALI VENTURE (PG0160468-W)
8:15 PM 01/17/06
Item Listing
January 17, 2006 Item
Description
Type
Cost
Price
LB BKURGIRL
LABOUR BAJU KURUNG SEPASANG GIRL
Service
6.93
LB BKURKED
LABOUR BAJU KURUNG KEDAH STD
Service
1.32
21.00 4.00
LB BKURLAD ALAS
LABOUR BAJU KURUNG LADY ALAS
Service
21.00
38.00
LB BKURLADY
LABOUR BAJU KURUNG SEPASANG LADY
Service
8.58
30.00
LB BLOLADY
LABOUR BLOUSE LADY
Service
7.59
23.00
LB BMELBOY
LB BAJU MELAYU BOY
Service
11.55
35.00
LB BMELMEN
LABOUR BAJU MELAYU CEKAK MUSANG SEPASANG ServiceMEN
14.85
45.00
LB KELAWAR
LABOUR BAJU KELAWAR
Service
0.99
3.00
LB KEMLONHANMEN
LABOUR KAMEJA LENGAN PANJANG - MEN
Service
7.59
23.00
LB KEMSHOHANMEN
LABOUR KAMEJA LENGAN PENDEK - MEN
Service
6.93
21.00
LB LINEN MEN
LABOUR LINEN MEN
Service
6.60
20.00
LB SUL LOGO
LABOUR SULAMAN LOGO
Service
2.70
3.00
LB SUL NAMA
LABOUR SULAMAN NAMA
Service
2.00
2.50
LB SUL TUD
LABOUR SULAM TUDUNG 1M
Service
19.00
22.80
LB TALI LEHER
LABOUR TALI LEHER
Service
3.00
8.50
LB TUDNUR
LB TUDUNG NURSE
Service
2.31
7.00
kain bkd
kain baju kurung dewasa RM4.5@1M
Inventory Part
4.50
6.25
KAIN D003
KAIN D003 BAJU KURUNG KEDAH
Inventory Part
2.50
2.66667
KAIN TALI LEHER
KAIN TALI LEHER
Inventory Part
0.80
1.20
KAIN TC
KAIN TC
Inventory Part
8.50
13.60
KAIN TUDNURSE
KAIN TUDUNG NURSE
Inventory Part
7.65
9.00
t-shirt panjang
t-shirt panjang
Inventory Part
18.00
27.00
t-shirt pendek
t-shirt pendek
Inventory Part
15.00
23.00
TALI LEHER
TALI LEHER MEN SIAP WITH LOGO
Inventory Part
7.00
13.00
Fin Chg
Finance Charges on Overdue Balance
Other Charge
0.00
10.0%
OTHER CHARGE
OTHER CHARGE
Other Charge
0.00
0.00
subtotal
Subtotal
Subtotal
0.00
100 megasale bkurlady
BKURLADY SALE 10%
Group
0.00
200 megasale bkurgirl
BKURGIRL SALE 10%
Group
0.00
BKEMSHOHAN -SET
KAMEJA SIAP LENGAN PENDEK MEN -SET
Group
0.00
BKURKED -SET
BKURKED -SET
Group
0.00
BKURLADY - SET
BAJU KURUNG LADY - SET
Group
0.00
TUDNURSE - SET
TUDUNG NURSE WITH PIPING - SET
Group
0.00
Discount
Discount
Discount
0.00
0.0%
Discount 05%
Discount 5% > 5
Discount
0.00
-5.0%
Discount 10%
Discount 10% > 30
Discount
0.00
-10.0%
Discount 15%
Discount 15% > 50
Discount
0.00
-15.0%
Discount 20%
Discount 20% > 100
Discount
0.00
-20.0%
Discount 30%
DISCOUNT 30% > 300
Discount
0.00
-30.0%
Discount 40%
DISCOUNT 40% > 400
Discount
0.00
-40.0%
Discount 50%
Discount 50%
Discount
0.00
-50.0%
Page 3 of 5
8:15 PM 01/17/06
ISWALI VENTURE (PG0160468-W)
Item Listing
January 17, 2006 Sales Tax Code
Quantity On Hand
Quantity On Sales Order
48.00
0.00
25.00
0.00
0.00
0.00
0.00
0.00
1.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Reorder Point
0.00
Tax Tax Tax Tax Tax Tax Tax Tax
Page 4 of 5
ISWALI VENTURE (PG0160468-W)
8:15 PM 01/17/06
Item Listing
January 17, 2006 Quantity On Purchase Order
Preferred Vendor
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Page 5 of 5
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 Invento You might have moved or deleted accounts from accounts list which gets used in a report like >> 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->Display >> Deleted exported data sheet which serves as data source.
goes to Sheet 1. When you export to an existing workbook, etX" using the next available number in the series.
uction worksheet.
r details about linking in Excel.) You can use this
kBooks data. Then create another worksheet where you can
t data so that the new data is used by any Excel links and formulas. rksheet in the workbook.
u used when setting up links, can cause mismatch heet, then you may have: e way? For example: used 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". elect Modify report->Display->Advanced->Diplay row->All rows
ISWALI VENTURE (PG0160468-W)
8:15 PM 01/17/06
Item Listing
January 17, 2006 Item
Description
Type
Cost
Price
LB BKURGIRL
LABOUR BAJU KURUNG SEPASANG GIRL
Service
6.93
LB BKURKED
LABOUR BAJU KURUNG KEDAH STD
Service
1.32
21.00 4.00
LB BKURLAD ALAS
LABOUR BAJU KURUNG LADY ALAS
Service
21.00
38.00
LB BKURLADY
LABOUR BAJU KURUNG SEPASANG LADY
Service
8.58
30.00
LB BLOLADY
LABOUR BLOUSE LADY
Service
7.59
23.00
LB BMELBOY
LB BAJU MELAYU BOY
Service
11.55
35.00
LB BMELMEN
LABOUR BAJU MELAYU CEKAK MUSANG SEPASANG ServiceMEN
14.85
45.00
LB KELAWAR
LABOUR BAJU KELAWAR
Service
0.99
3.00
LB KEMLONHANMEN
LABOUR KAMEJA LENGAN PANJANG - MEN
Service
7.59
23.00
LB KEMSHOHANMEN
LABOUR KAMEJA LENGAN PENDEK - MEN
Service
6.93
21.00
LB LINEN MEN
LABOUR LINEN MEN
Service
6.60
20.00
LB SUL LOGO
LABOUR SULAMAN LOGO
Service
2.70
3.00
LB SUL NAMA
LABOUR SULAMAN NAMA
Service
2.00
2.50
LB SUL TUD
LABOUR SULAM TUDUNG 1M
Service
19.00
22.80
LB TALI LEHER
LABOUR TALI LEHER
Service
3.00
8.50
LB TUDNUR
LB TUDUNG NURSE
Service
2.31
7.00
kain bkd
kain baju kurung dewasa RM4.5@1M
Inventory Part
4.50
6.25
KAIN D003
KAIN D003 BAJU KURUNG KEDAH
Inventory Part
2.50
2.66667
KAIN TALI LEHER
KAIN TALI LEHER
Inventory Part
0.80
1.20
KAIN TC
KAIN TC
Inventory Part
8.50
13.60
KAIN TUDNURSE
KAIN TUDUNG NURSE
Inventory Part
7.65
9.00
t-shirt panjang
t-shirt panjang
Inventory Part
18.00
27.00
t-shirt pendek
t-shirt pendek
Inventory Part
15.00
23.00
TALI LEHER
TALI LEHER MEN SIAP WITH LOGO
Inventory Part
7.00
13.00
Fin Chg
Finance Charges on Overdue Balance
Other Charge
0.00
10.0%
OTHER CHARGE
OTHER CHARGE
Other Charge
0.00
0.00
subtotal
Subtotal
Subtotal
0.00
100 megasale bkurlady
BKURLADY SALE 10%
Group
0.00
200 megasale bkurgirl
BKURGIRL SALE 10%
Group
0.00
BKEMSHOHAN -SET
KAMEJA SIAP LENGAN PENDEK MEN -SET
Group
0.00
BKURKED -SET
BKURKED -SET
Group
0.00
BKURLADY - SET
BAJU KURUNG LADY - SET
Group
0.00
TUDNURSE - SET
TUDUNG NURSE WITH PIPING - SET
Group
0.00
Discount
Discount
Discount
0.00
0.0%
Discount 05%
Discount 5% > 5
Discount
0.00
-5.0%
Discount 10%
Discount 10% > 30
Discount
0.00
-10.0%
Discount 15%
Discount 15% > 50
Discount
0.00
-15.0%
Discount 20%
Discount 20% > 100
Discount
0.00
-20.0%
Discount 30%
DISCOUNT 30% > 300
Discount
0.00
-30.0%
Discount 40%
DISCOUNT 40% > 400
Discount
0.00
-40.0%
Discount 50%
Discount 50%
Discount
0.00
-50.0%
Page 3 of 5
8:15 PM 01/17/06
ISWALI VENTURE (PG0160468-W)
Item Listing
January 17, 2006 Sales Tax Code
Quantity On Hand
Quantity On Sales Order
48.00
0.00
25.00
0.00
0.00
0.00
0.00
0.00
1.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Reorder Point
0.00
Tax Tax Tax Tax Tax Tax Tax Tax
Page 4 of 5
ISWALI VENTURE (PG0160468-W)
8:15 PM 01/17/06
Item Listing
January 17, 2006 Quantity On Purchase Order
Preferred Vendor
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Page 5 of 5
