All Collections
Accounting
Importing Data
How do I import register entries into accounting?
How do I import register entries into accounting?

Describes how to import register entries into the accounting module.

Updated over a week ago

You will need the Import permission to be able to access the import tools.

To access the import tools, visit the top toolbar, and select the cog menu > Import Data

From the dropdown choose Accounting > Register Entries

Note: Split transactions are only supported for importing with the Journal Entry import tool. Set the “Data Format” field to “Split Entries.”

Here you will be presented with a pop-up to select your file and import your data.

Choose the "Browse" button to locate your file, or drag and drop your CSV file.

After you upload your file you will have a chance to map your columns, the system will try to intelligently map columns with similar naming conventions.

Note: In the top right of the pop-up you can download a template file to help you map your columns correctly.

Below is the data that can be imported into the system. Some fields are required these are noted below -- Any fields with a red star are required. Any fields that are left blank will not be imported.

DETAILS

Register Account (required): Should be the exact name OR number of an existing cash or credit card account.

If using name, it must be the name exactly as it is in the system. If it's the account number, it must be the full account number (for sub accounts, it must be the full path)

Date (required)

Reference #: If type is Check, this is the check number. Otherwise, it is a general reference number

Payment Method

Memo

PAYEE IDENTIFIER

This is used to find the payee the record should be attached to. Identifier is either the Person or Business ID. Only set one of the mappings below.

Eternal ID: This is the unique id for the payee in an external system.

Payee ID: This is the unique id for the payee in One Church.

LINE ITEM DETAIL

Account (required): Should be the exact name or number of an existing account

Fund (required): Should be the exact name or number of an existing account

Description

Amount stored in (required) = 1 column
(Both positive and negative amounts are in a single column.)

Amount (required): A positive number represents money received. A negative number is money spent.

-OR-

Amount stored in (required) = 2 columns

(Positive numbers are in one column and negative numbers are in another.)

Money Spent (required)

Money Received (required)

  • If you need help, please contact support for guidance.

  • You can also submit a request for us to import your data if you would rather us do everything for you.

Did this answer your question?