{
  "name": "Multi-platform revenue reconciliation across Stripe, PayPal & bank with tax archive",
  "nodes": [
    {
      "id": "bbb0bbe0-fd8f-46cd-bd2f-c4826efcca19",
      "name": "Monthly Schedule",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -448,
        192
      ]
    },
    {
      "id": "6d08da53-983a-438c-b164-ff86ce7c1b47",
      "name": "Workflow Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        -224,
        192
      ]
    },
    {
      "id": "ead117d5-1bee-4c3f-bd93-1810f7f9600a",
      "name": "Get Stripe Revenue",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        0,
        0
      ]
    },
    {
      "id": "43052c70-6f3f-49b7-aa1a-22f8db32790d",
      "name": "Get PayPal Revenue",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        0,
        192
      ]
    },
    {
      "id": "8efb034f-82d7-43db-aa89-96ca9bb14f63",
      "name": "Get Bank Statements",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        224,
        384
      ]
    },
    {
      "id": "ba8740a8-2dcb-4513-94e0-047e96cc0f26",
      "name": "Normalize Stripe Data",
      "type": "n8n-nodes-base.set",
      "position": [
        224,
        0
      ]
    },
    {
      "id": "131da027-2258-4957-a297-c232325e4ea5",
      "name": "Normalize PayPal Data",
      "type": "n8n-nodes-base.set",
      "position": [
        224,
        192
      ]
    },
    {
      "id": "ac495591-815b-4443-a661-be7aa94af167",
      "name": "Normalize Bank Data",
      "type": "n8n-nodes-base.set",
      "position": [
        448,
        384
      ]
    },
    {
      "id": "6e01a2e2-2224-441c-983e-91ed044382ee",
      "name": "Combine Revenue Sources",
      "type": "n8n-nodes-base.merge",
      "position": [
        448,
        96
      ]
    },
    {
      "id": "a2d97894-1d5d-48b0-a05d-26a2bf3db021",
      "name": "Reconcile Revenue vs Bank",
      "type": "n8n-nodes-base.code",
      "position": [
        672,
        192
      ]
    },
    {
      "id": "dfdd2e11-c8f1-4504-b13e-d7137c59b2a1",
      "name": "Check for Mismatches",
      "type": "n8n-nodes-base.if",
      "position": [
        896,
        192
      ]
    },
    {
      "id": "858def70-5a67-4b79-8c2a-e3528082f850",
      "name": "Flag Mismatches",
      "type": "n8n-nodes-base.set",
      "position": [
        1120,
        128
      ]
    },
    {
      "id": "c907f41d-c860-4d1a-8708-d26a62dc4786",
      "name": "Aggregate Monthly Data",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1344,
        192
      ]
    },
    {
      "id": "c64b6ad1-cc8e-4dc7-bc93-7598b0379e8e",
      "name": "Generate Audit Report",
      "type": "n8n-nodes-base.code",
      "position": [
        1568,
        192
      ]
    },
    {
      "id": "511a0aa7-79b0-4a62-a21c-daee9e7796f3",
      "name": "Upload to Archive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1792,
        192
      ]
    },
    {
      "id": "f11ee402-4b02-49d6-869f-fbcd9a151fd0",
      "name": "Notify Tax Agent",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2016,
        192
      ]
    },
    {
      "id": "22bc4a46-41f2-409a-8376-1f7b8081f26f",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        896,
        -416
      ],
      "parameters": {
        "width": 720,
        "height": 288,
        "content": "## Prerequisites\nStripe, PayPal, and bank statement accounts; API credentials for each source \n## Use Cases\nAccounting firms automating client revenue verification; multi-channel e-commerce businesses"
      }
    },
    {
      "id": "ebd4913f-814c-4fdd-bc36-41f3b187f965",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        384,
        -352
      ],
      "parameters": {
        "width": 464,
        "height": 208,
        "content": "## Setup Steps\n1. Configure Stripe, PayPal.\n2. Set up normalization rules for date, currency, and transaction ID mappings.\n3. Connect Google Drive for report archiving and Gmail for agent notification"
      }
    },
    {
      "id": "f04bccea-bc33-465f-a9cf-c83c55420662",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -448,
        -352
      ],
      "parameters": {
        "width": 800,
        "height": 224,
        "content": "## How It Works\nThis workflow automates monthly revenue reconciliation across Stripe, PayPal, and bank statements by standardizing data formats, detecting discrepancies, and producing audit-ready repo"
      }
    },
    {
      "id": "71f605f8-f4e9-4bc5-bd86-13f1e375cff0",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1504,
        -96
      ],
      "parameters": {
        "width": 656,
        "height": 688,
        "content": "## Generate Audit Report & Notification\nWhat: Compiles flagged mismatches, monthly aggregates into audit documentation.\nWhy: Provides compliance evidence, supports tax filing \n"
      }
    },
    {
      "id": "99a328fb-27cb-4781-a415-bc349e543a1b",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        -96
      ],
      "parameters": {
        "width": 1120,
        "height": 704,
        "content": "## Reconcile & Flag Mismatches\nWhat: Compares aggregated revenue against bank statement totals and identifies discrepancies.\nWhy: Detects timing differences, missing transactions, and potential fraud "
      }
    },
    {
      "id": "1595a83a-4df7-46b6-91bc-7bde3fe23798",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -496,
        -96
      ],
      "parameters": {
        "width": 848,
        "height": 672,
        "content": "## Fetch Multi-Source Data\nWhat: Retrieves revenue records from Stripe, PayPal, and bank statements in parallel.\nWhy: Captures complete revenue picture across all payment and settlement channels."
      }
    }
  ],
  "connections": {
    "Flag Mismatches": {
      "main": [
        [
          {
            "node": "Aggregate Monthly Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Monthly Schedule": {
      "main": [
        [
          {
            "node": "Workflow Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload to Archive": {
      "main": [
        [
          {
            "node": "Notify Tax Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get PayPal Revenue": {
      "main": [
        [
          {
            "node": "Normalize PayPal Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Stripe Revenue": {
      "main": [
        [
          {
            "node": "Normalize Stripe Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Bank Statements": {
      "main": [
        [
          {
            "node": "Normalize Bank Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Bank Data": {
      "main": [
        [
          {
            "node": "Reconcile Revenue vs Bank",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check for Mismatches": {
      "main": [
        [
          {
            "node": "Flag Mismatches",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Aggregate Monthly Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Audit Report": {
      "main": [
        [
          {
            "node": "Upload to Archive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize PayPal Data": {
      "main": [
        [
          {
            "node": "Combine Revenue Sources",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Normalize Stripe Data": {
      "main": [
        [
          {
            "node": "Combine Revenue Sources",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate Monthly Data": {
      "main": [
        [
          {
            "node": "Generate Audit Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Workflow Configuration": {
      "main": [
        [
          {
            "node": "Get Stripe Revenue",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get PayPal Revenue",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Bank Statements",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine Revenue Sources": {
      "main": [
        [
          {
            "node": "Reconcile Revenue vs Bank",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Reconcile Revenue vs Bank": {
      "main": [
        [
          {
            "node": "Check for Mismatches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}