SAP Financial Lock Box

SAP Financial Lock Box is a service that banks provide to facilitate the orderly assortment and processing of incoming payments. Instead of sending their payments to your office, prospects mail their payments and remittance advices on to a central financial institution location, normally a submit workplace box.Banks obtain the payments, create a data file of the shopper remittance information and payment amounts, and deposit the checks into your financial institution account. Frequently, you obtain this knowledge file for processing to replace your books.Depending on the choice of service together with your financial institution, the lock box file will comprise the following data: buyer name and (SAP) customer quantity, buyer MICR number (bank routing number and account quantity), check quantity, bill number, payment date, payment quantities/deductions per invoice and causes for underpayment. n Some advantages to utilizing a lock box embody lowering in-house-processing time, growing cash move and decreasing processing costs.

Clients ship their checks and remittance advices to your lock box.The bank processes the checks, credits your checking account, and sends you a detailed file of the data along with a day by day total.The lock box records data are transmitted utilizing numerous methods such as tapes, diskettes, and direct dial-in and download.The lock box import program posts a basic ledger entry to replace the corporates money position and creates a payment recommendation file from the financial institution input. The cost advice is compared to the client's open gadgets in accounts receivable and clears any matching items. Any checks that might not be fully processed by the lock box import process are then manually processed in the post processing transaction.

Customers ship their funds to a lock box. The financial institution collects the data and sends an ANSI 823 message to the R/three person's EDI server. The server translates the message utilizing as commonplace EDI interface into an IDOC (middleman doc) and sends it to the SAP server.Once the message is received by the SAP server, the information is saved in the FINSTA01 Lock box table.At the identical time a program is kicked off which generates the next:
  • Examine information is stored in financial institution statement tables
  • Payment advices are created which detail the disposition of the checks i.e. payment amount, invoice numbers, customer numbers, etc.
Then the lock box program is processed and the cost advices are cleared towards buyer open items. Any checks that could not be totally processed by the lock box process will be manually processed using the publish processing transaction.

The financial institution's data file usually follows a typical banking industry format referred to as BAI or BAI2. The BAI format provides basic information akin to examine quantity, examine quantity, financial institution number and bill numbers. This format does not break down the check quantity into particular person amounts per invoice. n The BAI2 format provides larger detail, such as the cost per invoice, deduction quantity per invoice and a motive code for the deduction often leading to a higher variety of cleared invoices.Due to the extra data offered, banks normally charge increased charges for producing this format.The BAI and BAI2 codecs might fluctuate barely by bank.MICR numbers are a standard numbering format used by banks and are located on the backside of every check. The MICR quantity has two components, the financial institution routing quantity (or transit quantity), a unique quantity identifying the financial institution, and the shopper's checking account number. Handbook or automated maintenance of buyer MICR info considerably enhances the hit fee for future money applications. This information is captured on the shoppers grasp file underneath financial institution details.ANSI x.12 codecs are mapped from the EDI subsystem into the SAP IDOC interface.

The lock box import program is most frequently configured to publish an entry to cash and to an unapplied money receipts account. When fee advice info is cleared in opposition to buyer open items, the open merchandise and the posting to the unapplied money receipt account are cleared. Any unapplied checks will stay in the unapplied money receipt account and can have to be manually processed in the publish processing transaction.A cost recommendation accommodates detailed information about an incoming payment. The quantity of element on an recommendation is decided by the information offered by the bank. Extra detailed financial institution info leads to a better rate of automatic clearing.A payment advice could embrace the following information: customer MICR quantity (bank routing number and account quantity), verify quantity, bill number(s), cost date, payment quantities/deductions per bill and reasons for underpayment.The Lock box Import program uses detailed information from the fee advice to mechanically search and match customer open merchandise(s). The document number on the payment advice is matched towards the document number in the customer open merchandise file. Therefore, accurate cost advice knowledge is critical for automated clearing to take place.

If the verify was applied or partially applied, the advice is deleted from the system after processing.If the verify was unprocessed or placed on account of customer, the recommendation is saved on file for additional processing.

The post course of function entails reviewing the status of the checks applied via the lock box function. You could manually clear any checks that were on-account of buyer or not applied to buyer accounts. Checks have 4 statuses: utilized, partially utilized, on-account or unprocessed. The lock box overview display screen details the number of checks in each category. Depending on the standing of the verify, the consumer determines what must occur to apply the check. For example, if the financial institution keyed within the incorrect bill quantity, the Lock box Import program posts the cost on account. In the post processing step, you entry the payment recommendation and correct the document quantity and upon saving the adjustments, the publish course of operate clears the open items, deletes the cost advice, and units the verify status to applied.Checks which can be partially utilized might require additional processing. For example, a examine could have paid five invoices, however one was incorrectly keyed. The primary four invoices would clear. The cost amount for the fifth invoice would be placed on-account and would have to be submit processed to clear.

Any payment that would not be identified either by the shopper's MICR number or the document number would stay unprocessed. Once the cost is researched and the shopper and bill is identified, it could be applied throughout post processing.The post course of operate entails reviewing the status of the checks utilized via the lock box function. You want to manually clear any checks that were on-account of buyer or not utilized to buyer accounts. Checks have 4 statuses: applied, partially applied, on-account or unprocessed.The lock box overview display screen details the number of checks in each category. Relying on the standing of the examine, the user determines what must occur to apply the check.For example, if the bank keyed in the incorrect bill quantity, the Lock box Import program posts the cost on account. In the publish processing step, you entry the cost recommendation and proper the document quantity and upon saving the modifications, the publish process perform clears the open items,deletes the fee recommendation, and units the verify status to applied.Checks that are partially applied might require further processing. For example, a examine could have paid 5 invoices, but one was incorrectly keyed. The first four invoices would clear. The cost amount for the fifth bill could be placed on-account and must be put up processed to clear.

Any payment that would not be recognized either by the customer's MICR number or the document number would remain unprocessed. As quickly as the payment is researched and the client and invoice is identified, it might be utilized throughout publish processing.In the posting knowledge screen, you configure info on who owns the lock box and the sorts of postings generated.You specify the lock box bank knowledge; the company code that owns the lock box, the financial institution and account the information is coming from, and the general ledger accounts that will be used to e-book the postings.You specify additional posting parameters: the document varieties that will be used to create the posting paperwork and the posting keys.

The Lock box Import display screen is where you tell R/3 the place the data is coming from and how you need it processed. You specify the data file title, the file format and the way the cost quantities can be cleared against the open items.

  1. Invoice numbers: Bill numbers may be outlined because the document number or the reference number.Depending on the manner you outline “bill quantity” on your firm, you possibly can choose how the system will match open gadgets; by doc quantity, by reference number, by reference quantity first than doc quantity second, or vice versa.
  2. Enhanced bill checking: This characteristic, when selected, verifies whether or not all of the bill numbers belong to the same buyer or teams of shoppers belonging together.
  3. Extra Account Project: If crucial, you can add a price date, enterprise area and/or revenue center if you would like to assign those values for all line items for bank accounts and sub-accounts, for each check in the lock box file .
  4. When working the lock box program, buyer tolerances established in FI are checked to decide if “Difference is simply too massive for clearing”. Due to this fact, these tolerances have a think about determining if the system clears the open item or locations it “On Account” .
For BAI2 and EDI formats, if the cost has a reason code that displays a cost-off to an account, the merchandise is cleared and the difference related to that motive code is posted to a charge off account.

Related Posts


SAP project go live and support
SAP mini applications programming and setup
SAP Project design look and feel
My SAP Project safety and security

No comments :

Post a Comment