Where is the timesheet in 1s 8.3. How to save accounting data

Last week, two visitors wanted to know about summary entry of hours worked through report card in 1C ZUP 3. Let's analyze this issue in more detail:

“Help, please, set up a calculation in ZUP 3, similar to the calculation in ZUP 2.5. We previously introduced the Timesheet with the time entry method “Summary, as a whole for the period”. How to do it in ZUP 3?

✅ Seminar "Life hacks for 1C ZUP 3.1"
Analysis of 15 accounting life hacks in 1s zup 3.1:

✅ CHECK LIST for checking payroll in 1C ZUP 3.1
VIDEO - monthly self-check of accounting:

✅ Payroll in 1C ZUP 3.1
Step by step instructions for beginners:

In ZUP 3 there is also a Timesheet document that can be used to enter the hours worked by employees. However, this document does not have the ability to summarize hours worked.

You can implement such an input using a document. To do this, in the guide "Input data templates" you need to create a new element. In it, on the "Types of time" tab, specify the types of time for which we need to enter information. For example, let's specify the types of time Turnout and Night hours.

You also need to check the box " In general, for the period«.

As a result, in the document log "Payroll Data" a new type of document will appear for entering hours worked. Let's introduce employee Khristenko and Tsvetaev the hours worked. Khristenko worked at night.

After that in the document "Payroll and Contributions" for the calculation of these employees, the worked out from the document will be used "Payroll Data".

To be the first to know about new publications, subscribe to my blog updates:

The most common accounting programs in the Russian Federation are programs of the 1C complex - a huge staff of developers, programmers and debuggers constantly updates and improves the system, introducing all new functions into the work and greatly facilitating the life of accountants. With the help of 1C, you can keep records of wages, settlements with counterparties, quickly draw up a report on each of the parameters provided for by accounting. This, in turn, makes it possible to reduce the cost of the staff of accountants payroll.

How to fill out a time sheet in 1C

In the 1C program “Salary and personnel management”, the menu “Payroll” on the desktop is used to perform this function. When you open this tab, you should select the Timesheet option located in the navigation bar. By clicking on the appropriate button, you need to use the "Add" function, which is located on the toolbar. In this case, the entry must be done manually, adding data for each employee separately. In addition, it is possible to automatically generate a list of employees with time tracking data. To do this, select the "Fill" function and set the necessary parameters in the dialog box that appears.

How to save accounting data

If necessary, you can make changes to the entered data by adjusting the indicators of working hours, the number of night and holiday hours, absenteeism and overtime work. If there is an ambiguity with the symbols that need to be entered in the time sheet, you can call up help by clicking on the "question mark" icon on the toolbar. The program also provides the ability to enter data on hours worked on a daily basis or in general for a period, you can also view summary indicators. With daily manual entry, you must confirm the data entry so that the changes are saved in the program database. To do this, use the "Record" button in the lower right corner of the desktop. At the end of the reporting month, you will also need to save the document in the database. To do this, click on the "Submit" button located on the working panel. In addition, the time sheet can be saved in Excel format, printed on a printer to get a paper version. These functions use the standard Save As buttons; "Print Document", which are also located on the toolbar.

Similar opportunities are provided by other products of the company 1C: Production Enterprise Management, 1C: Salary and Personnel, 1C: Integrated.

The time sheet in 1C ZUP 8.3 is maintained for those employees whose wages depend on the amount of time worked (time workers).

There are two ways to track hours worked:

Accounting for deviations from planned time. In this case, all absences from work (time off, vacation, sick leave, etc.) are recorded. This method of accounting also reflects unplanned work (overtime).
This method reflects not only unscheduled work and absences, but also the time worked according to the schedule - continuous registration.

If you are interested in where to find the time sheet in 1C Accounting 8.3, I will not torment you - it is not there. For the purposes of extended accounting for wages, the solution 1C ZUP 8.3 is specially purchased. We will talk about her.

First of all, it is necessary for the current year (for the year of the time sheet). From the Settings menu, select Factory Calendars.

If the calendar has not been previously created, it must be created and filled in automatically, checking the correctness and, if necessary, making changes.

Work schedules

After filling out the production calendar in 1C ZUP, you need to create and fill out work schedules for employees. To do this, go to the "Settings" menu and select the "Employee work schedules" item.

The schedule can be filled in automatically, adjusted if necessary.

Work schedules can be set for employees by documents such as "Hiring" and "Personnel transfer".

ZUP has the ability to massively change the work schedule for employees.

In such situations, when the employee's working conditions have changed for a certain period of time (for example, a shortened day), individual schedules are indicated for them. Setting individual schedules is located in the "Salary" menu. If an employee has an individual schedule for a certain period, the program will not take into account the main one.

Filling out the time sheet in 1C ZUP

The timesheet in 1C ZUP 8.3 is located in the "Salary" section, item "Timesheets". The timesheet uses the designations that are in the reference book "Types of use of working time". If it is necessary to specify several types of time, each of them is indicated on a separate line.

The time sheet can be filled in automatically, correcting the data if necessary. Some enterprises use ACS (access control and management systems). The whole point is that all inputs and outputs are fixed using an electronic access system. This data can be uploaded to the time sheet, eliminating the need to maintain it manually.

In order to be able to change the data in the timesheet regarding the work schedule, in the program settings you need to uncheck the box “Check whether the actual time matches the planned one”. Otherwise, if the time sheet indicates working hours, for example, on a day off according to the work schedule, the document will not be posted.

It should be remembered that with the simultaneous maintenance of both time sheets and reflection documents, the time sheet will have the highest priority when receiving hours worked for payroll.

Form T-13

In 1C ZUP 3.1, there is a printed form "T-13" for viewing hours worked. You can generate this report from the "Salary" section by selecting the "Salary Reports" item. The report you need will be called "T-13 Timesheet".

1C Salary and Personnel Management 8 provides for the function of accounting for the cost of staff working time to perform job duties. Accounting is based on daily progress reports. The received data is distributed by types of work. Before you start working with the time sheet, we recommend that you update the enterprise calendar.

So, let's start with the fact that in 1C the accounting of working time can be kept in two ways:

Use "Deviations": in this case, the accounting of the completed working time is based on the indicators of the working time schedule and the deviations recorded from it. Deviations include missed work hours and overtime.
Take into account “Full logging”: in this method, in addition to recording deviation documentation, the hours of labor actually used are also saved.

In the order to register a person for work, the work schedule of the employee is mandatory to determine the planned schedule of the enterprise. There are situations when an employee falls under personnel transformation. In this case, its schedule is also necessarily fixed in its original form (if necessary, the schedule can always be corrected). In this regard, the props “Work schedule” in the “Employment” and “Personnel transfer” docks are filled in without exception.

In 1C, work time is recorded according to the employee's active schedule. Do not forget to take into account deviations from the schedule, which you can display using the following docs:

Vacation pay;
sick leave;
Passes;
Leave granted to care for children;
Recorded downtime;
Average salary.

There is a practice when an employee builds his own task schedule for a month. In such a situation, the planned time for the employee is assigned through another 1C document - “Entering individual enterprise work schedules”. You will find this function in the menu “Payrolls by organizations”.

Situations in which filling out the Time Sheet is not required:

When all departments of the company work according to the schedule “5 days a week”;
When a company has several (or more) types of work schedule. For example, they are all repetitive, and there are no situations of discrepancy from the schedule.

Conditions under which the completion of the Timesheet is mandatory:

The company has a shift work schedule;
Shift mode of work;
“Complex charts” that cannot be classified as cyclical.

Step by step filling out the document “Time sheet”

The document you need is in the menu "Payroll for organizations". (You can also navigate to the document through the Payroll tab on the user desktop.)

To add a new document, you just need to click on the “Add” field of the same name.

A new document form will open in front of you. Next, select the company for which you want to enter a time sheet. If for the entire company, leave the field blank. (In cases where the time sheet needs to be entered for one of the divisions of the enterprise, select the “Department” attribute). Indicate for which month the time sheet is filled out.

There are two options for completing the spreadsheet:

details for each day of the period;
summary (entering hours worked).

In order to select the option you need, set the switch "Time entry method" to the desired position.

The next step you need to take is to click on “Fill”. The part of the table called “Employees” will automatically be filled in with a list of employees of the enterprise. Later, you can always edit the information and make adjustments.

If you see that the table has remained empty, or the data has been entered only for some employees, see if the work schedule of employees for the current year is filled out correctly.

As a result, you have a table formed taking into account the pre-filled absenteeism.

To control the employees of the schedule fixed for them to go to work, to take into account the actual hours worked for payroll, and to compile statistics. HR departments maintain timesheets. For accounting, two forms T-12 and T-13 are used. The first is intended exclusively for manual filling, and the T-13 form for automatic filling. In this review, I will talk about the methodology for maintaining a time sheet, and also give brief instructions for filling out a time sheet in the 1C: Payroll and HR management program, edition 3.0.

Timesheet methodology

Accounting is maintained for hired employees, for whom the result of payroll calculation depends on the actual time worked out. In the classic scheme, it looks like this:

The specialist who is entrusted with the accounting of hours worked fills out the time sheet and transfers it to the accounting department;
In accounting, a payroll specialist calculates wages based on the data received.

With the help of automation tools, this process can be handled by one employee (for example, a payroll calculator).

There are situations when it is not necessary to keep track of hours worked, for example, if all employees work according to a standard work schedule (40 hour work week).

There are two ways to control hours worked:

The first way is to take into account deviations from the schedule fixed for the employee. Those. only those days (or hours) are recorded when the employee did not work, for example, vacation, sick leave, time off, etc. Deviations can also be in a big way, for example, work at unscheduled time, such as overtime;
The second way is continuous recording of hours worked. This method is used when you need to totally control the time worked by an employee.

It is important to understand that the second method is more time-consuming, because, as in the first one, you need to keep a record of deviation documents and additionally register all attendances of employees.

How to keep a time sheet in 1C: Accounting

So I’ll immediately make a reservation that in 1C:BP there is no standard functionality for automating this task. But there are solutions for this question in the development directory:

We fix the working time plan

We turn to the description of actions in the program 1C: Salary and personnel management. To assign a planned work time to an employee, you need to assign a work schedule to him or assign an individual schedule to the employee for a certain period. So step by step...

The first thing to do is fill in the production calendar for the current calendar year. To do this, go to the Settings - Production calendars section.

After the production calendar is filled, you need to prepare work schedules for which employees work in your enterprise.

You can assign a work schedule to an employee in several ways. For example, in the document "Employment".

Or, if the conditions of the document “Personnel transfer” have changed.

Please note that in ZUP 3.0 it is possible to change the work schedule immediately according to the list of employees. If the changes are massive, this tool can save time.

As mentioned earlier, if during any time the employee’s conditions for going to work change, you need to register an individual work schedule.

It is important to understand that an individual work schedule for the duration of the action (the specified calendar month) supersedes the employee's work schedule that is assigned by default (when hiring or during a personnel transfer).

Registering hours worked

In the first step, to account for the actual hours worked, you need to register deviations from the planned schedule. This can be done through the docs:

If you keep records according to the first method (only deviations), then the registration of the actual hours worked is completed. If you use the second method (continuous registration), then you must additionally register the “Time Sheet” document and indicate the actual hours worked in it for each day.

The timesheet has the highest priority! For example, if the time sheet records the time the employee was on sick leave and after that the sick leave registration document has changed, it is necessary to enter the corresponding ones in the time sheet, otherwise the payroll may not be performed correctly.

In the timesheet, you can manually enter the designation in any cell of the table (see the table of symbols used).