Did you take a look at the Starter Solutions?
Creating a database to do this is definitely doable, but you should take the time to learn the basics before you invest alot of time. Then spending a lot more time re doing it.
Im a huge FM fan, but I wonder it this may be a better job for Quickbooks. Besides just recording this info, how else do you need to use this data?
Here's a thread that describes a "bookkeeping" ledger that could be adapted for this purpose by including a field for the person and a field for the category: https://dl.dropboxusercontent.com/u/78737945/AccountingLedger.fmp12