Page 1 of 1
Bank reconciliation problem
Posted: Sun Jan 13, 2008 9:56 pm
by BobD
check 4331 in the amount of $100 was written and cleared the bank. Reconciliation of bank statement showed that church records had everything but the amount. Check Register, Acct. Activity all showed the check number, date, and payee but no amount was shown, The journal showed all this info with zero amount, and no account distribution to any account. Accts. payable reports show the check posted properly with the proper amount. Vendor activity report shows the check with the amount.
Unless someone has better idea, my plans are to make journal entry cr. the bank with $100 and dr. proper acct . Thoughts?
Thanks
Bob D.
Posted: Mon Jan 14, 2008 3:40 pm
by emellesee
What I would do is look up the transaction in "Posted Transactions" in the Fund Accounting module. Then click on the button to reverse the transaction. Then go to "Unposted Transactions" and add new lines to enter the correct information and change the transaction description from XXXX-REVERSE to XXXX-REV&COR to show the transaction is both the reversal and correction. This will make the correction linked to the original posting and may possibly help you see what went wrong.
ML
Posted: Sat Jan 26, 2008 7:26 pm
by Matt
This is an interesting problem. I'm curious as to what the original debit and credit accounts were when the check was originally posted in Accounts Payable. To see this run the Selected Paid Items report in Accounts Payable for check #4331 and be sure to check the "include account distributions" checkbox.
Posted: Mon Jan 28, 2008 5:20 pm
by tborgal
Matt,
I can not get an accounts distribution in that report if I put the check number in as a field to select by. The only way I can get that information is to use the vendor code only. Am I doing something wrong when I use this report??
Posted: Mon Jan 28, 2008 8:31 pm
by Matt
I double checked and I was able to input just the check number as a selection critieria and the report ran for that check, showing the account distributions. So not sure why it isn't working for you.
Posted: Mon Jan 28, 2008 11:24 pm
by tborgal
I have tried every possible combination and can not display account distributions with just the check number. In fact if I use the vendor code and the check number I get notes but still no account distribution. The only way I get account distribution is with vendor code only and the reference fields empty.
Posted: Tue Jan 29, 2008 7:51 pm
by Matt
Which version of PC+ are you using? Also, have you downloaded and installed the latest maintenance release? I am using version 10.4 updated with the 12/18/07 maintenance release.
Posted: Wed Jan 30, 2008 9:07 am
by Zorak
In Accounts Payable, the account distributions are stored on invoices and manual checks only. If this is a computer generated check, you won't be able to select by check number and get account distributions.
Try using the vendor and date instead, or the reference of the invoice that was paid.
Posted: Wed Jan 30, 2008 10:51 am
by tborgal
OK that answers the question. I am using 10.4 with the latest maint. release, but with computer generated checks aka invoices. Learned something new, thanks.