I don't know if this post belongs on this board move if necessary.
I have a friend who has a small business, he sells loose gemstones. Now he needs help with keeping his accounts and track of stock and invoices. He is currently using MS Excel to keep accounts but the problem is cross referencing different cells in different workbooks.
He obviously has a list of all his stock, and then when he sells something he has an invoice. Sold items then must be subtracted from the original stock and update of what loose gemstones he has left has to be made. Anyway its a bit more complex than that but here is my question:
What is the best software to handle this sort of business? In the UK we have SAGE, is this appropriate? Any advice will be welcome.