Allegro Data Solutions

Home | Services | Products | Contact

Allegro Timeclock 4.0

This solution is a virtual time clock that allows you to “punch in” and “punch out” when you work on jobs. It automatically calculates the amount owed based on the hourly rate you specify. You can also enter line items for your expenses, credits, and payments. Your virtual time cards can be printed as invoices or saved as pdf files for your clients.

Allegro Timeclock (Freelance Edition) 4 —  $49.99
This bundle contains a new, completely redesigned version for FileMaker Pro 13 & 14. It also includes the earlier versions in fmp12 format (for use with FileMaker 12 through 14). All are fully functional but do not allow you to make changes to the layouts, tables, scripts or relationships. This software is intended for a single user on a single computer. It cannot be shared on a network.
Allegro Timeclock (Small Business Edition) 1.1 $49.99
Originally sold for $99.99. This bundle contains fmp12 format files for use with FileMaker 12 through 14. Theyare fully functional, except for the fact that they do not allow you to make changes to the layouts, tables, scripts or relationships. This version is intended for small businesses with multiple employees. It is designed to be shared on a network, using FileMaker Server.


Allegro Timeclock (Freelance Edition) has been completely redesigned for FileMaker 13. It uses no currency symbols, so you can invoice international clients. A text field allows you to specify the currency. (For example, "Payable in U.S. dollars.") The virtual time clock now has  timestamp fields in place of date and time fields. This will give you the correct total number of hours if you punch in before midnight and punch out the next day. Also included in this bundle are previous releases, in U.S. and international versions, for use with earlier versions of FileMaker.


The user interface is divided into four main tabs:

Contacts - where you can store information about each of your clients, suppliers, etc.
Estimates - where you can estimate a job
Invoices - where you can log hours and other expenses, and also generate invoices
Help - where you can customize Timeclock and learn how to use its features

Navigation Panes on the left side of each tab let you easily find, filter, and sort the most commonly needed records. When you click on a record in a Navigation Pane, it appears in a Detail Pane on the right. Every client is automatically linked to his estimates, invoices, and notes. 

Click the thumbnails below for screen shots (will open in new window):

Each Contacts record represents one person or organization. They are listed in the Navigation Pane, on the left side of the screen. Clicking on a contact name brings up his record in the Detail Pane, on the right.

Contacts can have a virtually unlimited number of addresses, phones, email addresses, and representatives. Those you designate as defaults appear on the main layout. The others are stored in popover controls. You can add, delete, or modify them from the popovers. If your e-mail client is supported by FileMaker, a button allows you to send messages the main layout or the e-mail popover.

If you have entered a contact's URL in the Website field, the Web button displays it from within Timeclock.

You can view a contact's estimates and invoices with the other buttons. This is much faster and easier than searching for an  estimate or invoice on the main layouts. The contact's current balance is also displayed. The Report button allows you to print a client's billing history (all invoices and payments) for the date range you specify.

You can generate estimates which include labor costs, materials, and other expenses. These can be printed or saved as pdf files. The button used for this purpose displays an X once the estimate has been generated, but it does not prevent you from re-printing or re-saving them as pdfs. Estimates and Invoices have two fields for comments. One appears on the document for the client. The other is only visible in your database.

The Invoice Tab functions like a virtual time clock. You "punch in" and "punch out" with buttons. The timestamps are entered automatically, but they can be modified if you want to round the figures up or down. You can create time cards for any contact that you have marked as a CLIENT on the Contacts tab. The contact's addresses are automatically entered when you print an invoice or export it to a pdf file.

Your time cards become invoices when they are printed or saved as pdfs. The Punch In and Punch Out buttons create the line items. Another button is used to enter payments, credits, and other adjustments. One time card may represent a single day of work or multiple days. You can link Estimates to your Invoices, to compare the projected and actual cost of a job.

Allegro Timeclock has an integrated Help system that explains its features in more detail. It is linked to an HTML page on the Internet that you can check for additions, corrections, and update notices.

The Setup layout is where you customize your estimates, invoices, and add your business logo and contact information.

When you login as an employee, you will see a simplified time clock interface. Only your own unpaid hours are shown. You can punch in and out, but you cannot change the dates and times. You can log out to allow another employee to login.
The administrator and managers see an interface similar to the Freelance Edition. The Invoices tab has a column with employee numbers identifying the person who created the row. Dates, Times, Employee numbers and descriptions are editable. This allows managers to correct mistakes, such as an employee forgetting to punch in or out.
A payroll tab, available only to the administrator, and optionally to managers, has a record for each employee and all his unpaid hours.
Clicking the Pay button (or the "+" button) creates a record of each paycheck and updates the list of unpaid hours. Taxes are computed based on rates that you can assign on the Help Setup screen.
Any paycheck can be voided by clicking the trash can icon on a row. This also marks all the hours associated with that check as unpaid and restores them to the list.
You can archive checks, to keep the list to a manageable size. Checks can be unarchived simply by marking a checkbox.
You can also add any number of payroll notes to an employee's record.

If Timeclock doesn't suit your needs, you can hire Allegro Data Solutions to modify it or build a similar solution tailored to your particular business needs.


The Allegro Timeclock (Freelance Edition) 4 zip file archive contains version 3.1 and 4 (in fmp12 and fp7 format, repsectively). Simply save the appropriate version to your desktop and click on it to start FileMaker. You can also open it from within FileMaker.

Allegro Timeclock (Small Business Edition) 1.1 has not yet been updated for FileMaker 13. However, the zip file contains U.S. and international versions of the solution converted for use with FileMaker 12 and 13, along with the original versions for FileMaker 11. To host the Small Business Edition, follow the directions in the FileMaker Server manual.


FileMaker Pro 11, 12 or 13 and a PC or a Mac that meets the minimum hardware requirements for the version of the operating system that you are using. The appropriate FileMaker Server version is required to share Allegro Timeclock Business Edition on a network.