Skip to main content

General Ledger to Sub-Ledger Reconciliation with Reasons


Reconciliation of the general ledger to sub-ledgers is another type we will review. The general ledger (or simply "ledger" or "G/L") is a collection of all balance sheet and income statement accounts. The general ledger also includes all journal entries posted to accounts. In nowadays' computerized world, the ledger is maintained in an electronic form.



A sub-ledger is a detailed record of transactions for an individual account. Usually, a sub-ledger contains detail of transactions for an account, which are summarized by day (or month) and the total is then posted to the general ledger. Therefore, sub-ledgers serve as support for amounts posted to the general ledger. Sub-ledgers are presented in an electronic form as well (e.g. Excel file, detail of an account in QuickBooks, SAP or Oracle). For example, accounts receivable sub-ledger may contain detail for all issued invoices and cash receipts. At the end of a day, an accountant can summarize all invoices issued (sales) and cash receipts (cash collections) and post them to the general ledger in two separate journal entries. The general ledger would not contain detail for each individual transaction.



As there is always room for a human error, it is important to reconcile the general ledger balances to the sub-ledger balances on a periodic basis to spot such errors. If there are no errors in posting journal entries to the general ledger, then the two balances will match; however, if there are differences, then there would be reconciling items, which need to be analyzed and corrected, if necessary. Two important accounts that should be reconciled on a monthly basis are accounts receivable and accounts payable.



Sometimes items (amounts) are included into a sub-ledger, but not in the ledger. Vice versa, items (amounts) may be posted to the ledger via a journal entry, but not recorded in the sub-ledger. Such items should be identified on the reconciliation separately to ensure they are given proper treatment.



Step 1: Compare G/L balance to the sub-ledger balance



You should start by analyzing the G/L and sub-ledger balances to identify any differences. While doing that, pay special attention to the transactions that are unusual in their nature. For instance, non-recurring transactions may have a higher risk of an error than transactions completed on recurring and regular basis. You should examine the sales journal (for receivables) and the purchases journal (for payables); have a look at posted entries, which were posted to the wrong account, transactions posted twice (duplication error), transposition errors, etc. Then you should look at the cash receipts and cash payments journals (for receivables and payables, respectively). Possibly, you will need to repeat with your examination of the invoice register for accounts receivable and the purchase order journal for accounts payable.



Step 2: Investigate reasons for the difference



After you have compared the G/L and sub-ledger and found differences, you should investigate reasons for them. Reasons for the difference can include the following:

Items posted to G/L, but not in sub-ledger

Items posted to sub-ledger, but not in G/L

Errors



Step 3: Adjust G/L and/or sub-ledger



The next step is to make necessary adjustments to the G/L or to sub-ledger(s) based on the reconciliation to correct any errors, omissions, etc. To identify what needs to be adjusted, you could use the template of the general ledger to sub-ledger reconciliation statement presented above.



Step 4: Compare adjusted balances



Finally, compare G/L balance to sub-ledger balance again, after all necessary adjustments were made. If reconciling items are resolved, the reconciliation process is completed. If there is a difference, continue to examine the sub-ledger and journals that are a part of the revenue and expenditure cycles to identify the problem and correct it.


Comments

Post a Comment

Popular posts from this blog

Intercompany Eliminations with Journal Entries

Intercompany Eliminations Explained intercompany eliminations happen for business combinations. The whole thing kind of confuses me. Can you explain the process and the journal entries to record the intercompany eliminations? Answer: Remember that in a business combination, we are trying to eliminate any transactions between the parent and the subsidiary so that we only have transactions with 3rd parties left after our consolidating entries. So, let’s assume Company A owns Company B and A sells $120,000 of inventory to B. Let’s also assume that Company A gets a 40% margin on all sales and Company B has 30% of the inventory remaining at the end of the year. With this set of facts, they could ask you a wide variety of questions on the CPA exam. One of the tricks to solving problems involving intercompany eliminations is to understand the entries that A and B would book in these cases. One of the other tricks is understanding the relationship between cost and margin percentage.
Post a Comment
Read more

Procure to Pay (P2P) Process Folow with Journal Entries

Procure to Pay process flow. 1. Requester: Request for goods & the same goes for an approval 2. PR is created & routed for approval 3. Once approved, PO is created. 4. Sourcing activities like, Choosing the right Vendor, Payment info happens meanwhile, 5. PO is routed for approval 6. PO is sent to the supplier.& Vendor signs the agreement (Payment terms) 7. Supplier will send the goods along with Invoice.(PO Number mentioned) 8. Good received & GRN entry is made. 9. Invoice is sent to the AP team 10. AP team process the Invoice (3 way match) - GL coding will be automatically pulled. 11. process for Payment Few Journal Entries examples are as followed. 1. Goods Received Ware House Dr        Inventory a/c             Cr                    GRNI a/c 2. Inv. Register in our system Dr        RI a/c Cr                    Trade a/c 3. Receipts Matched/Approved Dr        GRNI a/c Cr                    RI a/c 4. Inv. Pa
Post a Comment
Read more

End to End Journal Entries for Purchase Orders

  Creating end-to-end journal entries for purchase orders involves recording the financial transactions associated with the entire procurement process. Here's a step-by-step breakdown of journal entries related to the purchase order process: 1. Request for Purchase: When a department identifies the need for goods or services and generates a Request for Purchase (RFP) or Purchase Requisition, no financial transactions are recorded at this stage. 2. Vendor Selection and Quotation Comparison: No financial transactions are recorded during the vendor selection or quotation comparison stage. 3. Purchase Order Creation: Once the Purchase Order is created and approved internally, the following journal entry is made: Copy code Debit: Purchase Order Liability Credit: Accounts Payable This entry recognizes the commitment to pay the vendor for the goods or services ordered. 4. Sending the Purchase Order: When the approved Purchase Order is sent to the vendor, there is no financial transacti
Post a Comment
Read more