22 Nov Adjustments Back to Client
Ask the Expert – Adjustments Back to the Client
Q – I support QuickBooks because my clients use it. I have tried the Accountant”s Review copy but the limitations in functionality as well as the version issues drive me crazy. I have decided to obtain a back up file from my client but need a more efficient way to provide them the information they need to update their books. Do you have any suggestions?
A – The only way to handle manually providing adjustments to the client when using a regular back up (as opposed to an Accountant”s Copy or Remote Access) is to track any name or account changes manually (plus any other changes such as preference or closing date) and create a custom report to send to the client. The audit trail (when turned on before you begin your work) provides the most detailed information regarding changes that have been made to existing transactions, as well as providing the new entries you have created. Filtering the report for the entered/modified date (from the date you received the file, through the current date) will provide a report for all the transactions you have “touched.” Making notes on that report so the client knows exactly what needs to be done is often helpful. This approach does require, however, that the changes be manually re-entered.
The Transaction and List copier Add-in is a tool that allows you to move transactions and lists from one QuickBooks file to another. Is uses QuickBooks’ exported lists and a QuickBooks report to create a single IIF file with the new list items and transactions you’ve entered in one file to be imported into another. More information is available from the developer, Big Red Consulting, including an Overview of the product and Q&A.