\u30de\u30cd\u30fc\u30d5\u30a9\u30ef\u30fc\u30c9\u4ed5\u8a33\u4f1d\u7968, \u751f\u6210 (MoneyForward Journal, Create)<\/div>
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<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- <\/i><\/span> A: \u4f1d\u7968\u306e\u6458\u8981\u540d\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span><\/li>\n
- <\/i><\/span> B: \u58f2\u4e0a\u9ad8\uff08\u4e00\u62ec\u8a08\u4e0a\u5206\uff09\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n
- <\/i><\/span> C: \u58f2\u4e0a\u65e5\uff08\u4e00\u62ec\u8a08\u4e0a\u5206\uff09\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n
- <\/i><\/span> D: \u58f2\u4e0a\u9ad8\uff08\u5206\u5272\u8a08\u4e0a\u5206\uff09\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n
- <\/i><\/span> E: \u521d\u56de\u306e\u58f2\u4e0a\u65e5\uff08\u5206\u5272\u8a08\u4e0a\u5206\uff09\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u6b21\u6708\u4ee5\u964d\u306f1\u65e5\u4ed8\u3067\u8a08\u4e0a\uff09<\/li>\n
- <\/i><\/span> F: \u5206\u5272\u8a08\u4e0a\u306e\u5206\u5272\u6570\uff08\u6708\u6570\uff09\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n
- <\/i><\/span> G: \u6c7a\u6e08\u4e88\u5b9a\u65e5\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span><\/li>\n
- <\/i><\/span> M: \u58f2\u639b\u91d1\u58f2\u4e0a\u884c\uff08\u4e00\u62ec\uff09\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u672a\u8a2d\u5b9a\u306e\u5834\u5408\uff1a”,,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,,\u58f2\u4e0a\u9ad8,\u2026”\uff09#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> N: \u524d\u53d7\u91d1\u58f2\u4e0a\u884c\uff08\u4e00\u62ec\uff09\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u672a\u8a2d\u5b9a\u306e\u5834\u5408\uff1a”,,\u524d\u53d7\u91d1,,\u5bfe\u8c61\u5916,,,,\u58f2\u4e0a\u9ad8,\u2026”\uff09#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> P: \u58f2\u639b\u91d1\u58f2\u4e0a\u884c\uff08\u5206\u5272\uff09\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u672a\u8a2d\u5b9a\u306e\u5834\u5408\uff1a”,,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,,\u58f2\u4e0a\u9ad8,\u2026”\uff09#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> Q: \u524d\u53d7\u91d1\u58f2\u4e0a\u884c\uff08\u5206\u5272\uff09\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u672a\u8a2d\u5b9a\u306e\u5834\u5408\uff1a”,,\u524d\u53d7\u91d1,,\u5bfe\u8c61\u5916,,,,\u58f2\u4e0a\u9ad8,\u2026”\uff09#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> R: \u58f2\u639b\u91d1\u56de\u53ce\u884c\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u672a\u8a2d\u5b9a\u306e\u5834\u5408\uff1a”,,\u666e\u901a\u9810\u91d1,\u2026,\u58f2\u639b\u91d1,\u2026\u672a\u5b9f\u73fe,,,”\uff09#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> S: \u524d\u53d7\u91d1\u56de\u53ce\u884c\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u672a\u8a2d\u5b9a\u306e\u5834\u5408\uff1a”,,\u666e\u901a\u9810\u91d1,\u2026,\u524d\u53d7\u91d1,\u2026\u672a\u5b9f\u73fe,,,”\uff09#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> X: \u4ed5\u8a33TSV\u304c\u683c\u7d0d\u3055\u308c\u308b\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u66f4\u65b0\uff09<\/li>\n
- <\/i><\/span> Y: \u4ed5\u8a33Excel-CSV\u304c\u683c\u7d0d\u3055\u308c\u308b\u30d5\u30a1\u30a4\u30eb\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u66f4\u65b0\uff09<\/li>\n
- <\/i><\/span> Z: \u6c7a\u7b97\u6708\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 (\u4f8b 3\u6708\u6c7a\u7b97\u306e\u5834\u5408 “3” )#{EL}<\/sup><\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\/\/ \n\/\/ Notes:\n\/\/ "Transaction No."\n\/\/ - The slip generated on April 1 = 8 digits of "401yyyzz" (closing month "12").\n\/\/ - The slip generated on April 1 = 8 digits of "101yyyzz" (closing month "3").\n\/\/ - The slip generated on March 31 = 9 digits "1231yyyzz" (closing month "3").\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\/\/ - "Transaction No." such as "manual entry" will be the increment value.\n\/\/ No header row is added to the generated "journal TSV". (for Sheet Append)\n\/\/ The following 21 items are posted in the header line of "Journal Excel-CSV"\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 "2020-04 @ {Description}".\n\/\/\n\/\/ Notes (ja):\n\/\/ "\u53d6\u5f15No" \u306f\u3001\n\/\/ - 4\u67081\u65e5\u306b\u751f\u6210\u3055\u308c\u308b\u4f1d\u7968\u306f\u3001\u6c7a\u7b97\u6708\u304c"12"\u306e\u5834\u5408 "401yyyzz" \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 "3"\u306e\u5834\u5408 "101yyyzz" \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"3"\u306e\u5834\u5408"1231yyyzz" \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 "\u53d6\u5f15No" \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 "2020-04 @ {\u6458\u8981}" \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 "[0],[1],[6],[12],[14]" \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 "\u672a\u5b9f\u73fe" \u306b\u3057\u305f\u3044\u5834\u5408\n\/\/ -- ",,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,\u672a\u5b9f\u73fe,,,"\n\/\/ - \u524d\u53d7\u91d1\u58f2\u4e0a\u4f1d\u7968\u306e\u300e[3]\u501f\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 "\u53d6\u5f15\u5148" \u306b\u300e[9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 "\u5546\u54c1\u7a2e" \u306b\n\/\/ -- ",,\u524d\u53d7\u91d1,#{#q_Billto},\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,#{#q_Product},\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,"\n\/\/ - \u58f2\u639b\u91d1\u56de\u53ce\u4f1d\u7968\u306e\u300e[9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 "\u53d6\u5f15\u5148" \u306b\u3057\u3001\u30bf\u30a4\u30d7\u3092 "\u672a\u5b9f\u73fe" \u306b\n\/\/ -- ",,\u666e\u901a\u8caf\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u639b\u91d1,#{#q_Billto},\u5bfe\u8c61\u5916,,,0,,,,\u672a\u5b9f\u73fe,,,"\n\/\/ - \u524d\u53d7\u91d1\u56de\u53ce\u4f1d\u7968\u306e\u300e[9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 "\u53d6\u5f15\u5148" \u306b\u3057\u3001\u30bf\u30a4\u30d7\u3092 "\u672a\u5b9f\u73fe" \u306b\n\/\/ -- ",,\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,,,"\n\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){\n\n\/\/\/\/ == for "MoneyForward\u30af\u30e9\u30a6\u30c9\u4f1a\u8a08" ==\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 "\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," +\n "\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," +\n "\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";\nconst colSlipId = 0; \/\/ "\u53d6\u5f15No" \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 0\uff09\nconst colDate = 1; \/\/ "\u53d6\u5f15\u65e5" \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 1\uff09\nconst ymdFormat = "YYYY\/MM\/DD"; \/\/ \u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\uff08MoneyForward\u306e\u5834\u5408\u306f "YYYY\/MM\/DD"\uff09\nconst colDrAmt = 6; \/\/ "\u501f\u65b9\u91d1\u984d" \u306e\u30bb\u30eb\u4f4d\u7f6e\uff08MoneyForward\u306e\u5834\u5408\u306f 6\uff09\nconst colCrAmt = 12; \/\/ "\u8cb8\u65b9\u91d1\u984d" \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; \/\/ "\u6458\u8981" \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( "conf_DataIdA" ) + ""; \/\/ required\nconst dataIdB = configs.get( "conf_DataIdB" ) + "";\nconst dataIdC = configs.get( "conf_DataIdC" ) + "";\nconst dataIdD = configs.get( "conf_DataIdD" ) + "";\nconst dataIdE = configs.get( "conf_DataIdE" ) + "";\nconst dataIdF = configs.get( "conf_DataIdF" ) + "";\nconst dataIdG = configs.get( "conf_DataIdG" ) + ""; \/\/ required\n\nlet tplReceivableSingle = configs.get( "conf_TplReceivableSingle" ) + "";\n if( tplReceivableSingle === ""){\n tplReceivableSingle = ",,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,";}\n const arrTplReceivableSingle = tplReceivableSingle.split(",");\nlet tplReceivedSingle = configs.get( "conf_TplReceivedSingle" ) + "";\n if( tplReceivedSingle === ""){\n tplReceivedSingle = ",,\u524d\u53d7\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,";}\n const arrTplReceivedSingle = tplReceivedSingle.split(",");\nlet tplReceivableSales = configs.get( "conf_TplReceivableSales" ) + "";\n if( tplReceivableSales === ""){\n tplReceivableSales = ",,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,";}\n const arrTplReceivableSales = tplReceivableSales.split(",");\nlet tplReceivedSales = configs.get( "conf_TplReceivedSales" ) + "";\n if( tplReceivedSales === ""){\n tplReceivedSales = ",,\u524d\u53d7\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,";}\n const arrTplReceivedSales = tplReceivedSales.split(",");\nlet tplPaymentReceivable = configs.get( "conf_TplPaymentReceivable" ) + "";\n if( tplPaymentReceivable === ""){\n tplPaymentReceivable = ",,\u666e\u901a\u9810\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,,,,,,,";}\n const arrTplPaymentReceivable = tplPaymentReceivable.split(",");\nlet tplPaymentReceived = configs.get( "conf_TplPaymentReceived" ) + "";\n if( tplPaymentReceived === ""){\n tplPaymentReceived = ",,\u666e\u901a\u9810\u91d1,,\u5bfe\u8c61\u5916,,,0,\u524d\u53d7\u91d1,,\u5bfe\u8c61\u5916,,,0,,,,,,,";}\n const arrTplPaymentReceived = tplPaymentReceived.split(",");\nif( myNumOfCols !== tplReceivableSingle.split(",").length ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {M} does not match 20-commas Header \\n" );\n}\nif( myNumOfCols !== tplReceivedSingle.split(",").length ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {N} does not match 20-commas Header \\n" );\n}\nif( myNumOfCols !== tplReceivableSales.split(",").length ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {P} does not match 20-commas Header \\n" );\n}\nif( myNumOfCols !== tplReceivedSales.split(",").length ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {Q} does not match 20-commas Header \\n" );\n}\nif( myNumOfCols !== tplPaymentReceivable.split(",").length ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {R} does not match 20-commas Header \\n" );\n}\nif( myNumOfCols !== tplPaymentReceived.split(",").length ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {S} does not match 20-commas Header \\n" );\n}\n\nconst dataIdX = configs.get( "conf_DataIdX" ) + "";\nconst dataIdY = configs.get( "conf_DataIdY" ) + "";\n\nlet numEndMonth = 12;\nconst monthInt = \/^([1-9]|1[0-2])$\/; \/\/ RegExp: 1,2,,,11,12\nconst strEndMonth = configs.get( "conf_EndMonth" ) + "";\nif( strEndMonth === "" ){\n engine.log( " AutomatedTask ConfigWarning:" +\n " {Z:EndMonth} is 12 (default)" );\n}else{\n if( monthInt.test( strEndMonth ) ){\n numEndMonth = parseInt(strEndMonth, 10);\n }else{\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {Z:EndMonth} must be 1 to 12 \\n" );\n }\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nlet slipDescr = ""; \/\/ config required\nif( engine.findDataByNumber( dataIdA ) === null ){\n engine.log( " AutomatedTask StringWarning:" +\n " {A} is empty" );\n}else{\n slipDescr = engine.findDataByNumber( dataIdA ) + "";\n}\n\nlet salesAmtSingle = engine.findDataByNumber( dataIdB ) - 0; \/\/ null-0 -> 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( "\\n AutomatedTask UnexpectedError:" +\n " Both {B:salesAmtSingle} and {D:salesAmtMultiple} are zero \\n" );\n}\n\nlet salesAmtSingleDate = engine.findDataByNumber( dataIdC ) + "";\nlet salesAmtMultipleDate = engine.findDataByNumber( dataIdE ) + "";\n\nlet dueDate = ""; \/\/ config required\nif( engine.findDataByNumber( dataIdG ) === null ){\n throw new Error( "\\n AutomatedTask UnexpectedDateError:" +\n " Date {G} is null \\n" );\n}else{\n dueDate = engine.findDataByNumber( dataIdG ) + "";\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\/\/\/ "\u53d6\u5f15No" (tmpSlipId): 8or9\u6841 MDDyyyzz,\nlet tmpSlipId = todaySerial * 100000 +\n (processInstance.getProcessInstanceId() % 1000) * 100;\n\nlet myTsv = "";\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( " AutomatedTask message:" +\n " Single only" );\n\n if( dateSalesAmtSingleDate.getTime() <= dateDueDate.getTime() ){\n tmpSlipId++;\n let tmpArrSales = arrTplReceivableSingle.concat();\n tmpArrSales[colSlipId] = tmpSlipId + "";\n tmpArrSales[colDate] = funcDateStr( dateSalesAmtSingleDate, ymdFormat );\n tmpArrSales[colDrAmt] = salesAmtSingle;\n tmpArrSales[colCrAmt] = salesAmtSingle;\n tmpArrSales[colSlipDescr] = slipDescr;\n myTsv += tmpArrSales.join("\\t");\n myTsv += "\\n";\n\n tmpSlipId++;\n let tmpArrPay = arrTplPaymentReceivable.concat();\n tmpArrPay[colSlipId] = tmpSlipId + "";\n tmpArrPay[colDate] = funcDateStr( dateDueDate, ymdFormat );\n tmpArrPay[colDrAmt] = salesAmtSingle;\n tmpArrPay[colCrAmt] = salesAmtSingle;\n tmpArrPay[colSlipDescr] = slipDescr;\n myTsv += tmpArrPay.join("\\t");\n }else{\n tmpSlipId++;\n let tmpArrSales = arrTplReceivedSingle.concat();\n tmpArrSales[colSlipId] = tmpSlipId + "";\n tmpArrSales[colDate] = funcDateStr( dateSalesAmtSingleDate, ymdFormat );\n tmpArrSales[colDrAmt] = salesAmtSingle;\n tmpArrSales[colCrAmt] = salesAmtSingle;\n tmpArrSales[colSlipDescr] = slipDescr;\n myTsv += tmpArrSales.join("\\t");\n myTsv += "\\n";\n\n tmpSlipId++;\n let tmpArrPay = arrTplPaymentReceived.concat();\n tmpArrPay[colSlipId] = tmpSlipId + "";\n tmpArrPay[colDate] = funcDateStr( dateDueDate, ymdFormat );\n tmpArrPay[colDrAmt] = salesAmtSingle;\n tmpArrPay[colCrAmt] = salesAmtSingle;\n tmpArrPay[colSlipDescr] = slipDescr;\n myTsv += tmpArrPay.join("\\t");\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( "\\n AutomatedTask UnexpectedConfigError:" +\n " '0' can not be used as division number. \\n" );\n }\n engine.log( " AutomatedTask message:" +\n " Multiple " + 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( " AutomatedTask message:" +\n " Multiple with Single" );\n let dateSalesAmtSingleDate = toJsDate( salesAmtSingleDate );\n\n if( dateSalesAmtSingleDate.getTime() <= dateDueDate.getTime() ){\n tmpSlipId++;\n let tmpArrSales = arrTplReceivableSingle.concat();\n tmpArrSales[colSlipId] = tmpSlipId + "";\n tmpArrSales[colDate] = funcDateStr( dateSalesAmtSingleDate, ymdFormat );\n tmpArrSales[colDrAmt] = salesAmtSingle;\n tmpArrSales[colCrAmt] = salesAmtSingle;\n tmpArrSales[colSlipDescr] = slipDescr;\n myTsv += tmpArrSales.join("\\t");\n myTsv += "\\n";\n myReceivableSales += salesAmtSingle;\n }else{\n tmpSlipId++;\n let tmpArrSales = arrTplReceivedSingle.concat();\n tmpArrSales[colSlipId] = tmpSlipId + "";\n tmpArrSales[colDate] = funcDateStr( dateSalesAmtSingleDate, ymdFormat );\n tmpArrSales[colDrAmt] = salesAmtSingle;\n tmpArrSales[colCrAmt] = salesAmtSingle;\n tmpArrSales[colSlipDescr] = slipDescr;\n myTsv += tmpArrSales.join("\\t");\n myTsv += "\\n";\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 \/\/ "101\/10" is divided into "10.10" * 10, in the case of two decimal places.\n \/\/ "101\/10" is divided into "11" * 1 and "10" * 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() <= dateDueDate.getTime() ){\n tmpSlipId++;\n let tmpArrSales = arrTplReceivableSales.concat();\n tmpArrSales[colSlipId] = tmpSlipId + "";\n tmpArrSales[colDate] = funcDateStr( arrSalesAmtMultipleDate[0], ymdFormat );\n tmpArrSales[colDrAmt] = monthlySalesFirst;\n tmpArrSales[colCrAmt] = monthlySalesFirst;\n tmpArrSales[colSlipDescr] =\n funcMonthStr( arrSalesAmtMultipleDate[0] ) + " @ " + slipDescr;\n myTsv += tmpArrSales.join("\\t");\n myTsv += "\\n";\n myReceivableSales += monthlySalesFirst;\n }else{\n tmpSlipId++;\n let tmpArrSales = arrTplReceivedSales.concat();\n tmpArrSales[colSlipId] = tmpSlipId + "";\n tmpArrSales[colDate] = funcDateStr( arrSalesAmtMultipleDate[0], ymdFormat );\n tmpArrSales[colDrAmt] = monthlySalesFirst;\n tmpArrSales[colCrAmt] = monthlySalesFirst;\n tmpArrSales[colSlipDescr] =\n funcMonthStr( arrSalesAmtMultipleDate[0] ) + " @ " + slipDescr;\n myTsv += tmpArrSales.join("\\t");\n myTsv += "\\n";\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 < 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() <= dateDueDate.getTime() ){\n tmpSlipId++;\n let tmpArrSales = arrTplReceivableSales.concat();\n tmpArrSales[colSlipId] = tmpSlipId + "";\n tmpArrSales[colDate] = funcDateStr( arrSalesAmtMultipleDate[i], ymdFormat );\n tmpArrSales[colDrAmt] = monthlySalesFollow;\n tmpArrSales[colCrAmt] = monthlySalesFollow;\n tmpArrSales[colSlipDescr] =\n funcMonthStr( arrSalesAmtMultipleDate[i] ) + " @ " + slipDescr;\n myTsv += tmpArrSales.join("\\t");\n myTsv += "\\n";\n myReceivableSales += monthlySalesFollow;\n }else{\n tmpSlipId++;\n let tmpArrSales = arrTplReceivedSales.concat();\n tmpArrSales[colSlipId] = tmpSlipId + "";\n tmpArrSales[colDate] = funcDateStr( arrSalesAmtMultipleDate[i], ymdFormat );\n tmpArrSales[colDrAmt] = monthlySalesFollow;\n tmpArrSales[colCrAmt] = monthlySalesFollow;\n tmpArrSales[colSlipDescr] =\n funcMonthStr( arrSalesAmtMultipleDate[i] ) + " @ " + slipDescr;\n myTsv += tmpArrSales.join("\\t");\n myTsv += "\\n";\n myReceivedSales += monthlySalesFollow;\n }\n }\n if(myReceivableSales !== 0 && myReceivedSales !== 0){\n tmpSlipId++;\n let tmpArrPay1 = arrTplPaymentReceivable.concat();\n tmpArrPay1[colSlipId] = tmpSlipId + "";\n tmpArrPay1[colDate] = funcDateStr( dateDueDate, ymdFormat );\n tmpArrPay1[colDrAmt] = myReceivableSales + myReceivedSales;\n tmpArrPay1[colCrAmt] = myReceivableSales;\n tmpArrPay1[colSlipDescr] = slipDescr;\n myTsv += tmpArrPay1.join("\\t");\n myTsv += "\\n";\n let tmpArrPay2 = arrTplPaymentReceived.concat();\n tmpArrPay2[colSlipId] = tmpSlipId + "";\n tmpArrPay2[colDate] = funcDateStr( dateDueDate, ymdFormat );\n tmpArrPay2[colDrAmt] = 0;\n tmpArrPay2[colCrAmt] = myReceivedSales;\n tmpArrPay2[colSlipDescr] = slipDescr;\n myTsv += tmpArrPay2.join("\\t");\n }else if(myReceivableSales === 0){\n tmpSlipId++;\n let tmpArrPay = arrTplPaymentReceived.concat();\n tmpArrPay[colSlipId] = tmpSlipId + "";\n tmpArrPay[colDate] = funcDateStr( dateDueDate, ymdFormat );\n tmpArrPay[colDrAmt] = myReceivableSales + myReceivedSales;\n tmpArrPay[colCrAmt] = myReceivedSales;\n tmpArrPay[colSlipDescr] = slipDescr;\n myTsv += tmpArrPay.join("\\t");\n }else if(myReceivedSales === 0){\n tmpSlipId++;\n let tmpArrPay = arrTplPaymentReceivable.concat();\n tmpArrPay[colSlipId] = tmpSlipId + "";\n tmpArrPay[colDate] = funcDateStr( dateDueDate, ymdFormat );\n tmpArrPay[colDrAmt] = myReceivableSales + myReceivedSales;\n tmpArrPay[colCrAmt] = myReceivableSales;\n tmpArrPay[colSlipDescr] = slipDescr;\n myTsv += tmpArrPay.join("\\t");\n }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( dataIdX !== "" ){\n engine.setDataByNumber( dataIdX, myTsv );\n}\nif( dataIdY !== "" ){\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 + "\\n" +\n myTsv.replace( \/,\/g, "" ).replace( \/\\t\/g, "," );\n outputFiles.add(\n new com.questetra.bpms.core.event.scripttask.NewQfile(\n (processInstance.getProcessInstanceId() + ".csv"), \/\/ fileName\n "text\/comma-separated-values; charset=Shift_JIS", \/\/ for sjis\n strSjisCsv\n )\n );\n engine.setDataByNumber( dataIdY, outputFiles );\n}\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\nfunction funcDateStr( dateObj, formatStr ){\n formatStr = formatStr.replace(\/YYYY\/g, dateObj.getFullYear());\n formatStr = formatStr.replace(\/MM\/g, ('00' + (dateObj.getMonth() + 1)).slice(-2));\n formatStr = formatStr.replace(\/DD\/g, ('00' + dateObj.getDate()).slice(-2));\n return formatStr;\n}\n\nfunction funcMonthStr( dateObj ){\n let myStr = dateObj.getFullYear() + "-" + ("00" + (dateObj.getMonth()+1)).slice(-2);\n return myStr;\n}\n\nfunction toJsDate( bpmsDateOrDatetimeStr ){\n \/\/ BPMS Date: "2020-04-01"\n \/\/ BPMS Datetime: "2020-04-01 23:59"\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 \/\/ "Date.parse" is danger (strongly discouraged)\n \/\/ - new Date("2014-11-10") \/\/ 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(" ");\n if( arrDatetime.length === 1 ){\n let arrDateParts = arrDatetime[0].split("-");\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("-");\n let arrTimeParts = arrDatetime[1].split(":");\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<\/a><\/figure><\/div>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- MoneyForward-Journal-Create-2021.xml<\/a><\/li><\/ul>\n\n\n\n
2021-08-03 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/ja\/addons\/moneyforward-journal-create-2021\/<\/a>
<\/i> Addon\u30d5\u30a1\u30a4\u30eb\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u306f Professional<\/strong><\/span> \u3067\u306e\u307f\u3054\u5229\u7528\u3044\u305f\u3060\u3051\u307e\u3059<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- “\u53d6\u5f15No” \u306f\u3001
- 4\u67081\u65e5\u306b\u751f\u6210\u3055\u308c\u308b\u4f1d\u7968\u306f\u3001\u6c7a\u7b97\u6708\u304c”12″\u306e\u5834\u5408 “401yyyzz” \u306e8\u6841\u3068\u306a\u308a\u307e\u3059\u3002<\/li>
- 4\u67081\u65e5\u306b\u751f\u6210\u3055\u308c\u308b\u4f1d\u7968\u306f\u3001\u6c7a\u7b97\u6708\u304c “3”\u306e\u5834\u5408 “101yyyzz” \u306e8\u6841\u3068\u306a\u308a\u307e\u3059\u3002<\/li>
- 3\u670831\u65e5\u306b\u751f\u6210\u3055\u308c\u308b\u4f1d\u7968\u306f\u3001\u6c7a\u7b97\u6708\u304c”3″\u306e\u5834\u5408”1231yyyzz” \u306e9\u6841\u3068\u306a\u308a\u307e\u3059\u3002<\/li>
- yyy \u90e8\u306f {\u30d7\u30ed\u30bb\u30b9ID} \u306e\u4e0b\u4e09\u6841\u306b\u306a\u308a\u307e\u3059\u3002<\/li>
- zz \u90e8\u306f\u5206\u5272ID\u306b\u306a\u308a\u307e\u3059\uff0801,02,\u2026\uff09\u3002<\/li>
- \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<\/li>
- \u203b\u305d\u306e\u5f8c\u306e\u300c\u624b\u52d5\u3067\u4ed5\u8a33\u300d\u7b49\u306e “\u53d6\u5f15No” \u306f\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u5024\u306b\u306a\u308a\u307e\u3059\u3002<\/li><\/ol><\/li>
- \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<\/li>
- \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
- [0]\u53d6\u5f15No,[1]\u53d6\u5f15\u65e5,<\/li>
- [2]\u501f\u65b9\u52d8\u5b9a\u79d1\u76ee,[3]\u501f\u65b9\u88dc\u52a9\u79d1\u76ee,[4]\u501f\u65b9\u7a0e\u533a\u5206,<\/li>
- [5]\u501f\u65b9\u90e8\u9580,[6]\u501f\u65b9\u91d1\u984d(\u5186),[7]\u501f\u65b9\u7a0e\u984d,<\/li>
- [8]\u8cb8\u65b9\u52d8\u5b9a\u79d1\u76ee,[9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee,[10]\u8cb8\u65b9\u7a0e\u533a\u5206,<\/li>
- [11]\u8cb8\u65b9\u90e8\u9580,[12]\u8cb8\u65b9\u91d1\u984d(\u5186),[13]\u8cb8\u65b9\u7a0e\u984d,<\/li>
- [14]\u6458\u8981,[15]\u4ed5\u8a33\u30e1\u30e2,[16]\u30bf\u30b0,[17]MF\u4ed5\u8a33\u30bf\u30a4\u30d7,<\/li>
- [18]\u6c7a\u7b97\u6574\u7406\u4ed5\u8a33,[19]\u4f5c\u6210\u65e5\u6642,[20]\u6700\u7d42\u66f4\u65b0\u65e5\u6642<\/li><\/ul><\/li>
- \uff03Money Forward journal_sample.csv
- https:\/\/support.biz.moneyforward.com\/account\/guide\/import-books\/ib01.html<\/a><\/li><\/ol><\/li>
- \u5206\u5272\u3055\u308c\u305f\u58f2\u4e0a\u30ec\u30b3\u30fc\u30c9\u306e\u6458\u8981\u306f “2020-04 @ {\u6458\u8981}” \u3068\u3044\u3063\u305f\u66f8\u5f0f\u3068\u306a\u308a\u307e\u3059\u3002<\/li>
- \uff1c\uff14\u4f1d\u7968\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u8a2d\u5b9a\u4f8b\uff1e
- \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<\/li>
- \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<\/li>
- \u203b\u306a\u304a “[0],[1],[6],[12],[14]” \u306e\u5404\u9805\u306f\u81ea\u52d5\u7684\u306b\u4e0a\u66f8\u304d\u3055\u308c\u307e\u3059<\/li>
- \u58f2\u639b\u91d1\u58f2\u4e0a\u4f1d\u7968\u3092\u300e[17]MF\u4ed5\u8a33\u30bf\u30a4\u30d7\u300f\u3092 “\u672a\u5b9f\u73fe” \u306b\u3057\u305f\u3044\u5834\u5408
- “,,\u58f2\u639b\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,,\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,\u672a\u5b9f\u73fe,,,”<\/li><\/ul><\/li>
- \u524d\u53d7\u91d1\u58f2\u4e0a\u4f1d\u7968\u306e\u300e[3]\u501f\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 “\u53d6\u5f15\u5148” \u306b\u300e[9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 “\u5546\u54c1\u7a2e” \u306b
- “,,\u524d\u53d7\u91d1,#{#q_Billto},\u5bfe\u8c61\u5916,,,0,\u58f2\u4e0a\u9ad8,#{#q_Product},\u8ab2\u7a0e\u58f2\u4e0a 10%,,,0,,,,,,,”<\/li><\/ul><\/li>
- \u58f2\u639b\u91d1\u56de\u53ce\u4f1d\u7968\u306e\u300e[9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 “\u53d6\u5f15\u5148” \u306b\u3057\u3001\u30bf\u30a4\u30d7\u3092 “\u672a\u5b9f\u73fe” \u306b
- “,,\u666e\u901a\u8caf\u91d1,,\u5bfe\u8c61\u5916,,,0,\u58f2\u639b\u91d1,#{#q_Billto},\u5bfe\u8c61\u5916,,,0,,,,\u672a\u5b9f\u73fe,,,”<\/li><\/ul><\/li>
- \u524d\u53d7\u91d1\u56de\u53ce\u4f1d\u7968\u306e\u300e[9]\u8cb8\u65b9\u88dc\u52a9\u79d1\u76ee\u300f\u3092 “\u53d6\u5f15\u5148” \u306b\u3057\u3001\u30bf\u30a4\u30d7\u3092 “\u672a\u5b9f\u73fe” \u306b
- “,,\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,,,”<\/li><\/ul><\/li><\/ol><\/li><\/ol>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/moneyforward-journal-ja-1.png?ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/moneyforward-journal-ja-2.png?ssl=1\")
<\/figure>\n\n\n\n![\"MoneyForward\u30af\u30e9\u30a6\u30c9\u4f1a\u8a08\u7528\u306e\u4ed5\u8a33\u4f1d\u7968\uff08TSV](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create-capture-ja.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"\u4ed5\u8a33\u4f1d\u7968,](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/MoneyForward-Journal-Create2-capture-ja.png?fit=1024%2C576&ssl=1\")
<\/figure>\n\n\n\n<\/i> See also<\/h3>\n\n\n\n
- “,,\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,,,”<\/li><\/ul><\/li><\/ol><\/li><\/ol>\n\n\n\n
- https:\/\/support.biz.moneyforward.com\/account\/guide\/import-books\/ib01.html<\/a><\/li><\/ol><\/li>
- “\u53d6\u5f15No” \u306f\u3001
- <\/i><\/span> B: \u58f2\u4e0a\u9ad8\uff08\u4e00\u62ec\u8a08\u4e0a\u5206\uff09\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n