After setting up, user may import bank transaction to the system through Bank Account Reconciliation section.
Steps as below:
- Go to "Bank Account Reconciliation"
- Create New
- Input/ select related fields
- Select Bank Account no.
- Input Bank Statement Date
- Input Statement ending balance
- Click Bank, then select Import Bank Statement
Select the csv file and improt - Transactions successfully imported to the Bank Account Reconciliation page
(** be aware that these transactions only imported to the Bank Account Reconciliation page, the transactions have not yet posted to General Ledger. Please follow the steps below for further process) - To transfer these transactions to General Journal for posting, select all lines under Bank Statement Lines,
Then click "Process" and select Transfer to General Journal - Input Gen. Journal Template and Gen. Journal Batch
- System will then create General Journal for these bank transactions.
User need to update the Account type and Account no. to complete the double entries. - Once complete the double entries, use may post the journal.