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 MARIA DEL CARMEN CASTIÑEIRAS IBAÑEZ
  2. Posted by Mell
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Mell
        • Posted by Mell
        • Posted by Gustavo A. Sebastiani Cépeda
  3. Posted by eduardo lopez
  4. Posted by Angela
    • Posted by Gustavo A. Sebastiani Cépeda
  5. Posted by checo
    • Posted by Gustavo A. Sebastiani Cépeda
  6. Posted by Mauro
    • Posted by Gustavo A. Sebastiani Cépeda
  7. Posted by Alejandro Nicolas Nario
    • Posted by Gustavo A. Sebastiani Cépeda
  8. Posted by Nosa
    • Posted by Gustavo A. Sebastiani Cépeda
  9. Posted by Marta
    • Posted by Gustavo A. Sebastiani Cépeda
  10. Posted by ANA LAURA CANEDO RAMA
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Lissette
        • Posted by Gustavo A. Sebastiani Cépeda
  11. Posted by Ricardo Nicolas Mier Garza
    • Posted by Gustavo A. Sebastiani Cépeda
  12. Posted by Camila
    • Posted by Gustavo A. Sebastiani Cépeda
  13. Posted by diana
  14. Posted by diana
  15. Posted by diana
  16. Posted by 0scar Fermin
    • Posted by Gustavo A. Sebastiani Cépeda
  17. Posted by valentina
    • Posted by Gustavo A. Sebastiani Cépeda
  18. Posted by carlos vilera
    • Posted by Gustavo A. Sebastiani Cépeda
  19. Posted by Dayann Stephanie Sanchez
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by herald talavera
        • Posted by Gustavo A. Sebastiani Cépeda
  20. Posted by Connie
    • Posted by Gustavo A. Sebastiani Cépeda
  21. Posted by Marcela Bedoya
    • Posted by Gustavo A. Sebastiani Cépeda
  22. Posted by Dairene
    • Posted by Gustavo A. Sebastiani Cépeda
  23. Posted by Carmen
    • Posted by Gustavo A. Sebastiani Cépeda
  24. Posted by Angélica
    • Posted by Gustavo A. Sebastiani Cépeda
  25. Posted by CRISTIAN CARRASCO
    • Posted by Gustavo A. Sebastiani Cépeda
  26. Posted by LILIAN
    • Posted by Gustavo A. Sebastiani Cépeda
  27. Posted by DIOMEDES
    • Posted by Gustavo A. Sebastiani Cépeda
  28. Posted by Maria Sol
    • Posted by Gustavo A. Sebastiani Cépeda
  29. Posted by Sussan
    • Posted by Gustavo A. Sebastiani Cépeda
  30. Posted by sara
    • Posted by Gustavo A. Sebastiani Cépeda
  31. Posted by MAGDA CHACON
    • Posted by Gustavo A. Sebastiani Cépeda
  32. Posted by Lorena
    • Posted by Gustavo A. Sebastiani Cépeda
  33. Posted by FELIPE PERALTA
    • Posted by Gustavo A. Sebastiani Cépeda
  34. Posted by AURA
    • Posted by Gustavo A. Sebastiani Cépeda
  35. Posted by ESTEBAN
    • Posted by Gustavo A. Sebastiani Cépeda
  36. Posted by Ada Quintero
    • Posted by Gustavo A. Sebastiani Cépeda
  37. Posted by LUISA FERNANDA PEREZ
    • Posted by Gustavo A. Sebastiani Cépeda
  38. Posted by Ariangely
    • Posted by Gustavo A. Sebastiani Cépeda
  39. Posted by Ada Quintero
    • Posted by Gustavo A. Sebastiani Cépeda
  40. Posted by Juana Gonzalez
    • Posted by Gustavo A. Sebastiani Cépeda
  41. Posted by Ariangely
    • Posted by Gustavo A. Sebastiani Cépeda
  42. Posted by Natalia
    • Posted by Gustavo A. Sebastiani Cépeda
  43. Posted by iRVING MARTINEZ
    • Posted by Gustavo A. Sebastiani Cépeda
  44. Posted by Carolina
    • Posted by Gustavo A. Sebastiani Cépeda
  45. Posted by martha
    • Posted by Gustavo A. Sebastiani Cépeda
  46. Posted by mariana
    • Posted by Gustavo A. Sebastiani Cépeda
  47. Posted by Larissa
    • Posted by Gustavo A. Sebastiani Cépeda
  48. Posted by Hernán Rodriguez
    • Posted by Gustavo A. Sebastiani Cépeda
  49. Posted by angela diaz
    • Posted by Gustavo A. Sebastiani Cépeda
  50. Posted by YAMITH GOMEZ
    • Posted by Gustavo A. Sebastiani Cépeda
  51. Posted by FERNANDO ALIRIO INGA
    • Posted by Gustavo A. Sebastiani Cépeda
  52. Posted by Cristina
    • Posted by Gustavo A. Sebastiani Cépeda
  53. Posted by Erika
    • Posted by Gustavo A. Sebastiani Cépeda
  54. Posted by Marco
    • Posted by Gustavo A. Sebastiani Cépeda
  55. Posted by Yessy Centella
    • Posted by Gustavo A. Sebastiani Cépeda
  56. Posted by Avelimar Gomez
    • Posted by Gustavo A. Sebastiani Cépeda
  57. Posted by Amilkar Lopez
    • Posted by Gustavo A. Sebastiani Cépeda
  58. Posted by claudia
    • Posted by Gustavo A. Sebastiani Cépeda
  59. Posted by Miquel Moreno
    • Posted by Gustavo A. Sebastiani Cépeda
  60. Posted by Franco Manriquez
    • Posted by Gustavo A. Sebastiani Cépeda
  61. Posted by Gustavo Arrieta
    • Posted by Gustavo A. Sebastiani Cépeda
  62. Posted by Melissa
    • Posted by Gustavo A. Sebastiani Cépeda
  63. Posted by Wendy Molina Díaz
    • Posted by Gustavo A. Sebastiani Cépeda
  64. Posted by Jose
    • Posted by Gustavo A. Sebastiani Cépeda
  65. Posted by Ana
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Ana
        • Posted by Gustavo A. Sebastiani Cépeda
  66. Posted by Sarah Salazar Farfán
    • Posted by Gustavo A. Sebastiani Cépeda
  67. Posted by Andrea
    • Posted by Gustavo A. Sebastiani Cépeda
  68. Posted by Nelly
    • Posted by Gustavo A. Sebastiani Cépeda
  69. Posted by Giancarlo
    • Posted by Gustavo A. Sebastiani Cépeda
  70. Posted by TERE
    • Posted by Gustavo A. Sebastiani Cépeda
  71. Posted by juan florez
  72. Posted by Alejandro
    • Posted by Gustavo A. Sebastiani Cépeda
  73. Posted by Camila
    • Posted by Gustavo A. Sebastiani Cépeda
  74. Posted by Diana Pinzon
    • Posted by Gustavo A. Sebastiani Cépeda
  75. Posted by Paulina Robledo
    • Posted by Gustavo A. Sebastiani Cépeda
  76. Posted by Andrea
    • Posted by Gustavo A. Sebastiani Cépeda
  77. Posted by mariano
    • Posted by Gustavo A. Sebastiani Cépeda
  78. Posted by Juanky
    • Posted by Gustavo A. Sebastiani Cépeda
  79. Posted by luis
    • Posted by Gustavo A. Sebastiani Cépeda
  80. Posted by Ana
    • Posted by Gustavo A. Sebastiani Cépeda
  81. Posted by Ana
    • Posted by Gustavo A. Sebastiani Cépeda
  82. Posted by N. Sánchez
    • Posted by Gustavo A. Sebastiani Cépeda
  83. Posted by N. Sánchez
    • Posted by Gustavo A. Sebastiani Cépeda
  84. Posted by alex
    • Posted by Gustavo A. Sebastiani Cépeda
  85. Posted by Ana
    • Posted by Gustavo A. Sebastiani Cépeda
  86. Posted by MARE
    • Posted by Gustavo A. Sebastiani Cépeda
  87. Posted by Mare Producciones
    • Posted by Gustavo A. Sebastiani Cépeda
  88. Posted by Melani
    • Posted by Gustavo A. Sebastiani Cépeda
  89. Posted by Ana
    • Posted by Gustavo A. Sebastiani Cépeda
  90. Posted by ADRIAN
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Maryana
      • Posted by Gustavo A. Sebastiani Cépeda
  91. Posted by Viviana
    • Posted by Gustavo A. Sebastiani Cépeda
  92. Posted by yady
    • Posted by Gustavo A. Sebastiani Cépeda
  93. Posted by barbara
    • Posted by Gustavo A. Sebastiani Cépeda
  94. Posted by Julian Gordillo
    • Posted by Gustavo A. Sebastiani Cépeda
  95. Posted by Diego P
    • Posted by Gustavo A. Sebastiani Cépeda
  96. Posted by abel
    • Posted by Gustavo A. Sebastiani Cépeda
  97. Posted by daniel macias
    • Posted by Gustavo A. Sebastiani Cépeda
  98. Posted by Lucas
    • Posted by Gustavo A. Sebastiani Cépeda
  99. Posted by JAVIER
    • Posted by Gustavo A. Sebastiani Cépeda
  100. Posted by Isaac
    • Posted by Gustavo A. Sebastiani Cépeda
  101. Posted by alexander garcia
    • Posted by Gustavo A. Sebastiani Cépeda
  102. Posted by Juan
    • Posted by Gustavo A. Sebastiani Cépeda
  103. Posted by Sofia
    • Posted by Gustavo A. Sebastiani Cépeda
  104. Posted by federico
    • Posted by Gustavo A. Sebastiani Cépeda
  105. Posted by cipriana
    • Posted by Gustavo A. Sebastiani Cépeda
  106. Posted by Martin
    • Posted by Gustavo A. Sebastiani Cépeda
  107. Posted by Fernando Sanchez
    • Posted by Gustavo A. Sebastiani Cépeda
  108. Posted by Jose Antonio
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by José Antonio
        • Posted by Gustavo A. Sebastiani Cépeda
  109. Posted by yesenia
    • Posted by Gustavo A. Sebastiani Cépeda
  110. Posted by Liezbeth Celis
    • Posted by Gustavo A. Sebastiani Cépeda
  111. Posted by Luz Edilem Orozco
    • Posted by Gustavo A. Sebastiani Cépeda
  112. Posted by María Luisa Sancho Soriano
  113. Posted by Jorge Segovia
    • Posted by Gustavo A. Sebastiani Cépeda
  114. Posted by Andres
    • Posted by Gustavo A. Sebastiani Cépeda
  115. Posted by Guillermo Gismondi
    • Posted by Gustavo A. Sebastiani Cépeda
  116. Posted by jose carlos garcia medina
    • Posted by Gustavo A. Sebastiani Cépeda
  117. Posted by Adriana
    • Posted by Gustavo A. Sebastiani Cépeda
  118. Posted by Sara
    • Posted by Gustavo A. Sebastiani Cépeda
  119. Posted by Klaus
    • Posted by Gustavo A. Sebastiani Cépeda
  120. Posted by pedro
    • Posted by Gustavo A. Sebastiani Cépeda
  121. Posted by Ismael Casneiro
    • Posted by Gustavo A. Sebastiani Cépeda
  122. Posted by Marianne
    • Posted by Gustavo A. Sebastiani Cépeda
  123. Posted by Danie
    • Posted by Gustavo A. Sebastiani Cépeda
  124. Posted by JUAN OLATE
    • Posted by Gustavo A. Sebastiani Cépeda
  125. Posted by Alfonso
    • Posted by Gustavo A. Sebastiani Cépeda
  126. Posted by Abraham Lee
    • Posted by Gustavo A. Sebastiani Cépeda
  127. Posted by Nasly
    • Posted by Gustavo A. Sebastiani Cépeda
  128. Posted by Blair Angel
    • Posted by Gustavo A. Sebastiani Cépeda
  129. Posted by Daniel Estévez
    • Posted by FERNANDOB
  130. Posted by GLADYS
    • Posted by Gustavo A. Sebastiani Cépeda
  131. Posted by blanca
  132. Posted by Lucia
    • Posted by Gustavo A. Sebastiani Cépeda
  133. Posted by veronica
    • Posted by Gustavo A. Sebastiani Cépeda
  134. Posted by hector castillo
  135. Posted by mauro
    • Posted by Gustavo A. Sebastiani Cépeda
  136. Posted by GENESIS
  137. Posted by José Marín Ruiz
    • Posted by joel
  138. Posted by Bryan
    • Posted by Gustavo A. Sebastiani Cépeda
  139. Posted by Maria Eloisa
  140. Posted by jose
  141. Posted by Ramiro
  142. Posted by Carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  143. Posted by fernando bol
  144. Posted by Isidro Sada Salum
    • Posted by Gustavo A. Sebastiani Cépeda
  145. Posted by samuel hernandez
  146. Posted by Luisa Sánchez
  147. Posted by Patricia Zarate
    • Posted by Gustavo A. Sebastiani Cépeda
  148. Posted by cuevano
    • Posted by Gustavo A. Sebastiani Cépeda
  149. Posted by Joan
    • Posted by Gustavo A. Sebastiani Cépeda
  150. Posted by kharem
  151. Posted by Diego
  152. Posted by elio
  153. Posted by Damian
    • Posted by Robin Solano
  154. Posted by juan carlos
  155. Posted by luis consuegra
    • Posted by Robin Solano
  156. Posted by Alonso
    • Posted by Robin Solano
      • Posted by Marina
        • Posted by Gustavo A. Sebastiani Cépeda
  157. Posted by Simón
  158. Posted by Pedro Benitez
  159. Posted by Alexander
  160. Posted by Fátima Hernández
  161. Posted by dan
    • Posted by Elkin Dario Bula Martinez
  162. 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
  163. Posted by julio cesar munguia morales
  164. Posted by luis rodriguez
  165. Posted by Liliana Rodgers
    • Posted by Gustavo A. Sebastiani Cépeda
  166. Posted by david
    • Posted by Gustavo A. Sebastiani Cépeda
  167. Posted by Joana
    • Posted by Joana
  168. Posted by Iovany
  169. Posted by Sebastian
  170. Posted by victor
  171. Posted by ZULMA
  172. Posted by E. Caballero
  173. Posted by ARI MULTISERVICIOS
  174. Posted by Angie
  175. Posted by ivon
    • Posted by Gustavo A. Sebastiani Cépeda
  176. Posted by carlos bergara
    • Posted by Robin Solano
  177. Posted by Norman
  178. Posted by ALEX HERNANDEZ TORRES
    • Posted by Robin Solano
      • Posted by Marcos
        • Posted by Robin Solano
  179. Posted by Alejandro
    • Posted by Robin Solano
  180. Posted by julio cesar santos
  181. Posted by Wilfredo Flores
    • Posted by Wilfredo Flores
    • Posted by Gustavo A. Sebastiani Cépeda
  182. Posted by RICARDO HERNANDEZ
    • Posted by Gustavo A. Sebastiani Cépeda
  183. Posted by Marcela
    • Posted by Gustavo A. Sebastiani Cépeda
  184. Posted by Carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  185. Posted by Franco Rocha
    • Posted by Gustavo A. Sebastiani Cépeda
  186. Posted by Consuelo
    • Posted by Gustavo A. Sebastiani Cépeda
  187. Posted by Arturo Arellano Matos
  188. Posted by Andrea Riveros Llorente
  189. Posted by María Alexandra Solano C
    • Posted by Gustavo A. Sebastiani Cépeda
  190. Posted by tito arredondo garcia
  191. Posted by Karito
    • Posted by Gustavo A. Sebastiani Cépeda
  192. Posted by Martin
    • Posted by Gustavo A. Sebastiani Cépeda
  193. Posted by RICARDO
    • Posted by Gustavo A. Sebastiani Cépeda
  194. Posted by Camila
    • Posted by Gustavo A. Sebastiani Cépeda
  195. Posted by Javier Colaiacovo
    • Posted by Gustavo A. Sebastiani Cépeda
  196. Posted by Nicolas
    • Posted by Gustavo A. Sebastiani Cépeda
  197. Posted by Manuel
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Karla
        • Posted by jorge
          • Posted by Gustavo A. Sebastiani Cépeda
  198. Posted by WALTER RONQUILLO
  199. Posted by Jorge
  200. Posted by Marisa
  201. Posted by perugina
    • Posted by Gustavo A. Sebastiani Cépeda
  202. Posted by ivan
    • Posted by Gustavo A. Sebastiani Cépeda
  203. Posted by Chima
    • Posted by Gustavo A. Sebastiani Cépeda
  204. Posted by wilton
  205. Posted by Margarita
  206. Posted by Paulo
    • Posted by Gustavo A. Sebastiani Cépeda
  207. Posted by Felipe
  208. Posted by Carla
  209. Posted by franklin mijhaiel herrera alvarez
  210. Posted by Carlos
  211. Posted by Artemisa
  212. Posted by arubio
    • Posted by Gustavo A. Sebastiani Cépeda
  213. Posted by Diana
    • Posted by michael
  214. Posted by Dailys
  215. Posted by Angel Enrique
  216. Posted by luis
    • Posted by Gustavo A. Sebastiani Cépeda
  217. Posted by christian
    • Posted by Gustavo A. Sebastiani Cépeda
  218. Posted by Jonhatan
    • Posted by Jonhatan
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by sandr
  219. Posted by irvin
    • Posted by Gustavo A. Sebastiani Cépeda
  220. 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
  221. Posted by César
  222. Posted by Juan Carlos Gamboa
  223. Posted by Maggie
  224. Posted by rene
    • Posted by Francisco
  225. Posted by Manuel
  226. Posted by enrique
  227. Posted by enrique
  228. Posted by Tello López
  229. Posted by MARTHA CECILIA
  230. Posted by Eloy Meza
  231. Posted by Dubner
  232. Posted by juan Ka
  233. Posted by Rocio
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Sandra
      • Posted by Lim
        • Posted by Gustavo A. Sebastiani Cépeda
  234. Posted by Manolo
  235. Posted by Melisa
    • Posted by Gustavo A. Sebastiani Cépeda
  236. Posted by Lilyana
  237. Posted by Claudia
  238. Posted by Kako Nauta
  239. Posted by mauri
    • Posted by Marco
      • Posted by Osvaldo
  240. Posted by Tessa
    • Posted by Claudia
  241. Posted by Sears
  242. Posted by Gemma
  243. Posted by Esteban
  244. Posted by Marco
  245. Posted by JAZMIN
  246. Posted by SAMUEL
  247. Posted by jim
  248. Posted by Daniel
  249. Posted by francklin
    • Posted by Silvestre