Automated PayPal Sales reconciliation to QuickBooks Online (Make.com)

Eliminate manual bookkeeping by automatically syncing PayPal transactions, fees, and customer data to QuickBooks via Make.com.

Tools: PayPal → QuickBooks

Platform: Make.com

Short Answer

Every PayPal sale triggers a real-time workflow in Make.com that searches for/creates customers and generates a Sales Receipt. This records the full gross revenue while accurately categorizing the transaction fee as a bank expense, ensuring your books are audit-ready.

The Problem

Manual entry of PayPal transactions into QuickBooks often ignores the gross-vs-net distinction, leading to inaccurate sales tax reports and unrecorded merchant fees. High-volume businesses struggle to reconcile the 'PayPal Bank' balance against real-world disbursements.

The Outcome

Every PayPal sale triggers a real-time workflow in Make.com that searches for/creates customers and generates a Sales Receipt. This records the full gross revenue while accurately categorizing the transaction fee as a bank expense, ensuring your books are audit-ready.

Step-by-Step Guide

1. **Create Scenario:** Open Make.com and create a new scenario titled 'PayPal to QBO Sync'. 2. **Trigger Module:** Add the **PayPal > Watch Transactions** module. Create a connection using your PayPal Rest API credentials (Client ID and Secret). Set the status to 'Success'. 3. **Add Router:** Connect a Router module to filter only for 'S' (Sale) or 'T' (Transfer) types to avoid syncing internal adjustments unless desired. 4. **Search Customer:** Add the **QuickBooks Online > Search for a Customer** module. Map the `Payer Email` from PayPal to the `Email` field in QBO. 5. **Create Customer (Conditional):** Right-click the Search module, select 'Add error handler' (Ignore) OR use a Filter on the next module. If 'Total number of bundles' is 0, route to **QuickBooks Online > Create a Customer** using PayPal's Name and Email data. 6. **Create Sales Receipt:** Add **QuickBooks Online > Create a Sales Receipt**. Map `Gross Amount` to the line item. Use `Transaction ID` for the Reference Number. Set the 'Deposit To' account to your 'PayPal Clearing' Asset account. 7. **Record Fees:** Add **QuickBooks Online > Create an Expense**. Map the `Fee Amount` from PayPal to your 'Bank Service Charges' account. This ensures the Net amount in QBO matches the Net amount in your PayPal balance. 8. **Error Handling:** Right-click the QBO modules and select 'Add Error Handler'. Use the **Break** directive to store failed executions for manual review without stopping the entire scenario. 9. **Schedule:** Click the clock icon on the Trigger and set the interval (e.g., every 15 minutes) or set to 'Immediately' if using Webhooks.