{"id":109248,"date":"2017-08-14T16:31:17","date_gmt":"2017-08-14T20:31:17","guid":{"rendered":"http:\/\/www.bu.edu\/tech\/?page_id=109248"},"modified":"2022-08-30T15:20:57","modified_gmt":"2022-08-30T19:20:57","slug":"buworks-cashier-upload-file","status":"publish","type":"page","link":"https:\/\/www.bu.edu\/tech\/support\/buworks\/help\/finance\/buworks-cashier-upload-file\/","title":{"rendered":"Cashier Upload File – BUworks"},"content":{"rendered":"

Last Updated 07\/20\/2018 <\/sub><\/p>\n

Cashier Upload File<\/h3>\n

The upload process imports the data into the general ledger system for workflow approval and posting.\u00a0 The necessary process change is due to the integration of the SAP BUworks<\/strong> system with the new Cashier Services system (NelNet<\/strong>).<\/p>\n

It provides an efficient streamline process for entering, approving and posting cashier entries in the University’s accounting system (BUworks WebGUI ECC<\/strong> system).<\/p>\n

The new process benefits both Administrators and Cashier Services by eliminating the use of Legacy accounting codes (ACK) and providing the user with the means to initiate and track deposits and or petty cash transactions entries.<\/strong><\/p>\n

\n

The Cashier Upload (Journal Entry) Process<\/h3>\n

The following sections describe the cashier upload process, review the instructions and template files, and talk about the required roles and the WebGUI ECC<\/strong> system transaction code (ZCashUpload<\/strong>) used to upload these entries.
\n<\/span><\/p>\n

<\/strong>

Cashier Upload Access, Template and Instructions - Step 1<\/h3>
<\/p>\n

Description<\/strong>:\u00a0 We will go over what roles are required and how to access the template and instructions to upload the cashier entries.\u00a0
Prerequisite:<\/strong>\u00a0 The cashier submitter decentralized (e.fi.cashier_submitter<\/strong>) <\/em>and department submitter decentralized roles (e.fi.department_submitter)<\/strong><\/em> are required to access the SAP<\/strong> transaction code ZCASHUPLOAD<\/strong>.<\/span><\/strong><\/p>\n

To request for these role(s), contact your Supervisor and DSA (Data Security Administrator).\u00a0 For more information on DSA go here; https:\/\/www.bu.edu\/tech\/support\/information-security\/docs\/dsaanddatatrustee\/. <\/a><\/p>\n

\n

Step 1<\/strong><\/span><\/h4>\n
    \n
  1. First, download the<\/span> Cashier Upload Template Instructions<\/a> and following the instructions<\/span>.<\/li>\n
  2. Next, select the appropriate template that resembles the type of Cashier upload transaction (i.e., CCV transaction type – Bank of America checks and cash deposit, Chase checks and cash deposit, Charles River Campus Petty Cash Replenishment, Metro Credit Union Deposit, Medical Campus Petty Cash Replenishment etc.)\u00a0 <\/span><\/li>\n
  3. Download the file by clicking on one of the Excel template links<\/a> below. \u00a0 <\/span><\/li>\n<\/ol>\n
    \n

    Step 1.1<\/span>\u00a0<\/strong> –\u00a0 Download the Cashier Upload Instructions.
    Click on this     link<\/a> to download instructions: Cashier Upload Template Instructions<\/a><\/span><\/p>\n

    \"FI.Cashier.FileInstruction\"

    A screen print of page 1 of instructions PDF document.<\/p><\/div>\n

    Step 1.2<\/strong>\u00a0<\/span> – Select the appropriate template to work on.\u00a0 Click on one of the cashier transaction templates links<\/a> below.
    Step 1.3<\/span>\u00a0<\/strong> – Downloaded the appropriate Cashier Upload Excel<\/em> file template.<\/p>\n

    Here are example Excel worksheet layouts templates to help you create and complete the process. <\/span><\/strong><\/p>\n

    <\/span>Charles River Campus<\/strong><\/p>\n

      \n
    1. Bank of America Deposit – Cash & Checks<\/a><\/li>\n
    2. Chase \u2013 Cash and Checks<\/a><\/li>\n
    3. Petty Cash Replenishment<\/a><\/li>\n<\/ol>\n

      Medical Campus<\/strong><\/p>\n

        \n
      1. Metro Credit Union Deposit<\/a><\/li>\n
      2. Petty Cash Replenishment<\/a><\/li>\n<\/ol>\n
        \n

        <\/span><\/span><\/em><\/span><\/span>Important Information:<\/strong><\/span><\/p>\n