<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tf/onlinemanual/000302" xml:lang="en">
	<Header>
		<Title xmlns:ssa="http://www.ssaglobal.com" xmlns:HTML="http://www.w3.org/TR/REC-html40">GL Account matching</Title>
		<Keyword><Level1>matching accounts</Level1>
		</Keyword>
		<Keyword><Level1>account matching</Level1>
		</Keyword>
	</Header>
	<GeneralSection><List><ListIntro>GL account matching consists of the matching of credit and debit entries on a single ledger account. GL account matching is usually performed on the following types of ledger accounts:</ListIntro>
			<ListItem><Link href="/baanerp/tf/glossary/glossary#000327" role="glossary">Interim accounts</Link>.</ListItem>
			<ListItem><Link href="/baanerp/tf/glossary/glossary#000308" role="glossary">Clearing accounts</Link>.</ListItem>
			<ListItem><Link href="/baanerp/tf/glossary/glossary#000340" role="glossary">Suspense accounts</Link>.</ListItem>
		</List>
		<Paragraph>When you close a period, the balance of these ledger accounts must be zero or the smallest amounts possible. Usually, the related postings balance and can be matched. If the amounts of the related transactions differ by a small amount, SSA ERP can generate a matching transaction to balance the account.</Paragraph>
		<Paragraph>When you analyze these accounts, you can print a report of the transactions that balance and you can examine the unmatched postings.</Paragraph>
		<GeneralSection><SectionTitle>Basic rules for GL account matching</SectionTitle>
			<List><ListIntro>The basic rules for GL account matching are:</ListIntro>
				<ListItem><List><ListIntro>You can perform GL account matching on accounts that are:</ListIntro>
						<ListItem>Of the type <GUIRef href="/baanerp/tf/domains/gld.actp#balance" role="enum">Balance Sheet</GUIRef> or <GUIRef href="/baanerp/tf/domains/gld.actp#profitloss" role="enum">Profit &amp; Loss</GUIRef>.</ListItem>
						<ListItem>Defined as matchable accounts. The <GUIRef href="/baanerp/tf/gld/tfgld0108s000#tfgld008.mach" role="formfield">Matching</GUIRef> check box must be selected for the account in the <GUIRef href="/baanerp/tf/gld/tfgld0108s000" role="session">Chart of Accounts (tfgld0108s000)</GUIRef> session.</ListItem>
						<ListItem>Not used for integration transactions.</ListItem>
					</List>
				</ListItem>
				<ListItem>You can only perform GL account matching of entries on the same account.</ListItem>
				<ListItem>The transactions to be matched can be in different transaction currencies.</ListItem>
				<ListItem>You can perform GL account matching on finalized transactions.</ListItem>
				<ListItem>You can unmatch transactions, even if the matching transactions have already been finalized.</ListItem>
			</List>
			<List><ListIntro>In the GL account matching process, the following situations can occur:</ListIntro>
				<ListItem>There is no difference between the sums of the credit amounts and the debit amounts of the selected transactions, or the difference is within the currency tolerance. The transactions are matched.</ListItem>
				<ListItem>The sums of the credit amounts and the debit amounts differ by the tolerance percentage and/or the tolerance amount or more. The transactions cannot be matched.</ListItem>
				<ListItem>The difference between the sums of the credit amounts and the debit amounts is within the matching tolerance percentage and less than the matching tolerance amount. The transactions can be matched with a matching transaction for the difference amount.</ListItem>
			</List>
		</GeneralSection>
		<GeneralSection ID="incomplete.match"><SectionTitle>To match with a matching transaction</SectionTitle>
			<Paragraph>If a matching transaction is generated for the difference amount, the amounts in the home currencies are calculated from the difference amount in the transaction currency by using the internal exchange rate type.</Paragraph>
			<List><ListIntro>The following situations can occur:</ListIntro>
				<ListItem>The remaining amount in each of the home currencies is zero or within the currency tolerance.</ListItem>
				<ListItem><List><ListIntro>The remaining amount in at least one home currency is not zero. This can be caused by currency rate changes between the transaction dates of the transactions to be matched. Two possibilities exist:</ListIntro>
						<ListItem>The differences in the home currencies stay on the GL account.</ListItem>
						<ListItem>To balance the account in the home currencies, a second transaction is generated for the difference amounts in the home currencies. The transaction is directly based on the difference amount, no currency rates are involved.</ListItem>
					</List>
				</ListItem>
			</List>
			<Paragraph>One side of the matching transactions balances the transactions on the GL account. The other side of the matching transactions is posted to a Matching Account.</Paragraph>
			<ExampleSection><SectionTitle>Example 1: Home currencies balance</SectionTitle>
				<Paragraph>After generating the matching transaction, no difference amount remains in the various home currencies.</Paragraph>
				<TABLE border="1"><TBODY><TR><TH></TH>
							<TH>Transaction amount</TH>
							<TH>Transaction currency</TH>
							<TH>D/C</TH>
							<TH>Local currency EUR</TH>
							<TH>Reporting currency 1 USD</TH>
							<TH>Reporting currency 2 CAD</TH>
						</TR>
						<TR><TD>Transaction 1</TD>
							<TD align="right">100</TD>
							<TD align="right">GBP</TD>
							<TD align="right">D</TD>
							<TD align="right">90</TD>
							<TD align="right">101</TD>
							<TD align="right">50</TD>
						</TR>
						<TR><TD>Transaction 2</TD>
							<TD align="right">50</TD>
							<TD align="right">GBP</TD>
							<TD align="right">C</TD>
							<TD align="right">45.4</TD>
							<TD align="right">49.80</TD>
							<TD align="right">24.4</TD>
						</TR>
						<TR><TD>Transaction 3</TD>
							<TD align="right">51</TD>
							<TD align="right">GBP</TD>
							<TD align="right">C</TD>
							<TD align="right">45.5</TD>
							<TD align="right">51.10</TD>
							<TD align="right">25.1</TD>
						</TR>
						<TR><TD>Matching transaction</TD>
							<TD align="right">1</TD>
							<TD align="right">GBP</TD>
							<TD align="right">D</TD>
							<TD align="right">0.9</TD>
							<TD align="right">0.10</TD>
							<TD align="right">0.5</TD>
						</TR>
						<TR><TD>Result</TD>
							<TD align="right">0</TD>
							<TD align="right"></TD>
							<TD align="right"></TD>
							<TD align="right">0</TD>
							<TD align="right">0</TD>
							<TD align="right">0</TD>
						</TR>
					</TBODY>
				</TABLE>
				<Paragraph>The other side of the matching transaction is posted to the Matching Account. In this case, the entry on the Matching Account consists of: GBP 1; EUR 0.9; USD 0.1; CAD 0.5.</Paragraph>
			</ExampleSection>
			<ExampleSection><SectionTitle>Example 2: Incomplete matching</SectionTitle>
				<Paragraph>A currency difference amount remains in some of the home currencies. This can happen both if a matching transaction is needed and if a matching transaction is not needed as shown in this example.</Paragraph>
				<TABLE border="1"><TBODY><TR><TH width="88"></TH>
							<TH width="100">Transaction amount</TH>
							<TH>Transaction currency</TH>
							<TH>D/C</TH>
							<TH>Local currency EUR</TH>
							<TH>Reporting currency 1 USD</TH>
							<TH>Reporting currency 2 CAD</TH>
						</TR>
						<TR><TD width="88">Transaction 1</TD>
							<TD align="right" width="100">100</TD>
							<TD align="right">GBP</TD>
							<TD align="right">D</TD>
							<TD align="right">90.1</TD>
							<TD align="right">101.02</TD>
							<TD align="right">50.5</TD>
						</TR>
						<TR><TD width="88">Transaction 2</TD>
							<TD align="right" width="100">100</TD>
							<TD align="right">GBP</TD>
							<TD align="right">C</TD>
							<TD align="right">90.9</TD>
							<TD align="right">101.1</TD>
							<TD align="right">50.5</TD>
						</TR>
						<TR><TD width="88">Result</TD>
							<TD align="right" width="100">0</TD>
							<TD align="right"></TD>
							<TD align="right"></TD>
							<TD align="right">0.8</TD>
							<TD align="right">0.08</TD>
							<TD align="right">0</TD>
						</TR>
					</TBODY>
				</TABLE>
			</ExampleSection>
			<ExampleSection ID="base.on.difference"><SectionTitle>Example 3: Matching based on a difference</SectionTitle>
				<Paragraph>After generating the matching transaction a currency difference amount remains in the home currencies. A second matching transaction is generated based on the difference amounts.</Paragraph>
				<Paragraph>This transaction is comparable to a currency difference transaction. The transaction amounts in the home currencies are not related to each other through a currency rate.</Paragraph>
				<TABLE border="1"><TBODY><TR><TH width="133"></TH>
							<TH width="142">Transaction amount</TH>
							<TH>Transaction currency</TH>
							<TH>D/C</TH>
							<TH>Local currency EUR</TH>
							<TH>Reporting currency 1 USD</TH>
							<TH>Reporting currency 2 CAD</TH>
						</TR>
						<TR><TD width="133">Transaction 1</TD>
							<TD align="right" width="142">100</TD>
							<TD align="right">GBP</TD>
							<TD align="right">D</TD>
							<TD align="right">90.1</TD>
							<TD align="right">101.2</TD>
							<TD align="right">50.1</TD>
						</TR>
						<TR><TD width="133">Transaction 2</TD>
							<TD align="right" width="142">100</TD>
							<TD align="right">GBP</TD>
							<TD align="right">C</TD>
							<TD align="right">90.9</TD>
							<TD align="right">101.1</TD>
							<TD align="right">50.5</TD>
						</TR>
						<TR><TD width="133">Result</TD>
							<TD align="right" width="142">0</TD>
							<TD align="right"></TD>
							<TD align="right"></TD>
							<TD align="right">0.8</TD>
							<TD align="right">0.08</TD>
							<TD align="right">0</TD>
						</TR>
						<TR><TD width="133">Transaction based on difference in local currency</TD>
							<TD align="right" width="142"></TD>
							<TD align="right"></TD>
							<TD align="right"></TD>
							<TD align="right">0.8</TD>
							<TD align="right"></TD>
							<TD align="right"></TD>
						</TR>
						<TR><TD width="133">Transaction based on difference in reporting currency</TD>
							<TD align="right" width="142"></TD>
							<TD align="right"></TD>
							<TD align="right"></TD>
							<TD align="right"></TD>
							<TD align="right">0.08</TD>
							<TD align="right"></TD>
						</TR>
						<TR><TD width="133">Result</TD>
							<TD align="right" width="142">0</TD>
							<TD align="right"></TD>
							<TD align="right"></TD>
							<TD align="right">0</TD>
							<TD align="right">0</TD>
							<TD align="right">0</TD>
						</TR>
					</TBODY>
				</TABLE>
				<Paragraph>The other side of the matching transaction is posted to the Matching Account.</Paragraph>
				<List><ListIntro>In this case, the entries on the Matching Account consist of:</ListIntro>
					<ListItem>First entry: GBP 1; EUR 0.9; USD 0.1; CAD 0.5.</ListItem>
					<ListItem>Second entry: GBP 0; EUR 0.8; USD 0; CAD 0.</ListItem>
					<ListItem>Third entry: GBP 0; EUR 0; USD 0.08; CAD 0.</ListItem>
				</List>
			</ExampleSection>
		</GeneralSection>
		<GeneralSection><SectionTitle>Frequently used accounts for general ledger account matching</SectionTitle>
			<List><ListItemHead>Sundry debtors and creditors accounts</ListItemHead>
				<ListItem>This account records receivables and payables that are not directly attached to the operating business cycle. For example, to register assignment expenses to be refunded and for which the posting is uncertain at the time of recording. This record is also used to record purchases on behalf of third parties, that must not be posted to the profit and loss account.</ListItem>
				<ListItemHead>Suspense accounts</ListItemHead>
				<ListItem>An account that records operations that cannot be posted definitely to an account. However, such accounts must not appear on the balance sheet. For example, when bank reconciliation is carried out to bring the balance of the company's account into line with that of the bank, the unidentified movements (such as customer payments) listed on the bank statements are posted to a suspense amount.</ListItem>
				<ListItemHead>Internal transfer accounts</ListItemHead>
				<ListItem>These clearing accounts are used for practical and controlled accounting operations, such as transferring cash funds to a bank account. In addition, such accounts are used for operations that require several accounting journals. Internal accounts must not appear on the balance sheet.</ListItem>
				<ListItemHead>Intracompany sales accounts</ListItemHead>
				<ListItem>These intracompany accounts are debited for goods and services provided, and credited for goods and services received. The accounts of a company's various branches must balance out and must not appear on the balance sheet.</ListItem>
				<ListItemHead>Account advances granted for personnel</ListItemHead>
				<ListItem>This is an account that records debit advances and credits them to salaries from which the advances are deducted.</ListItem>
				<ListItemHead>Group accounts</ListItemHead>
				<ListItem>These accounts record temporary advances of funds within companies of the same group.</ListItem>
			</List>
			<Paragraph>For some interim accounts, SSA ERP automatically generates the transaction reference when the transaction is created. For example, the transaction reference can consist of the transaction origin plus the order number.</Paragraph>
			<Note><SectionTitle>Note</SectionTitle>
				<Paragraph>You cannot perform GL account matching on ledger accounts that are used for integration transactions. The transactions on these ledger accounts are balanced during the reconciliation process.</Paragraph>
			</Note>
		</GeneralSection>
		<GeneralSection><SectionTitle>To set up GL account matching</SectionTitle>
			<ProcedureList><ListIntro>To set up GL account matching, take the following steps:</ListIntro>
				<ListItem><List><ListIntro>In the <GUIRef href="/baanerp/tf/gld/tfgld0108s000" role="session">Chart of Accounts (tfgld0108s000)</GUIRef> session:</ListIntro>
						<ListItem>Select the <GUIRef href="/baanerp/tf/gld/tfgld0108s000#tfgld008.mach" role="formfield">Matching</GUIRef> check box for the accounts for which you want to perform GL account matching. The accounts must be of the type <GUIRef href="/baanerp/tf/domains/gld.actp#balance" role="enum">Balance Sheet</GUIRef> or <GUIRef href="/baanerp/tf/domains/gld.actp#profitloss" role="enum">Profit &amp; Loss</GUIRef>, and they must not be used for integration transactions.</ListItem>
						<ListItem>For each matchable account, select the <GUIRef href="/baanerp/tf/gld/tfgld0108s000#tfgld008.dmsq" role="formfield">Default Matching Sequence</GUIRef>. Zoom to the <GUIRef href="/baanerp/tf/gld/tfgld1517m000" role="session">Matching Series by Ledger Account (tfgld1517m000)</GUIRef> session.</ListItem>
						<ListItem>In the <GUIRef href="/baanerp/tf/gld/tfgld1517m000" role="session">Matching Series by Ledger Account (tfgld1517m000)</GUIRef> session, define the series used to create document numbers for the generated matching transactions.</ListItem>
					</List>
				</ListItem>
				<ListItem>If required, in the <GUIRef href="/baanerp/tf/gld/tfgld1218m000" role="session">Rebuild History for GL Account Matching (tfgld1218m000)</GUIRef> session, rebuild the ledger account history.</ListItem>
				<ListItem><List><ListIntro>In the <GUIRef href="/baanerp/tf/gld/tfgld0103s000" role="session">Company Parameters (tfgld0103s000)</GUIRef> session, define the following data:</ListIntro>
						<ListItem>The <GUIRef href="/baanerp/tf/gld/tfgld0103s000#tfgld004.smac" role="formfield">Statutory Matching Account</GUIRef> and the <GUIRef href="/baanerp/tf/gld/tfgld0103s000#tfgld004.cmac" role="formfield">Complementary Matching Account</GUIRef>. Depending on whether the GL account is a statutory or a complementary account, one side of the matching transactions is posted to the statutory or the complementary matching account.</ListItem>
						<ListItem>The <GUIRef href="/baanerp/tf/gld/tfgld0103s000#tfgld004.mtol" role="formfield">Matching Tolerance (Percentage)</GUIRef>.</ListItem>
						<ListItem>The <GUIRef href="/baanerp/tf/gld/tfgld0103s000#tfgld004.atol" role="formfield" Update="No">Matching Tolerance (Amount)</GUIRef>.</ListItem>
						<ListItem>The <GUIRef href="/baanerp/tf/gld/tfgld0103s000#tfgld004.mtyp" role="formfield">Matching Transaction Type</GUIRef>.</ListItem>
						<ListItem><List><ListIntro>In the <GUIRef href="/baanerp/tf/gld/tfgld0103s000#tfglds0103.01" role="groupbox">Manual Matching Parameters</GUIRef> box, specify whether you want to:</ListIntro>
								<ListItem>Allow incomplete matching, where after matching a small currency difference remains in at least one home currency.</ListItem>
								<ListItem>Generate transactions based on the difference amounts in the home currencies after matching.</ListItem>
								<ListItem>Match transactions in different transaction currencies.</ListItem>
								<ListItem>The home currency for the matching transaction if the transaction currencies differ.</ListItem>
							</List>
						</ListItem>
					</List>
				</ListItem>
			</ProcedureList>
		</GeneralSection>
		<GeneralSection><SectionTitle>To perform GL account matching</SectionTitle>
			<List><ListIntro>You can perform GL account matching:</ListIntro>
				<ListItem>Automatic, in the <GUIRef href="/baanerp/tf/gld/tfgld1216m000" role="session">GL Account Matching - Automatic (tfgld1216m000)</GUIRef> session. The transactions must have a transaction reference. To generate matching transactions, select the <GUIRef href="/baanerp/tf/gld/tfgld1216m000#trans" role="formfield">Generate Transactions</GUIRef> check box.</ListItem>
			</List>
			<Paragraph><GUIRef href="" role="manual">Note</GUIRef>SSA ERP can only automatically match debit transactions with credit transactions. For example, to match a debit posting of a positive amount with a debit posting of a negative amount, you must run the <GUIRef href="/baanerp/tf/gld/tfgld1516m000" role="session">GL Account Matching - Manually (tfgld1516m000)</GUIRef> session.</Paragraph>
			<List><ListItem>Manually, in the <GUIRef href="/baanerp/tf/gld/tfgld1516m000" role="session">GL Account Matching - Manually (tfgld1516m000)</GUIRef> session. In this session, you can select the transactions that you wish to match. You can also use this session to match transactions that are not linked by a transaction reference.</ListItem>
				<ListItem>If the selected transaction balance, on the <GUIRef href="" role="menu">Specific</GUIRef> menu you can click <GUIRef href="/baanerp/tf/gld/tfgld1516m000#match.without.transaction" role="formcommand">Match without Transaction</GUIRef>. If the sums of the credit amounts and the debit amounts of the selected transactions differ, you can click <GUIRef href="/baanerp/tf/gld/tfgld1516m000#match.with.transaction" role="formcommand">Match with Transaction</GUIRef>. <List><ListItem>If you click <GUIRef href="/baanerp/tf/gld/tfgld1516m000#match.with.transaction" role="formcommand">Match with Transaction</GUIRef>, the <GUIRef href="/baanerp/tf/gld/tfgld1217m000" role="session">Create GL Account Matching Transactions - Manually (tfgld1217m000)</GUIRef> starts.</ListItem>
						<ListItem>In the <GUIRef href="/baanerp/tf/gld/tfgld1217m000" role="session">Create GL Account Matching Transactions - Manually (tfgld1217m000)</GUIRef> session you can enter the matching account and the dimensions and various other details of the matching transaction.</ListItem>
						<ListItem>To generate a matching transaction for the remaining differences in the home currencies, select the <GUIRef href="/baanerp/tf/gld/tfgld1217m000#based.on.diff" role="formfield">Post Differences</GUIRef> check box.</ListItem>
					</List>
				</ListItem>
				<ListItem><List><ListIntro>In the following sessions, you can match manually entered transactions prior to finalization:</ListIntro>
						<ListItem>Journal vouchers, in the <GUIRef href="/baanerp/tf/gld/tfgld1103s000" role="session">Journal Vouchers (tfgld1103s000)</GUIRef> session.</ListItem>
						<ListItem>Purchase transaction lines, in the <GUIRef href="/baanerp/tf/acp/tfacp1120s000" role="session">Purchase Invoice Transactions (tfacp1120s000)</GUIRef> session.</ListItem>
						<ListItem>Sales transaction lines, in the <GUIRef href="/baanerp/tf/acr/tfacr1111s000" role="session">Sales Invoice Transactions (tfacr1111s000)</GUIRef> session.</ListItem>
						<ListItem>Bank transaction journals, in the <GUIRef href="/baanerp/tf/cmg/tfcmg2120s000" role="session">Cash Management Transactions (tfcmg2120s000)</GUIRef> session.</ListItem>
					</List> If in these sessions you create transactions on a matchable ledger account, on the <GUIRef href="" role="menu">Specific</GUIRef> menu you can click <GUIRef href="/baanerp/tf/cmg/tfcmg2120s000#exec.user.1" role="formcommand">GL Account Matching</GUIRef> to start the <GUIRef href="/baanerp/tf/gld/tfgld1516m000" role="session">GL Account Matching - Manually (tfgld1516m000)</GUIRef> session. You can use this session to match transactions and to view the debit transactions and credit transactions on the account.</ListItem>
			</List>
			<Note><SectionTitle>Note</SectionTitle>
				<Paragraph>After matching an unfinalized transaction, you cannot make any changes to the transaction.</Paragraph>
			</Note>
		</GeneralSection>
		<GeneralSection><SectionTitle>Rebuild GL accounts for matching</SectionTitle>
			<Paragraph>You can define a ledger account on which transactions already exist as a matchable account. In the <GUIRef href="/baanerp/tf/gld/tfgld0108s000" role="session">Chart of Accounts (tfgld0108s000)</GUIRef> session, you can select the <GUIRef href="/baanerp/tf/gld/tfgld0108s000#tfgld008.mach" role="formfield">Matching</GUIRef> check box. If you do this, the corresponding Balance Analysis (tfglf116) table must be filled with the existing transactions.</Paragraph>
			<Paragraph>To generate the records in the Balance Analysis (tfglf116) table, run the <GUIRef href="/baanerp/tf/gld/tfgld1218m000" role="session">Rebuild History for GL Account Matching (tfgld1218m000)</GUIRef> session.</Paragraph>
		</GeneralSection>
	</GeneralSection>
</ManualTopic>
