Site Map
Phone Now 01323 649779

Contact us now!

Phone 01323 649779, email us or fill out our online enquiry form.

Newsletter

Privacy | Unsubscribe

Sage Export: Card Refunds as Audit Trail Transactions

Sage Export: Card Refunds as Audit Trail Transactions generates a .csv file of all card refunds ready for import into Sage.

In order to export the data, you must have the administrator permission and the Sage export feature must be enabled on your website. Contact technical support if you would like this feature enabled.

How to export card refunds as Sage format audit trail transactions

Step 1: Login to your account and go to the administration home page.

Step 2: Select "Export Data" from the menu.

Step 3: Choose "Sage Export: Card Refunds as Audit Trail Transactions (CSV)" from the drop-down list.

Step 4: Complete the form and press continue to generate the feed.

Step 5: When the feed has been generated, your browser will prompt you to download it - select save to download the file to your computer.

Sage Card Refund Export Properties

File Name - specify a suitable name for the file e.g. sage_order_export.csv.

Start Date - specifying a start date will only export refunds made on or after that date. Use the format dd/mm/yyyy e.g. 01/12/2004.

End Date - specifying an end date will only export refunds made on or before that date. Use the format dd/mm/yyyy e.g. 31/12/2004.

Customer Account Reference - the account reference of the Sage customer account representing your generic web customer.

Nominal Sales Account Reference - the nominal ledger account for your web sales.

Mispostings Account Reference - the nominal ledger reference of your mispostings account, usually 9999.

Bank Account Reference - the nominal ledger reference of the bank account from which the refunds were paid.

Sage Username - the Sage username that the transactions should be posted under, usually MANAGER.

Sage Card Refund Export File Format

The system creates four audit trail transactions for each card refund made on your site. Each refund has the following format:

Row 1: SC,[Customer Account Reference],[Sales Account Reference],,[Date],REFUND,Refund - [Order ID],[Net Cost],1,[Tax Cost],,[Sage Username]
Row 2: SI,[Customer Account Reference],[Mispostings Account Reference],,[Date],REFUND,Allocation - [Order ID],[Gross Cost],9,0.00,,[Sage Username]
Row 3: JD,,[Mispostings Account Reference],,[Date],REFUND,Refunds (S) - [Customer Account Reference],[Gross Cost],9,0.00,,[Sage Username]
Row 4: JC,,[Bank Account Reference],,[Date],REFUND,Refunds (S) - [Customer Account Reference],[Gross Cost],9,0.00,,[Sage Username]

Do I have to create the file every time I need it?

No. Once you have generated the feed, it will also be available from the files directory of your website e.g. if you specified "sage_export.csv" as the name of the feed, it will be available at www.yourdomain.com/files/sage_export.csv.

Did this help? More documentation, search website