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

ingreso de nuevo producto al control de almacen

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