JV Upload Instructions

Owned by Suzanne Hsu
Last updated: Apr 18, 2024 by Justin Freeman
3 min read

Forms:

Step 1: Filling out the JV form (Data entry in Green cells only)

image-20240314-175005.png

*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

image-20240314-180503.png

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.