QuickBooks & QuickBooks V2
- 14 Jun 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
QuickBooks & QuickBooks V2
- Updated on 14 Jun 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
The information below is for running the enhanced report version of these two reports.
The QuickBooks & QuickBooks V2 exports are order reports in text format that can be used with a third-party program called Transaction Pro Importer to import your order and sales data into your QuickBooks software.
WineDirect Support does not offer assistance with the setup or configuration of the Transaction Pro Importer. This is a manual process. You will want to contact the application provider or seek a Consultant Partner for more assistance.
WineDirect does not supply Transaction Pro Importer. The winery must purchase the program.
WineDirect does not supply Transaction Pro Importer. The winery must purchase the program.
Two versions of QuickBooks exports are available: Quickbooks Export and QuickBooks Export (V2). The filters below are the same for both; only the columns in the Export are different. Select whichever better supports your mapping style with Transaction Pro Importer.
Running The Report/Export
1. Navigate to Reports > Financial and select QuickBooks or QuickBooks (V2) export.
2. Enter the date range you wish to report on [To & From Date]. Dates should be MM/DD/YYYY in North America and DD/MM/YYYY in Australia.
**If you are looking to export all Authorized, Completed, Voided, and Refunded orders [money in and out], then you can skip to Step 4.**
3. Using the Manage Filters option, you can expand the filter menu and adjust the following:
A) Adjust any additional Order Type parameters if you only want to export specific order types (i.e., ClubOrder). By default, all order types will be shipped.
- All Types
- AdminPanel
- ClubOrder
- POS
- Website
- ...or Additional custom order types of your creation.
B) Select whether you want bundled items to export as their bundle SKU number or per piece (default is the Bundle SKU: Show Bundle Only)
- Show Bundle Only: Only the Bundle SKU will appear in the Export.
- Show Individual SKUs Only: Rather than showing the Bundle SKU in the Export, the report will display each of the subSKUs that make up the Bundle.
C) Adjust alternate Payment Status if you want to include declined tenders. (Bold Payment Statuses are the defaults used in the report)
- All Statuses
- Pending
- Submitted
- Authorized
- Paid
- Declined
- Refunded
- Voided
- External
D) If you use additional services connected to your WineDirect account, you can filter orders by Vendor.
4. Click View to view the report data in your browser (Not available on QuickBooks V2 export). Click Export to receive an export file.
QuickBooks & QuickBooks V2 FAQs
What is the difference between QuickBooks & QuickBooks V2?
Both the QuickBooks & QuickBooks V2 reports are designed to be used with the third party application Transaction Pro Importer. Because QuickBooks account setups can vary and because Transaction Pro Importer allows for custom mappings, there are two export versions available. Main differences include:
A) The columns in the report vary. Each has a different set of columns with different information.
B) The QuickBooks V2 export displays tips on POS orders as a separate line item.
If you are working with a consultant for data importing you will want to check with them to see which export sheet they are using. In most cases they will likely be using the newer QuickBooks V2.
How do orders with multiple (split) tenders work?
Only one payment type (tender) can be imported per order, so to help streamline the import process only one tender from the order will be displayed in the export. For most orders this will not have any affect on the report is the customer made full payment with a credit card or cash then the report will show the card or cash as the payment method.
For orders when the customer paid for the order with multiple payment types (tenders) then the first successful payment method will be reported on, with priority given first to credit card payments and then to cash. So on an order where a credit card and cash were both used the QuickBooks & QuickBooks V2 reports will only show the credit card payment type (with its card type: Visa, MasterCard, etc). On orders without a credit card tender, example a gift card and cash payments, then the cash tender would show instead of the gift card tender.
Please be mindful of whether you are placing orders with more than one payment type (tender) as this will affect your QuickBooks & QuickBooks V2 exports and in turn your reporting in QuickBooks.
Was this article helpful?
