Quickbooks export format
Dave Peticolas
dave@krondo.com
Tue, 24 Oct 2000 01:34:15 -0700
Gary Bickford writes:
> 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)
Looks like they're still using those strange dates ('00 for years in 2000).
Do you know why there are always 2 amounts, and why one of them is sometimes
zero and sometimes equal to the other?
dave