Audience: Accounting Manager, Read-Only Accounting Manager, Payment Authorizer
Summary: Use invoice and purchase order reports to track invoice status, review line-level coding, and monitor purchase order activity.
Overview
Invoice and purchase order reports show what is open, what has been paid, and how invoices were coded to your general ledger.
Available reports and columns may vary based on your ERP integration. Your ERP is the accounting system connected to MineralTree, such as NetSuite or QuickBooks.
Which invoice report should I use?
| If you need to... | Use... |
|---|---|
| Review invoices that are open or still in draft | Open Invoices |
| Review line-level coding for an unpaid invoice | Bill Detail |
| Connect a paid invoice’s line-level coding to its payment | Bill Payment Detail |
| Review payment information for a paid invoice without line-level coding | Bill Payment Report |
| Compare ordered and remaining purchase order amounts or quantities | All Purchase Orders |
| Investigate invoices that failed to sync with your ERP | Invoice Sync Failures |
| Review document capture volume by month | Monthly Invoice Capture |
Open Invoices
The Open Invoices report includes invoices that are open or in draft status.
Use this report to:
- Monitor outstanding balances
- Review approval progress
- Identify invoices that may need attention
- Review due dates and accounting periods
Columns included
Identifiers
- MineralTree ID
- Accounting System ID
- Invoice Number
Vendor
- Vendor
- Subsidiary Name
Amounts
- Original Amount
- Remaining Amount
Dates
- Invoice Date
- Due Date
- GL Posting Date
- Created
Status
- Invoice Status
- Invoice Approval Status
- Accounting Period
- Creation Source
People
- Submitter
- Approver
Bill Detail
The Bill Detail report provides line-level information for unpaid invoices.
Use this report to review:
- Invoice coding
- Expense details
- Item details
- Purchase order information
- Approval activity
- Invoice and expense memos
Columns included
Invoice information
- MineralTree ID
- Vendor Name
- Vendor ID
- Invoice Number
- Invoice Date
- Due Date
- Accounting Period
- PO Number
- Vendor Category
Approval
- Invoice Status
- Invoice Approval Status
- Approved By
- Rejected By
- Awaiting Approval From
Memos
- Invoice Memo
- Expense Memo
General ledger coding
- Line Number
- GL Code/Account, Expenses
- GL Code/Account, Items
- Item Name
- Item ID
Dimensions
Each available dimension may include its name and ID.
- Location
- Department
- Class
- Project
- Customer/Job
Amounts
- Expense Amount
- Total Bill Amount
- Remaining Bill Amount
Dates
- Created Date
Bill Payment Detail
The Bill Payment Detail report combines paid invoice information with line-level coding details.
Use this report to connect how an invoice was coded to its payment.
Columns included
Invoice information
- MineralTree ID
- Vendor Name
- Vendor ID
- Invoice Number
- Invoice Date
- Due Date
Amounts
- Total Bill Amount
- Remaining Bill Amount
- Bill Payment Amount
- Expense Amount
Payment
- Payment Date
Approval
- Invoice Approval Status
- Approved
- Rejected
- Awaiting
Memos
- Invoice Memo
- Expense Memo
General ledger coding
- Line Number
- GL Account or Item Name/ID
Dimensions
Each available dimension may include its name and ID.
- Location
- Department
- Class
- Project
- Customer/Job
Dates
- Created Date
Bill Payment Report
The Bill Payment Report includes paid invoices and their related payment information.
Use this report to:
- Confirm how or when an invoice was paid
- Research vendor payment questions
- Review payment history
- Review payment status and payment method
Requires: Start and end date
Columns included
Invoice information
- Name
- Vendor
- Subsidiary Name
- Print on Check Name
- Invoice Number
- Invoice Amount
- Vendor ID
- Invoice External ID
Payment
- Payment ID
- Payment Amount
- Payment Status
- Payment Date
- Payment Submitted
- Payment Type
- Payment Number
- Payment Document Name
- Account
- Paid From
Approval
- Payment Approver
Terms
- Discount Applied
- Terms
All Purchase Orders
The All Purchase Orders report provides an overview of purchase order activity.
Use this report to:
- Compare ordered and remaining amounts
- Compare ordered and remaining quantities
- Review purchase order status
- See which invoices are associated with a purchase order
Requires: Your ERP integration must support purchase orders.
Columns included
Identifiers
- PO Number
- PO Status
- Associated Invoices
- Vendor
Amounts and quantities
- PO Total Amount
- PO Amount Remaining
- PO Total Quantity
- PO Quantity Remaining
- PO Currency
Invoice Sync Failures
The Invoice Sync Failures report identifies invoices that failed to sync with your ERP.
Use this report to find affected invoices, review the error, and correct the issue before the next sync attempt.
Columns included
Identifiers
- Vendor Name
- Invoice Number
Amounts
- Invoice Amount
Dates
- Invoice Date
- Due Date
Status and error information
- Invoice Status
- Sync Details
- Original Error Message
- Error Explanation
Monthly Invoice Capture
The Monthly Invoice Capture report summarizes the number of documents captured each month.
Use this report to monitor invoice volume and track adoption over time.
Columns included
- Month
- Year
- Captured Documents