The following can be imported as CSV file:
How to Import Journal Entries (Entries Only)
Template: journal_entry_import.csv.
Field Name | Data Type | Required | Import Rules |
Entry Date | Date | Required | Also accepts Date. When the firm's accounting close date is today or earlier, a date on or before it is rejected. |
Number | Number | Required | Unique within the firm. |
Year End Journal Entry | Yes/No | Optional | Also accepts Year End, Year End Entry. Blank is No. |
How to Import Journal Entries (Lines Only)
Template: journal_entry_line_import.csv. Each row adds a debit or credit line to an existing journal entry.
Field Name | Data Type | Required | Import Rules |
Journal Entry Number | Lookup | Required | Also accepts Number. Matched by number. |
Account Name | Lookup | Required | Matched by name. |
Location | Lookup | Optional | Also accepts Location Name. Matched by name. |
Division | Lookup | Optional | Also accepts Division Name. Matched by name. |
Debit Amount | Currency | Required column | See debit and credit rule below. |
Credit Amount | Currency | Required column | Must be greater than 0 when used. |
Description | Text | Optional |
|
Debit or credit. A row is a debit when Debit Amount is a positive number. Otherwise it's a credit and Credit Amount is used. A Debit Amount that starts with $ is read as a credit.
Location and Division. With general ledger allocations off, a blank value uses the firm's default. With them on, both are required.
Every entry must balance. After the import, each entry in the file is checked. If any entry's debits don't equal its credits, all lines from the file are deleted and the import fails with "Journal entry must balance to zero". The entries stay.
Can't run while a Journal Entries import is in progress.
Import after: Journal Entries, Accounts, and Locations and Divisions when used.
How to Import Journal Entries (Entries & Lines)
Template: full_journal_entry_import.csv. One file holds entries and their lines. The file is split into an entries file and a lines file, which then follow the two sections above.
Column | Used for |
Number | The entry number, and the entry each line belongs to |
Date | Entry date. The column must be named exactly Date. |
Year End Entry | Entry year-end flag |
Account Name, Location, Division, Debit Amount, Credit Amount, Description | The line |
Column names must match exactly. The alternative headers from the other imports aren't accepted, and other columns are ignored.
One entry is created per distinct Number. Date and Year End Entry come from the first row with that Number. Every row becomes a line.
The entries import runs first. If any entry row fails, the lines file isn't processed and shows "The entries import failed, so this file was not processed. Fix the entries errors and re-run the import."
How to Import Recurring Journal Entries (Entries Only)
Template: recurring_journal_entry_import.csv. The importing member is recorded as the creator.
Field Name | Data Type | Required | Import Rules |
Number | Number | Required | Unique within the firm. |
Name | Text | Required |
|
Frequency Type | Fixed list | Required | daily, weekly or monthly. Not case-sensitive. |
Frequency Interval | Number | Required | Greater than 0. |
Status | Fixed list | Required | active or inactive. Not case-sensitive. |
Start Date | Date | Required |
|
End Date | Date | Optional | After Start Date. |
Last Generation Date | Date | Optional |
|
Next Generation Date | Date | Optional |
|
Days of Week | List | Optional | Comma-separated day names, for example Monday, Friday. Unrecognized names are dropped. |
Days of Month | List | Optional | Comma-separated numbers 1–31. Other values are dropped. |
A Frequency Type or Status outside the list fails the whole import, not just the row.
How to Import Recurring Journal Entries (Lines Only)
Template: recurring_journal_entry_line_import.csv.
Field Name | Data Type | Required | Import Rules |
Recurring Journal Entry Number | Lookup | Required | Matched by number. |
Account Name | Lookup | Required | Matched by name. |
Debit Amount | Currency | Required column | See debit and credit rule below. |
Credit Amount | Currency | Required column |
|
Description | Text | Optional |
|
Location | Lookup | Optional | Also accepts Location Name. Matched by name. Blank uses the firm's default. |
Division | Lookup | Optional | Also accepts Division Name. Matched by name. Blank uses the firm's default. |
Debit or credit. A row is a debit when the whole-number part of Debit Amount is positive. A debit under 1.00 (for example 0.50) is read as a credit and Credit Amount is used.
Every entry must balance. If any recurring entry's debits don't equal its credits, all lines from the file are deleted and the import fails with "Recurring journal entry must balance to zero".
Lines don't post to the general ledger.
Can't run while a Recurring Journal Entries import is in progress.
How to Import Recurring Journal Entries (Entries & Lines)
Template: full_recurring_journal_entry_import.csv. The file is split into entries and lines, which follow the two sections above.
Column | Used for |
Number | The entry number, and the entry each line belongs to |
Name, Frequency Type, Frequency Interval, Status, Start Date, End Date, Last Generation Date, Next Generation Date, Days of Week, Days of Month | The entry |
Account Name, Debit Amount, Credit Amount, Description, Location, Division | The line |
Column names must match exactly. Entry values come from the first row with each Number. Every row becomes a line.
If any entry row fails, the lines file isn't processed.
