​@dsimmerly - Are you looking for the reconciliation or the entering of the payments?  I believe acumatica has an import scenario created for customers implementing Amazon and trying to perform the bank settlement reconcilliation...did they not review this as part of the implementation?    Or if i’m missing something, are you importing the payments via the connector?

My response was crafted with AI assistance, tailored to provide detailed and actionable guidance for your query.

For efficiently entering Amazon deposits consisting of numerous payments with deducted fees into Acumatica ERP.

Best Practices for Entering Deposits

1. Use Bank Transactions Module:

   • Create a single bank deposit to represent the aggregated amount received from Amazon.
   • Use the Bank Deposits (CA305000) form to consolidate multiple payments into a single deposit.

2. Reconcile Bank Deposits:

   • Reconcile these bank deposits with your bank statement using the Reconciliation Statement (CA302000) form. This will simplify tracking and matching payments to deposits.

3. Handling Fees:

   • Record Amazon fees as separate entries in the deposit to ensure accurate financial reporting. Fees can be entered as negative adjustments linked to the appropriate expense accounts.

4. Batch Payment Applications:

   • Leverage batch processing to apply multiple payments efficiently. This can be managed through Payment and Applications (AR302000).

Automation Options

1. Bank Feeds Integration:

   • Use Acumatica's Bank Feed Integration (Plaid or MX) to automatically import bank transactions. This can help automate the creation of bank deposits by matching Amazon's deposits directly to bank feed entries​​.

2. Custom Import Scenarios:

   • Configure Import Scenarios (SM206025) to load payment and fee details directly from Amazon reports into Acumatica.
   • Use predefined mappings to match Amazon settlement data fields to Acumatica's payment fields.

3. Processing Centers:

   • Set up a processing center for Amazon payments to streamline the handling of these payments through a centralized mechanism, using the Processing Centers (CA205000) form​.

4. Reconciliation Tools:

   • Use Acumatica’s reconciliation tools to automate matching of payments with bank deposits and reduce manual data entry.

5. Mass Release Operations:

   • Use the Release Payments/Applications (AR505000) form to release all the generated payment applications in bulk.

Additional Tips

• Fee Reporting: Consider creating a separate GL account for Amazon fees to improve visibility and reporting accuracy.
• Audit Trails: Maintain detailed records by attaching Amazon settlement reports to the respective deposits using the file attachment functionality in Acumatica.