QUICKBOOKS OL-222

how_to_make_quickbooks_qbo.txt

Quickbooks OL-222 error help

Quickbooks QBO files are based on the OFX spec.
Instead of reading the spec, here are the actual real
world rules since Intuit doesn't appear to care about documentation or helping.

This is particularly useful if you want to avoid the "OL-222" error when
trying to import your own QBO files.

<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20100526120000[0:GMT]
<TRNAMT>-2341.23
<FITID>201005261
<NAME>05/25 Walmart 111-111-1111
<MEMO>More stuff that didn't fit
</STMTTRN>

<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20100526120000[0:GMT]
<TRNAMT>500.00
<FITID>201005261
<NAME>05/25 Paypal
</STMTTRN>


- Credits are positive amounts
- Debits are negative amounts and should have negative sign
- No commas or dollar signs

- No field can be over 36 characters
- No field can be blank, so for instance, if you don't have a MEMO, then remove the field
- The FITID must be unique, most banks are just using a timestamp
suffixed with which number transaction it is per the day: (201005260, 201005261, 201005262 etc...)

HEADER:
The fields contain bank specific codes, you should look at something your bank has already provided.
I have not included them here.


Footer
Put the current date for DTASOF fields.
Put 1 for BALAMT.
You DO NEED these fields, but the values don't seem to matter.
The fields cannot be blank.

</BANKTRANLIST>
<LEDGERBAL>
<BALAMT>1
<DTASOF>20101231120000[0:GMT]
</LEDGERBAL>
<AVAILBAL>
<BALAMT>1
<DTASOF>20101231120000[0:GMT]
</AVAILBAL>
</STMTRS>
</STMTTRNRS>
</BANKMSGSRSV1>
</OFX>


Official OFX docs: http://www.ofx.net/DownloadPage/Downloads.aspx