Control de Almacen y valuación método promedio 2015

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

Controlar nuestro stock, mercaderías, artículos y/o productos siempre ha sido un problema debido a que no encontramos el formato apropiado para nuestro negocio, en el siguiente aplicativo hemos tratado de plasmar todas las necesidades y por ello hemos implementado un sistema de stock (inventarios) o control de almacén desarrollado  en Excel (Programación de macros), esta diseñado para controlar los artículos que tengas (su limite es la capacidad de Excel), no importa el giro de tu negocio ya que se adapta a cualquier rubro, tendrás información en tiempo real para la toma de decisiones y aun más, por medio de este aplicativo podrás generar reportes por cada producto (kardex) con su respectiva valuación de costo método promedio así como un reporte consolidado con la información resumida; entre sus principales características podemos destacar su fácil manejo y la integración de ventanas interactivas para el ingreso de la información.

CAPTURAS

Para ingresar al sistema y pensando en tu seguridad te pedimos ingresar una clave de acceso, de esta forma evitaremos que personas ajenas manipulen el archivo.


Usuario del sistema de almacenes en excel

A través del siguiente formulario podemos ingresar “nuevos producto”, “modificar productos” y “eliminar productos”.

ingreso de nuevo producto al control de almacen

Desde aquí podemos ingresar todos los movimientos de nuestras mercaderías como: entradas, salidas e inventario inicial; de igual forma nos permite saber en tiempo real nuestro stock, su manejo es muy sencillo e intuitivo.

Para generar los reportes utilizamos el siguiente menú.
menu para generar reportes control de almacen

REPORTES

Reporte individual por cada Producto

reporte kardex por cada producto - control de almacen

Reporte consolidado resumen

reporte consolidado resumen del control de almacen

MODULOS

  • Base de datos de artículos (Catalogación de productos)
  • Control de Movimientos (Entradas / Salidas / Stock inicial)
  • Reporte por cada artículo / incluye determinación del costo de ventas
  • Reporte consolidado resumen

DEMOSTRACIÓN DE COMO FUNCIONA

Precio: S/ 145.00 Nuevos Soles  /   $45.00 para el Extranjero

                     Informes y Ventas: Rpm #970982933 Rpc 993854499                         email: gustavo@excelnegocios.com

¿COMO COMPRAR?

  1. Efectuar el depósito correspondiente en las siguientes cuentas bancarias: VER CUENTAS
  2. Enviar Voucher scaneado o un mail con los datos de la operación a gustavo@excelnegocios.com

Estaremos atendiendo tu pedido en instantes, en caso de demoras comunícate con nosotros al Rpm #970982933 / Rpc 993854499 preguntar por: Gustavo A. Sebastiani Cépeda.

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

Agrega tu comentario

Comentarios
  1. Posted by Rubén Cercado
    • Posted by Gustavo A. Sebastiani Cépeda
  2. Posted by Miguel
    • Posted by Gustavo A. Sebastiani Cépeda
  3. Posted by josue mejia palomino
    • Posted by Gustavo A. Sebastiani Cépeda
  4. Posted by Francisco
    • Posted by Gustavo A. Sebastiani Cépeda
  5. Posted by Karina Gonzalez
    • Posted by Gustavo A. Sebastiani Cépeda
  6. Posted by Patricia IH
    • Posted by Gustavo A. Sebastiani Cépeda
  7. Posted by Miguel angel
    • Posted by Gustavo A. Sebastiani Cépeda
  8. Posted by LADY ALEMAN HIDALGO
    • Posted by Gustavo A. Sebastiani Cépeda
  9. Posted by Jimmy Diaz
    • Posted by Gustavo A. Sebastiani Cépeda
  10. Posted by erly pauccara
    • Posted by Gustavo A. Sebastiani Cépeda
  11. Posted by Hugo Francisco
    • Posted by Gustavo A. Sebastiani Cépeda
  12. Posted by FRANCISCO JAVIER BARRAZA MANJARREZ
    • Posted by Gustavo A. Sebastiani Cépeda
  13. Posted by Jaime
    • Posted by Gustavo A. Sebastiani Cépeda
  14. Posted by Bernardo
    • Posted by Gustavo A. Sebastiani Cépeda
  15. Posted by Juan
    • Posted by Gustavo A. Sebastiani Cépeda
  16. Posted by Hugo Francisco
    • Posted by Gustavo A. Sebastiani Cépeda
  17. Posted by antonio cordero
    • Posted by Gustavo A. Sebastiani Cépeda
  18. Posted by tomas
    • Posted by Gustavo A. Sebastiani Cépeda
  19. Posted by jonathan
    • Posted by Gustavo A. Sebastiani Cépeda
  20. Posted by Omar rodriguez
    • Posted by Gustavo A. Sebastiani Cépeda
  21. Posted by oscar ruiz
    • Posted by Gustavo A. Sebastiani Cépeda
  22. Posted by Marcelino Avila
    • Posted by Gustavo A. Sebastiani Cépeda
  23. Posted by Elvis
    • Posted by Gustavo A. Sebastiani Cépeda
  24. Posted by ANGEL
    • Posted by Gustavo A. Sebastiani Cépeda
  25. Posted by Miguel
    • Posted by Gustavo A. Sebastiani Cépeda
  26. Posted by Jesus
    • Posted by Gustavo A. Sebastiani Cépeda
  27. Posted by Luis
    • Posted by Gustavo A. Sebastiani Cépeda
  28. Posted by gaby
    • Posted by Gustavo A. Sebastiani Cépeda
  29. Posted by JAIME GASCA
    • Posted by Gustavo A. Sebastiani Cépeda
  30. Posted by Paola Diaz
    • Posted by Gustavo A. Sebastiani Cépeda
  31. Posted by Rosana
    • Posted by Gustavo A. Sebastiani Cépeda
  32. Posted by JAIME GASCA
    • Posted by Gustavo A. Sebastiani Cépeda
  33. Posted by Lenin Bustamante Barrantes
    • Posted by Gustavo A. Sebastiani Cépeda
  34. Posted by edgar
    • Posted by Gustavo A. Sebastiani Cépeda
  35. Posted by Juan Doval
    • Posted by Gustavo A. Sebastiani Cépeda
  36. Posted by cristian
    • Posted by Gustavo A. Sebastiani Cépeda
  37. Posted by Tito
    • Posted by Gustavo A. Sebastiani Cépeda
  38. Posted by eduardo cabrera
    • Posted by Gustavo A. Sebastiani Cépeda
  39. Posted by Cristian
    • Posted by Gustavo A. Sebastiani Cépeda
  40. Posted by Franky Ruiz
    • Posted by Gustavo A. Sebastiani Cépeda
  41. Posted by ENY
    • Posted by Gustavo A. Sebastiani Cépeda
  42. Posted by Sergio
    • Posted by Gustavo A. Sebastiani Cépeda
  43. Posted by Oscar Alfonso Hernandez Sosa
  44. Posted by Tito Celis
    • Posted by Gustavo A. Sebastiani Cépeda
  45. Posted by ronal
    • Posted by Gustavo A. Sebastiani Cépeda
  46. Posted by rover joselito lopez acuña
    • Posted by Gustavo A. Sebastiani Cépeda
  47. Posted by Martin Fernandez
    • Posted by Gustavo A. Sebastiani Cépeda
  48. Posted by Cristian
    • Posted by Gustavo A. Sebastiani Cépeda
  49. Posted by ROVER LOPEZ ACUÑA
    • Posted by Gustavo A. Sebastiani Cépeda
  50. Posted by JEAN CHOQUESA
    • Posted by Gustavo A. Sebastiani Cépeda
  51. Posted by marco chavez
    • Posted by Gustavo A. Sebastiani Cépeda
  52. Posted by Nancy
    • Posted by Gustavo A. Sebastiani Cépeda
  53. Posted by Maria Teresa Ruiz Rubio
    • Posted by Gustavo A. Sebastiani Cépeda
  54. Posted by Bernabe Tocto Huaman
    • Posted by Gustavo A. Sebastiani Cépeda
  55. Posted by daryl sanchez manrique
    • Posted by Gustavo A. Sebastiani Cépeda
  56. Posted by Carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  57. Posted by Freddy salome
    • Posted by Gustavo A. Sebastiani Cépeda
  58. Posted by jessica naucapoma
    • Posted by Gustavo A. Sebastiani Cépeda
  59. Posted by kevin Valencia
    • Posted by Gustavo A. Sebastiani Cépeda
  60. Posted by Benjamin Ramírez
    • Posted by Gustavo A. Sebastiani Cépeda
  61. Posted by Ricardo Ordoñez
    • Posted by Gustavo A. Sebastiani Cépeda
  62. Posted by bryan
    • Posted by Gustavo A. Sebastiani Cépeda
  63. Posted by JOSE
    • Posted by Gustavo A. Sebastiani Cépeda
  64. Posted by GUST
    • Posted by Gustavo A. Sebastiani Cépeda
  65. Posted by Marco Franco
    • Posted by Gustavo A. Sebastiani Cépeda
  66. Posted by Gerardo Aguilar
    • Posted by Gustavo A. Sebastiani Cépeda
  67. Posted by Roberto
    • Posted by Gustavo A. Sebastiani Cépeda
  68. Posted by Orquidea Mardones Romo
    • Posted by Gustavo A. Sebastiani Cépeda
  69. Posted by patricio martinez
    • Posted by Gustavo A. Sebastiani Cépeda
  70. Posted by anthony
    • Posted by Gustavo A. Sebastiani Cépeda
  71. Posted by jose
    • Posted by Gustavo A. Sebastiani Cépeda
  72. Posted by Jose Juarez
    • Posted by Gustavo A. Sebastiani Cépeda
  73. Posted by Evelyn herrera romero
    • Posted by Gustavo A. Sebastiani Cépeda
  74. Posted by JUAN ALBERTTO OLMOS GOMEZ
    • Posted by Gustavo A. Sebastiani Cépeda
  75. Posted by Carlos C.
    • Posted by Gustavo A. Sebastiani Cépeda
  76. Posted by Manuel Tarrillo
    • Posted by Gustavo A. Sebastiani Cépeda
  77. Posted by Daniel De la rosa
    • Posted by Gustavo A. Sebastiani Cépeda
  78. Posted by reginaldo bama
    • Posted by Gustavo A. Sebastiani Cépeda
  79. Posted by alberto
    • Posted by Gustavo A. Sebastiani Cépeda
  80. Posted by DAVID DAMIANO OLARTE
    • Posted by Gustavo A. Sebastiani Cépeda
  81. Posted by Arturo
    • Posted by Gustavo A. Sebastiani Cépeda
  82. Posted by MORANTE E: TOMÁS
    • Posted by Gustavo A. Sebastiani Cépeda
  83. Posted by Hermes Hernandez
    • Posted by Gustavo A. Sebastiani Cépeda
  84. Posted by Felix Falconi
    • Posted by Gustavo A. Sebastiani Cépeda
  85. Posted by Israel Encarnación Soto
    • Posted by Gustavo A. Sebastiani Cépeda
  86. Posted by Miguel Mejia
    • Posted by Gustavo A. Sebastiani Cépeda
  87. Posted by Leonidas Arizaca
    • Posted by Gustavo A. Sebastiani Cépeda
  88. Posted by Enrique
    • Posted by Gustavo A. Sebastiani Cépeda
  89. Posted by MIGUEL CALDERON
    • Posted by Gustavo A. Sebastiani Cépeda
  90. Posted by Edin
    • Posted by Gustavo A. Sebastiani Cépeda
  91. Posted by lucero
    • Posted by Gustavo A. Sebastiani Cépeda
  92. Posted by Armando
    • Posted by Gustavo A. Sebastiani Cépeda
  93. Posted by Milagros Salome
    • Posted by Gustavo A. Sebastiani Cépeda
  94. Posted by daniel osorio
    • Posted by Gustavo A. Sebastiani Cépeda
  95. Posted by Diego A.
    • Posted by Gustavo A. Sebastiani Cépeda
  96. Posted by dario ureña
    • Posted by Gustavo A. Sebastiani Cépeda
  97. Posted by Elmer
    • Posted by Gustavo A. Sebastiani Cépeda
  98. Posted by marcos
    • Posted by Gustavo A. Sebastiani Cépeda
  99. Posted by raul
    • Posted by Gustavo A. Sebastiani Cépeda
  100. Posted by Luis Enrique Camac
    • Posted by Gustavo A. Sebastiani Cépeda
  101. Posted by karen
    • Posted by Gustavo A. Sebastiani Cépeda
  102. Posted by Milagros Bravo
    • Posted by Gustavo A. Sebastiani Cépeda
  103. Posted by Milagros Bravo
    • Posted by Gustavo A. Sebastiani Cépeda
  104. Posted by roberto tarrillo blas
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by liliana
  105. Posted by francisco vilca
    • Posted by Gustavo A. Sebastiani Cépeda
  106. Posted by Cesar
    • Posted by Gustavo A. Sebastiani Cépeda
  107. Posted by Nestor
    • Posted by Gustavo A. Sebastiani Cépeda
  108. Posted by Juan Apaza Huayta
  109. Posted by julio rojas
    • Posted by Gustavo A. Sebastiani Cépeda
  110. Posted by RAFAEL JARRIN ATUNCAR
    • Posted by Gustavo A. Sebastiani Cépeda
  111. Posted by Jesus
    • Posted by Gustavo A. Sebastiani Cépeda
  112. Posted by Juan Carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  113. Posted by JUAN CARLOS
    • Posted by Gustavo A. Sebastiani Cépeda
  114. Posted by edson paolo donayre lopez
    • Posted by Gustavo A. Sebastiani Cépeda
  115. Posted by rosario acosta
    • Posted by Gustavo A. Sebastiani Cépeda
  116. Posted by NILTON BAZALAR
  117. Posted by manuel
    • Posted by Gustavo A. Sebastiani Cépeda
  118. Posted by Andres
    • Posted by Gustavo A. Sebastiani Cépeda
  119. Posted by Franco
    • Posted by Gustavo A. Sebastiani Cépeda
  120. Posted by julieta vale
    • Posted by Gustavo A. Sebastiani Cépeda
  121. Posted by julieta vale
    • Posted by Gustavo A. Sebastiani Cépeda
  122. Posted by manuel martinez
    • Posted by Gustavo A. Sebastiani Cépeda
    • Posted by raziel
      • Posted by Gustavo A. Sebastiani Cépeda
  123. Posted by Gilbert Cortez
    • Posted by Gustavo A. Sebastiani Cépeda
  124. Posted by ANTONIO GOMEZ
    • Posted by Gustavo A. Sebastiani Cépeda
  125. Posted by Henry Cayo
    • Posted by Gustavo A. Sebastiani Cépeda
  126. Posted by Juan Carlos
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Saul
        • Posted by Gustavo A. Sebastiani Cépeda
  127. Posted by Haydee
    • Posted by Gustavo A. Sebastiani Cépeda
  128. Posted by Mara
    • Posted by Gustavo A. Sebastiani Cépeda
  129. Posted by CHRISTIAN
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by CHRISTIAN
  130. Posted by daniel martinez
    • Posted by Gustavo A. Sebastiani Cépeda
  131. Posted by Luciano
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by dofre lopez subia
      • Posted by CRISTHIAN VASQUEZ ZELA
        • Posted by Gustavo A. Sebastiani Cépeda
  132. Posted by Julian Flores Morales
    • Posted by Gustavo A. Sebastiani Cépeda
  133. Posted by Carlos Li
    • Posted by Gustavo A. Sebastiani Cépeda
  134. Posted by INGRID
    • Posted by Gustavo A. Sebastiani Cépeda
  135. Posted by Alberto Arredondo
    • Posted by Gustavo A. Sebastiani Cépeda
  136. Posted by José Fernández
    • Posted by Gustavo A. Sebastiani Cépeda
  137. Posted by MARBIEL SANCHEZ ALVAREZ
    • Posted by Gustavo A. Sebastiani Cépeda
  138. Posted by erick Litano
    • Posted by Gustavo A. Sebastiani Cépeda
  139. Posted by Patricia Utia
    • Posted by Gustavo A. Sebastiani Cépeda
  140. Posted by ronald huere arias
    • Posted by Gustavo A. Sebastiani Cépeda
  141. Posted by Rolando
    • Posted by Gustavo A. Sebastiani Cépeda
  142. Posted by Raúl
    • Posted by Gustavo A. Sebastiani Cépeda
  143. Posted by Rafael Paima
    • Posted by Gustavo A. Sebastiani Cépeda
  144. Posted by Christian
  145. Posted by Rolando Alfaro
    • Posted by Gustavo A. Sebastiani Cépeda
  146. Posted by angel gonzales
    • Posted by Gustavo A. Sebastiani Cépeda
  147. Posted by Juan Carlos fernandez
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by Pablo
        • Posted by Gustavo A. Sebastiani Cépeda
  148. Posted by Joan
    • Posted by Gustavo A. Sebastiani Cépeda
  149. Posted by maria zapata portal
    • Posted by Gustavo A. Sebastiani Cépeda
  150. Posted by rolando
    • Posted by Gustavo A. Sebastiani Cépeda
  151. Posted by LEONEL GONZALEZ
    • Posted by Gustavo A. Sebastiani Cépeda
  152. Posted by Yudixa
    • Posted by Gustavo A. Sebastiani Cépeda
  153. Posted by Yudixa
    • Posted by Gustavo A. Sebastiani Cépeda
  154. Posted by Consuelo Perez
    • Posted by Gustavo A. Sebastiani Cépeda
  155. Posted by eduardo
    • Posted by Gustavo A. Sebastiani Cépeda
  156. Posted by carlos hernan Alzate
  157. Posted by Carlos sanchez
    • Posted by Gustavo A. Sebastiani Cépeda
  158. Posted by Roberto
    • Posted by Gustavo A. Sebastiani Cépeda
  159. Posted by ABEL MOSTACERO
  160. Posted by ARIEL
    • Posted by Gustavo A. Sebastiani Cépeda
  161. Posted by ARIEL
  162. Posted by ABELARDO HERENCIA Q.
    • Posted by Gustavo A. Sebastiani Cépeda
  163. Posted by BISMAR CHACON SANIZO
    • Posted by Gustavo A. Sebastiani Cépeda
  164. Posted by diego gonzalez
    • Posted by Gustavo A. Sebastiani Cépeda
  165. Posted by luis Nuñes
  166. Posted by Victor Contreras
    • Posted by Gustavo A. Sebastiani Cépeda
  167. Posted by Sergio Gonzalez
  168. Posted by gustavo garcia
  169. Posted by ANDRES MAURICIO HERNANDEZ VALLEJO
    • Posted by Gustavo A. Sebastiani Cépeda
  170. Posted by Hector Huamani Machaca
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by ANA TERRONES
        • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by ANA TERRONES
        • Posted by Gustavo A. Sebastiani Cépeda
  171. Posted by Hector Huamani
  172. Posted by Jesús Alberto Yépez Estrada
  173. Posted by Arnaldo
    • Posted by Gustavo A. Sebastiani Cépeda
  174. Posted by omar
    • Posted by Gustavo A. Sebastiani Cépeda
  175. Posted by Jesús Alberto Yépez Estrada
    • Posted by Gustavo A. Sebastiani Cépeda
  176. Posted by jesus
    • Posted by Gustavo A. Sebastiani Cépeda
      • Posted by ANA TERRONES
        • Posted by Gustavo A. Sebastiani Cépeda
  177. Posted by Roberto Pajuelo
    • Posted by Gustavo A. Sebastiani Cépeda
  178. Posted by juan carlos
    • Posted by Gustavo A. Sebastiani Cépeda
  179. Posted by Andres
  180. Posted by CECILIA CASTRO
  181. Posted by luis j. galue
    • Posted by Gustavo A. Sebastiani Cépeda
  182. Posted by esteban ariel quiroga
    • Posted by Gustavo A. Sebastiani Cépeda
  183. Posted by Sebastian
    • Posted by Gustavo A. Sebastiani Cépeda
  184. Posted by luis ochoa
    • Posted by Gustavo A. Sebastiani Cépeda
  185. Posted by Maria Garcia de Visconti
  186. Posted by arnulfo pabon prada
  187. Posted by Ignacio
  188. Posted by Romell
  189. Posted by carlos flores
  190. Posted by Alejandro Gutierrez
  191. Posted by mariela
  192. Posted by Wilfre
    • Posted by Gustavo A. Sebastiani Cépeda
  193. Posted by Mario Domingo Choquehuanca
  194. Posted by yessica
  195. Posted by david
  196. Posted by Betty
  197. Posted by alexander
  198. Posted by alexander
  199. Posted by Dover Blake
  200. Posted by Manuel Espinal
  201. Posted by ROSANA BANCHIO
  202. Posted by Ramon
    • Posted by Felipe
  203. Posted by Vanessa
  204. Posted by oswaldo
  205. Posted by José Manuel Romero Cumo
  206. Posted by Arturo
  207. Posted by ADRIAN
  208. Posted by ELMER
  209. Posted by Jose Carlos Mendoza
  210. Posted by Carlos Saez
  211. Posted by Carlos Saez
  212. Posted by Carlos Sáez
  213. Posted by harold gaona
  214. Posted by harold gaona
  215. Posted by Pedro Achio
  216. Posted by Carlos
  217. Posted by CALEP BERNAL
  218. Posted by Bet
  219. Posted by grimaldo juep sanchez
  220. Posted by jaime
  221. Posted by Pedro
  222. Posted by luis Enrique
  223. Posted by Luis manuel
  224. Posted by Danielc
  225. Posted by PAOLA
  226. Posted by VICTOR
  227. Posted by WILBERTH
  228. Posted by henry
    • Posted by ALFONSO GERARDO GRANADOS INURRIGARRO
  229. Posted by RAUL
    • Posted by Angel Figueroa
      • Posted by Gustavo A. Sebastiani Cépeda
        • Posted by juan carlos
          • Posted by Gustavo A. Sebastiani Cépeda