MatchRecon Documentation

Overview

Custom Reports allow you to build tailored reports using 30+ pre-built templates or create your own from scratch. Configure data sources, apply filters, schedule automatic delivery, and export in multiple formats (PDF, Excel, CSV).

Step-by-Step Setup

1. 1

   Navigate to Reports

   Dashboard → Reports → Create New Report

2. 2

   Choose a Template

   Select from 30+ templates: Match Summary, Exception Report, Vendor Analysis, etc.

3. 3

   Configure Filters

   Set date ranges, vendors, amounts, match status, and custom fields

4. 4

   Customize Layout

   Drag-and-drop columns, add charts, configure grouping and sorting

5. 5

   Schedule Delivery (Optional)

   Set frequency (daily, weekly, monthly), recipients, and delivery time

API Usage

POST /api/reports
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "name": "Monthly Vendor Report",
  "template": "vendor-analysis",
  "filters": {
    "dateRange": {
      "start": "2024-01-01",
      "end": "2024-01-31"
    },
    "vendors": ["vendor-123", "vendor-456"],
    "minAmount": 1000
  },
  "schedule": {
    "frequency": "monthly",
    "dayOfMonth": 1,
    "time": "09:00",
    "timezone": "America/New_York",
    "recipients": ["finance@company.com"]
  },
  "format": "pdf"
}

Response 200 OK:
{
  "reportId": "rpt_abc123",
  "status": "scheduled",
  "nextRun": "2024-02-01T09:00:00Z",
  "downloadUrl": "/api/reports/rpt_abc123/download"
}

Configuration Options

Common Issues & Solutions

Overview

Multi-Currency Support enables reconciliation of transactions across 20+ currencies. The system uses real-time exchange rates from ExchangeRate-API and automatically converts amounts to your base currency for matching. Track foreign exchange variances and generate multi-currency reports.

Step-by-Step Setup

1. 1

   Set Base Currency

   Settings → Currency → Select your primary accounting currency (USD, EUR, GBP, etc.)

2. 2

   Enable Exchange Rate API

   Settings → Integrations → ExchangeRate-API → Enter your API key (free tier available)

3. 3

   Configure Rate Update Frequency

   Choose: Real-time (every match), Hourly, Daily, or Manual update schedule

4. 4

   Upload Multi-Currency Data

   Upload invoices/statements with currency codes (ISO 4217) in file or column headers

5. 5

   Review FX Variance Reports

   Reports → Multi-Currency Analysis to view exchange rate impact on matches

API Usage

POST /api/currency/configure
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "baseCurrency": "USD",
  "exchangeRateProvider": "exchangerate-api",
  "apiKey": "your_api_key",
  "updateFrequency": "hourly",
  "varianceThreshold": 0.05
}

Response 200 OK:
{
  "currencyConfigId": "curr_abc123",
  "baseCurrency": "USD",
  "supportedCurrencies": ["EUR", "GBP", "CAD", ...],
  "lastRateUpdate": "2024-01-15T10:30:00Z"
}

Configuration Options

Common Issues & Solutions

Overview

Payment Gateway Integration connects directly to Stripe and PayPal accounts to automatically import transaction data. Uses secure OAuth2 authentication and syncs payments in real-time or on scheduled intervals. Eliminates manual CSV exports from payment dashboards.

Step-by-Step Setup

1. 1

   Navigate to Integrations

   Dashboard → Settings → Integrations → Payment Gateways

2. 2

   Connect Stripe or PayPal

   Click "Connect Stripe" or "Connect PayPal" → Authorize via OAuth2 (redirects to gateway login)

3. 3

   Configure Sync Settings

   Set sync frequency: Real-time (webhooks), Hourly, Daily. Choose transaction types to import.

4. 4

   Test Connection

   Click "Test Import" to verify connection and import last 10 transactions

5. 5

   Enable Auto-Reconciliation

   Toggle "Auto-match imported transactions" to automatically reconcile against uploaded invoices

API Usage

POST /api/payment-gateways/stripe/connect
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "authorizationCode": "stripe_oauth_code",
  "syncFrequency": "realtime",
  "transactionTypes": ["payment", "refund"],
  "autoReconcile": true
}

Response 200 OK:
{
  "integrationId": "int_stripe_abc123",
  "status": "connected",
  "accountId": "acct_1234567890",
  "lastSync": "2024-01-15T10:30:00Z",
  "transactionCount": 1247
}

Configuration Options

Common Issues & Solutions

Overview

AI-powered Cash Flow Forecasting analyzes historical transaction patterns to predict future cash positions. Uses machine learning models trained on your reconciliation data to generate 30, 60, and 90-day projections. Identifies seasonal trends, recurring expenses, and payment timing patterns.

Step-by-Step Setup

1. 1

   Ensure Sufficient Historical Data

   Minimum 3 months of reconciled transactions required. 12+ months recommended for accurate forecasting.

2. 2

   Enable Cash Flow Forecasting

   Dashboard → Analytics → Cash Flow → Enable Forecasting

3. 3

   Train the Model

   Click "Train Model" to analyze historical patterns. Initial training takes 2-5 minutes.

4. 4

   Configure Forecast Parameters

   Set forecast horizon (30/60/90 days), confidence intervals, and scenario assumptions

5. 5

   Review and Export Forecasts

   View interactive charts, export to Excel/PDF, or schedule automated forecast reports

API Usage

POST /api/cashflow-forecast
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "horizon": 90,
  "confidenceInterval": 0.95,
  "includeRecurring": true,
  "scenarioAdjustments": {
    "expectedRevenue": 50000,
    "expectedExpenses": 30000
  }
}

Response 200 OK:
{
  "forecastId": "fcst_abc123",
  "projections": [
    {"date": "2024-02-15", "balance": 125430, "confidence": 0.89},
    {"date": "2024-03-15", "balance": 142180, "confidence": 0.82}
  ],
  "trends": ["seasonal_increase_q1", "recurring_payments_detected"],
  "accuracy": 0.87
}

Configuration Options

Common Issues & Solutions

Overview

Batch Processing enables high-volume reconciliation of millions of transactions using parallel processing architecture. Schedule automatic processing windows during off-peak hours, process large files (up to 10GB), and monitor batch jobs with real-time progress tracking. Ideal for month-end close operations.

Step-by-Step Setup

1. 1

   Enable Batch Processing Mode

   Settings → Processing → Enable "Batch Processing for Large Datasets"

2. 2

   Configure Processing Windows

   Set preferred processing times (e.g., 2 AM - 6 AM) to avoid peak usage hours

3. 3

   Upload Files for Batch Job

   Upload → Select "Batch Upload" → Add multiple large files (CSV, Excel, PDF)

4. 4

   Configure Batch Parameters

   Set chunk size, parallel threads, error handling mode (stop/continue on error)

5. 5

   Monitor Job Progress

   Dashboard → Batch Jobs → View real-time progress, estimated completion time, and logs

API Usage

POST /api/batch/create
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "name": "Month-End January 2024",
  "files": ["file_abc123", "file_def456"],
  "chunkSize": 10000,
  "parallelThreads": 8,
  "errorHandling": "continue",
  "scheduledStart": "2024-02-01T02:00:00Z"
}

Response 200 OK:
{
  "batchId": "batch_xyz789",
  "status": "scheduled",
  "totalRecords": 2500000,
  "estimatedDuration": "45 minutes",
  "scheduledStart": "2024-02-01T02:00:00Z"
}

Configuration Options

Common Issues & Solutions

Overview

Variance Analysis automatically detects and analyzes amount discrepancies between invoices and payments. Set custom thresholds by vendor, category, or amount range. Track variance trends over time and generate alerts when thresholds are exceeded. Helps identify pricing errors, unauthorized discounts, or payment processing issues.

Step-by-Step Setup

1. 1

   Enable Variance Detection

   Settings → Matching Rules → Enable "Variance Analysis"

2. 2

   Set Global Threshold

   Define default variance threshold: percentage (e.g., 5%) or absolute amount (e.g., $10)

3. 3

   Configure Vendor-Specific Rules

   Settings → Variance Rules → Add vendor overrides for known discount terms or payment patterns

4. 4

   Enable Alerts

   Configure email/Slack alerts for variances exceeding critical thresholds

5. 5

   Review Variance Reports

   Dashboard → Analytics → Variance Trends to view historical patterns and top variance sources

API Usage

POST /api/variance-analysis
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "globalThreshold": {
    "percentage": 5.0,
    "absoluteAmount": 10.00
  },
  "vendorRules": [
    {
      "vendorId": "vendor_123",
      "threshold": 2.0,
      "allowEarlyPaymentDiscount": true
    }
  ],
  "alertLevel": "medium"
}

Response 200 OK:
{
  "configId": "var_config_abc123",
  "activeRules": 12,
  "detectedVariances": 47,
  "averageVariancePercentage": 2.3
}

Configuration Options

Common Issues & Solutions

Overview

Duplicate Detection uses fuzzy matching algorithms to identify duplicate invoices and transactions that may have been uploaded multiple times or processed twice. Automatically flags potential duplicates and provides merge or dismiss actions. Prevents double payment and ensures data integrity.

Step-by-Step Setup

1. 1

   Enable Duplicate Detection

   Settings → Matching Rules → Enable "Automatic Duplicate Detection"

2. 2

   Configure Matching Criteria

   Set which fields to compare: amount, date, vendor, invoice number. Choose similarity threshold (default: 95%)

3. 3

   Set Time Window

   Define lookback period for duplicate checking (e.g., 90 days) to avoid false positives from recurring charges

4. 4

   Configure Actions

   Choose automatic action: flag for review, auto-merge, or auto-dismiss based on confidence level

5. 5

   Review Flagged Duplicates

   Dashboard → Exceptions → Duplicates tab to review and resolve flagged items

API Usage

POST /api/duplicates/detect
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "scanScope": "all",
  "matchFields": ["amount", "vendor", "invoiceNumber", "date"],
  "similarityThreshold": 0.95,
  "timeWindow": 90,
  "autoAction": "flag"
}

Response 200 OK:
{
  "scanId": "scan_abc123",
  "duplicatesFound": 23,
  "potentialDuplicates": 7,
  "duplicatePairs": [
    {"id1": "inv_001", "id2": "inv_045", "similarity": 0.98, "status": "flagged"}
  ]
}

Configuration Options

Common Issues & Solutions

Overview

Zapier Integration connects MatchRecon with 5,000+ apps including QuickBooks, Salesforce, Slack, Gmail, Google Sheets, and more. Create automated workflows (Zaps) that trigger on reconciliation events. Sync data bidirectionally without coding. Perfect for custom integrations and workflow automation.

Step-by-Step Setup

1. 1

   Get Your API Key

   Settings → Integrations → API Keys → Generate new key for Zapier

2. 2

   Connect to Zapier

   Visit zapier.com → Search "MatchRecon" → Connect account using API key

3. 3

   Create Your First Zap

   Choose trigger (e.g., "New Match Created") and action (e.g., "Send Slack Message")

4. 4

   Configure Zap Logic

   Map data fields, add filters, set conditions for when Zap should run

5. 5

   Test and Enable

   Test Zap with sample data, verify output, then turn on to activate automation

API Usage

POST /api/zapier/subscribe
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "targetUrl": "https://hooks.zapier.com/hooks/catch/...",
  "events": ["match.created", "exception.flagged"],
  "filters": {
    "minAmount": 1000,
    "vendors": ["vendor_123"]
  }
}

Response 200 OK:
{
  "subscriptionId": "sub_zapier_abc123",
  "status": "active",
  "events": ["match.created", "exception.flagged"],
  "createdAt": "2024-01-15T10:30:00Z"
}

Configuration Options

Common Issues & Solutions

Overview

Email Invoice Import allows you to forward invoices directly to your unique MatchRecon email address. System automatically extracts invoice data using OCR, processes attachments, and adds to reconciliation queue. Supports PDF attachments and inline images. Perfect for invoices received via email from vendors.

Step-by-Step Setup

1. 1

   Get Your Unique Import Email

   Settings → Email Import → Copy your unique address (e.g., invoices-abc123@matchrecon.com)

2. 2

   Configure Email Rules

   Set allowed sender domains, auto-categorization rules, and processing preferences

3. 3

   Forward Test Invoice

   Forward a sample invoice email to your import address to test OCR extraction

4. 4

   Set Up Email Forwarding Rules

   Create inbox rules to automatically forward invoices from known vendors

5. 5

   Monitor Import Queue

   Dashboard → Email Imports to view processing status and correct any OCR errors

API Usage

POST /api/email-import/configure
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "allowedDomains": ["vendor.com", "supplier.net"],
  "autoProcess": true,
  "ocrConfidenceThreshold": 0.85,
  "notifyOnImport": true,
  "defaultCategory": "vendor-invoices"
}

Response 200 OK:
{
  "importEmailAddress": "invoices-abc123@matchrecon.com",
  "status": "active",
  "allowedDomains": ["vendor.com", "supplier.net"],
  "importsToday": 47
}

Configuration Options

Common Issues & Solutions

Overview

Real-time Webhooks push notifications to your systems instantly when events occur in MatchRecon. Subscribe to events like match.created, exception.flagged, report.generated, and more. Build custom integrations and automate workflows. Uses HTTP POST with JSON payload and includes retry logic for failed deliveries.

Step-by-Step Setup

1. 1

   Create Webhook Endpoint

   Build HTTPS endpoint in your system to receive POST requests (must return 200 status)

2. 2

   Register Webhook

   Settings → Webhooks → Add New Webhook → Enter endpoint URL

3. 3

   Select Events

   Choose which events to subscribe to: matches, exceptions, reports, uploads, etc.

4. 4

   Configure Signing Secret

   Copy webhook signing secret to verify authenticity of incoming requests

5. 5

   Test and Monitor

   Send test webhook, verify receipt, monitor delivery logs for failures

API Usage

POST /api/webhooks
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "url": "https://your-domain.com/webhooks/matchrecon",
  "events": ["match.created", "exception.flagged"],
  "secret": "your_webhook_secret",
  "active": true
}

Response 200 OK:
{
  "webhookId": "wh_abc123",
  "url": "https://your-domain.com/webhooks/matchrecon",
  "events": ["match.created", "exception.flagged"],
  "status": "active",
  "createdAt": "2024-01-15T10:30:00Z"
}

Configuration Options

Common Issues & Solutions

Overview

White Label Platform allows you to rebrand MatchRecon with your own logo, colors, and custom domain. Perfect for accounting firms, bookkeepers, and service providers offering reconciliation services to clients. Create client-facing dashboards with your branding while leveraging MatchRecon's infrastructure.

Step-by-Step Setup

1. 1

   Upload Your Logo

   Settings → White Label → Upload logo (SVG recommended, 200x50px ideal)

2. 2

   Customize Color Scheme

   Set primary, secondary, and accent colors matching your brand guidelines

3. 3

   Configure Custom Domain

   Add CNAME record pointing to matchrecon servers (e.g., reconciliation.yourfirm.com)

4. 4

   Customize Email Templates

   Update notification emails with your branding, contact info, and support links

5. 5

   Test Client View

   Preview client-facing interface, create test client account, verify all branding

API Usage

POST /api/white-label/configure
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "logoUrl": "https://yourcdn.com/logo.svg",
  "primaryColor": "#1E40AF",
  "secondaryColor": "#3B82F6",
  "customDomain": "reconciliation.yourfirm.com",
  "companyName": "Your Firm Name",
  "supportEmail": "support@yourfirm.com"
}

Response 200 OK:
{
  "whitelabelId": "wl_abc123",
  "status": "active",
  "customDomain": "reconciliation.yourfirm.com",
  "dnsVerified": true,
  "sslEnabled": true
}

Configuration Options

Common Issues & Solutions

Overview

Dedicated Infrastructure provides your organization with isolated servers, guaranteed compute resources, and dedicated database instances. Includes 99.9% uptime SLA with performance credits, custom resource allocation, and choice of data residency region. Perfect for high-volume processing and regulatory compliance requirements.

Step-by-Step Setup

1. 1

   Contact Enterprise Sales

   Submit requirements: expected transaction volume, data residency needs, and compliance requirements

2. 2

   Choose Infrastructure Configuration

   Select server size, database tier, storage capacity, and region (US-East, US-West, EU, UK, AU)

3. 3

   Infrastructure Provisioning

   MatchRecon team provisions dedicated resources (typically 5-7 business days)

4. 4

   Configure Security & Access

   Set up IP whitelisting, VPN access, custom SSL certificates, and firewall rules

5. 5

   Monitor Performance Dashboard

   Access real-time metrics: CPU usage, memory, storage, API latency, and SLA compliance

API Usage

GET /api/infrastructure/status
Authorization: Bearer YOUR_API_KEY

Response 200 OK:
{
  "instanceId": "infra_dedicated_789xyz",
  "region": "us-east-1",
  "status": "active",
  "uptime": {
    "current": "99.97%",
    "slaTarget": "99.9%",
    "lastDowntime": null
  },
  "resources": {
    "cpu": {
      "allocated": "16 cores",
      "usage": "42%"
    },
    "memory": {
      "allocated": "64GB",
      "usage": "28GB"
    },
    "storage": {
      "allocated": "2TB SSD",
      "used": "847GB"
    }
  },
  "performance": {
    "avgApiLatency": "45ms",
    "p95ApiLatency": "120ms",
    "throughput": "5000 req/sec"
  }
}

Configuration Options

Common Issues & Solutions

Overview

AI Learning & Optimization uses machine learning to continuously improve matching accuracy based on your organization's patterns. The system learns from manual corrections, accepted/rejected suggestions, and historical matching decisions to automatically apply learned patterns to future reconciliations. Accuracy improves 5-15% over first 90 days of use.

Step-by-Step Setup

1. 1

   Enable AI Learning

   Settings → AI & Machine Learning → Toggle "Enable AI Learning" → Save

2. 2

   Configure Learning Parameters

   Set confidence threshold (75-95%), minimum training samples (50-500), and learning rate

3. 3

   Provide Training Data

   Process 3-6 months of historical reconciliations to build initial training set

4. 4

   Review & Correct AI Suggestions

   Accept/reject AI match suggestions - each decision trains the model

5. 5

   Monitor Learning Progress

   Dashboard shows model accuracy, training samples processed, and performance trends

API Usage

POST /api/ai/train
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "reconciliationId": "recon_456xyz",
  "corrections": [
    {
      "transactionId": "txn_123",
      "invoiceId": "inv_789",
      "action": "accept",
      "confidence": 0.92
    },
    {
      "transactionId": "txn_124",
      "invoiceId": "inv_790",
      "action": "reject",
      "reason": "vendor_mismatch"
    }
  ]
}

Response 200 OK:
{
  "modelId": "model_v23",
  "trainingSamplesAdded": 2,
  "totalTrainingSamples": 1247,
  "currentAccuracy": "91.3%",
  "improvementSinceBaseline": "+8.7%",
  "nextModelUpdate": "2024-02-01T00:00:00Z"
}

Configuration Options

Common Issues & Solutions

Overview

Approval Workflows enable multi-level approval processes for reconciliation matches based on amount thresholds, vendor types, or custom criteria. Configure chains with role-based permissions: reviewer → manager → CFO. Includes email notifications, approval history tracking, and escalation rules for overdue approvals.

Step-by-Step Setup

1. 1

   Enable Approval Workflows

   Settings → Approvals → Toggle "Require Approvals" → Save

2. 2

   Define Approval Rules

   Create rules: amounts >$10K require manager approval, >$50K require CFO approval

3. 3

   Assign Approvers

   Team Settings → Assign users to approval roles (Reviewer, Manager, Director, CFO)

4. 4

   Configure Notifications

   Set email/Slack alerts for pending approvals, escalation after 48 hours, approval granted/denied

5. 5

   Test Workflow

   Process test reconciliation and verify approval chain works correctly

API Usage

POST /api/approvals/workflows
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "name": "Standard Approval Chain",
  "rules": [
    {
      "condition": {
        "field": "amount",
        "operator": "greater_than",
        "value": 10000
      },
      "approvers": [
        {
          "role": "manager",
          "required": true,
          "timeoutHours": 48
        }
      ]
    },
    {
      "condition": {
        "field": "amount",
        "operator": "greater_than",
        "value": 50000
      },
      "approvers": [
        {
          "role": "cfo",
          "required": true,
          "timeoutHours": 72
        }
      ]
    }
  ],
  "notifications": {
    "email": true,
    "slack": true,
    "escalateAfterHours": 48
  }
}

Response 200 OK:
{
  "workflowId": "wf_abc123",
  "status": "active",
  "rulesCount": 2,
  "assignedApprovers": 5
}

Configuration Options

Common Issues & Solutions

Overview

Complete Audit Trail provides immutable logging of every action in the system: user logins, file uploads, match approvals/rejections, configuration changes, data exports, and API calls. Each entry includes timestamp, user ID, IP address, action type, and affected records. Logs are tamper-proof and compliance-ready (SOX, GDPR, SOC 2).

Step-by-Step Setup

1. 1

   Enable Comprehensive Logging

   Settings → Audit & Compliance → Toggle "Complete Audit Trail" → Save (enabled by default)

2. 2

   Configure Retention Policy

   Set retention period: 1 year (Professional), 3 years (Business), 7 years (Enterprise)

3. 3

   Access Audit Logs

   Dashboard → Audit Logs → Filter by user, action type, date range, or reconciliation ID

4. 4

   Export for Compliance

   Select date range → Export as CSV, Excel, or JSON → Optionally include cryptographic signature

5. 5

   Schedule Automated Reports

   Set up weekly/monthly audit reports delivered to compliance team automatically

API Usage

GET /api/audit/logs?startDate=2024-01-01&endDate=2024-01-31
Authorization: Bearer YOUR_API_KEY

Response 200 OK:
{
  "logs": [
    {
      "id": "log_abc123",
      "timestamp": "2024-01-15T14:32:18Z",
      "userId": "user_789",
      "userName": "john.smith@company.com",
      "ipAddress": "192.168.1.100",
      "action": "match_approved",
      "resourceType": "reconciliation",
      "resourceId": "recon_456xyz",
      "details": {
        "transactionId": "txn_123",
        "invoiceId": "inv_789",
        "amount": 15000.00,
        "approvalLevel": "manager"
      },
      "signature": "sha256:a3f8c2e..."
    },
    {
      "id": "log_def456",
      "timestamp": "2024-01-15T14:35:22Z",
      "userId": "user_789",
      "userName": "john.smith@company.com",
      "ipAddress": "192.168.1.100",
      "action": "export_data",
      "resourceType": "report",
      "resourceId": "rpt_abc123",
      "details": {
        "format": "xlsx",
        "recordCount": 1247
      },
      "signature": "sha256:b7e9d4f..."
    }
  ],
  "total": 2847,
  "page": 1,
  "perPage": 100
}

Configuration Options

Common Issues & Solutions

Overview

Team Collaboration enables real-time teamwork on reconciliation tasks with comment threads, @mentions, task assignments, and activity notifications. Team members can discuss exceptions, tag colleagues for input, assign resolution tasks, and track progress collaboratively. Includes Slack/Teams integration for external notifications.

Step-by-Step Setup

1. 1

   Enable Collaboration Features

   Settings → Team → Toggle "Enable Collaboration" → Save

2. 2

   Invite Team Members

   Team Settings → Add Members → Enter emails → Assign roles (Viewer, Contributor, Admin)

3. 3

   Configure Notifications

   Set preferences: email/in-app alerts for @mentions, task assignments, comment replies

4. 4

   Integrate Slack/Teams (Optional)

   Integrations → Connect Slack or Microsoft Teams → Map channels to workspaces

5. 5

   Start Collaborating

   Click any transaction → Add comment → Use @username to mention colleagues → Assign tasks

API Usage

POST /api/comments
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "resourceType": "transaction",
  "resourceId": "txn_123",
  "content": "Hey @sarah.jones, can you verify this vendor name? Looks like a duplicate.",
  "mentions": ["user_456"],
  "priority": "normal"
}

Response 200 OK:
{
  "commentId": "cmt_abc123",
  "createdAt": "2024-01-15T14:32:18Z",
  "author": {
    "id": "user_789",
    "name": "John Smith",
    "email": "john.smith@company.com"
  },
  "mentions": [
    {
      "userId": "user_456",
      "notified": true
    }
  ]
}

POST /api/tasks
{
  "title": "Investigate vendor name discrepancy",
  "assignee": "user_456",
  "resourceType": "transaction",
  "resourceId": "txn_123",
  "dueDate": "2024-01-20",
  "priority": "high"
}

Response 200 OK:
{
  "taskId": "task_def456",
  "status": "assigned",
  "createdBy": "user_789",
  "assignedTo": "user_456",
  "notificationSent": true
}

Configuration Options

Common Issues & Solutions

Overview

Data Residency Control allows you to select where your data is physically stored and processed. Choose from 5 global regions (US, EU, UK, AU, CA) with full GDPR compliance. Your data never leaves your chosen region, ensuring compliance with local data protection regulations and sovereignty requirements.

Step-by-Step Setup

1. 1

   Select Region During Setup

   During account creation: Enterprise Setup → Data Residency → Choose Region (US-East, EU-Central, UK-London, AU-Sydney, CA-Toronto)

2. 2

   Confirm Compliance Requirements

   Review compliance certifications (GDPR, SOC 2, ISO 27001) for your selected region

3. 3

   Configure Data Transfer Policies

   Settings → Data Governance → Set policies for data export, backup regions, and cross-border transfers

4. 4

   Enable Audit Logging

   Settings → Compliance → Enable data access logs and geographic tracking for all data operations

5. 5

   Verify Region Configuration

   Dashboard → System → Data Location shows current region and confirms data residency status

API Usage

GET /api/organization/data-residency
Authorization: Bearer YOUR_API_KEY

Response:
{
  "region": "eu-central",
  "dataCenter": "Frankfurt, Germany",
  "compliance": ["GDPR", "SOC2", "ISO27001"],
  "backupRegion": "eu-west",
  "crossBorderTransfers": false
}

POST /api/organization/data-residency/audit
Authorization: Bearer YOUR_API_KEY
Content-Type: application/json

{
  "startDate": "2024-01-01",
  "endDate": "2024-01-31",
  "includeAccess": true,
  "includeTransfers": true
}

Response:
{
  "totalAccess": 15234,
  "accessByRegion": {
    "eu-central": 15234,
    "other": 0
  },
  "dataTransfers": [],
  "complianceScore": 100,
  "violations": []
}

Configuration Options

Common Issues & Solutions

Overview

Multi-Entity Management enables you to manage reconciliation for multiple companies, subsidiaries, or business units within a single account. Create separate entities with isolated data, then generate consolidated reports that roll up metrics across all entities while maintaining entity-level breakdowns. Perfect for holding companies, accounting firms managing multiple clients, or multinational corporations.

Step-by-Step Setup

1. 1

   Create New Entities

   Dashboard → Entities → Add Entity → Enter entity name, currency, timezone, and tax ID

2. 2

   Configure Entity Hierarchy

   Entities → Organization Structure → Set parent-child relationships for consolidated reporting

3. 3

   Assign User Permissions

   Settings → Users → Assign users to specific entities or grant cross-entity access for managers

4. 4

   Upload Entity-Specific Data

   Switch to entity view → Upload bank statements and invoices tagged to specific entity

5. 5

   Generate Consolidated Reports

   Reports → Consolidated View → Select entities to include, run report with entity-level breakdown

API Usage

POST /api/entities
Authorization: Bearer YOUR_API_KEY
Content-Type: application/json

{
  "name": "ACME Subsidiary UK",
  "currency": "GBP",
  "timezone": "Europe/London",
  "taxId": "GB123456789",
  "parentEntity": "ent_parent_123",
  "settings": {
    "fiscalYearStart": "04-01",
    "consolidationRules": "full"
  }
}

Response:
{
  "entityId": "ent_uk_456",
  "status": "active",
  "hierarchyLevel": 2,
  "createdAt": "2024-01-15T10:00:00Z"
}

GET /api/reports/consolidated
Authorization: Bearer YOUR_API_KEY

{
  "entities": ["ent_uk_456", "ent_us_789", "ent_ca_012"],
  "dateRange": {
    "start": "2024-01-01",
    "end": "2024-01-31"
  },
  "breakdown": "entity",
  "includeIntercompany": false
}

Response:
{
  "totalMatches": 15234,
  "matchRate": 94.2,
  "byEntity": {
    "ent_uk_456": {"matches": 5124, "rate": 95.1},
    "ent_us_789": {"matches": 7890, "rate": 93.8},
    "ent_ca_012": {"matches": 2220, "rate": 93.5}
  }
}

Configuration Options

Common Issues & Solutions

Overview

Enhanced OCR uses advanced optical character recognition powered by machine learning to extract data from scanned invoices, receipts, and bank statements. It handles poor-quality scans, handwritten notes, multi-column layouts, and supports 25+ languages. The system automatically extracts key fields like amounts, dates, vendor names, and invoice numbers with 98%+ accuracy.

Step-by-Step Setup

1. 1

   Enable Enhanced OCR

   Settings → Document Processing → Enable Enhanced OCR (AI-powered extraction)

2. 2

   Configure Field Extraction

   Settings → OCR → Select fields to extract: amount, date, vendor, invoice number, line items, etc.

3. 3

   Set Confidence Thresholds

   OCR Settings → Confidence → Set minimum confidence (70-95%) for auto-approval vs manual review

4. 4

   Upload Scanned Documents

   Dashboard → Upload → Select scanned PDFs or images (JPG, PNG, TIFF supported)

5. 5

   Review and Validate Extractions

   Documents → OCR Results → Review low-confidence extractions, correct errors, and submit for matching

API Usage

POST /api/ocr/process
Authorization: Bearer YOUR_API_KEY
Content-Type: multipart/form-data

{
  "file": <binary_data>,
  "documentType": "invoice",
  "language": "en",
  "extractFields": ["amount", "date", "vendor", "invoiceNumber"],
  "minConfidence": 85
}

Response:
{
  "documentId": "doc_abc123",
  "status": "processed",
  "extractedData": {
    "amount": {"value": 1250.00, "confidence": 98},
    "date": {"value": "2024-01-15", "confidence": 95},
    "vendor": {"value": "ACME Corp", "confidence": 92},
    "invoiceNumber": {"value": "INV-2024-001", "confidence": 97}
  },
  "requiresReview": false,
  "processingTime": 2.3
}

POST /api/ocr/batch
Authorization: Bearer YOUR_API_KEY
Content-Type: application/json

{
  "documents": [
    {"url": "https://storage/doc1.pdf"},
    {"url": "https://storage/doc2.pdf"}
  ],
  "settings": {
    "extractLineItems": true,
    "detectHandwriting": true,
    "enhancePoorQuality": true
  }
}

Response:
{
  "batchId": "batch_xyz789",
  "totalDocuments": 2,
  "status": "processing",
  "estimatedCompletion": "2024-01-15T10:05:00Z"
}

Configuration Options

Common Issues & Solutions

Overview

Partial Payment Matching automatically detects when bank transactions represent partial payments toward invoices and tracks the remaining balance. The system links multiple payments to a single invoice, maintains payment schedules, and alerts you when invoices are fully paid or overdue balances remain. Supports installment plans, down payments, and progress billing scenarios.

Step-by-Step Setup

1. 1

   Enable Partial Payment Matching

   Settings → Matching Rules → Enable "Allow Partial Payments" and set matching tolerance

2. 2

   Configure Payment Thresholds

   Matching Rules → Set minimum partial payment % (e.g., 10% of invoice) to avoid false matches

3. 3

   Set Up Payment Schedules

   Invoices → Payment Plans → Define expected payment schedules for installment invoices (optional)

4. 4

   Upload Invoices and Transactions

   System automatically detects partial payments and links them to invoices based on vendor and amount

5. 5

   Monitor Outstanding Balances

   Dashboard → Partial Payments → View invoices with remaining balances and payment history

API Usage

POST /api/invoices/:invoiceId/partial-payment
Authorization: Bearer YOUR_API_KEY
Content-Type: application/json

{
  "transactionId": "txn_abc123",
  "amount": 500.00,
  "date": "2024-01-15",
  "reference": "Payment 1 of 3",
  "remainingBalance": 1000.00
}

Response:
{
  "paymentId": "pmt_xyz789",
  "invoiceId": "inv_456",
  "totalInvoiceAmount": 1500.00,
  "paidToDate": 500.00,
  "remainingBalance": 1000.00,
  "percentPaid": 33.3,
  "fullyPaid": false,
  "paymentCount": 1
}

GET /api/invoices/partial-payments
Authorization: Bearer YOUR_API_KEY

Response:
{
  "partiallyPaidInvoices": [
    {
      "invoiceId": "inv_456",
      "vendor": "ACME Corp",
      "totalAmount": 1500.00,
      "paidAmount": 500.00,
      "remainingBalance": 1000.00,
      "payments": [
        {"date": "2024-01-15", "amount": 500.00}
      ],
      "dueDate": "2024-02-15",
      "overdue": false
    }
  ],
  "totalOutstanding": 1000.00
}

Configuration Options

Common Issues & Solutions

Overview

QuickBooks Integration provides direct, bi-directional sync with both QuickBooks Online and QuickBooks Desktop. Automatically import invoices, bills, vendors, and bank transactions from QuickBooks. Push reconciliation statuses, matches, and exceptions back to QuickBooks as journal entries or updates to transaction status. Real-time sync every 15 minutes or on-demand manual sync.

Step-by-Step Setup

1. 1

   Connect QuickBooks Account

   Settings → Integrations → QuickBooks → Click "Connect" and authenticate with your QuickBooks credentials

2. 2

   Select Data to Sync

   Integration Settings → Choose what to sync: Invoices, Bills, Vendors, Bank Transactions, Payments

3. 3

   Configure Sync Direction

   Set sync mode: Import only (QB → MatchRecon), Export only (MatchRecon → QB), or Bi-directional

4. 4

   Set Sync Frequency

   Choose automatic sync interval: Real-time (15 min), Hourly, Daily, or Manual only

5. 5

   Run Initial Sync

   Click "Sync Now" to import existing data. Choose date range for historical data (last 30, 90, 365 days)

API Usage

POST /api/integrations/quickbooks/connect
Authorization: Bearer YOUR_API_KEY
Content-Type: application/json

{
  "authCode": "QB_AUTH_CODE_FROM_OAUTH",
  "realmId": "123456789",
  "syncSettings": {
    "entities": ["invoices", "bills", "vendors", "transactions"],
    "direction": "bidirectional",
    "frequency": "realtime"
  }
}

Response:
{
  "connectionId": "qb_conn_abc123",
  "status": "connected",
  "companyName": "ACME Corporation",
  "environment": "production",
  "lastSync": null,
  "nextSync": "2024-01-15T10:15:00Z"
}

POST /api/integrations/quickbooks/sync
Authorization: Bearer YOUR_API_KEY
Content-Type: application/json

{
  "syncType": "incremental",
  "entities": ["invoices"],
  "dateRange": {
    "start": "2024-01-01",
    "end": "2024-01-31"
  }
}

Response:
{
  "syncId": "sync_xyz789",
  "status": "completed",
  "imported": {
    "invoices": 145,
    "vendors": 23,
    "transactions": 312
  },
  "exported": {
    "reconciliationStatus": 89,
    "matches": 134
  },
  "errors": [],
  "duration": 23.4
}

Configuration Options

Common Issues & Solutions

Overview

Xero Integration provides seamless bi-directional synchronization with your Xero accounting platform. Automatically imports invoices, bills, and bank transactions from Xero, performs reconciliation matching, and posts reconciliation results back to Xero as bank reconciliation entries. Uses OAuth 2.0 authentication and supports real-time webhook updates.

Step-by-Step Setup

1. 1

   Navigate to Xero Integration Settings

   Dashboard → Settings → Integrations → Xero → Connect Account

2. 2

   Authorize MatchRecon Access

   Click "Connect to Xero" → Login to Xero → Authorize access to invoices, bills, bank transactions, and contacts

3. 3

   Select Xero Organization

   Choose which Xero organization to sync with. Configure sync direction (import only or bi-directional).

4. 4

   Configure Sync Parameters

   Set sync frequency, date range for historical import, and choose which transaction types to sync (invoices, bills, bank transactions)

5. 5

   Test and Enable Sync

   Run initial test import to verify connection. Enable automatic sync and webhook notifications for real-time updates.

API Usage

POST /api/integrations/xero/connect
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "organizationId": "xero_org_abc123",
  "syncDirection": "bidirectional",
  "syncFrequency": "realtime",
  "transactionTypes": ["invoices", "bills", "bank_transactions"],
  "historicalImport": {
    "enabled": true,
    "fromDate": "2024-01-01"
  },
  "autoReconcile": true
}

{
  "success": true,
  "integrationId": "xero_int_xyz789",
  "organizationName": "Acme Corporation",
  "status": "connected",
  "lastSync": "2024-11-06T10:30:00Z",
  "transactionsImported": 1847,
  "webhookStatus": "active"
}

Configuration Options

Common Issues & Troubleshooting

Overview

Recurring Transaction Detection uses pattern recognition and machine learning to automatically identify subscription payments, recurring bills, and regular vendor charges. Analyzes transaction history to detect frequency patterns (daily, weekly, monthly, quarterly, annual), predicts future occurrences, and flags anomalies such as missed payments, amount changes, or schedule deviations. Essential for subscription businesses and companies with predictable recurring expenses.

Step-by-Step Setup

1. 1

   Enable Recurring Detection

   Dashboard → Analytics → Recurring Transactions → Enable Detection

2. 2

   Set Detection Sensitivity

   Configure minimum occurrences (default: 3) and tolerance thresholds for amount variance (±5%) and schedule deviation (±3 days)

3. 3

   Run Initial Analysis

   Click "Analyze Historical Transactions" to scan your existing data. Requires minimum 90 days of transaction history for accurate detection.

4. 4

   Review and Confirm Patterns

   Review detected recurring patterns. Mark false positives as "Not Recurring" and manually add any missed patterns.

5. 5

   Enable Alerts and Forecasting

   Configure email alerts for missed payments, amount anomalies, and schedule changes. Enable future transaction forecasting in cash flow reports.

API Usage

POST /api/recurring-detection/analyze
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "dateRange": {
    "start": "2024-01-01",
    "end": "2024-11-06"
  },
  "minOccurrences": 3,
  "tolerances": {
    "amountVariance": 0.05,
    "scheduleDeviation": 3
  },
  "frequencies": ["daily", "weekly", "monthly", "quarterly", "annual"],
  "autoConfirm": false
}

{
  "success": true,
  "patternsDetected": 47,
  "patterns": [
    {
      "id": "rec_pat_001",
      "vendor": "AWS",
      "frequency": "monthly",
      "averageAmount": 523.50,
      "nextExpected": "2024-12-01",
      "confidence": 0.98
    }
  ],
  "anomaliesFound": 3
}

Configuration Options

Common Issues & Troubleshooting

Overview

SLA Monitoring provides comprehensive tracking and reporting of reconciliation completion times against defined service level targets. Measures key performance indicators including time-to-reconciliation, exception resolution time, and match rate accuracy. Generates executive dashboards, automated alerts for SLA breaches, and detailed performance analytics for team and individual performance assessment. Essential for organizations with compliance requirements or internal finance SLA commitments.

Step-by-Step Setup

1. 1

   Define SLA Targets

   Dashboard → Settings → SLA Configuration → Set targets for reconciliation completion (e.g., 24 hours), exception resolution (e.g., 48 hours), and match accuracy (e.g., 95%)

2. 2

   Configure Alert Thresholds

   Set warning thresholds (e.g., 80% of SLA time elapsed) and critical alerts (e.g., SLA breach). Choose notification channels: Email, Slack, or Teams.

3. 3

   Assign SLA Responsibilities

   Assign specific users or teams to different reconciliation types. Configure escalation paths for overdue items.

4. 4

   Enable Performance Tracking

   Activate SLA monitoring for all reconciliation batches. System starts tracking from upload/detection timestamp.

5. 5

   Access SLA Dashboards

   View real-time SLA compliance at Dashboard → Reports → SLA Performance. Export reports for management review or audit purposes.

API Usage

POST /api/monitoring/sla/configure
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "targets": {
    "reconciliationCompletion": 24,
    "exceptionResolution": 48,
    "matchAccuracy": 0.95
  },
  "alerts": {
    "warningThreshold": 0.80,
    "criticalThreshold": 1.00,
    "channels": ["email", "slack"]
  },
  "escalation": {
    "enabled": true,
    "escalateAfter": 72
  },
  "businessHoursOnly": false
}

{
  "success": true,
  "slaConfigId": "sla_cfg_001",
  "monitoring": "active",
  "currentCompliance": {
    "reconciliationSLA": 0.94,
    "exceptionSLA": 0.89,
    "matchAccuracy": 0.97
  },
  "activeBatches": 42,
  "breaches": 3
}

Configuration Options

Common Issues & Troubleshooting

Overview

Task Management provides a comprehensive workflow system for tracking and resolving reconciliation exceptions and discrepancies. Features include task creation and assignment, Kanban-style visual boards, priority levels, due date tracking, comment threads, file attachments, and status automation. Automatically generates tasks from detected exceptions or allows manual task creation. Integrates with email and Slack for notifications. Essential for teams that need structured exception resolution workflows and accountability tracking.

Step-by-Step Setup

1. 1

   Enable Task Management

   Dashboard → Settings → Features → Enable Task Management

2. 2

   Configure Workflow Columns

   Dashboard → Tasks → Board Settings → Customize columns (default: To Do, In Progress, Review, Done). Add custom statuses as needed.

3. 3

   Set Up Auto-Task Creation

   Configure which exception types automatically create tasks. Set default assignees based on exception category or amount threshold.

4. 4

   Define Priority Rules and SLAs

   Set task priorities (Low, Medium, High, Critical) and associated due date rules. Link to SLA monitoring for compliance tracking.

5. 5

   Enable Notifications

   Configure email and Slack notifications for task assignments, status changes, due date reminders, and overdue tasks.

API Usage

POST /api/tasks/create
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "title": "Investigate $5,200 bank fee discrepancy",
  "description": "Bank charged $5,200 but expected $5,000 based on contract",
  "priority": "high",
  "assigneeId": "user_abc123",
  "dueDate": "2024-11-10",
  "exceptionId": "exc_xyz789",
  "tags": ["bank_fees", "vendor_inquiry"],
  "status": "to_do"
}

{
  "success": true,
  "taskId": "task_def456",
  "status": "to_do",
  "assignee": {
    "userId": "user_abc123",
    "name": "Sarah Johnson",
    "notified": true
  },
  "createdAt": "2024-11-06T10:30:00Z",
  "url": "/tasks/task_def456"
}

Configuration Options

Common Issues & Troubleshooting

Overview

Vendor Analytics provides comprehensive intelligence on vendor payment patterns, invoice accuracy, and relationship health. Tracks metrics including average payment timing, discrepancy frequency, dispute rate, payment method preferences, and spending trends. Generates vendor scorecards with risk ratings based on historical performance. Identifies problematic vendors with chronic billing errors, frequent disputes, or unusual pricing variances. Supports strategic vendor management decisions including consolidation opportunities, early payment discount analysis, and payment term optimization.

Step-by-Step Setup

1. 1

   Enable Vendor Analytics

   Dashboard → Analytics → Vendor Intelligence → Enable Analytics

2. 2

   Configure Vendor Profiles

   Ensure vendor names are standardized using Settings → Vendors → Vendor Aliases. Link multiple vendor name variations to single canonical vendor profiles.

3. 3

   Set Performance Benchmarks

   Define acceptable thresholds for discrepancy rate (e.g., <2%), average payment timing variance (e.g., ±5 days), and dispute frequency.

4. 4

   Build Historical Analysis

   System analyzes minimum 90 days of transaction history per vendor. Initial analytics report generates automatically after data processing.

5. 5

   Review Vendor Scorecards

   Access vendor scorecards at Dashboard → Analytics → Vendor Scorecards. Export reports for procurement review or vendor negotiations.

API Usage

GET /api/analytics/vendors/{vendorId}
Authorization: Bearer YOUR_API_KEY

Query Parameters:
  dateRange: 90 (days)
  includeMetrics: true
  includeTrends: true

{
  "vendorId": "vnd_abc123",
  "vendorName": "Acme Supplies Inc",
  "metrics": {
    "totalTransactions": 342,
    "totalSpend": 1847250.00,
    "discrepancyRate": 0.029,
    "averageInvoiceAmount": 5400.15,
    "averagePaymentTiming": 32.5,
    "disputeCount": 8
  },
  "riskScore": 3.2,
  "riskLevel": "medium",
  "trends": {
    "spendTrend": "increasing",
    "discrepancyTrend": "stable"
  }
}

Configuration Options

Common Issues & Troubleshooting

Overview

Workspace Management enables multi-tenant architecture for organizations managing reconciliation for multiple business units, subsidiaries, or clients. Each workspace maintains completely isolated data, custom configurations, and separate reconciliation workflows while sharing centralized user management, billing, and administrative controls. Ideal for accounting firms managing multiple clients, holding companies with subsidiaries, or enterprises with independent regional operations. Features include workspace-level branding, custom settings inheritance, cross-workspace reporting, and centralized user provisioning with granular per-workspace permissions.

Step-by-Step Setup

1. 1

   Create New Workspace

   Dashboard → Workspaces → Create New → Enter workspace name, description, and select template settings (or start blank)

2. 2

   Configure Workspace Settings

   Set workspace-specific configurations: matching rules, currencies, integrations, notification preferences, and branding (logo, colors)

3. 3

   Assign Users and Permissions

   Dashboard → Workspaces → [Select Workspace] → Users → Add users with role-based permissions (Admin, Manager, Analyst, Viewer)

4. 4

   Set Up Data Isolation Rules

   Configure data access boundaries. Ensure users can only view/edit assigned workspaces. Enable cross-workspace reporting for admins if needed.

5. 5

   Switch Between Workspaces

   Use workspace switcher in top navigation bar to toggle between workspaces. All data, settings, and analytics update automatically per workspace context.

API Usage

POST /api/workspaces/create
Content-Type: application/json
Authorization: Bearer YOUR_API_KEY

{
  "name": "Client ABC Corporation",
  "description": "Reconciliation workspace for ABC Corp",
  "settings": {
    "currency": "USD",
    "timezone": "America/New_York",
    "templateId": "template_standard"
  },
  "branding": {
    "logoUrl": "https://example.com/logo.png",
    "primaryColor": "#1E40AF"
  },
  "users": [
    {
      "email": "manager@abccorp.com",
      "role": "admin"
    }
  ]
}

{
  "success": true,
  "workspaceId": "wks_xyz789",
  "name": "Client ABC Corporation",
  "status": "active",
  "createdAt": "2024-11-06T10:30:00Z",
  "usersAdded": 1,
  "url": "/workspaces/wks_xyz789"
}

Configuration Options

Common Issues & Troubleshooting