SageForum for UK versions of Sage 50- Help and support.

Hi all,

New to Sage so please bear with me.

I currently sell on ebay and use a 3rd party app for managing the orders and need to import the data from this app into Sage. I'm ok exporting the data out of the other app and I know I need to use the import function in Sage and import it as 'Audit trail transactions'. I've completed a basic test import and am happy with the process.

My ebay sales are global and I am VAT registered so I have varying transactions where some are charged VAT (EU) and others are not (ex-EU). I also sell in GBP and AUD. My confusion is how to deal with these and import them into Sage.

I realise I have to set up some customer records to receive the import. The easiest being one for ebay sales in GBP, for example with Account Ref of EBAYGBP.

My first question is about Nominal Codes - If I use the sales code of 4000, this has a default name of 'Sales Type A' so I assume I can rename that to perhaps 'Ebay Sales GBP'?

Now when it comes to the AUD sales, I assume I can set up another customer record, lets say with the Acc Ref of EBAYAUD. I can then use a separate Nominal Code (and perhaps call it Ebay Sales AUD) but how do I ensure it is set to Australian Dollars? I realise I can set the customer records default currency to AUD but I can't see any way to assign a currency to the Nominal Code - does this matter?

When I was looking at the Nominal Codes I see that I could create one with a 'Type' of Sales and a 'Category' of Export Sales - do I need to do this for any sales that I am exporting out of the EU (and therefore not charging any VAT on)?

Apologies for the numerous questions but I hope you can help.

Many thanks

You can import it all as 4000

You need a "bucket" sales account for each currency. Currencies need to be set up in Sage 50.

Which 3rd party app?

Thanks for your reply

brucedenney wrote:You can import it all as 4000

Is there any benefit in using different different different codes for different sales for tracking or auditing?

brucedenney wrote:You need a "bucket" sales account for each currency. Currencies need to be set up in Sage 50.

I have currencies setup. Following an ebay sale, the funds are credited to an AUD pot within Paypal so I have created a separate bank account in Sage called 'Paypal AUD' - is this what you mean?

brucedenney wrote:Which 3rd party app?

1stoporders

Using more nominal codes allow you to analyse your sales (and expenses) into more detail. e.g. You could breakdown sales by types of products in order that you could compare profitability of the different types and then use that information to decided where to spend resources to get best return.

With a proper integration you would import as invoices and sales receipts this way you have stock control & a fully traceable vat trail, you could also let Sage do the nominal code based on products codes.

But, you are using the basic built in Sage audit trail import format, this does not do transaction grouping so splitting an invoice into multiple nominals will not be nice as it will come through as separate transactions. You could import the payments, but these would not match off because you can only import as sales receipts on account and you will have to match them of manually later, it is not going to be great.

Perhaps you would be better off ignoring the customer ledger all together and just entering Bank Receipts against one nominal.

One stop looks rather nice, seems to integrate to "everything" so you can chop and change between shopping systems but use one thing to load it all into sage.

That's great - thank you for your advice