Mismatch in GL balance between FAGLB03 and FAGLL03

Issue:

General Ledger account balance displayed in transaction FAGLB03, may not match with balance for the same period shown on double clicking any cell in FAGLB03. or with transaction FAGLL03.

Causes:

There could be various reasons for mismatch between FAGLB03 and FAGLL03, Below are some of  the common reasons 

Reason One: Transaction Figures not updated 

Some documents were posted in entry view, but did not update the ledger totals  

Solution:

To identify and correct such documents, follow the steps below 

• Execute t-code FAGLF03 ( Program: TFC_COMPARE_VZ) to compare document and transaction figures in order to identify the documents in error
• If FAGLF03 identifies documents which are not posted to one or more ledgers, Execute t-code GLGCU1 (Program: RGURECGLFLEX) to update the transaction totals for the documents in error in the corresponding ledgers 

Reason Two: Incorrect negative postings 

Due to a program error, some debit line items may be displayed as credit line items in transaction FAGLL03 or some credit line items may be displayed as debit line items as shown in the screenshot below.This is usually for negative postings made due for reversals

Solution:
There could be various causes for this error,
Check the following SAP notes for resolution according to your system conditions

Note 1113114 - FAGLL03: Incorrect plus/minus signs for negative postings
Note 1163346 - FAGLL03: Incorrect plus/minus signs for negative postings(2)
Note 1170400 - Document splitting: Incorrect posting key in new G/L

Reason Three: Database Inconsistencies 

Inconsistencies in the database at various levels may cause the transaction totals and balance to differ.

Solution:

Several reports are provided by SAP to analyze database inconsistencies for relevant tables. 

Note 1155429 - Analysis:Posting keys/debit/credit indicators in FI-GL (new) 

The not above provides reports to detect and analyze database inconsistencies in new GL line items.

Electronic Bank Statement Processing in SAP

The following pages from SAP Help site, provide excellent details on the Electronic Bank Statement Processing  methodology in SAP.It also provided detail explanation of the terms used to setup the electronic bank reconciliation process using SAP

Follow the link below for details:  

SAP Help : Electronic Bank Statement Processing

Tool to compare SAP financial statement versions, Configuration and Table

Recently I needed to compare Financial Statement Versions, Configurations and Table data between two SAP systems or clients in order to ensure synchronization across multiple landscape 

While SAP offers great tools to compare ABAP programs and many configurations within the system and across multiple systems, comparing financial statement versions, table data could be tricky. Comparison in Excel may work well for comparing table data, but it becomes a time consuming activity if you need to compare each and every cell 

I stumbled upon a beautiful tool to compare two text files. SAP allows any Financial Statement Version (FSV), Configuration or Table to be downloaded to a ASCII text (.txt) file using menu option System > List > Save > Local File > Unconverted in case of FSVs or Configuration screens 

On screens where the Save Local option is not available a Print option may also be used to download data to an unconverted .txt file. Only precaution required is, files from both the SAP systems or clients you need to compare should be downloaded with exact same procedure.

After downloading the data into two files to be compared, just enter the location of the two data files in the  Exam Diff  tool and it would provide you with usual analysis of entries which are common in both the files, records which exist in one file but do not exist in other file or records which exist in both the files but are different in some way 

ExamDiff is a freeware visual file comparison tool which can be downloaded from PrestoSoft's website at the following location: ExamDiff Download Page  It's also available for download on CNET.