Uploading Journal Entries
To Upload journal entries into Rillet, navigate to Close Management > Account Register and select Upload Journal Entries
You can either download the journal entry template or just directly upload if you have already populated a template.
In the template fill out the following fields:
Date
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
Custom Fields - Field {field_name}
When using custom Fields in Rillet for Department, Segment etc. you can upload the Field values on the journal entry template. Follow these easy steps:
Update the template header for the name of your field. For example, if you have a Field in Rillet called "Department" the Template header should be
Field DepartmentAdd additional Columns for other Fields
Add Field Values on the Lines
Example:
Last updated