{"id":2138,"date":"2020-07-20T16:29:55","date_gmt":"2020-07-20T16:29:55","guid":{"rendered":"http:\/\/ajuda.grupopzm.com.br\/?p=2138"},"modified":"2020-10-06T20:11:27","modified_gmt":"2020-10-06T20:11:27","slug":"trial-balance-validation-upload","status":"publish","type":"post","link":"https:\/\/ajuda.grupopzm.com.br\/index.php\/en\/2020\/07\/20\/trial-balance-validation-upload\/","title":{"rendered":"Trial Balance Validation Upload"},"content":{"rendered":"\n<p>All the fields of the trial balance layout are mandatory. Following there are some checks before uploading:<\/p>\n\n\n\n<p>1- In column A must be informed the accrual month with two digits .<\/p>\n\n\n\n<p>2- In column B must be informed the account code according registered on Chart of Accounts.<\/p>\n\n\n\n<p>3- In column C must be informed the account name and it can not have single quotation mark, double quotes, apostrophe and backslash (&#8216; &#8221; `\u00b4\\) and must have at most 50 characters.<\/p>\n\n\n\n<p>4- In columns of balances (D, E, F and G)<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>It cannot have thousand separators<\/li><li>It cannot have &#8211; (dash) where there is no balance inform 0,00<\/li><li>It cannot have formulas<\/li><li>They must be formatted in numbers with two decimal digits without thousand separators<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ajuda.grupopzm.com.br\/wp-content\/uploads\/2020\/07\/1-1-9-1024x319.png\" alt=\"\" class=\"wp-image-2420\" width=\"1084\" height=\"337\" srcset=\"https:\/\/ajuda.grupopzm.com.br\/wp-content\/uploads\/2020\/07\/1-1-9-1024x319.png 1024w, https:\/\/ajuda.grupopzm.com.br\/wp-content\/uploads\/2020\/07\/1-1-9-300x94.png 300w, https:\/\/ajuda.grupopzm.com.br\/wp-content\/uploads\/2020\/07\/1-1-9-768x239.png 768w, https:\/\/ajuda.grupopzm.com.br\/wp-content\/uploads\/2020\/07\/1-1-9-150x47.png 150w, https:\/\/ajuda.grupopzm.com.br\/wp-content\/uploads\/2020\/07\/1-1-9.png 1174w\" sizes=\"(max-width: 1084px) 100vw, 1084px\" \/><\/figure>\n\n\n\n<p>5- In column H must be informed the trial balance year<\/p>\n\n\n\n<p>6- In column I must be informed the accounting subsidiary code registered in PZM.<\/p>\n<div style='text-align:center' class='yasr-auto-insert-visitor'><\/div>","protected":false},"excerpt":{"rendered":"<p>All the fields of the trial balance layout are mandatory. Following there are some checks before uploading: 1- In column A must be informed the accrual month with two digits . 2- In column B must be informed the account code according registered on Chart of Accounts. 3- In column C must be informed the ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/ajuda.grupopzm.com.br\/index.php\/en\/2020\/07\/20\/trial-balance-validation-upload\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"yasr_overall_rating":0,"yasr_post_is_review":"","yasr_auto_insert_disabled":"","yasr_review_type":"","footnotes":""},"categories":[1352],"tags":[3253,3254],"class_list":["post-2138","post","type-post","status-publish","format-standard","hentry","category-accounting-reconciliation","tag-trial-balance","tag-validation"],"yasr_visitor_votes":{"stars_attributes":{"read_only":false,"span_bottom":false},"number_of_votes":0,"sum_votes":0},"_links":{"self":[{"href":"https:\/\/ajuda.grupopzm.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2138"}],"collection":[{"href":"https:\/\/ajuda.grupopzm.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ajuda.grupopzm.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ajuda.grupopzm.com.br\/index.php\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/ajuda.grupopzm.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=2138"}],"version-history":[{"count":7,"href":"https:\/\/ajuda.grupopzm.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2138\/revisions"}],"predecessor-version":[{"id":2452,"href":"https:\/\/ajuda.grupopzm.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2138\/revisions\/2452"}],"wp:attachment":[{"href":"https:\/\/ajuda.grupopzm.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ajuda.grupopzm.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ajuda.grupopzm.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}