Reconcile deposit interest and bank fees

The bank statement reconciliation feature of Viindoo software makes checking and controlling money data simpler. In this process, there are transactions that often arise or are repetitive, which makes the accountant spend extra time on picking up data for accounting such as Bank fees, Deposit interest, etc. Setting up the Reconciliation model beforehand will speed up these tasks for the treasurer.

Reconciliation models

  1. Manually create a write-off on clicked button.

  2. Suggest counterpart values.

  3. Match existing invoices/bills.

Manually create a write-off on clicked button

To create a new reconciliation model, on the Accounting app with the Administrator right, you can navigate by two methods:

  • Method 1: Accounting ‣ Dashboard, on the Bank Journals or the Cash one, click on the Three vertical dots icon and choose Reconciliation Models.

Navigate to reconciliation models from a bank journal in Viindoo Accounting software
  • Method 2: Accounting ‣ Configuration ‣ Bank ‣ Reconciliation Models.

Navigate to reconciliation models from the configuration section in Viindoo accounting app

Press Create button and add the following required information:

Configure reconciliation models in Viindoo
  1. Reconciliation model information:

    • Name: Add a short and comprehensive name.

    • Type: Select Manually create a write-off on clicked button.

    • To Check: If checked, the journal entry created from this reconciliation model will be added to the To Check field in the Other info tab to mark waiting for the user to check all the information.

  2. Conditions on Bank Statement Line:

    • Journals: The reconciliation subject will be displayed with the chosen journal.

  3. Counterpart Values:

    • Account: Select the counterpart account of the money account.

    • Amount Type: Select the suitable type.

      • Fixed: Used in case you usually have a fixed amount of transactions;

      • Percentage of balance: Used in case the system calculates a defined percentage of total bank transactions;

      • From label: Used to get value according to certain criteria in statement label (Example: Get numeric values ​​(Amount) found on bank statement label). To write this formula you need to have knowledge of Regex, you can refer to this article.

  • Analytic Account: This can be used for analyzing and managing according to the needs of the administrator.

  • Analytic Tags: This can be used for grouping and searching purposes.

  • Journal Item Label: The content of the generated journal entries.

Different amount types for the counterpart values on reconciliation models.

Press Save and the write-off reconciliation model is now created.

When you reconcile a bank statement, you can use the available buttons in the Manual Operations tab to automatically add pre-configured information from the reconciliation models.

Available buttons on the reconciliation model in Viindoo

Do the final check for the starting and ending balance on the bank statement then press Validate. The bank statement status will be changed from Processing to Validated. See more at Steps in the bank reconciliation process.

Suggest counterpart values

This reconciliation model suggests right away the counterpart values need to be confirmed. The automation is done based on the set of conditions configured on said model.

Set up the counterpart values reconciliation model type in Viindoo software
  1. Reconciliation model information:

  • Name: Add a short and comprehensive name.

  • Type: Choose Suggest counterpart values.

  • Auto-validate: If checked, when reconciling a bank statement, the reconcile action is automatically confirmed and journal items will be created based on the configuration of the reconciliation model.

  1. Conditions on Bank Statement Line:

  • Journals: The reconciliation subject will be displayed with the chosen journal.

  • Amount Nature: The reconciliation is applied for the following transaction types:

    • Amount Received: Applies to received money only.

    • Amount Paid: Applies to the paid money only.

    • Amount Paid/Received: Applied for both types.

  • Amount: The reconciliation will be applied when the amount of money is smaller, bigger, or in a determined range.

Options for Amount filed on the reconciliation model
  • Label: The reconciliation will be automatically confirmed if the transaction’s description:

    • Contains: The description must contain the value written in this field.

    • Not Contains: The description does not contain the value written in this field.

    • Match Regex: Determine the content based on your own rules.

Options of the Label field on the reconciliation model

Note

  • Regex is the abbreviation of Regular Expression. Regular Expression is extremely useful in extracting information from a piece of text. It looks for characters in the text that match a specific rule.

  • Note: The reconciliation is applied only on transactions that satisfy the conditions on the note (similar to the Label field).

  • Transaction Type: The reconciliation model is applied only on transactions that satisfy the conditions (similar to the Label field).

  • Partner Is Set: If checked, the reconciliation mechanism is applied to Customers/Providers. These subjects can be reduced with the following conditions:

    • Restrict Partners to.

    • Restrict Partner Categories to.

  1. Counterpart Values: Refer to the settings of the Manually creating a write-off on clicked button model for more information.

  1. Partner Mapping: You can create multiple conditions for partner mapping, each line is a corresponding partner with the find conditions in the Label and Notes fields.

Partner mapping view in Viindoo

Press Save. With the above example, the conditions set for the reconciliation model are:

  • Label contains: fee.

  • Counterpart Values:

    • Account: 6425

    • Amount Type: Percentage of balance.

    • Amount: 100

When you create a bank statement and select Reconcile, the system will automatically search and match each journal item with the bank statement as in the image below.

Bank statement is reconciled with the counterpart value

Finally, you have to validate the bank statement to finish the reconciliation process.

Match existing invoices/bills

This type of reconciliation model will automatically choose the right customer invoice or vendor bill that matches the payment amount. The configuration for this model is similar to the one for the Suggestion counterpart values model. However, you need to pay attention to the following fields:

Configure the match existing invoices/bills reconciliation model.
  1. Reconciliation model information

  • Past Months Limit: Number of months in the past to consider accounting incursions when this condition applies.

  • Matching Order: Choose the transactions matching order, there are 2 options:

    • Oldest first.

    • Newest first.

  1. Conditions on Bank Statement Line

  • Same Currency Matching: If checked, only the journal items in the same currencies can be reconciled.

  • Amount Matching: Recommend the remaining balance to match the amount in the cash book.

  • Match Invoice/bill with: If checked, it will increase the ability to find the exact invoice that matches the payment.

  1. Fill the Partner Mapping information following this instruction.

Click Save. You need to add the full name of the customer or provider when reconciling from a bank statement. The system will search and match the invoice that was created earlier.

Match bank statement with existing invoices/bills

Then press Validate to proceed with the reconciliation and also Validate the bank statement.