You can import a journal entry from the Journal Entries tab home page.
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:
- 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 parenthesis, you would want to include those
parenthesis on this template as well. - Template can also include additional tabs as well for any supporting documentation, the
journal entry just needs to be the first tab in the workbook.