Set Up Amazon Sales Receipt Import

Amazon sales receipts can be imported from files placed on an ftp server, or from a file location on a PC. You will have already created a supplier for your Amazon account and a bank account to which receipts are assigned.

Amazon supply the sales receipts in a defined format.

Setting up Amazon Sales Receipt Import from a File Location

1. On the Utilities menu, click Order and Receipts Import Config.
2. Click the Receipt Import Configuration tab, then the Settings tab.
3. Find the Amazon settings section.
4. To set the location you want to copy the Amazon receipts to, in the Receipt path box, click the ellipsis […] button and browse to the folder where you want to paste the receipts. For Horizon Cloud users, we recommend that you use a tsclient location. Click OK.
5. Leave Select location to transfer Amazon receipts from blank unless we ask you use it.
6. In the Trader code list, select your Amazon supplier code.
7. In the Bank list, click the bank account to which you want the receipts assigned.
8. In the Payment type list, click, for instance, Internet. You cannot add payment types into Horizon.
9. In the Allowed difference (p/c) box, type a tolerance (as a percentage of the invoice total) that you will allow the receipt and invoice totals to differ. Differences are caused by rounding conventions differing between Horizon and the vendor.
10. In the Receipt failure email box, type an email address to which notifications of import failures should be sent.
11. Click OK.

Setting up Amazon Sales Receipt Import from an FTP Site

If you prefer to set up an FTP site, upload the sales receipt files and let Horizon download and import them, you can ask your IT people to set up a server for you, and enter the credentials here.

1. Set up the Amazon sales receipt according to the instructions above, ignoring the file location configuration steps.
2. Click the FTP tab.
3. In the Host box, type the address of the FTP server. This will be supplied by your IT support team, not ECI Software Solutions.
4. In the Username box, type the FTP account's username.
5. In the Password box, type the password for the FTP account.
6. In the Directory box, type the name of the directory to which you will upload the receipts.
7. Click the Tick button.
8. Click the entry for that server in the grid. Your settings are displayed below the grid.

See Also