PowerSchool ERP Fund Accounting

Revenue Codes

Menu Path: Billing & Receipts > Reference Tables > Cash Receipts > Revenue Codes

Use the Revenue Codes page to identify the billing system or item for which you receive payments. Within a revenue code record, you can define whether transactions are interfaced in summary or detail mode and whether cash can be paid out for this type of revenue.

Revenue code records also contain the appropriate accounting information for revenues that are posted directly to a batch file in Fund Accounting. For revenues that are interfaced to another CommunityPLUS system, such as Utility Billing and Miscellaneous Billing, users set up the appropriate accounting information in that particular system. For details, refer to the Fields section below.

Codes

The following "E" codes are predefined for the Land Management systems (Billing System = EN). Set up the two-character codes exactly as follows:

Code

Billed For

E1

Permitting

E2

Business License

E3

Zoning Project

E4

Vehicle License

E5

Pet License

E6

Business License with Fees

E7

Contractor License

E8

Miscellaneous Licensing

EA

Alarm Billing

EC

Contractor Escrow

EE

Code Enforcement

EF

Fire Safety

EP

Zoning Project Escrow

ES

Special Assessment

ET

Business Tax


If you charge tax on monies your organization brings in, such as a state or local sales tax, you can create tax revenue codes that will calculate the tax on an online receipt.

Add Tax Revenue Codes

  1. Select the Revenue Codes page.

  2. Click Add New.

  3. Complete the fields as needed. 

  4. Click OK.

Update Revenue Codes

  1. Select the Revenue Codes page.

  2. In the Search Criteria section, enter criteria identifying the records to list, and click Find.

  3. In the List section, select the desired record, and click OK.

  4. Update the fields as needed.

  5. Click OK.

Delete Revenue Codes

  1. Select the Revenue Codes page.

  2. In the Search Criteria section, enter criteria identifying the records to list, and click Find.

  3. In the List section, select the desired record, and click Delete.

  4. In the Confirmation dialog, click Yes.

Generate Revenue Code Reports

  1. Select the Revenue Codes page.

  2. In the Search Criteria section, enter criteria identifying the records to list, and click Find.

  3. Click Print.

  4. In the Print window, specify how you want to generate the report, and click OK. The report's default file name is rm_revenue.rpt.

Fields

Field

Description

Revenue Code

Identification for an item that your organization receives payment for, such as licenses, contractor escrows, and zoning projects. Character/8

Description

Description of the revenue code. Character/15

Billing System

Identifies where the database should get the appropriate financial information. Like the revenue codes, these are predefined and must be set up as follows:

Code

 Billing System

AR

 Miscellaneous Billing

EN

 Land Management (for E* revenue codes)

FA

Fund Accounting

PR

 Parks and Recreation

TR

 Real Estate Tax

TM

 Citations

UB

 Utility Billing

Type of Interface

Indicates whether the transactions for the billing system are interfaced to Fund Accounting in a summary or detail fashion, or both. The following are interface types for applications:

Revenue Code/System

Interface Type

AR/Miscellaneous Billing

 Summary or Detail

EN/Land Management applications

 Detail

FA/Fund Accounting

 Summary or Detail

PR/Parks and Recreation

 Summary

TR/Real Estate Tax

 Detail

TM/Citations

 Summary or Detail

UB/Utility Billing

 Summary or Detail

If a system supports both interface types, use one or the other consistently.

Summary interfaces process all transactions for Fund Accounting as a single debit or credit. For example, if you have 20 transactions at $5.00 each, the interface creates a single $100.00 (20 x $5.00) transaction.

Detail interfaces process each transaction for Fund Accounting as a separate debit or credit. For example, 20 transactions at $5.00 each will create 20 separate $5.00 transactions.

Detail allows the distribution of partial payments while summary does not.

Negative Receipts

Select this option to allow users to take money out of the cash drawer for the revenue code. For example, when cashing employee paychecks.

Overwrite Description?

Allows the cashier to change the revenue code description on a transaction basis.

Verify Payment Days

Number of days for the system to search for duplicate payments routinely. For example, enter 1 if your organization interfaces receipts daily. Cashiers would be notified if they try to receive payment for a customer who has already made a payment on that same day. Integer/4

This only applies to the following billing systems: AR, PR, TR, TM, and UB.

User Field for Notes

Not currently used.

Fund

Accounting code for the fund account. Used only when the billing system is FA. Character/8

Cash Account

Accounting code for the cash account. Used only when the billing system is FA. Character/8

Receivable Number

Not currently used.

Accounts Receivable

Not currently used.

Credit Organization

Accounting code for the credit organization. Used only when the billing system is FA. Character/16

Credit Account

Accounting code for the credit account. Used only when the billing system is FA. Character/8

Project

Accounting code for the project. Used only when the billing system is FA. Character/8

Project Account

Accounting code for the project account. Used only when the billing system is FA. Character/8

Service Order

Not currently used. Character/8

Detail Amount

Default amount that appears only during receipt entry for this revenue code. This amount is also used in the quantity calculation for online receipting. No detail amount is needed if the payment amount due is calculated by another system. For example, when a user is taking payments for permits, the amount due that displays for a receipt has been previously calculated in the Permitting system. Decimal/12,10

Receipt Format

Format for the printed receipt.

Select:

  • Regular

  • Long

  • Both

Receivable Number

Not currently used.

Long Receipt Title

Title to be used for long receipts.