So the people talking to the customers and taking down the payment info, how would they get the information into the database? Is there a GUI or some kind of software they use that write back to it, or do they enter it using SQL scripts themselves?

Of course, the best answer is to just let the people talking to customers enter the payments...this would also save you some money in accounting salaries...