Importing a Journal Entry Copied!
Purpose: Import a journal entry from the Journal Entries tab home page by uploading an .xlsx or .csv file.
- Click the dropdown option next to Create and select Import Journal Entry.
- A window will open where you will select the desired entity and then select the desired subsidiary (NetSuite example). After making those selections you’ll need to upload the .xlsx or .csv file.
- FloQast provides you with a template to download to ensure the required column headers are included on Sheet 1. The following are required column headers:
- Memo
- Transaction Date
- Account
- Debit
- Credit
- After uploading your file, FloQast will review it for any errors. If all looks good, you’ll then be able to import your journal entry, review the entry in FloQast and submit as needed.
Additional Notes Copied!
- Columns can be listed in any order.
- Ensure everything is spelled the same as how it looks in the JEM dropdown fields when creating an entry. For example, if your account name includes parentheses, you would want to include those parentheses on this template as well.
- The template can also include additional tabs for any supporting documentation. The journal entry just needs to be the first tab in the workbook.