Importing General Journal Entries
Sage 50 Accounting uses a wizard to import general journal entries from your accountant or another program, such as a spreadsheet program.
Notes: You can import only transactions you would normally enter in the General Journal window.
Transactions that affect the linked Accounts Receivable, Accounts Payable, Payroll Advances,
The program does not update any other modules after it imports transactions.
The file must be in text format.
Transaction File Specifications
The first line must include
- 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.
Tax header and detail lines are optional, but if you use one, you must use the other
- 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
Transaction detail lines include
- 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.
