Would anyone know if there's an App that will connect / integrate the POS System that Subway use to Quickbooks Online ?
We have a new client that has taken over a Subway franchise and I'm looking in to an easy (and digital) way to import the transactions from the clients POS system directly in to Quickbooks Online.
The system is Subways own and it's called SubwayPOS.Ink
I'd love to be able to use an App, but after an hour of Googling, I've found nothing so any help would be appreciated
Replies (7)
Please login or register to join the discussion.
I doubt it - Most of the time an App will only be designed to extract data from (or deal with exports from) known/popular systems. We were involved in the implementation of a 'new' app designed to enable a bespoke system to link into cloud software. I don't know the total cost but believe it was about £15k.
If the Subway POS is based upon a standardised system, then an existing app might be possible. That could be your first point of call.
But, I reckon you are going to need to have them (or Subway if centralised data although I doubt it) export data and then your going to have to either design your own app, or have one built for you. Or you can sort the data manually.
Is the till online - if so, then will the owners allow an API access login? If not, find out what data can be exported If that data is easily manageable then fine. If not, get some nerd to write you a program.
If Subway's system allows you to access its underlying database, then you got a fighting chance of creating a link without too much effort.
Play around with 'Get Data' from within Excel. If you can pull in the data to Excel without requiring passwords, there's hope for other apps. Otherwise you'll need to have a chat with the Subway peeps.
Im not up to date with the latest Subway software, but when I prepared the accounts for apprx 25 stores some years ago, I printed off the 'WISR' report from the POS system which gave all of the necessary info ie weekly totals for Sage50. Further info was available for split of product sales, active discount codes, food & labour %, food usage & waste etc. All very useful for KPIs, not so much in the pure accounts sense. With just one store the client should easily be able to summarise the info to a spreadsheet for you to upload.