How to Automate Paystack Payment Reconciliation with n8n

Payment reconciliation is the most time-consuming finance task in any Nigerian business. Every morning someone on your team logs into Paystack, exports the transaction CSV, opens Google Sheets, cross-checks bank deposits against invoices, manually marks payments as settled, and emails receipts — if they get to it at all.

A business processing 100+ monthly transactions through Paystack can easily spend 10–15 hours per week on reconciliation alone. That's time that could be spent on growth, product development, or serving customers.

This guide walks you through 5 production-ready n8n workflows that fully automate Paystack payment reconciliation. By the end, you'll have a system that captures every payment in real time, generates invoices automatically, sends branded receipts, and produces a daily reconciliation report — without anyone touching a spreadsheet.

These workflows are included in the Selazone Automation Vault, which ships 36 n8n workflows, 10 SOPs, and 200 AI prompts for Nigerian businesses.

Why Reconciliation Automation Matters in Nigeria

Nigerian businesses face unique payment reconciliation challenges that off-the-shelf accounting software doesn't solve well:

• Multiple payment channels — Paystack, bank transfers, POS terminals, USSD, and increasingly Flutterwave. Each has its own settlement timeline
• Bank settlement delays — Paystack batches settlements to your bank account on a T+1 schedule. Individual transaction statuses change as they settle, and you need to track which ones have cleared
• Partial payments and instalments — Common in Nigerian B2B transactions, where clients pay in chunks. Manual tracking is error-prone
• Audit and tax requirements — FIRS and state tax authorities expect clean, auditable records. Spreadsheets with manual entries won't hold up under scrutiny
• Chargebacks and failed re-attempts — Paystack's retry logic means a "failed" transaction may succeed later. Your reconciliation system must handle these edge cases automatically

A proper reconciliation automation system solves all of these. Let's build it with n8n.

What You'll Need

Before diving into the workflows, make sure you have these ready:

• Paystack account — with live API keys (secret key and public key). You'll need webhook access, available on all Paystack plans
• n8n instance — self-hosted on a VPS (starting at about $5/month) or n8n.cloud free tier
• Google Cloud project — for Google Sheets and Gmail API access (free tier is sufficient)
• Airtable account — optional but recommended for the reconciliation ledger (free tier)
• SMTP or email API — for automated invoice and receipt emails. Gmail (free) or SendGrid (free tier) works well

Workflow 1: Capture Paystack Payments in Real Time

Every reconciliation system starts with a reliable payment capture mechanism. Paystack sends webhook events for every transaction event — charge success, transfer success, refund processed, and more. You'll use these as the trigger for your entire pipeline.

How it works: Paystack sends a POST request to your n8n webhook URL every time a transaction status changes. n8n receives the payload, validates the webhook signature (critical for security — verify the HMAC-SHA512 hash against your secret key), and extracts the relevant transaction data: amount, customer email, customer name, reference, channel (card, bank transfer, USSD), status, and paid_at timestamp.

The workflow then writes this data to two destinations simultaneously:

• Google Sheets — a master payments log with columns for date, reference, customer, amount (₦), channel, status, invoice sent, and receipt sent
• Airtable — a structured reconciliation ledger with the same data plus computed fields for settlement status, batch ID, and reconciliation flag

This workflow runs in under 2 seconds per transaction. From the moment a customer taps "Pay" on your checkout page to the moment the record appears in your sheet, the lag is typically less than 5 seconds.

Workflow 2: Automatic Invoice Generation

Once payment is captured, your customer needs a proper invoice. Not a payment receipt — an invoice with your business details, Tax Identification Number (TIN), VAT breakdown, and a clear description of goods or services.

How it works: This workflow triggers when the Google Sheets row is created (or on a short polling interval). It reads the transaction data and does the following:

• Looks up the customer in an existing customer database (Airtable or Google Sheets). If new, creates a customer profile with their email, name, and phone number
• Generates an invoice number using a sequential ID format (e.g., INV-2026-00142)
• Calculates VAT (7.5% of the invoice subtotal — standard Nigerian rate) if applicable
• Creates an invoice document using a Google Docs template or an HTML-to-PDF service (like Gotenberg or PDF.co)
• Saves the invoice PDF to Google Drive
• Records the invoice reference in the master payments log

The result is a professional, tax-compliant invoice generated automatically within 30 seconds of payment confirmation.

Workflow 3: Branded Payment Receipt Emails

Beyond invoices, customers expect a payment receipt — a confirmation that their money has been received. This builds trust and reduces support tickets asking "Did my payment go through?"

How it works: After the invoice is generated, this workflow composes a payment receipt email using an HTML template with your brand colours, logo, and transaction details. The email includes:

• Transaction reference and amount paid
• Date and time of payment
• Payment channel (card, bank transfer, USSD)
• Invoice PDF as an attachment
• Receipt number
• Customer support contact information

The email is sent via Gmail API (or SMTP) using n8n's email node. A BCC copy is sent to your finance team for their records. The workflow then updates the Google Sheets row to mark "Receipt Sent" as YES.

For Nigerian businesses, we recommend including your company's RC number and TIN in the receipt footer — it signals professionalism and is required by some corporate customers for their own accounts payable processes.

Workflow 4: Daily Reconciliation Report

This is where the magic happens. While the first three workflows handle individual transactions in real time, Workflow 4 gives you the bird's-eye view your finance team needs.

How it works: A scheduled workflow runs every morning at 7 AM (before your finance team arrives). It does the following:

• Queries the Airtable reconciliation ledger for all transactions from the previous day
• Fetches settlement data from Paystack's API to confirm which transactions have been settled to your bank account
• Matches each settled transaction against bank deposits (you can upload a CSV statement or connect a Plaid-like aggregator)
• Flags three categories: Matched (paid, invoiced, receipted, settled), Pending Settlement (paid but not yet settled by Paystack), and Exception (paid but no matching bank deposit — investigate)
• Computes daily totals: gross revenue, Paystack fees (1.5% + ₦100 for local cards), net settlement expected, and outstanding receivables
• Compiles the data into a formatted email report with an HTML table and sends it to the finance team and CEO

The report also includes a summary of any failed charge attempts, refunds processed, and transactions with missing customer data. This single workflow eliminates the need for anyone to manually reconcile payments ever again.

Workflow 5: Flutterwave Alternative — Payment Capture via Webhook

Many Nigerian businesses operate on both Paystack and Flutterwave, either as redundancy or to reach customers who prefer one over the other. This workflow mirrors Workflow 1 but for Flutterwave payment notifications.

How it works: Flutterwave sends webhook events (charge.completed) to a separate n8n webhook URL. The workflow validates Flutterwave's webhook signature (using the secret hash), normalises the payload into the same format your reconciliation ledger expects, and sends the data to the same Google Sheets and Airtable destinations as Workflow 1.

Because the data schema is normalised upfront, Workflows 2, 3, and 4 work identically whether the payment came from Paystack or Flutterwave. Your reconciliation ledger sees a unified view of all payment channels.

Putting It All Together: The Complete Pipeline

Here's how the five workflows interact in a typical day of operations:

1. Customer pays via Paystack checkout at 2:15 PM
2. Workflow 1 fires — captures the transaction, logs it to Google Sheets and Airtable within 5 seconds
3. Workflow 2 fires — generates an invoice with VAT, saves the PDF to Google Drive, records the invoice reference
4. Workflow 3 fires — sends a branded payment receipt with invoice attached to the customer and BCCs finance
5. Workflow 4 runs the next morning at 7 AM — pulls all yesterday's transactions, matches against settlements, and emails the reconciliation report

At any point, your finance team can open the Google Sheets master log or Airtable reconciliation ledger and see the exact status of every transaction — when it was paid, whether the invoice was sent, whether the receipt was delivered, and whether it has settled to your bank account.

Real Results: What Businesses Are Saving

Businesses using this reconciliation automation pipeline report:

• 10–15 hours saved per week on manual reconciliation work
• Zero missed invoices — every transaction generates an invoice automatically
• 80% reduction in payment-related support tickets — customers get instant receipts
• Clean audit trail — every transaction is timestamped, logged, and traceable from payment to settlement
• Faster settlement tracking — know exactly which Paystack batches have cleared and which are still pending

How to Deploy These Workflows (Without Hiring a Developer)

Each of the 5 workflows above is included in the Selazone Automation Vault as a ready-to-import JSON file. Here's how to get them running in under 2 hours:

1. Set up n8n — deploy via Docker on a $5–10 VPS (DigitalOcean, Hostinger, or any Nigerian cloud provider). n8n's official Docker image makes this a single command
2. Configure Paystack webhook — go to your Paystack dashboard → Settings → Webhooks → add your n8n webhook URL for charge.success events. Paystack sends a test event you can use to verify the connection
3. Import the workflow JSON — in n8n, click Workflows → Import from File. Select the downloaded JSON. Every node, credential, and webhook URL is pre-configured
4. Connect your accounts — n8n will prompt you to authenticate with Google Sheets, Gmail, Airtable, and any other services each workflow uses
5. Customise your branding — update the email template, invoice template, and receipt HTML with your logo, colours, and business details. Each template is clearly marked in the workflow
6. Test with a ₦50 transaction — make a test payment through your checkout page. Watch the data flow through Sheets, the invoice get generated, the receipt email arrive in your inbox, and the report run the next morning
7. Activate and go live — toggle the workflow to Active. From this point forward, every transaction is handled automatically

No coding required. Each workflow comes with a step-by-step implementation guide written for non-technical business owners and operations managers.

Get All 5 Workflows Pre-Built in the Selazone Vault

The 5 reconciliation workflows in this guide are part of a larger collection: 36 n8n workflows, 10 corporate SOPs, 200 AI business prompts, automation audit tools, and a client acquisition kit — all in one vault built specifically for Nigerian businesses.

Every workflow ships as a ready-to-import JSON file. Import into n8n, connect your API keys, and activate. Implementation guides walk you through every step, from webhook configuration to customising invoice templates.

The vault includes dedicated invoice automation and payment receipt workflows that integrate directly with the reconciliation pipeline described in this guide.