{"id":110776,"date":"2021-08-04T11:55:16","date_gmt":"2021-08-04T02:55:16","guid":{"rendered":"https:\/\/support.questetra.com\/?p=110776"},"modified":"2026-04-13T10:50:43","modified_gmt":"2026-04-13T01:50:43","slug":"moneyforward-journal-create-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create-2021\/","title":{"rendered":"MoneyForward Journal, Create"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">MoneyForward Journal, Create<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only batch sales invoices but also invoices that are prorated for each month.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li> A: Select STRING DATA for Slip Description<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> B: Select NUMERIC DATA for Sales Amount (Single Record)<\/li>\n<li> C: Select DATE DATA for Sales Record (Single Record)<\/li>\n<li> D: Select NUMERIC DATA for Sales Amount (Multiple Records)<\/li>\n<li> E: Select DATE DATA for First Sales Record (Next Month 1st Day)<\/li>\n<li> F: Select NUMERIC DATA for Division Number<\/li>\n<li> G: Select DATE DATA for Scheduled Due Date<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> M: Set Record Tpl for Receivable Single (e.g. &#8220;,,AR,,,,,,Sa,*&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> N: Set Record Tpl for Received Single (e.g. &#8220;,,Rvd,,,,,,Sa,*&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> P: Set Record Tpl for Receivable Sales (e.g. &#8220;,,AR,,,,,,Sa,*&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> Q: Set Record Tpl for Received Sales (e.g. &#8220;,,Rvd,,,,,,Sa,*&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> R: Set Record Tpl for Payment of Receivable (e.g. &#8220;Bank,,na&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> S: Set Record Tpl for Payment of Received (e.g. &#8220;Bank,,na&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> X: Select STRING DATA for TSV (update)<\/li>\n<li> Y: Select FILES DATA for Excel-CSV (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> Z: Set End Month of Fiscal Period (eg March: &#8220;3&#8221; )<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\n\/\/ GraalJS Script (engine type: 2)\n\/\/ \n\/\/ Notes:\n\/\/ &quot;Transaction No.&quot;\n\/\/ - The slip generated on April 1 = 8 digits of &quot;401yyyzz&quot; (closing month &quot;12&quot;).\n\/\/ - The slip generated on April 1 = 8 digits of &quot;101yyyzz&quot; (closing month &quot;3&quot;).\n\/\/ - The slip generated on March 31 = 9 digits &quot;1231yyyzz&quot; (closing month &quot;3&quot;).\n\/\/ - The yyy part is the last three digits of {process ID}.\n\/\/ - The zz part is the split ID (01,02, ...).\n\/\/ - It may be renumbered when imported to MF.\n\/\/ - &quot;Transaction No.&quot; such as &quot;manual entry&quot; will be the increment value.\n\/\/ No header row is added to the generated &quot;journal TSV&quot;. (for Sheet Append)\n\/\/ The following 21 items are posted in the header line of &quot;Journal Excel-CSV&quot;\n\/\/ - [0] Transaction No, [1] Transaction Date,\n\/\/ - [2] Debit account, [3] Debit sub-item, [4] Debit tax classification,\n\/\/ - [5] Debit department, [6] Debit amount (yen), [7] Debit tax amount,\n\/\/ - [8] Credit account, [9] Credit sub-item, [10] Credit tax classification,\n\/\/ - [11] Credit department, [12] Credit amount (yen), [13] Credit tax amount,\n\/\/ - [14] description, [15] journal memo, [16] tag, [17] MF journal type,\n\/\/ - [18] Closing journal, [19] Creation date, [20] Last update date\n\/\/ #Money Forward journal_sample.csv\n\/\/ https:\/\/support.biz.moneyforward.com\/account\/guide\/import-books\/ib01.html\n\/\/ The description of the split sales records in the format &quot;2020-04 @ {Description}&quot;.\n\/\/\n\/\/ Notes (ja):\n\/\/ &quot;\u53d6\u5f15No&quot; \u306f\u3001\n\/\/ - 4\u67081\u65e5\u306b\u751f\u6210\u3055\u308c\u308b\u4f1d\u7968\u306f\u3001\u6c7a\u7b97\u6708\u304c&quot;12&quot;\u306e\u5834\u5408 &quot;401yyyzz&quot; \u306e8\u6841\u3068\u306a\u308a\u307e\u3059\u3002\n\/\/ - 4\u67081\u65e5\u306b\u751f\u6210\u3055\u308c\u308b\u4f1d\u7968\u306f\u3001\u6c7a\u7b97\u6708\u304c &quot;3&quot;\u306e\u5834\u5408 &quot;101yyyzz&quot; \u306e8\u6841\u3068\u306a\u308a\u307e\u3059\u3002\n\/\/ - 3\u670831\u65e5\u306b\u751f\u6210\u3055\u308c\u308b\u4f1d\u7968\u306f\u3001\u6c7a\u7b97\u6708\u304c&quot;3&quot;\u306e\u5834\u5408&quot;1231yyyzz&quot; \u306e9\u6841\u3068\u306a\u308a\u307e\u3059\u3002\n\/\/ - yyy \u90e8\u306f {\u30d7\u30ed\u30bb\u30b9ID} \u306e\u4e0b\u4e09\u6841\u306b\u306a\u308a\u307e\u3059\u3002\n\/\/ - zz \u90e8\u306f\u5206\u5272ID\u306b\u306a\u308a\u307e\u3059\uff0801,02,\u2026\uff09\u3002\n\/\/ - \u203bMF\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\u969b\u306b\u30ea\u30ca\u30f3\u30d0\u30fc\u3055\u308c\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\n\/\/ - \u203b\u305d\u306e\u5f8c\u306e\u300c\u624b\u52d5\u3067\u4ed5\u8a33\u300d\u7b49\u306e &quot;\u53d6\u5f15No&quot; \u306f\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u5024\u306b\u306a\u308a\u307e\u3059\u3002\n\/\/ \u751f\u6210\u3055\u308c\u308b\u300c\u4ed5\u8a33TSV\u300d\u306b\u30d8\u30c3\u30c0\u884c\u306f\u4ed8\u4e0e\u3055\u308c\u307e\u305b\u3093\u3002\uff08Sheet\u8ffd\u8a18\u304c\u60f3\u5b9a\u3055\u308c\u308b\u305f\u3081\uff09\n\/\/ \u751f\u6210\u3055\u308c\u308b\u300c\u4ed5\u8a33Excel-CSV\u300d\u306e\u30d8\u30c3\u30c0\u884c\u306b\u306f\u4ee5\u4e0b\u306e21\u9805\u76ee\u304cCSV\u5f62\u5f0f\u3067\u63b2\u793a\u3055\u308c\u307e\u3059\n\/\/ - [0]\u53d6\u5f15No,[1]\u53d6\u5f15\u65e5,\n\/\/ - [2]\u501f\u65b9\u52d8\u5b9a\u79d1\u76ee,[3]\u501f\u65b9\u88dc\u52a9\u79d1\u76ee,[4]\u501f\u65b9\u7a0e\u533a\u5206,\n\/\/ - [5]\u501f\u65b9\u90e8\u9580,[6]\u501f\u65b9\u91d1\u984d(\u5186),[7]\u501f\u65b9\u7a0e\u984d,\n\/\/ - [8]\u8cb8\u65b9\u52d8\u5b9a\u79d1\u76ee,[9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee,[10]\u8cb8\u65b9\u7a0e\u533a\u5206,\n\/\/ - [11]\u8cb8\u65b9\u90e8\u9580,[12]\u8cb8\u65b9\u91d1\u984d(\u5186),[13]\u8cb8\u65b9\u7a0e\u984d,\n\/\/ - [14]\u6458\u8981,[15]\u4ed5\u8a33\u30e1\u30e2,[16]\u30bf\u30b0,[17]MF\u4ed5\u8a33\u30bf\u30a4\u30d7,\n\/\/ - [18]\u6c7a\u7b97\u6574\u7406\u4ed5\u8a33,[19]\u4f5c\u6210\u65e5\u6642,[20]\u6700\u7d42\u66f4\u65b0\u65e5\u6642\n\/\/ \uff03Money Forward journal_sample.csv\n\/\/ https:\/\/support.biz.moneyforward.com\/account\/guide\/import-books\/ib01.html\n\/\/ \u5206\u5272\u3055\u308c\u305f\u58f2\u4e0a\u30ec\u30b3\u30fc\u30c9\u306e\u6458\u8981\u306f &quot;2020-04 @ {\u6458\u8981}&quot; \u3068\u3044\u3063\u305f\u66f8\u5f0f\u3068\u306a\u308a\u307e\u3059\u3002\n\/\/\n\/\/ \uff1c\uff14\u4f1d\u7968\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u8a2d\u5b9a\u4f8b\uff1e\n\/\/ \u30ab\u30f3\u30de\uff0820\u500b\uff09\u3067\u533a\u5207\u3089\u308c\u305f\u6587\u5b57\u5217\u3067\u632f\u66ff\u4f1d\u7968\u884c\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\n\/\/ \u5909\u6570\uff08EL\u5f0f\uff09\u3092\u633f\u5165\u3059\u308b\u3068\u3001\u5909\u6570\u90e8\u304c\u6848\u4ef6\u306b\u5fdc\u3058\u3066\u5909\u5316\u3057\u307e\u3059\u3002\n\/\/ \u203b\u306a\u304a &quot;[0],[1],[6],[12],[14]&quot; \u306e\u5404\u9805\u306f\u81ea\u52d5\u7684\u306b\u4e0a\u66f8\u304d\u3055\u308c\u307e\u3059\n\/\/ \n\/\/ - \u58f2\u639b\u91d1\u58f2\u4e0a\u4f1d\u7968\u3092\u300e[17]MF\u4ed5\u8a33\u30bf\u30a4\u30d7\u300f\u3092 &quot;\u672a\u5b9f\u73fe&quot; \u306b\u3057\u305f\u3044\u5834\u5408\n\/\/ -- &quot;,,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,\u672a\u5b9f\u73fe,,,&quot;\n\/\/ - \u524d\u53d7\u91d1\u58f2\u4e0a\u4f1d\u7968\u306e\u300e[3]\u501f\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 &quot;\u53d6\u5f15\u5148&quot; \u306b\u300e[9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 &quot;\u5546\u54c1\u7a2e&quot; \u306b\n\/\/ -- &quot;,,\u524d\u53d7\u91d1,#{#q_Billto},\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,#{#q_Product},\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,&quot;\n\/\/ - \u58f2\u639b\u91d1\u56de\u53ce\u4f1d\u7968\u306e\u300e[9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 &quot;\u53d6\u5f15\u5148&quot; \u306b\u3057\u3001\u30bf\u30a4\u30d7\u3092 &quot;\u672a\u5b9f\u73fe&quot; \u306b\n\/\/ -- &quot;,,\u666e\u901a\u8caf\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u639b\u91d1,#{#q_Billto},\u5bfe\u8c61\u5916,,,0,,,,\u672a\u5b9f\u73fe,,,&quot;\n\/\/ - \u524d\u53d7\u91d1\u56de\u53ce\u4f1d\u7968\u306e\u300e[9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 &quot;\u53d6\u5f15\u5148&quot; \u306b\u3057\u3001\u30bf\u30a4\u30d7\u3092 &quot;\u672a\u5b9f\u73fe&quot; \u306b\n\/\/ -- &quot;,,\u666e\u901a\u8caf\u91d1,\u307f\u305a\u307b\u9280\u884c,\u5bfe\u8c61\u5916,,,0,\u524d\u53d7\u91d1,#{#q_Billto},\u5bfe\u8c61\u5916,,,0,,,,\u672a\u5b9f\u73fe,,,&quot;\n\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){\n\n\/\/\/\/ == for &quot;MoneyForward\u30af\u30e9\u30a6\u30c9\u4f1a\u8a08&quot; ==\nconst myNumOfCols = 21; \/\/ \u30de\u30cd\u30fc\u30d5\u30a9\u30ef\u30fc\u30c9\u306e\u30d8\u30c3\u30c0\u884c\u306f\u4ee5\u4e0b\u306e21\u9805\u76ee\nconst headerRow =\n  &quot;\u53d6\u5f15No,\u53d6\u5f15\u65e5,\u501f\u65b9\u52d8\u5b9a\u79d1\u76ee,\u501f\u65b9\u88dc\u52a9\u79d1\u76ee,\u501f\u65b9\u7a0e\u533a\u5206,\u501f\u65b9\u90e8\u9580,\u501f\u65b9\u91d1\u984d(\u5186),\u501f\u65b9\u7a0e\u984d,&quot; +\n  &quot;\u8cb8\u65b9\u52d8\u5b9a\u79d1\u76ee,\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee,\u8cb8\u65b9\u7a0e\u533a\u5206,\u8cb8\u65b9\u90e8\u9580,\u8cb8\u65b9\u91d1\u984d(\u5186),\u8cb8\u65b9\u7a0e\u984d,\u6458\u8981,&quot; +\n  &quot;\u4ed5\u8a33\u30e1\u30e2,\u30bf\u30b0,MF\u4ed5\u8a33\u30bf\u30a4\u30d7,\u6c7a\u7b97\u6574\u7406\u4ed5\u8a33,\u4f5c\u6210\u65e5\u6642,\u6700\u7d42\u66f4\u65b0\u65e5\u6642&quot;;\nconst colSlipId = 0;  \/\/ &quot;\u53d6\u5f15No&quot; \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 0\uff09\nconst colDate   = 1;  \/\/ &quot;\u53d6\u5f15\u65e5&quot; \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 1\uff09\nconst ymdFormat = &quot;YYYY\/MM\/DD&quot;; \/\/ \u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\uff08MoneyForward\u306e\u5834\u5408\u306f &quot;YYYY\/MM\/DD&quot;\uff09\nconst colDrAmt  = 6;  \/\/ &quot;\u501f\u65b9\u91d1\u984d&quot; \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 6\uff09\nconst colCrAmt  = 12; \/\/ &quot;\u8cb8\u65b9\u91d1\u984d&quot; \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 12\uff09\nconst decimalPlaces = 0; \/\/ \u901a\u8ca8\u306e\u5c0f\u6570\u70b9\u4ee5\u4e0b\u6709\u52b9\u6570\u5b57\uff08\u65e5\u672c\u5186\u306e\u5834\u5408\u306f 0\uff09\nconst colSlipDescr = 14; \/\/ &quot;\u6458\u8981&quot; \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 14\uff09\n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst dataIdA = configs.get( &quot;conf_DataIdA&quot; ) + &quot;&quot;; \/\/ required\nconst dataIdB = configs.get( &quot;conf_DataIdB&quot; ) + &quot;&quot;;\nconst dataIdC = configs.get( &quot;conf_DataIdC&quot; ) + &quot;&quot;;\nconst dataIdD = configs.get( &quot;conf_DataIdD&quot; ) + &quot;&quot;;\nconst dataIdE = configs.get( &quot;conf_DataIdE&quot; ) + &quot;&quot;;\nconst dataIdF = configs.get( &quot;conf_DataIdF&quot; ) + &quot;&quot;;\nconst dataIdG = configs.get( &quot;conf_DataIdG&quot; ) + &quot;&quot;; \/\/ required\n\nlet   tplReceivableSingle = configs.get( &quot;conf_TplReceivableSingle&quot; ) + &quot;&quot;;\n  if( tplReceivableSingle === &quot;&quot;){\n      tplReceivableSingle = &quot;,,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,&quot;;}\n  const arrTplReceivableSingle = tplReceivableSingle.split(&quot;,&quot;);\nlet   tplReceivedSingle   = configs.get( &quot;conf_TplReceivedSingle&quot; ) + &quot;&quot;;\n  if( tplReceivedSingle   === &quot;&quot;){\n      tplReceivedSingle   = &quot;,,\u524d\u53d7\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,&quot;;}\n  const arrTplReceivedSingle   = tplReceivedSingle.split(&quot;,&quot;);\nlet   tplReceivableSales   = configs.get( &quot;conf_TplReceivableSales&quot; ) + &quot;&quot;;\n  if( tplReceivableSales   === &quot;&quot;){\n      tplReceivableSales = &quot;,,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,&quot;;}\n  const arrTplReceivableSales = tplReceivableSales.split(&quot;,&quot;);\nlet   tplReceivedSales     = configs.get( &quot;conf_TplReceivedSales&quot; ) + &quot;&quot;;\n  if( tplReceivedSales     === &quot;&quot;){\n      tplReceivedSales   = &quot;,,\u524d\u53d7\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,&quot;;}\n  const arrTplReceivedSales   = tplReceivedSales.split(&quot;,&quot;);\nlet   tplPaymentReceivable = configs.get( &quot;conf_TplPaymentReceivable&quot; ) + &quot;&quot;;\n  if( tplPaymentReceivable === &quot;&quot;){\n      tplPaymentReceivable = &quot;,,\u666e\u901a\u9810\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,,,,,,,&quot;;}\n  const arrTplPaymentReceivable = tplPaymentReceivable.split(&quot;,&quot;);\nlet   tplPaymentReceived   = configs.get( &quot;conf_TplPaymentReceived&quot; ) + &quot;&quot;;\n  if( tplPaymentReceived   === &quot;&quot;){\n      tplPaymentReceived     = &quot;,,\u666e\u901a\u9810\u91d1,,\u5bfe\u8c61\u5916,,,0,\u524d\u53d7\u91d1,,\u5bfe\u8c61\u5916,,,0,,,,,,,&quot;;}\n  const arrTplPaymentReceived   = tplPaymentReceived.split(&quot;,&quot;);\nif( myNumOfCols !== tplReceivableSingle.split(&quot;,&quot;).length ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {M} does not match 20-commas Header \\n&quot; );\n}\nif( myNumOfCols !== tplReceivedSingle.split(&quot;,&quot;).length ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {N} does not match 20-commas Header \\n&quot; );\n}\nif( myNumOfCols !== tplReceivableSales.split(&quot;,&quot;).length ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {P} does not match 20-commas Header \\n&quot; );\n}\nif( myNumOfCols !== tplReceivedSales.split(&quot;,&quot;).length ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {Q} does not match 20-commas Header \\n&quot; );\n}\nif( myNumOfCols !== tplPaymentReceivable.split(&quot;,&quot;).length ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {R} does not match 20-commas Header \\n&quot; );\n}\nif( myNumOfCols !== tplPaymentReceived.split(&quot;,&quot;).length ){\n  throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                   &quot; Config {S} does not match 20-commas Header \\n&quot; );\n}\n\nconst dataIdX = configs.get( &quot;conf_DataIdX&quot; ) + &quot;&quot;;\nconst dataIdY = configs.get( &quot;conf_DataIdY&quot; ) + &quot;&quot;;\n\nlet numEndMonth = 12;\nconst monthInt = \/^([1-9]|1[0-2])$\/; \/\/ RegExp: 1,2,,,11,12\nconst strEndMonth = configs.get( &quot;conf_EndMonth&quot; ) + &quot;&quot;;\nif( strEndMonth === &quot;&quot; ){\n  engine.log( &quot; AutomatedTask ConfigWarning:&quot; +\n              &quot; {Z:EndMonth} is 12 (default)&quot; );\n}else{\n  if( monthInt.test( strEndMonth ) ){\n    numEndMonth = parseInt(strEndMonth, 10);\n  }else{\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {Z:EndMonth} must be 1 to 12 \\n&quot; );\n  }\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nlet slipDescr = &quot;&quot;; \/\/ config required\nif( engine.findDataByNumber( dataIdA ) === null ){\n  engine.log( &quot; AutomatedTask StringWarning:&quot; +\n              &quot; {A} is empty&quot; );\n}else{\n  slipDescr = engine.findDataByNumber( dataIdA ) + &quot;&quot;;\n}\n\nlet salesAmtSingle       = engine.findDataByNumber( dataIdB ) - 0;  \/\/ null-0 -&gt; 0\nlet salesAmtMultiple     = engine.findDataByNumber( dataIdD ) - 0;\nlet salesAmtMultipleNum  = engine.findDataByNumber( dataIdF ) - 0;\nif( salesAmtSingle === 0 && salesAmtMultiple === 0){ \/\/Case 0: Error exit\n  throw new Error( &quot;\\n AutomatedTask UnexpectedError:&quot; +\n                   &quot; Both {B:salesAmtSingle} and {D:salesAmtMultiple} are zero \\n&quot; );\n}\n\nlet salesAmtSingleDate   = engine.findDataByNumber( dataIdC ) + &quot;&quot;;\nlet salesAmtMultipleDate = engine.findDataByNumber( dataIdE ) + &quot;&quot;;\n\nlet dueDate = &quot;&quot;; \/\/ config required\nif( engine.findDataByNumber( dataIdG ) === null ){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedDateError:&quot; +\n                   &quot; Date {G} is null \\n&quot; );\n}else{\n  dueDate = engine.findDataByNumber( dataIdG ) + &quot;&quot;;\n}\nconst dateDueDate = toJsDate( dueDate );\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/  [M] numMonthSerial (Serial Number, 1 means the first month of the fiscal year.)\n\/\/               01 02 03 04 05 06 07 08 09 10 11 12\n\/\/  EndMonth= 1: 12  1  2  3  4  5  6  7  8  9 10 11\n\/\/  EndMonth= 3: 10 11 12  1  2  3  4  5  6  7  8  9\n\/\/  EndMonth=12:  1  2  3  4  5  6  7  8  9 10 11 12\nconst dateToday = new Date();\nconst numMonthSerial = (dateToday.getMonth() + 12 - numEndMonth ) % 12 + 1;\n\/\/  [MDD] todaySerial\nconst todaySerial = numMonthSerial * 100 + dateToday.getDate();\n\/\/\/ &quot;\u53d6\u5f15No&quot; (tmpSlipId): 8or9\u6841 MDDyyyzz,\nlet tmpSlipId = todaySerial * 100000 +\n                (processInstance.getProcessInstanceId() % 1000) * 100;\n\nlet myTsv    = &quot;&quot;;\n\n\/\/Case 1: Only Single Sales \/ \u4e00\u62ec\u58f2\u4e0a\u3060\u3051\u306e\u5834\u5408\nif(salesAmtSingle !== 0 && salesAmtMultiple === 0){\n  let dateSalesAmtSingleDate = toJsDate( salesAmtSingleDate );\n  engine.log( &quot; AutomatedTask message:&quot; +\n              &quot; Single only&quot; );\n\n  if( dateSalesAmtSingleDate.getTime() &lt;= dateDueDate.getTime() ){\n    tmpSlipId++;\n    let tmpArrSales        = arrTplReceivableSingle.concat();\n    tmpArrSales[colSlipId] = tmpSlipId + &quot;&quot;;\n    tmpArrSales[colDate]   = funcDateStr( dateSalesAmtSingleDate, ymdFormat );\n    tmpArrSales[colDrAmt]  = salesAmtSingle;\n    tmpArrSales[colCrAmt]  = salesAmtSingle;\n    tmpArrSales[colSlipDescr] = slipDescr;\n    myTsv += tmpArrSales.join(&quot;\\t&quot;);\n    myTsv += &quot;\\n&quot;;\n\n    tmpSlipId++;\n    let tmpArrPay          = arrTplPaymentReceivable.concat();\n    tmpArrPay[colSlipId]   = tmpSlipId + &quot;&quot;;\n    tmpArrPay[colDate]     = funcDateStr( dateDueDate, ymdFormat );\n    tmpArrPay[colDrAmt]    = salesAmtSingle;\n    tmpArrPay[colCrAmt]    = salesAmtSingle;\n    tmpArrPay[colSlipDescr] = slipDescr;\n    myTsv += tmpArrPay.join(&quot;\\t&quot;);\n  }else{\n    tmpSlipId++;\n    let tmpArrSales        = arrTplReceivedSingle.concat();\n    tmpArrSales[colSlipId] = tmpSlipId + &quot;&quot;;\n    tmpArrSales[colDate]   = funcDateStr( dateSalesAmtSingleDate, ymdFormat );\n    tmpArrSales[colDrAmt]  = salesAmtSingle;\n    tmpArrSales[colCrAmt]  = salesAmtSingle;\n    tmpArrSales[colSlipDescr] = slipDescr;\n    myTsv += tmpArrSales.join(&quot;\\t&quot;);\n    myTsv += &quot;\\n&quot;;\n\n    tmpSlipId++;\n    let tmpArrPay          = arrTplPaymentReceived.concat();\n    tmpArrPay[colSlipId]   = tmpSlipId + &quot;&quot;;\n    tmpArrPay[colDate]     = funcDateStr( dateDueDate, ymdFormat );\n    tmpArrPay[colDrAmt]    = salesAmtSingle;\n    tmpArrPay[colCrAmt]    = salesAmtSingle;\n    tmpArrPay[colSlipDescr] = slipDescr;\n    myTsv += tmpArrPay.join(&quot;\\t&quot;);\n  }\n\n}\n\n\/\/Case 2:  Including Multiple Sales \/ \u5206\u5272\u58f2\u4e0a\u3092\u542b\u3080\u5834\u5408\nif(salesAmtMultiple !== 0){\n  if(salesAmtMultipleNum === 0){\n    throw new Error( &quot;\\n AutomatedTask UnexpectedConfigError:&quot; +\n                     &quot; &#39;0&#39; can not be used as division number. \\n&quot; );\n  }\n  engine.log( &quot; AutomatedTask message:&quot; +\n              &quot; Multiple &quot; + salesAmtMultipleNum );\n\n  \/\/ Subtotal of ReceivableSales and ReceivedSales\n  let myReceivableSales = 0;\n  let myReceivedSales = 0;\n\n  \/\/\/\/ Single\n  if(salesAmtSingle !== 0){\n    engine.log( &quot; AutomatedTask message:&quot; +\n                &quot; Multiple with Single&quot; );\n    let dateSalesAmtSingleDate = toJsDate( salesAmtSingleDate );\n\n    if( dateSalesAmtSingleDate.getTime() &lt;= dateDueDate.getTime() ){\n      tmpSlipId++;\n      let tmpArrSales        = arrTplReceivableSingle.concat();\n      tmpArrSales[colSlipId] = tmpSlipId + &quot;&quot;;\n      tmpArrSales[colDate]   = funcDateStr( dateSalesAmtSingleDate, ymdFormat );\n      tmpArrSales[colDrAmt]  = salesAmtSingle;\n      tmpArrSales[colCrAmt]  = salesAmtSingle;\n      tmpArrSales[colSlipDescr] = slipDescr;\n      myTsv += tmpArrSales.join(&quot;\\t&quot;);\n      myTsv += &quot;\\n&quot;;\n      myReceivableSales += salesAmtSingle;\n    }else{\n      tmpSlipId++;\n      let tmpArrSales        = arrTplReceivedSingle.concat();\n      tmpArrSales[colSlipId] = tmpSlipId + &quot;&quot;;\n      tmpArrSales[colDate]   = funcDateStr( dateSalesAmtSingleDate, ymdFormat );\n      tmpArrSales[colDrAmt]  = salesAmtSingle;\n      tmpArrSales[colCrAmt]  = salesAmtSingle;\n      tmpArrSales[colSlipDescr] = slipDescr;\n      myTsv += tmpArrSales.join(&quot;\\t&quot;);\n      myTsv += &quot;\\n&quot;;\n      myReceivedSales += salesAmtSingle;\n    }\n  }\n\n  \/\/\/\/ Multiple\n  \/\/ Sales for each month\n  \/\/ The remainder is added to the first month. \/ \u5546\u306e\u5270\u4f59\u306f\u521d\u6708\u306b\u52a0\u7b97\n  \/\/ &quot;101\/10&quot; is divided into &quot;10.10&quot; * 10, in the case of two decimal places.\n  \/\/ &quot;101\/10&quot; is divided into &quot;11&quot; * 1 and &quot;10&quot; * 9, in the case of 0 decimal place.\n  const monthlySalesFollow =\n        Math.floor( salesAmtMultiple \/ salesAmtMultipleNum * Math.pow(10, decimalPlaces) ) \/\n        Math.pow(10, decimalPlaces);\n  const monthlySalesFirst  =\n        salesAmtMultiple - monthlySalesFollow * ( salesAmtMultipleNum - 1 );\n  let arrSalesAmtMultipleDate  = new Array( salesAmtMultipleNum );\n\n  \/\/ First Month\n  arrSalesAmtMultipleDate[0]   = toJsDate( salesAmtMultipleDate );\n  if( arrSalesAmtMultipleDate[0].getTime() &lt;= dateDueDate.getTime() ){\n    tmpSlipId++;\n    let tmpArrSales        = arrTplReceivableSales.concat();\n    tmpArrSales[colSlipId] = tmpSlipId + &quot;&quot;;\n    tmpArrSales[colDate]   = funcDateStr( arrSalesAmtMultipleDate[0], ymdFormat );\n    tmpArrSales[colDrAmt]  = monthlySalesFirst;\n    tmpArrSales[colCrAmt]  = monthlySalesFirst;\n    tmpArrSales[colSlipDescr] =\n      funcMonthStr( arrSalesAmtMultipleDate[0] ) + &quot; @ &quot; + slipDescr;\n    myTsv += tmpArrSales.join(&quot;\\t&quot;);\n    myTsv += &quot;\\n&quot;;\n    myReceivableSales += monthlySalesFirst;\n  }else{\n    tmpSlipId++;\n    let tmpArrSales        = arrTplReceivedSales.concat();\n    tmpArrSales[colSlipId] = tmpSlipId + &quot;&quot;;\n    tmpArrSales[colDate]   = funcDateStr( arrSalesAmtMultipleDate[0], ymdFormat );\n    tmpArrSales[colDrAmt]  = monthlySalesFirst;\n    tmpArrSales[colCrAmt]  = monthlySalesFirst;\n    tmpArrSales[colSlipDescr] =\n      funcMonthStr( arrSalesAmtMultipleDate[0] ) + &quot; @ &quot; + slipDescr;\n    myTsv += tmpArrSales.join(&quot;\\t&quot;);\n    myTsv += &quot;\\n&quot;;\n    myReceivedSales += monthlySalesFirst;\n  }\n\n  \/\/ Following Months\n  \/\/ Record on 1st of each month \/ \u6b21\u6708\u4ee5\u964d\u306f1\u65e5\u306b\u58f2\u4e0a\u8a08\u4e0a\n  for( let i=1; i &lt; salesAmtMultipleNum; i++){\n    arrSalesAmtMultipleDate[i] = new Date(\n                                     arrSalesAmtMultipleDate[0].getFullYear(),\n                                     arrSalesAmtMultipleDate[0].getMonth() + i,\n                                     1); \/\/ 1st of each month\n    if( arrSalesAmtMultipleDate[i].getTime() &lt;= dateDueDate.getTime() ){\n      tmpSlipId++;\n      let tmpArrSales        = arrTplReceivableSales.concat();\n      tmpArrSales[colSlipId] = tmpSlipId + &quot;&quot;;\n      tmpArrSales[colDate]   = funcDateStr( arrSalesAmtMultipleDate[i], ymdFormat );\n      tmpArrSales[colDrAmt]  = monthlySalesFollow;\n      tmpArrSales[colCrAmt]  = monthlySalesFollow;\n      tmpArrSales[colSlipDescr] =\n        funcMonthStr( arrSalesAmtMultipleDate[i] ) + &quot; @ &quot; + slipDescr;\n      myTsv += tmpArrSales.join(&quot;\\t&quot;);\n      myTsv += &quot;\\n&quot;;\n      myReceivableSales += monthlySalesFollow;\n    }else{\n      tmpSlipId++;\n      let tmpArrSales        = arrTplReceivedSales.concat();\n      tmpArrSales[colSlipId] = tmpSlipId + &quot;&quot;;\n      tmpArrSales[colDate]   = funcDateStr( arrSalesAmtMultipleDate[i], ymdFormat );\n      tmpArrSales[colDrAmt]  = monthlySalesFollow;\n      tmpArrSales[colCrAmt]  = monthlySalesFollow;\n      tmpArrSales[colSlipDescr] =\n        funcMonthStr( arrSalesAmtMultipleDate[i] ) + &quot; @ &quot; + slipDescr;\n      myTsv += tmpArrSales.join(&quot;\\t&quot;);\n      myTsv += &quot;\\n&quot;;\n      myReceivedSales += monthlySalesFollow;\n    }\n  }\n  if(myReceivableSales !== 0 && myReceivedSales !== 0){\n    tmpSlipId++;\n    let tmpArrPay1         = arrTplPaymentReceivable.concat();\n    tmpArrPay1[colSlipId]  = tmpSlipId + &quot;&quot;;\n    tmpArrPay1[colDate]    = funcDateStr( dateDueDate, ymdFormat );\n    tmpArrPay1[colDrAmt]   = myReceivableSales + myReceivedSales;\n    tmpArrPay1[colCrAmt]   = myReceivableSales;\n    tmpArrPay1[colSlipDescr] = slipDescr;\n    myTsv += tmpArrPay1.join(&quot;\\t&quot;);\n    myTsv += &quot;\\n&quot;;\n    let tmpArrPay2         = arrTplPaymentReceived.concat();\n    tmpArrPay2[colSlipId]  = tmpSlipId + &quot;&quot;;\n    tmpArrPay2[colDate]    = funcDateStr( dateDueDate, ymdFormat );\n    tmpArrPay2[colDrAmt]   = 0;\n    tmpArrPay2[colCrAmt]   = myReceivedSales;\n    tmpArrPay2[colSlipDescr] = slipDescr;\n    myTsv += tmpArrPay2.join(&quot;\\t&quot;);\n  }else if(myReceivableSales === 0){\n    tmpSlipId++;\n    let tmpArrPay          = arrTplPaymentReceived.concat();\n    tmpArrPay[colSlipId]   = tmpSlipId + &quot;&quot;;\n    tmpArrPay[colDate]     = funcDateStr( dateDueDate, ymdFormat );\n    tmpArrPay[colDrAmt]    = myReceivableSales + myReceivedSales;\n    tmpArrPay[colCrAmt]    = myReceivedSales;\n    tmpArrPay[colSlipDescr] = slipDescr;\n    myTsv += tmpArrPay.join(&quot;\\t&quot;);\n  }else if(myReceivedSales === 0){\n    tmpSlipId++;\n    let tmpArrPay          = arrTplPaymentReceivable.concat();\n    tmpArrPay[colSlipId]   = tmpSlipId + &quot;&quot;;\n    tmpArrPay[colDate]     = funcDateStr( dateDueDate, ymdFormat );\n    tmpArrPay[colDrAmt]    = myReceivableSales + myReceivedSales;\n    tmpArrPay[colCrAmt]    = myReceivableSales;\n    tmpArrPay[colSlipDescr] = slipDescr;\n    myTsv += tmpArrPay.join(&quot;\\t&quot;);\n  }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( dataIdX !== &quot;&quot; ){\n  engine.setDataByNumber( dataIdX, myTsv );\n}\nif( dataIdY !== &quot;&quot; ){\n  let outputFiles = engine.findDataByNumber( dataIdY ); \n  \/\/ java.util.ArrayList\n  \/\/ - com.questetra.bpms.core.event.scripttask.QfileView\n  if( outputFiles === null ){\n    outputFiles = new java.util.ArrayList();\n  }\n  let strSjisCsv = headerRow + &quot;\\n&quot; +\n                   myTsv.replace( \/,\/g, &quot;&quot; ).replace( \/\\t\/g, &quot;,&quot; );\n  outputFiles.add(\n    new com.questetra.bpms.core.event.scripttask.NewQfile(\n      (processInstance.getProcessInstanceId() + &quot;.csv&quot;),  \/\/ fileName\n      &quot;text\/comma-separated-values; charset=Shift_JIS&quot;,   \/\/ for sjis\n      strSjisCsv\n    )\n  );\n  engine.setDataByNumber( dataIdY, outputFiles );\n}\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\nfunction funcDateStr( dateObj, formatStr ){\n  formatStr = formatStr.replace(\/YYYY\/g, dateObj.getFullYear());\n  formatStr = formatStr.replace(\/MM\/g,   (&#39;00&#39; + (dateObj.getMonth() + 1)).slice(-2));\n  formatStr = formatStr.replace(\/DD\/g,   (&#39;00&#39; +  dateObj.getDate()).slice(-2));\n  return formatStr;\n}\n\nfunction funcMonthStr( dateObj ){\n  let myStr = dateObj.getFullYear() + &quot;-&quot; + (&quot;00&quot; + (dateObj.getMonth()+1)).slice(-2);\n  return myStr;\n}\n\nfunction toJsDate( bpmsDateOrDatetimeStr ){\n  \/\/ BPMS Date:     &quot;2020-04-01&quot;\n  \/\/ BPMS Datetime: &quot;2020-04-01 23:59&quot;\n\n  let year       = 0;\n  let monthIndex = 0;\n  let day        = 0;\n  let hours      = 0;\n  let minutes    = 0;\n\n  \/\/  The Date object has a large number of methods.\n  \/\/ &quot;Date.parse&quot; is danger (strongly discouraged)\n  \/\/ - new Date(&quot;2014-11-10&quot;) \/\/ Mon Nov 10 2014 09:00:00 GMT+0900 (JST)\n  \/\/ - new Date(2014, 10, 10) \/\/ Mon Nov 10 2014 00:00:00 GMT+0900 (JST)\n  let arrDatetime = bpmsDateOrDatetimeStr.split(&quot; &quot;);\n  if( arrDatetime.length === 1 ){\n    let arrDateParts = arrDatetime[0].split(&quot;-&quot;);\n    year       = parseInt(arrDateParts[0], 10);\n    monthIndex = parseInt(arrDateParts[1], 10) - 1;\n    day        = parseInt(arrDateParts[2], 10);\n  }\n  if( arrDatetime.length === 2 ){\n    let arrDateParts = arrDatetime[0].split(&quot;-&quot;);\n    let arrTimeParts = arrDatetime[1].split(&quot;:&quot;);\n    year       = parseInt(arrDateParts[0], 10);\n    monthIndex = parseInt(arrDateParts[1], 10) - 1;\n    day        = parseInt(arrDateParts[2], 10);\n    hours      = parseInt(arrTimeParts[0], 10);\n    minutes    = parseInt(arrTimeParts[1], 10);\n  }\n\n  return new Date( year, monthIndex, day, hours, minutes );\n}\n\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAEVElEQVRYR8WXe0yVdRjHPy+3AyeF\nUmLeEAZeQk6kWOaWYbrSLrISDk5QqaAVh9VC12b6B65WMoqVJQpBWZumKw5aUSNl6qKagQgGRkuR\nBDUuXhBU7vBr73vO6RzOnaLx++9939\/zPN\/neb6\/7\/N7JcZ5SW7Hjy1R49MXh8QyYAGIUJDuMtiL\nDpAuADUIjtOvOkhJbLc7vl0DSPhyCsJzM4g0wNcdp0AvSPlIQ9kUrWl1ZuMcQLw+DUnkgHSHm4Gt\ntonbCOk1irX5juwdA0go3o0Qun8X2MpKkvIoik+358s+AK1+P5A4JsHNTg6g1yZZ+7QFMJaZ20Sz\nrcRIAErPyRuLzDfEzGRJRCAHKy5z+HSb2aVAZ8kJMwCF7VKDI8ItnjOJTatm82hUEHeqfZCMlr0D\nQ9Q1dbGztIG95c1KoPSV4WSv1zDB14u2zj6e31VFaY3pMIjbSGKW6XSYAWiL3weRYS\/7txIjefnx\ncALU3g6LMzgkKKtt48WPqklZFsrWuHtQeXvQ2T1AemEN+3+6aGEr7UAfv1F+YQAgi4yq75q9c16Y\nFk3y0hB8vDxcdkYIqG3qJOOzX3k7MZLIYH\/K66+y7sNKbvYMWtr30qeaLIuVAUC8fj0Se60j6FaE\nkbVOYzdzOVhP\/5DSCj8fT4MeCjha105czgnrgLbgBRso1u4zANDqPwFSLHdN9PPi2LYY7g83qq2V\ni98udrHmvQr81V4UvBTNvTMDONdyi2feOUH9pS6X1QL2oNemmgBUG\/TdvJ57JIQPUu7D38+278NC\nUFD2J7rCGsXgiQVTyErSkF\/WSP6RRuZMnUDI3WrKatudAalBr402Aii6bh4sBpvc1PnoVobhYaR7\nXXOnEnD1ouloF0\/nlT2nKalqsRtA7v\/DEYHEZP7gBIDoQJ8wyVQBYb3zY91CUpeHKq\/7B4fJ\/uoP\nMr+oV56ffmAaX5\/8y67ztQ8Fs+uF+bTe6CVyY5nzVui1xvS0eqcAmq50s3ZHBb+cvT7CoawN2xM1\nvPvNWeWcz5vhz4GMRUSFBCg8GAUA2xbkJEfx6pOz8PKU+K66lVVZP9tks2X1XDITIrja1U\/ekUYe\niwoiZl6g0rbqxhss3HzU7RY4JKGnh8Tr+86Q+\/15hWxxD07jjaLfuXSth\/I3lyq9tl7ycfz0+AVS\n8065S0L7x7B06xJCg9Qk7zzJsTNXFGKmrQijofWWogGa4AClQtarvbOPtIJqDlXa54lxv8UxdCBE\nKctDFUX79lSLomjbkzTMmOznlFhDw4LPf2zm2dwq5wQcIUROpFgGsCl2Nr7eBrVztkahhFZSLHt1\nMozkKbglbi6BE1UO48vD6FDlZaXvVrpvx8Z6GMlbXIxjufTbEiJ4KnoqQQEqZHLKGd\/sHaDyXAe7\nD5931XMjEEfjWP48hhcSh6VyeCExWYzrlcwEYlwvpf9HJUZ9LTeBGNcfk38qMZ6\/ZpZUHrefU1fy\n9x+\/\/w06a8wwleGinwAAAABJRU5ErkJggg==\n\" alt=\"\"\/><\/a><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/file\/d\/1A6_nohm3jmI7temE3BSXVuipxTH4InCK\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">MoneyForward-Journal-Create-2021.xml<\/a><\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-08-03 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create-2021\/\">https:\/\/support.questetra.com\/addons\/moneyforward-journal-create-2021\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Add-on import feature is available with <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>&#8220;Transaction No.&#8221;<ul><li>The slip generated on April 1 = 8 digits of &#8220;401yyyzz&#8221; (if the closing month is 12).<\/li><li>The slip generated on April 1 = 8 digits of &#8220;101yyyzz&#8221; (if the closing month is 3).<\/li><li>The slip generated on March 31 = 9 digits &#8220;1231yyyzz&#8221; (if the closing month is 3).<\/li><li>The yyy part is the last three digits of {process ID}.<\/li><li>The zz part is the split ID (01,02, \u2026).<\/li><li>It may be renumbered when imported to MF.<\/li><li>The Transaction No. in the manual entry will be an incremental value.<\/li><\/ul><\/li><li>No header row is added to the generated journal TSV (because it is expected to be added to the Sheet).<\/li><li>The following 21 items are posted in the header line of the Journal Excel-CSV<ul><li>[0] Transaction No, [1] Transaction Date,<\/li><li>[2] Debit account, [3] Debit sub-item, [4] Debit tax classification,<\/li><li>[5] Debit department, [6] Debit amount (yen), [7] Debit tax amount,<\/li><li>[8] Credit account, [9] Credit sub-item, [10] Credit tax classification,<\/li><li>[11] Credit department, [12] Credit amount (yen), [13] Credit tax amount,<\/li><li>[14] Description, [15] Journal memo, [16] Tag, [17] MF journal type,<\/li><li>[18] Closing journal, [19] Creation date, [20] Last update date<\/li><\/ul><\/li><li>#Money Forward journal_sample.csv<ul><li><a href=\"https:\/\/support.biz.moneyforward.com\/account\/guide\/import-books\/ib01.html\" rel=\"nofollow\">https:\/\/support.biz.moneyforward.com\/account\/guide\/import-books\/ib01.html<\/a><\/li><\/ul><\/li><li>The summary of the split sales records will be formatted as &#8220;2020-04 @ {Description}&#8221;.<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/moneyforward-journal-en-1.png?ssl=1\" alt=\"\" class=\"wp-image\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/moneyforward-journal-en-2.png?ssl=1\" alt=\"\" class=\"wp-image\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener noreferrer\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"87051\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create\/attachment\/moneyforward-journal-create-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"MoneyForward-Journal-Create-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only invoices that are booked as single sales record, but also invoices that are booked as monthly sales records.\" class=\"wp-image-87051\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"87054\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create\/attachment\/moneyforward-journal-create2-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"MoneyForward-Journal-Create2-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i2.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?fit=1024%2C576&amp;ssl=1\" alt=\"Journal Slips, Generate Automatically\" class=\"wp-image-87054\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"W3wKqx6jMS\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/fiscal-month-day-string-create-2021\/\">Fiscal Month-Day String, Create<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Fiscal Month-Day String, Create&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/fiscal-month-day-string-create-2021\/embed\/#?secret=I0tGJiUtYN#?secret=W3wKqx6jMS\" data-secret=\"W3wKqx6jMS\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"h2cmMujdfB\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-append-tsv\/\">Google Sheets: Sheet, Append TSV<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Google Sheets: Sheet, Append TSV&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/google-sheets-sheet-append-tsv\/embed\/#?secret=UDOrs8WPip#?secret=h2cmMujdfB\" data-secret=\"h2cmMujdfB\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only batch sales invoices but also invoices that are prorated for each month.<\/p>\n","protected":false},"author":3,"featured_media":87049,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[382,389],"faq_section":[],"class_list":["post-110776","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-date","tag-tsv-csv"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Hirotaka NISHI","author_link":"https:\/\/support.questetra.com\/en\/author\/nishiquestetra\/"},"uagb_comment_info":1,"uagb_excerpt":"Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only batch sales invoices but also invoices that are prorated for each month.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-sOI","jetpack-related-posts":[{"id":87048,"url":"https:\/\/support.questetra.com\/en\/addons\/moneyforward-journal-create\/","url_meta":{"origin":110776,"position":0},"title":"MoneyForward Journal, Create","author":"IMAMURA, Genichi","date":"2020-04-09","format":false,"excerpt":"Creates the Journal-Slips (TSV or Excel) for MoneyForward Cloud Accounting. It supports not only invoices that are booked as single sales record, but also invoices that are booked as monthly sales records.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"MoneyForward Journal, Create","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":73398,"url":"https:\/\/support.questetra.com\/en\/addons\/journal-tsv-create\/","url_meta":{"origin":110776,"position":1},"title":"Journal-TSV Create","author":"IMAMURA, Genichi","date":"2018-12-12","format":false,"excerpt":"Creates the Journal-Slip TSV. The transfer slip TSV of the sales is generated based on the Invoice data. To generate a file that can be imported into the accounting system, place a converter such as \"TSV to Excel-CSV FILE\" in the downstream process.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":70808,"url":"https:\/\/support.questetra.com\/en\/addons\/journaltsv-generator\/","url_meta":{"origin":110776,"position":2},"title":"Journal Slip TSV from Invoice Data","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"Generate transfer slip TSV (tab-separated-values) with sales amount, sales date, due date. It supports cases where add a sales collectively or divided into several months or mixture of those. In order to generate a file for the accounting system, you need to place a converter such as \"TSV to Excel-CSV\u2026","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/journal-tsv-generator-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/journal-tsv-generator-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/journal-tsv-generator-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/journal-tsv-generator-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/journal-tsv-generator-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69591,"url":"https:\/\/support.questetra.com\/en\/addons\/generate-transferslips\/","url_meta":{"origin":110776,"position":3},"title":"Generate Transfer Slips","author":"Hirotaka NISHI","date":"2016-09-08","format":false,"excerpt":"Regarding to the down payment for long-term service, stores sales transfer slip data for the number of months of contract into a data item","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/generate-transfer-slips-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/generate-transfer-slips-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/generate-transfer-slips-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/generate-transfer-slips-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/generate-transfer-slips-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":87057,"url":"https:\/\/support.questetra.com\/ja\/addons\/moneyforward-journal-create\/","url_meta":{"origin":110776,"position":4},"title":"\u30de\u30cd\u30fc\u30d5\u30a9\u30ef\u30fc\u30c9\u4ed5\u8a33\u4f1d\u7968, \u751f\u6210","author":"IMAMURA, Genichi","date":"2020-04-09","format":false,"excerpt":"MoneyForward\u30af\u30e9\u30a6\u30c9\u4f1a\u8a08\u7528\u306e\u4ed5\u8a33\u4f1d\u7968\uff08TSV or Excel\uff09\u3092\u751f\u6210\u3057\u307e\u3059\u3002\u4e00\u62ec\u3057\u3066\u58f2\u4e0a\u8a08\u4e0a\u3055\u308c\u308b\u8acb\u6c42\u66f8\u3060\u3051\u3067\u306a\u304f\u5404\u6708\u306b\u6309\u5206\u8a08\u4e0a\u3055\u308c\u308b\u8acb\u6c42\u66f8\u306b\u3082\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u3002\u306a\u304a\u3001\u58f2\u4e0a\u8a08\u4e0a\u65e5\u304c\u300c\u4e88\u5b9a\u5165\u91d1\u65e5\u300d\u3088\u308a\u672a\u6765\u306b\u306a\u308b\u58f2\u4e0a\u4f1d\u7968\u306e\u52d8\u5b9a\u79d1\u76ee\u306f \"\u58f2\u639b\u91d1\u58f2\u4e0a\" \u3067\u306f\u306a\u304f \"\u524d\u53d7\u91d1\u58f2\u4e0a\" \u3068\u5224\u65ad\u3055\u308c\u307e\u3059\u3002\u307e\u305f\u3001\u8acb\u6c42\u91d1\u984d\u3092\u6309\u5206\u3057\u305f\u969b\u306e\u5270\u4f59\uff08\u7aef\u6570\uff09\u306f\u521d\u6708\u58f2\u4e0a\u30ec\u30b3\u30fc\u30c9\u306b\u52a0\u7b97\u3055\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"\u30de\u30cd\u30fc\u30d5\u30a9\u30ef\u30fc\u30c9\u4ed5\u8a33\u4f1d\u7968, \u751f\u6210","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":73405,"url":"https:\/\/support.questetra.com\/ja\/addons\/journal-tsv-create\/","url_meta":{"origin":110776,"position":5},"title":"\u4ed5\u8a33\u4f1d\u7968TSV \u751f\u6210","author":"IMAMURA, Genichi","date":"2018-12-12","format":false,"excerpt":"\u4ed5\u8a33\u4f1d\u7968TSV\u3092\u751f\u6210\u3057\u307e\u3059\u3002\u8acb\u6c42\u30c7\u30fc\u30bf\uff08\u58f2\u4e0a\u91d1\u984d\u30fb\u58f2\u4e0a\u65e5\u30fb\u6c7a\u6e08\u4e88\u5b9a\u65e5\uff09\u3092\u5143\u306b\u3001\u58f2\u4e0a\u91d1\u306e\u632f\u66ff\u4f1d\u7968TSV\uff08text\/tab-separated-values\uff09\u304c\u751f\u6210\u3055\u308c\u307e\u3059\u3002\u4e00\u62ec\u3057\u3066\u58f2\u4e0a\u8a08\u4e0a\u3059\u308b\u30b1\u30fc\u30b9\u3001\u6570\u304b\u6708\u306b\u5206\u3051\u3066\u58f2\u4e0a\u5206\u5272\u3059\u308b\u30b1\u30fc\u30b9\u3001\u305d\u308c\u3089\u304c\u8907\u5408\u3059\u308b\u30b1\u30fc\u30b9\u306b\u5bfe\u5fdc\u3057\u307e\u3059\uff08\u5206\u5272\u5270\u4f59\u306f\u521d\u6708\u306b\u52a0\u7b97\uff09\u3002 \u4f1a\u8a08\u30b7\u30b9\u30c6\u30e0\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u53ef\u80fd\u306a\u30d5\u30a1\u30a4\u30eb\u3092\u751f\u6210\u3055\u305b\u308b\u306f\u3001\u4e0b\u6d41\u5de5\u7a0b\u306b\u300cTSV to Excel-CSV FILE\u300d\u306a\u3069\u306e\u30b3\u30f3\u30d0\u30fc\u30bf\u3092\u914d\u7f6e\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/12\/journal-tsv-create.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/110776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=110776"}],"version-history":[{"count":10,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/110776\/revisions"}],"predecessor-version":[{"id":114677,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/110776\/revisions\/114677"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/87049"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=110776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=110776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=110776"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=110776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}