{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5","Sheet8","Sheet6","Sheet9"],"not_rendered":{"charts":0,"images":0,"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":"Sheet1","index":0,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,3,2,4],[13,6,13,10],[3,2,3,15],[4,2,4,15],[5,2,5,15],[6,2,6,15],[11,3,11,7]]}
[]
[]
[null,null,null,"كاربر گرامي"]
[null,null,"جهت ورود اطلاعات صورت مغايرت بانكي در جدول مربوطه ، اطلاعات خواسته شده را تكميل نموده و سپس با كليك بر روي جمله صورت مغايرت بانكي"]
[null,null,"به صفحه  مربوطه  وارد شده و با كليك بر روي هر كدام  از گزينه ها ،  وارد جدول مربوطه  شده و  با تكميل جداول مربوطه ، اطلاعات خروجي به جدول "]
[null,null,"صورت مغايرت بانكي انتقال مي يابد و در نهايت با كليك بر روي جمله صورت مغايرت بانكي در هر يك از جداول ضميمه وارد جدول صورت مغايرت بانكي "]
[null,null,"شده و با توجه به تكميل شده جدول و موجودي واقعي آماده چاپ مي باشد ."]
[]
[]
[]
[]
[null,null,null,"جهت ورود به جدول صورت مغايرت بانكي",null,null,null,null,"كليك","كنيد"]
[]
[null,null,null,null,null,null,"d_arabdoost@yahoo.com"]

{"sheet":"Sheet2","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,2,2,12],[5,2,5,7],[4,2,4,7],[4,8,4,12],[5,8,5,12],[3,2,3,12],[6,2,6,7],[12,2,12,7],[12,8,12,10],[12,11,12,12],[13,1,13,13],[8,7,9,12],[8,2,9,6],[7,2,7,7],[10,2,10,7],[10,11,10,12],[10,8,10,10],[6,8,6,12],[7,8,7,12]]}
[]
[]
[null,null,"ورودي اطلاعات صورت مغايرت بانكي"]
[null,null,"كاربر گرامي اطلاعات اوليه ورودي را در اين قسمت وارد نماييد"]
[null,null,"نام شركت",null,null,null,null,null,"نمونه"]
[null,null,"نام و شماره حساب جاري",null,null,null,null,null,1]
[null,null,"مانده موجودي بانك در دفاتر شركت",null,null,null,null,null,1]
[null,null,"مانده موجودي بانك در صورتحساب بانكي",null,null,null,null,null,1]
[null,null,"تاريخ امروز",null,null,null,null,{"$f":"J_TODAY()","v":"95/08/10"}]
[]
[null,null,"جهت ورود به راهنماي كاركرد صورت مغايرت بانكي",null,null,null,null,null,"كليك",null,null,"كنيد"]
[]
[null,null,"جهت ورود به جدول صورت مغايرت بانكي",null,null,null,null,null,"كليك",null,null,"كنيد"]
[null,"d_arabdoost@yahoo.com"]

{"sheet":"Sheet3","index":2,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,4,2,9],[6,4,6,5],[9,8,9,9],[4,9,4,10],[3,9,3,11],[5,8,5,9],[6,8,6,9],[7,8,7,9],[5,3,5,6],[7,3,7,7],[9,3,9,7],[7,10,7,12],[8,4,8,5],[2,10,2,14],[10,14,10,16],[5,10,5,12],[8,8,8,9],[6,14,6,16],[8,14,8,16],[5,14,5,15],[7,14,7,15],[9,14,9,15],[9,10,9,13],[6,10,6,12],[8,10,8,12],[14,13,14,14],[15,13,15,14],[11,8,11,9],[12,9,13,11],[12,6,13,8],[11,14,11,15],[15,4,15,10],[14,4,14,10],[17,7,17,11],[10,8,10,9],[10,3,10,6],[20,4,20,6],[20,11,20,12],[18,7,18,10]]}
[]
[]
[null,null,null,null,"صورت مغايرت بانكي حساب جاري",null,null,null,null,null,{"$f":"Sheet2!I6","v":1}]
[null,null,null,null,null,null,null,null,"شركت",{"$f":"Sheet2!I5","v":"نمونه"}]
[null,null,null,null,null,null,null,null,"تاريخ",{"$f":"Sheet2!H9","v":"95/08/10"}]
[null,null,null,"مانده بانك طبق دفاتر موسسه",null,null,null,null,{"$f":"Sheet2!I7","v":1},null,"مانده طبق صورتحساب بانك",null,null,null,{"$f":"Sheet2!I8","v":1}]
[null,null,null,null,"اضافه مي شود:",null,null,null,null,null,"اضافه مي شود:"]
[null,null,null,"جمع وجوه واريزي كه در دفاتر ثبت نشده",null,null,null,null,{"$f":"Sheet4!L18","v":0},null,"جمع سپرده بين راهي",null,null,null,{"$f":"Sheet8!L18","v":0}]
[null,null,null,null,"كسر ميشود:",null,null,null,null,null,"كسر مي شود:"]
[null,null,null,"جمع كارمزد و ساير هزينه ها",null,null,null,null,{"$f":"Sheet5!L17","v":0},null,"جمع چك هاي وصول نشده",null,null,null,{"$f":"Sheet9!L18","v":0}]
[null,null,null,"جمع برداشت هاي ثبت نشده",null,null,null,null,{"$f":"Sheet6!L17","v":0}]
[null,null,null,"مانده واقعي",null,null,null,null,{"$f":"(I6+I8)+(I10+I11)","v":1},null,"مانده واقعي",null,null,null,{"$f":"(O6+O8)-O10","v":1}]
[null,null,null,null,null,null,"اختلاف تراز",null,null,{"$f":"I12-O12","v":0}]
[]
[null,null,null,null,"جهت ورود به راهنماي كاركرد صورت مغايرت بانكي",null,null,null,null,null,null,"كليك",null,"كنيد"]
[null,null,null,null,"جهت ورود به جدول ورود اطلاعات صورت مغايرت بانكي",null,null,null,null,null,null,"كليك",null,"كنيد"]
[]
[]
[null,null,null,null,null,null,null,"d_arabdoost@yahoo.com"]
[]
[null,null,null,null,"تنظیم کننده",null,null,null,null,null,null,"کنترل کننده"]

{"sheet":"Sheet4","index":3,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,12,16,12],[2,8,2,9],[2,4,2,7],[6,9,6,10],[7,9,7,10],[8,9,8,10],[4,4,4,7],[4,8,4,10],[6,4,6,8],[20,9,20,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[19,9,19,10],[17,2,17,10]]}
[]
[]
[null,null,null,null,"ضميمه ",null,null,null,"صورت مغايرت بانكي",null,"وجوه واريزي كه در دفاتر ثبت نشده"]
[null,null,null,null,null,null,null,null,"شركت",{"$f":"Sheet2!I5","v":"نمونه"}]
[null,null,null,null,"حساب جاري",null,null,null,{"$f":"Sheet2!I6","v":1}]
[null,null,null,null,null,null,null,null,"در تاريخ",{"$f":"J_TODAY()","v":"95/08/10"}]
[null,null,"رديف","شماره","تاريخ",null,null,null,null,"شرح",null,"مبلغ واريزي"]
[null,null,1,null,null,"/",null,"/",null,null,null,0]
[null,null,2,null,null,"/",null,"/",null,null,null,0,"d_arabdoost@yahoo.com"]
[null,null,3,null,null,"/",null,"/",null,null,null,0]
[null,null,4,null,null,"/",null,"/",null,null,null,0]
[null,null,5,null,null,"/",null,"/",null,null,null,0]
[null,null,6,null,null,"/",null,"/",null,null,null,0]
[null,null,7,null,null,"/",null,"/",null,null,null,0]
[null,null,8,null,null,"/",null,"/",null,null,null,0]
[null,null,9,null,null,"/",null,"/",null,null,null,0]
[null,null,10,null,null,"/",null,"/",null,null,null,0]
[null,null,"جمع",null,null,null,null,null,null,null,null,{"$f":"SUM(L8:L17)","v":0}]

{"sheet":"Sheet5","index":4,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,2,16,10],[43,12,50,12],[7,12,15,12],[19,9,19,10],[8,9,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[18,9,18,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[1,8,1,9],[1,4,1,7],[5,9,5,10],[6,9,6,10],[7,9,7,10],[3,4,3,7],[3,8,3,10],[5,4,5,8],[31,9,31,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[43,9,43,10],[32,9,32,10],[55,9,55,10],[44,9,44,10],[45,9,45,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[50,9,50,10],[51,9,51,10],[52,9,52,10],[53,9,53,10],[54,9,54,10],[33,9,33,10],[34,9,34,10]]}
[]
[null,null,null,null,"ضميمه ",null,null,null,"صورت مغايرت بانكي",null,"كارمزد و ساير هزينه هاي ثبت نشده"]
[null,null,null,null,null,null,null,null,"شركت",{"$f":"Sheet2!I5","v":"نمونه"}]
[null,null,null,null,"حساب جاري",null,null,null,{"$f":"Sheet2!I6","v":1}]
[null,null,null,null,null,null,null,null,"در تاريخ",{"$f":"Sheet2!H9","v":"95/08/10"}]
[null,null,"رديف","شماره","تاريخ",null,null,null,null,"شرح",null,"مبلغ واريزي"]
[null,null,1,null,null,"/",null,"/"]
[null,null,2,null,null,"/",null,"/",null,null,null,0,"d_arabdoost@yahoo.com"]
[null,null,3,null,null,"/",null,"/",null,null,null,0]
[null,null,4,null,null,"/",null,"/",null,null,null,0]
[null,null,5,null,null,"/",null,"/",null,null,null,0]
[null,null,6,null,null,"/",null,"/",null,null,null,0]
[null,null,7,null,null,"/",null,"/",null,null,null,0]
[null,null,8,null,null,"/",null,"/",null,null,null,0]
[null,null,9,null,null,"/",null,"/",null,null,null,0]
[null,null,10,null,null,"/",null,"/",null,null,null,0]
[null,null,"جمع",null,null,null,null,null,null,null,null,{"$f":"SUM(L7:L16)","v":0}]

{"sheet":"Sheet8","index":5,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,2,17,10],[44,12,51,12],[8,12,16,12],[20,9,20,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[40,9,40,10],[2,8,2,9],[2,4,2,7],[6,9,6,10],[7,9,7,10],[8,9,8,10],[4,4,4,7],[4,8,4,10],[6,4,6,8],[32,9,32,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[31,9,31,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[19,4,19,10],[44,9,44,10],[33,9,33,10],[56,9,56,10],[45,9,45,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[50,9,50,10],[51,9,51,10],[52,9,52,10],[53,9,53,10],[54,9,54,10],[55,9,55,10],[34,9,34,10]]}
[]
[]
[null,null,null,null,"ضميمه ",null,null,null,"صورت مغايرت بانكي",null,"سپرده بين راهي"]
[null,null,null,null,null,null,null,null,"شركت",{"$f":"Sheet2!I5","v":"نمونه"}]
[null,null,null,null,"حساب جاري",null,null,null,{"$f":"Sheet2!I6","v":1}]
[null,null,null,null,null,null,null,null,"در تاريخ",{"$f":"Sheet2!H9","v":"95/08/10"}]
[null,null,"رديف","شماره","تاريخ",null,null,null,null,"شرح",null,"مبلغ واريزي"]
[null,null,1,null,null,"/",null,"/"]
[null,null,2,null,null,"/",null,"/",null,null,null,0]
[null,null,3,null,null,"/",null,"/",null,null,null,0]
[null,null,4,null,null,"/",null,"/",null,null,null,0]
[null,null,5,null,null,"/",null,"/",null,null,null,0]
[null,null,6,null,null,"/",null,"/",null,null,null,0]
[null,null,7,null,null,"/",null,"/",null,null,null,0]
[null,null,8,null,null,"/",null,"/",null,null,null,0]
[null,null,9,null,null,"/",null,"/",null,null,null,0]
[null,null,10,null,null,"/",null,"/",null,null,null,0]
[null,null,"جمع",null,null,null,null,null,null,null,null,{"$f":"SUM(L8:L17)","v":0}]
[]
[null,null,null,null,"d_arabdoost@yahoo.com"]

{"sheet":"Sheet6","index":6,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,4,3,7],[3,8,3,10],[1,10,1,11],[5,4,5,8],[16,2,16,10],[43,12,50,12],[7,12,15,12],[1,8,1,9],[1,4,1,7],[5,9,5,10],[6,9,6,10],[7,9,7,10],[19,9,19,10],[8,9,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[18,9,18,10],[31,9,31,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[43,9,43,10],[32,9,32,10],[55,9,55,10],[44,9,44,10],[45,9,45,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[50,9,50,10],[51,9,51,10],[52,9,52,10],[53,9,53,10],[54,9,54,10],[33,9,33,10],[34,9,34,10]]}
[]
[null,null,null,null,"ضميمه ",null,null,null,"صورت مغايرت بانكي",null,"برداشت هاي ثبت نشده"]
[null,null,null,null,null,null,null,null,"شركت",{"$f":"Sheet2!I5","v":"نمونه"}]
[null,null,null,null,"حساب جاري",null,null,null,{"$f":"Sheet2!I6","v":1}]
[null,null,null,null,null,null,null,null,"در تاريخ",{"$f":"Sheet2!H9","v":"95/08/10"}]
[null,null,"رديف","شماره","تاريخ",null,null,null,null,"شرح",null,"مبلغ برداشتي"]
[null,null,1,null,null,"/",null,"/"]
[null,null,2,null,null,"/",null,"/",null,null,null,null,"d_arabdoost@yahoo.com"]
[null,null,3,null,null,"/",null,"/"]
[null,null,4,null,null,"/",null,"/"]
[null,null,5,null,null,"/",null,"/"]
[null,null,6,null,null,"/",null,"/"]
[null,null,7,null,null,"/",null,"/"]
[null,null,8,null,null,"/",null,"/"]
[null,null,9,null,null,"/",null,"/"]
[null,null,10,null,null,"/",null,"/"]
[null,null,"جمع",null,null,null,null,null,null,null,null,{"$f":"SUM(L7:L16)","v":0}]

{"sheet":"Sheet9","index":7,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,4,4,7],[4,8,4,10],[2,10,2,11],[6,4,6,8],[17,2,17,10],[31,9,31,10],[44,12,51,12],[8,12,16,12],[2,8,2,9],[2,4,2,7],[6,9,6,10],[7,9,7,10],[20,9,20,10],[8,9,8,10],[9,9,9,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[32,9,32,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[19,4,19,10],[44,9,44,10],[33,9,33,10],[56,9,56,10],[45,9,45,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[50,9,50,10],[51,9,51,10],[52,9,52,10],[53,9,53,10],[54,9,54,10],[55,9,55,10],[34,9,34,10]]}
[]
[]
[null,null,null,null,"ضميمه ",null,null,null,"صورت مغايرت بانكي",null,"چك هاي وصول نشده"]
[null,null,null,null,null,null,null,null,"شركت",{"$f":"Sheet2!I5","v":"نمونه"}]
[null,null,null,null,"حساب جاري",null,null,null,{"$f":"Sheet2!I6","v":1}]
[null,null,null,null,null,null,null,null,"در تاريخ",{"$f":"J_TODAY()","v":"95/08/10"}]
[null,null,"رديف","شماره","تاريخ",null,null,null,null,"گيرنده چك",null,"مبلغ چك"]
[null,null,1,null,null,"/",null,"/",null,null,null,0]
[null,null,2,null,null,"/",null,"/",null,null,null,0]
[null,null,3,null,null,"/",null,"/",null,null,null,0]
[null,null,4,null,null,"/",null,"/",null,null,null,0]
[null,null,5,null,null,"/",null,"/",null,null,null,0]
[null,null,6,null,null,"/",null,"/",null,null,null,0]
[null,null,7,null,null,"/",null,"/",null,null,null,0]
[null,null,8,null,null,"/",null,"/",null,null,null,0]
[null,null,9,null,null,"/",null,"/",null,null,null,0]
[null,null,10,null,null,"/",null,"/",null,null,null,0]
[null,null,"جمع",null,null,null,null,null,null,null,null,{"$f":"SUM(L8:L17)","v":0}]
[]
[null,null,null,null,"d_arabdoost@yahoo.com"]