Troubleshooting
      Back to home
      1. Texada Knowledge Base
      2. Rental: SRM
      3. Troubleshooting

      Troubleshooting Balance Sheet Discrepancies

      How to troubleshoot balance sheet discrepancies in Texada SRM.

      Quick Reference

      • If you have encountered discrepancies when running balance sheets in Texada SRM, there are a number of techniques you can employ to troubleshoot and resolve them. These are rebuilding your statement layouts and resummarizing the General Ledger; checking your most recent year-end posting against your latest income statement; and checking for and removing back-dated entries.
      • To Rebuild and Resummarize:
        • Open Texada SRM and navigate to System Maintenance → Configure System Settings → Accounting → Statement Layouts.
        • Click “Build”, then select “Generate Statement Layouts” and click “Accept”.
        • Click “Accept” again, then “Yes”.
        • Exit the Statement Layouts utility and navigate to General Ledger → Financial Statements → Summarize for Financial Statements.
        • Enter the period for which you are troubleshooting into the “Period Start Date” and “Period End Date” fields, then click “Accept”.
        • Rerun the balance sheet and see if the discrepancies are resolved.
      • To Check the Most Recent Year-End Posting:
        • Open Texada SRM and navigate to General Ledger → Financial Statements → Income Statement. 
        • Select your preferred reporting type and click “Accept”.
        • Open the report and note the “Net Profit (Loss)” amount for the current period.
        • Exit the Income Statement utility and navigate to General Ledger → Account Inquiry.
        • Run the Account Inquiry utility on the PLRE account, with a Year / Period Start Date of 01/01/1901 and a Period End Date of 12/31/2999.
        • Open the report and verify that the most recent Year End Close debit amount matches the Net Profit (Loss) amount from your income statement. If not, you will need to correct this entry to make these values match.
      • To Check for Back-Dated Entries:
        • Open Texada SRM and navigate to General Ledger → Account Inquiry.
        • Run the Account Inquiry utility on the PLRE account, with a Year / Period Start Date of 01/01/1901 and a Period End Date of 12/31/2999. Open the report and note the Transaction # and Date of the most recent transaction.
        • Exit the G/L Account Inquiry utility and navigate to General Ledger → Account Inquiry By Transaction #.
        • Run the Account Inquiry By Transaction # utility using the Transaction # and To Posting Date from your most recent PLRE transaction.
        • Open the report and look for any transactions posted after the most recent PLRE transaction. Any such transaction will need to be reversed.

      Introduction

      When running the Balance Sheet utility in Texada SRM, you may discover that there are discrepancies in your financial records - meaning, your total assets do not match your total liabilities. These discrepancies can be caused by a number of factors, many of which can be resolved with some simple troubleshooting within SRM.

      This article will explore the following techniques for resolving balance sheet discrepancies:

      See the sections below for detailed instructions on each of these techniques. If you are still unable to resolve the discrepancies after trying these techniques, contact Texada support for assistance.

      Rebuild and Resummarize

      1. Open Texada SRM and navigate to System Maintenance → Configure System Settings → Accounting → Statement Layouts.
      2. Click “Build”, then select “Generate Statement Layouts” and click “Accept”.
        Statement Layouts - Build Statement Layouts-1
      3. Click “Accept” on the Generate Statement Layouts window. A message will appear that reads “The layouts which you have specified for the Balance Sheet and the Income Statement are currently in use. Do you wish to continue and over-write them?” Select “Yes” to rebuild the balance sheet.
        Statement Layouts - Generate Statement Layouts + Confirmation-1
      4. Now that you have rebuilt the balance sheet, the next step is to resummarize the General Ledger. Exit the Statement Layouts utility and navigate to General Ledger → Financial Statements → Summarize for Financial Statements.
      5. Enter the period for which you are troubleshooting into the “Period Start Date” and “Period End Date” fields, then click “Accept”. Once the General Ledger has been summarized, you will automatically return to the main menu.
        Summarize GL for Financials-1
      6. Rerun the Balance Sheet utility and check if the discrepancy is resolved.

      Check the Most Recent Year-End Posting

      1. Open Texada SRM and navigate to General Ledger → Financial Statements → Income Statement. 
      2. Select your preferred output format (Print or Excel), then click “Accept”. This will generate and download an income statement for the current period, either as a .pdf file (if “Print” was selected) or an .xls file (if “Excel” was selected).
        Income Statement-1
      3. Open the downloaded income statement file and note the “Net Profit (Loss)” amount for the current period.
        Income Statement xls
      4. In SRM, exit the Income Statement utility and navigate to General Ledger → Account Inquiry.
      5. In the G/L Account Inquiry utility, enter the following information:
        1. Account Number: PLRE
        2. Division: ALL
        3. Year Start Date: 01/01/1901
        4. Period Start Date: 01/01/1901
        5. Period End Date: 12/31/2999
        6. Product: [Leave blank]
        7. Accumulate Prior Balance: [Unchecked]
        8. Report Options: [As desired]
        9. Report Type: Detail
          GL Account Inquiry-1
      6. Click “Accept”. This will generate and download a G/L account inquiry report, either in SRM (if “Paging” was selected), as a .pdf file (if “Print” was selected) or an .xls file (if “Excel” was selected). Open the report and verify that the most recent Year End Close debit amount matches the Net Profit (Loss) amount from step 2 above. If not, you will need to correct this entry to make these values match. When correcting entries, remember that profits are debits to the PLRE account and credits to Retained Earnings, while losses are credits to the PLRE account and debits to Retained Earnings.
        GL Account Inquiry xls-1

      Check for Back-Dated Entries

      1. Open Texada SRM and navigate to General Ledger → Account Inquiry.
      2. In the G/L Account Inquiry utility, enter the following information:
        1. Account Number: PLRE
        2. Division: ALL
        3. Year Start Date: 01/01/1901
        4. Period Start Date: 01/01/1901
        5. Period End Date: 12/31/2999
        6. Product: [Leave blank]
        7. Accumulate Prior Balance: [Unchecked]
        8. Report Options: [As desired]
        9. Report Type: Detail
          GL Account Inquiry-1
      3. Click “Accept”. This will generate and download a G/L account inquiry report, either in SRM (if “Paging” was selected), as a .pdf file (if “Print” was selected) or an .xls file (if “Excel” was selected). Open the report and note the Transaction # and Date of the most recent transaction.
        GL Account Inquiry xls HIGHLIGHT
      4. Exit the G/L Account Inquiry utility and navigate to General Ledger → Account Inquiry By Transaction #.
      5. In the Account Inquiry By Transaction # utility, enter the following information:
        1. From Transaction #: The Transaction # you noted in step 3 above.
        2. To Posting Date: The Date you noted in step 3 above.
        3. Report Options: Excel
          Account Inquiry by Transaction #-1
      6. Click “Accept”. This will generate and download a G/L transaction report as an .xls file. Open the report once it is finished downloading. The first transaction in the report, appearing in row 5, should be the year end PLRE transaction from step 3 above. Any transactions posted after this entry will need to be reversed.
        Account Inquiry by Transaction # xls HIGHLIGHT