Jump to content

Make invoice from employee time records


This topic is 2883 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
I need help with Time Billing. We are a service business and bill clients only for our time, we have no products and no inventory. We have a very basic file where employees enter their activities by creating a new record each time they work on something. Fields are: 
Date  |  Employee  | Job Number  | Client  | Activity  | Time  | Rate  | Total
I need to generate invoices from the records in this file. What is the best way to find all the time posted to a particular job number, sorted by activity? Should this be in the same file with 2 layouts or in 2 separate files?
Invoice should show a single dollar figure for all employees who performed a certain activity on the job. Using a sub summary part (sorted by job number) I can get totals, but I can't figure out how to also summarize the activities and turn all that into an invoice.
Invoices need only the following:
Bill to/address/date (which it obtains from contact file)
Job number 
List of Activities: (2 examples listed here)
  –Proofing . . . $00.00 
  –Research. . . $00.00 
GRAND TOTAL (of all proofing + research for this job number)


Link to comment
Share on other sites

No need to add a file.


Probably the easiest way to generate an invoice is to sort the time entries like you want them and then loop through them and add things up, turn around and create an invoice.  You probably should also mark each time entry record with the invoice ID (or invoice line item ID) so you can drill down when needed.


What tables do you currently have in your solution?

Link to comment
Share on other sites

You can use FileMaker's subsummary feature to help with this. Create a layout with a subsummary by activity. Then when generating the report, do a find for the relevant time entries, and then sort by activity. You can include a summary field in the subsummary part that shows a total for that activity.


This can be easily done in the same file which holds the time entry table.

Link to comment
Share on other sites

This topic is 2883 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.