Accounting
Trimble Spectrum
Available
Reviewed CSV/XLSX file imports for master data, open AP/AR, opening balances and journals. No live API connection.
Available today through reviewed file import. Step-by-step instructions are in the product guide.
Coverage by service or edition
Reviewed file import. Each service needs its own permissions and acceptance checks.
Trimble Spectrum
Available
Reviewed CSV/XLSX file imports for master data, open AP/AR, opening balances and journals. No live API connection.
Before you start
Have these ready before you start.
- Authorized export layout and as-of date; Data Exchange entitlement separately.
- Confirm the destination company/project and the reviewer responsible for approving imported records.
Confirm the scope
Authorized export layout and as-of date; Data Exchange entitlement separately.
Agree the mapping
Vendor/job/document export columns → reviewed party/project/document mappings.
Preview and reconcile
Reconcile balances, currency, payments and retainage at one as-of date. Differences block approval; posted corrections use the accounting reversal or void workflow.
Review before applying
An authorized reviewer must confirm destination scope, unresolved records and control totals. A successful extraction is not proof that data has been applied.
Check recovery and access
Pause on expired or revoked access. Restore authorization before resuming from the last complete checkpoint. An incomplete list or permission error is not proof of deletion; inspect uncertain outcomes before retrying.
Mapping and synchronization
- Record mapping
Vendor/job/document export columns → reviewed party/project/document mappings.
- Sync boundary
- File preview and reconciliation first. Data Exchange must not reuse Vista schema/paging assumptions.
- Source ownership
- The provider remains authoritative for its source records. Local project placement, access and workflow decisions need explicit destination ownership. Match by scoped IDs, not names alone.
- Outbound policy
- No provider business writes are offered here. Sending, posting, inviting, deleting and permission changes require separately approved capabilities.
Conflicts and recovery
When records disagree
Reconcile balances, currency, payments and retainage at one as-of date. Differences block approval; posted corrections use the accounting reversal or void workflow.
When a run stops
Pause on expired or revoked access. Restore authorization before resuming from the last complete checkpoint. An incomplete list or permission error is not proof of deletion; inspect uncertain outcomes before retrying.
Limits to plan around
- File import only: export flat CSV or XLSX files and upload them. A Data Exchange API connection is planned, not available.
- Nothing is written back to Spectrum.
No provider connection is initiated from this page. See the product guide for how to run it.
Documentation and source dates
Provider documentation establishes upstream capabilities, not os.construction availability. Confirm the current edition and API contract before planning setup.