日记账表格

In the Journal table of the Time Sheet, you can enter the daily data, which can be modified and entered according to your needs.
Thanks to the rows and columns with totals, it allows you to have an immediate overview of the situation.

The Journal table includes several columns to suit all needs. Depending on your needs, the columns of your choice can be displayed.

Typology of rows, colors, and formats

When creating a new file, the rows of the Journal are generated automatically by the program. When using an existing template, they will already be predefined.

Daily rows

Daily rows are used for entering your data.

  • Normal rows - refer to rows for working hours.
  • Rows in red - refer to official holidays
  • Rows in blue - refer to non working days.
  • Rows high-lighted in yellow - refer to the current date.

Multiple rows for a day

By duplicating the day row, you can enter additional information about the same day, such as timetables by project, annotations, or other.
To differentiate between the following rows, the Day description is slightly indented.

Carried forward, Start, Total and Balance rows

The Carried forward, Start, Total and Progressive row are indicated in bold character.

  • The Carried forward row will automatically display holidays and hours belonging to the previous year, that were entered via File property → Start.
  • The Start rows refer to the start of the year and month.  Enter the initial values for holidays and hours.
  • The Total rows refer to the end of the year and month. The total of columns are automatically reported and totalized here.
  • The Balance rows are automatically calculated by the program and will the progressive value of the columns that contain data.

Journal table view

The Journal table is created with a series of columns that will cover the major part of your requirements.
Predefined columns are displayed, depending on the view you select:

  • Base - displays the main principal columns.
  • Minimal - displays the columns to enter your data.
  • Complete - displays all available columns of the Journal.

Columns for the Journal in Base view

The Base view displays the principal columns in use for the Time sheet.

Date

This column is protected and is used to insert the date of the day.

Festive

This column for calibrating the type of day.  If the cell remains empty, the value will be set to the one defined in the File properties, or to the one defined with the W code (see below).

Possible values are:

  • Empty. Working day
  • 0 - The current day is set as festive (the row will be displayed in red).
  • 1  - The current day is set as non-working (the row will be displayed in blue).
  • 2 - The current day is a working day. It overwrites the predefined value.
  • [0] - A festive day set up automatically as defined in File properties. There will be no value in the Due column.
  • [1]  - A up day set up automatically as defined in File properties. There will be no value in the Due column.
  • W0 - Defines the current day as festive. The same day in successive weeks will be set up with a value of (0).
  • W1  - Defines the current day as non-working day. The same day in successive weeks will be set up with a value of (1).
  • W2 - Defines the current day as working day. The same day in successive weeks will be set up with a value of (2)
  • WR - Resets the current day to the value of the predefined one from the File properties.
  • WA - Resets the current day to the value of the predefined one from the File properties. The same day in successive weeks will be set up with a value of Properties file.

Day description

This column is used by the program to generate the name of the day date based on your data.
If you wish a different text than the one suggested by the program, enter a your one preceded by the # character (ex. #Christmas, #National Holiday).

Start1, Stop1, Start2, Stop2...

These columns allow you to enter the stop and start date of worked hours. The Total and Difference columns are automatically updated by the program.

Sick leave

Column to insert hours of absence due to sick leave.

Holidays

Column to insert hours of holidays.

Adjustment

Column to insert any adjustment values.

Total

This column is protected. The program uses it to automatically insert the total sum of hours worked, extra hours, leaves and adjustments.

Due Code

This column helps you define, if needed, the value of Due amounts (hours worked).

If the Due code is left empty, the due value is completed by the software, according to the File menu File and accounting settings Start.

To change the Due amount in the Journal table:

  • Reset the Due time.
    Codes to be entered in the Due code column, in order to edit the daily due from the row you are in. You will then need to enter the new value in the Due column.
    • DS (Set Today) the due hours for the current day, without modifying  other days.
    • WS (Set Week Day)
      Sets the due hours for a specific week day and for the same  days for the subsequent weeks.
    • PS (Set Predefined)
      Sets the due hours for that day and successive days, keeping same preset value.
  • Reset codes for the daily Due time.
    • WR (Reset Week Day).
      Resets the predefined value for the week day.
    • WA (Reset All Week Days)
      Resets all predefined values related to the weekdays.
    • PR (Reset Predefined)
      Resets the general predefined value. Removes the general predefined value.
    • PA (Reset Predefined and Week Day)
      Resets the general predefined value and the ones of the week.
      It will be like starting from scratch.
  • Code to reset the Progressive calculation
    • RP (Restart progressive)
      The Progressive column amount will restart from zero. Insert this code in the first row of the month, when all hourly worked hours, with an hourly pay, have been payed for the previous month.     

Due

This column is protected. The software will automatically calculate the difference between hours worked and hours due. At the end of each month the total for hours due is carried forward

  • If no data is present in the Due column, the program will use those present in the Properties file -Start tab.
  • When codes are entered in the Due column, calculations will be executed on the basis of those codes (see previous paragraph).
  • All of the rows in Festive that contain 0 (festive) or 1 (non working), in the Due column will display an empty cell.

Difference

This column is protected. The software will automatically calculate the difference between hours worked (Total) and hours due (Due). Totals for the differences will be reported for month and year end.

Progressive

This column is protected. The software will automatically calculate the difference between hours worked (Total) and hours due (Due). Totals for the progressive differences will be reported for month and year end.

 

Columns for the Journal in Complete view

Additional columns to the Base view will be available in the Complete view.

Section

This is a protected column. It is used by the program to make a distinction between the lines to be used for data entry and system specific lines.

Lines used for entering and editing data (working hours, absences, holidays, etc.), will have an empty cell in this column.
The rows used by the software for calculation, contain a  specific code in the Section column and must not be altered, as errors in calculations in this part might well occur.

The codes used are: AllStart, YearStart_2020, MonthStart_202001, MonthTotal_202001, MonthBalance_202001, SpaceAfterMonth_202001.

Values of a code is defined by different elements:

Period

  • All - Refers to all rows.
  • Year - Refers to the rows of the Year.
  • Month - Refers to the rows of the Month.
  • Week - Refers to the rows of the Week.
  • Day - Refers to the rows of the Day.

Type

  • CarryForward - Rows report previous year. Automatically generated by the software from Properties file.
  • Start - Opening rows. Insert initial balances (planned holidays, effective holidays etc).
  • Total - Rows used for totals  (columns related to daily hours, adjustments to Start or Carry Forward Balances).
  • Balance - Holiday balance. Displays difference between balance of holidays due that are carried over and current holidays due and taken).P
  • SpaceAfterMonth - To specify that there must be an empty row (year, month or day referred by the identifier).

Description

Column used to insert additional description.

Code1

Use this column to add a client, project or other identification number.

Work1 and Work2 (only Experimental version)

The Work1 and Work2 columns are used in particular to record working hours in the Time Sheet - Simplified template.  In addition, in the Experimental version they can be used to enter particular working hours (e.g. nights, holidays).
In parallel to these columns the surcharge columns are also used (see explanations below).

    Worked

    This is a protected column. This is used by the software to automatically calculate the total of hours worked.

    Detail

    This is a protected column. It is used by the program to automatically display work details (e.g. projects). See Managing projects details.

    Surcharge

    You can add enter working time with a surcharge, with a different pay, in hours and minutes. It can also be used to manage recoveries or penalties for delays or other.

    %Surcharge

    You can enter the percentage increase in working time that is paid with a different pay.
    If on the same day you work both hours without surcharge and hours with surcharge, you must enter the time on two rows:

    • Add row Day
    • On the first row you will indicate the work (beginning and end) normally.
    • In the second line, the overtime hours will be indicated and the appropriate percentage will be indicated.
      If you want the daily total directly in the table, you must add a daily total line.

    Surcharge calc.

    This is a protected column. It is used by the program to calculate the surcharge time (overtime), indicated in the Surcharge or %Surcharge column.

    Surcharge total

    This is a protected column. It is used by the program to calculate the total surcharge time (overtime), indicated in the Surcharge or %Surcharge column.
    This value is added to the total hours column.

      Service

      Compulsory leaves, such as military duties, civil service or other can be registered here.

      Other

      Different types of absence can be defined. Do not indicate Sick Leave or Holidays in  the Service column, if you use this option.

      Absence

      This is a protected column. It is used by the software to calculate the total hours of absence leave.

      Split1 and Split2

      These columns may be used to distinguish between hours invested in different projects.

       

      help_id
      timesheet::journal

      请帮助我们完善必备文件

      我们非常欢迎您发送宝贵的反馈意见

      请告诉我们什么主题需要更好的解释或如何才能更好的对其诠释。

      Share this article: Twitter | Facebook | Email