{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Панель","Справочник","Банк","Касса_1С","Касса","СККО_src","СККО","Отчет","Итог"],"not_rendered":{"charts":0,"images":1,"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":"Панель","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,0,8,14],[9,0,9,14],[1,0,1,14],[2,0,2,14],[3,0,3,14],[5,0,5,14],[6,0,6,14],[7,0,7,14]]}
[null,null,null,"Инструкция заполнения УСН_шаблон"]
["1. Сначала Лист Справочник, заполняем контрагентов (юридические лица) по образцу; \n2. Лист Банк, заполняем только ячейку УНП, и контрагент подтягивается автоматически. После нужно подставить дату и сумму. Если оплата от физического лица, то в ячейку УНП подставляем 0 - Получена оплата за услуги посредством ACQ (помимо даты и суммы,"]
[" нужно подставить комиссию), 1 - Получена оплата за услуги посредством E-POS (АИС расчет) (помимо даты, суммы и комиссии, нужно подставить количество операций); \n3. В перспективе можно доработать, чтобы копировать банковские выписки и данные сами подставлялись;"]
["4. Лист Касса_1С, суда копируем данные из 1С (если есть, делается это для проверки правильности внесения данных в 1С). Отчёт по проводкам – в окне Фильтр выбираем 50,90 и копируем в левую часть таблицы, 57.1,90 и копируем в правую часть таблицы; \n5. Лист Касса заполняется VBA скриптом;"]
["6.Лист СККО_src, в него данные копируются из отчёта СККО (копируется полностью лист, ничего выбирать не нужно);"]
["7. Лист СККО заполняется VBA скриптом;\n"]
["8. Лист Отчёт, здесь показываются расхождения между данными 1С и отчётом СККО;"]
["9. Лист Итог заполняется VBA скриптом; \n10. После заполнения переходим на первый лист Панель и нажимает по порядку, \nначиная с Шаг 2 (Шаг 1: Очистить – макрос для очистки данных перед началом "]
["заполнения). Шаг 2 – Сортирует по датам и переносит данные в таблицу на лист Касса. Шаг 3 – Сортирует по датам и переносит данные в таблицу на лист СККО. Шаг 4 – сверяет данные листов Касса и СККО, если находит расхождения, вносит в отчёт. Шаг 5 – Объединяет и сортирует по дате все данные с листов Банк и СККО."]
["11. Далее полученную таблицу с листа Итог можно копировать в Книгу учета доходов и расходов УСН."]

{"sheet":"Справочник","index":1,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,2,0],[0,1,0,2],[0,3,0,5],[0,6,2,6],[0,7,0,9],[0,11,2,11],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,7,1,8],[1,9,2,9],[0,10,2,10]]}
["Дата отражения \n(излишнего отражения) валовой выручки, дата возврата ","Сведения о контрагенте",null,"Документ",null,null,"Содержание операции","Валовая выручка",null,null,"Ставка налога, \n% ","Примечание"]
[null,"УНП","наименование ","наименование","номер","дата",null,"в иностранной валюте",null,"сумма в белорусских рублях (далее - бел. руб.) "]
[null,null,null,null,null,null,null,"код иностранной валюты","сумма",null,null,null,"сумма комиссии","кол-во операций"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[]
[]
[]
[null,0,"Физ.лица","Банковская выписка с приложенным реестром поступившей оплаты от физлиц",null,null,"Получена оплата за услуги посредством ACQ",null,null,75,6,"Удержано комиссии",2.25]
[null,1,"Физ.лица","Банковская выписка с приложенным реестром поступившей оплаты от физлиц",null,null,"Получена оплата за услуги посредством E-POS (АИС расчет)",null,null,25,6,"Удержано комиссии","0,31",1]
[null,101541947,"ЗАО \"Альфа-Банк\"","Платежный ордер",null,null,"% банка по договору №01 от 30.03.2025 г.",null,null,null,6]
[null,100000001,"ООО \"Один\"","Платежное поручение",null,null,"Оплата за услуги Дог.№ 1 от 01.02.2025 г.",null,null,null,6]
[null,100000002,"ОАО \"Два\"","Платежное поручение",null,null,"Оплата за услуги Дог.№ 2 от 02.02.2025 г.",null,null,null,6]
[null,100000003,"УП \"Три\"","Платежное поручение",null,null,"Оплата за услуги Дог.№ 3 от 03.02.2025 г.",null,null,null,6]
[null,100000004,"ООО \"Четыре\"","Платежное поручение",null,null,"Оплата за услуги Дог.№ 4 от 04.02.2025 г.",null,null,null,6]
[null,100000005,"ОАО \"Пять\"","Платежное поручение",null,null,"Оплата за услуги Дог.№ 5 от 08.02.2025 г.",null,null,null,6]
[null,100000006,"УП \"Шесть\"","Платежное поручение",null,null,"Оплата за услуги Дог.№ 6 от 09.02.2025 г.",null,null,null,6]

{"sheet":"Банк","index":2,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,2,0],[0,1,0,2],[0,3,0,5],[0,6,2,6],[0,7,0,9],[0,11,2,11],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,7,1,8],[1,9,2,9],[0,10,2,10]]}
["Дата отражения \n(излишнего отражения) валовой выручки, дата возврата ","Сведения о контрагенте",null,"Документ",null,null,"Содержание операции","Валовая выручка",null,null,"Ставка налога, \n% ","Примечание"]
[null,"УНП","наименование ","наименование","номер","дата",null,"в иностранной валюте",null,"сумма в белорусских рублях (далее - бел. руб.) "]
[null,null,null,null,null,null,null,"код иностранной валюты","сумма",null,null,null,"сумма комиссии","кол-во операций"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]

{"sheet":"Касса_1С","index":3,"n_rows":7,"n_cols":18,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Дата","Документ","Содержание","Дебет","Кредит","Сумма","Кол-во","Валюта","Вал. Сумма","Дата","Документ","Содержание","Дебет","Кредит","Сумма","Кол-во","Валюта","Вал. Сумма"]
["2026-03-01","Приходный кассовый ордер 1","Сотрудник1\nВыручка\nБез НДС от выручки","50.1","90.1",50," "," "," ","2026-03-01","Приходный ордер по пласт.картам 1","Сотрудник1\nБез НДС от выручки","57.1","90.1",50," "," "," "]
["2026-03-01","Приходный кассовый ордер 1","Сотрудник2\nВыручка\nБез НДС от выручки","50.1","90.1",50,null,null,null,"2026-03-01","Приходный ордер по пласт.картам 2","Сотрудник2\nБез НДС от выручки","57.1","90.1",50]
["2026-03-02","Приходный кассовый ордер 1","Сотрудник1\nВыручка\nБез НДС от выручки","50.1","90.1",50,null,null,null,"2026-03-02","Приходный ордер по пласт.картам 3","Сотрудник1\nБез НДС от выручки","57.1","90.1",100]
["2026-03-02",null,"Сотрудник2\nВыручка\nБез НДС от выручки","50.1","90.1",50,null,null,null,"2026-03-02","Приходный ордер по пласт.картам 4","Сотрудник2\nБез НДС от выручки","57.1","90.1",50]
["2026-03-03",null,"Сотрудник1\nВыручка\nБез НДС от выручки","50.1","90.1",50,null,null,null,"2026-03-03","Приходный ордер по пласт.картам 5","Сотрудник1\nБез НДС от выручки","57.1","90.1",50]
["2026-03-03",null,"Сотрудник2\nВыручка\nБез НДС от выручки","50.1","90.1",50,null,null,null,"2026-03-03","Приходный ордер по пласт.картам 6","Сотрудник2\nБез НДС от выручки","57.1","90.1",50]

{"sheet":"Касса","index":4,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,2,0],[0,1,0,2],[0,3,0,5],[0,6,2,6],[0,7,0,9],[0,11,2,11],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,7,1,8],[1,9,2,9],[0,10,2,10]]}
["Дата отражения \n(излишнего отражения) валовой выручки, дата возврата ","Сведения о контрагенте",null,"Документ",null,null,"Содержание операции","Валовая выручка",null,null,"Ставка налога, \n% ","Примечание"]
[null,"УНП","наименование ","наименование","номер","дата",null,"в иностранной валюте",null,"сумма в белорусских рублях (далее - бел. руб.) "]
[null,null,null,null,null,null,null,"код иностранной валюты","сумма",null,null,null,"сумма комиссии","кол-во операций"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]

{"sheet":"СККО_src","index":5,"n_rows":69,"n_cols":16,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,0,68,7],[37,0,67,0],[37,1,67,1],[37,2,67,2],[1,0,1,9],[5,0,35,0],[5,1,35,1],[5,2,35,2],[36,0,36,7]]}
[null,null,null,null,null,null,null,null,"- проблемный z-отчет"]
["34. Продажи \"Общество с ограниченной ответственностью \"Пример\"\", по данным Z-отчетов за март 2026, в разрезе КО (по датам)"]
[]
["Учетный номер КО","Адрес места установки КО","Заводской номер КО","Номер Z-отчета","Дата открытия смены","Время открытия смены ","Дата закрытия смены","Время закрытия смены","Кол. Чеков","Продажи","В том числе наличными ","В том числе безналичными","Кол. Возвратов","Сумма возвратов","Кол. Аннулирований","Сумма аннулирований"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[400000001,"г. Минск","0000000000000",1,"2026-03-01","07:58:09","2026-03-01","20:47:00",51,100,50,50,"0",0,"0",0]
[null,null,null,2,"2026-03-02","07:32:46","2026-03-02","21:15:13",43,100,50,50,"0",0,"0",0]
[null,null,null,3,"2026-03-03","07:49:00","2026-03-03","20:41:49",60,100,50,50,"0",0,"0",0]
[null,null,null,4,"2026-03-04","08:42:19","2026-03-04","19:44:23",44,100,50,50,"0",0,"0",0]
[null,null,null,5,"2026-03-05","08:45:14","2026-03-05","18:53:13",40,100,50,50,"0",0,"0",0]
[null,null,null,6,"2026-03-06","09:51:02","2026-03-06","21:57:25",39,100,50,50,"0",0,"0",0]
[null,null,null,7,"2026-03-07","07:51:41","2026-03-07","20:53:18",53,100,50,50,"0",0,"0",0]
[null,null,null,8,"2026-03-08","07:44:43","2026-03-08","20:44:56",59,100,50,50,"0",0,"0",0]
[null,null,null,9,"2026-03-09","08:15:33","2026-03-09","20:41:15",57,100,50,50,"0",0,"0",0]
[null,null,null,10,"2026-03-10","07:45:28","2026-03-10","20:26:59",55,100,50,50,"0",0,"0",0]
[null,null,null,11,"2026-03-11","08:47:34","2026-03-11","16:47:26",19,100,50,50,"0",0,"0",0]
[null,null,null,12,"2026-03-12","08:45:59","2026-03-12","18:42:50",37,100,50,50,"0",0,"0",0]
[null,null,null,13,"2026-03-13","08:01:23","2026-03-13","19:13:13",30,100,50,50,"0",0,"0",0]
[null,null,null,14,"2026-03-14","07:52:22","2026-03-14","20:56:11",48,100,50,50,"0",0,"0",0]
[null,null,null,15,"2026-03-15","07:58:06","2026-03-15","20:43:00",50,100,50,50,"0",0,"0",0]
[null,null,null,16,"2026-03-16","07:53:21","2026-03-16","20:44:21",54,100,50,50,"0",0,"0",0]
[null,null,null,17,"2026-03-17","07:32:31","2026-03-17","20:38:37",72,100,50,50,"0",0,"0",0]
[null,null,null,18,"2026-03-18","08:44:20","2026-03-18","19:48:47",25,100,50,50,"0",0,"0",0]
[null,null,null,19,"2026-03-19","08:44:14","2026-03-19","18:40:24",32,100,50,50,"0",0,"0",0]
[null,null,null,20,"2026-03-20","07:51:50","2026-03-20","21:43:12",112,100,50,50,"0",0,"0",0]
[null,null,null,21,"2026-03-21","07:57:57","2026-03-21","20:46:56",86,100,50,50,"0",0,"0",0]
[null,null,null,22,"2026-03-22","07:36:14","2026-03-22","20:38:16",60,100,50,50,"0",0,"0",0]
[null,null,null,23,"2026-03-23","07:41:03","2026-03-23","20:46:01",49,100,50,50,"0",0,"0",0]
[null,null,null,24,"2026-03-24","07:50:24","2026-03-24","21:13:45",77,100,50,50,"0",0,"0",0]
[null,null,null,25,"2026-03-25","08:52:10","2026-03-25","19:49:35",54,100,50,50,"0",0,"0",0]
[null,null,null,26,"2026-03-26","08:40:46","2026-03-26","18:33:57",21,100,50,50,"0",0,"0",0]
[null,null,null,27,"2026-03-27","07:39:41","2026-03-27","20:45:13",49,100,50,50,"0",0,"0",0]
[null,null,null,28,"2026-03-28","07:50:43","2026-03-28","20:46:02",70,100,50,50,"0",0,"0",0]
[null,null,null,29,"2026-03-29","08:04:12","2026-03-29","20:48:50",76,100,50,50,"0",0,"0",0]
[null,null,null,30,"2026-03-30","07:39:47","2026-03-30","20:33:40",65,100,50,50,"0",0,"0",0]
[null,null,null,31,"2026-03-31","07:42:22","2026-03-31","20:41:48",43,100,50,50,"0",0,"0",0]
["Итого по 400000001",null,null,null,null,null,null,null,1630,{"$f":"SUM(J6:J36)","v":3100},{"$f":"SUM(K6:K36)","v":1550},1550,"0",0,"0",0]
[400000002,"г. Минск","0000000000000",1,"2026-03-01","08:55:48","2026-03-01","21:39:48",60,100,50,50,"0",0,"0",0]
[null,null,null,2,"2026-03-02","08:59:56","2026-03-02","21:48:11",38,100,50,50,"0",0,"0",0]
[null,null,null,3,"2026-03-03","09:57:46","2026-03-03","21:36:29",58,100,50,50,"0",0,"0",0]
[null,null,null,4,"2026-03-04","08:44:08","2026-03-04","19:43:42",27,100,50,50,"0",0,"0",0]
[null,null,null,5,"2026-03-05","08:41:46","2026-03-05","18:45:10",22,100,50,50,"0",0,"0",0]
[null,null,null,6,"2026-03-06","07:59:58","2026-03-06","21:38:57",75,100,50,50,"0",0,"0",0]
[null,null,null,7,"2026-03-07","09:00:49","2026-03-07","21:38:18",58,100,50,50,"0",0,"0",0]
[null,null,null,8,"2026-03-08","08:52:38","2026-03-08","21:38:31",66,100,50,50,"0",0,"0",0]
[null,null,null,9,"2026-03-09","08:53:14","2026-03-09","21:44:27",45,100,50,50,"0",0,"0",0]
[null,null,null,10,"2026-03-10","07:46:21","2026-03-10","22:07:50",45,100,50,50,"0",0,"0",0]
[null,null,null,11,"2026-03-11","08:50:01","2026-03-11","19:42:14",36,100,50,50,"0",0,"0",0]
[null,null,null,12,"2026-03-12","08:51:10","2026-03-12","18:40:04",59,100,50,50,"0",0,"0",0]
[null,null,null,13,"2026-03-13","08:21:15","2026-03-13","21:44:51",82,100,50,50,"0",0,"0",0]
[null,null,null,14,"2026-03-14","07:52:26","2026-03-14","21:41:39",68,100,50,50,"0",0,"0",0]
[null,null,null,15,"2026-03-15","09:25:18","2026-03-15","21:49:32",55,100,50,50,"0",0,"0",0]
[null,null,null,16,"2026-03-16","09:37:28","2026-03-16","21:39:21",56,100,50,50,"0",0,"0",0]
[null,null,null,17,"2026-03-17","08:59:18","2026-03-17","21:47:03",49,100,50,50,"0",0,"0",0]
[null,null,null,18,"2026-03-18","10:07:04","2026-03-18","20:03:05",38,100,50,50,"0",0,"0",0]
[null,null,null,19,"2026-03-19","08:44:20","2026-03-19","18:39:49",40,100,50,50,"0",0,"0",0]
[null,null,null,20,"2026-03-20","08:16:56","2026-03-20","18:32:35",24,100,50,50,"0",0,"0",0]
[null,null,null,21,"2026-03-21","09:19:38","2026-03-21","21:46:40",47,100,50,50,"0",0,"0",0]
[null,null,null,22,"2026-03-22","07:46:04","2026-03-22","21:53:54",43,100,50,50,"0",0,"0",0]
[null,null,null,23,"2026-03-23","07:41:24","2026-03-23","21:46:56",51,100,50,50,"0",0,"0",0]
[null,null,null,24,"2026-03-24","09:09:14","2026-03-24","21:44:14",61,100,50,50,"0",0,"0",0]
[null,null,null,25,"2026-03-25","08:57:49","2026-03-25","19:45:30",38,100,50,50,"0",0,"0",0]
[null,null,null,26,"2026-03-26","08:41:37","2026-03-26","18:42:15",31,100,50,50,"0",0,"0",0]
[null,null,null,27,"2026-03-27","08:02:57","2026-03-27","21:51:31",76,100,50,50,"0",0,"0",0]
[null,null,null,28,"2026-03-28","08:16:07","2026-03-28","21:44:07",50,100,50,50,"0",0,"0",0]
[null,null,null,29,"2026-03-29","09:04:45","2026-03-29","21:45:30",52,100,50,50,"0",0,"0",0]
[null,null,null,30,"2026-03-30","07:35:39","2026-03-30","21:51:23",57,100,50,50,"0",0,"0",0]
[null,null,null,31,"2026-03-31","07:44:14","2026-03-31","21:42:48",57,100,50,50,"0",0,"0",0]
["Итого по 400000002",null,null,null,null,null,null,null,1564,{"$f":"SUM(J38:J68)","v":3100},{"$f":"SUM(K38:K68)","v":1550},{"$f":"SUM(L38:L68)","v":1550},"0",0,"0",0]

{"sheet":"СККО","index":6,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,11,2,11],[0,10,2,10],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,7,1,8],[1,9,2,9],[0,0,2,0],[0,1,0,2],[0,3,0,5],[0,6,2,6],[0,7,0,9]]}
["Дата отражения \n(излишнего отражения) валовой выручки, дата возврата ","Сведения о контрагенте",null,"Документ",null,null,"Содержание операции","Валовая выручка",null,null,"Ставка налога, \n% ","Примечание"]
[null,"УНП","наименование ","наименование","номер","дата",null,"в иностранной валюте",null,"сумма в белорусских рублях (далее - бел. руб.) "]
[null,null,null,null,null,null,null,"код иностранной валюты","сумма",null,null,null,"сумма комиссии","кол-во операций",{"$f":"SUM(J5:J270)","v":0}]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]

{"sheet":"Отчет","index":7,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Дата","Сумма (1С)","Сумма (СККО)","Разница","Назначение (1С / СККО)","Проблема"]

{"sheet":"Итог","index":8,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,12,2,12],[0,13,2,13],[0,0,2,0],[0,1,0,2],[0,3,0,5],[0,6,2,6],[0,7,0,9],[0,11,2,11],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,7,1,8],[1,9,2,9],[0,10,2,10]]}
["Дата отражения \n(излишнего отражения) валовой выручки, дата возврата ","Сведения о контрагенте",null,"Документ",null,null,"Содержание операции","Валовая выручка",null,null,"Ставка налога, \n% ","Примечание","сумма комиссии","кол-во операций"]
[null,"УНП","наименование ","наименование","номер","дата",null,"в иностранной валюте",null,"сумма в белорусских рублях (далее - бел. руб.) "]
[null,null,null,null,null,null,null,"код иностранной валюты","сумма"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]