Report Title: Accrual

Category: AP

Available to: All users

Pricing Package: Basic


Overview

The Accrual Report returns Invoices that have not been exported as of a certain date but should hit the relevant period


For users running accrual-based accounting, the Accrual Report will be especially helpful when trying to gather invoices that may (a) hit the fiscal period of interest, and (b) have not yet been exported to their accounting system.


Dashboard View




Filters


FilterMeaning
GroupGroup of locations to run the report on.  To run the report on all location, leave this blank.
LocationTo run a report for a single location, select the location's Group, and choose the location from the dropdown.
Invoice Date RangeA date must be selected, so either choose a pre-filled Date Range including today's date, yesterday, the last 7 days, month to date, last 30 days, last 3 months, last 1 year, or a custom Date Range.
Invoice DateMandatory date field that is pre-populated if a Date Range is selected, or can be manually populated by entering a start and end date.  These dates are inclusive, meaning 06/01/19 will return data from June 1st as well.
After Export DateIf chosen, the report will include only invoices that (1) have not been exported yet, and (2) were not exported after the given "After Export Date."  This is commonly used for historical accruals.
VendorTo view un-accrued invoices from a particular vendor
EmailPre-populated with the user's email address.  Additional emails can be included by appending other comma-separated emails.


Data


ColumnMeaning
LocationLocation specified on the invoice
Department/StoreIf relevant, this is the department code / company code specified on the invoice
VendorVendor, as it's read on the invoice
Invoice NumberInvoice number, as it's read on the invoice
Invoice DateInvoice date, as it's read on the invoice
Posting DateEither the Posting Date as it's specified on the invoice, or the Invoice Date if Posting Date is blank.
AccountGL Account Split summary of of the specified invoice
AmountSum of the spend for the above GL Account
Approved StatusApproved status determined by approval state in Plate IQ.
ApproverUser who approved
MemoMemo added to invoice (if applicable)
Issue(If the invoice was flagged)



Sample