Reports help you understand how you and your business are doing so that you can quickly make well-informed decisions. This section talks about the reports that make this possible.
The most important reports are project-releated because that's where most data goes but we'll also discuss how you can extract useful information from the list of invoices.
When using Fanurio, you only get to see one project at a time. You can see its items and how much time and money was recorded. But if you need to see time and money information for more projects, you need to use project reports. Depending on what you need, there are two ways of displaying such a report:
-
Go to or
-
Open a project and click the link under the items table.
A project report contains information about one or more projects during a specified period. To create one, first specify the projects and the time period. Then, since all project activity is recorded using items, you can specify what kind of items will be included in the report. You can filter items by their billing type (flat, hourly or none) and by their invoicing status (invoiced or uninvoiced).
Finally, you need to specify the template used to display the report. Fanurio comes with a set of default templates to help you see both time and money in various useful formats.
-
Timelog shows the recorded time by date in chronological order.
You should use this template if you want to review what you've done on a certain date. You may want to use it at the end of the day, to see where you spent your time.
-
Project Timelog shows how much time was spent on each project, in detail.
-
Project Time and Money does the same thing as Project Timelog but it also shows the money earned for each project.
-
Time and Money by Date shows how much time you've recorded and how much money your work is worth by date.
You could use this template if you want to see how you are doing during a certain week or month. For instance, you could create a report at the end of the week to see how much time you've worked each day from Monday until Friday.
-
Time and Money by Week, Month and Year do the same thing as Time and Money by Date but instead of showing time and money totals by date they show totals by week, month and year.
If you use project reports frequently then you can create your own report configurations. These configurations will remember the report period and the other settings so that you don't have to specify them again each time.
Note: Project reports evaluate how much your projects are worth. They don't tell how much money you've made from invoicing your clients. Sometimes there can be a difference between the two. Suppose you have a project worth $1100 and you invoice it with a $100 discount for $1000. The project report will tell you the project is worth $1100 but that's not how much you've asked for it.
If you want to know more about your invoices, all you have to do is go to the Invoices view and use the filters above the invoices table. The table will only display those invoices that match the selected filters. Invoices can be filtered by:
-
paid status: paid, unpaid or overdue,
-
creation date and
-
client.
Once you set these filters, the table footer will also display totals for profit (how much money you've actually made), total (how much money the invoices are before taxes) and taxes (total tax money charged to your clients if you use taxes).
For instance, you could use these filters to see all overdue invoices issued this year for client X. The table footer will help you see how much money the client owes you.
These three elements (filters, table and table footer) should help you extract lots of useful information about your invoices. If you need to do extra calculations on the list of invoices, you can export it to CSV or Excel. Just click the small top-right button from the table header and then select Export Table Data from the popup menu.
The purpose of projects reports is to show how you performed over time in terms of time and money (profit). Reporting time is easy because the report only needs to see if there's any time recorded during the report period. Reporting money on the other hand is trickier because the value of a project or project item must be calculated over a period of time.
To better understand how reporting works, let's consider a few examples:
Example 1: Simple time and money reporting
Suppose, you have a project (My Project) that charges $100 per hour to do X (hourly-rated billing).
-
On Monday: You do 1:12 hours (1.2 in decimal format) of X
-
On Tuesday: You do 3:24 hours (3.4) of X
-
On Wednesday: You do 2 hours (2.0) of X
-
On Thursday: You do 1:06 hours (1.1) of X
The total recorded time is 7:42 hours (7.7 in decimal format) of X which means it's worth $770.
Table 4.1. Project report by date
| Project | Monday | Tuesday | Wednesday | Thursday | Total |
|---|---|---|---|---|---|
| My Project |
1:12 $120 |
3:24 $340 |
2:00 $200 |
1:06 $110 |
7:42 $770 |
This is a pretty simple example where time is easily translated to money. But let's see what happens when time rounding or discounts are used.
Example 2: Time and money reporting with time rounding
Now, suppose that all time is added to the same project item which rounds time up to 30 minutes. In this case, the 7:42 hours become 8:00 after rounding, meaning that the project is worth $800. Let's see how the report shows time and money over time.
Table 4.2. Project report by date on Thursday
| Project | Monday | Tuesday | Wednesday | Thursday | Total |
|---|---|---|---|---|---|
| My Project |
1:12 $125 |
3:24 $353 |
2:00 $208 |
1:06 $114 |
7:42 $800 |
The 1:12 hours from Monday are not worth only $120 because time rounding is used now. If 7:42 hours are rounded to 8:00 then 1:12 hours are evaluated to 1:15 hours (1.25 in decimal format).
But what if you work 18 more minutes on Friday? The total recorded time will be 8:00 hours and the project report now looks like this:
Table 4.3. Project report by date on Friday
| Project | Monday | Tuesday | Wednesday | Thursday | Friday | Total |
|---|---|---|---|---|---|---|
| My Project |
1:12 $120 |
3:24 $340 |
2:00 $200 |
1:06 $110 |
0:18 $30 |
8:00 $800 |
Important: Please note the differences between the two reports. As time is added to an hourly-rated item that uses time rounding, its value changes in time. This is not an error but rather a recalculation that displays the real value as work progresses.
The same thing happens if an hourly-rated item has a fixed discount.
|
Copyright © 2006-2008 Atelier Software SRL |