There are a number of reports available to accounts payable users in the expense manager system.
- Expense report where line level data is required
- Claim status report where just claim totals and the status is required.
- Receipts report for duplicate attachments
- Activity code report to enable a PDF file to be generated containing all receipts or invoices allocated to an activity, job or project code.
- FBT report to enable a company live FBT insights to easily distinguish if a 50/50 or an actual FBT return will be most beneficial to the business.
To access the reporting section, sign into expense manager as a user with “payer” access. Then on the left hand side navigation menu select the desired report.
The expense report can be run across a wide range of criteria and any number of filters can be selected.
||A user can have restricted access to the expense report. See 'User Permissions'.
Once the filters have been selected, click the submit button at the bottom of the screen.
The transactions that match the search criteria are displayed for the user on screen. From here you can click on the blue headers at the top of the screen to sort the reports.
The reports are interactive with hyperlinks to allow you to easily navigate directly through to an expense or claim. You can also scroll to the bottom of the search results and export the transaction data to excel and CSV for further manipulation.
Claim Status Report
The claim status report allows payers to track the status of claims through the system. Payers can run this report across several criteria including the claim created date, claim type, status and user.
Once the report has been run the report results are displayed on screen. Fields included in this report include the claim ID (direct link to claim details) claim created date, claim description, claimants cost centre, claimants name, approvers details, claim status, claim type, value of the total claim, PO balance (only for purchase orders), linked PO (only for supplier invoices) along with the date the claim has been exported through to the finance system.
This report can also be exported into CSV and Excel for further manipulation.
The receipts report is used to easily view receipt images. This report can be run by a date range, and can also only show receipts attached to multiple expense transactions.
Once the date range is populated, and the report is run only receipts attached to multiple expenses are listed. This report displays the claim ID (hyperlinked) along with the claim name, expense ID (hyperlinked) claimants details, expense type, and claim status.
Activity Code Report
The activity code report is used to generate a PDF file with receipts matched to a project. The report can be run across a date range, by activity code, claim type, claimant, and claim status.
Once the report criteria is entered and the report is run, all relevant matches are displayed on screen. From here a payer has the option to deselect or exclude and receipts linked to a project that they do not wish to have included on the report. Once the selection has been made, a payer can chose to export the PDF and flag if receipts are to be included in the report.
The PDF file is then exported for manipulation and sharing outside of the expense manager system.
Where enabled a company can run our in built FBT report which analyses FBT data from within expense manager and simplifies the return process. The FBT Report can be run at any point in time across a number of criteria including a date range, status, category, cost centre, expense type (only FBT related expense types are available) and by claimant.
A gross up factor and tax rate is defaulted to the report. If a company is eligible to claim a minor benefit exception amount this can also be entered in the report criteria and excluded from the report.
Once the report is run all transaction that match the criteria are displayed on screen with a tax method comparison displayed on the top right. This comparison shows the amount of FBT payable where a company lodges an actual FBT return, 50/50 return and the difference between the two figures.
This report can also be exported into Excel and manipulated further from there.