Journal Spreadsheet Template
Purpose: Use this as a reference for instructions and links to download the Journal Spreadsheet JRNL1_WS, Journal MACRO, and GLLOG MACRO to access the journal spreadsheet or import template in ctcLink.
Audience: Finance Staff/Supervisors or end users who import journals into the General Ledger using the spreadsheet template, either as a “Write to File” or “Import Now”.
NOTE: Before you down load, please read the recommendations from the Application Services Team (below) as these files are easy to corrupt.
Instructions from Application Services
Please ensure to delete older versions of JRNL Spreadsheet and both MACROs before downloading this version. Upon downloading the files, save your files as directed by APP services from the above directions.
- When you download these three files, save them on your C drive (recommended) to a brand new folder ALL BY ITSELF. If you put these files in other folders you run a risk of file corruption. Also, the reason it's best to load in the C drive is so there are less levels of folders (once again, corruption).
- Upon creating a download import or spreadsheet, navigate to the Setup screen and change the path to Production. Copy and paste this path for Production: https://fsprd.ctclink.us:443/
- Save the files to a new folder on your C drive and do not rename them. Please use the name App Services provided to avoid file corruption.
- When you are ready to create your upload, select the JRNL1_WS file. Do not open the Journal Macro files to avoid file corruption.
- Verify with your local IT Security Team or LSA that you have the same password for PT-production and FS-production. Passwords must be in sync. Additionally, there may be some security settings that need to be adjusted if your files are being blocked.
- Please save the following three links in order to your C drive:
JOURNAL MACRO: From your File Explorer, right click on the MACROS file [JRNLMCRO_WS.xlam] below and scroll down to select Properties. On the General tab, select the Unblock box, you may have to select Apply, and then select OK.
GLLOG MACRO: From your File Explorer, right click on the MACROS file [GLLOG.XLT] below and scroll down to select Properties. On the General tab, select the Unblock box, you may have to select Apply, and then select OK.
EXCEL SPREADSHEET: Then right click on the main SPREADSHEET file [JRNL1_WS.xlsm] below and scroll down to select Properties. On the General tab, select the Unblock box, you may have to select Apply, and then select OK.
If you get a Security Risk warning, please select the Learn More link for more information and troubleshoot issues when downloading macros. For the direct link to Learn More, please see the Microsoft article.
Video Tutorial
The training video below demonstrates the process actions described in the steps listed above. There is audio included with this video. Select the play button to start the video.
Video Tutorial via Panopto
View the external link to Journal Spreadsheet Template: Download, Save, and Unblock. This link will open in a new tab/window.
Changing Spreadsheet or Import Options?
Please refer to the following QRGs to help with updating and/or changing settings:
QRG Importing a Journal Spreadsheet (Import Now)
QRG Uploading a Journal Spreadsheet as a Text File (Write to File)
0 Comments
Add your comment