Excel Worksheet for Calculating PTU 2024 (Profit Sharing)

Excel tool to calculate and document in a clear and professional manner the distribution of profits (PTU) corresponding to the fiscal year 2024, in accordance with the provisions of the Federal Labor Law and current tax provisions.

This working paper is designed to facilitate compliance with mandatory profit sharing for employees, allowing for the automatic calculation of the total amount to be distributed, as well as its distribution among employees, considering salary and days worked.

Ideal for accountants, accounting firms and companies who wish to comply precisely with this legal obligation.

Includes:

• Automatic calculation of the 2024 PTU based on the data entered.

• Taxable base and tax considerations according to the LFT and the SAT.

• Editable spaces to record salary, days worked, and other key data.

• Automatic distribution by percentage and by worker.

• Compatible with Excel 2016 and later.

• Format 100% editable and reusable every year.

• For all your clients (without RFC limits)

Advantages:

• Save time and reduce errors in calculating PTU.

• Professional presentation ready to give to your client or keep as a support.

• File downloadable immediately after purchase.

• No locks: you can modify, copy or adapt it as many times as you need.

Who does it serve?

• Legal entities that are obliged to distribute profits.

• Public accountants responsible for determining the PTU.

• Accounting firms that manage payroll and labor obligations.

• Companies that wish to correctly document profit sharing.

Complies with the provisions of the SAT and the Federal Labor Law.