Agency AR Deposit Spreadsheet Upload Processor
  • Dark
    Light
  • PDF

Agency AR Deposit Spreadsheet Upload Processor

  • Dark
    Light
  • PDF

Article summary

Role Description and Responsibilities

Agency AR Deposit Spreadsheet Upload Processor is the agency role responsible for uploading deposits. Role responsibilities include:

  • Creating and loading the ARI010 Inbound Deposit Spreadsheet Upload file.
  • Manage and resolve spreadsheet upload errors
  • Runs AR deposit reports
  • Views AR deposits and payments inquiry
  • View and review returned items and debit memos

Role Functions

The following table describes what the Agency AR Deposit Spreadsheet Upload Processor does in each related Business Process and related workflows. The table also describes the related Topic and Activity found on the Florida PALM Topics and Activities list.

Topic

Activity

Business Process

Related Workflow

Managing Direct Journal Deposits

Manually Creating Deposit and Accounting Entries

60.2.2 AR Deposits

N/A

Managing Direct Journal Deposits

Creating Deposit and Accounting Entries via Spreadsheet Upload

60.2.1 Direct Journal Deposits

ARW002

Managing Direct Journal Deposits

Reviewing and Reconciling Deposits

60.2.1 Direct Journal Deposits

N/A

Managing Direct Journal Deposits

Processing Deposits through Workflow

60.2.1 Direct Journal Deposits

N/A

Managing Direct Journal Deposits

Managing Exceptions

60.2.1 Direct Journal Deposits

ARW002

Managing Direct Journal DepositsSubmitting a Research Request/Reconciliation Assistance Form60.2.1 Direct Journal DepositsN/A

Managing AR Deposits

Manually Creating a Customer Payment

60.2.2 AR Deposits

N/A

Managing AR Deposits

Processing a Customer Overpayment60.2.2 AR DepositsN/A

Managing AR Deposits

Creating a Customer Payment by Spreadsheet Upload

60.2.2 AR Deposits

N/A

Managing AR Deposits

Reviewing and Reconciling Deposits

60.2.2 AR Deposits

N/A

Interface Error Handling Process

Manage and Resolve Spreadsheet Upload Errors

120.1.2 Spreadsheet Upload Error Handling

N/A

Interface Error Handling Process

Performing Interface Error Checking

120.1.2 Spreadsheet Upload Error Handling

N/A

Conflicts with Other Roles

The table below includes the roles that conflict with the Agency AR Deposit Spreadsheet Upload Processor, including separation of duty (SOD) conflicts and system enforced restrictions. If an agency identifies a SOD conflict that cannot be resolved, the agency must submit justification and compensating controls to Division of Accounting and Auditing (A&A) to request an exception. A&A will review the agency’s submitted request to determine if an exception will be granted.

End User Role

Type of Conflict

Reasoning

N/A

N/A

N/A

Learning Path

This table shows the available learning materials for each of the Topics and Activities this End User Role will be assigned.

Topic

Activity

Learning Material



Coming Soon

Other Information

This section includes additional information about this role’s relationships to other roles.

  • Agency AR Deposit Spreadsheet Upload Processors will also need the Agency AR Deposit Processor role to be able to update deposits online that were loaded form the Inbound AR Deposit Spreadsheet Upload file.

Version History

Date

Revision Description

05/19/2025

Original Version


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.