Financial Statement

I have another issue...

On my financial statement, the "Total Assets" and "Total Liabilities" do not match. What causes this and how do i figure out what's throwing it off on Sage 300? I checked and all accounts are on the FS. I'm hoping to get some help on how to find the problem. I'd appreciate any feedback.

Thank you in advance!

  • 0

    Normally when the assets don't equal the liabilities, it's a coding issue.  What are you off?  Can you find that amount on your GL? If you can, is that account coded appropriately? Perhaps there is a revenue or expense account that should have been coded as an asset or liabilty?

  • 0

    Hi Suzanne,

    Start with running the Year to Date Ledger (GL Reports > Year to date Ledger) for the same period as your financial statement to verify if you are truly out of balance or not.

    If the ledger is in balance, then it likely something with the financial statement design (i.e. Reverse sign incorrectly set, an account in the wrong line instruction, a line being added/subtracted incorrectly, etc), or something with the prefix group being selected (if using prefixes), or an account has an incorrect account type.

    If the ledger is out of balance, then that will take us down another path of troubleshooting.

  • 0

    Assets don't necessarily equal Liabilities and I would be surprised if they were equal.  It's Assets = Liabilities + Owner's Equity.  If you meant that these are not equal, I would first see if all entries have posted in general ledger. 

  • 0

    Hi Suzanne, Do you have a balance in your suspense account?  Usually when the balance sheet is off, it's because an item has posted to suspense, which doesn't flow thru to R.E.