Although Pandle doesn’t yet have a direct integration with Amazon, there is an easy way to input your Amazon summary reports in Pandle to accurately record your sales, refunds and selling fees.
Retrieving summaries from your Amazon account
We recommend entering financial summaries for each Settlement Period.
To find the summary for each of your Settlement Periods in your Amazon Seller Central account, go to your Reports page, then click on the All Statements tab.
From here click on 'View Summary' for the period you wish to enter in Pandle:
You will then receive a summary similar to the following, which we will use for our example:
Entering your summary in Pandle
To enter the above information in Pandle, you will need to follow these simple steps:
1. Create a new a bank account called 'Amazon Seller Account', or something similar.
To do this, go to Enter Transactions > Banking Tab > Click 'New Bank Account' and select the manual entry method.
2. Enter the information from your Amazon summary report in the form of new manual bank transactions, as seen below.
You may need to add new categories for your 'Amazon Returns' and 'Amazon Seller Fees'.
Please note: The total amount of your Amazon sales is made up of your 'Product charges' plus and any 'Other (shipping & gift wrap credits)', as seen below:
3. You will need to ensure you enter the date for each transaction as the last date on your Amazon summary report.
4. Once all the data has been entered from your summary check that the balance of your 'Amazon Seller Account' bank account in Pandle is the same as the amount Amazon will be transferring to your actual business account.
5. Once you receive the money in your business account you will need to categorise this transaction in Pandle as Money In from your ‘Amazon Seller Account’. This will bring the balance of your 'Amazon Seller Account' bank account in Pandle to nil.
Here is an example of how to do this:
Multiple Tax treatment
If you sell products which have different tax rates you will need to breakdown your Amazon sales by tax rate.
To do this you will need to add a new sales transaction for each different tax rate.
Multiple Amazon Seller Accounts
If you have multiple seller accounts then you should receive a summary from Amazon for each of these accounts. Each seller account will need its own bank account in Pandle with the above process completed for each account.