Quickbooks export format

[Gary Bickford]

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:garyb@fxt.com.
Websystems, content/asset management systems
PHP, XML, Apache, Tomcat, SQL, JSP
FXT Corp, http://www.fxt.com, tel. 541-383-2749