Page 4

How to Mask Sensitive Data in Sync Logs for QuickBooks Online and QuickBooks Desktop in DBSync

1. Summary / Introduction

This article outlines the process for masking sensitive data in sync logs for both QuickBooks Online (QBO) and QuickBooks Desktop (QBD) within DBSync. It ensures that confidential fields (such as those containing PII or client-defined sensitive information) are not exposed in logs, enhancing data privacy and security compliance.

2. Problem / Issue

Clients may identify specific fields in their integration workflows that contain sensitive information (e.g., customer notes, internal IDs) that should not be visible in DBSync logs. By default, these fields may appear in sync logs unless explicitly masked, potentially posing a data exposure risk.

3. Environment / Applies To

Product/Service: DBSync Cloud Workflow

Versions: All versions

Operating Systems: Platform-independent (Cloud-based)

Connectors: QuickBooks Online, QuickBooks Desktop

Use Case: Masking sensitive fields in logs for compliance and privacy

4. Solution / Steps

Prerequisites:

Admin access to DBSync

Field-level knowledge of sensitive data from the client

The field names (API field names) confirmed by the client

Steps:

Step 1:

Log in to DBSync and open the Integration Project that syncs data to or from QuickBooks Online/QuickBooks Desktop.

Step 2:

Identify and confirm the Connector used in the active project where the sync logs are generated.

Step 3:

Click on the connector to go to its Connector Detail Page.

Step 4:

Click on the Log Settings tab (or section) available on the connector configuration page.

Step 5:

Locate the “Mask Fields” section and a corresponding textbox.

Step 6:

In the textbox, enter each field name (API field name) that needs to be masked — one per line.

For example:

CustomerMemo

PrivateNote

Notes__c

Step 7:

Save the configuration.

5. Workaround (If Applicable)

If the client cannot provide the field names immediately, advise them to provide

Review previous logs to spot where sensitive data appears

6. Root Cause

The DBSync platform logs all field values by default unless configured otherwise. If sensitive fields are not added to the "Mask Fields" setting, they may appear in logs accessible to DBSync support personnel and admins.

QuickBooks Desktop

QuickBooks Online