Setting up journal entry import
Set up journal entry import
- From the
> Manage
menu, click Import Journal Entries. - Select Settings.
- Under Import File Detail, enter:
| Field delimiter |
Select a field delimiter being used in the .csv file. Note: For a .csv file the delimiter will be a comma (,), other fields might separate fields differently. |
| Text qualifier |
Select a text qualifier (None, ", '). By default, " is selected. |
| Decimal symbol | Enter a symbol to use as a decimal. |
| Date delimiter |
Enter a date delimiter. By default, / is selected. |
| Date order |
Select the order the date appears in the file. |
| File contains a header | Check if the file contains a header. |
| Date leading zeros | Check if the date leads with zeros. |
| Four digit year | Check to use a four digit year. |
- Under Fields to Import, select from the available columns:
| Reference | Reference associated with the journal entry |
| Notes | Additional information associated with the journal entry that does not fit into other columns |
| Detail Notes | Notes about the detail entry |
| Account ID | The ID for the account for the journal entry |
| Account Key | The database identifier of the account associated with the journal entry |
| Department Key | The database identifier of the department associated with the journal entry |
To delete columns, click the 
next to the column. The following are default columns and cannot be removed:
| Basis | The basis of the journal entry |
| Accounting Date | The accounting date associated with the journal entry |
| Description | The description of the journal entry |
| Account Description | The account description of the journal entry |
| Department | The name of the department associated with the journal entry |
| Debit Amount | The debit amount of the journal entry |
| Credit Amount | The credit amount of the journal entry |
- Click Save.
| Note: |
A journal entry is created based on common Basis, Accounting dates, Description, and Reference (if included). Total Debits and Credits must equal zero. |
Concepts
About accrual vs. cash accounting basis
About importing journal entries
Tasks
Voiding and deleting journal entries
Entering a journal entry for a prior date
Filter and Sort Journal Entry items
Designing Reporting Journal Entry Widgets
Designing Journal Entry Task Widgets
Adding attachments to journal entries
Entering journal entries to intercompany accounts
References
