Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

QuickBooks 2005

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #1  
Old 10-18-2005, 09:15 AM
 
a.harris a.harris is offline
 

Member
  
Join Date: Aug 2005
Posts: 13
 

Default QuickBooks 2005

Having struggled with QuickBooks 2005 integration, getting the IIF to be formated properly; we have modified the

Code:
skin1/modules/QuickBooks/orders_export_qb.tpl

file to be what we think is in line with the required specifications:

Enjoy

Code:
{* $Id: orders_export_qb.tpl,v 1.13.2.7 2005/03/09 12:58:05 mclap Exp $ *} !ACCNT{$delimiter}NAME{$delimiter}ACCNTTYPE{$delimiter}SCD{$delimiter}EXTRA{$delimiter}HIDDEN {* Define account for taxes. Please don't change ACCNTTYPE & EXTRA fields for it! It must be an income account. *} ACCNT{$delimiter}{$config.QuickBooks.acct_tax}{$delimiter}INC{$delimiter}{$delimiter}{$delimiter}N {assign var="have_processed" value=""} !CUST{$delimiter}NAME{$delimiter}BADDR1{$delimiter}BADDR2{$delimiter}BADDR3{$delimiter}BADDR4{$delimiter}BADDR5{$delimiter}SADDR1{$delimiter}SADDR2{$delimiter}SADDR3{$delimiter}SADDR4{$delimiter}SADDR5{$delimiter}PHONE1{$delimiter}FAXNUM{$delimiter}EMAIL{$delimiter}CONT1{$delimiter}SALUTATION{$delimiter}COMPANYNAME{$delimiter}FIRSTNAME{$delimiter}LASTNAME{$delimiter}CUSTFLD1 {section name=oid loop=$orders} CUST{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$orders[oid].b_firstname} {$orders[oid].b_lastname}{$delimiter}{$orders[oid].b_address} {$orders[oid].b_address_2}{$delimiter}"{$orders[oid].b_city}, {$orders[oid].b_state} {$orders[oid].b_zipcode}"{$delimiter}{$orders[oid].b_countryname}{$delimiter}{$delimiter}{$orders[oid].s_firstname} {$orders[oid].s_lastname}{$delimiter}{$orders[oid].s_address} {$orders[oid].s_address_2}{$delimiter}"{$orders[oid].s_city}, {$orders[oid].s_state} {$orders[oid].s_zipcode}"{$delimiter}{$orders[oid].s_countryname}{$delimiter}{$delimiter}{$orders[oid].phone}{$delimiter}{$orders[oid].fax}{$delimiter}{$orders[oid].email}{$delimiter}{$orders[oid].lastname}, {$orders[oid].b_firstname}{$delimiter}{$orders[oid].title}{$delimiter}{$orders[oid].company}{$delimiter}{$orders[oid].firstname}{$delimiter}{$orders[oid].lastname}{$delimiter}{$orders[oid].login} {/section} !TRNS{$delimiter}TRNSTYPE{$delimiter}DATE{$delimiter}ACCNT{$delimiter}{$delimiter}CLASS{$delimiter}AMOUNT{$delimiter}DOCNUM{$delimiter}MEMO{$delimiter}ADDR1{$delimiter}ADDR2{$delimiter}ADDR3{$delimiter}ADDR4{$delimiter}ADDR5{$delimiter}SHIPVIA{$delimiter}SADDR1{$delimiter}SADDR2{$delimiter}SADDR3{$delimiter}SADDR4{$delimiter}SADDR5{$delimiter}TOPRINT !SPL{$delimiter}TRNSTYPE{$delimiter}DATE{$delimiter}ACCNT{$delimiter}{$delimiter}CLASS{$delimiter}AMOUNT{$delimiter}DOCNUM{$delimiter}MEMO{$delimiter}PRICE{$delimiter}QNTY{$delimiter}INVITEM{$delimiter}TAXABLE{$delimiter}EXTRA !ENDTRNS {if $config.QuickBooks.export_invitems eq "Y"} {* Declare invetory items *} !INVITEM{$delimiter}NAME{$delimiter}INVITEMTYPE{$delimiter}DESC{$delimiter}PURCHASEDESC{$delimiter}ACCNT{$delimiter}PRICE{$delimiter}COST{$delimiter}TAXABLE{$delimiter}REORDERPOINT{$delimiter}ASSETACCNT{$delimiter}COGSACCNT {section name=oid loop=$orders} {if $orders[oid].gcid}{* INVITEM:GIFT CERTIFICATE *} INVITEM{$delimiter}GIFT CERTIFICATE{$delimiter}INVENTORY{$delimiter}GC#{$orders[oid].gcid}{$delimiter}GC#{$orders[oid].gcid}{$delimiter}{$config.QuickBooks.acct_gc}{$delimiter}{$orders[oid].amount}{$delimiter}0{$delimiter}N{$delimiter}0{$delimiter}{$config.QuickBooks.acct_inv_asset}{$delimiter}{$config.QuickBooks.acct_inv_cogs} {else}{* INVITEM:PRODUCT *} {if $orders[oid].productcode ne ""}{assign var="invitem_name" value=$orders[oid].productcode} {else}{assign var="invitem_name" value=$orders[oid].productid} {/if} INVITEM{$delimiter}{$invitem_name}{$delimiter}INVENTORY{$delimiter}{$orders[oid].product}{if $orders[oid].product_options ne ""}\n{$orders[oid].product_options}{/if}{$delimiter}{$orders[oid].product}{if $orders[oid].product_options ne ""}\n{$orders[oid].product_options}{/if}{$delimiter}{$config.QuickBooks.acct_product}{$delimiter}{$orders[oid].price}{$delimiter}0{$delimiter}N{$delimiter}{$config.QuickBooks.qb_reporderpoint}{$delimiter}{$config.QuickBooks.acct_inv_asset}{$delimiter}{$config.QuickBooks.acct_inv_cogs} {/if} {/section} {/if}{* $config.QuickBooks.export_invitems eq "Y" *} {assign var="new_order" value=""} {section name=oid loop=$orders} {if $orders[oid].total gt 0} {assign var="order_total" value=$orders[oid].total} {else} {math equation="x+y" x=$orders[oid].total y=$orders[oid].giftcert_discount assign="order_total"} {/if} {if $new_order ne $orders[oid].orderid}{* start new order *} {if $new_order ne ""} {* make qb happy *} SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_tax}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}0{$delimiter}{$orders[oid].orderid}{$delimiter}TAX{$delimiter}{$delimiter}{$delimiter}{$delimiter}N{$delimiter}AUTOSTAX ENDTRNS {/if} {assign var="new_order" value=$orders[oid].orderid} TRNS{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}HSBC{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}{$order_total}{$delimiter}{$orders[oid].orderid}{$delimiter}Website Order: {$orders[oid].details|replace:"\r":" "|replace:"\n":" "|replace:"\t":" "}{$delimiter}{$orders[oid].b_firstname} {$orders[oid].b_lastname}{$delimiter}{$orders[oid].b_address} {$orders[oid].b_address_2}{$delimiter}"{$orders[oid].b_city}, {$orders[oid].b_state} {$orders[oid].b_zipcode}"{$delimiter}{$orders[oid].b_countryname}{$delimiter}{$delimiter}{$delimiter}{$orders[oid].s_firstname} {$orders[oid].s_lastname}{$delimiter}{$orders[oid].s_address} {$orders[oid].s_address_2}{$delimiter}"{$orders[oid].s_city}, {$orders[oid].s_state} {$orders[oid].s_zipcode}"{$delimiter}{$orders[oid].s_countryname}{$delimiter}{$delimiter}Y {* start new order *} {if $orders[oid].gcid}{* CASH SALE:GIFT CERTIFICATE *} SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_gc}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}-{$orders[oid].amount}{$delimiter}{$orders[oid].orderid}{$delimiter}GC#{$orders[oid].gcid}{$delimiter}{$orders[oid].amount}{$delimiter}-1{$delimiter}GIFT CERTIFICATE{$delimiter}N{$delimiter} {else}{* CASH SALE:PRODUCT *} {if $orders[oid].productcode ne ""}{assign var="invitem_name" value=$orders[oid].productcode} {else}{assign var="invitem_name" value=$orders[oid].productid} {/if} SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_product}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}-{$orders[oid].cost}{$delimiter}{$orders[oid].orderid}{$delimiter}{$orders[oid].product}{if $orders[oid].product_options ne ""}\n{$orders[oid].product_options}{/if}{$delimiter}{$orders[oid].price}{$delimiter}-{$orders[oid].amount}{$delimiter}{*$invitem_name*}TFT Non Stock{$delimiter}N{$delimiter} {/if} {if $orders[oid].total gt 0 and $orders[oid].giftcert_discount gt 0} SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_gc_discount}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}{$orders[oid].giftcert_discount}{$delimiter}{$orders[oid].orderid}{$delimiter}{$orders[oid].applied_giftcerts}{$delimiter}-{$orders[oid].giftcert_discount}{$delimiter}-1{$delimiter}GIFT CERTIFICATE(s){$delimiter}N{$delimiter} {/if} SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_shipping}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}-{$orders[oid].shipping_cost}{$delimiter}{$orders[oid].orderid}{$delimiter}{$orders[oid].shipping|trademark}{$delimiter}{$orders[oid].shipping_cost}{$delimiter}-1{$delimiter}Shipping{$delimiter}N{$delimiter} {if $orders[oid].coupon_discount gt 0} SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_coupon_discount}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}{$orders[oid].coupon_discount}{$delimiter}{$orders[oid].orderid}{$delimiter}{$orders[oid].coupon}{$delimiter}-{$orders[oid].coupon_discount}{$delimiter}-1{$delimiter}COUPON DISCOUNT{$delimiter}N{$delimiter} {/if} {if $orders[oid].discount gt 0} SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_discount}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}{$orders[oid].discount}{$delimiter}{$orders[oid].orderid}{$delimiter}DISCOUNT{$delimiter}-{$orders[oid].discount}{$delimiter}-1{$delimiter}DISCOUNT{$delimiter}N{$delimiter} {/if} {foreach key=tax_name item=tax from=$orders[oid].tax_values} {if $tax.tax_cost gt 0} SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}VAT Control{*$config.QuickBooks.acct_tax*}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}-{$tax.tax_cost}{$delimiter}{$orders[oid].orderid}{$delimiter}{$tax.tax_display_name} {$tax.rate_type}{$tax.rate_value}{$delimiter}{$vat_value}{$delimiter}-1{$delimiter}TAX{$delimiter}N{$delimiter} {/if} {/foreach} {/if} {if %oid.last%} {* make qb happy *} SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}VAT Control{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}0{$delimiter}{$orders[oid].orderid}{$delimiter}TAX{$delimiter}{$delimiter}{$delimiter}{$delimiter}N{$delimiter}AUTOSTAX ENDTRNS {/if} {/section} {if $config.QuickBooks.qb_exportpayments eq "Y"} !TRNS{$delimiter}TRNSTYPE{$delimiter}DATE{$delimiter}ACCNT{$delimiter}NAME{$delimiter}AMOUNT{$delimiter}PAYMETH{$delimiter}DOCNUM !SPL{$delimiter}TRNSTYPE{$delimiter}DATE{$delimiter}ACCNT{$delimiter}NAME{$delimiter}AMOUNT{$delimiter}DOCNUM !ENDTRNS {assign var="new_order" value=""} {section name=oid loop=$orders} {if $orders[oid].status eq "P"} {if $orders[oid].total gt 0} {assign var="order_total" value=$orders[oid].total} {else} {math equation="x+y" x=$orders[oid].total y=$orders[oid].giftcert_discount assign="order_total"} {/if} {if $new_order ne $orders[oid].orderid}{* start new order *} {if $new_order ne ""} ENDTRNS {/if} {assign var="new_order" value=$orders[oid].orderid} TRNS{$delimiter}PAYMENT{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}Undeposited Funds{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$order_total}{$delimiter}{$orders[oid].payment_method}{$delimiter}{$orders[oid].orderid} SPL{$delimiter}PAYMENT{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}HSBC{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}-{$order_total}{$delimiter}{$orders[oid].orderid} {if %oid.last%} ENDTRNS {/if} {/if}{* start new order *} {/if} {/section} {/if}{* $config.QuickBooks.qb_exportpayments eq "Y" *}
__________________
Rocate
Reply With Quote
  #2  
Old 10-20-2005, 12:20 PM
 
extremeis extremeis is offline
 

Newbie
  
Join Date: May 2005
Posts: 9
 

Default

Hello,

Does this modification import the credit card info found in the note field to the payment info area within QB2005?

I have a client who has been struggling with this as they process all orders through quickbooks.

Ryan
__________________
Ryan Porter
Extreme Internet Solutions
Reply With Quote
  #3  
Old 11-10-2005, 07:04 AM
 
elviselviselvis elviselviselvis is offline
 

Newbie
  
Join Date: Oct 2005
Posts: 6
 

Default

A.harris
I too am modifying the export file for quicken, but would like to do the following:
We have prepaid certificates that people can buy for themselves or a freind so these types of sales on the system need to come into Quickbooks as a liability.
Also since we are in US we need the taxes collected to come into the quickbooks as a tax payable liability -- currently the default quickbook .tpl file has them imported into sales.
IF you get any feed back or help with your issues please post and i will post anything i find on this matter also
Cheers!
Sam
__________________
x-Cart version 4.0.16
www.winterdrive.com
Reply With Quote
  #4  
Old 12-27-2005, 08:44 AM
 
delphi delphi is offline
 

Senior Member
  
Join Date: Jul 2004
Posts: 185
 

Default Re: QuickBooks 2005

Anyone with luck on running IFF for Quickbook 2005?

I used the code above and when I imported, everything is okay but it does not show any transaction in Quickbook.

Is there anything that I am missing?
__________________
X-Cart Gold version 4.4.4
X-Cart directory /home/web/u/ugchweb/cart
PHP 5
MySQL server 5
Reply With Quote
  #5  
Old 12-27-2005, 09:43 AM
 
elviselviselvis elviselviselvis is offline
 

Newbie
  
Join Date: Oct 2005
Posts: 6
 

Default

Delphi,
I have the same problem.

I get the customer data to import but the sales comes in as Invoice, nothing in the deposit of the check register.
I dont have enough information on how to format the file so that all the proper fields in Quickbooks gets data...... But will post any updates to my search and trials... here...


Sam
__________________
x-Cart version 4.0.16
www.winterdrive.com
Reply With Quote
  #6  
Old 12-27-2005, 10:34 AM
 
delphi delphi is offline
 

Senior Member
  
Join Date: Jul 2004
Posts: 185
 

Default

Thanks,

I've been using Quickbook 2003 and all import/export are fine. Until recently we upgraded to Quickbook 2005 Pro and the IIF export is not mapping anymore.

really need some expert help here
__________________
X-Cart Gold version 4.4.4
X-Cart directory /home/web/u/ugchweb/cart
PHP 5
MySQL server 5
Reply With Quote
  #7  
Old 01-02-2006, 09:27 AM
 
SoapLady SoapLady is offline
 

Advanced Member
  
Join Date: Feb 2003
Posts: 60
 

Default QB 2006

I just upgraded to QB 2006.

Does anyone have experience with X-Cart into QB2006 or know if the QB2005 specs will work for importing into QB2006?
__________________
SoapLady
Working with various versions of X-Cart Gold
from 4.0.x to 4.4.1
(Trying to get everyone up to 4.4.x)
Reply With Quote
  #8  
Old 01-31-2006, 11:53 AM
  shipmerchant's Avatar 
shipmerchant shipmerchant is offline
 

eXpert
  
Join Date: Mar 2005
Posts: 361
 

Default

I opened a ticket with Xcart and the reply was that they can only gurantee export to QB for sure with QB02/QB03. Thats the information I have recieved
which was rather disapointing, but hopefully they will get on this soon, as I dont of too many people who would use such an outdated program.

Lets stay tuned.
__________________
Mil Mascaras
Live Xcart Site #1-V- 4.1.8
Live Xcart site # 2-V 4.4.3
CDSEO Mod - Firetank MM30 - 7DANA- The bestTemplates!
Linux - EWD Host Servers awesome service!
AlteredCart One Page Checkout
Reply With Quote
  #9  
Old 02-01-2006, 06:59 PM
 
SoapLady SoapLady is offline
 

Advanced Member
  
Join Date: Feb 2003
Posts: 60
 

Default Quickbooks

Thanks.

I expect that it will become important at some point!
__________________
SoapLady
Working with various versions of X-Cart Gold
from 4.0.x to 4.4.1
(Trying to get everyone up to 4.4.x)
Reply With Quote
  #10  
Old 02-03-2006, 06:44 PM
  shipmerchant's Avatar 
shipmerchant shipmerchant is offline
 

eXpert
  
Join Date: Mar 2005
Posts: 361
 

Default

Well I just tried the export from the store and imported the .IFF file into QBPremier 06 and all seems to be fine. We only use PayPal at this point in our venture so every transaction comes in as invoice even though its been processed. So I think it will require some modifications to correct it, but other than that, all seems to be working for now.

I am just amazed that there is little if no support on this from Xcart, but then again QB is another parties application.

BTW this was all done without applying any mods at this point all was set as default. We plan to meet with our accountant sometime soon to see if they can recomend any changes we would need to make sure QB is getting all the necessary information in the stores export, then move on from there.

__________________
Mil Mascaras
Live Xcart Site #1-V- 4.1.8
Live Xcart site # 2-V 4.4.3
CDSEO Mod - Firetank MM30 - 7DANA- The bestTemplates!
Linux - EWD Host Servers awesome service!
AlteredCart One Page Checkout
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 06:47 PM.

   

 
X-Cart forums © 2001-2020