a store what intergrates with accounting software?

[dustybin]

If one runs a online store it seems competely logical to have your accounting software in sync with all the sales, etc to save you manually entering data. I would be interested to know about any solutions, open-source or closed-source. As all my business will be done in the UK, it would be ideal if the accounting software was geared towards the UK market.

[paulam]

I use openmind commerce for my shop ( www.openmindcommerce.co.uk (http://www.openmindcommerce.co.uk) )which integrates with kashflow ( www.kashflow.co.uk (http://www.kashflow.co.uk) ). I haven't set it up yet as I am still working on my website but I know there are some people on this forum that have and they had good things to say about it. I'm sure there will be someone along shortly than will know of some others.

Paula

[mke]

Most shopping cart software these days has modules available to integrate with the more popular accounting packages. See, for instance, Zen Cart, one of the most popular shopping carts on the web and it will not only tie in with several accounting systems, it has a module to tie it in with specifically British spelling, postcodes, VAT and more..

[DuaneJackson]

As Paula says, Open Mind Commerce integrates with the UK;s favourite small business accounting software. As does "Internet Retailer" and another product being added next week. See http://www.kashflow.co.uk/addons.asp

[dustybin]

Open Mind Commerce requirements are Windows 2003 Server, that is a complete NO NO NO, unix based platforms only for me, I could never trust Windows to be in charge of my store. The good points, at least you can buy a 'Open Mind Commerce' license what lasts forever.

Kashflow looks excellent, apart from the fact that you cannot buy a single license for it, one needs to keep paying out monthly or yearly to use it, that can work out expensive for ultra small businesses like mine. Also I dont like the idea of keeping all your account data with Kashflow, I would rather a solution where you keep all the data on your own server(s). What happens if Kashflow went bust? You would lose all your data...?!

I am going to carry on looking for store and accounting alternatives, maybe the open-source world has a few things up its sleeve, Magento Commerce looks promising!

[mke]

In which case I'd run my OS cart on PostreSQL instead of MySQL and use it together with an accounts package such as LedgerSMB.

[DuaneJackson]

What happens if Kashflow went bust? You would lose all your data...?!

No. You can set it to automatically email you a backup of your data once a week.

[tony84]

I would imagine most will have a feature to download a CSV file?

Once that is downloaded it should be possible to use it in excel or another piece of software.

[DuaneJackson]

I would imagine most will have a feature to download a CSV file?

Once that is downloaded it should be possible to use it in excel or another piece of software.

Yes, but that's a pain.

With the KashFlow integrated stores, customer and invoice records are created in the accounting software as soon as a sale is made

[Austin]

I have also a online dentist clinic and want to purchased accounting software some body tell me which type of software i purchase because i am new for this use please guide me?

[dustybin]

If one wants to do the open-source route, OSCommerce 3 Alpha is looking really good, the admin panel is excellent and its really fast, unlike Magento, what is slow and bloated. I think I'm going to stick with OSCommerce 3, test it out now, and start using it when its properly released. Now I will need to research some UK accounting software what can directly sync with OSCommerce 3, I dont think Kashflow is capable of doing that? There is a SMBLEDGER perl API for OSCommerce, but I cannot find any specific software at the moment.

[DuaneJackson]

KashFlow integrates with OSC via a thirdpart, paid-for service: http://www.carrytheone.co.uk/

I dont think any has yet released a free add-on.

[mke]

Remember that LedgerSMB is a fork of SQL-Ledger. There is much among the latter's docs and forums to help you.

[emerchant]

I know the thread is a little old but I just wanted to point out that easywebstore (http://www.easywebstore.net) now integrates with KashFlow (http://www.easywebstore.net/kashflow).

[mangoprint]

I use Openmind with Kashflow for mine.

[openmind]

Open Mind Commerce requirements are Windows 2003 Server, that is a complete NO NO NO, unix based platforms only for me, I could never trust Windows to be in charge of my store. The good points, at least you can buy a 'Open Mind Commerce' license what lasts forever.

I've only just come across this thread but I had to pick up this point I'm afraid...

A server operating system is only as secure as the server admin responsible for it's security. Linux OSs are just as liable to be attacked and the attack will succeed if the base is not tied down.

Disregarding an ecommerce platform as it does not run on Linux is a little blinkered IMHO ;) I think you will find that is more likely that the application will be compromised by poor coding rather than the operating system more so where the software is not developed in a controlled environment such as open source.

One last point, Open Mind Comerce actually only requires ColdFusion to run. ColdFusion will install on both Windows and Linux so the operating system becomess irrelevant.

I hope this clarifies the issue and as mentioned above, OMC ties in directly with KashFlow to provide a seamless web store/accounting package, it will save you a tremendous amount of time...

[WhiskyFive]

The CarryTheOne service does integrate OSCommerce 2.2 with KashFlow:
http://www.carrytheone.co.uk

Support for OSC 3.0 will be available in around 10 days - feel free to PM me if you have any specific integration queries that I might be able to help with.

It works with OSCMax already, and we are testing with CRE Loaded.

Ed
www.carrytheone.co.uk

[Peter Bowen]

I've just finished integrating our latest online offering (www.clientfishing.com (http://www.clientfishing.com)) with KashFlow. I just love the fact that one can automate all of this stuff. For those who might be interested it works like this:


Interested parties sign up for a quote on our website.
The details are captured as a lead in SugarCRM (free opensource crm software).
If they accept our quote one click sends their details from SugarCRM to KashFlow where we make an invoice and email it with a coded link to the client.
They click on the link and they are taken to a page that retrieves the invoice details and sends them to SagePay to pay the bill.
If the transaction is successful the invoice gets automatically marked as Paid on KashFlow (and the amount added to the bank account in KF) and a note is made against the customer record in SugarCRM.

I'm sure that this saves at least 2 hours per day of manual data entry and processing.

I presume we'd have to pay about £10 per hour for someone to do this kind of work, add all the extra costs of employment and we're probably looking at £20/hour x 2 hours/day = £200/week x 52 weeks = £10 400 per year. That's a significant cost advantage to have over the competition. I love this stuff.

[WhiskyFive]

That's great - KashFlow is really beginning to rack up the applications.

The more they have, the more attractive the platform is and the more customers they attract (and the more potential customers the application developers get to).

While it is good to have the direct billing relationship with the customer, it would be ideal if KashFlow could have a one click "add app" within the service, with the cost automatically added to their monthly bill.

I wouldn't even object to them taking a commission - although not a big one!

[DuaneJackson]

Nice - will you be sharing the SugarCRM integration code?

[Peter Bowen]

I'd be happy to share it. I've been developing 2 php classes for my own use - one for sugar and one for KashFlow.

At the moment they only do what I have needed so far. I'm extending them as i need the extra functions.

Cheers

Pete

[Chakkilam]

I have also a online dentist clinic and want to purchased accounting software some body tell me which type of software i purchase because i am new for this use please guide me?

Try getting Qucikbooks, it offers software as per your requirement

[Chakkilam]

Dear Sustybin,

Try to Quickbooks or visit their website. ITs offers accounting software for all sizes of businesses

[Tradebox]

Tradebox offers financial integration between e-commerce websites, eBay, Amazon and Play.com into Sage 50 Accounts v12 onwards or Sage Instant Accounts v15

[Tradebox]

Tradebox offer a middleware solution, Finance Manager, which acts as an automated bookkeeping tool, downloading orders from eBay, Amazon, Play.com and ecommerce websites into Sage Instant or Sage 50 accounts solutions.

In conjunction with Sage, Finance Manager provides the online seller with a powerful package, enabling them to:



expediently import and process high volumes of online orders
automatically calculate correct VAT liability for each order
print invoices and dispatch notes
identify products for shipping
deplete stock
assess and reorder supplies
maintain an accurate financial account of their online sales.

[Brightpearl]

Hello People -

You've maybe not heard of Pearl - it's a full ecommerce system with built in accounting, contact management and super powerful order processing. And it starts for FREE (http://www.thisispearl.com/features/pricing-c-393.html)!

http://www.thisispearl.com/images/categories_desc/screenshots/originals/homeslides_landingslidesmall.jpg (http://www.thisispearl.com/features/pricing-c-393.html)

[Chris Ashdown]

Just my little input to this old thread

Actinic has a direct link program to Sage line 50 so you can easily export all sales to Sage and a more limited input from Sage to Actinic.

Also worth pointing out Sage has now taken over Protx so should have better links between Actinic and Sage-Protx

[WhiskyFive]

For any store owners reading this thread, we would love to know which shopping software you are using and which accounts software you'd like it integrated with.

We've got a short survey to complete (12 questions) that would help us to work out which software to integrate next:

http://www.surveymonkey.com/s.aspx?sm=8ENnh84Aq8ZZ7zpTs6fYIw_3d_3d

Thanks in advance!