Release Notes 2025
Frequently Asked Questions!
How do I access field level help?
How do I see descriptions of codes in enquiry screens?
How do I make a user have read only access
Can I copy and delete lines in data entry screens?
Out of Office
Can I run a report to view security groups against my users?
How do I stop a user posting to prior and future periods?
Delete a payment run
Changing security access to a user
User setup requires multiple screens and is complicated!
De-allocate an AP Payment
How to stop over receipting of orders
Why has my transaction not appeared on the AP Payment run?
Download Templates
Useful information to include when raising Financials cases
Prevent users posting to specific balance classes
Hints and Tips!
General Ledger - Helpful how-to guides
General Ledger Data Entry
General Ledger Enquiries
GL Enquiries - Transaction Enquiries
GL Enquiries - Balance Sheet & Profit and Loss
GL Enquiries - Account Details
Trial Balance
Period and Year End Close
General Ledger Security
Accounts Payable - Helpful how-to guides
Accounts Payable Supplier File
Accounts Payable Data Entry
Log and Invoice/Credit note
Enter a logged Invoice
Enter a non order related Invoice
Order Related Invoice
Order Related Invoices with Mismatches
Order Related Invoice - Mismatch Scenarios
Mismatch Types
Invoice and Credit Note Matching
Accounts Payable Enquiries
Accounts Payable Transaction Maintenance
Accounts Payable Payment Processing
Accounts Payable Code Tables
Accounts Payable Reports
Accounts Receivable - Helpful how-to guides
Customer Maintenance
Enquiries
Cash Allocation
Data Entry & Contracts
Student Sponsor - Education sector
Credit Control
Credit Control Overview
Customer Statements
Diary Notes
Query Management
Interest Charges
Dunning Process
Credit Control Diary
Reporting within Financials
Student Sponsor - Education Sector
Purchasing Management - Helpful how-to guides
Fixed Assets - Helpful how-to guides
Prompt File - Asset Creation
Join Prompt File Items
Fixed Assets Period End & Depreciation
Revaluation
Disposals
Relife
Reconciliation process - Helpful how-to guides
Accounts Receivable Reconciliation Reporting
Accounts Payable Reconciliation Reporting
Daily Checks
Fixed Assets Reconciliation Reporting
General Ledger Reconciliation Reporting
Purchasing Management Reconciliation Reporting
Reporting
General Ledger Reports
Accounts Payable Reports
Accounts Receivable Reports
Sales Invoicing Reports
Fixed Assets Reports
Bank Reconciliation Reports
Import Tool Kit
Procurement Portal
Procurement Portal new User Interface
Navigation
Requisitions
Orders
Authorisation
Receiver
Invoice Clearance
Portal Administration
Procurement Portal - Teams Setup
Invoice Manager
Purchase Invoice Automation (PIA)
New User Interface
Release Notes 2024
December 2024
November 2024
October 2024
September 2024
August 2024
July 2024
June 2024 Release
May 2024
April 2024
March 2024
February 2024
January 2024
Release Notes - Previous years
December 2023
November 2023
October 2023
September 2023
August 2023
July 2023
June 2023
April 2023
February 2023
January 2023
November 2022
October 2022
September 2022
Collaborative Planning
Contents
- All categories
- Reconciliation process - Helpful how-to guides
- Accounts Payable Reconciliation Reporting
Accounts Payable Reconciliation Reporting
Updated
by Caroline Buckland
Accounts Payable Audit Reconciliation Procedures
Accounts Payable Procedure
Number | Description | Frequency | Action Required |
1 | AP Audit Checks Schedule: CLDAUREC | Daily | Access the Spool: Systems Admin>Spool. Enter RGM601 in the report field. AP Audit Transaction Summary – Update Control Report (RGM601) This report compares the audit totals (Total Accumulated) with the database balance on the Creditors system. · Ensure that Ledger balance carried forward and Ledger balance carried forward control agree. If an imbalance exists Accounts Payable>AP Processes>AP Data Entry>Review Batches · check AP Batch List (MGBA) for any ‘in error’ or ‘processing’ batches. If ‘in error’ batches exist ensure that batch transactions have not updated the supplier account and not been included on audit reports. Access the Spool: Systems Admin>Spool. Enter RGM201 and then RGM501 in the report field. Check AP Audit – Batch Summary Financial Audit - PL Report RGM201or for full batch details, report RGM501 AP Audit – Transaction Details for detailed. Access the Spool: Systems Admin>Spool. Enter RGM601 (AP Audit – Transaction Summary) in the report field. Recheck the AP Audit Summary– Update Control Report RGM601 to see if the previous imbalance appears on the Audit Totals. If there are discrepancies between the totals check the General Ledger - Account Payable reconciliation reports Access the Spool: Systems Admin>Spool. Enter RGQXXX in the report field. RGQF01 - AP-GL Reconciliation Control RGQF02 – AP – GL Sourced Mismatches RGQF03 – AP-GL Non Sourced mismatches to determine whether differences are due to transactions posted to the creditors control accounts via non-accounts payable transactions i.e. direct GL journals. |
Inter Ledger Reconciliation AP to GL | Daily | AP-GL Reconciliation Control Report (RGQF01) Access the Spool: Systems Admin>Spool. Enter RGQF01 in the report field. Check report RGQF01 to ensure no mismatches found. If only mismatches are equal to +/- 0.01 and mismatches greater than +/- 0.01 are zero, then mismatches can be assumed to be currency rounding differences and inter ledger reconciliation can be considered to be in balance If mismatches found then investigate as follows: 1) If AP (Accounts Payable) sourced mismatches in AP.
General Ledger>GL Enquiries>Transactions by Account Code Check that GL audit ED4 process was run as this would affect whether GL transactions were written to the inter ledger reconciliation files. Access the Spool: Systems Admin>Spool. Enter ED4 in the process field or enter schedule CLDAUREC in the schedule field. 2) If AP sourced mismatches in GL Check transaction details from PL-GL Sourced Mismatches Report (RGQF02). Enter RGQF02 in the report field Carry out on-line enquiries in AP to confirm that transaction has not posted to AP Supplier account. Accounts Payable>AP Enquiries, select any of the appropriate options to locate the transaction. Check that AP audit GM4 process was run as this would affect whether AP transactions were written to the inter ledger reconciliation files. Access the spool: Systems Admin>Spool enter GM4 in the process field. 3) If non-AP sourced mismatches in GL Check transaction details from AP-GL Non-Sourced Mismatches Report (RGQF03) Enter RGQF03 in the Report field. Carry out on-line enquiries in GL to AP control accounts to confirm that transactions were manually posted to GL via journals. General Ledger>GL Enquiries>Transactions by Account code (the source details will indicate which module the transactions where sourced (if source module is blank that = General Ledger) If manual postings to AP control accounts are discovered then users should be advised that this practice is not permitted. Security profile of the update user must be investigated to ensure range security prevents further postings to control accounts. | |
Confirmation of Reconciliation Tasks | Daily | 1) No imbalances exist All Audit and Reconciliation reports have been checked and that there are no imbalances. 2) Imbalances exist If imbalance cannot be explained
|