A2X offers a helpful export solution for your accounting so that you can import into a wide variety of different accounting systems.
In this guide, we will walk through how to setup A2X for a manual integration with NetSuite and how to export your settlement data for accounting and reconciliation.
There are 3 steps to using A2X on a manual integration:
Set up A2X - accounts, tax rates, and bank accounts.
Map your accounts and taxes
Export your settlement data from A2X
We will work through each step below, but first there are some things you need:
You need to sign-up for A2X and should connect your A2X account to your sales channel account (e.g. Amazon, Shopify, Etsy, eBay, Walmart, or BigCommerce).
You need to export your chart of accounts from your accounting system
Step 1: Set up A2X
a) Set up the custom integration
Go to your Home page, and click on the 'Custom Integration button' next to the 'Use without a connected accounting platform?' to begin with the setup.
You will be taken to your Settings > Connections to set up your chart of accounts, tax rates and bank accounts.
b) Upload your Chart of Accounts & Tax Files
A2X needs your chart of accounts and tax rates in order to configure your accounting for Amazon settlements.
Firstly you will need to create your chart of accounts file and then upload it into A2X.
Begin with exporting a sample accounts and taxes files from within A2X:
A simplified example of an Accounts upload file is shown below:
When you are happy with your upload files, you can go back to A2X and upload them.
c) Confirm export format and select bank accounts
Confirm the export format is NetSuite (.csv)
Additionally, you must provide three additional fields (all integer numbers) that will be included in the NetSuite export:
- Subsidiary Id
- Brand Id
- Sales channel Id
The Subsidiary ID, Brand ID, and Sales channel ID will be a part of the file name and included as additional columns in the export. File name format: {Subsidiary Id}-{Brand ID}-{Sales channel ID}-{Account Name}_{Date Range}.csv
Save your settings.
Step 2: Map your accounts and taxes
A2X needs to know how you want to map your Amazon transactions into your accounting system. To do that, A2X has an Accounts and Taxes screen. You can learn more about the mapping process HERE.
This is a standard part of the A2X set up process for all users (both direct and manual integrations). If you’d like some help with this our support team can give you some tips and pointers, but in general, you’ll want to discuss this with your accountant as it affects the way your financial statements will appear.
Save your mappings.
Step 3: Export your settlement data in the NetSuite CSV format
A2X will export a CSV file for each of your settlements. You will then import this CSV file into your accounting system as a Journal entry.
The NetSuite CSV file contains the following columns:
External Id is a system wide unique ID that can be used in NetSuite to group journal entries together. It is in the format a2x-{accountId}-{invoiceId}
Export the A2X settlement data
Click the export link for any given settlement as shown below:
Import the General Journal CSV file into Netsuite
Go to Netsuite > Setup > Import/Export > Import CSV Records as shown below:
When prompted, choose:
Import Type > Transactions
Record Type > Journal Entry
Then, click the Select button to choose your General Journal CSV file and click Next.
When prompted, choose Add and click Next.
Finally, map your fields, name your import and click Save and Run to start your General Journal import.
And your Amazon settlement import is complete!
Related Articles:
Uploading your Chart of Accounts File: For more information on uploading your chart of accounts, read our article HERE
Carry Forward Balance: A "carry forward balance" account is required. For more information on the carry forward balance, read our article HERE
Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE