Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more


Developing a Payroll System in Filemaker

Posted on 2008-06-16
Medium Priority
Last Modified: 2013-12-13
Hi Experts,

I am trying to create a payroll / leave system in Filemaker. The objective is:

1. Get daily time & attendance data from bio metric machine from remote offices
2. Import the txt file to filemaker DB
3. Calculate employee salary based on a monthly payroll period
4. Have ability to print all employee payslips for a give payroll period in one hit
5. Export employee payroll list with salary amount as excel report for finance
6. Calculate employee absence data - link to online self service leave request application (Using Filemkaer API for PHP) where employees can request leave, have this approved by a manger and deduct from the employees remaining allowed days quota

Basically can anyone tell me a ER diagram of the correct database structure to achieve this, including links and calculations?? Or better yet has a working example of a filemaker payroll system to download??

I have attached the sample data from the time attendance machine to this post as well as my current database layout.

I am totally new to database stuff so any help will be greatly appreciated.

All the best,


Question by:sam_thwaites
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
LVL 28

Expert Comment

ID: 21795242
if, you're totally new to databases, I would certainly not start with such an application, too many consequences if case of of pbs.
On top, a payroll is something generic almost, there are plenty out of the shelf, so it is rarely useful to write yours, just choose one which allows to report to yr finance dept correctly, and do the biometric i/f if not supported only.
Payrolls and Accounting is someting I would never write, too much work and rules to respect, buying one is a lot cheaper, and save time to design what is specific to your company.

Author Comment

ID: 21896375
Hi Lesouef

Do you have any suggestion for good off the shelf Filemaker HRSM and Payroll Systems.
LVL 28

Expert Comment

ID: 21897160
unfortunately no since these apps are closely related to each country law, same as accounting apps, so all I know are my country applications (France). The only software editor which is having apps in several languages here is Sage (UK originilly), but I have no experience with their offer; check if they have something within your country.
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Expert Comment

by:Peter Harris
ID: 23720202
If you were going to build a custom solution it would be best to hire an experienced FileMaker developer as it really would be a challenge for someone new to databases to meet your requirements.

Author Comment

ID: 23729694
Thanks for the comment Cogitive, After searching for both good HRD software and a filemaker developer in Indonesia without results I decided to create the system myself. Current status is it is live and running well, even managed to get it online through our intranet. Filemaker is an amazing bit of software and easy to pickup.

Expert Comment

by:Peter Harris
ID: 23729784
Slight sidetrack - but wondering what do you use for intranet access? Is it VPN software?

Accepted Solution

ee_auto earned 0 total points
ID: 24277363
Question PAQ'd, 500 points refunded, and stored in the solution database.

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Suggested Courses

647 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question