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!