PDA

View Full Version : Account Reconciliation problems


PatB
08-07-2004, 07:37 AM
I’m a new user of Peachtree Complete Accounting 2005 multiuser.

PROBLEM: In account reconciliation window, some deposit amounts are accumulated inaccurately. The unaccumulated are listed as separate items. Thus, reconciliation is cumbersome to say the least. Why would this be happening? Is there a way to cause our deposit entries to reflect the actual amount of the deposit? (During this time we began using receipts rather than invoice forms for most of our cash transactions. Could that have an affect on the situation?)

Dep # Amt listed Actual Amount Description
on Acct Recon
226 781.44 781.44 Payment on Invoice
227 17.28 540.17 Payment on Invoice
(2 of 18 items)
228 75.00 477.58 Payment on Invoice
(2 of 13 items)
229 206.88 365.77 Deposit Ticket
(12 of 17 items)
230 769.50 1097.50 Deposit Ticket

TheWolf
08-07-2004, 09:06 AM
Go to Maintain, Default Information, Customers, Pay Methods Tab, and under deposit ticket id's you want to select in select for deposits. Now when you enter receipts, do not assign a deposit ticket id number, just leave it blank. When you make your depsoit, go to Task, Select for deposit and all your receipts will be listed here. Select the ones that are in the actual bank deposit, assign the deposit ticket id and you can even print the deposit ticket from this screen if you wish or just save it. Now that deposit should show as a lump sum in the Account Rec window.

PatB
08-11-2004, 01:34 PM
Thanks Tom, but the problem persists.

I followed your instructions and confirmed that my default information was set up as you outlined and the method I used to Select for Deposit matched your instructions. Still I have the problem. I went thru each deposit as it displays in Select for Deposit and wrote down every receipt that failed to appear in the accumulated related deposit total.

On the reconciliation page:
Dep #226 . . lists 11 items instead of 19 selected for deposit . . $543.34 total instead of $781.44
Dep #227 . . lists 2 items instead of 18 selected for deposit . . . $17.28 total instead of $540.17
Dep #228 . . lists 2 items instead of 13 selected for deposit . . . $75.00 total instead of $477.58
Dep #229 . . lists 15 items instead of 19 selected for deposit . . $245.37 total instead of $365.77

Bank Deposit Report shows the same low totals and incomplete listing of items deposited.

However, the cash account register lists all items.

Any suggestions?

Arrrrrrgh!

Persistent Pat