The bank import feature significantly streamlines the transfer of bank transaction data into AccountingSuite, improving accuracy while reducing the time required. Users have the flexibility to upload bank statements directly through the Import Bank Transaction tool or to input data manually via the Bank Reconciliation document.

From a high-level perspective, the bank import process can be summarized as follows:

1. Upload the file for the selected period (day, week, month).
2. All manually created documents for the selected bank account get unposted, as they need to be verified against bank records.
3. All uploaded transaction appear in the Unapproved tab.
4. Automatically recognize and process documents wherever possible (using the tools Merchant Company Mapping and Categorization Rules).
5. For documents that have not been recognized, fill in the document type and counterparty information.
6. Upon approval, the system generates the documents with appropriate General Ledger entries, which then appear in the Approved tab.
7. Documents that should not be posted to the General Ledger are marked as Exceptions under the Excluded tab.
8. Review all extra documents listed as Unposted—these were manually processed but didn’t pass bank verification. Analyze why they failed: incorrect dates or missing payment orders (both critical issues). Clean up by deleting unnecessary items or updating dates accordingly.
9. On the Undeposited tab, check what remains outstanding from this bank, including checks, and determine when actual funds will be received. Draw conclusions and coordinate with the bank to resolve any pending issues.

Import Transactions #

For easy and successful import, create Categorization Rules and Company Mapping Rules first, and complete the Feed settings in the Bank Account.

1. Navigate to Bank → Import Bank Transactions
2. Select the Bank Account (1)
3. Click Import from File (2) and Open Import Wizard (3)

4. In the Import Wizard window, select the bank file. Column numbers and attributes CSV separator, Date format, Has header row will be filled according to the Feed settings in the Bank account. These setting can be changed here if needed. Click Continue.

5. The next Import Wizard step shows the summary of transactions for upload, incorrect transactions and all transactions derived from the file.

6. The import tool will check the transaction from the For upload tab with any extisting transactions in the system.

Following tabs are available:

• Uanapproved transactions: uploaded from the bank file
• Approved transactions: imported transactions ticked as approved
• Excluded transactions: imported transactions ticked as declined
• Unposted documents: bank documents that have been created for the selected bank account and for the selected time frame earlier, but not matched with any transaction in the uploaded file
• Undeposited documents: documents that are not linked to a particular bank account and have Undeposited funds subcategory and documents linked to the selected bank account and accounted for as Post Dated Checks