Expense Reporting

Expense Reporting

Expense Analysis

Go to Expenses > Reporting > Expense Analysis. Pivot with:

• Dimensions: Employee, Department, Category, Project, Date.
• Measures: Total Amount, Untaxed Amount, Number of Expenses, Taxes.
• Filters: Date Range, Status (Approved, Submitted, Paid), Payment Method.

Key Insights

• Department spending by category (which dept spends most on travel?).
• Expense trends over time.
• Top categories by total spend.
• Reimbursement turnaround time (submission to payment).

Policy Compliance Checks

Use the analysis view to spot patterns that suggest policy issues: expenses consistently just under an approval threshold, missing receipts on high-value items, or one employee's spend trending well above their department's average — these are the things a periodic review should catch, not just individual expense approval.

Best Practices

• Require receipts for all expenses over a set threshold (e.g. $25).
• Use expense categories that match your accounting chart of accounts.
• Set up a corporate credit card journal for automatic reconciliation.
• Review expense policy quarterly.
• Reconcile the Expense Analysis total against what Accounting actually posted for the period — differences usually mean some approved sheets were never posted to journal entries.