Payroll 1s 8.3 accounting.

Design and interior 04.02.2024

Design and interior

It happens that an accountant makes an error when creating a T-51 payroll, but there is no error in the standard accounting reports. What to do? In this article we will look at:

Which report should be used to detect the error.
What settings need to be made to make the report clear.
How to fix the found error.

Error in Payroll T-51

The organization is obliged to approve in its accounting policy the forms of primary accounting documents, accounting registers, as well as documents for internal accounting reporting (clause 4 of PBU 1/2008). The payroll sheet (T-51) is often approved by organizations as an accounting register of settlements with personnel with all accruals and deductions for each employee. The 1C program supports automatic completion of the T-51 form.

Quite often, an accountant is faced with the fact that the report is filled out incorrectly, information is missing or incorrectly reflected:

the amount of debt of the organization (column 16);
amount to be paid (column 18).

Reconciliation of T-51 data with accounting registers

To check data Payroll (T-51) can be formed account balance sheet report“Settlements with personnel for wages”, section Reports – Standard reports – Account balance sheet.

A discrepancy was detected between account balances and debt to employees for Payroll (T-51) .

In the 1C program it is impossible to generate or identify an error in a report Payroll (T-51) based on salary accounting entries. For this purpose, a special salary and personnel accounting subsystem has been created, which is based on savings registers.

It is movements in wage accumulation registers, and not in accounting accounts, that form records in settlement documents with employees, as well as data for reports on wages, insurance premiums and personal income tax.

Therefore, to analyze errors associated with settlements with personnel, we will monitor the movements register Mutual settlements with employees.

And the report that will help us find the error is Universal report according to metadata, which is generated from the section Administration – Program settings – Printed forms, reports and processing – Universal report.

Setting up the Universal report Mutual settlements with employees

Filling out the report header

In the header you must fill out:

Period– month for which it was formed Payroll T-51 with an error.
Accumulation register – data source type.
Mutual settlements with employees -name of the register, according to which the data in column 18 of the T-51 report is generated.
Balances and turnover — data for creating a report.

Setting up the report

You can go to settings by pressing the button Settings in the header of the report. After the settings panel opens, click the button View – Advanced.

Tackles tab

On the tab Selections You can set additional selection by objects.

In our example, the selection is specified (there is more than one organization in the database):

Field –Organization.
Condition – Equals.
Meaning – Cozy House LLC.
Method for displaying the selection field – star, i.e. in the header of the report.

Based on the specified settings, when generating a report, the selection by organization will be automatically set Cozy home. If necessary, the selection organization can be changed directly in the report header.

Fields and sorting tab

On this tab, you set the fields that will be displayed in the columns of the tabular part of the report:

You can sort by Department - Ascending , i.e. in alphabetical order.

Structure tab

Tab Structure sets the set of grouped fields and the order in which the table section headings will be displayed in the report.

When you click on the values Grouped fields opens Group composition , where you can set its type. In our example:

Subdivision – No hierarchy;
Employee – No hierarchy.

After which you can Finish editing . After setup is complete Universal report you need to press a button Close and form . The program will generate a report.

Saving settings

In the form that opens, in the fields:

Name – give the report a name, for example, Mutual settlements with employees.
Available– select a button:
- Only for the author – a report with these settings will be available only to the user who created it.
- All users – the report will be available to all database users.

With this conservation Universal report Mutual settlements with employees the form will be available from the sections:

Generating a report

The generated report with the specified parameters looks like this.

We see that according to employee Kolokoltsev I.F. Consumption exceeds Coming by object Amount of mutual settlements . To understand the reason, it is necessary to decipher the amount Expense by employee.

To get a breakdown of the amounts for an employee, you need to stand on any cell of the line with his last name and, calling up the menu by right-clicking the mouse, click Decipher .

Registrar – the document on the basis of which the entry was made into the register Mutual settlements with employees .

Then press the button Choose .

We will receive a report with a transcript according to To the registrar :

From the employee report it is clear that one extra Statement to the cash register .

Let's open this document.

Please pay attention to filling out the field:

Type of payment – Salary;
Pay– was not produced.

Entries by register

The following entries were made in the register:

Type of movement – Consumption;
Type of mutual settlements – Salary payment;
Deduction group – Paid.

Despite the fact that Sheets to the cash desk dated May 25, 2018 N 4 the payment was not made, it was posted and created an extra entry in the register Mutual settlements with employees .

Examination

After deleting an unnecessary document, a report is generated Payroll (T-51) :

Comparison report Payroll (T-51) With Account balance sheet “Settlements with personnel for wages” shows the absence of discrepancies.

– Report on the results of accruals:

Payroll in form T-51;
Summary of accrued wages;
Pay slips;
Salary analysis for employees.

– Reports on taxes and contributions.

The command for calling all salary reports in 1C 8.3 ZUP 3.0 is located on a special report panel. In each section of the 1C ZUP 3.0 program there is a link to call the panel. For example:

Section “Salary – Salary reports”;
Section “Payments – Payment reports”;
Section “Taxes and contributions – Reports on taxes and contributions”.

The composition of the reports on the panel and their assignment to a particular section can be customized.

In the “Salary Reports” section you can find all salary reports:

“A complete set of charges, deductions and payments”;
“Salary analysis for employees” is what was previously called “Free Form Payroll”:

Let’s create in 1C ZUP 3.0 “Full set of accruals, deductions and payments”, where a set of accruals is formed:

Everything accrued by type of accrual,
Everything that is withheld in terms of types of deductions,
Everything paid:

In 1C ZUP 3.0 you can see a key difference from the previous version 1C ZUP 2.5, which is the accounting of balances. In 1C ZUP 3.0 there is a “salary balance”. If everything accrued for the current month has been paid, then the balance is zero. That is, there is no balance in the summary, because the entire salary for the current month has been paid.

The payment will be included in the salary report for January, because the month of payment is January. In 1C ZUP 3.0, the most important thing for payment is the month of payment; it is in this month that the paid amount will be included in the reports:

How to view employee salaries for a period in 1C ZUP 3.0

In 1C ZUP 3.0 you can use the accumulation register “Mutual settlements with employees”. In this report you can configure custom fields by movement date:

And by the amount of movement:

This report will compare turnovers. Let's set the register recording period for January, from 01/01/2016 to 01/31/2016. We will also establish an additional selection by movement date from 01/01/2016 to 01/31/2016. The turnover of account 70 is formed:

If you generate a report for the period until February 6, that is, when the salary has already been paid, then there will be no balance, since everything that has been accrued has already been paid:

How to view the “salary balance” in 1C ZUP 3.0

If, based on the results of payments for the current month, some of the employees still owe money, and someone still owes us, then the “Balance based on the results of payments for the month” appears in the salary reports. For example, in January one employee was paid 10,000 rubles more, and another was paid 1,000 rubles less. This can be seen:

In the report “Full summary of charges, deductions and payments”:

You can also see the turnover for account 70 in the Universal Report:

In the section “Payments – Payment reports – Salary arrears:

You can also see the balance in the “Payroll in free form”, in 1C ZUP 3.0 the report is called “Salary Analysis by Employees”. This report contains:

balance at the beginning of the month,
number of days and hours worked and not worked for each employee,
amounts of accruals by types of accruals,
total according to accruals,
amount of deductions by types of deductions,
total of deductions,
payments for the current month,
balance at the end of the month:

In 1C ZUP 3.0, the balance will be automatically taken into account during the next salary payment. In our example, next month one employee’s salary will be 10,000 rubles less, and the second employee’s salary will be 1,000 rubles more.

Payroll T-51 in 1C ZUP 3.0

Let's look at how the columns in Payroll T-51 are filled out.

The payslip contains fields that indicate: what has been accrued, what has been withheld, and the amount to be paid. According to the new methodology in 1C ZUP 3.0, the amount to be paid is filled in with the amounts actually paid. Having created a payout sheet in the 1C ZUP 3.0 program, the amount to be paid is determined. This amount goes into column 18 of the payslip and into the pay slips in the Amount to be paid section:

Columns 16 and 17 in Payroll T-51 are the balance at the beginning of the month. The fact that employees were overpaid or underpaid in the current month can be seen in Payroll T-51 for the next month:

The main request for the 1C ZUP 3.0 payroll program is that the user must make sure that everything that is accrued is paid. In 1C 8.3 Accounting 3.0, it is not clear from the accounting balance whether everything has been paid, because, for example, salaries for January are paid in February and at the beginning of the month there is a balance on account 70. By analyzing account 70, it is impossible to determine whether all employees were paid what accrued. Therefore, for 1C ZUP 3.0 they developed a “salary balance” mechanism. And this is convenient, because in 1C ZUP 3.0 you can see: if there is no debt, then everything has been done correctly.

Pay slip in 1C ZUP 3.0

In 1C ZUP 3.0 a very convenient form of payslips is created, as compact as possible for printing. Details of displaying information on payslips can be configured using the “Settings” button:

Using the checkboxes, you can configure the content of information to be printed:

The payslip indicates the accrued amount of income, how much was withheld, actually paid, and the amount paid in salary is indicated as the amount payable:

If you enter everything correctly in 1C ZUP 3.0 and pay wages on time, then there will be no balance. If the statement is filled out automatically, then the 1C ZUP 3.0 program offers to pay everything that has been accrued.

Reports on taxes and contributions in 1C ZUP 3.0

Reports on taxes and contributions in 1C ZUP 3.0 are generated in the Section “Taxes and contributions – Reports on taxes and contributions”:

Time sheet in 1C 8.3 ZUP 3.0 - settings, filling procedure, discussed in the article.

(from user questions)

In new editions of 1C: Enterprise Accounting 8th edition. 3.0 and 1C: Salary and Enterprise Management 3.0, there is no such report separately. You yourself can see all the reports in the Enterprise Accounting 3.0 configuration for salary by opening in the “Employees and Salary” section – Salary – Salary reports – All reports – under the “Salary” report option. Here's everything there is:

— Employee contributions transferred to the Pension Fund

— Statement DSV-1 Card for recording insurance premiums (in general)

— Card for recording insurance premiums (by branches)

— Brief summary of charges and deductions Taxes and contributions (briefly)

— Payroll (T-51)

— Pay slip

— Regulated form of certificate for DSV

— Register of insurance recipients

— Deductions from wages.

There is no “free-form payslip” here. Moreover, if earlier in the ed. 2.0 the reports “Payroll (T-51)” and “Payroll in free form” were separate reports, but in the new edition there is only one report “Analysis of accruals and deductions”, and a list of generated printed forms, which we are accustomed to consider as separate reports - these are just its options:

— Salary analysis by departments and employees

— Brief summary of charges and deductions

— A complete set of charges, deductions and payments

— Payroll (T-51)

— Payroll statement (T-49)

— Pay slip

— Salary deductions

What can you do here? The data on the types of calculations is present in the request, so you just need to “pull it out” into the report by creating a new version of the report.

The action plan is:

(!) Just do everything on a copy first, otherwise the changes may be irreversible and the Report will stop being generated altogether if you make mistakes.

1. Open the report “Payment sheet (T-51)”. At the top right of the menu “All actions” - “Change report option”. The report structure opens, you go to the “Fields” tab and drag the “Calculation Type” field from “Available Fields” to the “Selected Fields” list (The cursor should be at the root of the “Report” report structure).

2. When “Calculation type” appears in the list of selected fields, place the cursor on the bottom line of the “Employee” report structure. Position" and right-click to add a new grouping, indicating "Calculation type" in the grouping field.

3. Click “OK”, “Finish editing” and save the new report version by calling again “All actions” - “Save report version” under a new name.

4. Select a new report option from the list of options: “All actions” – “Select report option”. Then generate a report by clicking on the “Generate” button. All types of calculations will be indicated in detail.

This is the simplest option that comes to mind. You can create a new, more complex report structure in the form of tables, where you place the type of calculation in the report columns, but this requires time and considerable experience. Perhaps the 1C developers will include the usual version of the payslip in free form in subsequent updates, when more and more users switch to edit. 3.0. After all, the form is indeed very convenient and many people will probably ask for it. But not everyone will be able to create their own versions of reports, and even quite complex ones. So try playing with the report options on the copy.

In any case, it’s interesting! 🙂

Today I am completing a series of articles devoted to an overview of the main features of the software product. In the last publication, I noted that the formation of regulated reporting is one of the main tasks of accounting. But an equally important task is generating reports for internal use. These reports, first of all, include:

salary slips,
time sheet forms,
salary slip forms,
summary of accrued wages.

And of course, 1C ZUP provides the ability to generate these reports. In addition, the software product has a large number of other useful reports and printed forms:

analysis of accrued taxes and contributions (PFR, personal income tax, social insurance fund),
reflection of wages in accounting,
printed form of the employment contract,
forms of orders for hiring, personnel transfer and dismissal,
vacation order form.

These are not all the reports and forms presented in the program. There is no point in listing all possible reports in this publication since it is of an overview nature. However, this topic is very broad and I will return to it more than once in my future materials.

Let me remind you that this is the seventh and final part of a series of review articles about the 1C ZUP program. Links to previous materials are provided below:

Pay slips

Most medium and large organizations provide their employees with payslips containing their monthly salaries. In 1C ZUP there is a specialized report of the same name for this purpose. It can be found on the “Payroll” tab in the “Reports” section.

When generating payslips, you can make the following selections (filters):

Period – month of accrual. As a rule, you need to print sheets for a certain month, so this field is filled in in most cases;

Selection by Division – it is possible to generate a report for the selected division;
Selection by Employee – accordingly, you can select certain employees.

You can see the appearance of the salary slip in 1C ZUP in the figure:

The report contains information on accrued and withheld amounts with detail by type of accrual and withholding, information on personal income tax deductions, the amount of debt owed by the enterprise or employee, if any, and other information, this was the main thing.

The program also has access to the so-called “operational” payslip. It can be opened directly in the document "Payroll for employees of the organization"(more about payroll). This payslip reflects the accruals and deductions of the current “Payroll” document, even if it has not been posted. The sheet also reflects the data of other documents for calculating salaries for the same month of accrual, but these documents must be posted. To open the sheet, you need to click on the link in the “Payroll” document at the bottom right "Show payslip". It is also worth noting that the data will be generated for the employee who is currently highlighted in the document form.

This sheet provides essentially the same information as the first report, but is typically used for viewing rather than printing.

Time sheet forms

The report has the following selections (filters):

The period for which the timesheet is needed;
Organization;
Mode – two modes: “time sheet” is automatically filled out and “form” - so that you can print a blank form with all working employees (useful idea);
Selection by employee.

Salary forms

"Organizations Payroll"- this is a report that is not regulated, such as a report card. However, it is popular in many organizations and enterprises. This report offers data on accrued and withheld amounts by type of accrual and deduction by employee and department. It offers the same selections (filters) as in previous reports.

Summary of charges

"Accrued salary summary"- a report that provides summary (without detailing by employee) data on accrued and withheld amounts by type of accrual and withholding, as well as on amounts paid and balances at the beginning and end of the month. As additional information, you can include in the report information about paid and worked days and hours. This report is available on the “Payroll calculation” tab of the program desktop.

Analysis of accrued taxes and contributions

This report is available on the “Taxes” tab of the program desktop. The report is useful for analyzing the calculation of insurance premiums and personal income tax (for more information about the features of accounting for insurance premiums, read the article: Part 4: Calculation and payment of insurance premiums. Step-by-step description of all stages of salary calculation). The report has several options that were configured by 1C developers:

Personal income tax deductions,
personal income tax,
Benefits - information about benefits paid at the expense of the Social Insurance Fund,
Pension Fund, contributions for employees with early retirement,
FSS and MHIF,
FSS NS.

I won’t go into detail about each option. In the screenshots I will present the most popular ones.

Analysis of contributions to the Russian Pension Fund.

Analysis of contributions to the Social Insurance Fund and the Mandatory Medical Insurance Fund.

Analysis of contributions to the Social Insurance Fund against Accidents.

Analysis of Personal Income Tax.

Reflection of salaries in accounting

This report is generated based on the results of filling out and conducting the document of the same name “Reflection of wages in regulated accounting”. For information about why and how to work with this document, read the material: . The report can be accessed on the “Accounting” tab of the program desktop in the reports section. You can see the appearance of the report in the figure:

These were the main reports and printed forms presented in the program "1C: Salary and Personnel Management", but not all. I listed some at the beginning of the article. Also, the program on the 1C platform has ample opportunities for flexible configuration of each of these reports. It is worth noting that in 1C there is such a thing as external printed forms and reports, with the help of which you can painlessly implement third-party reports and printed forms for a standard configuration. But the topic is for other articles, but that’s all for today. And a series of articles about the basic capabilities of a software product "1C: Salary and Personnel Management" has come to an end.

That's all for today! I'm glad you read my blog. New interesting materials will be coming soon.

To be the first to know about new blog posts via e-mail or join our groups on social networks, where all articles are also regularly published.

– Report on the results of accruals:

Payroll in form T-51;
Summary of accrued wages;
Pay slips;
Salary analysis for employees.

– Reports on taxes and contributions.

The command for calling all salary reports in 1C 8.3 ZUP 3.0 is located on a special report panel. In each section of the 1C ZUP 3.0 program there is a link to call the panel. For example:

Section “Salary – Salary reports”;
Section “Payments – Payment reports”;
Section “Taxes and contributions – Reports on taxes and contributions”.

The composition of the reports on the panel and their assignment to a particular section can be customized.

In the “Salary Reports” section you can find all salary reports:

“A complete set of charges, deductions and payments”;
“Salary analysis for employees” is what was previously called “Free Form Payroll”:

Let’s create in 1C ZUP 3.0 “Full set of accruals, deductions and payments”, where a set of accruals is formed:

Everything accrued by type of accrual,
Everything that is withheld in terms of types of deductions,
Everything paid:

How to view employee salaries for a period in 1C ZUP 3.0

In 1C ZUP 3.0 you can use the accumulation register “Mutual settlements with employees”. In this report you can configure custom fields by movement date:

And by the amount of movement:

If you generate a report for the period until February 6, that is, when the salary has already been paid, then there will be no balance, since everything that has been accrued has already been paid:

How to view the “salary balance” in 1C ZUP 3.0

In the report “Full summary of charges, deductions and payments”:

You can also see the turnover for account 70 in the Universal Report:

In the section “Payments – Payment reports – Salary arrears:

You can also see the balance in the “Payroll in free form”, in 1C ZUP 3.0 the report is called “Salary Analysis by Employees”. This report contains:

balance at the beginning of the month,
number of days and hours worked and not worked for each employee,
amounts of accruals by types of accruals,
total according to accruals,
amount of deductions by types of deductions,
total of deductions,
payments for the current month,
balance at the end of the month:

Payroll T-51 in 1C ZUP 3.0

Let's look at how the columns in Payroll T-51 are filled out.

Pay slip in 1C ZUP 3.0

In 1C ZUP 3.0 a very convenient form of payslips is created, as compact as possible for printing. Details of displaying information on payslips can be configured using the “Settings” button:

Using the checkboxes, you can configure the content of information to be printed:

The payslip indicates the accrued amount of income, how much was withheld, actually paid, and the amount paid in salary is indicated as the amount payable:

Reports on taxes and contributions in 1C ZUP 3.0

Reports on taxes and contributions in 1C ZUP 3.0 are generated in the Section “Taxes and contributions – Reports on taxes and contributions”:

Time sheet in 1C 8.3 ZUP 3.0 – settings, filling procedure, discussed in the article.

There is nothing better than a time-tested classic complemented by modern technology. In this case, we will talk about the good old payroll T-51 with details by type of calculation.

The main difference from the Statement T-51 report presented in the Salary and Personnel Management configuration is the breakdown of the accrued and withheld sections by type of payment. Each type of calculation is presented in a separate column. A section has been added to the report paid, which in turn is detailed at:

Prepaid expense
Intersettlement payments
Salary bank
Salary cash desk

When you check the “Consider only advances” checkbox in the report settings, in the section paid Only the advance payment will be covered.

The report contains fields in which you can specify the responsible persons - the compilers of the report; information about them will be displayed in the footer of the report (if a specific organization is selected in the report).

Payroll is a document that is drawn up for employees of an enterprise when calculating wages. This document has the T-51 form established by the legislation of the Russian Federation and, according to the OKUD classifier, the code for this form is 0301010.

The payroll includes a complete list of all accruals by type of payment taken from the wage fund, as well as other payments, which include various material and social benefits that are provided to the employee. This document also displays all deductions from accrued wages. At the end is the amount of money that is actually payable to the employee of the enterprise

The location of the details of this document depends on the activities of the enterprise, as well as on the technology for processing the information included in this document. In this case, you should be guided by the details approved in the unified form T-51. The first page of the document requires the following details:

full name of the organization;
name of the structural unit;
document code, according to OKUD;
OKPO number;
Title of the document;
payslip registration number;
the reporting period for which this document is being filled out.

The second side of this document is in the form of a table and involves displaying information on the following indicators:

serial number of each employee for whom the calculation is made;
last name, first name and patronymic of a specific employee of the enterprise;
the position of the employee;
tariff rate (full salary, hourly, daily);
information about days worked (working days and holidays or weekends);
the total amount accrued (for all types of payments, as well as additional payments in the form of material incentives or social assistance);
the total amount that has been withheld for contributions to various government funds;
amount of debt (by the employee, as well as by the enterprise);
actual amount to be paid.

The payslip is compiled by an authorized employee of the accounting department in one copy. The data that forms the basis of the payroll are the primary documents in which actual production is recorded, i.e. time worked in days and hours by each employee of the enterprise

The payslip is issued to the employees of the organization upon payment of wages. It contains complete information about all charges and deductions for the billing period. The sheet also shows the salary arrears to the employee at the beginning and end of the month. Read this article on how to generate a payslip in 1C 8.3.

The payslip includes all accruals for the employee.

salary;
bonuses;
bonuses;
compensation;
sick leave.

For each accrual, the days and hours worked are visible on the sheet. It also indicates the withheld personal income tax and the amount due for issuance. Thus, the payslip provides the employee with complete information about his salary.

The payslip does not have a unified form. 1C has developed its own form, consisting of a header and 3 sections:

Accrued
Held
Paid

The title states:

title of the document “Payment slip”;
pay slip period (for which month);
Full name of the employee;
employee personnel number;
the name of your organization;
the department in which the employee works;
employee position;
his salary.

Separate columns indicate wage arrears at the beginning and end of the period. If desired, you can display information on accrued contributions to the pension fund on the payslip. Where to find a payslip in 1C 8.3 and how to generate and print it in 4 steps, read on.

How to create in the BukhSoft program
payslip

Step 1. Go to 1C 8.3 Accounting in the reports of the “Salary” section

Go to the “Salary and Personnel” section (1) and click on the “Salary Reports” link (2). The salary reports window will open.

Step 2. Fill in the basic details on the payslip in 1C 8.3

Please indicate on your payslip:

your organization (1);
employee (2). If you want to generate payslips for all employees, uncheck the box next to the “Employee” field (3);
start and end date of the period (4).

If you check the box next to “Split by departments” (5), then the payslips will be grouped by departments. To fill out the sheet, click the “Generate” button (6). Information about the employee will appear on the sheet.

The leaflet contains the following information:

by accrued salary (7);
number of paid working days according to salary (8);
withheld personal income tax (9);
amount to be paid “in hand” (10).

How to display information on accrued contributions to the pension fund on a payslip in the next step.

Step 3. Customize the payslip in 1C 8.3 “for yourself”

If necessary, you can customize the payslip to suit your needs. For example, add information about contributions to the pension fund. You can also create a new report that will reflect the information you need. For example, create separate payslips for the director and chief accountant.

Add information on insurance contributions to the pension fund to the payslip

Click on the “Settings” button (1) on the payslip. The settings window will open.

In the window that opens, check the box next to the “Display information about accrued Pension Fund contributions” (2). Next, click the “Close and Generate” button (3).

Now the payslip displays information about contributions to the pension fund deducted from the salary for the billing month (4).

Create and save a new report “Pay slips by managers”

Go to the settings window as in the previous section. Check the box next to “Position” (1). Next, click the “Selection” link (2) and select the positions you need from the directory, for example, “General Director” and “Chief Accountant”. Click on them with your mouse. These positions will appear in the window below (3). Click the “Close and Generate” button (4) to generate a new report. Payslips for the two selected positions will open.

You can save any settings to use them in future work. To do this, 1C 8.3 provides the ability to save various report options. To save your settings in a separate report, click the button (5) and click on the “Save report option” link (6). A window will open for saving a new version of the payslip.

In the window that opens, in the “Name” (7) field, write the name of your new report, for example, “Pay slips for management staff.” To save the report, click the “Save” button (8). The new report has been saved.