Infusion Knowledge Base

    Sorry, we didn't find any relevant articles for you.

    Send us your queries using the form below and we will get back to you with a solution.

    Import a bank statement

    The Bank Reconciliation is an automated process that requires the importing of a bank file to proceed. In-built business intelligence within the software looks to match bank and Infusion transactions. Matched transactions are listed in readiness for approval while unmatched bank transactions are available for manual reconciliation.


    Bank Reconciliations are performed against individual bank accounts, go to Financials > Bank Accounts and select the bank account to reconcile. 


    Bank Account Balances

    Bank accounts show a summary of balances at the top of the page. The balances are separated into two and provide distinction between bank statement activity, and activity within Infusion.



    The Statement balances reflect bank statement reconciliation figures.

    • Close Off Balance – the bank account balance from the bank statement or online balance as at the close off date. 
    • Close Off Date – the date of the last close off of a bank reconciliation.
    • Statement Balance - the sum of the Opening Balance (Close Off Balance) plus the sum of the imported bank transactions.
    • Latest Transaction Date - the date of the most recently imported bank transaction. Note, if this transaction is deleted, the date does not change.
    • Unreconciled  the balance of unreconciled bank statement transactions. These transactions display on the Imported tab.  During a bank reconciliation, this figure continuously updates and when all transactions are reconciled it should be zero.

     

    Infusion balances show balances of transactions recorded against the bank account within Infusion.

    • GL Balance – the sum of all reconciled transactions to date. This is the total of Reconciled transactions on the Processed tab, excluding the opening balance of the GL Account.
    • Reconciled Balance – the opening GL Account Balance plus the sum of reconciled Infusion transactions.
    • Unreconciled – the balance of Unreconciled Infusion transactions. This is the total of Unreconciled transactions on the Processed tab.  



    Import a Bank File

    Bank files need to be imported into Infusion to complete a reconciliation. On your bank's website export transactions from the bank account to create a file to use. File formats available for importing are OFX, CSV, TSV and QIF.

    To import a transaction file go to the Imported tab within a bank account. Drag and drop the file into the body of the tab or alternatively select + Import to browse and select the file. 


    Existing unreconciled transactions previously imported may be displaying on the tab. Files can continue to be imported in addition to these transactions. Infusion recommends that a reconciliation is completed before importing a new statement so Close Off balances are accurately managed.



    Once imported, bank transactions display in the body of the screen ready to match and reconcile. 



    • Bank transaction details display on the left including the date, supplied reference details and amount. 
    • Infusion transaction details display in the middle column.  Infusion analyses the detail of each transaction line and offers matches or suggestions for the reconciliation.
    • Options are given at the end of each row for processing of the reconciliation. Customer or Supplier Payments are the default reconciliation options with drop down arrows beside them providing the ability to change this.
    • As transactions are reconciled, balances update to reflect the activity. Reconciled transactions transfer to the Processed tab where they display with a Reconciled badge. Note - the default Unreconciled filter in the Search field needs to be removed for these to display.

    Was this article helpful?

    Still can't find what you are looking for?

    Our award-winning customer care team is here for you.

    Contact Support

    Powered by