Find transaction that has been accidently altered

  • 1
  • Question
  • Updated 3 years ago
  • Answered
In Reckon Personnel Plus 2017 is there any way to find/locate a transaction that has been accidentally altered.I was doing some tidying up and obviously altered an amount of a transaction and now one account is out by $1250 . Easy way is to do a contra entry but this will not fix the altered transaction
Photo of Terry Stewart

Terry Stewart

  • 90 Points 75 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Diver Dave

Diver Dave

  • 6,060 Points 5k badge 2x thumb
Terry, I are you referring to the balance of a Banking account being out?  Assuming so, easiest way to locate the incorrect entry is to work back, month end by month end, comparing the Reckon balance to you bank statement.  That way you can locate the month in which the error occured and then work through entry by entry comparing to your statement, until you find the one which doesn't agree.

If the issue is something else, could you be more specific in describing the problem?
Photo of John Campbell

John Campbell

  • 4,062 Points 4k badge 2x thumb

Assuming this is a transaction account, I would approach this problem by exporting all transactions for this account to a .csv or .prn file, by creating a report of all transactions in the account and then "print" to file as .csv, .prn or excel format.

This can be imported into excel and then you can create a balance calculation to compare to the account records you have or use a variety of sorts or pivot tables to find where the $1250 may be in error.

I actually export on an irregular interval, so I could compare to past reports.

Alternatively, you could do a report from a backup, prior to your cleanup, and then look for differences in the .prn files. This would work for most types of accounts.

Photo of Terry Stewart

Terry Stewart

  • 90 Points 75 badge 2x thumb
Thank Diver Dave and John for your input. I used bits out of the two replies. Exported the transaction report and used Bank statements to cross check the balances. After a few hours work eventually located the problem transaction and all is back to normal. Thanks again  Cheers Terry