Importing General Journal Entries
Sage Simply Accounting uses a wizard to import general journal entries from your accountant or another program, such as a spreadsheet
program. Note that:
- 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, Vacation Payable, or Inventory accounts can only be imported
if they were created by your accountant using Sage Simply Accounting Accountants' Edition and an accountant's
copy of your company data.
- 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.
Sample transaction file
What do you want to do?
Import general journal entries from a text file