Export Data From Flourish To QuickBooks Desktop

Updated by NIr Malchy

Export the data from Flourish Software to QuickBooks Desktop in a few simple steps:

  1. Find the report you need.
  2. Set the filters (if applicable) and display the data.
  3. Export the data as a CSV file.
  4. Import the data to QuickBooks Desktop using Transaction Pro.

Reports and data

  1. Go to Analytics.
  2. Select Reports / Integrations
  3. Select the appropriate QuickBooks Desktop report for the data you are looking for in the list below:

The name of the report

The data in the report

QBD Bills (INBOUND)

Inbound invoices (bills) details.

QBD Customers

  • Top part - Inbound invoices.
  • Bottom part - Destinations.

QBD Invoices Import File

Outbound invoices details.

QBD Purchase Orders

Purchase order information.

QBD Received Payments (NonRetail)

Payments received for outbound orders.

QBD Sales Receipts (Retail Orders)

Payments received for retail orders.

QBD Vendors

Vendors information.

QBD Products & Services

Inventory-Items information.

Export Steps

Please follow the steps below to export that data and import to QuickBooks Desktop:

  1. Go to Analytics.
  2. Select Reports / Integrations.
  3. Select the report you want to export.
  4. Set the filters to get the data you need.
  5. Click on the following button to refresh the report and ensure it looks correct:
  6. Click on the three dots next to the table and select
  7. On the "Download Invoices Import File" popup, set the Format to CSV.
    The option "With visualizations options applied" is the default when you export the report. You must keep this setting checked.
  8. Click:
    1. More on Analytics - Export and Download the results to excel.
  9. Use Transaction Pro Importer to import Invoices via the CSV.
  10. Map the fields after you select the CSV. There is a button that says "Field Match" that will auto-map most of the fields. One or two fields are up to you.
    1. Example: Destination facility license number in the QBD Invoices Import File report.
The names on the header match the names on Transaction Pro.
Transaction Pro does not support item names longer than 30 Characters.

With visualizations options applied
  • The option "With visualizations options applied" is the default when you export the report.
  • Click "Advanced data options" if you want to see it. You must keep this setting checked.

How did we do?