QuickBooks to GnuCash -- Apologies for wrong question

[Tom Bullocik]

Derek Atkins wrote:
> 
> LRP <lloyd at paisite.com> writes:
> 
>>
>> Does anyone have experience transferring QuickBooks accounts and data to
>> GnuCash via CSV and QIF conversions?
>>
>> How painful was it?
> 
> Once you get it into QIF format it's fairly straight forward.  But note
> that you can only import the transaction data, not your customer,
> vendor, or invoice lists.
> 
> -derek
> 
> LRP,
> 
> What Derek has commented is certainly correct.  My experience is current:
> I am moving my QB transactions into GC as listed in the steps below.  Be
> aware that I have not yet solved all my conversion problems  because (a) I
> am very new to GC, and (b) I use lots of SPLITS in QB and have not  spent
> enough time yet getting sufficiently familiar with getting those into the
> conversion process.
> 
> INSIDE QB:
> 1.  After trial and error I found that using the Journal Report that QB
> provides seems to be best to capture the full range of my transactions.  I
> at first set the date parameters to catch just one month (1/1/xx -
> 1/31/xx).
> 2.  When that report is open I use the QB Excel function to open and
> create a new Excel report.
> 3.  Inside Excel I use the step 2 report and  save it as an Excel file
> (*.xls).  This is backup to save having to repeat 1 & 2.
> 4.  I next use the Save As function to create a new name and scroll thru
> the Type Of drop.-down menu of file types to select CSV (*.csv).
> 5.  Using the conversion utility (CALC2QIF, you can google this) with the
> step 4 file as input, I convert to QIF and use the converted file as input
> to the GC import process.
> 
> My present results indicate:
> a)  it probably would be better for me to subset the step 1 process so
> that each output file was just one type of transaction.  My transactions
> are mostly in these 3 types: cash related, credit card, general journal. 
> So far I have not been able to spend time on the best way to separate
> these 3 groups.  The reason for doing this is that it helps me focus on
> where in QB to look when I have to track down a  conversion problem.
> b)  I have not decided yet how  much effort to put into resolving split
> problems so that the  conversion would work without a lot of entries into
> the IMBALANCE account that have to be recategorized after conversion.  If
> I have printed QB listings of all transactions, it may be quicker and
> simpler to let things go to imbalance and fix them after conversion than
> to try to identify all the various QIF conversion scenarios.
>  
> While this may seem to  be a lot of hassle, the actual conversion process
> is so fast that it seems instantaneous.  Once I  get the first month to
> work properly, I expect subsequent months to be converted with much less
> effort.
> 
>  I need to include all transactions for the year, since I use my
> accounting system (QB, and now GC) to support the numbers that are
> reported in my annual US tax returns.  For tax return support purposes, at
> year end i print the General Ledger and all financial statements.  
> 
> If I get any more insights I can report them back to the GC User List. 
> 
> Best,
> 
> Tom
> 
> 
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> li
> 

-- 
View this message in context: http://gnucash.1415818.n4.nabble.com/QuickBooks-to-GnuCash-Apologies-for-wrong-question-tp2124870p2132829.html
Sent from the GnuCash - User mailing list archive at Nabble.com.