The Joomla! Forum ™





Post new topic Reply to topic  [ 9 posts ] 
Author Message
PostPosted: Thu Aug 19, 2010 6:04 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Aug 19, 2010 5:58 am
Posts: 2
I took on a bookkeeping assigment where they forwarded me files in which need to be imported to Quickbooks. does anyone have a clue how I am suppose to do that. I am not a programmer and do not understand Joomla.

Example attached.....Please help..... :'(


You do not have the required permissions to view the files attached to this post.


Top
 Profile  
 
PostPosted: Thu Aug 19, 2010 7:29 am 
Joomla! Hero
Joomla! Hero

Joined: Tue Aug 23, 2005 1:56 pm
Posts: 2414
Location: Kent / Sussex / Surrey border UK
Quick books is an accounting program and Joomla is a content management program, they are not the same or compatible.

_________________
http://www.gadsolutions.biz Electrical services
http://www.electrical-testing-safety.co.uk Testing services


Top
 Profile  
 
PostPosted: Thu Aug 19, 2010 1:09 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Aug 19, 2010 5:58 am
Posts: 2
The owner sent me the Joomla files and insists they can be imported via Access. Any ideas? ANYONE?????

Or I guess how to change a CSV file into an Excel file...


Top
 Profile  
 
PostPosted: Thu Aug 19, 2010 2:44 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Mon Jun 21, 2010 2:38 pm
Posts: 210
Hi :)

If you are using linux instead of Windows then try GnuCash as it can import Quickbooks data usefully. Importing a csv file into Excel or the OpenOffice equivalent should be fairly easy but then you have a spreadsheet rather than an accounting package. OpenOffice is free and available for Windows. Here's the link for that
http://www.openoffice.org/
The website magically spots which OS you are using and gives you the appropriate version, hopefully.

Gotta love that free and OpenSource philosophy making it fairly easy to port programs to multiple different platforms.
Good luck and regards from
Tom :)

PS i would seriously consider moving to linux, perhaps try the Ubuntu version, so that you can access these programs in their native environment along with other powerful programs and enjoy greater security too.

[Edit]
Wow!! I have just found that GnuCash is available for Windows too. Here's the link
http://www.gnucash.org/
http://www.gnucash.org/download.phtml
and some info
http://wiki.gnucash.org/wiki/Windows


Top
 Profile  
 
PostPosted: Thu Aug 19, 2010 7:40 pm 
Joomla! Hero
Joomla! Hero

Joined: Tue Aug 23, 2005 1:56 pm
Posts: 2414
Location: Kent / Sussex / Surrey border UK
GConwayFL wrote:
The owner sent me the Joomla files and insists they can be imported via Access. Any ideas? ANYONE?????

Or I guess how to change a CSV file into an Excel file...

A CSV file is to all intents and purposes an Excel file just double clicking on it should open it in Excel, assuming you have MS office installed, you can import it into an access data base as well if you want to. None of this has anything to do with joomla, however if you have a website running joomla you can import it into the MySql data base that joomla uses via phpmyadmin.

_________________
http://www.gadsolutions.biz Electrical services
http://www.electrical-testing-safety.co.uk Testing services


Top
 Profile  
 
PostPosted: Fri Aug 20, 2010 9:49 am 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Mon Jun 21, 2010 2:38 pm
Posts: 210
Brilliant, good point. MySql is a database program just like Access except less quirky and much more pure sql which means it is compatible with other database programs. So importing the csv file into MySql makes a lot more sense then trying to use Excel or Access. Note that Access is excessively expensive and OpenOffice includes a free alternative but you can side-step all that by using MySql which was installed when you installed Joomla.

However, if you are looking for an accounts package that can handle output from Quickbooks then GnuCash is probably the best, and it's free. Sage can cost quite a bit and i am not certain it can import Quickbooks data. Quickbooks costs but can read Quickbooks data (obviously). TAS costs money and its' unclear whether it can import Quickbooks data. GnuCash specifies Quickbooks as being something it can import data from

Regards from
Tom :)


Top
 Profile  
 
PostPosted: Wed Aug 25, 2010 2:04 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Aug 25, 2010 1:40 pm
Posts: 2
Thanks for the info! I just started using Quickbooks with the company I started.

_________________
Signature rules: Literal URLs only - viewtopic.php?f=8&t=65


Top
 Profile  
 
PostPosted: Wed Sep 22, 2010 10:25 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Dec 23, 2009 12:46 am
Posts: 36
I am trying to fiqure out how to process credit cards on a joomla website and download the transactions into QuickBooks. Do you have any suggestions?

Thus far I have discovered iGateway has a $28.00 component I can purchase that will work with a gateway product from Innovative Gateway Solutions which in turn feeds to the merchant account at QuickBooks Merchant Services. This seems a bit excessive.

I'm looking for ideas on shopping carts, gateways, merchant accounts. The whole thing is highly confusing at this point so anything you can provide will delay my premature graying this is causing.

The ultimate [drive] is being able to import activity into QuickBooks.

Thanks in advance!


Top
 Profile  
 
PostPosted: Thu Sep 23, 2010 5:52 am 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Thu Aug 18, 2005 5:53 pm
Posts: 1958
Location: Washington D.C. & Baltimore, MD Metro
I know that if you use a Joomla extension such as VirtueMart or maybe one of the billing / invoicing extensions such as JForce, you could use their payment systems to work with PayPal. And then in PayPal you can download your transactions into a Qicken or QuickBooks format that can be imported.

Just be aware that some extensions only send pieces of the sale or invoice or transaction over to PayPal (such as an invoice number and not the actual product name / service you are selling).

_________________
Thanks,
Roger Raymond


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 



Who is online

Users browsing this forum: No registered users and 15 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group