⌂ All reports
Wicks — Inventory Unit Cost Analysis
Wicks General Info
Wicks - Project Hygiene
MEC - Project Hygiene
Wicks - Vendor Bill Reconciliation
MEC - Vendor Bill Reconciliation
Wicks - AR Reconciliation
MEC - AR Reconciliation
Sign out
Wicks — Vendor Bill Reconciliation
Upload any vendor's invoice list, map its columns once, and check each bill against Wicks' ServiceTitan and Acumatica bills.
1. Vendor name
Start typing, then pick from the list.
2. Vendor invoice file (.xlsx, .xls, .csv)
Any layout works. You'll map the columns below.
Run reconciliation
X
Export to Excel
Vendor name in ServiceTitan
Vendor name in Acumatica
The two systems sometimes name a vendor differently. Best guesses are filled in, and your picks are remembered for next time.
Loading ServiceTitan and Acumatica bills...
3. Map the vendor's columns
Pick which column holds each field. Best guesses are filled in. Check the preview, then save the mapping so this vendor runs automatically next time.
Save mapping for this vendor
Header row
The row with the column titles.
Preview
Vendor file vs. ServiceTitan & Acumatica
Matches are shown regardless of bill status.
X
Export to Excel
Open in ServiceTitan – not on vendor file
Status Unreconciled or Discrepancy, not canceled.
Open in Acumatica – not on vendor file
Status Open, On Hold, Balanced or Scheduled.