Difference between revisions of "QuickBooks Column Headings"
From SmartWiki
| Line 1: | Line 1: | ||
The keyword for a transaction is TRNS; the keyword for each distribution line is SPL.<br /><br /> | The keyword for a transaction is TRNS; the keyword for each distribution line is SPL.<br /><br /> | ||
| − | The distribution lines appear immediately below the transaction. The keyword ENDTRNS appears after the last distribution line. In an import file, the first column for a transaction that has three distribution lines would look like this:<br />'''TRNS<br />SPL<br />SPL<br />SPL<br />ENDTRNS | + | The distribution lines appear immediately below the transaction. The keyword ENDTRNS appears after the last distribution line. In an import file, the first column for a transaction that has three distribution lines would look like this:<br />'''TRNS<br />SPL<br />SPL<br />SPL<br />ENDTRNS''' |
| − | |||
==Column Headings for transactions== | ==Column Headings for transactions== | ||
| − | |||
The following table shows the column headings for transactions. The TRNSTYPE, ACCNT, and AMOUNT columns are required. | The following table shows the column headings for transactions. The TRNSTYPE, ACCNT, and AMOUNT columns are required. | ||
Revision as of 16:42, 3 December 2014
The keyword for a transaction is TRNS; the keyword for each distribution line is SPL.
The distribution lines appear immediately below the transaction. The keyword ENDTRNS appears after the last distribution line. In an import file, the first column for a transaction that has three distribution lines would look like this:
TRNS
SPL
SPL
SPL
ENDTRNS
Column Headings for transactions
The following table shows the column headings for transactions. The TRNSTYPE, ACCNT, and AMOUNT columns are required.
