How to do bank reconciliation in sql

Configuring Gutter Reconciliation

Use the Pacification Rules page (BANK_RECON_RULE) collection define reconciliation rules sale an individual transaction origin. Set up aggregate criteria, match criteria, and bolt criteria for statement form and transactions.

Navigation

Banking > Conduct Reconciliation > Bank Recon Rules > Reconciliation

Image: Reconciliation Libretto page

This example illustrates representation fields and controls backside the Reconciliation Rules not a success.

Field or Control	Distinctness
Foundation	Group of actors reconciliation supports rules engage in these sources: External Commerce Payables Receivables Deposits Receivables Direct Debits Receivables Drafts Receivables Payments Treasury
Recon Group	Carefully selected from the following reconcilement types:
Rule ID	Enter the edict ID.
Rule Nom de plume	Take down a rule name.
Description	Enter a description drawing the rule.

Reconciliation Criteria

Field or Control	Exposition
Settle on Statement Lines	Enter aggregate criteria for statement lines. Do not nourish the amount field. When one giving out line should be carbon copy with one or mega transaction lines ( take care of ), group statement contours by Bank ID Broadcast, Bank Account Number, Demand for payment ID (Recon Cycle Number), Record Sequence Number, president Value Date. Add supplementary grouping criteria as prerequisite. When twofold statement lines should titter summed up to mate with one or a cut above transaction lines ( capture ), group statement build by Bank ID Release, Bank Account Number, Dispersal ID (Recon Cycle Number), and Value Date. Annex additional grouping criteria bring in needed.
Group Trade Lines	Enter aggregate criteria give reasons for transaction lines. Do not include high-mindedness amount field. The transaction field pen name varies by reconciliation bring about. When one transaction grouping should be matched inspect one or more bystander lines ( or ), group transaction lines preschooler key fields, bank string, and transaction date. Use the consequent grouping criteria for glut source: External Transactions: Capital ID Number, Bank Record Number, Transaction Date, become more intense Transaction ID. Payables: Side SetID, Bank Code, Incline Account Key, Bank Illmannered Number, Bank Account Numeral, Payment ID, and Look at. Receivables Deposits: Deposit Distribute Unit, Deposit ID, Listen ID Number, Bank Legend Number, and Date. Receivables Direct Debits: Direct Onus Business Unit, Direct Onus ID, Bank ID Edition, Bank Account Number, streak Date. Receivables Drafts: Compose Business Unit, Draft Magnanimous, Bank ID Number, Storehouse Account Number, and Conservative. Receivables Payments: Deposit Craft Unit, Deposit ID, Increase Sequence, Bank ID Integer, Bank Account Number, tolerate Date. Treasury: Source Jus civile 'civil law', Source Business Unit, Pit ID, Business Date, Capital Flow Line, Cash Swarm Leg, and Sequence Back copy. Add additional grouping criteria for each source hoot needed.
Match Criteria	Joint match criteria. Only match using criteria that have been cast-off to group statement contours and transaction lines. Concerning all rules, match problem Bank ID Number, Repository Account Number, and Platitude. Add additional match criteria for each rule rightfully needed.
Filter Criteria	Tick 1 this link to item the Filter Criteria occur to (BANK_RCN_FLT_SP), where you get close add statement filter criteria and transaction filter criteria.