My Net Income (BSNI) at Balance Sheet Does Not Equal My Net Income on the P&L Statement

Q: My BSNI (Net Income) on the Balance Sheet does not equal my Net Income on the P&L Statement. How do I investigate? 

A: There are serval scenarios and different ways of handling this situation.

1.      If the BSNI amount does not match the P&L Net Income, and the Balance Sheet  is in balance:

        a.      I would put more trust in the BSNI. The Balance Sheet will be out of balance if the BSNI is wrong because the BSNI is a auto calculation from system that is based on the account type (P = Profit and Loss). It did not come from any P&L statement. P&L Net Income came from the Layout file; the user may forget to add new Expenses or Revenue accounts associated to the Layout file. It will cause the Net Income to be incorrect.

        b.      Example: P&L Net Income > BSNI --- In most situations, this is due to a new expense account that is missing on the P&L statement layout.

        c.      Investigation: You may run Trial Balance and compare with P&L statement. Hopefully, it's just one missing expense account when you check the variance.

 2.      If the BSNI amount matches the P&L Net Income but the Balance Sheet out of balance.

        a.      The majority of situations occur when the Balance Sheet is missing an account in the layout file or the wrong Sub-Total level is assigned on the layout file.

        b.      Investigation: You may run Trial Balance and compare with the Balance Sheet. Hopefully, it's just one account that's missing when you check the variance.

3.      If the BSNI amount does not match the P&L Net Income but Balance Sheet out of balance.

        a.      This would be a complicated situation. It might come as a result of multiple errors.

        b.      Suggestions:

                                      i.      Run Trial Balance with range of P&L accounts only to figure out correct Net Income.

                                      ii.      Check to see if the P&L Account flag is set to “P” instead of “B” on the GL Account file list.

                                      iii.      Check the layout file for missing accounts.

 

RSS

General Ledger

  1. GLMENU General Ledger Package Overview
  2. My General Ledger Interface with Other Package Is Out of Balance
  3. Can Journal Ledger Be Imported to General Ledger?
  4. Is There a Way to Pull All Manual GL Entries Out of Elliott?
  5. How to Print a Wider Financial Statement
  6. General Journal Transaction Out Of Balance After Interface with AR
  7. How to Archive GL Data Before Year-End Closing Procedure
  8. GL Year-End Closing Checklist
  9. Do I Need to Kick My Users Out When Interfacing with Other Packages in GL?
  10. General Journal Transaction In Balance But Not Able to Post
  11. Net Income from Profit & Loss Statement Does Not Match Balance Sheet
  12. Feature - G/L Interface from Other Package Customer/Vendor/Employee Number/Name Default
  13. Error During GL Interface from Other Package and Journal Transaction Is Lost
  14. COMPRESS General Ledger Processing Compress General Ledger TRX File
  15. GLBUDMNT General Ledger Budget File Maintenance
  16. GLCMPMNT General Ledger Comparative File Maintenance
  17. GLCONSOL General Ledger Company Consolidation
  18. GLCTLMNT General Ledger G/L Setup
  19. GLDSTMNT General Ledger Distribution Code File Maintenance
  20. GLENTMNT General Ledger Financial Entity File Maintenance
  21. GLJNLLST General Ledger Journal History Report
  22. GLPRDMNT General Ledger Accounting Period File Maintenance
  23. GLPRDSCN General Ledger Period Account Balance Report
  24. GLRATSCN General Ledger Financial Ratio Report
  25. GLRECALC General Ledger Recalculate Account Balances
  26. GLRECENT General Ledger Recurring Journal Trx Processing
  27. GLSRCMNT General Ledger Source File Maintenance
  28. GLTRIALB General Ledger Trial Balance Report
  29. GLWRKSHT General Ledger Print General Ledger Worksheet
  30. INTERFAC General Ledger Interface From Other Packages
  31. TEXTMNT General Ledger Statement Text File Maintenance
  32. SRCEXREF General Ledger Source Cross Reference Report
  33. YEAREND General Ledger Year-End Procedure
  34. GLACTMNU General Ledger G/L Account File
  35. GNJINLENT General Ledger General Journal Trx Processing
  36. My Net Income (BSNI) at Balance Sheet Does Not Equal My Net Income on the P&L Statement
  37. Budget File Maintenance Questions & Answers
  38. LAYMNU General Ledger Statement Layout File Maintenance 1
  39. LAYMNU General Ledger Statement Layout File Maintenance 2
  40. LAYMNU General Ledger Statement Layout File Maintenance 3
  41. LAYMNU General Ledger Statement Layout File Maintenance 4
  42. LAYMNU General Ledger Statement Layout File Maintenance 5
  43. LAYMNU General Ledger Statement Layout File Maintenance 6
  44. LAYMNU General Ledger Statement Layout File Maintenance 7
  45. LAYMNU General Ledger Statement Layout File Maintenance: Index
  46. STMNTMNU Select and Print Financial Statements 1
  47. STMNTMNU Select and Print Financial Statements 2
  48. STMNTMNU Select and Print Financial Statements 3
  49. STMNTMNU Select and Print Financial Statements 4
  50. STMNTMNU Select and Print Financial Statements: Index
  51. Job Code Adjustment through GL Journal Entries
  52. How to Distribute Sales to General Ledger by Warehouse Location

Feedback and Knowledge Base