Importing General Journal Entries

• The date, separated by hyphens (mm-dd-yy). The date must be followed by a comma.
• The source of the transaction (usually a document number, such as a cheque or invoice number), up to twenty characters. It must be enclosed in straight quotation marks ("12345678") and followed by a comma.
• Optional: A comment, such as a customer or employee name or transaction description, up to 75 characters. It must be enclosed in straight quotation marks.
• Optional: The name of the currency used, if the transaction is in a foreign currency.
• Optional: The exchange rate used if the transaction is in a foreign currency.

• The Tax header line starts with the prefix TAXH, followed by a comma, the number of tax detail lines that follow, followed by a comma, and either a zero to indicate sales or a one to indicate purchases tax.
• The number of tax detail lines must match the number indicated in the tax header. The format for the tax detail line is: TAXD,account number,tax name,tax code, amount subject to tax, tax amount,other tax paid

• The account number (four characters), followed by a comma.
• The amount, followed by a comma. Enter debits as positive amounts, credits as negative amounts.
• Optional: Comment in double quotes, followed by a comma.
• Optional: Number of project allocation lines that follow (enter zero if you are not allocating).
• Optional: Project allocation lines. Each line includes, the name of the project in double quotes, followed by a comma, and the percentage being allocated to the project. the percentage must include a period and two decimal places.

You can have as many detail lines as you need, but the amounts must balance to zero.