0% found this document useful (0 votes)
48 views9 pages

Balance Sheet Reconciliation Process

Uploaded by

Rajesh Varma
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
48 views9 pages

Balance Sheet Reconciliation Process

Uploaded by

Rajesh Varma
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

BALANCE SHEET RECONCILIATIONS

Definition:

Balancesheet reconciliation is providing substantiation for the balances in the GL accounts, in this we have to check accuracy a
* Analysing Nature of transactions whether they are valid with accounting treatment or not
Movement explanation from previous month to current month is called as Balancesheet reconciliation
An account reconciliation is prepared to assess the validity, correctness or appropriateness of an account balance at a specifi

Need of BS recons:
BS recons helps for decistion making and it will also helps for Bankers to evaluate the creditworthyness of the business.

Substantiation:

Journal Copy
Invoice copy
Email Copy
PO, SAP Screenshots that ties to the GL
Bank statement to support GL balance of a Bank(even if the account has a $0 balance)
Amortization schedule along with Invoice copy to support prepaid rent/prepaid Insurance.
Previous month Invoice to support current month accruals.
Utility or Tax Bill
Travel Reports
Calculation for amortization of prepayments and Bad debts etc

Process
we will take the previous month reconcilition as a starting point for the current month, and save it in my personal folder.
I will change the dates accordingly
I will go to SAP and enter FS10n [Link] and extract the MTD balance and add it to the previous month transactions
once we add it we will check if any knock off items (offsetting items) and delete it from the excel
I will check all the line items whether they are valid with accounting treatment or not
and provide substantiation, and remove supporting which are no longer relvant to the current balance
and we will do reclass or write offs whereever required and mention the comments for aged open items
Provide action plan to resolve reconciling items and ensure reconciling items are actioned timely

Due dates

D+7---------D+10----------D+12

Number of recons

42….

what kind of reconciliation you will be performing take one example and explain me.
Accrued expence, Prepaid Insurance, Prepaid rent, Bank, O/s Salaries, Share capital, Bonus accruals,

Preparer----------------------Reviewer------------------------Approver
Shared Drive.

Blackline Tool..

Service Level Agreements SLA

what are the 3 parameter you will see in Blackline while uploading the recon
Required Adjustment------- Means any GL balance having wrong postings and which can be rectified sebsequently
List component-------- Other than RA, TI we will upload through this option
Timing items- Any last minute payments which did not reflected in Bank statements due to timing difference will be uploaded

what are the advantages of Blackline/What is Blackline


Blackline is a third party tool where review and approval will happen in the tool it self, it will also track the SLA's and Time, if w
automatic emails saying that there is some action pending from blackline.
***** we also use blackline for task module certifications as and when we finish the tasks we can certify in Blackline tool.

Service level Agreements

WHAT IS OPEN ITEM ?

un Finished business transaction


Any transaction posted in GL account is an open item

Two types:

Reconciled Open Item: when it has supprting we will call it as reconciled open item
Un reconciled open item: when there is no supporting for the balances in GL account we will call it as un reconciled open item

what is aged/aged open item

Any item sitting in balance sheet GL account more than 90 days is called as aged open item

I will follow up with respective teams


Preparer
Approver
Reviewer

SLA KPI

Service Level Agreement Key Performance Indicators


High
Medium
low share capita;l
reserves

Customer 500000
to sales 500000

Bank A/c Dr 400000


to customer 400000

posting date
Customer 12/20/2022
sales
Customer
to sales

Bank A/c Dr
to customer A/c Cr

Current
4/20/2023 121
500000
500000

500000
500000
200200
2/23/2023 Customer 40000
to sales 40000
Electricity A/c Dr 5000
OCT to Electricity Payable 5000

-5000 NOV Electricity Payable 5000


to Electricity 5000

NOV Electricity 5000


to ELE payable 5000

Common questions

Powered by AI

Challenges from using previous month reconciliations as a starting point include the risk of carrying over unresolved discrepancies, outdated information, or errors into the new reconciliation period. These issues could lead to inaccurate financial reporting if not addressed timely. To mitigate these challenges, it is vital to thoroughly review and validate the previous month's data, removing obsolete or irrelevant information before initiating current reconciliations. Additionally, implementing a robust process of verification and validation will ensure that any past errors are identified and corrected early in the cycle. Such diligence ensures the integrity of the new financial data .

Timing items in balance sheet reconciliations refer to transactions that occur close to the cut-off period but do not reflect in bank statements immediately due to timing differences. These items are significant because they can temporarily skew the GL account balances. In the reconciliation process, timing items are identified and enumerated to provide clarity on why discrepancies exist on the balance sheet. They are subsequently uploaded through specific list components to ensure that such pending transactions are accounted for and matched with the bank statements in future reconciliations, thus enhancing the accuracy and reliability of financial reports .

In financial accounting, open items refer to transactions in the GL account that remain unresolved, often reflecting unfinished or pending business actions. An open item becomes a reconciled open item when it has adequate supporting documentation confirming the transaction's accuracy and validity. The distinction lies in the level of substantiation; reconciled open items have undergone scrutiny to ensure they reflect true and accurate business activity, whereas open items may indicate areas needing further investigation or correction. Effective reconciliation practices transform open items into reconciled items, thus enhancing the reliability and completeness of financial reports .

From a banker's perspective, reconciliation processes are critical for assessing a company's creditworthiness because they provide a transparent and accurate view of its financial position. Through reconciliation, discrepancies in financial records are identified and rectified, resulting in cleaner and more reliable financial statements. These reconciliations show that a company maintains proper financial controls and adheres to accounting standards, which are indicators of sound financial management. This reliability in financial reporting helps bankers assess the risk involved in lending and therefore, determine the credit terms and limits appropriately .

The process of handling reconciling items impacts a company's financial audits by ensuring that any discrepancies between the GL accounts and their supporting documents are identified and rectified promptly. This proactive management of reconciling items reduces the likelihood of audit adjustments and provides auditors with transparent evidence of accurate financial practices. By maintaining through reconciliations, companies demonstrate compliance with accounting standards and improve the reliability of their financial data, resulting in fewer issues during external audits and enhancing the credibility of their financial reporting .

The primary purpose of balance sheet reconciliation is to substantiate the balances in General Ledger (GL) accounts by assessing their validity, correctness, or appropriateness. This process involves checking the accuracy of transactions and ensuring that all entries align with accounting treatments. Balance sheet reconciliation is essential for business decision-making because it helps provide accurate financial information, which is crucial for evaluating a company's creditworthiness and overall financial health. Moreover, it aids in identifying discrepancies or errors that need correction, thereby ensuring compliance with financial regulations and enhancing transparency .

Service Level Agreements (SLAs) are significant for the reconciliation process in a financial organization as they define the expected timelines and standards that reconciliation activities must meet. SLAs help ensure that each step of the reconciliation process—from preparation to approval—is completed within set deadlines, thus facilitating timely and efficient financial reporting. By establishing these benchmarks, SLAs help manage performance expectations and maintain accountability among team members involved in the reconciliation process. Compliance with SLAs can also reduce operational risks, enhance the accuracy of financial statements, and support regulatory adherence .

The balance sheet reconciliation process assists in managing aged open items by providing a structured approach to identify, substantiate, and address these items. Aged open items, defined as transactions sitting in the GL account for more than 90 days without resolution, are highlighted during reconciliations. By systematically examining each line item for valid accounting treatment and substantiation, businesses can develop action plans to resolve reconciling items. This process helps ensure that aged open items are addressed in a timely manner, thereby reducing potential financial discrepancies and improving the accuracy of financial statements .

The Blackline tool plays a critical role in the reconciliation process by providing a platform for review, approval, and tracking of reconciliations. It enhances the efficiency of balance sheet reconciliations by automating workflows and notifying users of pending actions via automatic emails. Blackline enables real-time tracking of Service Level Agreements (SLAs) and timings, ensuring that reconciliations are completed within designated periods. Additionally, it supports the task module for certifications, allowing teams to collectively monitor progress and complete reconciliations more efficiently .

Substantiation of transactions improves the reliability of financial reporting by providing concrete evidence for each transaction recorded in the GL accounts, ensuring that they are valid and correctly accounted for. This involves verifying transactions with supporting documents such as journal entries, invoices, bank statements, and other relevant records. These steps help identify and correct any errors or misstatements, thereby increasing the accuracy and credibility of financial statements. Furthermore, substantiation mitigates the risk of fraud and financial misrepresentation, thus fostering stakeholders' trust in the reported financial outcomes .

You might also like