4.4. Reporting

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-related because that's where most data goes but we'll also discuss how you can extract useful information about your time, invoices and payments.

4.4.1. Time Reports

To learn more about the time you record in Fanurio, go to the Timesheet view and use the filters above the time entries table. The table will display only those time entries that match the selected filters. Time can be filtered by:

  • date,

  • status: invoiced or not and

  • client, project or service item.

Once you set these filters, the table footer will display the total of all visible time entries. For instance, you could use these filters to see how much time you've worked on a date, week or month.

Note: If these time reports are not enough, you can also use project reports to learn more about your services and the time recorded on them.

If you need to do extra calculations on the list of time entries, you can also export it to CSV or Excel from File » Export.

4.4.2. Invoice Reports

To learn more about the invoices you create, go to the Invoices view and use the filters above the invoices table. The table will display only those invoices that match the selected filters. Invoices can be filtered by:

  • status: paid, unpaid or overdue,

  • date (creation),

  • number or

  • client.

Once you set these filters, the table footer will also display totals for:

  • balance (how much money you must receive),

  • 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.

If you need to do extra calculations on the list of invoices, you can also export it to CSV or Excel from File » Export.

4.4.3. Payment Reports

To learn more about the payments you receive, go to the Payments view and use the filters above the payments table. The table will display only those payments that match the selected filters. Payments can be filtered by:

  • date,

  • invoice,

  • reference or

  • client.

Once you set these filters, the table footer will display the total of all visible payments. For instance, you could use these filters to see how much money a client has paid you this year.

If you need to do extra calculations on the list of payments, you can also export it to CSV or Excel from File » Export.

4.4.4. Project Reports

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 to display such a report:

  1. Go to Report » Projects or

  2. 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 specify what kind of items will be included in the report. You can specify items by:

  • type: services or expenses,

  • billing: billable or not and

  • status: invoiced or not.

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. Please note that you can get the same result if you go to the Timesheet view and restrict visible time entries to today.

  • 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.

4.4.5. Example: Project Reporting

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).

  1. On Monday: You do 1:12 hours (1.2 in decimal format) of X

  2. On Tuesday: You do 3:24 hours (3.4) of X

  3. On Wednesday: You do 2 hours (2.0) of X

  4. 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 service 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 a service item billed in hours 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 a service billed in hours has a fixed discount.