On Mon, Feb 13, 2012 at 12:33 PM, Michael Richardson
<..hidden..> wrote:
>>>>> "Chris" == Chris Travers <
..hidden..> writes:
>> Further to my experiences: I report that most of my asset
>> accounts and liability accounts are inverted. Positive amounts
>> show under "DEBIT", etc. Ditto for Liabilities. I have a few
>> accounts that do not seem to be this way.
>>
>> Revenue and Expenses seem to be show in the right terms. I
>> looked and none of them have the "contra" bit set.
>>
>> Looking at the transactions themselves, they seem to be reversed,
>> for instance when I setup cash when I started in 2003, I show a
>> debit of 18K making my balance -18K, when it should be a +18K.
>> Ditto checks written are "CREDITS" rather than debits.
>>
>> Any advice? It's clearly systematic.
>>
Chris> Really? I have never seen this before. A couple questions:
Chris> 1) Are your books balanced in the trial balance?
I can take a look, I haven't looked since the upgrade.
What I see is that the result of transactions into my Asset and
Liabilities accounts are reversed.
Look at the beginning of time for my bank account:
http://www.sandelman.ca/tmp/mcrcadatabasepture/8506.2012-02-13/old1.png
http://www.sandelman.ca/tmp/mcrcapture/8506.2012-02-13/new1.png
I seem to recall that the credit/debit column was not always something
you could rely on in the ledger-smb days. Maybe that is the origin of
the problem.
The credit/debit columns are the same in both. The difference in the new one is that the running balance is flipping signs and showing negative for debit, positive for credit rather than the normative balance (for an asset account, positive for debit, negative for credit).
I seem to recall a fix for this at some point. I need to go check which version it's available on.
Chris> 2) Would
Chris> you like paid assistance in looking at the data?
Perhaps. I'd rather pay you to give me some additional tools to help me
than to fix one instance of data.
I can't provide tools without knowing what the problem is, but if it is a widespread one
However before we get to the point of doing paid support I want to check something.
What I think would be the best thing to do, is for me to throw away my
entries prior to 2009-12-31. I think I have too much "legacy" here.
I would create a new set of books, setup identical chart of accounts,
set up the initial values sanely based upon my 2009 tax return.
Unless we know what the problem is, all of that is premature.
Step one is identifying the problem. Then we figure out how to fix it. From your screenshots, I am not at all convinced that there is a difference in the data between 1.2 and 1.3. It looks like the running total has a flipped sign, and that seems to be the only difference in the screen shots.
What would make this problem much easier to bite off would be if I could
transfer the vendors, customers, and invoices/purchases for 2010. I
would be okay with loosing the payments/receipts, and having to
reconcile the 6 months of 2010 that I've already done.
On the other hand, this looks like a systematic thing in my data.
I will post more when I have an opportunity to look at the code changes.
Best Wishes,
Chris Travers