Net Income from Profit & Loss Statement Does Not Match Balance Sheet

Net Income from Profit & Loss Statement Does Not Match Balance Sheet

Q. Normally the Net Income amount on my Profit & Loss Statement always matches the Balance Sheet of my monthly financial statement. Unfortunately, they don't match this month. How can I find out why this happened and resolve the problem?

A. There are several issues can be causing the mismatch. I suggest you try the following steps to fix the problem:

1.  Verify that the Trial Balance (Summary) is in Balance -- Print the Summary Trial Balance to make sure it is in balance. You may run "Recalculate Account Balances" to refresh the GL Period Account Balance file if it is out of balance.

2.  Verify that the Balance Sheet Statement is in Balance -- Compare Total Assets with Total Liabilities and Equity to make sure it is in balance. If the answer is yes, then we can trust the Net Income amount on the Balance Sheet.

3.  Carefully Review the Profit & Loss Statement:

  • New Expenses or Revenue Account were not incorporated into the Statement Layout File -- This is the most likely cause for a mismatched balance. You should compare the P&L and Trial Balance amounts account by account to find out if any are missing.
  • If P&L Net Income is Greater than Balance Sheet -- Chances are that an Expense account is missing from the P&L Layout file.
  • If P&L Net Income is Less than Balance Sheet -- Chances are that a Revenue account is missing from the P&L, or that an Expense account is duplicated in the P&L Layout file. 
  • Modify Statement Layout File -- Add any new missing account information to the P&L Statement Layout file, then rerun the Financial Statement.





    • Related Articles

    • 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 ...

    • Feature - Last Year Net Income Layout Support

      Release Date - 3/29/19 Version - 8.5 and up For users who perform a temporary year-end close, from the time of the temporary year-end close to the final year-end close, the General Ledger Balance Sheet will be out of balance. This is because the ...

    • LAYMNU General Ledger Statement Layout File Maintenance 5

      Run Instructions Select Statement Layout File from the pull down G/L Maintenance window. The following screen will then be displayed: Statement Layout File Entry Screen The following options are available: * Select the desired mode from the Statement ...

    • LAYMNU General Ledger Statement Layout File Maintenance 3

      Ratios Ratios can only be printed on the Profit and Loss Statement and the Profit and Loss Format Supporting Schedule. In order to be able to select ratios to print on a statement, you must define the basis upon which the ratios will be calculated ...

    • LAYMNU General Ledger Statement Layout File Maintenance 1

      Statement Layout File Maintenance Application Overview The Statement Layout File application enables you to create and modify Financial Statement Layouts. The features include: Add provides for the entry of financial statement layouts. Change ...