In the general ledger, every transaction is recorded twice, once as a debit and as a credit. General ledger reconciliation is then defined as ensuring that each transaction is recorded correctly and placed in the appropriate account as a credit and debit.

What is a reconciliation in accounts?

What Is Reconciliation? Reconciliation is an accounting process that compares two sets of records to check that figures are correct and in agreement. Reconciliation also confirms that accounts in the general ledger are consistent, accurate, and complete.

What are the 3 types of reconciliation?

There are five main types of account reconciliation: bank reconciliation, customer reconciliation, vendor reconciliation, inter-company reconciliation and business-specific reconciliation. Let's explore each one of them in detail.

What is ledger reconciliation?

General ledger reconciliation is the process of comparison between accounts and data. Those tasked with the process will have to verify the books against other financial documents like statements, reports, and accounts.

What is GL reconciliation in SAP?

Reconcile the balances of the asset G/L accounts in Financial Accounting on the transfer date with the balances of your legacy system. ... Reconcile the accumulated values of the asset history sheet on the transfer date with the asset history sheet in your legacy system.

General Ledger: Reconciliation

How do I reconcile GL accounts in Excel?

1. Type the name of the general ledger account and the general ledger account number at the top of the Excel spreadsheet. ...
2. Enter the month and year to be reconciled below the GL name and number.

What is general ledger example?

Examples of General Ledger Accounts

asset accounts such as Cash, Accounts Receivable, Inventory, Investments, Land, and Equipment. liability accounts including Notes Payable, Accounts Payable, Accrued Expenses Payable, and Customer Deposits.

What are the 4 sections in a general ledger?

General ledgers contain four parts: the chart of accounts, financial transactions, account balances and accounting periods. Generally, accountants refer to the accounts from the chart of accounts as general ledger accounts.

What is in a general ledger?

Within a general ledger, transactional data is organized into assets, liabilities, revenues, expenses, and owner's equity. ... This data from the trial balance is then used to create the company's financial statements, such as its balance sheet, income statement, statement of cash flows, and other financial reports.

What is GL process?

GL process flow is a five-step process from recording the transactions in the system to finally running the reports containing financial data out of the system. ...

How do you automate a reconciliation in Excel?

To access the tool, go to the Get & Transform Data group on the Data tab of the Excel Ribbon, as shown in the screenshot below. The walk-through that follows provides further instructions specific to automating a large part of the bank reconciliation process.

What is GL and SL?

Both are used to record a financial transaction. The GL is a set of master accounts, and transactions are recorded, and SL is an intermediary set of accounts linked to the general ledger. GL contains all debit. ... Sub-ledger is a detailed subset of accounts that contains transaction information.

What is meant by itemization in GL reconciliation?

Itemization for General Ledger Documents. To check whether postings were transferred to the general ledger, you can create a list of the general ledger documents created during the transfer. Using additional selection criteria (such as company code and G/L account), you can restrict the display even further.

What is SAP general ledger?

General Ledger (G/L) accounts are used to provide a picture of external accounting and accounts and to record all the business transactions in a SAP system. This software system is fully integrated with all the other operational areas of a company and ensures that the accounting data is always complete and accurate.

What is the formula of reconciliation?

A bank reconciliation can be thought of as a formula. The formula is (Cash account balance per your records) plus or minus (reconciling items) = (Bank statement balance). When you have this formula in balance, your bank reconciliation is complete. ... The difference between these two balances is due to reconciling items.

What is Vlookup formula?

In its simplest form, the VLOOKUP function says: ... =VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).

How do you prepare a reconciliation statement?

1. Check for Uncleared Dues. ...
2. Compare Debit and Credit Sides. ...
3. Check for Missed Entries. ...
4. Correct them. ...
5. Revise the Entries. ...
6. Make BRS Accordingly. ...
7. Add Un-presented Cheques and Deduct Un-credited Cheques. ...
8. Make Final Changes.

How do you reconcile two sets of data in Excel?

1. Select the entire data set.
2. Click the Home tab.
3. In the Styles group, click on the 'Conditional Formatting' option.
4. Hover the cursor on the Highlight Cell Rules option.
5. Click on Duplicate Values.
6. In the Duplicate Values dialog box, make sure 'Duplicate' is selected.
7. Specify the formatting.

How do you reconcile two lists in Excel?

The quickest way to find all about two lists is to select them both and them click on Conditional Formatting -> Highlight cells rules -> Duplicate Values (Excel 2007). The result is that it highlights in both lists the values that ARE the same.

What is the formula for Excel?

In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.

What is GL in ERP?

The General Ledger (GL) is the primary accounting record for a business. It tracks all financial transactions and is used to generate the company's financial statements, including the Income Statement and Balance Sheet.

What is GL mapping?

GL mapping is the method of assigning a General Ledger account number to a financial transaction that is generated in PAS. It is handled using the GL Mapping table which contains contract attributes, account reference codes and the associated GL accounts.