/
JV Upload Instructions

JV Upload Instructions

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.

 

Related content

General Ledger Transactions
General Ledger Transactions
Read with this
General Accounting Forms
General Accounting Forms
Read with this
Fixed Asset Policy
Fixed Asset Policy
Read with this
Unrelated Business Income
Unrelated Business Income
Read with this
Tax
Read with this
Fixed Asset Procedures
Fixed Asset Procedures
Read with this