ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> bal sheet reduced but entries not in Gl
http://www.istechforum.com/YaBB.pl?num=1263610941

Message started by Laura Oliver on 01/15/10 at 20:02:21

Title: bal sheet reduced but entries not in Gl
Post by Laura Oliver on 01/15/10 at 20:02:21

the checks we wrote on 5/14/09 ( about 10 checks totaling $5700.00) are nowhere to be found in detail trail balance or the journals.
but somehow the checking account balance is correct on the balance sheet. (So I assume the entries went thru the GL, how else would the balance sheet be correct?)

The entries would have to have been cleared out of GL-O or the checking account balance would not be correct on the balance sheet.

It is interesting to note that while the checking account balance is correct on the balance sheet., the ending balancing on the detail trial balance is off by the same $5700.00 (because the journals do not have the 5-14-2009 AP transactions)

So my end of the year accounts payable trade is short by the same $5700.00, but my balancee sheet is correct?"??

Ive been on DBA since 1997 and I have never had anything like this happen. I seem to remember years back where someone thought that maybe a power surge had confused the posting of GL-O.

I supposed there is someway to manually enter the transactions, so that they would show up in the detail trial and the journals, but that would also reduce my checking account balance on my balance sheet, and I dont need that .

I am soooo confused.

Title: Re: bal sheet reduced but entries not in Gl
Post by Lynn_Pantic on 01/16/10 at 09:08:54

UT-A, program EDITGL will allow you to enter the transactions without impacting anything else. Fill in the blank screen with the entries to Cash and Accounts Payable.

Title: Re: bal sheet reduced but entries not in Gl
Post by Laura Oliver on 01/16/10 at 12:44:12

Thanks Lynn, I will try that. I have also determined that this is tied to the YE entries. Because these transactions were not in BKGLTRAN-B. when I ran AM-B, these amounts were not zeroed out with a YE transaction

.....do you have any idea what boneheaded thing I could have done to cause this?

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Here are my notes for the archives....they might serve as key word for someone doing a search about this in the future.....like me.

I wrote checks on 5/19/2009 totalling $5761.45.
The checks were accurately recorded in AP-R. All were entered as vouchers thru AP-B. All vouchers are still found thru AP-B.
However I can not find these transactions in BKGLTRAN-B, but they are found in BLGLCHK-B. Because these transactions were not in BKGLTRAN-B. when I ran AM-B, these amounts were not zeroed out.

The problem is that since these are not in BKGLTRANS –B, That also means they are not in my General Journals or Detail trial balances. But they have reduced my checking account balance.

However while the transaction did not get transferred to the expense account it did make it to the income statement.
The Income statement does reflect these transactions as expenses.
Even though these expenses do no show up on the detail trial balance or journal they did correctly effect the balance sheet and the income statement.

The problem is that since these are not in BKGLTRANS –B, That also means they are not in my General Journals or Detail trial balances. But they have reduced my checking account balance.

The detail trial ending balance of my checking is 17,064.46
The balance sheet checking account is $12,479.89 off $4584.57

The detail trial ending balance of my VISA acct is 89,753.31
The balance sheet Visa account is $88,576.43 off 1176.88.

$4584.57 + 1176.88. = $5,761.45 the exact amount of the 5/14/2009 checks

I could recreate the transactions in BKGLTRAN-B., No Lynn just suggested UT-A, program EDITGL