Bank reconciliation add-on

Development project: Bank reconciliation add on for Microsoft Dynamics NAV / Navision.

Our bank reconciliation add-on makes it easy for companies to reconcile their bank statements with the corresponding financial data held on their Dynamics NAV system. The add-on is especially beneficial for companies that process a large number of transactions every month.

Our add-on extends NAV’s standard, ‘out-of-the-box’ bank account reconciliation feature, thereby making the whole process quicker and easier.

Functionality

Users can import electronic bank statements into NAV, using common file formats such as .CSV or XML. The statements can then be reconciled against Bank Ledger entries in NAV.

An ‘Auto apply bank to NAV entries’ function reconciles the entries the best it can based on date fields, monetary value, cheque numbers or purchase order references. Further reconciliation can be carried out on-screen by selecting single/multiple bank entries to reconcile with single/multiple NAV entries.

Once the reconciliation is completed as far as possible, an improved ‘Transfer to General Journal’ function allows you to also transfer unreconciled entries from the bank statement to the selected General Journal.

This all makes it very straightforward to spot any discrepancies in the two sets of figures and to take appropriate follow-up action.

To find out more about our bank reconciliation add-on, please download our bank reconciliation add-on fact sheet (PDF) or contact us.