Skip to main content

Journal Entries

Journal Entries

E
Written by Eddie Jackson

Overview

To manually move money between accounts, you can create a journal entry. A journal entry can be made up of many lines so you can move money between multiple accounts at once. All credits and debits must balance. When complete, the transfers will show up in each account's ledger.

Navigation

Side Menu -> Journal Entries

Viewing Journal Entries

This page shows a list of all journal entries with their corresponding lines.

Permissions:

  • View Account

  • View Journal Entry

Key Information:

  • Number

  • Entry Date

  • Account

  • Description

  • Debit

  • Credit

Available Actions:

  • ✏️ - Edit journal entry

  • 🗑️ - Delete journal entry

Filters:

  • Account

  • Amount

  • Entry Date

  • Created At

  • Updated At

Searchable Fields:

  • Number

Adding a Journal Entry

This option is available on the journal entries page by clicking "Add Journal Entry".

Permissions:

  • View Account

  • Create Journal Entry

Required Fields:

  • Number

  • Entry Date

  • At least two entry lines with:

    • Account

    • Credit or Debit amount (must balance across all lines)

    • Description (optional)

Import Journal Entries

This option is available on the journal entries page by clicking "Import from CSV".

Permissions:

  • View Account

  • Create Journal Entry

  • Import Journal Entry

First, import journal entry headers with:

  • Number

  • Date

Import options:

  • Only validate CSV file, do not import records

  • Ignore Unmatched Headers

A template file can be downloaded to ensure proper formatting.

Import Journal Entry Lines

After importing journal entries, you must import corresponding entry lines through a separate import.

Permissions:

  • View Account

  • Create Journal Entry

  • Import Journal Entry

Entry line fields:

  • Journal Entry Number

  • Account Number (optional if Account Name is provided)

  • Account Name (optional if Account Number is provided; enter the name without the account number)

  • Debit Amount

  • Credit Amount

  • Description

Import options:

  • Only validate CSV file, do not import records

  • Ignore Unmatched Headers

A template file can be downloaded to ensure proper formatting.

Note: Journal entries must be imported before their corresponding lines. All debits and credits within a journal entry must balance.

Exporting Journal Entries

Permissions:

  • View Account

  • View Journal Entry

  • Export Journal Entry

To export journal entry data:

  1. Apply any desired filters to narrow down the records

  2. Click the "Export Journal Entry" button

  3. Select which columns to include in the export

  4. Click "Export" to generate and download the CSV file

Recurring Journal Entries

You can schedule journal entries to regularly create on a set schedule. We currently support daily, weekly, and monthly schedules. Visit the Recurring tab in Journal Entries to setup recurring entries.

Permissions:

  • View Account

  • Create Journal Entry

Key Information:

  • Number

  • Name

  • Frequency Type (Daily, Weekly, Monthly)

  • Frequency Interval (number of days/weeks/months between repeats)

  • Start Date

  • End Date

  • Last Generation Date

  • Next Generation Date

  • Account

  • Description

  • Debit

  • Credit

Filters:

  • Account

  • Amount

  • Created At

  • Updated At

Searchable Fields:

  • Number

Adding a Recurring Journal Entry

This option is available on the recurring journal entries page by clicking "Add Recurring Journal Entry".

Permissions:

  • View Account

  • Create Journal Entry

Required Fields:

  • Number

  • Start Date

  • Active

  • Schedule type and interval

  • At least two entry lines with:

    • Account

    • Credit or Debit amount (must balance across all lines)

    • Description (optional)

Schedule

Daily

Select number of days to repeat the entry.

Weekly

Select number of weeks to repeat the entry, and which days of the week to repeat on.

Monthly

Select number of months to repeat the entry, and which day of the month to repeat on.

Import Recurring Journal Entries

This option is available on the recurring journal entries page by clicking "Import from CSV".

Permissions:

  • View Account

  • Create Journal Entry

  • Import Journal Entry

First, import journal entry headers with:

  • Number

  • Name

  • Frequency Type

  • Frequency Interval

  • Start Date

  • End Date

Import options:

  • Only validate CSV file, do not import records

  • Ignore Unmatched Headers

A template file can be downloaded to ensure proper formatting.

Import Recurring Journal Entry Lines

After importing recurring journal entries, you must import corresponding entry lines through a separate import.

Permissions:

  • View Account

  • Create Journal Entry

  • Import Journal Entry

Entry line fields:

  • Recurring Journal Entry Number

  • Account Name

  • Debit Amount

  • Credit Amount

  • Description

Import options:

  • Only validate CSV file, do not import records

  • Ignore Unmatched Headers

A template file can be downloaded to ensure proper formatting.

Note: Recurring journal entries must be imported before their corresponding lines. All debits and credits within a journal entry must balance.

Related Articles
Did this answer your question?