Reconciliations

Reconcile any account against Spectrum

Bank and card statements, subledgers, retainage and the balance sheet against the trial balance. Vergo matches the detail against your Viewpoint Spectrum numbers, flags what doesn't tie and keeps every reconciliation with the month's close.

Book a Demo See the platform

INGEST

Any source, reconciled against Spectrum

Bring in whatever the account ties to: a bank or card statement, a subledger report, a vendor or customer statement, or another Spectrum export. Vergo's AI reads PDFs and spreadsheets as they are, so there's no re-keying or reformatting before you start.

Statements and PDFs — Bank, card, vendor and customer statements in PDF, Excel or CSV form, with no templates to set up.

Spectrum and Spreadsheet Server exports — The trial balance, GL detail, AP and AR reports you already pull from Spectrum.

Any combination — Statement to GL, subledger to trial balance, one Spectrum report to another.

Balance Sheet Reconciliations

SourcevsSpectrum GL

DescriptionSourceSpectrum GLStatus

1010 Cash$842,310$842,310

Matched

1200 AR$1.46M$1.46M

Matched

1250 Retainage$218,400$214,900

Exception$3,500

2150 Credit Cards$38,925$38,925

Matched

3 matched · 1 exception$3,500 to review

MATCH

Exceptions flagged, so you only review what doesn't tie

Vergo matches line by line and flags every item that doesn't tie. Matched items clear, and your team works through the exceptions instead of ticking every line.

Missing on either side — Items on the statement or subledger that aren't in Spectrum yet, and the reverse.

Amount and date mismatches — Items that appear in both places but don't agree.

Posting errors and items in limbo — When a Spectrum module doesn't agree with the balance sheet, see exactly which entries are off.

Bank vs Spectrum Cash4 records

Bank statementSpectrum GLConfidenceMethodStatus

Deposit 09/03GL 284798%Amount + date

Matched

Check 10421GL 285195%Check no.

Matched

ACH 09/12GL 286072%Amount differs

Review

Wire 09/15Not in GL——

No match

2 auto-matched · 1 review · 1 unmatched96.5% avg confidence

RESOLVE

A running list of what's unresolved, attached to the close

Every open exception stays on a running list until it's resolved, with notes on what was done. Each reconciliation attaches to that month's close board with its support, ready for review and sign-off.

Running unresolved list — See every open exception in one list, and what's still waiting on someone.

Review and sign-off — Preparer and reviewer on every reconciliation, with the history kept month over month.

Common Spectrum reconciliations — Cash, credit cards, AR and retainage, AP, accruals, prepaids, intercompany and the balance sheet against the trial balance.

Exception Dashboard3 exceptions

EXC-101

Crane Rental — INV vs DB$3,400 variance

Resolved

EXC-102

Steel Delivery — PDF mismatch$1,250 variance

Resolved

EXC-103

Concrete — rounding diff$12 variance

In Progress

Recent Activity

Resolved EXC-101 — S. Martinez2h ago

Note added to EXC-103 — J. Reeves4h ago

Stop ticking reconciliations line by line

See how Vergo reconciles your accounts against Spectrum and flags only the exceptions.

Book a Demo

What construction finance teams are saying

“Since the transition to Vergo, we have been able to cut back the time spent on reconciliations immensely. What was a full time job previously, takes about an hour to process daily!”

Taylor Ricard

Controller, Moss Utilities

“Since the signing I cannot speak highly enough of the customer service we have received, the team are continuously improving the product and are always on hand to jump on a call.”

Mark Goan

Accountant, JMB

Know what's unresolved before the close

See how Spectrum accounting teams reconcile every account in Vergo, so they work the exceptions, not the whole statement.

Book a Demo See the platform