I sell sinks & taps on Ebay, Ebid & now on my own website.
I have started off using Sage Line 50 to do my accounts on but to be honest I am finding it a bit of a cumbersome way of doing it. I am familiar with Sage but I'm not sure I have made the right choice in using it. I have 3 client accounts in Sage one for each sales point and produce an invoice for each sale and then a corresponding payment.
I accept payments by Google checkout & Paypal and then transfer the monies over to my business current account.
How does everyone else deal with Ebay/web sales bookkeeping? I have approx 200 sales a month so hand writtten books is not appealling! Would I be better off with a spreadsheet and if so can someone recommend a template?
I am a small business owner as well and have just started using Kashflow, very good so far. Who hosts your website as some websites have API's that communicate with some accounts software directly..... without the need for Tradebox
I have just joined the forum today and can confirm that I use Tradebox.
We typically have around 500 sales per month across several platforms.
Tradebox will import the last 30 days of sales from Ebay as that is all the API connection will allow.
We got around this last year by creating a CSV file and did a manual import into Tradebox and then into Sage. This was for about 3000+ transactions.
If you are good at manipulating data in Excel, it makes life a sight easier.
For Amazon, Tradebox will import MFN Sales (Merchant Fulfilled Network - items you post yourself) for the last 30 days unless you have saved previous Order Reports from the Amazon interface and then you can go back as far as they do. We made an horrendous mistake with this as, before we had Tradebox, we had set it to generate Order Reports every day but we hadn't realised it will only save so many in the interface before losing them off the bottom. If memory serves me correctly, we were able to set up a case in Amazon and get them to delete the Order Reports and upload them in tranches which we then downloaded, emailed them and then they uploaded the next tranche. Lifesaver!
You can set Tradebox up to do your own website also.
PM me if you want additional information on Tradebox.
He only feels the need to do an annual stock count, for adjustment in the financial statements. So, throughout the year, I just post the fortnightly statement, through Sage bank accounts I set up for Amazon.
I operate Amazon UK, Amazon France and Amazon Germany bank accounts on Sage, as well as Google Checkout and 2Checkout. ON USD and Euro, I use the bank receipt to work out the conversion rate, so that I can re-value of sales and fees from the original currency.
The posting takes me about half a day, once a quarter. I use a spreadsheet to quickly tally the quarter sales and post in one go. The client is happy at this, as they don't really use sage other then for the VAT and the Accounts.
I am currently reviewing the implications of selling to other countries, as the VAT system is changing in 2015.
ON USD and Euro, I use the bank receipt to work out the conversion rate, so that I can re-value of sales and fees from the original currency.
This is exactly what I do and then work back the conversion factor at the point of bi-weekly disbursement from Amazon.
I cannot remember if Tradebox would handle this if I ran Sage 50 Acccounts Professional. I think it does but it simply needs setting up as another currency in Tradebox.
I cannot remember if Tradebox would handle this if I ran Sage 50 Acccounts Professional. I think it does but it simply needs setting up as another currency in Tradebox.
Based on something another client said to me, after they enquired to Sage about the multi currency function - you need a higher version of Sage. Sorry, I cant remember which one.. it may have been an add on to Sage 50, I am not sure :)
