Skip to content
Big Red Consulting
We specialize in Excel-based add-ins and other productivity tools, both ready-to-use & custom solutions.
Copy transactions from one QuickBooks company file to another. Transactions are pulled directly from QuickBooks and made ready to import into another company file. Filter your transactions based on date, account, and transaction type. Most transaction types are supported.
The Transaction copier pulls transactions from one company file and helps you import them into another company file. It works from within Excel and displays the transactions on an Excel worksheet for review. You can select transactions to copy by their date, transaction type, or by account.
For example, you may want to copy invoices entered in one company file to a different QuickBooks file at the home office. Or, an accountant may want to make modifications to a client’s file by adding journal entries or other transactions. Using this add in, these new transactions can be pulled from one company file and imported into another file.
The add in supports all transaction types that are supported by QuickBooks import. This includes types such as bills, checks, deposits, invoices, payments, journals, and most others.
For added flexibility, the source & destination company files can be on different QuickBooks versions and even on different machines.
Download this add in for a free trial, which allows you to try before you buy. You can use the trial to test the add in and create up to 100 individual transactions (e.g. 100 journal entries or 100 invoices, or a mix of transaction types.)
11.57: Resolve a messaging error regarding account types.
11.56: Improve QuickBooks version detection and connection from 32-bit and 64-bit Excel when connecting to both 32-bit and 64-bit QuickBooks versions.
11.55: Changes to avoid the error message “Unexpected error; quitting” from a QuickBooks 2022 component that’s only partially installed.
– Improvements to logic when auto-setting the transaction type when no type is specified or an invalid type is specified.
– Updated messaging when the QuickBooks version can’t be detected before integrating.
– Updated messaging when the connection to QuickBooks fails, offering new suggestions.
– Don’t use an account or a rate when creating or using Subtotal type items.
11.53: Improve code that detects the running version of QuickBooks before connecting to integrate lists.
11.52: Enhancements for QuickBooks 2022 support.
11.51: Add support for QuickBooks 2022 and Enterprise 22.0.
11.44: New feature to try to detect and repair a broken QuickBooks connection with no need to re-run the installer.
11.42: Fix an issue introduced in 11.41 that caused the New Transaction column to not be recognized.
11.41: Update text on the message that is shown when the worksheet doesn’t appear to be created by the Transaction Copier. Revise column labels in messaging to match recent changes to the workbook the Transaction Copier creates when you pull transactions from your source file. Better handling of items within group items when integrating in some cases. Better handling for product keys and annual keys in the About & Purchase dialog.
11.35: Make sure account numbers, which are not really numbers, are treated like text.
11.34: Big Update!
– Add option to retain integration temp files for support review.
– When an in-product link to our site can’t be opened for some reason, now display a message with the link that can be pasted directly into a browser.
– For new name records, now format address fields that contain double-quote characters so the double-quotes can be imported.
– Significant refresh for most dialog windows to aid in usability.
– New option, now the default, to use a more reliable method to process temporary files returned from QuickBooks when integrating lists. This helps handle unusual text characters in the files.
– Refresh help files with cleaner language, streamlined formatting, updated screenshots, and more thorough coverage of settings and preferences.
– Add option to skip hidden rows when exporting to IIF.
– Updated the support information written to IIF file.
– Fix issue where new names were counted multiple times when error checking the worksheet when the names list was very large.
11.27: Make sure older annual keys work properly with newer primary keys. Better alert messages when subscription is due or overdue. Add warning to delete key message to explain that it’s unusual to delete keys. Reorganize the IIF file export form for clarity.
11.26: Better handling for new names and the default customer name for sales when AP, AR, and the special sales tax accounts are used.
11.25: 1) Sales Tax related change: Now use the account from the sales tax item and then if not found use the special sales tax account QB creates, instead of the other way around. 2) Handle key entry case where the space between the first and last name is omitted.
11.14: Fix issue where addresses were not included in the exported IIF file for names and transactions.
11.11: Handle case where Excel worksheet is corrupted and Excel indicates there is only one row of used data. Handle case where account numbers (which are really text) change when stored as numbers during integration.
11.01: Fix several cases when handling sales tax vendors on sales transactions tax rows.
10.99: Ensure the Integration dialog appears before exporting to an IIF file. Changes to the About & Purchase dialog messaging.
10.93c: Reapply the digital signature to the installer.
10.93b: Changes to installer related to repairing the QuickBooks connection.
10.93: For better list matching, now retain double-quotes for text and list fields instead of replacing with two single quotes.
10.91: Resolve OLE error caused by attempting to open the documentation when it’s already open.
10.88: Improve handling of sales tax groups and subtotals when pulling only open portions of partially paid transactions.
10.87b: Update to installer to better detect QuickBooks installations.
10.87: Switch to using QuickBooks’ 5 line address blocks instead of parsed address fields when pulling transactions from QuickBooks for more accurate duplicate of the original address fields.
10.84: Fix handling for Inventory items on sales where the sale is voided. Improve performance when pulling large amounts of data. Working dialog now communicates more details when pulling data from QuickBooks.
10.81: Improve code that saves and gets the user-specified temp file location.
10.79: Add Paste button to key entry dialog for convenience. Rework messaging when keys are entered incorrectly or for the wrong product.
10.78: 1) Add option to set the temp folder used when pulling data from QuickBooks in order to handle the case where the user does not have rights to their own temp folder. 2) Add warning at startup if creating the custom Ribbon tab is not possible because user does not have rights to the customization file.
10.75: Changes to support info added to IIF files, to logic regarding when to auto-pop the integration dialog, and to capture the QB file information when pulling transactions and integrating lists.
10.68: Better handling for group totals: Now include the totals in the IIF file even when they have no memo.
10.62: Allow up to 20 digits for A/P transaction document number (11 for other types of transactions.)
10.61: Set and correctly display good through date in About dialog for certain upgrade paths.
10.55b: Installer update related to integration issues specific to 32-bit computers.
10.55: Change the way check worksheet results are copied. Better messaging when entering a key for the wrong product.
10.53c: Installer update related to integration issues.
10.53: Resolve QuickBooks integration issues with recent QB patch releases.
10.52: Detect recent QB releases while integrating to avoid QB crash.
10.47: Ensure Sales Orders are excluded from pulled transactions because they cannot be imported.
10.45: Update for setting reimbursable status on purchase transactions for QB 2019.
10.43: Update to integration error handling – pass back original error message & update suggested actions.
10.41: Notice when a conflicting duplicate account number is used on new accounts on transaction rows. (Detail rows were checked in prior releases.)
10.39: Handle subtotals within group items on sales transactions.
10.38: Better handling of transaction cleared status values as well as smarter default accounts for new inventory items.
10.37: Fixed issue where Annual product keys were sometimes not displayed.
10.36: Update date handling code to stop trying to fix possible errors from QB for international Excel versions, as seems to be worse then leaving the dates alone.
10.35: Fix the calculation of the open quantities and amounts for Purchase Orders, for the purpose of including only unbilled Purchase Orders in the transfer process. Previously if PO’s were over-billed they’d show up as unbilled.
10.34: Handle date-like values in various transaction data fields including item name, invoice number, class, description, and the three ‘other’ fields to prevent Excel from reformatting them as dates.
10.33: Dialog window changes to link customers to QB 2019 import recommendations. Tweaks to the file format.
10.31: Changes for QB 2019 (more!) including new help links.
10.28: Changes to purchase transaction handling so that item and non item rows will appear on the correct tabs in QuickBooks.
10.26: Changes to accommodate QuickBooks 2019 and Enterprise 19.0.
10.25: Minor change to the menu ribbon to avoid internal conflicts with other BRC apps.
10.22: Change the way “Other” fields are handled when they contain time values like 9:34 so they don’t get converted into decimals numbers during the conversion.
10.21: Changes to clarify the transfer process. Major re-write of the documentation.
10.19: Changes to About & Purchase dialog to handle more than one product key. Fix for Excel 2016 to resolve issue where app would not load properly.
10.14: Changes to the way integrated group items are stored in the list cache to handle larger groups.
10.12: Smarter handling for inventory item detail on sales forms when an income account is used as the COGS account.
10.11: New tips on the dialog used to pull data from QuickBooks and to integrate with your company file.
10.09: Added the Class filter.
10.08: Reworked the connection dialog to pull transactions from QuickBooks.
10.07: Set newer 64-bit connection method as the default method.
© 2022 Big Red Consulting
MS Excel is a registered trademark of Microsoft, Inc. QuickBooks and Quicken are registered trademarks of Intuit, Inc.