How to run a report to see the transactions have been enterred in a specific date, or simply the last 50 data entires?

  • 1
  • Question
  • Updated 1 year ago
We have 3 bookkeepers and we need to check the work done by someone on 14 August 2018. We need to see the data entries entered by one employee who may made some mistakes. I can not do this by selecting the invoice date as some of the transactions are not this month. Is this possible in reckon hosted?
Photo of charlie xu

charlie xu

  • 70 Points

Posted 1 year ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 16,500 Points 10k badge 2x thumb
Review the Audit Trail report - this will show who entered/edited any transactions - you can choose the report to be for any date, but modified in the last month...  :)
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 54,302 Points 50k badge 2x thumb
Thats right Linda. Now if the username isnt unique it probably wont help. Also I would be very doubtful it would stand up in court

Hi Charlie

As Linda mentioned, the Audit Trail report is one option.  I find it easier to create, modify & memorise a summary version which includes the Date, Time & User for each entry:

  • Click on “Edit” (along top toolbar) > “Find ...”
  • On the Advanced tab, click on “Entered/Modified” from the Filters list & enter the date you want in both the “From” & “To” boxes
  • Scroll down the Filters list & click on “Detail Level” then select “Summary
  • Click on “Find” then “Report
  • Click on “Modify Report” & on the Display tab, select (tick) “Entered/Last Modified” & “Last Modified by” columns.  (You can also de-select any columns you don’t need or “close” them on the report itself)
  • In the “Sort by” field, select “Date” from the dropdown
  • Ensure your “Report Basis” is set to “Accrual” to capture all entries
  • On the Header/Footer tab, you can edit (choose your own) meaningful “Report Title
  • Click on “OK

This report can then be memorised for future use & can also be tweaked for any date range &/or any User.