I started working for a new client recently and the prior support person was not attentive to details and there are multiple transactions (six months worth) that have been miscoded. I know that I can go in and change them one at a time but that would take me forever. Is there a way that I can do this quicker?
Yes, there is a quicker way to do this. You can do the following
- Reports menu
- Custom reports
- Transaction Detail
- Customize the report using this fiscal year for the date range and sort using name
Now you will be able to determine the vendor/name and the expense used which will give you the idea of what is incorrect by vendor and the specific incorrect account.
Export this report to excel for easy review/analysis.
Sort the data in excel to figure out how much of each account needs to be corrected and adjust accordingly.