I was part of a discussion some time ago about exporting from Quickbooks
(Mac version). I have done a couple of quickie tests, and the output
appears to be essentially in spreadsheet format. It appears to be for
all accounts. It only includes this year, which only went through April
at this point (when I lost access to the Mac.) I don't recall if it
only includes this year because I selected it that way or because of
some other reason.
Here's an excerpt that includes all the 'Types' I noticed offhand. It's
been a while since I did this, so I don't recall exactly what my options
were - it appears this is for this year. I can send an example file to
someone, but I'd rather not post it on the list as it's real data.
Type Date Num Name Memo Account Class Clr Split Amount Balance
Jan - Dec '00
Bill 01/01/'00 Cellular One 2000 - Accounts Payable 6880 -
Telephone (21.53) (21.53)
Bill 01/01/'00 Cellular One 480-5468 6880 - Telephone 2000 -
Accounts Payable 21.53 0.00
Bill 01/01/'00 US West 2000 - Accounts Payable 6880 - Telephone
(69.95) (69.95)
Bill 01/01/'00 US West 6880 - Telephone 2000 - Accounts Payable
69.95 0.00
Bill 01/01/'00 Sun Mountain Water 2000 - Accounts Payable 6960 -
Water (8.00) (8.00)
Bill 01/01/'00 Sun Mountain Water 6960 - Water 2000 - Accounts
Payable 8.00 0.00
Bill 01/01/'00 central electric 2000 - Accounts Payable 6950 - Gas
and Electric (91.23) (91.23)
Bill 01/01/'00 central electric 6950 - Gas and Electric 2000 -
Accounts Payable 91.23 0.00
Bill 01/01/'00 Empire Net 2000 - Accounts Payable 6970 - Internet
Service (66.00) (66.00)
Bill 01/01/'00 Empire Net 6970 - Internet Service 2000 - Accounts
Payable 66.00 0.00
Invoice 01/01/'00 97151 SLB Sed VOID: 1200 - Accounts Receivable X
4070 - Services 0.00 0.00
Invoice 01/01/'00 97151 SLB Sed Systems Maintenance 4070 - Services X
1200 - Accounts Receivable 0.00 0.00
Invoice 01/01/'00 97152 SLB OCS 1200 - Accounts Receivable 4070 -
Services 2,573.00 2,573.00
Check 01/19/'00 US Bank Overdraft 1100 - Checking X 6060 - Bank
Service Charges (25.00) (25.00)
Check 01/19/'00 US Bank Minimum Balance 6060 - Bank Service Charges
1100 - Checking 25.00 0.00
Bill Pmt -Check 01/19/'00 419 US West 1100 - Checking X 2000 -
Accounts Payable (157.90) (157.90)
Bill Pmt -Check 01/19/'00 419 US West 2000 - Accounts Payable 1100 -
Checking 157.90 0.00
Payment 01/21/'00 SLB OCS 1499 - Undeposited Funds X 1200 - Accounts
Receivable 2,573.00 2,573.00
Payment 01/21/'00 SLB OCS 1200 - Accounts Receivable 1499 -
Undeposited Funds (2,573.00) 0.00
Deposit 01/21/'00 Deposit 1100 - Checking X 1499 - Undeposited Funds
2,573.00 2,573.00
Deposit 01/21/'00 SLB OCS Deposit 1499 - Undeposited Funds X 1100 -
Checking (2,573.00) 0.00
I hope this is useful.
GB
--
"The time from now until the completion of the project tends to become
constant."
- Douglas Hartree
Gary E Bickford, mailto:[EMAIL PROTECTED].
Websystems, content/asset management systems
PHP, XML, Apache, Tomcat, SQL, JSP
FXT Corp, http://www.fxt.com, tel. 541-383-2749
_______________________________________________
gnucash-devel mailing list
[EMAIL PROTECTED]
http://www.gnumatic.com/cgi-bin/mailman/listinfo/gnucash-devel
