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 FILE”.
Data Input
- A’: Description name on the transfer slip stored in the Data Item selected at A
- B’: Sales amount stored in the Data Item selected at B (collective)
- C’: Date of recording collective sales stored in the Data Item selected at C
- D’: Sales amount stored in the Data Item selected at D (divided portion)
- E’: Initial date of divided sales stored in the Data Item selected at E (the date on which transfer slips to be recorded in each following month will automatically be the “1st”.)
- F’: Number of divisions (number of months) stored in the Data Item selected at F
- G ‘: Due date of settlement (deposit) stored in theDdata Item selected at G
Service Output
- TSV data of the transfer slip (journal slip) will be stored in the String type Data Item selected at X
*Note
Each row (each record) of the TSV data corresponds to one sheet of journal slip.
You can not import TSV data into the accounting system (accounting software/accounting cloud) as it is. To generate “File to be imported”, place an automatic conversion Step (converter) such as “TSV to Excel-CSV FILE” at the downstream.
Regarding journal slip, if the sales recording date is the same as or before the “settlement date”, the “accounts receivable sales row template” will be applied. and if the sales recording date is after the “settlement date”, “advance payment sales Row template “will be applied
The date on journal slip for payment collection to be generated is the”settlement due date” (composite entry). (The actual payment date information needs to be corrected on the accounting system side)
The “header row” of the import file differs depending on the accounting system. Please set it by comma delimiter in the config item “H”. If not specified anything, “Heading row” for “MF cloud accounting” (21 items) will be automatically set.
- 21 items in the heading row of MF Cloud Accounting
- Transaction No., Trading date, Debit account item, Debit supplementary item, Debit tax category, Debit department, Debit amount (yen), Debit amount, Credit account item, Credit supplementary item, Credit Tax category, Credit department, Credit amount (yen), Credit tax amount, Description, Notes, Tag, MF journal type, Adjusting entry, Creation date and time, Last update date and time
- 22 items in the heading row of Freee
- Date, Slip number, Adjusting entry, Debit account item, Debit item code, Debit supplementary item, Debit supplementary item code, Debit department, Debit amount, Debit tax in/excluded, Debt tax category, Debit tax amount, Credit account item, Credit item code, Credit supplementary item, Credit supplementary item code, Credit department, Credit amount, Credit tax in/excluded, Credit tax category, Credit tax amount, Description
The data insertion position and format in each column varies depending on the accounting system. Please set in the Config item of between “I” and “O”. When not specified, the specification of “MF cloud accounting” is automatically applied.
Set the template of each row in the Config item of between “P” and “S” for the four patterns which are sales as account-receivable, sales as Received, collection of Receivable, collection of Received. When not specified, the specification for “MF cloud accounting” is automatically applied.
In case if you want to reference the workflow data to be set on the template, set it by EL expression. For example, if you set “# {data [’14’]}” at the position of the supplementary subject of the account item “Accounts receivable”, the Issue data is automatically referenced and the name of the supplementary subject such as “AAA Co., Ltd.” is recorded. Alternatively, if you set “# {data [’13’]}” to the position of the supplementary item of the account item “Sales”, the item data is automatically referenced and the supplementary subject name such as “SaaS” is recorded.
If you are a developer with JavaScript knowledge, you can also customize the format of “Transaction No.” (transfer slip ID). Edit the assignment expression of the variable “tmpSlipId” in the definition file.