{"id":5332,"date":"2025-05-01T11:32:22","date_gmt":"2025-05-01T17:32:22","guid":{"rendered":"https:\/\/q1dapyf5zv.onrocket.site\/?post_type=product&p=5332"},"modified":"2025-10-20T21:24:10","modified_gmt":"2025-10-21T03:24:10","slug":"papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025","status":"publish","type":"product","link":"https:\/\/taxid.mx\/english\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/","title":{"rendered":"Excel Worksheet for Calculating PTU 2024 (Profit Sharing) to be paid in May 2025"},"content":{"rendered":"

Excel Worksheet for Calculating PTU 2024 (Profit Sharing)<\/strong><\/p>\n

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<\/strong> and current tax provisions.<\/p>\n

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.<\/p>\n

Ideal for accountants, accounting firms and companies<\/strong> who wish to comply precisely with this legal obligation.<\/p>\n

Includes:<\/strong><\/h3>\n
    \n
  • \n

    Automatic calculation of the 2024 PTU based on the data entered.<\/p>\n<\/li>\n

  • \n

    Taxable base and tax considerations according to the LFT and the SAT.<\/p>\n<\/li>\n

  • \n

    Editable spaces to record salary, days worked, and other key data.<\/p>\n<\/li>\n

  • \n

    Automatic distribution by percentage and by worker.<\/p>\n<\/li>\n

  • \n

    Compatible with Excel 2016 and later.<\/p>\n<\/li>\n

  • \n

    Format 100% editable and reusable every year.<\/p>\n<\/li>\n

  • For all your clients (without RFC limits)<\/li>\n<\/ul>\n

    Advantages:<\/strong><\/h3>\n
      \n
    • \n

      Save time and reduce errors in calculating PTU.<\/p>\n<\/li>\n

    • \n

      Professional presentation ready to give to your client or keep as a support.<\/p>\n<\/li>\n

    • \n

      File downloadable immediately after purchase.<\/p>\n<\/li>\n

    • \n

      No locks: you can modify, copy or adapt it as many times as you need.<\/p>\n<\/li>\n<\/ul>\n

      Who does it serve?<\/strong><\/h3>\n
        \n
      • \n

        Legal entities that are obliged to distribute profits.<\/p>\n<\/li>\n

      • \n

        Public accountants responsible for determining the PTU.<\/p>\n<\/li>\n

      • \n

        Accounting firms that manage payroll and labor obligations.<\/p>\n<\/li>\n

      • \n

        Companies that wish to correctly document profit sharing.<\/p>\n<\/li>\n<\/ul>\n

        Complies with the provisions of the SAT and the Federal Labor Law.<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"

        Excel file to calculate and document the distribution of employee profit sharing (PTU) for 2024 in accordance with the Federal Labor Law. Editable, automated, and ready to use.<\/p>","protected":false},"featured_media":4986,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_joinchat":[]},"product_brand":[],"product_cat":[564,74],"product_tag":[705,703,706,707,701,702,704],"class_list":{"0":"post-5332","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-nomina","7":"product_cat-papel-de-trabajo","8":"product_tag-calculadora-ptu","9":"product_tag-calculo-ptu-en-excel","10":"product_tag-como-calcular-la-ptu","11":"product_tag-cuando-se-paga-la-ptu","12":"product_tag-ptu-2024","13":"product_tag-ptu-2025","14":"product_tag-ptu-en-excel","16":"first","17":"instock","18":"downloadable","19":"virtual","20":"purchasable","21":"product-type-simple"},"yoast_head":"\nC\u00e1lculo de PTU 2024 en Excel - se paga en2025<\/title>\n<meta name=\"description\" content=\"Papel de trabajo en Excel para calcular la PTU 2024. Reparte utilidades conforme a la ley. Descarga editable y f\u00e1cil de usar para contadores y empresas.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/taxid.mx\/english\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1lculo de PTU 2024 en Excel - se paga en2025\" \/>\n<meta property=\"og:description\" content=\"Papel de trabajo en Excel para calcular la PTU 2024. Reparte utilidades conforme a la ley. Descarga editable y f\u00e1cil de usar para contadores y empresas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/taxid.mx\/english\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/\" \/>\n<meta property=\"og:site_name\" content=\"TAX ID\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-21T03:24:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/taxid.mx\/wp-content\/uploads\/2025\/03\/Recurso-5@4x.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1145\" \/>\n\t<meta property=\"og:image:height\" content=\"1106\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/taxid.mx\\\/tienda\\\/papel-de-trabajo\\\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\\\/\",\"url\":\"https:\\\/\\\/taxid.mx\\\/tienda\\\/papel-de-trabajo\\\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\\\/\",\"name\":\"C\u00e1lculo de PTU 2024 en Excel - se paga en2025\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/taxid.mx\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/taxid.mx\\\/tienda\\\/papel-de-trabajo\\\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/taxid.mx\\\/tienda\\\/papel-de-trabajo\\\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/taxid.mx\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Recurso-5@4x.png\",\"datePublished\":\"2025-05-01T17:32:22+00:00\",\"dateModified\":\"2025-10-21T03:24:10+00:00\",\"description\":\"Papel de trabajo en Excel para calcular la PTU 2024. Reparte utilidades conforme a la ley. Descarga editable y f\u00e1cil de usar para contadores y empresas.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/taxid.mx\\\/tienda\\\/papel-de-trabajo\\\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/taxid.mx\\\/tienda\\\/papel-de-trabajo\\\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/taxid.mx\\\/tienda\\\/papel-de-trabajo\\\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\\\/#primaryimage\",\"url\":\"https:\\\/\\\/taxid.mx\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Recurso-5@4x.png\",\"contentUrl\":\"https:\\\/\\\/taxid.mx\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Recurso-5@4x.png\",\"width\":1145,\"height\":1106},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/taxid.mx\\\/tienda\\\/papel-de-trabajo\\\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/taxid.mx\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tienda\",\"item\":\"https:\\\/\\\/taxid.mx\\\/tienda\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Papel de Trabajo en Excel para el C\u00e1lculo de la PTU 2024 (Reparto de Utilidades) se paga en Mayo 2025\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/taxid.mx\\\/#website\",\"url\":\"https:\\\/\\\/taxid.mx\\\/\",\"name\":\"TAX ID\",\"description\":\"Despacho de contadores en M\u00e9xico\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/taxid.mx\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calculation of PTU 2024 in Excel - payable in 2025","description":"Excel worksheet for calculating the 2024 PTU. Distribute profits according to the law. Editable and easy-to-use download for accountants and businesses.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/taxid.mx\/english\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/","og_locale":"en_US","og_type":"article","og_title":"C\u00e1lculo de PTU 2024 en Excel - se paga en2025","og_description":"Papel de trabajo en Excel para calcular la PTU 2024. Reparte utilidades conforme a la ley. Descarga editable y f\u00e1cil de usar para contadores y empresas.","og_url":"https:\/\/taxid.mx\/english\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/","og_site_name":"TAX ID","article_modified_time":"2025-10-21T03:24:10+00:00","og_image":[{"width":1145,"height":1106,"url":"https:\/\/taxid.mx\/wp-content\/uploads\/2025\/03\/Recurso-5@4x.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/taxid.mx\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/","url":"https:\/\/taxid.mx\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/","name":"Calculation of PTU 2024 in Excel - payable in 2025","isPartOf":{"@id":"https:\/\/taxid.mx\/#website"},"primaryImageOfPage":{"@id":"https:\/\/taxid.mx\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/#primaryimage"},"image":{"@id":"https:\/\/taxid.mx\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/#primaryimage"},"thumbnailUrl":"https:\/\/taxid.mx\/wp-content\/uploads\/2025\/03\/Recurso-5@4x.png","datePublished":"2025-05-01T17:32:22+00:00","dateModified":"2025-10-21T03:24:10+00:00","description":"Excel worksheet for calculating the 2024 PTU. Distribute profits according to the law. Editable and easy-to-use download for accountants and businesses.","breadcrumb":{"@id":"https:\/\/taxid.mx\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/taxid.mx\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/taxid.mx\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/#primaryimage","url":"https:\/\/taxid.mx\/wp-content\/uploads\/2025\/03\/Recurso-5@4x.png","contentUrl":"https:\/\/taxid.mx\/wp-content\/uploads\/2025\/03\/Recurso-5@4x.png","width":1145,"height":1106},{"@type":"BreadcrumbList","@id":"https:\/\/taxid.mx\/tienda\/papel-de-trabajo\/papel-de-trabajo-en-excel-para-el-calculo-de-la-ptu-2024-reparto-de-utilidades-se-paga-en-mayo-2025\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/taxid.mx\/"},{"@type":"ListItem","position":2,"name":"Tienda","item":"https:\/\/taxid.mx\/tienda\/"},{"@type":"ListItem","position":3,"name":"Papel de Trabajo en Excel para el C\u00e1lculo de la PTU 2024 (Reparto de Utilidades) se paga en Mayo 2025"}]},{"@type":"WebSite","@id":"https:\/\/taxid.mx\/#website","url":"https:\/\/taxid.mx\/","name":"TAX-ID","description":"Accounting firm in Mexico","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/taxid.mx\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/taxid.mx\/english\/wp-json\/wp\/v2\/product\/5332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taxid.mx\/english\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/taxid.mx\/english\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/taxid.mx\/english\/wp-json\/wp\/v2\/comments?post=5332"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taxid.mx\/english\/wp-json\/wp\/v2\/media\/4986"}],"wp:attachment":[{"href":"https:\/\/taxid.mx\/english\/wp-json\/wp\/v2\/media?parent=5332"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/taxid.mx\/english\/wp-json\/wp\/v2\/product_brand?post=5332"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/taxid.mx\/english\/wp-json\/wp\/v2\/product_cat?post=5332"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/taxid.mx\/english\/wp-json\/wp\/v2\/product_tag?post=5332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}