JV Upload Instructions
- Hsu, Suzanne
- Freeman, Justin
Forms:
Step 1: Filling out the JV form (Data entry in Green cells only)
*When you add/delete rows in the [JOURNAL VOUCHER], make sure the formulas for columns not shaded in Green are copied down. Check that the formulas in [UPLOAD DATA] tab is picking up the data correctly. See example of error below
Step 2: Save the Document.
Step 3: Click on the [UPLOADDATA] tab Nd save it in Comma Delimited Form (CSV).
*Do not have spaces when naming the CSV file.
Step 4: Banner upload (1/2) - upload the csv file to banner system.
Step 5: Banner upload (2/2) - Assigning the document to the posting queue.
You will then receive a notification in your email with the upload details. See Example Below.
Doc code: 101336
Transaction Date: 31-Mar-2024
Total Debits & Credit: 500, 1000
If there is an error in the upload, the notification would display lines that contain errors. See Example Below.
Step 6: Forward the notification along with the JV to generalledger@spu.edu.