Setting Up Sage Account for ecommerce company

Tahirfayyaz

Free Member
Jul 13, 2007
41
1
London
Hi,

We have recently started working with an accounting company for our e-commerce company and it seems to me they are not doing it correctly for our business needs as all they ask for is our paid and due invoices but do not ask for the following information.

Our daily sales (split between our website, ebay, amazon and play.com)
Our stock levels
Our current bank balance and when the actual payments come out of and into our account.

Are there any accountants that have experience with working with sage and e-commerce companies successfully? We have been looking at www.getconnect.co.uk to synchronise everything automatically

- Do we need to account for every single sale we make individually and compare this to the stock value to calculate the profit made on daily sales?

- If above is true then will we need to keep the product information and stock levels accurately stored in sage.

- How do you allocate the payments to the actual orders as they do not come into our bank immediately. For example we have the following scenarios

1) Website orders go through sagepay and daily batched into our account at midnight. which takes 2 working days to go into our bank account

2) website orders go into paypal. ebay orders also go into paypal. Paypal take their fees from the payments so we dont get the full sale amount. These payments are manually transferred every few days into our bank account which takes 3 to 5 working days

3) Amazon sales are stored in the amazon account for 2 weeks and then transferred into our account less the amazon fees and this takes 7 to 10 working days.

Do we need to reconcile which paid orders go along with what payment is coming into our bank account?

Thanks for any advice

Tahir
 

Brightpearl

Free Member
Jan 23, 2008
305
27
Oh boy, you're in for a few years of headaches if you're going down the route of Sage and web based ecommerce.

How about a really simple powerful solution where the whole lot is part of one application?

Have a look at www.ecokitchensonline.com for an example of the type of websites we do, and of course this comes with full accounting built in! These guys moved to Pearl from Sage, by the way.

... and if you sign up today then you benefit from our 75% offer :)
http://blog.thisispearl.com/2010/01/06/theres-no-business-like-snow-business/

Chris
 
Upvote 0

Tahirfayyaz

Free Member
Jul 13, 2007
41
1
London
Hi Chris,

I have looked at pearl before and spoke to someone at your company but we already have new website being built and so only need the accounting side but unfortunately it seems like your system will not connect to our website, ebay, amazon and play

our new website will download all the sales from amazon, ebay and play.com into our website backend and then we just need to transfer all that detail into the accounting package. Would we be able to export all these sales into pearl?

Tahir
 
Upvote 0

Tahirfayyaz

Free Member
Jul 13, 2007
41
1
London
I was actually going to pearl a try as it would be great to have the stock control and accounts as one system

do you recommend that as a ecommerce company we account for each sale individually and for each product sold? will this tie what has sold with the stock control and automatically adjust the stock levels

will give it a whirl this weekend and get in touch if I have any problems

Tahir
 
Upvote 0

Naughty Vend

Free Member
Aug 5, 2007
942
179
Sage Line, Sage SDO Keys, Actinic Catalogue or something similar... job done. :cool:

Use departments to seperate your site sales etc for reporting, if you want to get really clever use Moleend OSA for automation, you can go on holiday and it'll download your orders and dump them into Sage automatically, if you are an absolute showoff get Codepath's Dropship and Soapbox for dropship emails and site reviews.

Why does everyone whom know nothing have so much to say?
 
Upvote 0
Why does everyone whom know nothing have so much to say?

Indeed so, I've got hundreds of customers using my software to download from eBay, Amazon, Play & Websites into Sage 50 with no problems at all...

To answer some of the specific questions:

1. It is possible to have all sales going to a single customer whilst still retaining stock control and individual customer addresses in invoices.
2. There's not much you can about the delay in receiving payment but, my software, for example, will also download PayPal and Amazon fees so the bank account balance reflects what you actually receive from PayPal or Amazon.

John
 
Last edited:
Upvote 0

Latest Articles