Skip To Main Content

Toggle Close Container

Triggers Container

Toggle Schools Canvas

Toggle Site Info Canvas

Mobile Translate

Mobile Main Nav

Mobile Utility

Header Holder

Header Right Column

Header Right Top

Toggle Schools Canvas

Toggle Site Info Canvas

English

Utility Nav - Desktop

Header Right Bottom

Toggle Search Canvas

Toggle Canvas Menu

Canvas Menus

District Canvas Menu

finder

school & Program

Site Info Canvas

spps

Get in Touch with

contact us

Saint Paul Public Schools, District 625
360 Colborne Street
Saint Paul
MN
55102

Telephone

Get In Touch Navigation

Search Canvas

Horizontal Nav

Breadcrumb

Recording Revenue in Activity Tracker

Recording Revenue in Activity Tracker

Who Completes This Task: Clerk

Process

Accounts Receivable staff use the Activity Tracker data to record deposits in PeopleSoft. The information provided determines whether revenue is taxable or non-taxable. Schools are encouraged to conduct fundraising activities through their PTA/PTO organizations which typically qualify for an exemption for taxable sales.

Criteria

  • After a deposit for the bank has been prepared
  • Checks, deposit slip and the Receipts to Deposit form have been scanned to pdf

Steps

  1. Open the site’s Activity Tracker in Google Sheets 
  2. Click on the Activity Detail tab
  3. For each source of revenue deposited, enter:
    1. Date the deposit was prepared
    2. Budget code
    3. A description, including the revenue source and if it was a taxable event
    4. Amount
    5. Category
  4. Verify the entry matches the deposit total
    1. Click the Deposit Summary tab
    2. Make any necessary changes in the Activity Detail tab
  5. Share the deposit pdf with Accounts Receivable staff
    1. Open your Google Drive
    2. Navigate to the folder the deposit pdf needs to be uploaded to
    3. Right-click anywhere in the folder, click Upload files...
    4. Locate the pdf of your scanned deposit on your hard drive and double-click it
    5. Once the pdf is uploaded, right-click on the file and click Share
    6. Share with the Accounts Receivable Accounting Clerk
    7. In Financial Activity Report, verify deposit to correct account prior to archiving records

Documentation Required 

  • Scanned checks
  • Deposit slip
  • Receipts to Deposit form

Why This Is Important

Related Topics

Preparing Deposit for Bank

Receiving Cash or Checks on Behalf of SPPS

Revenue Account Code Quick Guide