[Skunkworks] Mpesa paybill business number - data problems

Dear great people, I am currently developing a system that allows customers to make payments for items through mpesa using the safaricom paybill system. Works pretty well extracting the data from the excel sheet safcom normally provides and updating the accounts. However, my challenge is that I want to eliminate that human intervention where one has to import the excel from mpesa database and then upload to the ERp system we are developing.. I know an API would be the solution but of course Safcom wont give you access to database so no way to get the data update seamlessly. Any one with such an experience and do you have some kind or recommendations basically to assure the client on data integrity. regards Oliver