Amazon Payout Reconciliation

Overview

Key Capabilities

System Capabilities

• Fully Automated Import - Hourly automatic settlement report import
• Advanced Transaction Matching - Intelligent refund matching using adjustment IDs
• Batch Auto-Post - Process multiple transactions simultaneously
• Real-time Inventory Integration - Automatic inventory adjustments for all transaction types
• Enhanced UI - Comprehensive transaction details with metadata display
• Flexible GL Mapping - Configurable transaction type to GL account mapping
• Advanced Error Handling - Robust error recovery and retry mechanisms

Automated Import System

Automatic Settlement Report Import

Key Features

Intelligent Transaction Classification

Automatically categorizes transactions based on Amazon's transaction type and amount description, handling orders, refunds, fees, and adjustments with precision.

Advanced Transaction Matching

Links Amazon transactions to existing Versa orders and refunds using sophisticated matching algorithms and external resource mappings. The system intelligently matches:

• Order transactions to existing Versa orders via external order mappings
• Refund transactions to existing Versa refunds using adjustment IDs
• Payment receipts to corresponding order transactions

Dual-Path Processing

Simultaneously handles financial records and inventory adjustments, ensuring accurate accounting and inventory management. The system processes both monetary transactions and physical inventory changes in a single operation.

Batch Operations

Process multiple transactions at once with batch auto-post functionality and comprehensive error handling. This dramatically reduces the time required to process large payouts.

Configurable Mappings

Flexible transaction type to GL account mapping system allows customization for different business requirements. Configure how each Amazon transaction type maps to your specific chart of accounts.

Real-time Visibility

Comprehensive dashboard with transaction breakdowns, processing statuses, and detailed metadata display. Monitor the status of all Amazon transactions and payouts in real-time.

Transaction Types & Processing

1. Order Transactions

2. Refund Transactions

3. Adjustment Transactions

4. Other Transactions

User Interface Features

Amazon Payouts Index View

• DataTables Integration: Server-side pagination for large datasets with fast loading
• Settlement Information: Settlement ID, period, total amount, currency, webstore
• Quick Actions: Direct links to payout details and transaction processing
• Search and Filter: Find specific payouts quickly using built-in search functionality

Amazon Payout Details View

• Comprehensive Statistics: Posted vs unposted transaction counts and amounts
• Enhanced Transaction Table: Shows amount description, SKU, quantity from Amazon metadata
• Direct Bank Transaction Link: One-click access to OFX transactions view
• CSV Export: Download all transaction data for external analysis
• Transaction Status Indicators: Visual indicators showing which transactions are posted or unposted

OFX Transactions Integration

• Payout Filtering: Enhanced dropdown with payout amounts for easy selection
• Batch Auto Post Button: Appears when payout selected and eligible transactions exist
• Post Total Fees Button: Aggregate payout fee posting functionality
• Amazon Transaction Details: Displays amount description, SKU, and quantity in transaction rows
• Institution ID Display: Clear labeling of bank/institution information

Batch Processing & Auto-Post

Individual Auto-Post

Transactions are eligible for auto-posting when they meet the following criteria:

• Transaction type must be: order, refund, adjustment, or other
• Transaction must not already be posted
• Must have required metadata for transaction type
• Must have valid GL account mappings configured

Batch Auto-Post Features

• Smart Processing: Only processes eligible transactions that can be auto-posted
• Error Resilience: Continues processing even if individual transactions fail
• Progress Reporting: Returns detailed counts of successful and failed transactions
• Payout-Specific: Only available when transactions are filtered by specific payout
• Transaction Type Support: Handles all four Amazon transaction types

Fee Handling

The system includes sophisticated fee handling that aggregates all fees within a payout and creates a single accounting transaction for efficient processing. This approach:

• Reduces the number of accounting transactions created
• Simplifies fee reconciliation
• Provides clear visibility into total payout fees
• Uses configured expense GL accounts for proper categorization

Inventory Integration

Order-Principal Transactions

• Automatic Inventory Reduction: Uses quantity-purchased from transaction metadata
• Facility Selection: FBA facility for AFN transactions, FBM facility for MFN transactions
• GL Account Assignment: Uses product's expense GL account from product category
• Product Matching: Links Amazon SKUs to Versa products automatically

Warehouse Adjustments

• WAREHOUSE_LOST: Creates positive inventory adjustments using a designated adjustment SKU
• WAREHOUSE_DAMAGE: Handles damaged inventory with appropriate GL posting
• Variance Reasons: Uses configured variance reason's organization GL account
• Automatic Processing: No manual intervention required for standard adjustments

Inventory Adjustment Logic

The system intelligently determines inventory adjustments based on transaction type and amount description:

• Sales (Order-Principal): Negative adjustment (reduces inventory)
• Refunds: No inventory adjustment (handled separately in refund process)
• Warehouse Lost/Damage: Positive adjustment (accounts for lost inventory)
• Quantity Handling: Uses Amazon's quantity-purchased field or defaults to 1.0

Setup & Configuration

Required Settings

The following settings must be configured to enable Amazon payout reconciliation:

Where to Configure Settings

All Amazon payout reconciliation settings are configured in your webstore settings:

1. Navigate to Tools menu, Integrations
2. Select your Amazon webstore
3. Click Edit
4. Navigate to Setup menu, Feature Setting, E-Commerce Reconciliation
5. Scroll to the E-commerce Reconciliation section

Import Settings

• Enable Amazon Payout Import: Check this box to turn on automatic settlement report import
• Bank Account Configuration: Select which GL account represents your Amazon bank account (configured in Branch Settings)

Transaction Mapping Configuration

In the same E-commerce Reconciliation section, configure how each Amazon transaction type maps to your GL accounts:

Order Transaction Mappings

• Principal Amount: Map to your revenue GL account
• Tax Amount: Map to your tax liability GL account
• Shipping Amount: Map to your shipping revenue GL account
• Commission Amount: Map to your commission expense GL account

Refund Transaction Mappings

• Principal Refund: Map to your refund expense GL account
• Tax Refund: Map to your tax refund GL account
• Commission Refund: Map to your commission recovery GL account

Other Transaction Mappings

• Commission Fees: Map to your Amazon commission expense GL account

Adjustment Transaction Mappings

• Warehouse Lost Items: Map to your inventory adjustment GL account
• Warehouse Damaged Items: Map to your damaged goods GL account

Feature Requirements

• Feature Permission: "Payout Reconciliation" must be enabled for the firm
• Amazon API Access: Valid Amazon SP-API credentials with "Finance and Accounting" permissions
• GL Account Setup: Properly configured GL accounts for all transaction types
• Product Integration: Amazon products must be imported into Versa for inventory adjustments
• Facility Configuration: FBA and FBM facilities must be configured for proper inventory handling

Configuration Steps

1. Enable Feature: Ensure "Payout Reconciliation" feature is enabled for your firm
2. Configure API: Set up Amazon SP-API credentials with proper permissions in your Amazon webstore settings
3. Navigate to Settings: Go to Tools → Integration → [Your Amazon Webstore] → Edit
4. Configure Clearing Account: In Settings, set up the GL account that represents your Amazon clearing account
5. Map GL Accounts in Setup menu, feature settings In the E-commerce Reconciliation section, configure transaction type to GL account mappings for all four transaction types
6. Enable Import: Check the "Enable Amazon Payout Import" checkbox
7. Save Settings: Save your webstore configuration

Troubleshooting

Common Issues & Solutions

Transaction Not Auto-Posting

Symptoms: Transactions remain unposted despite being eligible

Check: Transaction type eligibility, existing mappings, required metadata presence

Solution: Verify GL account mappings and transaction type configuration in webstore settings

Inventory Adjustments Not Creating

Symptoms: Order transactions post but inventory doesn't change

Check: Product exists in Versa, SKU mapping, facility configuration

Solution: Ensure products are properly imported and facilities are configured for FBA/FBM

Refunds Not Matching

Symptoms: Refund transactions don't link to existing Versa refunds

Check: Adjustment ID presence, external refund mappings

Solution: Verify refunds were imported with proper external resource mappings using adjustment IDs

Automatic Import Not Working

Symptoms: New settlement reports not importing automatically

Check: Feature permission, import setting enabled, API credentials

Solution: Verify "Payout Reconciliation" feature and enable_amazon_payout_import setting are both enabled

Batch Processing Failures

Symptoms: Batch auto-post fails for multiple transactions

Check: GL account mappings, transaction eligibility, error logs

Solution: Review error messages and ensure all required GL accounts are configured

Diagnostic Information

When troubleshooting issues, the following information can be helpful to check:

• Feature Status: Verify that the "Payout Reconciliation" feature is enabled for your firm
• Import Setting: Confirm that Amazon payout import is enabled in webstore settings
• Transaction Eligibility: Check if individual transactions meet auto-post criteria
• Batch Eligibility: Verify how many transactions in a payout are eligible for batch processing
• Transaction Mappings: Ensure transactions are properly linked to accounting records
• GL Account Mappings: Verify that all transaction types have valid GL account mappings
• API Credentials: Confirm that Amazon API credentials are properly configured

Performance Considerations

• Large Payouts: Payouts with thousands of transactions may take several minutes to process
• Batch Processing: Use batch auto-post for better performance with large transaction volumes
• API Rate Limits: Amazon API has rate limits; the system includes proper retry logic
• Database Performance: Large transaction volumes may require database optimization

Contact & Support

For additional support or questions about Amazon Payout Reconciliation, please contact the Versa Cloud ERP support team.