Ok, I didn't notice because I assume it's an impossibility, but of course my accountant did.
 
Total Assets does not equal Total Liabilities plus Retained Earnings.
 
I have gone back and printed previous years Balance Sheets and they do not add up either!
 
However, Trial Balance is in balance, so it seems it's a problem with the report. We are on IS Tech update 7/5/10, "Build 02/22/10". I tried installing SP1 hoping that there would be a fix for it, but that was not successful (I have a thread about that in the Installation section).
 
There are three accounts that are not in balance - one asset (our checking account) and two liabilities (a Line of Credit and a holding account on a Credit Card used for purchases). All three are on the balance sheet but the totals do no agree with the Trial Balance.
 
Again, this is using the standard report in GL-F.

I have double checked the setup, and it is fine. I have been using DBA for over 10 years and never had this problem before. Now if I go back and re-print a balance sheet which was in balance before, it is not in balance now.
 
That fact plus this one makes it obvious to me that there is a problem with the report:
 
Quote:

 
i.e. my "Amex not billed" account shows 6,610.36 on the balance sheet, but 16,322.47 on the trial balance...
 
Lastly, the difference between the amounts on the Balance Sheet and Trial Balance on the three accounts I mentioned adds up to the difference between the Total Liabilities and Total Liab/Own Eq on the Balance sheet.

You mention trial balance, but I don't think trial balance is one of the standard financial statements. Therefore I'm assuming you set up the trial balance report in AM-F (Format Custom Financial Statements)?
 
If so, have you compared the GL account ranges for standard balance sheet report, the to GL account ranges for the custom Trial Balance report. When you compare the two, are the ranges similar, or is one range wider than another, perhaps causing the Trial Balance report to pick up extra accounts somewhere, which may or may not be used anymore.

Ok I see, so you are comparing GL-E detail trial balance to your balance sheet.
 
I checked a few of mine, they all balanced. It looks like there are different options for GL-E, such as posting date, entry date, etc. which may cause some differences. (I used the "post date" field, left "Entry date" blank) I also notice that you can run out a detail trial balance report as of a particular DAY, whereas balance sheet would only go to end of month/period. Obviously these two date ranges would need to match up if you expect them to balance.
 
Maybe you have a reason for sending your accountant your entire detailed trial balance for every account, but I'm wondering why you wouldn't just send your balance sheet and income statement, then supporting detail trial balance for ONLY the accounts where that detail is necessary. Might save you and your accountant a lot of work.
 
A few years ago, I was putting together a cash flow statement for the previous year for planning purposes. I remember having the same type of problem where a cash account detail trial balance was not agreeing with the balance sheet account for certain periods. Unfortunately I can't remember how I solved that problem, but will post here if I do. It sounds like your problem accounts are all cash related.
 
One more thing, that cash account 11100 with two listings doesn't sound right. I have changed account descriptions before, and never had two show up in the lookups. It sounds like maybe the two should be merged, or maybe one deleted, but I'm not sure about that. When we changed banks, DBA AD-B wouldn't let me delete the old bank account, but EVO would.

I reread some of your comments from the beginning and just want to add this....
 
Quote:

 
It's not necessarily suppose to, as Assets = Liabilities + Owner's Equity. Owner's Equity consists of Retained Earnings, Current Earnings (Income less expenses), and possibly other things like Dividends paid, common stock, etc., depending on how your chart of accounts is setup. Just want to make sure you aren't comparing to the Retained Earnings account only.
 
Quote:

 
This also makes me think another owner's equity account may be left out of your calcuation.

If the trial balance is in balance and some accounts on the Balance Sheet have different balances than shown in GL-E, then use UT-K-D and run it for all accounts to correct it.  It will recalculate the Chart of Accounts file based on the transaction file.
 
If you have a duplicate entry for one account, you may have to use Maintain Database on BKGLCOA and ISGLCOA to delete it before you run UT-K-D.

This has to be related.
 
The Trial Balance and Balance Sheet now agree, but it seems they are both wrong on our Line of Credit (LoC) account.
 
Of course I am always checking that the bank's version of what we owe agrees with mine on a frequent basis using their online banking. However, when I went to make a cash advance today I noticed that the amount they say we owe and what DBA say is off by $15,000. My first thought is that I missed an entry somewhere, but all advances and payments check out back to July of last year. Further, I do a formal reconciliation at the end of the year to accrue interest payable and adjust principle balances on term loans, and the amount I recorded for the LoC says it was in agreement with the bank, HOWEVER IT IS NOW $15,000 OFF FROM THE BALANCE SHEET AS OF 12/31/10!!! Ditto if I go back to 2009.
 
By searching my BKGLTRANS and BKGLCHK files I think I may have found the root of the problem, but am not sure:

• How it could have happened in the first place,
  
• Why it has not showed up until now, and certainly not
  
• What to do about it...

On 1/18/07 there is both a debit and credit in the BKGLTRAN for the LoC for $15,000, type GJ.
However, in the BKGLCHK there is only only a debit.
 
Any ideas?