BatchIt (Reconcile Amazon Batch Payments With Ease)

Amazon deposits can be difficult to reconcile in NetSuite because there aren’t easy ways to match up the transactions in the Amazon file with the orders in NetSuite.  Manually trying to match up orders is time-consuming and error-prone.  To alleviate the manual effort, increase productivity, and improve accuracy, an automated solution is required.  Fourth Wave Consulting customers were struggling with the manual process of reconciling Amazon deposits, so we developed a custom solution to help.

BatchIt is the custom solution Fourth Wave Consulting developed.  This process records the payments and credit refunds within NetSuite, as well as provides a quick way to select the applicable transactions in one deposit.  The process also provides a summary of all the other charges so a cashback entry can be recorded on the same deposit the transactions were selected on.  Once everything is recorded this one deposit will match perfectly to the Amazon deposit line on your bank statement, making bank reconciliation a breeze.

Clients have reported time savings of 3-5 hours on average batch sizes of 70 orders – every 2 weeks. Using BatchIt, a reconciliation from start to deposit creation generally takes less than twenty minutes. Not only does it take less time but because it is automated, the correct orders get matched up every time.  The process also provides a list of exceptions that help identify if an order within NetSuite was created incorrectly or if Amazon is withholding additional funds unexpectedly.

This solution uses searches, custom records, custom fields, and NetSuite standard functionality to perform the required processes. Below is the basic process flow that BatchIt uses. 

This solution can be customized to your specific requirements whether that be recording payments against open invoices or updating cash sales with a batch id to allow selecting them in a deposit via a filter field. If you are struggling with reconciling Amazon deposits (or other marketplaces), contact us, we will be glad to assist with automating this task so you can get back to your more important responsibilities like growing the business.

Note this solution can also be adapted to other types of batch payments such as credit card batches, Walmart Marketplace batches, etc.  It provides a good option for batch sizes of 30-800 orders biweekly.

The following two tabs change content below.

• Bio
• Latest Posts

Renee Chandler

NETSUITE FUNCTIONAL CONSULTANT Specializing in ACCOUNTING AND OPERATIONS I have over twenty-five years of experience running accounting and operational departments with sales revenue ranging from $1M to $200M+ within the eCommerce and utility industries. My 14+ years of Netsuite administrator experience along with my depth of accounting and operational knowledge insures I can provide deep level analysis and professional implementations. My NetSuite experience includes but is not limited to custom reporting, KPI’s, dashboards, workflows, searches, financial reporting, banking, demand planning, supply planning, eft payments, inventory management, order to cash, custom forms, custom fields, Netsuite to Shopify via Celigo integrator, full Netsuite implementations, and financial management.

Latest posts by Renee Chandler (see all)

• BatchIt (Reconcile Amazon Batch Payments With Ease) - November 1, 2022