Importing miscellaneous General Journal entries from a text file
Description
Cause
Resolution

Important information before you begin

  • Make a backup of your file before you begin
  • The import file must be in text format
  • If you’re using the Premium, Quantum, or the Accountants Edition you must be in Single-User Mode
  • Store the data locally and not on a server
    • If necessary, temporarily copy the data locally to do the import then copy the data back onto the server
  • Follow the rules described in this section

Restrictions on Importing

  1. Import only the types of transactions that you normally record in the Miscellaneous Transactions window.
  2. The program can't import transactions ufif you've finished entering the history that that affect the following linked accounts.
    • Accounts Receivable
    • Accounts Payable
    • Payroll Advances
    • Vacation Payable
    • Inventory accounts
  3. The program doesn't update any other modules after it imports transactions.

Formatting the Import File

The first line of every transaction must include the following:

  1. Separate the date in month-day-year order my hyphens. For example, enter October 14, 2024 as 10-17-24. A comma must follow the date.
  2. The source of the transaction (usually a document number, such as a cheque number or invoice number).
    • The source identification can be up to 13 characters, enclosed in straight quotation marks (" "), and followed by a comma
  3. A comment, such as a customer or employee name or a description of the transaction.
    • The comment can be up to 39 characters. Enclose in straight quotation marks.

Example 

Line 1

12-05-07,"1035-9315","Lionel Cardoz"

  • Lines 2-5 include the debits and credits for the transaction\
  • Use a separate line for each debit and credit
  • Enter debits as positive amounts, and credits as negative amounts
  • The amount must contain a period and two decimal places
  • The Details of the transaction must include the account number (four characters), followed by a comma. Press Enter after you type the amount
  • Each amount must be on a separate line and your debits must equal your credits

Line 2-5

1090,133.75
4020,-97.50
4060,-27.50
2490,-8.75

  • You can have as many detail lines as you need, but the amounts must balance
  • If they don’t, the transactions won't import. It won’t record any transactions until the entire file is correct
  • This table identifies the parts of a valid import file that contains two transactions

Line Type: Text entered in the import file

10-14-07,"338","Drafting Services for Ronald Black"
1080,150.00
4020,-150.00
10-14-07,"339","Consulting Services for Acme Ltd."
1080,2250.00
4040,-1250.00
4060,-1000.00

Example of importing with departments Note the dash between the account number and the department

4-30-15,"source","comment"
1710-0100,133.75
4020-0100,-97.50
4080-0200,-27.50
2460-0100,-8.75
04-30-15,"1034-9315","1000 s111-04"
1710-0100,234.75
4020-0100,-97.50
4080-0200,-27.50
2460-0100,-109.75
04-30-15,"1034-9315","1000 s111-04"
1710-0100,134.75
4020-0100,-197.50
4080-0200,-127.50
2460-0100,-9.75

Importing

  1. Go to File, Import / Export, Import Transactions.
  2. Follow the wizard.




Steps to duplicate
Related Solutions