fbpx

Plantilla Excel para controlar gastos

ingresos gastos excel plantillaPlantilla Excel para controlar gastos: Este año 2018 me he propuesto controlar cada sol (moneda de Perú) que gasto, para ello estoy elaborando una plantilla en Excel que pronto la compartiré; por dicha razón me puse a revisar plantillas que tengan esta funcionalidad y haciendo mi recorrido diario en foros y web sobre Excel encontré una plantilla para controlar nuestros gastos, una de las bondades de este archivo es que nos permite clasificar los gastos de acuerdo a rubros y periodos. La plantilla es simple y puedes modificarlo según lo que necesites, ha sido desarrollado en su totalidad con formulas. A continuación te detallo como funciona. (al final de la publicación puedes descargarlo)

1.- Debes ingresar tus gastos dependiendo del mes en el que se realizaron, es decir en cualquiera de las hojas que contienen el mes de referencia.

Plantilla gastos excel

2.- Para ver de forma resumida toda la información dirígete a la hoja «resumen».

cuadro resumen de gastos - plantillas excel

3.- Si quieres modificar algún concepto, agregar o eliminar puedes hacerlo desde la hoja «Categorías».

Planilla de gastos excel

¿COMO MODIFICAR LAS FECHAS?

Muchos usuarios me consultarón como hacer para cambiar las fechas en el archivo ya que todo hace referencia al año 2013, a continuación te detallo paso a paso como hacer esta modificación:

  • Tomaré como ejemplo la hoja «01 Enero» (el procedimiento se repite para cualquier hoja), seleccionamos el rango «D8:D1000» y hacemos clic en el botón «Validación de datos».
    validacion de datos en excel
  • Seguido a esto modificamos los casilleros, colocando el rango de fechas que nos interese.modificacion de datos de validacion fechas
  • Presionamos aceptar y listo.

DESCARGA EL ARCHIVO

Descargar Plantilla Excel para controlar Gastos.xls

SUSCRÍBETE GRATIS

Te convertiré en un experto en Excel, tengo la experiencia y todo el material que necesitas, mi ayuda es totalmente gratuita.

Suscríbete

Agrega tu comentario

Comentarios
  1. Posted by Abraham Lee
    • Posted by Gustavo A. Sebastiani Cépeda
  2. Posted by Blair Angel
    • Posted by Gustavo A. Sebastiani Cépeda
  3. Posted by Daniel Estévez
  4. Posted by GLADYS
    • Posted by Gustavo A. Sebastiani Cépeda
  5. Posted by blanca
  6. Posted by Lucia
    • Posted by Gustavo A. Sebastiani Cépeda
  7. Posted by veronica
    • Posted by Gustavo A. Sebastiani Cépeda
  8. Posted by hector castillo
  9. Posted by mauro
    • Posted by Gustavo A. Sebastiani Cépeda
  10. Posted by GENESIS
  11. Posted by José Marín Ruiz
    • Posted by joel
  12. Posted by Bryan
    • Posted by Gustavo A. Sebastiani Cépeda
  13. Posted by Maria Eloisa
  14. Posted by jose
  15. Posted by Ramiro
  16. Posted by Carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  17. Posted by fernando bol
  18. Posted by Isidro Sada Salum
    • Posted by Gustavo A. Sebastiani Cépeda
  19. Posted by samuel hernandez
  20. Posted by Luisa Sánchez
  21. Posted by Patricia Zarate
    • Posted by Gustavo A. Sebastiani Cépeda
  22. Posted by cuevano
    • Posted by Gustavo A. Sebastiani Cépeda
  23. Posted by Joan
    • Posted by Gustavo A. Sebastiani Cépeda
  24. Posted by kharem
  25. Posted by Diego
  26. Posted by elio
  27. Posted by Damian
    • Posted by Robin Solano
  28. Posted by juan carlos
  29. Posted by luis consuegra
    • Posted by Robin Solano
  30. Posted by Alonso
    • Posted by Robin Solano
      • Posted by Marina
        • Posted by Gustavo A. Sebastiani Cépeda
  31. Posted by Simón
  32. Posted by Pedro Benitez
  33. Posted by Alexander
  34. Posted by Fátima Hernández
  35. Posted by dan
    • Posted by Elkin Dario Bula Martinez
  36. Posted by Sandra
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Katerine
        • Posted by Robin Solano
          • Posted by andrea
          • Posted by Gustavo A. Sebastiani Cépeda
  37. Posted by julio cesar munguia morales
  38. Posted by luis rodriguez
  39. Posted by Liliana Rodgers
    • Posted by Gustavo A. Sebastiani Cépeda
  40. Posted by david
    • Posted by Gustavo A. Sebastiani Cépeda
  41. Posted by Joana
    • Posted by Joana
  42. Posted by Iovany
  43. Posted by Sebastian
  44. Posted by victor
  45. Posted by ZULMA
  46. Posted by E. Caballero
  47. Posted by ARI MULTISERVICIOS
  48. Posted by Angie
  49. Posted by ivon
    • Posted by Gustavo A. Sebastiani Cépeda
  50. Posted by carlos bergara
    • Posted by Robin Solano
  51. Posted by Norman
  52. Posted by ALEX HERNANDEZ TORRES
    • Posted by Robin Solano
      • Posted by Marcos
        • Posted by Robin Solano
  53. Posted by Alejandro
    • Posted by Robin Solano
  54. Posted by julio cesar santos
  55. Posted by Wilfredo Flores
    • Posted by Wilfredo Flores
    • Posted by Gustavo A. Sebastiani Cépeda
  56. Posted by RICARDO HERNANDEZ
    • Posted by Gustavo A. Sebastiani Cépeda
  57. Posted by Marcela
    • Posted by Gustavo A. Sebastiani Cépeda
  58. Posted by Carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  59. Posted by Franco Rocha
    • Posted by Gustavo A. Sebastiani Cépeda
  60. Posted by Consuelo
    • Posted by Gustavo A. Sebastiani Cépeda
  61. Posted by Arturo Arellano Matos
  62. Posted by Andrea Riveros Llorente
  63. Posted by María Alexandra Solano C
    • Posted by Gustavo A. Sebastiani Cépeda
  64. Posted by tito arredondo garcia
  65. Posted by Karito
    • Posted by Gustavo A. Sebastiani Cépeda
  66. Posted by Martin
    • Posted by Gustavo A. Sebastiani Cépeda
  67. Posted by RICARDO
    • Posted by Gustavo A. Sebastiani Cépeda
  68. Posted by Camila
    • Posted by Gustavo A. Sebastiani Cépeda
  69. Posted by Javier Colaiacovo
    • Posted by Gustavo A. Sebastiani Cépeda
  70. Posted by Nicolas
    • Posted by Gustavo A. Sebastiani Cépeda
  71. Posted by Manuel
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Karla
        • Posted by jorge
          • Posted by Gustavo A. Sebastiani Cépeda
  72. Posted by WALTER RONQUILLO
  73. Posted by Jorge
  74. Posted by Marisa
  75. Posted by perugina
    • Posted by Gustavo A. Sebastiani Cépeda
  76. Posted by ivan
    • Posted by Gustavo A. Sebastiani Cépeda
  77. Posted by Chima
    • Posted by Gustavo A. Sebastiani Cépeda
  78. Posted by wilton
  79. Posted by Margarita
  80. Posted by Paulo
    • Posted by Gustavo A. Sebastiani Cépeda
  81. Posted by Felipe
  82. Posted by Carla
  83. Posted by franklin mijhaiel herrera alvarez
  84. Posted by Carlos
  85. Posted by Artemisa
  86. Posted by arubio
    • Posted by Gustavo A. Sebastiani Cépeda
  87. Posted by Diana
    • Posted by michael
  88. Posted by Dailys
  89. Posted by Angel Enrique
  90. Posted by luis
    • Posted by Gustavo A. Sebastiani Cépeda
  91. Posted by christian
    • Posted by Gustavo A. Sebastiani Cépeda
  92. Posted by Jonhatan
    • Posted by Jonhatan
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by sandr
  93. Posted by irvin
    • Posted by Gustavo A. Sebastiani Cépeda
  94. Posted by Ahorrador
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by ALICIA
      • Posted by Ahorrador
        • Posted by Gustavo A. Sebastiani Cépeda
          • Posted by Christian
          • Posted by Gustavo A. Sebastiani Cépeda
  95. Posted by César
  96. Posted by Juan Carlos Gamboa
  97. Posted by Maggie
  98. Posted by rene
    • Posted by Francisco
  99. Posted by Manuel
  100. Posted by enrique
  101. Posted by enrique
  102. Posted by Tello López
  103. Posted by MARTHA CECILIA
  104. Posted by Eloy Meza
  105. Posted by Dubner
  106. Posted by juan Ka
  107. Posted by Rocio
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Sandra
      • Posted by Lim
        • Posted by Gustavo A. Sebastiani Cépeda
  108. Posted by Manolo
  109. Posted by Melisa
    • Posted by Gustavo A. Sebastiani Cépeda
  110. Posted by Lilyana
  111. Posted by Claudia
  112. Posted by Kako Nauta
  113. Posted by mauri
    • Posted by Marco
      • Posted by Osvaldo
  114. Posted by Tessa
    • Posted by Claudia
  115. Posted by Sears
  116. Posted by Gemma
  117. Posted by Esteban
  118. Posted by Marco
  119. Posted by JAZMIN
  120. Posted by SAMUEL
  121. Posted by jim
  122. Posted by Daniel
  123. Posted by francklin
    • Posted by Silvestre