Operating System Version? Filemaker version? Language?
What software or paper based process is he using to get this information now?
Quickbooks the most common software for businesses to track all these.
There is a plugin that will connect Quickbooks and Filemaker on Windows.
There are some documents linked in this list that may be useful
And it is Possible to do this all in FileMaker via additional tables, relationships and summary and/or cross tab reports, though this appears in many ways to be "reinventing the wheel" given the mature accounting software systems already on the market...
I got Easy Accounting from Advance Database Systems and got some tech support from David. He helped me intergrate the solution into mine and shared some helpful technical knowledge that I am very appreciative for. The solution was very clean and easy to use. I would recommend you check it out and I hope it works for you too.
If you read this....
Thank you David from Advance Database Systems!