Skip to main content

Finance Pro - Import Journal Entries

Finance Pro - Import Journal Entries

K
Written by Keith Bell

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.

Did this answer your question?