/
JV Upload Instructions

JV Upload Instructions

Owned by Hsu, Suzanne
Last updated: Apr 18, 2024 by Freeman, Justin
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
image-20240314-180637.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.

image-20240314-181050.png
image-20240314-181207.png
image-20240314-181353.png

Step 4: Banner upload (1/2) - upload the csv file to banner system.

image-20240314-181506.png
Search for “File Upload” in Banner Screen
image-20240314-181512.png
Click on “Manual File Upload” and Another page will pop up.
image-20240314-181940.png
Select “Finance” and click on “Continue”
image-20240314-181529.png
Choose the CSV file saved and click “Submit File”
image-20240314-181605.png
The upload success message will appears. Copy the file name without the quotations. It will be used in the next step.

Step 5: Banner upload (2/2) - Assigning the document to the posting queue.

image-20240314-182549.png
image-20240314-182559.png
Line1:paste the csv file name
Line 2: Enter a ref code (8 character Max)
Line 3: the date which the JV is posting to
Click on a box in the “Submission” area and click “Save”

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

image-20240314-182620.png

If there is an error in the upload, the notification would display lines that contain errors. See Example Below.

image-20240314-190946.png
image-20240314-190953.png

Step 6: Forward the notification along with the JV to generalledger@spu.edu.

image-20240314-182628.png

 

Related content