Discussion:QB Audit Trail Question
From TaxAlmanac
←Older revision | Newer revision→
Discussion Forum Index --> Accounting Questions --> QB Audit Trail Question
| 11 June 2009 | |
| Having to review books for local co. as the result of emblezzment. I have a Audit Trail report that is really damaging. Sheriff Dept. wants an exact figure of what has been stolen. I have a working copy of company file to make changes.
Now, question. Should'nt I create another user as "Admin" shows up on Audit Trail report continuously & I want to show who is making changes now. There has been a lot of deleted checks after printing that has to be re-entered into QB. Missing checks reports shows a lot missing. Any advice would be greatly appreciated. Dar | |
| June 11, 2009 | |
| First, I would recommend you save the original file as is -- it shouldn't even be opened if possible. Second, are you going to make changes? What is your plan to figure out how much has been stolen? | |
| 15 June 2009 | |
| Thanks for your reply. We did saved the company file twice, Reg. name for one acct. and corrected XXXXXX for changes. The forged checks were obvious. Any changes will be made to the "corrected" company file. Did a spreadsheet for the 12 mth period that the embezzlement happened. Employee had no check signing authority and the different in signatures were very obvious. We have proven $50,443.75 to the Sheriff Dept. The employee had reconcile thru QB so I am trying to locate the adjusting entries today and we are trying to provide a Audit Trail Report that will show changed entries, haven't figure that out yet. Stress level was very high last Thurs. & Friday.
Dar | |
| 15 June 2009 | |
| Natalie, Will do a voided/deleted transaction report. That will show the difference between bank statements & QB co. file. None of the ck # on the statement matches QB info., so all info for 1 yr. will have to be verified.
Dar | |
| June 15, 2009 | |
| There may be a different approach you can take on this. What type of entity is it? Sometimes it's possible to pick one or two months to get an idea of how the fraudster worked. That makes it possible to narrow done the work. | |
| 16 June 2009 | |
| Natalie,
Started a "corrected" co. file. Reconciling is all screwed up. Approx. 12 mths done at one time. Printed out rec reports before undoing rec but beg. bal. is still wrong. Someone really screw this acct. up. Business is a S-Corp. Having 5 2007 checks never "Cleared" but if cleared now will come close to balancing but I don't work that way. Have to verify they cleared. I don't believe in plugging ending balance until last resort and never had to use last resort so far in my accounting. I don't know what exactly to do but take tiny steps. Checking out the audit trail for the 2007 chks to see if that was part of the embezzlement. I like challenges but boy did jump into a big one. Dar | |
| June 16, 2009 | |
| Dar, given that this involves legal issues, I would recommend you do not post additional details on this forum. Check your email. | |
