Salesforce Data Quality: How to Audit Your Org Before AI and Automation

Guest blog by: Mykhailo Radchenko

Artificial Intelligence is no longer a futuristic concept; it is an active component of daily business operations. Many companies are currently in a race to integrate AI into their workflows, investing heavily in intelligent automation to achieve significant productivity gains. However, a silent hurdle is preventing these investments from reaching their full potential: messy data.

The Financial Reality of Poor Data Quality

The impact of bad data is cumulative and affects every corner of an organization. To prevent marketing campaigns from missing targets and forecasting from becoming unreliable, organizations often rely on a Salesforce data quality playbook to standardize their data entry and maintenance processes. This translates into significant financial losses. According to a 2024 Forrester Research report, over 25% of global data and analytics employees estimate annual losses exceeding $5 million due to poor data quality, with 7% reporting losses of $25 million or more. Gartner further supports this, noting that poor data quality costs organizations an average of $12.9 million annually.

Perhaps the most pressing concern is the threat to future competitiveness. Gartner predicts that through 2026, organizations will abandon 60% of AI projects that lack AI-ready data. This unreliability also severely impacts customer retention. According to a Zendesk study, over 50% of consumers will switch to a competitor after a single bad experience, and 73% after multiple poor experiences. 

Image source: Gartner

Why Companies Struggle with Salesforce Hygiene

For many firms, Salesforce acts as the "central nervous system" of their go-to-market engine. But as companies grow, they build complex technology stacks where marketing automation, ERP systems, and sales platforms all feed data into the CRM. These multiple entry points often result in a CRM filled with missing pieces and mixed-up details.

According to a recent study by Salesforce, the vast majority of executives–87%–view data silos as the primary hurdle preventing them from using artificial intelligence effectively. Despite this, a Salesforce/Forrester survey found that two out of three companies do not have a proper data strategy, although many of them already use AI.

Image source: Salesforce

Furthermore, data decay happens faster than most teams realize. At least 28% of business email addresses expire within a single year, according to a recent industry report. This means that without a consistent strategy to maintain data quality, more than a quarter of your database could be obsolete within 12 months. When Salesforce data hygiene is neglected, the results include:

• Inaccurate Forecasting: 39% of sales professionals claim poor data prevents accurate pipeline reporting.
• Lost Productivity: Sales reps spend 70% of their time on non-selling tasks, a figure largely unchanged since 2022.
• AI Failure: 63% of sales professionals report that their company’s data is not properly set up for generative AI.
• Loss of Trust: 65% of sales professionals report they cannot fully trust their organization's data.

Understanding Salesforce AI Data Quality Dimensions

Are you ready for AI? The growth potential is significant: Salesforce research indicates that 90% of SMB leaders report AI makes operations more efficient, while 87% say it helps scale services, and 86% believe it improves margins and competitive standing. Furthermore, sales teams that deploy AI with reliable foundations see a clear revenue advantage: 83% saw gains, compared to only 66% of teams without AI. However, these results are achievable only if the underlying data are reliable.

Image source: Salesforce

Before deploying bots or predictive models, it is essential to understand the data quality dimensions Salesforce AI requires to function. If the underlying data is fragmented or incomplete, AI tools will likely surface outdated info or produce "hallucinations". In one high-profile case, an AI support bot invented a fake login policy and sent it to users without human oversight, leading to canceled subscriptions and a public apology. To improve the quality of the data in Salesforce, organizations should audit their org against these four key dimensions:

1. Required Field Standards

AI models require specific "ingredients" to produce meaningful results. For objects like Leads, Contacts, and Opportunities, you must identify which fields, such as Industry, Job Title, or Annual Revenue, are mandatory for your specific AI use case. Identifying these gaps is the first step in creating a reliable dataset.

2. Picklist Uniformity

Inconsistent values are a primary cause of broken logic in AI segmentation. If your "Industry" field contains variations such as "Healthcare," "Health Care," and "Medical," an AI will treat them as separate categories. Normalizing these picklists is vital for Salesforce data quality.

3. Duplication Thresholds

You must define what constitutes a duplicate within your specific business context. For example, should "IBM" and "International Business Machines" be merged?. Using Salesforce deduplication filters to define these match criteria is necessary to prevent the AI from processing redundant or conflicting information.

4. Record Freshness

The "New/Modified Records" trend view is a useful metric to identify stale data. Tracking records created or updated over the past 360 days helps flag data that might confuse analytics or cause poor customer experiences.

The "New/Modified Records" trend view is a useful metric to identify stale data. Tracking records created or updated over the past 360 days helps flag data that might confuse analytics or cause poor customer experiences.

How to Improve Data Quality in Salesforce: A Phased Approach

Cleaning an entire Salesforce instance can feel overwhelming, but a phased strategy for Salesforce data cleansing can yield immediate results.

Phase 1

Target Exact Matches: Start with the "low-hanging fruit" – obvious exact matches where Leads or Contacts share the same email and account name. Merging these records immediately restores trust in the CRM for the teams using it every day.

Phase 2

Automate and Schedule: Once the initial "mess" is cleared, schedule automated merge jobs to handle low-risk duplicates in the background. This ensures that your efforts to maintain data quality in Salesforce are consistent and not just a one-time project.

Phase 3

Prevent at the Source: The most effective way to improve Salesforce data quality is to stop errors before they enter the system. Using API integrations, such as those offered by Cloudingo, allows external systems, such as marketing automation or ERPs, to be deduplicated before they land in Salesforce.

Real-World ROI: The Cost of Inaction

The need for a Salesforce data quality playbook is often best illustrated by companies that have faced "data disasters". For instance, Docker, Inc. faced a situation in which thousands of duplicate records filled its system – some companies appeared as 60 separate accounts due to repeated credit card payments. This led sales reps to stop trusting the CRM entirely, resulting in nearly $1 million in annual lost revenue.

Similarly, at 1-800Accountant, the team was "drowning in duplicates," with over 32,000 bad leads. This led to one in five sales calls being repeats, with clients contacted up to 10 times, resulting in significant prospect frustration. 

A similar situation occurred at Lucid Design Group, where a CRM with 75,000 records became so unmanageable that the sales team repeatedly called disqualified leads, and the sole Admin spent a full working day manually merging duplicates.

By implementing a structured audit and an automated cleanup solution, these companies restored trust and provided their teams with a reliable system.

Conclusion: Building the Future on a Clean Foundation

Salesforce data quality is no longer just a background administrative task; it is a core growth strategy. As organizations prepare for deeper AI integration, they must move away from manual, reactive cleanup and toward proactive, automated maintenance.

If your data is messy, AI will only amplify those errors. But if your data is clean, AI becomes a powerful multiplier for productivity and revenue. For a deeper dive into these strategies, you can download the full Salesforce data quality playbook or explore the technical requirements for Salesforce data hygiene.

Salesforce: Opportunity Contact Roles are Added by Default

When Opportunity Contact Roles are Added by Default?

• From a Contact Record: When users create a new opportunity directly from the Related List on a Contact record, that contact is added as a contact role.
• During Lead Conversion: When a Lead is converted into an Opportunity, Salesforce automatically links the converted Contact to the new Opportunity.

As above, this only happened during Opportunity creation, and not during Opportunity edit.

What is the Role and Primary?

• Role = blank
• Primary = Yes

Automation

Salesforce administrators/developers can create Flows or Apex Triggers to create contact roles automatically based on custom criteria when an opportunity is created or edited.

Salesforce: Restrict picklist to the values defined in the value set

There is a checkbox in the Picklist field "Restrict picklist to the values defined in the value set". What is the purpose of this checkbox? 

An unrestricted picklist means that users can add extraneous values to records having that picklist field. To restrict values only to those in the picklist definition, enable this setting.

Checking the "Restrict picklist to the values defined in the value set" box in Salesforce ensures that only predefined values are allowed in a picklist field, rejecting any others from API updates. This promotes data consistency and prevents invalid entries, such as typos or unauthorized data.

User will get the following error when saving the record: INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST: Brand: bad value for restricted picklist field: value [API_field_name__c]

But are there any character limits that the API call can push the data past if we remove the restriction? 

Error saving record: STRING_TOO_LONG: field_name: data value too large: new values (max length=255) [API_field_name__c]

Salesforce: Field History Tracking

By design, when a field is enabled for tracking, it is not tracked during record creation. For example: Primary Campaign Source (PCS) in Opportunity:

Action	Appears in Field History?
Create Opp with PCS filled	❌ No
Create Opp blank PCS	❌ No
Update PCS from blank → Campaign	✅ Yes
Change PCS Campaign A → Campaign B	✅ Yes

The same result using SOQL, sample: 

SELECT Id, OpportunityId, CreatedDate, Field, DataType, OldValue, NewValue FROM OpportunityFieldHistory WHERE DataType = 'Text' ORDER BY CreatedDate DESC

Designing Salesforce Payment Workflows with QuickBooks and Stripe (Part: 2)

Guess blog by: Antonina Kharchenko

Introduction: Operating Salesforce Payment Workflows in Real-World Integrations

In the first part of this guide, we explored how to design Salesforce payment workflows when integrating with systems such as Stripe and QuickBooks. We discussed how to structure Salesforce objects, define workflow triggers, model integration fields, and automate billing‑related processes so that customer records, subscriptions, and invoices remain aligned across platforms. If you haven’t read it yet, you can start with our previous article.

While designing workflows is essential, running payment integrations in production introduces a different set of challenges. Once Salesforce begins exchanging data with external financial systems, teams must manage synchronization timing, API limits, record matching logic, and security considerations.

These challenges are not unique to payment systems, they reflect broader trends in enterprise technology. According to Salesforce and MuleSoft’s Connectivity Benchmark Report, organizations today use over 1,000 applications on average, yet less than 30 % of these applications are integrated, leaving vast portions of business data siloed and disconnected.

Average Apps per Organization vs. Integrated Apps, image from Salesforce.

This article focuses on the most common challenges teams encounter when running Salesforce payment workflows in real environments. Understanding these challenges helps teams anticipate problems early and build integrations that remain stable as systems and data volumes grow.

Common Challenges in Salesforce Payment Workflows

Different challenges can come up depending on how you integrate Salesforce with external systems. Most issues happen with custom-built integrations, while some can also appear when using middleware or prebuilt apps. The challenges in this section give you a clear idea of what to watch out for.

Issue #1. Record Matching and Duplicate Accounts

What happens:

QuickBooks and Stripe both maintain their own unique customer IDs and account structures. When Salesforce attempts to sync a client record, the integration must match the Salesforce record to an existing external record.

Typical failure modes:

• The external system creates a new customer instead of matching an existing one.
• Duplicates are introduced because the matching criteria differ (email vs. name vs. ID).

What to check:

• How the integration matches records by default (email, external ID, custom logic).
• Whether custom matching rules can be configured.

Why it matters: Duplicate clients lead to mismatched financial records and require manual cleanup. A Salesforce study found that the average customer’s contact database is composed of 90% incomplete contacts, with 20% of records being useless due to several factors, such as 74% of the records needing updates and more than 25% of those being duplicates.

Issue #2. Field Mapping Discrepancies Between Systems

What happens:

Salesforce objects do not map one‑to‑one with external system objects. QuickBooks Online uses nested address structures (e.g., BillAddr, ShipAddr) and requires a CustomerRef when creating invoices. When updating records, SyncToken must be provided to prevent conflicts. Stripe also has its own object schema with required fields for customers and subscriptions. 

Typical failure modes:

• Missing required fields cause API errors.
• Updates fail if required attributes like SyncToken are not supplied.

What to check:

• Confirm mandatory fields in QuickBooks or Stripe before creating or updating records.
• Verify that Salesforce fields are mapped to the correct external attributes.

Issue #3. Timestamp and Data Staleness

What happens:

Different systems update data at different times and may use independent clocks or refresh intervals. Salesforce may receive external data with a delay or with timestamps that do not exactly match internal expectations.

Typical failure modes:

• A subscription change in Stripe is reflected in Salesforce much later.
• QuickBooks invoice states update with a delay and appears outdated.

What to check:

• Sync frequency (near‑real‑time vs. scheduled batch).
• Whether the integration supports event‑driven updates or only polling.

For example, with Breadwinner, you can configure the sync schedule to control how often updates are pulled into Salesforce.

Issue #4. API Limits and Large Data Loads

What happens:

Stripe and QuickBooks APIs impose rate limits. When initial data loads are large (many customers, invoices, payments), or when webhook traffic spikes, calls can fail or get throttled.

Typical failure modes:

• Integration stops due to rate limit rejections.
• Partial imports without clear error diagnostics.

What to check:

• API usage quotas for the external system.
• Support for throttling and back‑off logic.

Issue #5. Integration Security and Least Privilege

What happens:

Integration connections need the right permissions to create, update, or delete records in Salesforce, Stripe, or QuickBooks. If an integration user has too many privileges, it increases security and compliance risk; if it has too few, API calls will fail. Storing credentials insecurely (like hard‑coding in config or metadata) also poses a risk.

Typical failure modes:

• API calls fail due to insufficient permissions.
• Credentials embedded in code or configuration create audit and security issues.
• Over‑privileged integration accounts expand the risk if credentials are compromised.

What to check:

• Use dedicated integration users with narrowly scoped permissions that match only what the integration needs.
• Configure authentication using OAuth 2.0 or Named Credentials to prevent hard‑coding secrets.
• Rotate tokens and credentials regularly and avoid storing secrets in custom fields or hard‑coded Apex.

Issue #6. Webhook Reliability (Stripe)

What happens:

Stripe uses webhooks to deliver asynchronous payment and subscription events (e.g., payment success, subscription updates) to connected systems. Webhooks are best‑effort notifications and may not always arrive reliably or in order.

Typical failure modes:

• Webhook deliveries fail or time out, so the connected system never receives critical events.
• Events may be delivered more than once or out of order, requiring handling logic that accounts for duplicates and variability in delivery sequences.

What to check:

• Verify the webhook endpoint configuration in Stripe (correct endpoint URL, HTTPS, and event types).
• Ensure your integration processes events idempotently so that repeated deliveries do not produce inconsistent records.
• Confirm that webhook retries are being logged and monitored, and address connectivity or handler errors that prevent successful responses.

Best Practices for Reliable Salesforce Payment Integrations

Designing Salesforce payment processing with QuickBooks or Stripe Salesforce integration requires a careful, methodical approach. Integrations are not just about moving data; they ensure client records, subscriptions, and invoices remain accurate and consistent across systems.

Define the source of truth: Decide which system owns each type of data. Salesforce for client details, Stripe for subscription history, QuickBooks for invoices. This prevents conflicts and accidental overwrites.

Validate and map fields: Make sure all required fields in external systems have corresponding Salesforce fields. Map products, pricing, and plans correctly to avoid errors during record creation.

Monitor sync processes: Use logs, alerts, and reports to catch failures early. Partial syncs or missed updates can be costly if left unchecked.

Handle updates carefully: Changes to client data should flow in a controlled, predictable way. Implement error handling and plan for retries on failed API calls.

Secure the integration: Use secure authentication, tokenized payment data, and least-privilege integration accounts. Ensure compliance with PCI, GDPR, and other relevant standards.

Prebuilt AppExchange apps such as Breadwinner can connect QuickBooks Salesforce or Stripe with minimal setup. For organizations with specific business rules or complex requirements, custom API solutions provide additional flexibility.

Following these practices supports automating Salesforce workflows that reduce manual effort, prevent errors, and keep Salesforce and the connected financial system aligned, giving teams confidence in the accuracy of client and payment data.

Conclusion: Reliable and Scalable Salesforce Payment Workflows

Designing Salesforce payment processing with QuickBooks or Stripe Salesforce integration requires a careful, methodical approach. Integrations are not just about moving data; they ensure client records, subscriptions, and invoices remain accurate and consistent across systems.

Payment workflows work best when they are thoughtfully structured, monitored, and maintained. From planning triggers and mapping fields to handling updates and addressing real-world challenges, a clear and consistent approach keeps data aligned and processes predictable. When workflows are designed and managed properly, organizations can reduce manual effort, prevent errors, and maintain confidence in their customer and payment data.

By addressing common challenges and following proven recommendations, organizations can automate billing processes confidently, reduce manual effort, and maintain accurate customer and payment data across Salesforce, Stripe, and QuickBooks. This approach ensures that payment workflows are not only functional but also scalable and resilient as business needs grow.

Designing Salesforce Payment Workflows with QuickBooks and Stripe (Part: 1)

Guess blog by: Antonina Kharchenko

Introduction: Understanding Salesforce Payment Workflows

Managing client records and financial data across Salesforce and external systems is complex. Client data exists in Salesforce, but to create subscriptions, invoices, or records in Stripe or QuickBooks, teams often rely on spreadsheets, CSV exports, or emails. When a client updates an address, email, or billing detail, these changes must be manually reflected in Stripe or QuickBooks, increasing the chance of errors and delays.

Most business applications remain isolated: only about 29% of systems are integrated, and 95% of IT leaders report challenges with data integration. These disconnected systems force teams to rely on manual data transfers like spreadsheets and emails when synchronizing client records between Salesforce, payment providers, and accounting platforms.

This article focuses on how to design reliable payment workflows in Salesforce when integrating with systems like Stripe or QuickBooks. We’ll explore how to structure objects, define workflow triggers, model integration fields, and automate billing-related processes so that customer records, subscriptions, and invoices stay aligned across systems. These design principles help reduce manual work, improve data consistency, and support scalable billing workflows directly from Salesforce.

Designing Salesforce Payment Workflows

Payment Process, image from Breadwinner

A payment workflow in Salesforce is more than building Stripe or QuickBooks to Salesforce integration. It’s about structuring objects, fields, and automation so that client data, subscriptions, and invoices are created and updated reliably. Proper workflow design reduces manual work, ensures data consistency, and makes integration predictable.

1. Define the Workflow Triggers

• Choose the initiating events: Typically, a workflow begins with a Salesforce object changing state. For example:
• A new Account or Contact is created → trigger client provisioning in Stripe or QuickBooks.
• An Opportunity ready for billing → trigger subscription creation or invoice generation.
• Determine conditional logic: Decide when the workflow should execute, such as only for specific Opportunity types, regions, or billing plans. This avoids unnecessary API calls.

2. Model Integration Fields in Salesforce

• External system IDs: Store QuickBooks or Stripe customer IDs on the Salesforce Account or Contact object. This allows reliable mapping for updates.
• Payment and subscription status: Include fields such as Subscription Status, Invoice Status, Last Payment Date, or Last Sync Timestamp. These fields make it possible to monitor workflow execution and detect failures.
• Custom fields for required external data: Map required fields from QuickBooks or Stripe that Salesforce does not track natively (e.g., tax codes, billing cycles, Stripe plan IDs).

3. Decide on Automation Tools

• Flow vs Apex:
• Flow is suitable for standard automation, like creating a subscription after an Opportunity closes, or updating a QuickBooks record when an Account changes.
• Apex may be needed for complex logic, bulk updates, or handling retries for failed API calls.
• Process orchestration: Combine Flows with scheduled or triggered updates for tasks such as:
• Periodic reconciliation of invoices.
• Updating subscription status daily from Stripe.
• Keeping Salesforce recurring payment records aligned with external payment and accounting systems

4. Map Data Flow Direction

• Single source of truth: Define which system owns each piece of data. For example, Salesforce may own client contact info, while Stripe owns subscription history.
• One-way vs two-way sync: Determine if updates flow only from Salesforce → external system, or if external changes also flow back. One-way sync is simpler and reduces conflicts, two-way sync adds visibility but requires careful conflict resolution.

5. Sequence and Error Handling

• Workflow sequence example:
• Opportunity meets billing criteria.
• Validate client data in Salesforce.
• Push the customer record to Stripe or QuickBooks.
• Create a subscription or invoice in an external system.
• Record external ID and status back in Salesforce.
• Log errors or retries if any step fails.
• Monitoring and alerts: Include fields or reports to track failed updates, partial syncs, or API errors. Set up notifications for admins so issues can be resolved quickly.

Existing Solutions to Solve the Problem in Salesforce

There are several approaches to integrating Salesforce with financial systems to manage client data, subscriptions, and Stripe payments Salesforce. Each approach comes with trade-offs in terms of effort, reliability, and maintainability.

Summary: Each integration of Salesforce payment solutions has strengths and limitations. Organizations should weigh ease of setup, level of automation, and long-term maintainability when selecting a solution, for example to integrate QuickBooks with Salesforce.

Step-by-Step: Managing Salesforce Payment Workflows

To demonstrate how Salesforce payment workflows can be implemented, we reviewed available solutions on the AppExchange. Building a custom integration or using middleware would require more development time and maintenance. Prebuilt solutions provide a quicker way to get started while still illustrating the core workflow concepts. 

Salesforce Stripe integrations on AppExchange

After evaluating options, we selected Breadwinner, which can connect Salesforce with QuickBooks or Stripe. For this guide, we’ll use the Salesforce Payments Stripe app as an example.

Payments Integration on AppExchange

The focus of this guide is on synchronizing client records, creating subscriptions, and handling updates reliably, ensuring Salesforce remains aligned with the external system.

Step 1: Install the App

Install the Breadwinner Payments Integration from AppExchange into your Salesforce org. Assign the required permissions to integration users and admins as per the app’s setup guide.

Get the app

Step 2: Connect the Stripe

Use the app’s authentication flow to link a Stripe account. This establishes a secure connection so Salesforce can push and receive data.

Connect with a Payment Processor

Step 3: Configure Object Mappings

Map Salesforce objects (Accounts, Contacts, Opportunities, or custom objects) to Stripe customers and subscriptions. Identify which fields from Salesforce will populate the corresponding Stripe fields, such as email, billing address, and subscription plan.

Example of Associated Salesforce Account

Step 4: Test Synchronization

Test the workflow with a small set of records. Verify that client records, subscriptions, and related data are created correctly in Stripe and that updates in Salesforce are reflected as expected.

Create an Invoice or Subscription from Salesforce

Step 5: Monitor and Refine

Use app-provided logs and Salesforce reports to monitor workflow execution. Check for errors, partial syncs, or missing data, and adjust field mappings, triggers, or validation rules as needed.

Key Takeaway: Using a prebuilt AppExchange app allows you to connect Salesforce to an external system, synchronize client records, and automate subscription or invoice creation, keeping both systems aligned without complex coding.

Agentforce and Payment Integrations

Payment integrations can also support automation through Agentforce. When billing and payment data from Stripe or QuickBooks is synchronized with Salesforce, Agentforce can use this data to trigger workflows, update account status, or initiate follow-up actions based on payment activity.

Breadwinner provides integration apps listed on AgentExchange, the marketplace for Agentforce extensions within Salesforce. These apps allow synchronized financial data to be used reliably in Agentforce workflows and automation.

Breadwinner on AgentExchange

In practice, this type of setup allows teams to manage billing workflows directly from Salesforce, while payment processing and financial records remain managed in external systems such as Stripe or QuickBooks.

Closing Thoughts: Building Reliable Salesforce Payment Workflows

Payment integrations are not only about connecting systems, they are about designing workflows that keep customer, subscription, and financial data consistent across platforms.

When Salesforce is used as the operational hub for sales and customer management, integrations with platforms like Stripe and QuickBooks make it possible to automate billing processes while maintaining a clear and reliable source of truth for different types of data.

The key principles discussed in this article help reduce manual work and improve data reliability across systems. Whether organizations choose prebuilt AppExchange applications, middleware platforms, or custom integrations, the most successful implementations start with well-designed workflows inside Salesforce.

In the next article, we’ll explore the operational side of Salesforce payment workflows in more detail, including common integration challenges, typical failure scenarios, and practical recommendations for building stable and secure payment integrations.