How to Use the Import Data File Tool
21 steps
2 minutes
1
Navigate to Brokerage Engine.
2
Click the "Accounting" tab to navigate to the BE Accounting module.
3
Click the "Quick Actions" menu.
4
Click the "Journal Entry" option.
5
A new Journal Entry will display.
6
Click the "Import Data File" button.
7
The prompt window will display the option to "Import From CSV"
8
Click "Download Import template"
A CSV file named "import-journal-entry-template" will automatically save on your "Downloads" folder.
Create the Import Journal Entry Template
9
The file will have the format below. Follow this template to import the information to BE Accounting.
10
In the column named "Post_Date (Journal Date)" fill out all cells with the Journal Entry Date.
If the Journal Entry contains 16 lines, the 'Post Date' value must be copied to all 16 rows."
11
In the column named "Expense_Account_Code (Account)" fill out the Account Number as displayed on the Chart of Accounts.
The Account Number can be associated with any type of account; it is not limited to Expense type or detail types.
12
In the columns named "Debits" and "Credits" fill out the Amount needed to adjust the account balances
A **Normal Balance** means the side (Debit or Credit) where **increases** are recorded for that account type:\ \ **Account Type --> Normal Balance**\ Assets --> Debit\ Expenses --> Debit\ Liabilities --> Credit\ Equity -- > Credit\ Income -- > Credit\ \ To **reduce** the balance of an account, apply an entry on the side opposite its normal balance.
13
In the column named "Description" fill out the cells with the desired text. Descriptions can be added on a per-line basis.
14
In the column named "Location_Desc (Class)" fill out the cells with the desired Class.
Classes can be assigned on a per-line basis. Use the Class name exactly as it appears, whether it is a parent or subclass.
15
In Cell "K2" under the column named "Doc_Number" fill out the desired reference number for the "Journal No. field.
Once all the desired information has been entered into the template, it can be saved. If any information is missing, it can be added later on the Journal Entry screen after the file is uploaded.
Upload the Data File
16
Back in the BE Accounting screen, click the "Import Data File" button.
17
Click the "Browse" button and locate the file.
18
Click "Upload"
19
The Journal Entry will populate with the information on the template.
20
Click the "Save" button.
21
Click "OK"
