/doc/users/

Default-chart.sql'>
path: root/sql/Venezuela_Default-chart.sql
blob: 7232085e4837cc09ac5a0dd3cffb514e835d1907 (plain) 
    

  1. -- Venezuela General COA
    2. 

  2. -- modify as needed
    3. 

  3. --
    4. 

  4. 

  5. -- ACTIVO
    6. 

  6. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','ACTIVO','H','','A','');
    7. 

  7. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1050','Caja','A','','A','AR_paid:AP_paid');
    8. 

  8. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1100','Banesco APD','A','','A','AR_paid:AP_paid');
    9. 

  9. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1110','Provincial','A','','A','AR_paid:AP_paid');
    10. 

  10. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1120','Venezuela','A','','A','AR_paid:AP_paid');
    11. 

  11. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1130','Banesco JD','A','','A','AR_paid:AP_paid');
    12. 

  12. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','Cuentas por Cobrar','A','','A','AR');
    13. 

  13. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1205','Provisión Cuentas Incobrables','A','','A','');
    14. 

  14. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','INVENTARIO','H','','A','');
    15. 

  15. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','Mercancía en Almacén','A','','A','IC');
    16. 

  16. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','Mercancía en Consignación','A','','A','IC');
    17. 

  17. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','ACTIVOS CAPITALES','H','','A','');
    18. 

  18. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','Mobiliario y Equipo','A','','A','');
    19. 

  19. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1825','Amort. Acum. -Inv. y Equip.','A','','A','');
    20. 

  20. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840','Vehículo','A','','A','');
    21. 

  21. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1845','Amort. Acum. -Vehículo','A','','A','');
    22. 

  22. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1850','Edificio','A','','A','');
    23. 

  23. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1855','Amort. Acum. -Edificio','A','','A','');
    24. 

  24. -- PASIVO
    25. 

  25. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','PASIVO CORTO PLAZO','H','','L','');
    26. 

  26. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','Cuentas por Pagar','A','','L','AP');
    27. 

  27. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','PASIVO LARGO PLAZO','H','','L','');
    28. 

  28. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','Préstamos Bancarios','A','','L','');
    29. 

  29. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2680','Préstamos de Accionistas','A','','L','AP_paid');
    30. 

  30. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2700','APARTADOS','H','','L','');
    31. 

  31. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2710','Apartados Indem. Laborales','A','','L','');
    32. 

  32. -- CAPITAL
    33. 

  33. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','CAPITAL ACCIONARIO','H','','Q','');
    34. 

  34. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','Acciones Comunes','A','','Q','');
    35. 

  35. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3400','RESERVAS','H','','Q','');
    36. 

  36. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3410','Reserva Legal','A','','Q','');
    37. 

  37. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3420','Reserva Voluntaria','A','','Q','');
    38. 

  38. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','UTILIDADES RETENIDAS','H','','Q','');
    39. 

  39. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3590','Utilidades Retenidas - años anteriores','A','','Q','');
    40. 

  40. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3600','Ganancia del Ejercicio','A','','Q','');
    41. 

  41. -- INGRESO
    42. 

  42. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','INGRESOS PRINCIPALES','H','','I','');
    43. 

  43. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','Ventas Autopartes','A','','I','AR_amount:IC_sale');
    44. 

  44. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','OTROS INGRESOS','H','','I','');
    45. 

  45. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4430','Shipping & Handling','A','','I','IC_income');
    46. 

  46. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4440','Intereses','A','','I','');
    47. 

  47. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4450','Ganancia en Paridad Cambiaria','A','','I','');
    48. 

  48. -- EGRESO
    49. 

  49. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','COSTO DE VENTA','H','','E','');
    50. 

  50. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','Compras','A','','E','AP_amount:IC_cogs:IC_expense');
    51. 

  51. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','COSTO DE VENTA: Autopartes','A','','E','AP_amount:IC_cogs');
    52. 

  52. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','Flete','A','','E','AP_amount:IC_expense');
    53. 

  53. -- HR
    54. 

  54. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','GASTO DE PERSONAL','H','','E','');
    55. 

  55. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5405','Sueldos Directivo y Administradores','A','','E','HR_expense');
    56. 

  56. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','Sueldos Empleados','A','','E','HR_expense');
    57. 

  57. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5415','Comisiones Vendedores','A','','E','HR_expense');
    58. 

  58. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420','Vacaciones','A','','E','HR_expense');
    59. 

  59. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5425','Bono Vacacional','A','','E','HR_expense');
    60. 

  60. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5430','Utilidades','A','','E','HR_expense');
    61. 

  61. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5435','Indemnizaciones','A','','E','HR_expense');
    62. 

  62. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5440','Movilizaciones y Traslados','A','','E','HR_expense');
    63. 

  63. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5445','Gastos de Representación','A','','E','HR_expense');
    64. 

  64. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5450','Instrucción y Mejoramiento','A','','E','HR_expense');
    65. 

  65. 

  66. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','GASTOS GENERALES','H','','E','');