startWorking with bank lines - Allocation rules
How To

Working with bank lines - Allocation rules

Twinfield
Last update: Reading time 2 minutes
Allocation RulesBanking Module

    Creating a rule for a bank allocation

    Rules are created to make the bank allocation process more efficient.  Allocation rules are applied against a bank statement line when a bank feed or CSV import loads new lines.  

    NOTE: Currently, rules can only be set against bank lines which are allocated as customer or supplier and matched against outstanding amounts or assigned to a general ledger code.  Lines which are assigned to a customer or supplier code and not matched can not be saved with an allocation rule.

    A rule can be created once the allocation has been defined and saved.

    • Click on Create rule on the left of the Assignment details window
    • Using the description - Highlight values within the text which will be consistent each time this transaction appears on the bank statement but also should be unique to this assignment coding.
      • Examples include; Customer code; Supplier code; your account number or policy number
      • Multiple selections can be made to build a criteria when the values are not consecutive - for example, a description of "Insurances Limited July 2022 1234531" highlighting the supplier name and seperately your policy number would set a criteria to search for Insurances Limited & 1234531
    • Values from other fields can be added within the criteria by clicking the  
    clipboard_e898d15f3ff5903054c243251aa6624db.png
    • icon next to the field
      • Mutation code - Transaction code (DD; BACS, etc)
      • Value of the bank statement line
         
    clipboard_e1cf74a2801e40f6ce4bafbbf481297f5.png

    • Click down arrow to the right of the amount allows the amount to become part of the criteria using various tests such as equal to, less than, etc
    • Show rule details
       
    clipboard_e2ce4f1b8ec0f2558a9fc4173eb469b02.png

    • Set that the rule only applies to receipts/payments
    • Use rule for
      • Whole company - The rule will be applied to all bank statement lines imported for all bank accounts in the active company
      • Bank account - Apply the rule to bank statement lines imported against the bank account to which the rule was originally created
    Saving the bank statement line
    clipboard_ef82dd9825cdb3c225d2ee00101eb3991.png

    Use the buttons at the bottom of the screen to save the allocations

    • Save - Save the allocation and leave in the To Assign bucket - The allocation rule is not saved
    • To Investigate - Save the allocation and move to the To Investigate bucket for further review - The allocation rule is not saved
    • Accept without learning - Save the allocation without creating an allocation rule and move to the Assigned bucket
    • Accept and create rule - Save the allocation saving the allocation rule and move to the Assigned bucket

    Related documents

    Cheques and Paying-in slips
    Cheques and Paying-in slips.
    Twinfield: Twinfield Analysis Consultancy (10091307)
    This document outlines a training course on Twinfield accounting software, designed for Twinfield partners and subscribers. The course, lasting up to 3 hours, focuses on enabling participants to leverage their Excel expertise to manipulate TwinCube data for creating comprehensive financial reports. Key objectives include processing transactions and searching via the reporting module. The session covers various topics such as data cube management, Excel formula building, and conditional formatting. Attendees must have advanced Excel skills and their own devices to join the session, as the course is tailored for Microsoft Windows users.
    Twinfield Consultancy (10093303/10080551)
    This document outlines a consultancy service for Twinfield users, targeting both partners and subscribers. It emphasizes collaborative sessions aimed at improving operational efficiencies and best practices through tailored advice and process reviews. Conducted online or onsite over two 3-hour sessions, the consultancy covers topics such as reporting, VAT reporting, and reconciliations. Attendees are expected to have a solid grasp of double entry bookkeeping. Additional resources, including eLearning courses, videos, and webinars, are provided for further learning.
    Twinfield: Integration Consultancy (10095230/10095228)
    This document outlines a consultancy-led course focused on the Twinfield accounting software, designed to assist businesses in managing their financials effectively. The course consists of four interactive sessions—each lasting three hours—covering navigation, invoicing, credit management, transactions, and reporting. Aimed at Twinfield partners and subscribers, participants are expected to have a good understanding of bookkeeping principles. Additional resources such as eLearning courses, videos, and webinars are also provided to enhance learning. The maximum group size is six delegates.
    Twinfield: PM Integration Consultancy (10091304/10091303)
    This document outlines a training course for Twinfield accounting software users, focusing on its integration with CCH Central. The course consists of four sessions, each lasting about three hours, aimed at enhancing attendees' bookkeeping skills and knowledge of both systems. Key objectives include familiarization with CCH Practice Management and Twinfield, as well as hands-on experience with financial processes such as invoicing, bank transactions, and VAT reporting. Prerequisites include a good understanding of CCH Central and appropriate permissions. The course is intended for Twinfield partners and subscribers, with a maximum of six delegates per group.