Use ERP Purchase Order Functionality to Support the GL Period Close

An organized and controlled GL period close is essential to the completion of accurate financial statements. Learn more today!

Table of Content

    An organized and controlled GL period close is essential to the completion of accurate financial statements. Accurate statements are critical in expense control analysis and support informed financial decisions.

    To ensure financial statement accuracy and that all transactions related to the period being closed are included, the applicable departments (including purchasing) follow a pre-planned period closing procedure to ensure that all transaction activity related to the reporting period, is identified and recorded accurately.

    To learn more about the GL period close process see: Financial Management: Accounting Period Close

    Revenue and expense matching is an important accounting principle. The matching principle requires a company to report an expense on its income statement, in the same period as the related revenues. This requirement makes purchasing a key part of the GL closing process, as an open purchase order (PO) and receiving review will identify purchase commitments made in the period, which haven’t yet been invoiced by the vendor or processed in accounts payable.

    It’s very important to be sure that the PO and receiving review has been completed before closing the period. Purchasing and warehouse team members review all open purchase orders and receipts not yet entered into the ERP related to the period being closed. A list is provided to accounting so that they can accrue the PO and receiving data using the GL reversing journal entry function.

    Additionally, as a part of the period GL close the accountant and department manager meet to review department expense transactions (processed and expected) prior to generating financial statements. These meetings help to identify expense-related transactions which need to be included. Many times, a non-PO required service has been completed or a physical item delivered, for which a vendor invoice has not yet been received.

    The department manager provides this information to the accountant who then determines if the transaction should be accrued.

    If you’d like to learn more about this topic, see: How to Control Expense and Support Manager Accountability

    Functionality, Measures and Alerts

    Measures and alerts are meant to assist the user in keeping abreast of processing status, identifying anomalies, and ensuring that implemented process controls are being effectively employed. The information below illustrates the interaction between PO and warehouse receiving functionality, measures and alerts.

    Functionality- ERP GL, purchase order and receiving period controls.

    Measures and Alerts- Open PO’s or receiving transactions processed in a prior or future period.

    Today, all ERPs support a multi-period processing functionality. This means that with proper permissions assigned the user can process transactions in a prior, current or future period. This functionality should be tightly controlled. If not used properly, it can have a negative impact on financial reporting.

    Reviewing PO and receiving transactions posted to a period other than the period being closed, is an important control to ensure that all related transactions are processed correctly. The purchasing and warehouse managers review this alert and address any issues identified.

    Functionality- ERP open purchase orders

    Measures and Alerts- Open approved POs not closed or partially received at period end.

    When a purchase order is entered into the ERP, it remains as a pending PO until approved by purchasing. Once the PO is approved it becomes an open PO and represents a purchase commitment that should be accrued in the appropriate period. Also, when PO’s have been partially received, the balance of the PO should be accrued until the PO has been completely received or closed by purchasing.

    The purchasing manager reviews all open PO alerts, resolves any issues and communicates any accruals required to the accountant for processing.

    Functionality- ERP GL journal entry processing

    Measures and Alerts- Prior period PO and receiving accruals not reversed or posted in the current period.

    Reversing GL entry is usually a two-step process. While the ERP auto-creates the reversing entry, the entry itself usually needs to be reviewed and posted. This task is completed by the accounting department as a part of their period closing account analysis. Not posting reversing accrual entries will cause the ERP to duplicate the transaction when it is processed and posted.

    The accountant reviews this alert and addresses any issues.

    Process Implementation Best Practices

    Successfully implementing a new process isn’t always easy. Consider the best practices below to streamline and control new process implementations.

    Understand the Process

    • Be sure that all purchasing, and warehouse team members involved in the period close understand the closing tasks that apply to the purchasing and receiving departments.
    • Review the accounting period close schedule and be sure that the department managers understand the timing of their tasks to be completed.
    • Review the ability of the ERP to process transactions in multiple periods (e.g., current, prior) with the purchasing and warehouse managers and assign the proper system permissions if warranted.
    • If multiple period processing permissions are not provisioned to the purchasing and/or warehouse manager, review the accounting communication process related to accounting period control.

    Align Resources

    • Assign specific PO and receipts closing tasks to specific purchasing and warehouse team members. Include staffing to support out of office coverage.
    • Be sure that any company executives included in PO transaction review and approval processes are aware of their responsibilities and tasks required. (e.g., communicating PO required purchases made without a PO being completed).
    • Assign measures and alerts review tasks to the applicable purchasing, warehouse or accounting team members.

    Improve the Process

    • Be sure to build realistic purchase order requirement levels. You don’t need to do a PO for every purchase transaction. Be sure to document how to process non-PO related invoice handling and approvals.
    • Use ERP tools, measures and alerts to assist in identifying and resolving any processing issues. Resolve any issues identified as soon as possible.
    • If the volume warrants, use technology such as warehouse receipts scanning and entry and PO routing and approval workflows.
    • For more basic processing needs use tools such as receiving spreadsheets and e-mail templates for PO approval documentation. Stay away from manually prepared documents when possible.
    • When hiring new purchasing and warehouse team members, be sure to include PO processing, warehouse receipts entry and accrual process training as a part of their onboarding if required. If the team member(s) are at a manager level, include any additional task training. Assign a temporary mentor from purchasing, warehouse and accounting (if needed) to ensure that training happens.

    Common System Permissions

    System permissions and security functionality play a vital role in any ERP process. Using these ERP tools allows the user to set up efficient and controlled processes. common system permissions

    Common PO and receiving period close functionality, measures and alerts examples are displayed in the tables below:

    Use ERP purchase order functionality to support the GL period close to ensure expense reporting accuracy.

    Conclusion

    An organized and controlled GL period close is essential to the completion of accurate financial statements. Accurate statements are critical in expense control analysis and support informed financial decisions.

    Purchasing plays, a key role in the period close process. PO closing controls such as processing cutoffs, transaction review and correction, and posting or accruing open POs and receiving transactions, when required, are key in supporting period close success.

    Use the functionality, best practices, measures and alerts described here to assist in the completion of a timely close and generation of quality financial reporting.

    Process Flow

    Use ERP purchase order functionality to support the GL period close to ensure expense reporting accuracy.

     

     

     

     


    Enterprise Resource Planning (ERP)
    Conference
    The MedTech Conference
    October 9-11
    Learn More
    AXIO for Dynamics 365 FinanceDistributionDynamics 365 Business CentralDynamics 365 ERPDynamics 365 Finance and OperationsEnterprise Resource Planning (ERP)
    Conference
    Dynamic Communities Summit ’23
    October 15-20, 2023
    Learn More
    Advanced Projects for D365 Business CentralAgribusinessAnalytics, Business Intelligence & WorkflowsAXIO Advanced ProjectsAXIO for Dynamics 365 FinanceBusiness ProductivityCloudCommercial HVACData FabricDealer ManagementDistributionDynamics 365 Business CentralDynamics 365 Customer Engagement & Dynamics CRMDynamics 365 ERPDynamics 365 Finance and OperationsDynamics AXDynamics GPDynamics NAVDynamics SLEnterprise Resource Planning (ERP)Field ServiceGenerative AIIndustry InsightsMarketing AutomationMicrosoft (Office) 365Microsoft CopilotNon-ProfitOn-Premises DynamicsPower AppsPower AutomatePower BIPower PlatformProject Centric BusinessProject Service AutomationRansomware & CybersecurityRestaurant Equipment DistributionSharePoint