CloudExtend

A journal entry records debits and credits to be posted to general ledger accounts. Account values are thus adjusted without entering transactions such as invoices or bills.

The source data for a journal entry often comes from another system and is readily available in CSV or Excel format. Rather than key this information in manually or with a CSV import CloudExtend users save time by creating their journal entries directly from Excel.

In this video, we will show you how to manage Journal Entries via Excel using CloudExtend Excel Data Management for NetSuite.

___________________________________________________________

💡 Tip: It is best to check out the forms and fields and identify the header, column, and required fields in NetSuite that you may need to build the template.

If you are using NetSuite Classic Interface you can go to:

Transactions&gt;Financials&gt;Make Journal Entries

Line List: Memo (Optional only. Used for notes)

- TranId
- Trandate
- Memo
- Line List: Account
- Line List: Debit
- Line List: Credit
- Line List: Memo (Optional only. Used for notes)

To create one record, lines that have the same header values will be recognized as one record.

Step 1: Fill in the value for the memo and repeat the header values on the template for each line you wish to have on your Journal Entry. Trandate and Tran ID are automatically generated by NetSuite.

Step 2: Put in the line detail values. You can copy from one sheet to another or key in the account from the pick list value or type ahead on the cell.

Step 3: Send to NetSuite by clicking Upload to NetSuite and then Upload Records.

<a href="https://support.cloudextend.io/en/articles/6496775-manage-records-how-to-create-records-using-cloudextend#h_ee1e26210b">Creating a new entry based on an existing record from NetSuite</a>

- <a href="https://support.cloudextend.io/en/articles/6496775-manage-records-how-to-create-records-using-cloudextend#h_0f1288c758">Copy/paste data prepared from other systems</a>
- <a href="https://support.cloudextend.io/en/articles/6496775-manage-records-how-to-create-records-using-cloudextend#h_0f1288c758">Manually key in data using picklist to get the values from NetSuite</a>

- <a href="https://support.cloudextend.io/en/articles/6496775-manage-records-how-to-create-records-using-cloudextend#h_ee1e26210b">Creating a new entry based on an existing record from NetSuite</a>
- Creating One Record with multiple lines
 - <a href="https://support.cloudextend.io/en/articles/6496775-manage-records-how-to-create-records-using-cloudextend#h_0f1288c758">Copy/paste data prepared from other systems</a>
 - <a href="https://support.cloudextend.io/en/articles/6496775-manage-records-how-to-create-records-using-cloudextend#h_0f1288c758">Manually key in data using picklist to get the values from NetSuite</a>

<a href="https://support.cloudextend.io/en/articles/6496775-manage-records-how-to-create-records-using-cloudextend#h_f62b23171d">Using trandate field only</a>

<a href="https://support.cloudextend.io/en/articles/6496775-manage-records-how-to-create-records-using-cloudextend#h_249f2a3aa7">Using trandate and Memo</a>

- <a href="https://support.cloudextend.io/en/articles/6496775-manage-records-how-to-create-records-using-cloudextend#h_f62b23171d">Using trandate field only</a>
- <a href="https://support.cloudextend.io/en/articles/6496775-manage-records-how-to-create-records-using-cloudextend#h_249f2a3aa7">Using trandate and Memo</a>

If you wish to provide feedback on the beta app, click the button below! We love to hear from you!

Template Layout

Create Journal Entry

Different ways to create Journal Entries

Any Feedbacks?