Supplier list with detailed information
- Log in to QuickBooks Online.
- Go to the Reports menu.
- Start from a standard report that’s close to what you need. For supplier details, the Suppliers & Payables reports are a good place to start — look for Supplier Contact List if available.
- If there’s no exact match, click Customize on an existing report to modify it.
- Add the fields for address, phone number, email, contact, EIN, and Vendor ID. These are added under the Rows/Columns section — choose Change columns and select the data you want.
- Click Run report.
- Click Save customization to give the report a recognizable name for future use.
Payments to suppliers in the last 12 months
- Go to the Reports menu.
- Look under the Expenses and Suppliers reports — Transaction List by Supplier is a good starting point.
- Click Customize.
- Set the Date Range to the last 12 months.
- In the Filter section, narrow to payment transactions if needed (this depends on how your QuickBooks is set up).
- Run the report.
- Click Save customization for future access.
Tips
- If a field you need (like EIN or Vendor ID) isn’t available, make sure that detail is being captured in your supplier profiles — customization is limited by the data you enter.
- Export reports to Excel for further manipulation or sharing.
Bring these vendors into Dash.fi
You have two in-app options:- Sync automatically. Dash.fi integrates with QuickBooks Online — connecting the integration syncs your vendors with no manual export needed. See Connect QuickBooks Online.
- Bulk import your export. Upload the file you exported on the Vendors tab and map its columns to Dash.fi’s vendor fields. See Import your vendor list.