Home Overview  Screenshots Help  How to Buy Testimonials Videos

Beginning Balance Transfer Utility

How To Buy

Free Demo: You can download the Beginning Balance Transfer Utility programs, at no cost, by clicking on the link listed below. The demo programs are fully functional except that you are limited to entering a transfer date of 12/13/07 or 12/13/11. If you don't have Microsoft Access 2000 to 2013, you will need the free Microsoft Access Runtime engine which is available further down this page.

IMPORTANT NOTE (1): This program is designed only for businesses using the accrual basis of accounting. QuickBooks reports run on the cash basis that include any receipts or payments affecting beginning balances created by this program will be incorrect. 

IMPORTANT NOTE (2): To use this program you must temporarily (a) Uncheck the "Use account numbers" box at Edit>Preferences, Accounting Preferences and (b) Edit the general ledger accounts for all Accounts Receivable and Accounts Payable accounts and remove any "Description" that may be entered for these accounts and (c) make any Accounts Receivable and Accounts Payable sub accounts into accounts.

Vista Users: You must have User Account Control (UAC) set to On in Vista or you will get a "Could not start QuickBooks" error message. 

Canadian and UK users: If you receive the following error message, "Class does not support Automation. ...", you need to update the QBXMLRP2.dll file installed by QuickBooks. Click at right to download and install this file.  QBXMLRP2Installer.exe

Canadian Users: Versions 4 to 6 listed above must be run on a computer that only has the multicurrency capable version of QuickBooks on it. Version 8 must be run on a computer that only has the non-multicurrency capable version of QuickBooks on it. The programs won't work if you try to run them on a computer that has both the multicurrency capable and the non-multicurrency capable versions of QuickBooks on it.

How to Purchase:

You must download the program  above, this section only processes your payment. 

As soon as we receive notice of your payment, we will send your registration information to you by email. When you enter this registration information into the program downloaded in step 1, the trial limitations are removed giving you full use of the program. This registration email is in addition to the shopping cart/credit company emails that you will receive. This email will be sent from support@q2q.us to the email address used on the order or the PayPal account.  

B. (Exceptions to A above). If you purchase your order at night or over the weekend, your registration information may not be sent until the morning of the next business day.

Payments are processed by PayPal. With PayPal your payment can be charged to your PayPal account or to your Credit Card.  Also there is an Order Form in the program under the Help menu.

1. Pay using PayPal (click the "Add to Cart" button below).

Microsoft Access Runtime Engine:

If you don't have Microsoft Access 2000 to 2013 you can use the Microsoft Access Runtime engine instead of the full version of Access. To do this, 

1. Click at right to download the Access 2000 Runtime Engine:ARTinstall.exe or click below to download the Microsoft Access 2007 Runtime engine

http://www.microsoft.com/en-us/download/details.aspx?id=4438

2. Install the Runtime Engine by double clicking the downloaded file.

3. Download the Data Transfer Utility (from the download links at the top of this page) and install it.

If you have any problems, email us at support@q2q.us

Version History:

16.02 (07/21/18) Works with  Excel 2016.

16.01 (09/21/17) Works with US and CA QuickBooks 2018.

15.05 (07/21/18) Works with Excel 2016.

15.04 (09/27/16) Works with US and CA QuickBooks 2017.

15.03 (06/07/16) Fixed for CA QB 2016.

15.02 (03/02/15) replaced missing menus items from ADD INS in previous versions

15.01 (09/01/15) Now works with US/CA QB 2016

14.03 (02/23/15) Now works with UK QuickBooks 2015.

14.02 (11/06/14) Now works with Canadian QuickBooks 2015.

14.01 (09/13/14) First release.

13.18 (09/05/14) Now dates inventory valuation adjustments correctly if default date in QuickBooks is set to current date.

13.17 (07/31/14) Average cost adjustments now correctly post with the beginning balance date instead of defaulting to the current date. Added ISO-8859-1 encoding to handle accented characters.

13.16 (07/29/14) Private release.

12.08 (06/26/14) Now works with Reckon Accounts 2014.

13.15 (03/26/14) Added Preference that allows the export of accounts receivable in chunks. 

13.14 (02/07/14) Fixed problem with bank reconciliation transfer. Now transfers just un-cleared transactions. Transfers inventory in chunks on large files. 

12.07 (01/07/14) Now works with Reckon Accounts 2013. More accurately zeroes subtotals in the inventory valuation summary by site Excel report.

12.06 (12/30/13) Private release.

12.05 (12/24/13) Can now work with and Excel file containing an inventory valuation summary by site report filtered for one or more sites.

13.13 (11/19/13) Now works with CA QuickBooks 2014.

13.12 (11/14/13) Now works with UK QuickBooks 2014.

13.11 (10/17/13) Now correctly handles any cleared transactions that may be in the  bank reconciliation file.

13.10 (10/15/13) Now works with US QuickBooks 2014.

13.09 (09/06/13) Just cosmetic changes. Changed dividing lines to blue. No longer include extra spaces in decoded &'s.

13.08 (07/16/13) Simplified the process of transferring un-cleared bank transactions.

13.07 (06/28/13) If sites are used, inventory inventory quantity and value are added separately. Now XML encodes site names. 

13.06 (06/28/13) Same as 12.04 below. Also minor change in format of the main screen.

12.04 (06/28/13) Foreign bank accounts whose name includes an apostrophe are now included on the foreign accounts screen. Now rounds exchange rate to 6 digits if positive or negative. Sets exchange rate for foreign accounts with home currency balance but no foreign balance to a rate that will calculate the foreign balance as zero (or near zero) when imported. Added note on the foreign accounts screen re sign on foreign credit card accounts foreign balance. Fixed invalid use of null error message when there are no sales tax records.

12.03 (06/03/13) If sites are used inventory inventory quantity and value are added separately. Now XML encodes site names. 

13.05 (12/28/12) Can now transfer serial numbers if source QuickBooks file doesn't have any transactions after the Beginning Balance Date and inventory by site is turned on. Revised file restore process and made cosmetic changes to main screen.

13.04 (12/24/12) Inventory by site now works correctly with the revised report from QuickBooks. Correctly adds average cost adjustments when using inventory by site. Revised format of main screen.,

11.10 (12/22/12) Fixed divide by zero problem on exchange rate application. Correctly adds average cost adjustments when using inventory by site. 

12.02 (12/22/12)  Now applies exchange rate to unapplied foreign currency payments in accounts receivable. Correctly formats large unapplied vendor credits in accounts payable. No longer stops trial balance import if foreign currency bank balances are zero. Fixed divide by zero problem on exchange rate application. No longer pops up write to XML screen. Correctly adds average cost adjustments when using inventory by site.

11.09 (12/05/12) Now applies exchange rate to unapplied foreign currency payments in accounts receivable. Correctly formats large unapplied vendor credits in accounts payable. No longer stops trial balance import if foreign currency bank balances are zero.

13.03 (11/12/12) Now works with Canadian QuickBooks 2013.

13.02 (10/25/12) Now works with UK QuickBooks 2013.

11.08 (10/11/12) Now works with Australian QuickBooks 2012-13.

13.01 (09/26/12) New version for US QuickBooks 2013 to work with the revised Inventory Valuation Summary report.

12.01 (02/24/12) New version for US QuickBooks 2012. Now transfers detail of sales tax payable and marks finance charge invoices if ref numbers begin with FC. Also compares preferences for closing date, price levels, sales tax and multicurrency before importing any data. In addition, compares trial balance inventory amounts to the total on the Inventory Valuation Summary report on export and provides a way to activate inactive inventory items which can cause a difference in this comparison because the report incorrectly excludes inactive items even if they have a quantity and amount.

11.07 (11/21/11). Now works with UK QuickBooks 2012.

11.06 (11/16/11) Now works with Canadian QuickBooks 2012. Added note to use xls instead of xlsx when saving the inventory by site report from QuickBooks.

11.05 (11/04/11) Added the ability  to transfer inventory by site when using Enterprise and advanced inventory.

9.17 (10/31/11) Now works with Australian QuicBooks 2011-12.

11.04 (09/09/11 Updated to note that it works with US QuickBooks 2012.

11.04 (08/12/11) French accented characters no longer cause a parsing error when importing un-cleared bank transactions.

11.03 (06/27/11) Increased field size for item descriptions.

11.02 (04/25/11) Re-issued 11.02 to correct version number that appears at the top of the main screen.

9.02C (01/19/11)  Cash version now works with QuickBooks 2008.

11.01C (01/18/11) Released cash version for US QuickBooks 2011.

11.02 (12/31/10) Now works with Canadian QuickBooks 2011 and Enterprise 10.

11.01 (09/23/10) New version to work with QuickBooks 2011.

9.16 (08/30/10) Now handles transfer of negative undeposited funds amounts.

9.15 (08/20/10) Now includes name on uncleared bank transactions transfer. Optional restore screen works correctly when opened immediately after a change in the destination company.

9.14. (08/13/10) Warning screen for duplicate reference numbers on Bills now says Bills and Item Receipts instead of just Bills.

9.13 (08/12/10) Added UK multicurrency capability. Added home currency amount to the foreign currency screen and this screen no longer pops up if the home currency amount is zero. Fixed problem with foreign invoices which have been partially paid. The Canadian QuickBooks Software Development Kit (SDK) no longer incorrectly includes payments after the report date in the Open Invoices report and the warning for this was removed. 

9.12 (07/26/10) Added UK 2010 capability for non-multicurrency files.

9.11 (06/08/10) Accounts receivable transfer now includes any open credit card refund transactions.

9.10 (06/07/10) No longer shows invalid use of null when undeposited funds detail contains deposits with blank rows.

8.13 (05/20/10) Now works with Australian QuickBooks 2010-11.

9.09 (05/04/10) No longer displays an item not found in this collection error message when transferring undeposited funds detail that includes negative amounts.

9.08 (02/26/10) Minor changes to copyright notices.

9.07 (12/03/09) Now transfers average cost adjustments in chunks. Now includes the reference number for journal entries in accounts receivable. Forms showing transactions needing reference numbers can now be viewed form the Edit menu.

9.06 (11/25/09) Now checks for duplicate reference numbers, handles descriptions and subaccounts and includes credit card charges and credits in accounts receivable and accounts payable transfers.

9.05 (11/17/09) Now works with Canadian QuickBooks 2010.

9.04 (10/02/09) Now works with US QuickBooks 2010.

9.03 (09/02/09) Fixed invalid use of null message when there is no UDF balance at the beginning balance date.

9.02 (07/14/09) Credit memo imports are no longer rejected with a message that the amount must be positive.

8.12 (07/10/09) Added ability to work with Australian QuickBooks 2009-10 files not using multicurrency.

9.01 (07/02/09) Can now transfer multicurrency beginning balances.

8.11 (06/11/09) Now resets average cost on inventory items which have a negative or zero value. Also all other current asset accounts that include the word inventory are include in the beginning balance equity account when transferring the trial balance. 

8.10 (05/07/09) For certain transaction types, Accounts Receivable and Accounts Payable open balances are transferred by Journal Entry. These journal entries now always list the Accounts Receivable and Accounts Payable accounts as the first row on the journal entries so that the journal entries will show on the Customer Center. Also, inventory quantities are now transferred even if the inventory value is zero.

8.09 (01/30/09) Corrected a problem introduced by 8.08 which prevented open statement charges transferred by this program from being paid by payments transferred by the Data Transfer Utility program.

4.12 (01/19/09) Added Menus button.

6.12 (01/03/09) Now deletes the erroneous amounts created by Intuits Software Development Kit which incorrectly labels some subtotal rows as data rows in the Accounts Receivable report. Now handles credit card charges in accounts receivable.

8.08 (12/31/08) Now correctly handles unit if measure in inventory and increased speed of accounts receivable and accounts payable export.

8.07 (08/01/08) Now works when Enterprise incorrectly identifies itself as Simple Start.

8.06 (06/25/08) Now deletes the erroneous amounts created by Intuits Software Development Kit which incorrectly labels some subtotal rows as data rows in the Accounts Receivable report.

8.05 (06/17/08) Now works with Canadian QuickBooks 2008. Reduced time needed to read the import request files. Due to bugs in Intuits Software Development Kit, Canadian users have to manually add the Beginning Balance account and item that are automatically added when using the U.S. version.

8.04 (06/11/08) Added a work around for the QuickBooks Inventory Valuation Summary Report which has a bug in it when a company uses units-of-measure. The program now attempts to determine the detail in the undeposited funds account by searching Deposits made after the beginning balance date for Payments received before the beginning balance date. The  number of days searched is controlled by user preference.

8.03 (03/06/08) Replaced browse buttons with Add/Change buttons.

8.02 (11/09/07) Now works with UK QuickBooks 2008.

8.01 (10/04/07) Works with QuickBooks 2008.

6.11 (10/01/07) Now works with Access 2007. Tests for subaccounts and descriptions on Accounts Receivable and Accounts Payable accounts. Creates Journal Entry for Deposit transactions in Unpaid Accounts Payable

4.15 (07/05/07) Minor change in AU version.

6.10 (05/07/07) The Menus form (used when other programs overwrite our custom menus) was updated for the reconciliations screen.

6.09 (02/06/07) Automatically adds the Beginning Bal Equity account when transferring only uncleared bank transactions. 

6.08 (01/15/07) Now handles orphaned Bill Payment Credit Card transactions in the Accounts Payable transfer. Also added the ability to transfer uncleared checks and deposits at the beginning balance date.

6.07 (12/28/06) Now correctly handles rejects with an apostrophe in the name rejected.

6.06 (10/12/06) Added about page, restored error handler dropped in 6.05 and added Requirements document.

6.05 (10/11/06) Switched to late binding. Revised documentation.

6.04 (09/18/06) Now works with US QB 2007 and Enterprise 7. Improved reject messages. Trial Balance now added with one account with per Journal Entry instead of one Journal Entry for all accounts.  

6.03 (03/13/06) Added UK 2006 capability.

6.02 (12/01/05) Added Canadian 2006 capability.

6.01 (10/05/05) Released version 6 for QuickBooks 2006 and 2007 and Enterprise Solutions 6 and 7.

4.14 (06/18/05) Added ability to work with Australian QuickBooks. Also transfers cheques in addition to checks.

4.13 (04/23/05) Now checks to see if the "Use Account Number" preference is unchecked. Also now correctly handles multicurrency invoices and bills in Canadian QuickBooks. Added ability to work with QuickBooks UK.

4.12 (01/22/05) Now handles Unpaid Bill amounts generated by "Checks". Now uses Beginning Bal Equity account instead of Opening Bal Equity account as a clearing account for trial balance summary amounts and and offsetting open transaction details. 

4.11 (11/12/04) Corrected problem that locked out Canadian QuickBooks 2005 users.

4.10 (11/03/04) Updated Initial Connection screen for the new streamlined connection procedure available in QuickBooks 2005. Also added Connecting to QuickBooks 2005 help document. 

4.09 (10/27/04) Revised program to work with QuickBooks 2005.

4.08/3.05 (09/07/04) Revised programs to eliminate erroneous error messages generated by Access 2003.

4.07 (05/23/04) If the Reference Number on Statement Charges is blank, calculates and assigns a 11 digit Reference Number so payments can be applied using our Data Transfer Utility version 4.08 and later. Prior versions of this program calculated a 6 digit Reference Number which wasn't always unique.

4.06 (05/17/04) Now handles multiple inventory accounts correctly in the trial balance transfer (providing the account names begin with the word "Inventory" and they are of the type "Other Current Assets").

4.05 (05/06/04) Calculates Ref Number (6 digits long) on Statement Charges so payments can be applied using our Data Transfer Utility. 

4.04/3.04 (01/14/03) Mod A/P to handle balances created by Bill Payment checks.

4.03/3.03 (01/05/04) Mod A/R and A/P to handle balances recorded by journal entry. Mod A/R to handle balances  recorded by check or deposit. Include inactive accounts in special account lookups. Corrected handling of dates on balances created by journal entry.

4.02/3.02 (12/31/03) Corrected problem with handling of multiple A/P and A/R accounts and spelling error on un-located Opening Bal Equity accounts.

4.01/3.01 (12/02/03) revised Open Invoice and Unpaid Bill reports to run correctly as of any date.

4.00 (11/15/03) Initial release for use with QuickBooks 2004.

3.00 (10/23/03) Initial commercial release.