AP Accrual

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.

Navigation

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.