MENU
    AP Accrual
    • 04 Jul 2024
    • 2 Minutes to read
    • Dark
    • PDF

    AP Accrual

    • Dark
    • PDF

    Article summary

    The Accounts Payable Accrual report is used to gather the information entered regarding the Dates of Service for an expense and summarize it at month end so a journal entry can be recorded.

    Click here for more information on Dates of Service entered in an AP Invoice Form.


    To navigate to the AP Accrual report, click 'My Reports' under 'Reports' in the left pane and select 'Financial' in the top header of the reporting window. Once opened, a listing of reports will be shown. 

    Find 'AP Accrual' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define your report.


    Report Parameters

    1. Filter By - A listing of all Location categories

    2. Filter - A listing of all Locations within the selected Location category

    3. GL Start Date - The beginning date for when invoices were posted to the General Ledger

    4. GL End Date - The end date for when invoices were posted to the General Ledger

    5. Date Created Start - The beginning date for when invoices were created

    6. Date Created End - The end date for when invoices were created

    7. Document Start - The beginning date for the Document Start Date listed on invoices 

    8. Document End - The end date for the Document End Date listed on invoices

    9. Start Date of Service - From - The beginning date for the Start Date of Service range assessed in invoices

    10. Start Date of Service - To -The end date for the Start Date of Service range assessed in invoices

    11. End Date of Service - From - The beginning date for the End Date of Service range assessed in invoices

    12. End Date of Service - To - The end date for the End Date of Service range assessed in invoices

    13. Unapproved - This option either shows or hides Unapproved invoices

    14. Account - A listing of all GL Accounts

    15. Subtotal By Account - This option will either show a summarized or expanded version of the report

    16. Run Button - Runs the report

    Click here to learn more about Report Views and their added functionality.


    Report Columns

    1. Document Date - The date listed on the AP transaction

    2. GL Date - The GL Date listed on the AP transaction

    3. Start Date - The Start Date of Service listed in the transaction details

    4. End Date - The End Date of Service listed in the transaction details

    5. Date Created - The date the AP transaction was created

    6. Vendor Nbr - The Vendor number, if any noted on the Vendor record

    7. Vendor Name - The name of the Vendor associated with the transaction

    8. Document Number - The number associated with the transaction. This is hyperlinked to its transaction

    9. Type - The type of transaction (AP Invoice or AP Credit Memo)

    10. Account Nbr - The GL Account number on the Distribution tab of the transaction

    11. Account Name - The GL Account name on the Distribution tab of the transaction

    12. Location Number - The number associated with the Location

    13. Location Name - The Location name on the Distribution tab of the transaction

    14. Amount - The amount listed on the transaction

    15. Service Days - The total number of Service Days based on the Start Date and End Date entered on the Distribution line

    16. Amount Per Day - The Amount (#14) divided by the number of Service Days (#15)

    17. Prior Period Amt - The number of Service Days in the fiscal period(s) prior to the GL Date multiplied by the Service Days (#15)

    18. Current Period Amt - The number of Service Days in the same fiscal period(s) as the GL Date multiplied by the Service Days (#15)

    19. Future Period Amt - The number of Service Days in the fiscal period(s) after the GL Date multiplied by the Service Days (#15)


    Email, Export, or Print the Report

    This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.


    Was this article helpful?