Upload Journal Entries
You can upload journal entries (JEs) directly into Rillet using a pre-filled template. This lets you record multiple transactions efficiently and keep your account register up to date. Once uploaded, the entries appear in Account Register, ready for review and posting.
To upload a journal entry:
Go to Close Management > Account Register.
Select Upload Journal Entries.
Download the journal entry template, or upload your own if you already have one prepared.
Fill out the template with the following fields:
HeaderRequired?LevelDescriptionDate
Yes
Header
The effective date of the JE. Date formats accepted are YYYY-MM-DD, MM/DD/YYYY, or DD/MM/YYYY
JE Name
Yes
Header
Top level description of the JE
Debit Amount
Yes
Line
Debit impact of the JE Line
Credit Amount
Yes
Line
Credit impact of the JE line
Currency
Yes
Header
Currency of the JE
FX Rate
Header
Optional override of the default FX rate
Account Number or Name
Yes
Line
The GL account related to the JE line. You can use either the account number (recommended) or the account name.
Description
No
Line
Optional line level description
Vendor Name
No
Header
Vendor related to the JE, if applicable. Cannot be used if customer is used.
Customer Name
No
Header
Customer related to the JE, if applicable. Cannot be used if vendor is used.
Reversal Date
No
Header
Optional JE reversal date.
Field {field_name}
No
Line
See below for more details
Save the template in CSV format.
Drag and drop your file or select Choose File.
Confirm the selected file and click Upload.
The journal entries will appear in the Account Register, ready for review and posting.
Custom fields (Field {field_name})
When using custom fields in Rillet (for example, Department or Segment), you can include them in the journal entry template:
Update the template header with the field name in Rillet. Example: if the field is Department, the column header should be Field Department.
Add additional columns for other custom fields.
Enter field values on each line.
Protips:
Use General text format for all fields except Date.
Each line can only have a Debit or Credit Amount, not both.
Always upload the file in CSV format.
See also
For related journal entry actions, see the following articles:
Last updated