BUSCA AQUI UN ARCHIVO EXCEL ►

Sistema de Contabilidad Simplificada en Excel

Menu sistema contable en excel

Sistema de Contabilidad Simplificada en Excel: Adquirir un software contable puede ser considerablemente caro y muy complejo si se trata de una pequeña o mediana empresa, es por eso que te brindamos la posibilidad de usar un sistema desarrollado en excel para contabilidad simplificada SIN COSTO ALGUNO el cual esta constantemente en actualización tomando en cuenta las sugerencias recogidas en esta página. La contabilidad simplificada se ampara en la Ley 30056 – RS N° 226-2013/SUNAT la cual nos indica que todas las empresas del régimen general que obtengan hasta 150 UIT al año deben llevar el registro de compras, registro de ventas y el libro diario de formato simplificado.

Este sistema esta desarrollado mediante el uso de macros (herramientas avanzadas en excel) que nos permiten automatizar procesos para facilitar nuestras labores contables, a la fecha este archivo viene siendo usado por más de 150 contadores en todo el Perú y conforme las normas van cambiando se va actualizando.

Este archivo esta actualizado al 2015, antes tenía un precio pero hoy he decidido compartirlo y ponerlo a disposición de todos ustedes. Puedes descargar el archivo al final del artículo.

Si tienes Estudio Contable, o trabajas en una empresa o eres contador independiente será una herramienta de gran ayuda, espero tus comentarios para que juntos optimicemos este archivo.

MODULOS

  • Plan Contable General para Empresas 2015.

  • Base de datos de clientes y proveedores.

  • Registro de Compras (Formato 8.1 – Sunat).

  • Registro de Ventas (Formato 14.1 – Sunat).

  • Diario Convencional

  • Diario Simplificado

  • Control de Cuentas por pagar y cobrar

  • Hoja de trabajo (analizada a nivel de devisionarias).

  • Estados financieros

CAPTURAS

MENÚ PRINCIPAL

Menu sistema contable en excel


MODULO LIBRO DIARIO

contabilidad simplificada diario simplificado

MODULO REGISTRO DE COMPRAS

contabilidad simplificada registro de compras

MODULO REGISTRO DE VENTAS

contabilidad simplificada registro de ventas

ASÍ FUNCIONA ESTE ARCHIVO

DESCARGA EL ARCHIVO

Descargar sistema de contabilidad simplificada en Excel.xls

CODIGO FUENTE LIBRE – ARCHIVO LIBERADO

Ingresa tu correo electrónico y te convertiré en un experto en Excel. ↓


Agrega tu comentario

Comentarios
  1. Posted by Rosvel
    • Posted by Gustavo A. Sebastiani Cépeda
  2. Posted by FORTUNATA VILLANUEVA SANCHEZ
    • Posted by Gustavo A. Sebastiani Cépeda
  3. Posted by Alejandro
    • Posted by Gustavo A. Sebastiani Cépeda
  4. Posted by Antoni Llique
    • Posted by Gustavo A. Sebastiani Cépeda
  5. Posted by Jose Yamid
  6. Posted by WASHINGTON
    • Posted by Gustavo A. Sebastiani Cépeda
  7. Posted by Roberto daniel arce fructus
    • Posted by Gustavo A. Sebastiani Cépeda
  8. Posted by Norma
    • Posted by Gustavo A. Sebastiani Cépeda
  9. Posted by Margare
    • Posted by Gustavo A. Sebastiani Cépeda
  10. Posted by Nicols Zuniga
    • Posted by Gustavo A. Sebastiani Cépeda
  11. Posted by Carmenzch
    • Posted by Gustavo A. Sebastiani Cépeda
  12. Posted by Jose Enciso
    • Posted by Gustavo A. Sebastiani Cépeda
  13. Posted by daniela
  14. Posted by FERNANDO ZUÑIGA
    • Posted by Gustavo A. Sebastiani Cépeda
  15. Posted by fabian
  16. Posted by Roland
    • Posted by Gustavo A. Sebastiani Cépeda
  17. Posted by domingo rosales
    • Posted by Gustavo A. Sebastiani Cépeda
  18. Posted by Jonnathan
  19. Posted by Monica Carrillo
    • Posted by Gustavo A. Sebastiani Cépeda
  20. Posted by Alessandro Coletti
    • Posted by Gustavo A. Sebastiani Cépeda
  21. Posted by Cesar YH
    • Posted by Gustavo A. Sebastiani Cépeda
  22. Posted by LISETH INGA
  23. Posted by jose luis moreno
    • Posted by Gustavo A. Sebastiani Cépeda
  24. Posted by Carola
    • Posted by Gustavo A. Sebastiani Cépeda
  25. Posted by ALDO A BODERO CRIOLLO
    • Posted by Gustavo A. Sebastiani Cépeda
  26. Posted by jesus
    • Posted by Gustavo A. Sebastiani Cépeda
  27. Posted by Roberto
    • Posted by Gustavo A. Sebastiani Cépeda
  28. Posted by Teddy
    • Posted by Gustavo A. Sebastiani Cépeda
  29. Posted by Bernardo
    • Posted by Gustavo A. Sebastiani Cépeda
  30. Posted by Claudio Guevara
  31. Posted by JuanDelgado Ortiz
    • Posted by Gustavo A. Sebastiani Cépeda
  32. Posted by jesus ignacio
  33. Posted by MERCCI IBAÑEZ
    • Posted by Gustavo A. Sebastiani Cépeda
  34. Posted by Jorge Anibal
  35. Posted by sec. DDHH
    • Posted by Gustavo A. Sebastiani Cépeda
  36. Posted by Yorkevin Alayon
  37. Posted by IVAN
    • Posted by Gustavo A. Sebastiani Cépeda
  38. Posted by Cristian
    • Posted by Cristian
    • Posted by Gustavo A. Sebastiani Cépeda
  39. Posted by Lizbeth Dominguez Ramirez
  40. Posted by Latacunga Blanca
  41. Posted by ELMAR
    • Posted by Gustavo A. Sebastiani Cépeda
  42. Posted by taty
    • Posted by Gustavo A. Sebastiani Cépeda
  43. Posted by Jose Santa Ana
  44. Posted by rous
  45. Posted by rous
    • Posted by Gustavo A. Sebastiani Cépeda
  46. Posted by Jose Santa Ana
    • Posted by Gustavo A. Sebastiani Cépeda
  47. Posted by PABLO NATANAEL FERNANDE
    • Posted by Gustavo A. Sebastiani Cépeda
  48. Posted by LUIS ALBERTO MEDINA COLLANTES
    • Posted by Gustavo A. Sebastiani Cépeda
  49. Posted by Bryam Chicas
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Jorge López
        • Posted by Gustavo A. Sebastiani Cépeda
  50. Posted by Fernando Alberto
    • Posted by Gustavo A. Sebastiani Cépeda
  51. Posted by Latacunga Blanca
    • Posted by Gustavo A. Sebastiani Cépeda
  52. Posted by Latacunga Blanca
    • Posted by Gustavo A. Sebastiani Cépeda
  53. Posted by saul yauri
    • Posted by Gustavo A. Sebastiani Cépeda
  54. Posted by MARTIN PAREDES
    • Posted by Gustavo A. Sebastiani Cépeda
  55. Posted by geremias carranza
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by geremias carranza cieza
        • Posted by Gustavo A. Sebastiani Cépeda
  56. Posted by VICTOR
    • Posted by Gustavo A. Sebastiani Cépeda
  57. Posted by Robert Carlo Guevara Castillo
    • Posted by Gustavo A. Sebastiani Cépeda
  58. Posted by Juan De Dios Cueto Ruiz de Somocurcio
    • Posted by Gustavo A. Sebastiani Cépeda
  59. Posted by Guadalupe Reyes
  60. Posted by LINA ESTELLA BOJORGE AGUIRRE
  61. Posted by Jorge López
    • Posted by Gustavo A. Sebastiani Cépeda
  62. Posted by Pilar
  63. Posted by Vicente Orbegoso Rodriguez
    • Posted by Gustavo A. Sebastiani Cépeda
  64. Posted by Miguel
    • Posted by Gustavo A. Sebastiani Cépeda
  65. Posted by ESTELA FERNANDEZ LAZON
    • Posted by Gustavo A. Sebastiani Cépeda
  66. Posted by Liliana Sanfilippo
    • Posted by Gustavo A. Sebastiani Cépeda
  67. Posted by Jose
    • Posted by Gustavo A. Sebastiani Cépeda
  68. Posted by susana
    • Posted by Gustavo A. Sebastiani Cépeda
  69. Posted by VIVIANA CAMPO GRISALES
  70. Posted by Emiliano zenteno
  71. Posted by Miriam
    • Posted by Gustavo A. Sebastiani Cépeda
  72. Posted by VIVIANA
  73. Posted by LINO
    • Posted by Gustavo A. Sebastiani Cépeda
  74. Posted by lucio Ruiz
  75. Posted by Pedro
    • Posted by Gustavo A. Sebastiani Cépeda
  76. Posted by RUBEN SEGOVIA SANCHEZ
    • Posted by Gustavo A. Sebastiani Cépeda
  77. Posted by Javier Bancayan Elera
    • Posted by Gustavo A. Sebastiani Cépeda
  78. Posted by JOSE
    • Posted by Gustavo A. Sebastiani Cépeda
  79. Posted by JOSE
    • Posted by Gustavo A. Sebastiani Cépeda
  80. Posted by STEVE
    • Posted by Gustavo A. Sebastiani Cépeda
  81. Posted by DANA
    • Posted by Gustavo A. Sebastiani Cépeda
  82. Posted by JULIO FLORES
    • Posted by Gustavo A. Sebastiani Cépeda
  83. Posted by JULIO FLORES
    • Posted by Gustavo A. Sebastiani Cépeda
  84. Posted by carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  85. Posted by Carla Dulanto Vargas
  86. Posted by KARINA
    • Posted by Gustavo A. Sebastiani Cépeda
  87. Posted by JOSE PERALTA
    • Posted by Gustavo A. Sebastiani Cépeda
  88. Posted by OSCAR
    • Posted by Gustavo A. Sebastiani Cépeda
  89. Posted by Vicente Huamani Gutierrez
    • Posted by Gustavo A. Sebastiani Cépeda
  90. Posted by JULIO FLORES
    • Posted by Gustavo A. Sebastiani Cépeda
  91. Posted by Paola Andrea Barrera
    • Posted by Gustavo A. Sebastiani Cépeda
  92. Posted by César
    • Posted by Gustavo A. Sebastiani Cépeda
  93. Posted by EDUARDO
    • Posted by Gustavo A. Sebastiani Cépeda
  94. Posted by victor
    • Posted by Gustavo A. Sebastiani Cépeda
  95. Posted by OSCAR
    • Posted by Gustavo A. Sebastiani Cépeda
  96. Posted by Ana
    • Posted by Gustavo A. Sebastiani Cépeda
  97. Posted by Alejandro iturre
    • Posted by Gustavo A. Sebastiani Cépeda
  98. Posted by DIEGO SALINAS
    • Posted by Gustavo A. Sebastiani Cépeda
  99. Posted by lucia carrillo
    • Posted by Gustavo A. Sebastiani Cépeda
  100. Posted by Marcelo García
    • Posted by Gustavo A. Sebastiani Cépeda
  101. Posted by Ivan Rozo
    • Posted by Gustavo A. Sebastiani Cépeda
  102. Posted by Pamela
    • Posted by Gustavo A. Sebastiani Cépeda
  103. Posted by jennifer
    • Posted by Gustavo A. Sebastiani Cépeda
  104. Posted by ROCIO
    • Posted by Gustavo A. Sebastiani Cépeda
  105. Posted by Diego
    • Posted by Gustavo A. Sebastiani Cépeda
  106. Posted by Flor
  107. Posted by ANTONIO
    • Posted by Gustavo A. Sebastiani Cépeda
  108. Posted by Fernando
    • Posted by Gustavo A. Sebastiani Cépeda
  109. Posted by RICHARD
    • Posted by Gustavo A. Sebastiani Cépeda
  110. Posted by ANGELY
    • Posted by Gustavo A. Sebastiani Cépeda
  111. Posted by pedro yovera anastacio
    • Posted by Gustavo A. Sebastiani Cépeda
  112. Posted by Andres Flores Meneses
    • Posted by Gustavo A. Sebastiani Cépeda
  113. Posted by jose castañeda carpio
  114. Posted by Adrian
    • Posted by Gustavo A. Sebastiani Cépeda
  115. Posted by Edgar JPP
    • Posted by Gustavo A. Sebastiani Cépeda
  116. Posted by Daniel
    • Posted by Gustavo A. Sebastiani Cépeda
  117. Posted by Carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  118. Posted by Luc Moreno
    • Posted by Gustavo A. Sebastiani Cépeda
  119. Posted by Emerson
    • Posted by Gustavo A. Sebastiani Cépeda
  120. Posted by david
    • Posted by Gustavo A. Sebastiani Cépeda
  121. Posted by jose luis
  122. Posted by David
  123. Posted by Patricia
  124. Posted by alexander
  125. Posted by Guillermo
    • Posted by Gustavo A. Sebastiani Cépeda
  126. Posted by teddy
  127. Posted by lau osorio
    • Posted by Gustavo A. Sebastiani Cépeda
  128. Posted by teddy
    • Posted by Gustavo A. Sebastiani Cépeda
  129. Posted by GERARDO
    • Posted by Gustavo A. Sebastiani Cépeda
  130. Posted by marco antonio gregorio arias
    • Posted by Gustavo A. Sebastiani Cépeda
  131. Posted by Jorge
    • Posted by Gustavo A. Sebastiani Cépeda
  132. Posted by BELISARIO MANUEL ALVARADO ROJAS
  133. Posted by gloria maria
  134. Posted by Vanessa
  135. Posted by Jorge Panta Ruiz
    • Posted by Gustavo A. Sebastiani Cépeda
  136. Posted by víctor espinoza
  137. Posted by Carlos Limo
    • Posted by Gustavo A. Sebastiani Cépeda
  138. Posted by Nelson
  139. Posted by Juan Gomez
    • Posted by Gustavo A. Sebastiani Cépeda
  140. Posted by edwi8n
  141. Posted by MARYANNE HUERTAS
    • Posted by Gustavo A. Sebastiani Cépeda
  142. Posted by CHARLES
    • Posted by Gustavo A. Sebastiani Cépeda
  143. Posted by Ruald
    • Posted by Gustavo A. Sebastiani Cépeda
  144. Posted by JHONATAN
    • Posted by Gustavo A. Sebastiani Cépeda
  145. Posted by MARYANNE
    • Posted by Gustavo A. Sebastiani Cépeda
  146. Posted by David Miranda C.
  147. Posted by Jorge Luis Chávez
  148. Posted by Cristian
    • Posted by Gustavo A. Sebastiani Cépeda
  149. Posted by Carolina Alzamora León
    • Posted by Gustavo A. Sebastiani Cépeda
  150. Posted by Antonio Liñan
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by MARYANNE HUERTAS
      • Posted by Gustavo A. Sebastiani Cépeda
  151. Posted by stefania
  152. Posted by EDGARD
    • Posted by Gustavo A. Sebastiani Cépeda
  153. Posted by Doris
    • Posted by Gustavo A. Sebastiani Cépeda
  154. Posted by EDWIN MENDOZA
    • Posted by Gustavo A. Sebastiani Cépeda
  155. Posted by LUIS A
    • Posted by Gustavo A. Sebastiani Cépeda
  156. Posted by Julio
    • Posted by Gustavo A. Sebastiani Cépeda
  157. Posted by Veronica
    • Posted by Gustavo A. Sebastiani Cépeda
  158. Posted by harol guilarte
    • Posted by Gustavo A. Sebastiani Cépeda
  159. Posted by Raul
  160. Posted by REYNALDO
    • Posted by Gustavo A. Sebastiani Cépeda
  161. Posted by Marco
    • Posted by Gustavo A. Sebastiani Cépeda
  162. Posted by margot doris
  163. Posted by GIOVANA CARPIO SALDARRIAGA
    • Posted by Gustavo A. Sebastiani Cépeda
  164. Posted by Darwin
  165. Posted by Miriam
    • Posted by Gustavo A. Sebastiani Cépeda
  166. Posted by wenceslao
    • Posted by Gustavo A. Sebastiani Cépeda
  167. Posted by Yvon
    • Posted by elmer
  168. Posted by SAULO
    • Posted by Gustavo A. Sebastiani Cépeda
  169. Posted by JHON
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by luis a
  170. Posted by Reinaldo Vargas
    • Posted by Gustavo A. Sebastiani Cépeda
  171. Posted by Juan Ricser Ctos
  172. Posted by fernando
    • Posted by Gustavo A. Sebastiani Cépeda
  173. Posted by Edwin meza
  174. Posted by Edwin meza
    • Posted by Gustavo A. Sebastiani Cépeda
  175. Posted by percy
  176. Posted by DANNY MARTIN PACHAS GONZALES
  177. Posted by Julio
  178. Posted by juan francisco
  179. Posted by juan francisco
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by oscar eduardo
  180. Posted by Jose Vertiz
    • Posted by Gustavo A. Sebastiani Cépeda
  181. Posted by Jesus
    • Posted by Gustavo A. Sebastiani Cépeda
  182. Posted by Mariano ESONO NGUEMA ASANGONO
    • Posted by Gustavo A. Sebastiani Cépeda
  183. Posted by Lourdes
  184. Posted by Pascual Rossi
    • Posted by Gustavo A. Sebastiani Cépeda
  185. Posted by Lourdes
    • Posted by Gustavo A. Sebastiani Cépeda
  186. Posted by cesar sanchez
    • Posted by Gustavo A. Sebastiani Cépeda
  187. Posted by alfredo flores
    • Posted by Gustavo A. Sebastiani Cépeda
  188. Posted by armando chapoñan
  189. Posted by MiguelZ
  190. Posted by MiguelZ
    • Posted by Gustavo A. Sebastiani Cépeda
  191. Posted by MAYCKEL
    • Posted by Gustavo A. Sebastiani Cépeda
  192. Posted by nilton cajma
    • Posted by Gustavo A. Sebastiani Cépeda
  193. Posted by Lesly AGURTO peralta
    • Posted by Gustavo A. Sebastiani Cépeda
  194. Posted by Juan Soto
    • Posted by Gustavo A. Sebastiani Cépeda
  195. Posted by Roger Tipula
    • Posted by Gustavo A. Sebastiani Cépeda
  196. Posted by JUAN TORRES
    • Posted by Gustavo A. Sebastiani Cépeda
  197. Posted by Zoraida Rios
    • Posted by Gustavo A. Sebastiani Cépeda
  198. Posted by Gladys Luque
    • Posted by Gustavo A. Sebastiani Cépeda
  199. Posted by Gustavo
    • Posted by Gustavo A. Sebastiani Cépeda
  200. Posted by Brayhan Ramos Tintaya
    • Posted by Gustavo A. Sebastiani Cépeda
  201. Posted by Félix Alejandro Rangel Morales
    • Posted by Gustavo A. Sebastiani Cépeda
  202. Posted by victor raul
  203. Posted by Rafael Paima
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Wilbert
        • Posted by Gustavo A. Sebastiani Cépeda
  204. Posted by humberto saravia saravia
    • Posted by Gustavo A. Sebastiani Cépeda
  205. Posted by humberto saravia saravia
    • Posted by Gustavo A. Sebastiani Cépeda
  206. Posted by Eduardo
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by lorena del carmen
        • Posted by Gustavo A. Sebastiani Cépeda
          • Posted by roy
          • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Eduardo
        • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by Jaime Isaias
      • Posted by Gustavo A. Sebastiani Cépeda
  207. Posted by CRISTHIAN INSUASTI
    • Posted by Gustavo A. Sebastiani Cépeda
  208. Posted by juan flores
    • Posted by Gustavo A. Sebastiani Cépeda
  209. Posted by Junior
    • Posted by Gustavo A. Sebastiani Cépeda
  210. Posted by Cindy
  211. Posted by ANGEL
  212. Posted by Carlos Cisneros Cárdenas
    • Posted by Gustavo A. Sebastiani Cépeda
  213. Posted by henry
    • Posted by Gustavo A. Sebastiani Cépeda
  214. Posted by vilma jayme
    • Posted by Gustavo A. Sebastiani Cépeda
  215. Posted by Anna Rodriguez
    • Posted by Gustavo A. Sebastiani Cépeda
  216. Posted by Lourdes Calderon
    • Posted by Gustavo A. Sebastiani Cépeda
  217. Posted by carlos
  218. Posted by MAURICIO ANGEL CRUZ
    • Posted by Gustavo A. Sebastiani Cépeda
  219. Posted by Paola Cáceres
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by CARLOS
  220. Posted by ANGEL
    • Posted by Gustavo A. Sebastiani Cépeda
  221. Posted by Diana
  222. Posted by Diana
  223. Posted by Blanca Peralta
  224. Posted by Narciso Ramos M.
  225. Posted by John Iman
  226. Posted by Jessy Gaglay
  227. Posted by Carmen Rosa Oliva Vilchez
  228. Posted by FRANK JHORDANY DIAZ S.
  229. Posted by SEGHIRA
  230. Posted by Ahiezer Abreu
  231. Posted by JACQUELINE C.
  232. Posted by laura
  233. Posted by hernan
  234. Posted by ROMULO OBESO GUZMAN
  235. Posted by Juan Omar
  236. Posted by JULIO CESRA CHOQUE
  237. Posted by NESTOR PRIETO
  238. Posted by eduardo
  239. Posted by marina
  240. Posted by WILBER
  241. Posted by MANUEL ROGGER NEVADO VELASQUEZ
  242. Posted by paul
  243. Posted by Rodolfo
  244. Posted by MARINE MARQUEZ
  245. Posted by Miguel
  246. Posted by Emilia
  247. Posted by Luis Leon
  248. Posted by Cecilia
  249. Posted by jose campos
  250. Posted by LUIS CHERO LANDA
  251. Posted by Miguel Del Aguila
  252. Posted by Marcelo
  253. Posted by SANTOS CHAVEZ
  254. Posted by jesus ramos
  255. Posted by Rosa
    • Posted by Sebastiani
  256. Posted by SIMON MARIO MEDINA NAVARRO
  257. Posted by Liliana
  258. Posted by Angel
  259. Posted by EduardoF
  260. Posted by CPC. YOLVI
  261. Posted by JOSE SALVATIERRA Q.
    • Posted by Rafael Paima
      • Posted by Gustavo A. Sebastiani Cépeda
        • Posted by andrea donayre
          • Posted by Gustavo A. Sebastiani Cépeda
          • Posted by LUIS GUSTAVO FLORES BASILIO
          • Posted by Gustavo A. Sebastiani Cépeda