---
title: EXAC220　Suspense Journal Documents General Upload
description: Suspense
---

[Skip to content](https://faq.multibook.jp/en/knowledge/exac220-汎用仮伝票取込#main-content)

English

Show submenu for translations

![multibookロゴ.png\]](https://faq.multibook.jp/hs-fs/hubfs/multibook%E3%83%AD%E3%82%B4.png?height=40&name=multibook%E3%83%AD%E3%82%B4.png)

- [Blog](https://faq.multibook.jp/en/knowledge/exac220-汎用仮伝票取込#blog)
- [Gallery](https://faq.multibook.jp/en/knowledge/exac220-汎用仮伝票取込#gallery)
- [About](https://faq.multibook.jp/en/knowledge/exac220-汎用仮伝票取込#about)

Open main navigation

Close main navigation

- [Blog](https://faq.multibook.jp/en/knowledge/exac220-汎用仮伝票取込#blog)
- [Gallery](https://faq.multibook.jp/en/knowledge/exac220-汎用仮伝票取込#gallery)
- [About](https://faq.multibook.jp/en/knowledge/exac220-汎用仮伝票取込#about)
- English
  
  Show submenu for translations
- [manual site](http://help.multibook.jp/manual/manual_en.html)

[manual site](http://help.multibook.jp/manual/manual_en.html)

 Search the Knowledge Base

- There are no suggestions because the search field is empty.

1. [multibook WebSupportCenter](https://faq.multibook.jp/en/knowledge?hsLang=en)
2. [Finance ＆Accounting](https://faq.multibook.jp/en/knowledge/finance-accounting?hsLang=en)
3. [Excel Upload](https://faq.multibook.jp/en/knowledge/finance-accounting?hsLang=en#excel-upload)

# EXAC220　Suspense Journal Documents General Upload

**Predefined formats can be used to upload suspense documents from Excel, CSV, and TSV files.**

**![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-24-29-3956-AM.png?width=1890&height=1424&name=image-png-Mar-12-2025-09-24-29-3956-AM.png)**

**Operation**

1. **Set Up**
2. **Basic Operation**

**1. Set Up**

**Before uploading using this function, one needs to set up the field relationship in MAEX110 External System Profile. In MAEX110, you speficy following items:** 

　　**・Which Excel column of the import file are corresponding fields to which fields of multibook accounting journal. For example, "Post Date" should be picked up from "Column B" in Excel**

　　**・ If a particular field value is always the same,  you can spefici in the MAEX110 in stead of having a field in Excel. i.e. Ledger Type is always "Normal", then put "0", next to "Ledger" field.** 

　　**・Whether to convert and import G/L account, department, biz partner, and segment codes.  (If you specify "Convert", you need to set the conversion information with the corresponding master maintenance function.) \*\*See below for more explanation**

　　

    **・Whether to automatically set payment information such as the due date.**

　　**・Whether to automatically calculate the amount (co. currency) from and rate.**

**Excel File (example)**

**![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-31-41-7277-AM.png?width=643&height=176&name=image-png-Mar-12-2025-09-31-41-7277-AM.png)**

**External Profile Set Up Screen**

**![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-31-29-2889-AM.png?width=366&height=393&name=image-png-Mar-12-2025-09-31-29-2889-AM.png)**

**To set up it: Click MAEX110 External System Profile**

**![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-32-29-0454-AM.png?width=1882&height=1434&name=image-png-Mar-12-2025-09-32-29-0454-AM.png)**

**Select the company and Enter a name of the profile:**

**Note: you need to set up the profile for each company even they are the same.** 

**![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-33-24-4478-AM.png?width=1368&height=496&name=image-png-Mar-12-2025-09-33-24-4478-AM.png)**

**![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-35-51-6685-AM.png?width=737&height=346&name=image-png-Mar-12-2025-09-35-51-6685-AM.png)**

**![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-35-32-6264-AM.png?width=1478&height=1510&name=image-png-Mar-12-2025-09-35-32-6264-AM.png)**

**![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-36-15-4971-AM.png?width=1366&height=1514&name=image-png-Mar-12-2025-09-36-15-4971-AM.png)**

**Enter the Profile Name and others and Click Update to Save.** 

**![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-39-34-8885-AM.png?width=1978&height=716&name=image-png-Mar-12-2025-09-39-34-8885-AM.png)**

**\*\*Whether to convert and import G/L account, department, biz partner, and segment codes.  (If you specify "Convert", you need to set the conversion information with the corresponding master maintenance function.)** 

- **G/L account, biz partner, department, and segment can be converted from the code on the import file and then imported into the document.**
- **When converting biz partner code, if you set "NCC\*" on the "Additional" tab of the biz partner master, all codes starting with "NCC\*" in the biz partner code of the import file will be converted to this master record.**
- **The same applies to the conversion of "Account", "Department", and "Segment".**

![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-37-50-9782-AM.png?width=482&height=428&name=image-png-Mar-12-2025-09-37-50-9782-AM.png)

 

**2. Basic Operation**

**Once you are compete setting up the Profile, Go to EXAC220 Suspense Documents General Upload**

![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-38-35-6987-AM.png?width=845&height=629&name=image-png-Mar-12-2025-09-38-35-6987-AM.png)

**Specify a profile you would like to choose.** 

**Enter Start Line which is the line that the information that you would like to upload start (excluding the title lines) and click Upload button.** 

**※ Please refer to the 【ACSP125 Update Suspense Journal】 manual for how to update, approval, posting, and delete method importing the suspense document.**

![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-41-02-5271-AM.png?width=1528&height=568&name=image-png-Mar-12-2025-09-41-02-5271-AM.png)

![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-43-25-3501-AM.png?width=870&height=346&name=image-png-Mar-12-2025-09-43-25-3501-AM.png)

**Specify the file to import and click Open button.**

   **※The following formats can be imported.**

　　**・ Excel workbook file (extension "xls", "xlsx")**

　　**・ Comma-separated text file (extension "csv")**

　　**・ Tab-separated text file (extension "tsv")**

![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-43-52-2222-AM.png?width=391&height=233&name=image-png-Mar-12-2025-09-43-52-2222-AM.png)

**When the import is completed, the execution result file will be generated.**

**A suspense Doc No. is set if the import is completed normally.**  

![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-44-12-9001-AM.png?width=683&height=207&name=image-png-Mar-12-2025-09-44-12-9001-AM.png)

**If there is an error, the registration Doc No. Will not be set and the error content will be displayed in the error message field.**

**In this case, the suspense Doc No. is not set because the import has not been completed normally.**

**If there is even one error, all document will not be registered.**  

![](https://faq.multibook.jp/hs-fs/hubfs/image-png-Mar-12-2025-09-44-41-8223-AM.png?width=687&height=206&name=image-png-Mar-12-2025-09-44-41-8223-AM.png)

END

 

 

 

 

- [setting](https://faq.multibook.jp/en/knowledge/setting?hsLang=en#main-content)

    - [VPN](https://faq.multibook.jp/en/knowledge/setting?hsLang=en#vpn)
- [Screen Inquiry & Report Output](https://faq.multibook.jp/en/knowledge/screen-inquiry-report-output?hsLang=en)
- [Finance ＆Accounting](https://faq.multibook.jp/en/knowledge/finance-accounting?hsLang=en#main-content)

    - [General Accounting](https://faq.multibook.jp/en/knowledge/finance-accounting?hsLang=en#general-accounting)
    - [Excel Upload](https://faq.multibook.jp/en/knowledge/finance-accounting?hsLang=en#excel-upload)
- [Asset Management](https://faq.multibook.jp/en/knowledge/asset-management?hsLang=en#main-content)

    - [Fixed Asset](https://faq.multibook.jp/en/knowledge/asset-management?hsLang=en#fixed-asset)
- [Logistics](https://faq.multibook.jp/en/knowledge/logistics?hsLang=en#main-content)

    - [Invoice Document / Invoice](https://faq.multibook.jp/en/knowledge/logistics?hsLang=en#invoice-document-invoice)
    - [Item Movement Document](https://faq.multibook.jp/en/knowledge/logistics?hsLang=en#item-movement-document)
    - [Vendor Invoice Document](https://faq.multibook.jp/en/knowledge/logistics?hsLang=en#vendor-invoice-document)
    - [Sales Order Document](https://faq.multibook.jp/en/knowledge/logistics?hsLang=en#sales-order-document)
    - [Purchase Order Document](https://faq.multibook.jp/en/knowledge/logistics?hsLang=en#purchase-order-document)
    - [Inquiry & Report](https://faq.multibook.jp/en/knowledge/logistics?hsLang=en#inquiry-report)
- [Manual](https://faq.multibook.jp/en/knowledge/manual?hsLang=en#main-content)

    - [Accounting](https://faq.multibook.jp/en/knowledge/manual?hsLang=en#accounting)
    - [Accounting/Account Receivable](https://faq.multibook.jp/en/knowledge/manual?hsLang=en#accounting-account-receivable)
    - [Accounting / Account Payable](https://faq.multibook.jp/en/knowledge/manual?hsLang=en#accounting-account-payable)
    - [Accounting / Master maintenance](https://faq.multibook.jp/en/knowledge/manual?hsLang=en#accounting-master-maintenance)
    - [Logistics/Orders](https://faq.multibook.jp/en/knowledge/manual?hsLang=en#logistics-orders)
    - [Logistics／Purchase Order](https://faq.multibook.jp/en/knowledge/manual?hsLang=en#logisticspurchase-order)
    - [Fixed Asset／Inquiry & Report](https://faq.multibook.jp/en/knowledge/manual?hsLang=en#fixed-assetinquiry-report)
    - [Logistics／Item Movement](https://faq.multibook.jp/en/knowledge/manual?hsLang=en#logisticsitem-movement)
    - [Logistics／Invoice](https://faq.multibook.jp/en/knowledge/manual?hsLang=en#logisticsinvoice)
    - [Master Maintenance／Fixed Asset](https://faq.multibook.jp/en/knowledge/manual?hsLang=en#master-maintenancefixed-asset)
    - [Country Specific Function](https://faq.multibook.jp/en/knowledge/manual?hsLang=en#country-specific-function)
- [Enter Expense Reimbursement](https://faq.multibook.jp/en/knowledge/enter-expense-reimbursement?hsLang=en)

- [Blog](https://faq.multibook.jp/en/knowledge/exac220-汎用仮伝票取込#blog)
- [Gallery](https://faq.multibook.jp/en/knowledge/exac220-汎用仮伝票取込#gallery)
- [About](https://faq.multibook.jp/en/knowledge/exac220-汎用仮伝票取込#about)

[![Chill listening crop-3](https://faq.multibook.jp/hs-fs/hubfs/multibook_small-1.jpg?width=30&height=24&name=multibook_small-1.jpg "Chill listening crop-3")](http://multibook.co.jp)

Support E-mail: mb.support@multibook.jp

Copyright © 2026, HP：https://www.multibook.jp/ \<br\>