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

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

Publicidad

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.

Publicidad

Agrega tu comentario

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