21 Nov Combining Data Files
Ask the Expert – Combining Data Files
Q – I have a doctor client who does not want the bookkeeper to see his salary or expenses. Currently it is entered into a QuickBooks file in my office while the bookkeeper enters everything else in his office. It is getting complicated. Do you have any suggestions?
A – This situation can be best handled by having the full QuickBooks file in your office, then importing the data the bookkeeper has entered into your file. There is an add-on from Big Red Consulting that is available for just that situation. The transaction copier is available from our online store for $79.
The way the add on works is that a journal report based on the appropriate date range is created in the bookkeeper”s file, and then click on the Excel button to transfer the report, use the tool to convert the file to an iif file that can then be imported into QuickBooks. The only two problems will be that the paycheck data will need to be re-entered to prepare the payroll returns, and any transactions will need to be linked. For example, the bill and bill payment will both be imported, but the link stating that the bill was paid by the bill payment will have been broken. What we have found is that it much more efficient to import the transactions (and less prone to data entry errors) by using the tool, even though there are those two issues to address.