<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tf/onlinemanual/000197" xml:lang="en">
   <Header>
      <Title>Automatic matching of electronic bank statements</Title>
      <Keyword type="header" order="d1e1634341">
         <Level1>Electronic bank statements</Level1>
         <Level2>matching</Level2>
      </Keyword>
   </Header>
   <GeneralSection>
      <Paragraph>In the <GUIRef href="/baanerp/tf/cmg/tfcmg5212m000" role="session">Match Electronic Bank Statements (tfcmg5212m000)</GUIRef> session, LN matches
		each electronic bank statement amount with as many open entries as possible.</Paragraph>
      <List>
         <ListTitle>Transactions for matching</ListTitle>
         <ListIntro>LN can match the following transactions:</ListIntro>
         <ListItem>Outgoing payments with
		  anticipated payments (automatic supplier reconciliation).</ListItem>
         <ListItem>Incoming receipts with anticipated receipts (automatic customer
		  reconciliation).</ListItem>
         <ListItem>Outgoing payments with open purchase invoices, if you do not
		  use the automatic payment procedure in <GUIRef href="/baanerp/tf/acp" role="module">Accounts Payable</GUIRef>.</ListItem>
         <ListItem>Incoming receipts with open sales invoices, if you do not use
		  the direct debit procedure in <GUIRef href="/baanerp/tf/acr" role="module">Accounts Receivable</GUIRef>.</ListItem>
         <ListItem>Incoming receipts with open sales invoices, if you do not use
		  the direct debit procedure and a remittance advice exists for the
		  receipt.</ListItem>
      </List>
   </GeneralSection>
   <GeneralSection>
      <List>
         <ListTitle>Matching options</ListTitle>
         <ListIntro>In the <GUIRef href="/baanerp/tf/cmg/tfcmg5212m000" role="session">Match Electronic Bank Statements (tfcmg5212m000)</GUIRef> session, you can select several
		  matching options, among others:</ListIntro>
         <ListItemHead>
            <GUIRef href="/baanerp/tf/cmg/tfcmg5212m000#use.cmg.tol" role="manual">Payment Difference Tolerances</GUIRef>
         </ListItemHead>
         <ListItem>Indicates whether LN must take
		  the payment difference tolerances that you define in the <GUIRef href="/baanerp/tf/cmg/tfcmg0100s000" role="session">CMG Parameters (tfcmg0100s000)</GUIRef> session into account.</ListItem>
         <ListItemHead>
            <GUIRef href="/baanerp/tf/cmg/tfcmg5212m000#create.unal" role="manual">Create Unallocated Receipt</GUIRef>
         </ListItemHead>
         <ListItem>
            <Paragraph>Indicates whether LN must
			 create unallocated receipts for unallocated amounts.</Paragraph>
            <List>
               <ListIntro>LN can create unallocated receipts for unallocated amounts in the
				following situations:</ListIntro>
               <ListItem>LN can find the business partner. However, LN cannot
				find the invoice that correspond with the payment.</ListItem>
               <ListItem>LN can find the business partner and the invoice. However, the
				invoice balance is zero.</ListItem>
               <ListItem>LN can find the business partner and the invoice. However, the
				payment difference exceeds the payment difference tolerance.</ListItem>
            </List>
         </ListItem>
         <ListItemHead>
            <GUIRef href="/baanerp/tf/cmg/tfcmg5212m000#allow.underpay" role="manual">Match Lesser Amounts</GUIRef>
         </ListItemHead>
         <ListItem>Indicates whether LN must
		  match the payments with open entries if the open entry amount exceeds the
		  payment amount.</ListItem>
      </List>
   </GeneralSection>
   <GeneralSection>
      <List>
         <ListTitle>To match trade notes</ListTitle>
         <ListIntro>The invoices and anticipated documents that can be matched
		  also include <Link href="/baanerp/tf/glossary/glossary#000436" role="glossary">trade notes</Link> that replace
		  invoices. The following rules apply to trade notes:</ListIntro>
         <ListItem>For incoming receipts, LN also
		  checks whether the document number occurs as a trade note number in the Trade
		  Notes Receivable table. If this is the case, the EBS is matched.</ListItem>
         <ListItem>For outgoing payments, LN also
		  checks whether the document number occurs as a trade note number in the Trade
		  Notes Payable table. If this is the case, the EBS is matched.</ListItem>
      </List>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>The automatic matching process</SectionTitle>
      <ProcedureList>
         <ListIntro>The automatic matching process uses the following procedure
		  steps:</ListIntro>
         <ListItem>Remittance advice
		  present for incoming receipt? If not, proceed to Step 6.</ListItem>
         <ListItem>Document known from
		  remittance advice? If not, proceed to Step 4.</ListItem>
         <ListItem>Anticipated or invoice
		  found? If so, match and go to next EBS.</ListItem>
         <ListItem>Reference or
		  description known from remittance advice? If not, proceed to Step 6.</ListItem>
         <ListItem>Anticipated or invoice
		  found? If so, match and go to next EBS.</ListItem>
         <ListItem>Payment reference
		  filled? If not, proceed to Step 10.</ListItem>
         <ListItem>Payment reference known
		  as reconciliation document? If not, proceed to Step 10.</ListItem>
         <ListItem>Anticipated document
		  status ready for receipt/payment? If not, proceed to Step 10.</ListItem>
         <ListItem>Receipt/paid amount
		  equals anticipated document amount, either complete or partial? If so, match
		  and select next EBS.</ListItem>
         <ListItem>Is a check number
		  known? If not, proceed to Step 13</ListItem>
         <ListItem>Amount on check number
		  equals paid amount? If not, proceed to Step 13.</ListItem>
         <ListItem>Anticipated payment
		  document status ready for payment? If so, match and go to next EBS.</ListItem>
         <ListItem>Is an invoice number
		  known? If not, proceed to Step 17.</ListItem>
         <ListItem>Invoice number found in
		  open invoice table? If not, proceed to Step 17.</ListItem>
         <ListItem>Same business partner
		  or child customer? If not, proceed to Step 17.</ListItem>
         <ListItem>Receipt/paid amount
		  equals invoice amount? If so, match and go to next EBS.</ListItem>
         <ListItem>Is the business partner
		  code known? If not, proceed to Step 20.</ListItem>
         <ListItem>Is there an open
		  invoice with the same open amount? If not, proceed to Step 23</ListItem>
         <ListItem>Match and go to next
		  EBS.</ListItem>
         <ListItem>Does another (one-time)
		  business partner exist with the same bank account? If not, proceed to Step 23.</ListItem>
         <ListItem>Does an open invoice
		  exist with the same open amount? If not, proceed to Step 23.</ListItem>
         <ListItem>Match and go to next
		  EBS.</ListItem>
         <ListItem>Automatic matching not
		  possible.</ListItem>
      </ProcedureList>
      <Paragraph>In the <GUIRef href="/baanerp/tf/cmg/tfcmg5103s000" role="session">Electronic Bank Statements (tfcmg5103s000)</GUIRef> session, you can manually match the
		transactions that cannot be automatically matched.</Paragraph>
   </GeneralSection>
   <RelatedTopics>
      <SectionTitle> Related topics</SectionTitle>
      <RelTopic>
         <Link href="/baanerp/tf/onlinemanual/000196" role="manual">Electronic Bank Statements</Link>
      </RelTopic>
   </RelatedTopics>
</ManualTopic>