{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Documentatie","Inventar","NotaInventar","PuVanzRamane","AdaosRamane"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Documentatie","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"HAMOR Soft SRL",null,null,null,"31/07/2025"]
[null,null,null,"www.hamorsoft.ro"]
[]
[null,null,null,"Excel pentru"]
[null,null,null,"stabilire note contabile diferente de inventar scriptic-faptiv."]
[null,null,null,"modificare cote TVA si pret si note contabile aferente daca:"]
[null,null,null,"  -pret vanzare ramane fix si recalculeaza adaosul si pretul de livrare sau"]
[null,null,null,"  -adaosul ramane fix si se recalculeaza TVA neexigibil si pretul de vanzare"]
[]
[null,null,null,"Pret livrare = pret achizitie + adaos"]
[null,null,null,"Pret vanzare = pret livrare + valoare TVA"]
[]
[null,null,null,"Operare:"]
[null,null,null,null,"1. Inventarul faptic fie se introduce in sheetul \"Inventar\","]
[null,null,null,null,null,"fie se importa un excel similar cu butonul \"Import Inventar din alt excel\""]
[null,null,null,null,"2. Diferentele de Inventar scriptic si faptic se calculeaza in sheetul \"NotaInventar\""]
[null,null,null,null,null,"Soldurile 371, 378, 4428 se inscriu in celulele respective"]
[null,null,null,null,null,"Pentru calcul, se utilizeaza butonul \"Preluare din Inventar\""]
[null,null,null,null,null,"Se poate utiliza in cazul oricarui inventar faptic, nu numai la modificare TVA."]
[null,null,null,null,"3. Pentru a recalcula TVA si preturile, dupa trecerea la cote de TVA 11% si 21%:"]
[null,null,null,null,null,"Se verifica/suprascriu cotele TVA noi,"]
[null,null,null,null,null,"Daca se pastreaza pretul de vanzare, se utilizeaza \"PuVanzRamane\""]
[null,null,null,null,null,"Daca se pastreaza adaosul, se utilizeaza \"AdaosRamane\""]
[]
[null,null,null,"Observatie: "]
[null,null,null,null,"Pentru deblocare Excel dupa descarcare:"]
[null,null,null,null,null,"Click dr, Properties, Unlock"]
[null,null,null,null,null,"Enable Content"]
[null,null,null,null,"Daca apare avertizarea ActiveX content in this file is blocked:"]
[null,null,null,null,null,"File, Options, Trust Center, Trust Center Settings , ActiveX settings, Prompt me before enabling  all controls   with  minimal restrictions "]

{"sheet":"Inventar","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,6]]}
["ABC SRL/MA1",null,null,null,null,"Data","31/07/2025"]
["Note contabile de corectie inventar"]
[]
["Nr.crt","Denumire","UM","Stoc","Cota TVA","PU Vanzare","Val.vanzare"]
[1,"Produs 0/0","BUC",10,0,20,{"$f":"ROUND(F5*D5,2)","v":200}]
[2,"Produs 0/11","BUC",10,0,20,200]
[3,"Produs 5/11","BUC",10,5,21,210]
[4,"Produs 5/21","BUC",10,5,21,210]
[5,"Produs 9/11","KG",10,9,22,220]
[6,"Produs 9/21","KG",10,9,22,220]
[7,"Produs 19/21","KG",10,19,24,240]
[null,"TOTAL",null,null,null,null,{"$f":"SUM(G5:G11)","v":1500}]

{"sheet":"NotaInventar","index":2,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,0,31,3],[32,0,32,3],[33,0,33,3],[34,0,34,3],[35,0,35,3],[29,0,29,3],[30,0,30,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[24,0,24,3],[25,0,25,3],[1,0,1,10],[0,0,0,4],[27,0,27,3],[19,0,19,3],[28,0,28,3],[15,0,15,3],[16,0,16,3],[18,0,18,3],[20,0,20,3],[17,0,17,3]]}
["ABC SRL/MA1",null,null,null,null,"Data","31/07/2025"]
["Inventar si note contabile de corectie"]
[]
["Nr.crt","Denumire","UM","Stoc","Cota TVA","PU Vanzare","Val.vanzare","Pu livrare","Val.livrare","Pu TVA","Val. TVA"]
[1,"Produs 0/0","BUC",10,0,20,{"$f":"ROUND(F5*D5,2)","v":200},{"$f":"ROUND(F5*100/(100+E5), 2)","v":20},{"$f":"ROUND(G5-K5, 2)","v":200},{"$f":"ROUND(F5*E5/(100+E5), 2)","v":0},{"$f":"ROUND(J5*D5, 2)","v":0}]
[2,"Produs 0/11","BUC",10,0,20,200,20,200,0,0]
[3,"Produs 5/11","BUC",10,5,21,210,20,200,1,10]
[4,"Produs 5/21","BUC",10,5,21,210,20,200,1,10]
[5,"Produs 9/11","KG",10,9,22,220,20.18,201.8,1.82,18.2]
[6,"Produs 9/21","KG",10,9,22,{"$f":"ROUND(F10*D10,2)","v":220},{"$f":"ROUND(F10*100/(100+E10), 2)","v":20.18},{"$f":"ROUND(G10-K10, 2)","v":201.8},{"$f":"ROUND(F10*E10/(100+E10), 2)","v":1.82},{"$f":"ROUND(J10*D10, 2)","v":18.2}]
[7,"Produs 19/21","KG",10,19,24,{"$f":"ROUND(F11*D11,2)","v":240},{"$f":"ROUND(F11*100/(100+E11), 2)","v":20.170000000000002},{"$f":"ROUND(G11-K11, 2)","v":201.7},{"$f":"ROUND(F11*E11/(100+E11), 2)","v":3.83},{"$f":"ROUND(J11*D11, 2)","v":38.299999999999997}]
[null,"TOTAL",null,null,null,null,{"$f":"SUM(G5:G11)","v":1500},null,{"$f":"ROUND(SUM(I5:I11), 2)","v":1405.3},null,{"$f":"ROUND(SUM(K5:K11), 2)","v":94.7}]
[]
[]
["Calcule"]
[]
["Denumire",null,null,null,"Cont","Val.veche\ndin hCONT","Val.noua\ndin inventar","Diferenta"]
["Val.vanzare 0%",null,null,null,null,null,{"$f":"SUMIF(E5:E11,0,G5:G11)","v":400}]
["Val.vanzare 5%",null,null,null,null,null,{"$f":"SUMIF(E5:E11,5,G5:G11)","v":420}]
["Val.vanzare 9%",null,null,null,null,null,{"$f":"SUMIF(E5:E11,9,G5:G11)","v":440}]
["Val.vanzare 19%",null,null,null,null,null,{"$f":"SUMIF(E5:E11,19,G5:G11)","v":240},null,"%"]
["Total val. vanzare",null,null,null,"371.2",6000,{"$f":"SUM(G18:G21)","v":1500},{"$f":"G22-F22","v":-4500},{"$f":"H22/F22","v":-0.75}]
["TVA 5%",null,null,null,null,null,{"$f":"SUMIF(E5:E11,5,K5:K11)","v":20}]
["TVA9%",null,null,null,null,null,{"$f":"SUMIF(E5:E11,9,K5:K11)","v":36.4}]
["TVA19%",null,null,null,null,null,{"$f":"SUMIF(E5:E11,19,K5:K11)","v":38.299999999999997}]
["Total TVA",null,null,null,"4428",950,{"$f":"SUM(G23:G25)","v":94.699999999999989},{"$f":"G26-F26","v":-855.3}]
["Val. livrare 0%",null,null,null,null,"",{"$f":"SUMIF(E5:E11,0,I5:I11)","v":400}]
["Val.livrare 5%",null,null,null,null,null,{"$f":"SUMIF(E5:E11,5,I5:I11)","v":400}]
["Val.livrare 9%",null,null,null,null,null,{"$f":"SUMIF(E5:E11,9,I5:I11)","v":403.6}]
["Val.livrare 19%",null,null,null,null,null,{"$f":"SUMIF(E5:E11,19,I5:I11)","v":201.7}]
["Total val.livrare",null,null,null,null,{"$f":"F22-F26","v":5050},{"$f":"SUM(G27:G30)","v":1405.3},{"$f":"G31-F31","v":-3644.7}]
["Adaos",null,null,null,"378.2",550,{"$f":"ROUND(F34*G31,2)","v":153.05000000000001},{"$f":"G32-F32","v":-396.95},"Verificare"]
["Val.achizitie",null,null,null,null,{"$f":"F22-F26-F32","v":4500},{"$f":"ROUND(F35*G31,2)","v":1252.25},{"$f":"G33-F33","v":-3247.75},{"$f":"H22-H26-H32","v":-3247.75}]
["% adaos",null,null,null,null,{"$f":"F32/F31","v":0.10891089108910891}]
["% val.achiztie",null,null,null,null,{"$f":"F33/F31","v":0.8910891089108911}]
[]
["Nota contabila la 31/07/2025"]
["Dif. val.achizitie",null,null,null,"6…","=","371.2",{"$f":"-H33","v":3247.75}]
["Dif.TVA",null,null,null,"4428","=","371.2",{"$f":"-H26","v":855.3}]
["Dif.adaos",null,null,null,"378.2","=","371.2",{"$f":"-H32","v":396.95}]
["Dif.val vanzare",null,null,null,"Verificare",null,null,{"$f":"SUM(H38:H40)","v":4500}]

{"sheet":"PuVanzRamane","index":3,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,18],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,2,10],[2,11,2,18]]}
["ABC SRL/MA1",null,null,null,null,"Data","01/08/2025"]
["Recalculare cote TVA la 11,21 % si preturi, adaosuri (pret vanzare nu se modifica)"]
["Nr.crt","Denumire","UM","Stoc","ELEMENTE DE PRET VECHI",null,null,null,null,null,null,"ELEMENTE DE PRET NOU"]
[null,null,null,null,"Cota TVA","PuVanzare","Val.vanzare","PUlivrare","Val.livrare","PuTVA","Val. TVA","Cota TVA","PuVanzare","Val.vanzare","PuTVA","Val.TVA","PUlivrare","Val.livrare","Dif.adaos"]
[1,"Produs 0/0","BUC",10,0,20,{"$f":"ROUND(F5*D5, 2)","v":200},{"$f":"ROUND(F5*E5/(100+E5), 2)","v":0},{"$f":"ROUND(G5-K5, 2)","v":200},{"$f":"ROUND(F5*E5/(100+E5), 2)","v":0},{"$f":"ROUND(J5*D5, 2)","v":0},{"$f":"IF(E5=0,0,IF(E5=5,11,IF(E5=9,11,IF(E5=19,21,0))))","v":0},{"$f":"F5","v":20},{"$f":"ROUND(M5*D5, 2)","v":200},{"$f":"ROUND(M5*L5/(100+L5), 2)","v":0},{"$f":"ROUND(O5*D5, 2)","v":0},{"$f":"ROUND(M5-O5, 2)","v":20},{"$f":"ROUND(N5-P5, 2)","v":200},{"$f":"ROUND(G5-P5-I5, 2)","v":0}]
[2,"Produs 0/11","BUC",10,0,20,200,0,200,0,0,0,20,200,0,0,20,200,0]
[3,"Produs 5/11","BUC",10,5,21,210,1,200,1,10,11,21,210,2.08,20.8,18.920000000000002,189.2,-10.8]
[4,"Produs 5/21","BUC",10,5,21,210,1,200,1,10,11,21,210,2.08,20.8,18.920000000000002,189.2,-10.8]
[5,"Produs 9/11","KG",10,9,22,220,1.82,201.8,1.82,18.2,11,22,220,2.1800000000000002,21.8,19.82,198.2,-3.6]
[6,"Produs 9/21","KG",10,9,22,{"$f":"ROUND(F10*D10, 2)","v":220},{"$f":"ROUND(F10*E10/(100+E10), 2)","v":1.82},{"$f":"ROUND(G10-K10, 2)","v":201.8},{"$f":"ROUND(F10*E10/(100+E10), 2)","v":1.82},{"$f":"ROUND(J10*D10, 2)","v":18.2},{"$f":"IF(E10=0,0,IF(E10=5,11,IF(E10=9,11,IF(E10=19,21,0))))","v":11},{"$f":"F10","v":22},{"$f":"ROUND(M10*D10, 2)","v":220},{"$f":"ROUND(M10*L10/(100+L10), 2)","v":2.1800000000000002},{"$f":"ROUND(O10*D10, 2)","v":21.8},{"$f":"ROUND(M10-O10, 2)","v":19.82},{"$f":"ROUND(N10-P10, 2)","v":198.2},{"$f":"ROUND(G10-P10-I10, 2)","v":-3.6}]
[7,"Produs 19/21","KG",10,19,24,{"$f":"ROUND(F11*D11, 2)","v":240},{"$f":"ROUND(F11*E11/(100+E11), 2)","v":3.83},{"$f":"ROUND(G11-K11, 2)","v":201.7},{"$f":"ROUND(F11*E11/(100+E11), 2)","v":3.83},{"$f":"ROUND(J11*D11, 2)","v":38.299999999999997},{"$f":"IF(E11=0,0,IF(E11=5,11,IF(E11=9,11,IF(E11=19,21,0))))","v":21},{"$f":"F11","v":24},{"$f":"ROUND(M11*D11, 2)","v":240},{"$f":"ROUND(M11*L11/(100+L11), 2)","v":4.17},{"$f":"ROUND(O11*D11, 2)","v":41.7},{"$f":"ROUND(M11-O11, 2)","v":19.829999999999998},{"$f":"ROUND(N11-P11, 2)","v":198.3},{"$f":"ROUND(G11-P11-I11, 2)","v":-3.4}]
[null,"TOTAL",null,null,null,null,{"$f":"ROUND(SUM(G5:G11), 2)","v":1500},null,{"$f":"ROUND(SUM(I5:I11), 2)","v":1405.3},null,{"$f":"ROUND(SUM(K5:K11), 2)","v":94.7},null,null,{"$f":"ROUND(SUM(N5:N11), 2)","v":1500},null,{"$f":"ROUND(SUM(P5:P11), 2)","v":126.9},null,{"$f":"ROUND(SUM(R5:R11), 2)","v":1373.1},{"$f":"ROUND(SUM(S5:S11), 2)","v":-32.200000000000003}]
[]
[]
[]
[null,"Nota contabila  la 01/08/2025"]
[null,null,null,null,"378.2","=","371.2",null,{"$f":"-S12","v":32.200000000000003}]
[null,null,null,null,"371.2","=","4428",null,{"$f":"P12-K12","v":32.200000000000003}]

{"sheet":"AdaosRamane","index":4,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,17],[2,4,2,10],[2,11,2,17],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3]]}
["ABC SRL/MA1",null,null,null,null,"Data","01/08/2025"]
["Recalculre TVA la 11, 21% si pret vanzare pe baza de inventar faptic (se pastreaza adaosul existent)"]
["Nr.crt","Denumire","UM","Stoc","ELEMENTE DE PRET VECHI",null,null,null,null,null,null,"ELEMENTE DE PRET NOU"]
[null,null,null,null,"Cota TVA","PU vanzare","Val. vanzare","PU livrare","Val. livrare","PU TVA","Val. TVA","Cota TVA","PU vanzare","Val. vanzare","PU livrare ","Val. livrare","PU TVA","Val. TVA"]
[1,"Produs 0/0","BUC",10,0,20,{"$f":"ROUND(F5*D5,2)","v":200},{"$f":"ROUND(F5/(1+E5/100),2)","v":20},{"$f":"H5*D5","v":200},{"$f":"F5-H5","v":0},{"$f":"ROUND(G5-I5,2)","v":0},{"$f":"IF(E5=0,0,IF(E5=5,11,IF(E5=9,11,IF(E5=19,21,0))))","v":0},{"$f":"ROUND(H5*(1+L5/100),2)","v":20},{"$f":"ROUND(M5*D5,2)","v":200},{"$f":"ROUND(H5,2)","v":20},{"$f":"ROUND(O5*D5,2)","v":200},{"$f":"ROUND(M5-O5,2)","v":0},{"$f":"ROUND(N5-P5,2)","v":0}]
[2,"Produs 0/11","BUC",10,0,20,200,20,200,0,0,0,20,200,20,200,0,0]
[3,"Produs 5/11","BUC",10,5,21,210,20,200,1,10,11,22.2,222,20,200,2.2000000000000002,22]
[4,"Produs 5/21","BUC",10,5,21,210,20,200,1,10,11,22.2,222,20,200,2.2000000000000002,22]
[5,"Produs 9/11","KG",10,9,22,220,20.18,201.8,1.8200000000000003,18.2,11,22.4,224,20.18,201.8,2.2200000000000002,22.2]
[6,"Produs 9/21","KG",10,9,22,220,20.18,201.8,1.8200000000000003,18.2,11,22.4,224,20.18,201.8,2.2200000000000002,22.2]
[7,"Produs 19/21","KG",10,19,24,{"$f":"ROUND(F11*D11,2)","v":240},{"$f":"ROUND(F11/(1+E11/100),2)","v":20.170000000000002},{"$f":"H11*D11","v":201.70000000000002},{"$f":"F11-H11","v":3.8299999999999983},{"$f":"ROUND(G11-I11,2)","v":38.299999999999997},{"$f":"IF(E11=0,0,IF(E11=5,11,IF(E11=9,11,IF(E11=19,21,0))))","v":21},{"$f":"ROUND(H11*(1+L11/100),2)","v":24.41},{"$f":"ROUND(M11*D11,2)","v":244.1},{"$f":"ROUND(H11,2)","v":20.170000000000002},{"$f":"ROUND(O11*D11,2)","v":201.7},{"$f":"ROUND(M11-O11,2)","v":4.24},42.4]
[null,"TOTAL",null,null,null,null,{"$f":"SUM(G5:G11)","v":1500},null,{"$f":"SUM(I5:I11)","v":1405.3},null,{"$f":"SUM(K5:K11)","v":94.7},null,null,{"$f":"SUM(N5:N11)","v":1536.1},null,{"$f":"SUM(P5:P11)","v":1405.3},null,{"$f":"SUM(R5:R11)","v":130.80000000000001}]
[]
[]
[]
[]
["Nota contabila  la 01/08/2025"]
["Diferenta TVA",null,null,null,"371.2","=","4428",{"$f":"R12-K12","v":36.100000000000009}]
["Total vanzare vechi",null,null,null,null,null,null,{"$f":"G12","v":1500}]
["Crestere TVA",null,null,null,null,null,null,{"$f":"H18","v":36.100000000000009}]
["Total vanzare nou",null,null,null,null,null,null,{"$f":"N12","v":1536.1}]