• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 851
  • Last Modified:

Quickbooks - merge check registers from two companies

Problem:

    1. On PC 1 - Customer has existing company file with several years worth of records.
    2. On PC 2 - Customer has created a second company file (for same company) and input 6 months worth of bank statements.
    3. On PC 1 - Subsequent updates have been made to the original company file - leaving a 6 month gap in the check register.


 I need to export the check register on PC 2 and import/merge with existing register on PC 1

km
0
kmccain
Asked:
kmccain
  • 3
1 Solution
 
turn123Commented:
kmccain,

Not going to be a fun project no matter how you do it.

Do you have a programing language you can use to do this project with?

You can print the check register to a CSV file then import it using the QuickBooks SDK.

http://developer.intuit.com/QuickBooksSDK/Downloads/

Turn123
0
 
turn123Commented:
And of course if you don't have too many typing them in again would probaly be a good option.
0
 
turn123Commented:
Hi kmccain :-),
Since this question is starting to get old could you please give us an update on the status of this question?
See:  http://www.experts-exchange.com/help.jsp#hi51 Thank you, turn123 (s)
0
 
kmccainAuthor Commented:
Turned out to be fairly simple -

 First I exported the 6 months worth of register data to excel and then wrote a vb routine to import the spread sheet into a MSAccess table. Next I downloaded some sample IIF files from quickbooks.com and used vb to output the check register data in the proper IIF format and then imported that into quickbooks.

I have the SDK but since this was a one time thing I just cobbled together some vb routines.

 It's kind of a cludgy process but it got the job done.  Sample IIF files can be found at

http://www.quickbooks.com/support/faqs/qbw2002/117503.html

the rest of it was just reading and writing spreadsheets from a vb6 project.




0
 
NetminderCommented:
User resolved; closed, 500 points refunded.

Netminder
Site Admin
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now