Account Reconciliation

[Jean]

Strange things happen when I reconcile the checking account.
My checks alway show up right, but my deposits are not always the deposits for the period. Example, the October 2001 rec., deposits from July 2000 and only those deposit appear for reconciliation, I know these deposits have already been cleared, and where are my deposits from October 2001? When I go into reports the deposits show up in the deposit report but are not available for clearing, I know at some point these deposits will show up to be reconciled but I never know when. I can't really rely on the account balance in this portion of peachtree 2002.
Any ideas?

[riscniaga]

check your deposit ticket id - there should not be duplicate id for different deposits.

in peachtree's bank recon, deposits are summed by the ticket id - no matter the date. so if you had a deposit ticket id of 123456 in july 2001, and another 123456 in october 2001. the deposit could appear in july 2001, october 2001, or in both months.

i would not know the logic for this abnormal behavior, but that is how it turns out for duplicate ticket ids.

[Jean]

Thank you!
I do believe this was the problem.

[bkpr913]

For future receipts, it's best to code each deposit ticket's ID with the date written as 012502 for January 25, 2002. Note the leading zero. That way the receipts will always show up in the correct order in the correct month. You can further distinguish checks and cash and credit card deposits by putting ck, csh, cc respectively at the end of each date id. This makes reconciling a breeze.

[riscniaga]

personally, when using dates i always recommend my clients to use 020126 for 26 jan 2002. this way you get the year, month and date correctly in that order. except when it was 1999 moving to 2000.

if you use 011225 for 25 dec 2001 and 020125 for 25 jan 2002, it will come out in your bank reconciliation correctly in ascending order. if you use the mm/dd/yy format - then it will not appear in the correct ascending order.