In this article
With the free Banana Accounting Plus Time Sheet, you can easily start entering work times, your holidays and absences and instantly know the totals and balances of all the data.
According to what is stipulated in the contract:
- Set the due working time (agreed) and include holidays.
- Actual working hours and absences are entered.
- The program calculates the daily and progressive balance.
All values, time due, hours worked, absences and holidays are entered and displayed as hours: minutes (eg 10:30).
This unified approach allows you to enter data quickly and instantly and be in control of the situation.
The values entered are checked by the program. If you enter an incorrect value, it will show instantly.
Setting up the due time
The Time Sheet, in File Properties - Start, allows you to quickly set up the weekly working time.
If the scheduled time is different or changes during the year, you can adapt it, see Set the working period and times.
Planned Holidays are set directly in the Holidays column instead of the Journal table.
Entry of working times and absences
Enter the daily values in the appropriate columns of the Journal table, relating to the following data:
- Hours of work carried out are entered as follows:
- Entry and exit times (systematic collection)
The program calculates the hours and minutes of work. - Work hours, Work 1 or 2 columns
Total hours worked are entered. - If you enter both entry and exit values and hours worked, the program adds them.
- Entry and exit times (systematic collection)
- Hours of absence (Sickness, Vacation, Service, Other).
These are the hours that will be deducted from the due hours. - Adjustments.
When accounting adjustments are required, enter a positive or negative value in the Adjustments column.
When extra hours are paid, for example, the hours are entered in negative, so that the progressive is reduced.
When you start work during the year
When the work period begins during the year, proceed as follows to reset the hours due from the first of January to the work start date:
- On 1st January, in the corresponding line and in the column Due code, enter WA. The programme resets the total hours for all days before the start of the working period.
- On the start date line, and for all working days of the first week, enter WS in the column Due code and the number of working hours in the column Due. The programme will automatically complete the hours due for all weeks until the end of the year.
How to change work days during the year
If working days change during the year, the new working day settings must not be changed in the File properties, otherwise the change is applied retroactively from the first of January, but directly in the Journal table using the appropriate codes. Several changes during the year are possible.
If a working day becomes a non-working day:
- On the line of the day you wish to change (from a working day to a non-working day), enter the code W1 in the column Holiday. For the programme to resume the change as a non-working day for all weeks of the year, the code WS must be entered in the column Due code.
If a non-working day becomes a working day:
- On the line of the day you wish to change (from a non-working day to a working day), enter the code W2 in the column Holiday. For the programme to resume the change as a working day for all weeks of the year, the code WS must be entered in the column Due code.
For further customisations see the explanation of the Journal Table columns.
How to change the work rate during the year
If the number of working hours due increases or decreases during the year, the new settings must be entered in the Journal table, in the columns Due code and Due.
On the day in which the changes are to be implemented (e.g. from 5 working hours to 8):
- In the Due code column, enter the code WS.
- In the Due column, enter the current due hours (8)
The programme resumes the change of the new due hours for all weeks of the year.
For other customisations, please refer to the explanation of the Due code column .
If the available holiday hours change during the year, the differences must be calculated and changed manually. See Changes during the year.
Multiple rows for the same days
You can manage multiple rows for the same working day, where you can enter different daily values. To make understand that it is the same row of the day, the description is indented in the following rows of the same day .
There are several possibilities to create an additional row for the same day:
- Via the Edit → Duplicate rows... menu
- Via the Edit → Add rows... menu, inserting the date of the day (you have to remove the protection from the date column).
- Via the Actions → Add row Day (only in the Banana Accounting Plus version).
The difference with respect to the amount due and the totals
In the Journal Table, the program displays the following data after each entry:
- The difference between the hours due and the hours worked on the day.
- The progressive balance.
- The total by month, year and grand total of the different hour columns and numeric columns.
The total for the holidays results as the difference between the holidays set at the beginning of the year and those used, see Holidays page. - The carry-over to the end of the month and year of the various numerical columns:
- The carry-over is the total of the position, and also takes into account the values of the previous periods.
- At the end of the month you will also known how many hours have been done since the beginning of the year.
- The final total is equal to the carry-over.
Monthly printout
The monthly printout presents all values in summary form.
Adjustments and payment of accumulated hours
The Adjustments column allows you to modify the total hours due / worked.
- If hours are accumulated and these are paid:
- In the row of the day they are paid
- Enter the hours paid in negative in the Adjustment column.
- Indicate "Payment of accumulated hours" in the notes
- The progressive balance decreases.
- In the row of the day they are paid
- When accumulated holidays are paid:
- In the row of the day when the holidays are paid.
- Enter the hours paid in negative in the Holidays column.
- Indicate "Accumulated holiday payment" in the notes
- The progressive balance decreases.
- In the row of the day when the holidays are paid.