Automated PayPal Sales and Fee Reconciliation to QuickBooks Online (Make.com)

Streamline accounting by syncing payments, customers, and merchant fees automatically via Make.com scenarios.

Tools: PayPal → QuickBooks

Platform: Make.com

Short Answer

A fully automated Make.com scenario that creates customers and detailed sales receipts in QuickBooks. It automatically accounts for PayPal fees as separate line items, ensuring your 'PayPal Clearing' bank account balances perfectly every time.

The Problem

Manual entry of PayPal transactions into QuickBooks is prone to error and often misses transaction fees, leading to reconciliation discrepancies. Businesses Struggle to match PayPal's gross receipts with the net amounts hitting their clearing accounts.

The Outcome

A fully automated Make.com scenario that creates customers and detailed sales receipts in QuickBooks. It automatically accounts for PayPal fees as separate line items, ensuring your 'PayPal Clearing' bank account balances perfectly every time.

Step-by-Step Guide

1. **Establish Connections**: In Make.com, create a new scenario. Add the **PayPal** module and connect using your PayPal Developer Client ID and Secret. Add the **QuickBooks Online** module and authorize your Intuit account. 2. **Trigger Step**: Add the **PayPal > Watch Transactions** module. Set the 'Limit' to 10 for initial testing. This will poll PayPal for new successful events. 3. **Search for Existing Customer**: Add the **QuickBooks Online > Search for Customers** module. Use the Filter menu to search where `Email` equals the `Payer Email` from PayPal. This prevents duplicate customer profiles. 4. **Conditional Logic (Router)**: Add a **Router**. - Path A: If the search result from Step 3 is empty, add **QuickBooks Online > Create a Customer** mapping the Payer Name and Email. - Path B: If the search result exists, proceed directly to the next step. 5. **Calculate Net and Fees**: Use a **Tools > Set Variable** module to handle currency conversion or fee calculation if needed. Specifically, use the formula `{{add(transaction.amount; transaction.fee)}}` to verify the gross total. 6. **Create Sales Receipt**: Add the **QuickBooks Online > Create a Sales Receipt** module. - Map `Customer Ref` to the ID from Step 3 or 4. - Set `Deposit to Account` to your 'PayPal Clearing' bank account. - Add two line items: - Line 1: Gross Sales (Positive Amount). - Line 2: PayPal Fee (Negative Amount mapped to your 'Merchant Fees' expense account). 7. **Duplicate Prevention (Data Store)**: Add a **Data Store > Add/replace a record** module at the end. Use the PayPal `Transaction ID` as the Key. Add a **Filter** before the QuickBooks modules to only proceed if the `Transaction ID` does *not* exist in the Data Store. 8. **Error Handling**: Right-click the QuickBooks modules and select **Add error handler**. Choose the `Ignore` or `Commit` directive to ensure the scenario doesn't stop if a single transaction fails due to a locked period in QuickBooks.