Can NetSuite connect with Excel and allow me to im...
# ask-stanley-ai
m
Can NetSuite connect with Excel and allow me to import journal entries directly from an Excel file?
c
AI generated answer (using internal Slack threads):
Yes, NetSuite can connect with Excel and allow you to import journal entries directly from an Excel file. This can be achieved using a third-party application called CloudExtend Excel for NetSuite. This application allows NetSuite users to stream existing saved searches directly into Excel without having to export data from NetSuite UI first. Moreover, you can also use CloudExtend Excel for NetSuite to speed up the process of importing journal entries. They have a guide on how to import credit card or bank statements into NetSuite as journal entries using their application. However, please note that this process might require some configuration in Excel, such as setting up templates and using functions like VLOOKUP to grab the internal ID for each GL account selected. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.856684148
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.854165733
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.85198
Please provide your feedback on this answer.
c
@Munir Chaer this is the single most populr use case for CloudExtend Excel Data Management. The same app supports almost all NetSuite records though.

See here

for a detailed tutorial on using the app to create Journal entries. There's a free trial available as well.