Coins ERP+ allows you to load bank statement files and reconcile them with transactions in Coins ERP+. Follow the steps below when you want to load a bank statement.
Retrieve/download the statement via your banking software.
Check the current status of your statements.
Load the Bank statement.
Coins ERP+ has the facility to accept electronic statements in the following forms. (This is regulated by the 'Statement Type' in Bank Accounts). Click the links below for more information about the individual formats.
blank - Manual statement.
Format A (Barclays)
Format B (NatWest)
Format C (Bank of Ireland)
Format D (Midland Bank)
Format E (Royal Bank of Scotland)
Format F (Commonwealth Bank)
Format G (ANZ Bank)
Format H (Bank of Ireland - Format 2)
Format I (HSBC Hexagon)
Format J (Lloyds Bank)
Format K (Bank of Scotland CHOBS)
Format L (Northern Bank)
Format M (Allied Irish Bank (AIB))
Format N (Bank Of Ireland (No Header))
Format O (HSBC Hexagon (New Format))
Format P (Royal Bank Of Scotland (New Format))
Format Q (Ulster Bank Load)
Format R (Co-Op Bank)
Format S (RBS/Natwest BankLine)
Format T (HSBCNet)
Format U (Clydesdale Bank)
Format V (National Australia Bank)
Format W (Handelsbankken)
Format X (Generic CSV File)
Format Y (Barclays Daily Statement)
Format Z (Lloyds Commercial Online Banking)
For types A - X, the medium for loading a statement is a file. It is probable that you will first load that file onto your PC via your bank's software.
If you are using a manual statement, you can still use the Bank Reconciliation processes in Coins ERP+, but you will need to manually type in the statement details.
Coins ERP+ allows you to load up to one statement per statement date per bank account. Therefore, it is expected that you will not reconcile any more frequently than daily for any one bank account within a company.
Parameters
CB/LINESKIP - Lines to skip at top of statement load