1.Account Event Mapping
Accounting event mapping provides the base connection mappings between PACS 9.0 Treasurer functions and your office’s financial management system.
Several processes utilize this mapping:
- Distribution
- Tax district disbursement
- Refund disbursement
- Import from AP
2.Mapping Credit Card Events
Purpose
Use this procedure to map credit card events per credit card type. This mapping only interacts with the distribution process.
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > Setup Event Mapping
Procedure
- In PACS 9.0, choose Activities > Accounting > Accounting Event Mapping.
- In the Accounting Event Mapping dialog box, select a year. Then in the Credit Card Types section, select a row and click Distribution Details.
- In the Collection panel, map accounts to the payment process by doing the following:
- Select the Enable Credit Card Event Mapping check box to include credit card fees in the distribution process.
- To add a new row click Add.
- Complete the following options as required:
- Event
- Action
- Account Number
- Primary
- Type
- Description
- Click OK or Apply.
3.Mapping Escrow Events
Purpose
Use this procedure to map escrow type events to accounts for the distribution process.
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > Setup Event Mapping
Procedure
- In PACS 9.0, choose Activities > Accounting > Accounting Event Mapping.
- In the Accounting Event Mapping dialog box, select a year. Then in the Escrow Types section, select a row and click Distribution Details.
- In the Escrow Type dialog box, map accounts to the payment process by doing the following:
- To add a new row click Add.
- Complete the following options as required:
- Event
- Action
- Account Number
- Primary
- Type
- Description
- Use the following options as required:
- To open the change log for the selected type, agency and tax district combination, click Change Log. For more information, see Reviewing Event Mapping Changes
- To run the validate event mapping process, click Validate. For more information, see Validating Event Mapping.
- To add a debit and credit row for every event code available for each panel, click Add All.
- Click OK or Apply.
4.Mapping Fee Type Events
Purpose
Use this procedure to map fee types to accounts for distributions, disbursements, and refunds.
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > Setup Event Mapping
Procedure
- In PACS 9.0, choose Activities > Accounting > Accounting Event Mapping.
- In the Accounting Event Mapping dialog box, select a year. Then in the Fee Types section, select a row and click Distribution Details.
- In the Collection/Distribution panel of the Fee Type dialog box, map accounts to the payment process by doing the following:
- To add a new row click Add.
- Complete the following options as required:
- Event
- Action
- Account Number
- Primary
- Type
- Description
- In the Refunds panel, map accounts to refund process by doing the following:
- To add a new row click Add.
- Complete the table using the fields noted above.
- Use the following options as required:
- To open the change log for the selected type, agency and tax district combination, click Change Log. For more information, see Reviewing Event Mapping Changes.
- To run the validate event mapping process, click Validate. For more information, see Validating Event Mapping.
- To add a debit and credit row for every event code available for each panel, click Add All.
- Click OK or Apply.
5.Mapping Overpayment Credit Events
Purpose
Use this procedure to map overpayment credit for the distribution process. This mapping is effective across the system.
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > Overpayment Credit Event Mapping
Procedure
- In PACS 9.0, choose Activities > Accounting > Accounting Event Mapping.
- In the Accounting Event Mapping dialog box, select a year. Then in the Overpayment Credit sections select the row and click Distribution Details.
- Complete the following options as required:
- Event
- Action
- Account Number
- Primary
- Type
- Description
- In the Refunds panel, do the following:
- To add a new refund, click Add.
- Complete the table using the fields noted above.
- Use the following options as required:
- To open the change log for the selected type, agency and tax district combination, click Change Log. For more information, see Reviewing Event Mapping Changes
- To run the validate event mapping process, click Validate. For more information, see Validating Event Mapping
- To add a debit and credit row for every event code available for each panel, click Add All.
- Click OK or Apply.
6.Mapping REET Events
Purpose
Use this procedure to map real estate excise tax (REET) events at the REET rate level for tax districts. You can specify an accounting event for receipt of payment and for receipt of interest so that interest and payments can go to different funds.
If a UGA code that is not event mapped for interest is entered on a property record (in the Identification panel), default event mapping for the None UGA indicator is used.
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > Setup Event Mapping
Procedure
- In PACS 9.0, choose Activities > Accounting > Accounting Event Mapping.
- In the Accounting Event Mapping dialog box, select a year. Then, in the REET section, expand a REET rate row and double-click one of the following options:
Payment Receipt
,Interest Receipt
,Penalty Receipt
. - In the Real Estate Excise Tax Rates – Taxing District dialog box, set up the event mapping for the REET rate by using the following options as required:
- To add a UGA indicator, click Add. Then complete or review the following columns of the table for the required debit and credit:
- UGA Code
- Description
- Percent of Rate
- Account Number
- Type
- Account Description
- To add more accounts for a UGA indicator, click Add. To remove accounts, click Remove.
- To add a UGA indicator, click Add. Then complete or review the following columns of the table for the required debit and credit:
- Use the following options as required:
- To open the change log for the selected type, agency and tax district combination, click Change Log. For more information, see Reviewing Event Mapping Changes.
- To run the validate event mapping process, click Validate. For more information, see Validating Event Mapping.
- To add a debit and credit row for every event code available for each panel, click Add All.
- Click OK or Apply.
7.Mapping REET Global Events
Purpose
Use this procedure to map REET account receivable events, penalties, and interest to account numbers.
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > Setup Event Mapping
Procedure
- In PACS 9.0, choose Activities > Accounting > Accounting Event Mapping.
- In the Accounting Event Mapping dialog box, select a year. Then, in the REET Global Event Mapping section, double-click REET Global Event Mapping.
- In the REET Global Event Mapping dialog box, map events to accounts by doing the following:
- To add a new row, click Add.
- Complete the following options as required:
- Event
- Action
- Account Number
- Primary
- Type
- Description
- Use the following options as required:
- To open the change log for the selected type, agency and tax district combination, click Change Log. For more information, see Reviewing Event Mapping Changes.
- To run the validate event mapping process, click Validate. For more information, see Validating Event Mapping.
- To add a debit and credit row for every event code available for each panel, click Add All.
- Click OK or Apply.
8.Mapping Refund Type Events
Purpose
Use this procedure to map refund types to accounts.
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > Setup Event Mapping
Procedure
- In PACS 9.0, choose Activities > Accounting > Accounting Event Mapping.
- In the Accounting Event Mapping dialog box, select a year. Then, in the Refund Types section, select a row and click Distribution Details.
- In the Refund Type dialog box, map accounts to refund process by doing the following:
- To add a new row click Add.
- Complete the following options as required:
- Event
- Action
- Account Number
- Primary
- Type
- Description
- Use the following options as required:
- To open the change log for the selected type, agency and tax district combination, click Change Log. For more information, see Reviewing Event Mapping Changes
- To run the validate event mapping process, click Validate. For more information, see Validating Event Mapping
- To add a debit and credit row for every event code available for each panel, click Add All.
- Click OK.
9.Mapping Special Assessment Fund Events
Purpose
Use this procedure to map special assessment events to account numbers. Accounts can be mapped for distribution, disbursements, and refunds.
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > Setup Event Mapping
Procedure
- In PACS 9.0, choose Activities > Accounting > Accounting Event Mapping.
- In the Accounting Event Mapping dialog box, select a year. Then, in the Special Assessments section, select a row and click Distribution Details.
- In the Billing panel, map accounts to bill processes by doing the following:
- To add a new row click Add.
- Complete the following options as required:
- Event
- Action
- Account Number
- Primary
- Type
- Description
- In the Collection panel, map accounts to the payment process by doing the following:
- To add a new row click Add.
- Complete the table, using the fields noted above.
- In the Disbursements panel, map accounts to the disbursements process by doing the following:
Note There can only be one debit/credit pair for the AP-Billable event.
- To add a new row, click Add.
- If you need to use the balance of an account as the maximum that can be disbursed from this levy fund, select Disburse from and select the account.
- Complete the table, using the fields noted above.
- In the Refunds panel, map accounts to refund process by doing the following:
- To add a new row click Add.
- Complete the table, using the fields noted above.
- Use the following options as required:
- To open the change log for the selected type, agency and tax district combination, click Change Log. For more information, see Reviewing Event Mapping Changes
- To run the validate event mapping process, click Validate. For more information, see Validating Event Mapping
- To add a debit and credit row for every event code available for each panel, click Add All.
- Click OK or Apply.
10.Mapping Tax District Levy Fund Events
Purpose
Use this procedure to map levy fund events to account numbers. This process represents the different accounting buckets that the treasurer’s office tracks. Accounts can be mapped for distribution, disbursements, refunds, and real estate excise tax (REET).
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > Setup Event Mapping
Procedure
- In PACS 9.0, choose Activities > Accounting > Accounting Event Mapping.
- In the Accounting Event Mapping dialog box, select a year. Then, in the Tax District Levy Funds section, select a row and click Distribution Details.
- In the Billing panel of the Tax District Levy dialog box, map accounts to bill processes by doing the following:
- To add a new row click Add.
- Complete the following options as required:
- Event
- Action
- Account Number
- Primary
- Type
- Description
- In the Collection panel, map accounts to the payment process by doing the following:
- To add a new row click Add.
- Complete the table, using the fields noted above.
- In the Disbursements panel, map accounts to the disbursements process by doing the following:
Note There can only be one debit/credit pair for the AP-Billable event.
- To add a new row, click Add.
- If you need to use the balance of an account as the maximum that can be disbursed from this levy fund, select Disburse from and select the account.
- Complete the table, using the fields noted above.
- In the Refunds panel, map accounts to refund process by doing the following:
- To add a new row click Add.
- Complete the table, using the fields noted above.
- Use the following options as required:
- To open the change log for the selected type, agency and tax district combination, click Change Log. For more information, see Reviewing Event Mapping Changes
- To run the validate event mapping process, click Validate. For more information, see Validating Event Mapping
- To add a debit and credit row for every event code available for each panel, click Add All.
- Click OK or Apply.
11.Setting Up a Fund Number Event Mapping Template
Purpose
Use this procedure to set up a fund number event mapping that can be applied as a template to an existing fund on a selected levy.
This feature expedites the process of entering event mapping when a fund is used in multiple levies.
Procedure
- In PACS.ADMIN, choose Tools > Code File Maintenance > Fund > Fund Number.
- Select a fund number and click Edit.
- Select either
Current
orDelinquent
to map either current or delinquent event mappings. Then click Details. - In the Fund Number Event Mapping dialog box, enter a description for the mapping.
- In the Billing panel, map accounts to bill processes by doing the following:
- To add a new row click Add.
- Complete the following options as required:
- Event
- Action
- Account Number
- Primary
- Type
- Description
- In the Collection panel, map accounts to the payment process by doing the following:
- To add a new row click Add.
- Complete the table, using the fields noted above.
- In the Disbursements panel, map accounts to the disbursements process by doing the following:
Note There can only be one debit/credit pair for the AP-Billable event.
- To add a new row, click Add.
- If you need to use the balance of an account as the maximum that can be disbursed from this levy fund, select Disburse from and select the account.
- Complete the table, using the fields noted above.
- In the Refunds panel, map accounts to refund process by doing the following:
- To add a new row click Add.
- Complete the table, using the fields noted above.
- Use the following options as required:
- To open the change log for the selected type, agency and tax district combination, click Change Log. For more information, see Reviewing Event Mapping Changes.
- To run the validate event mapping process, click Validate. For more information, see Validating Event Mapping.
- To add a debit and credit row for every event code available for each panel, click Add All.
- Click OK or Apply.
12.Validating Event Mapping
Purpose
Use this procedure to validate the following:
- All events are mapped to an activated account.
- All debits and credits match.
- The vendor and vendor site are setup correctly for tax district levy funds, special assessments and refunds.
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > Validate Event Mapping
Procedure
- In PACS 9.0, choose Activities > Accounting > Validate Event Mapping.
- If the data is validation is successful, a message is displayed stating that validation has completed successfully.
- If validation fails, a message is displayed stating validation failed and a report dialog box is displayed from which you can print the validation report.
13.Copying Event Mappings: Tax District or Special Assessment
Purpose
Use this procedure to copy the entire set of event mapping for a tax district levy fund or special assessment from one year to another.
This process generally occurs after the new year has been created and before bills have been created.
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > Copy Event Mapping
Procedure
- In PACS 9.0, choose one of the following:
- For tax districts – Activities > Accounting > Copy Event Mapping – Tax District.
- For special assessments – Activities > Accounting > Copy Event Mapping – Special Assessments.
- In the Copy Account Event Mapping dialog box, complete the following fields:
- From Year
- To Year
- Review one of the following:
- For tax districts – The Tax District Levy Funds field lists the valid tax district levy funds.
- For special assessments – The Special Assessments field lists the valid special assessments.
- Use the following options as required:
- To add a tax district levy fund/special assessment event, click Add.
- To delete a tax district levy fund/special assessments event, click Delete.
- To add all the tax district levy fund/special assessment event in the system, click Add All.
- Click OK.
14.Copying Fund Event Mappings
Purpose
Use this procedure when setting up a new fund to copy the accounting event mapping of an existing fund to the new fund.
This feature can be useful, for example, when setting up funds for annexations.
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > Copy Event Mapping
Procedure
- In PACS 9.0, open a tax district record. In the Levies panel, select a levy and click Details.
- In the Fund Maintenance section of the Levy Data panel in the Tax District dialog box, select a fund and click Details.
- In the next Tax District dialog box, select Copy Event Mapping at the bottom of the dialog box.
- In the Copy Event Mapping dialog box, select one of the following options:
- Copy Event Mapping for Fund <number> – Use this option to copy either the current or delinquent event mapping of the selected fund by specifying either
Current
orDelinquent
. - Copy Event Mapping for the Selected Fund – Use this option to copy the event mapping of another fund by specifying a particular year, tax district, levy, and fund combination.
- Copy Event Mapping for Fund <number> – Use this option to copy either the current or delinquent event mapping of the selected fund by specifying either
- Click OK.
15.Reviewing Event Mapping Changes
Purpose
Use this procedure to track any changes to the event mapping tables.
Prerequisites
- In order to perform this procedure, the following user right is required:
- Event Mapping > View Event Mapping Change Log
Procedure
- In PACS 9.0, choose Activities > Accounting > Accounting Event Mapping. Then select an event mapping and click Change Log.
- Review the following fields:
- Date
- User
- Table
- Field
- Before Value
- After Value
- Click OK.