Time sheet details

The Time sheet functionality simplifies and accelerates the recording and presentation of the working hours.
It is completely free, you just have to download and install Banana Accounting 9


Designed for employees with flexible working hours or for those who are required to record their presence at the job.

  • Similar to Excel, you can copy and paste, correct.
  • Planning of scheduled hours, with customizable weekly schedule.
  • All calculations, hours due, hours worked, holidays and illness in hours:minutes.
  • Very fast input of hours, in two possible ways:
    • Start and end time with daily total calculation
      • Automatically enters the current time
      • Deviation + or - from current time possible.
        When you've arrived earlier or you're leaving soon.
    • Total daily hours worked
  • Difference between scheduled and performed hours.
  • Instant count of working hours, vacations and absences.
  • Totals for each day, week, month and year.
  • Carry forward by month and year
  • Easily customizable, it adapts to all work schedules.
  • Possibility of setting the holidays and paid leave.
  • Possibility to add columns, to record expenses, kms travelled or other.
  • It can be used for the entire year or for specific time frames.
  • Prints a monthly report, even with totals in decimal hours.

Important things to know

  • The time sheet is composed by a table called Journal where the working hours and settings are entered
  • The start and end times of the work are entered.
  • Vacations, sick leave, absences and others are indicated with hours and minutes.
  • The program always shows the reports based on the hours and minutes.

Enter daily working hours - tips and tricks

  1. Open the file
  2. Go on the current Day (yellow) -> Menu Utilities1 -> Go to today.
  3. Set the begin and end times.
    1. Press "." to enter the computer's time.
    2. If you enter +5 or -5 (or any other number), the program displays the current time with 5 minutes more or less than the computer time.
    3. With the Utilities1 Menu, Fill week command it is possible to carry forward the previous week schedule.
    4. With the key or button "F4" or "Cmd4" (Copy from above), the previous row value is copied.
  4. Enter holidays or absences.
    1. Indicate the hours of holidays or absences of the day in the appropriate columns.
    2. If you go into Edit mode, the program shows the daily scheduled hours
    3. If you enter the hours in decimal format (e.g. 1.75), the software will show the value in hours and minutes (e.g. 1:45).

Prints and reports

  • With the File menu -> Print command, you can:
    • Print the table.
    • Print a specific part of the table that you have selected
  • With Utilities1 -> Monthly report:
    The monthly report will be printed.

Conversion from Hours.decimals to Hours:minutes

The program always works with hours and minutes; 8:30 means 8 hours and 30 minutes.
There are situations where hours are used with decimals. In this case, the value 8.50 is equivalent in hours/minutes to 8:30. If the number of hours per day is determined on a decimal basis (43 hours per week, divided into 5 days), you will have to work 8.6 hours per day.
The program helps with conversions

  • In the "hour counter" columns (holidays, sickness, due), when after the hour you insert the point and the decimal value, the program indicates the time in hours and minutes in autocompletion. For example, if you write 8.6, the program suggests 8:36.
    You must adopt the proposed value.
  • The information window also shows the value of hours in decimal values.
  • In the monthly report, some values are also shown in decimal values (because payroll programs often use decimal values).

Specific Commands (Utilities1 menu)

Go to today

Sets the cursor on the current day.

Fill day

Resumes the working time and absence of the current day with the values from the same day of the previous week.

Fill week

Resumes the working time and absence of the current week with the values of the respective days of the previous week.

Monthly report

Prints the totals and rows of the current month.
You can select the printing period.

Create rows for period

Creates the rows for each day, from the beginning, and the total for the indicated year.

Import timesheet

Imports the values from an external timesheet.

  • Indicate the file from which the software will import the data.
  • Specify which values to import.
    • Import only holidays.
      The software imports the values of the Holiday column
      It will import also the Notes related to the imported values.
    • Import everything.
      Caries forward the values of Holiday, Notes, Worked, Absences, Corrections, Due and Split.

The program looks in the imported file for rows with equal date and section and it imports the values.
If in the imported file there are several rows for the same date, values subsequent to the first row are not imported.



Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | Email