The method for Kingdee to import bank statements is: 1. Prepare bank statement files, usually exported in Excel or Csv format; 2. In Kingdee financial software, you need to create a bank account according to the actual situation; 3. Import the bank statement 4. Check the completeness and correctness of bank statements; 5. If the bank statements are correct, just enter the accounting process.
# Operating system for this tutorial: Windows 10 system, Kingdee KIS version, Dell G3 computer.
As a commonly used financial software, Kingdee Financial Software can easily import bank flow, making corporate financial management simpler and more efficient. The following describes the detailed steps for Kingdee to import bank statements.
Step 1: Prepare bank statement file
First of all, you need to obtain the bank statement file from the bank, which is usually exported in Excel or Csv format. Generally, bank flow documents contain the following information: transaction date, voucher number, summary, counterparty account number, counterparty account name, currency, income amount, expenditure amount, balance and other information. Note: The imported bank statement file must be consistent with the account name in Kingdee Financial Software.
Step 2: Create a bank account
In Kingdee financial software, you need to create a bank account according to the actual situation. The specific steps are as follows:
1. Enter the "Account" - "Bank Account" menu;
2. Click the "New" button and enter the bank account name, account number, currency and other information;
3. In the bank account editing interface, check "Enable Journal" so that bank statements can be entered later.
Step 3: Import bank statements
In Kingdee financial software, you can import bank statements through the following steps:
1. Enter " Journal" - "Bank Deposit Journal" menu;
2. Click the "Import" button and select the bank statement file;
3. In the import wizard, select the correct bank account and specify the date range, and set the columns to be imported;
4. Click the "Import" button and wait for the import to complete.
Note: The imported bank flow file needs to be entered in the appropriate format, otherwise the import will fail.
Step 4: Check the bank statements
After importing the bank statements, you need to check the completeness and correctness of the bank statements. The specific method is as follows:
1. Enter the "Journal" - "Bank Deposit Journal" menu;
2. Click the "Query" button to check whether the imported bank statements are completely displayed in the journal ;
3. Check whether the bank statement on the journal is consistent with the data in the bank statement file.
Step Five: Accounting Processing
If the bank statements are correct, you can enter the accounting process. The specific method is as follows:
1. Enter the "Journal" - "Bank Deposit Journal" menu;
2. Select the bank flow record that needs to be recorded;
3. Click the "Generate Voucher" button to generate the corresponding accounting voucher;
4. Adjust and modify the accounting voucher as needed;
5. Submit the voucher and review it.
The above are the detailed steps for Kingdee to import bank statements. Through the above operations, corporate financial personnel can process bank flow data more conveniently and quickly, improving financial efficiency and accuracy
The above is the detailed content of How to import bank statements into Kingdee. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

Dreamweaver Mac version
Visual web development tools

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software