# Payroll reconciliation

> Payroll reconciliation: Which payroll totals tie to GL and bank; why not Checked: proven by code. Produces reconciled payroll, differences explained.

Source: https://www.sumarity.ai/library/payroll-reconciliation/

Finance and accounting 

# Payroll reconciliation

Reads payroll register, the general ledger, bank payments. Produces reconciled payroll, differences explained. Code works out every figure, the Judgement Engine answers the narrow questions, and whatever stays uncertain goes to a person.

Proven by codeReconciliation and matching
Start from this workflowMore for finance  

What it decides

## Narrow questions, each with a check behind it.

Which payroll totals tie to GL and bank; why not
Proven by code: register = GL = bank. Code proves the answer from the data itself: totals tie, a match is exact, the quote is on the document. Most of these judgements settle without a person.

| Reads | Payroll register, the general ledger, bank payments 
| Produces | Reconciled payroll, differences explained 
| Who signs | A person on your team, with every figure traced to its document and every call on record 
| Process | Reconciliation and matching 
| Industry | Finance and accounting    

See it run

## Every line, decided where it's safest.

An example run. Each stage lights up as a line is decided there; pick a stage to see its lines.

ReadsPayroll register, the general ledger, bank paymentsCodeReads, matches, ties out and works out every figure.JudgementWhich payroll totals tie to GL and bank; why not. Settles only when it clears the cutoff and code proves it.A personGets whatever stays uncertain, with the evidence. Their ruling tunes the next run.ProducesReconciled payroll, differences explained  
Payroll reconciliation · example run Example run  

| Run | Line | Amount | Decided by  
| Sep | Gross pay per registerTies to the ledger's salary accounts | 412,300.00 | Code · tied 
| Sep | Net pay to bankBank payments equal net pay | 301,880.40 | Code · tied 
| Sep | Social chargesRates × base agree · 0.96 | 41,230.00 | Engine · proven 
| Sep | Pension contributionsOne employee's rate changed · 0.90 · new plan | 22,410.00 | Engine · proven 
| Sep | Payment to a closed accountReturned by the bank | 4,120.00 | To a person  
|  

Settled 4 To a person 1 Settled wrong 0      Illustrative lines. Amber rows are the Judgement Engine's calls; each settles only above its cutoff and when its check agrees.    

What it could save

## Your volumes in. Your hours out.

In our tests, between 24% and 42% of items still went to a person after tuning. Set your own share; a pilot measures it on your data.

Items per run 
Runs per month 
Minutes per item by hand 
Cost per hour

Share of items that still need a person: 30%  

By hand today80 ha month 
With Sumarity24 ha month, for the items people decide 
Saved56 hCHF 53,760 a year    

Related

## Start from what's closest.

### Reconciliation and matching in other work

Finance

### Bank reconciliation

Which ledger entry a bank line is; why a line is unmatched

Proven by codeTestedFinance

### Card and payment-processor settlement reconciliation

Which sales a payout covers; fee and chargeback lines

Proven by codeFinance

### Intercompany reconciliation

Which entries are the two sides of one transaction

Proven by code

### More for finance

### Bank reconciliation

Which ledger entry a bank line is; why a line is unmatched

Proven by codeTested

### Card and payment-processor settlement reconciliation

Which sales a payout covers; fee and chargeback lines

Proven by code

### Cash application

Which open invoices a receipt pays; short-pays and deductions

Proven by code  

Questions

## What buyers ask

What happens when Sumarity isn't sure?

Nothing settles below the cutoff, or when the check disagrees. The item goes to a person in the inbox with what the engine saw, its best answer and the runner-up. The person's ruling is kept and tunes the next run.

How are its judgements checked?

Code proves the answer from the data itself: totals tie, a match is exact, the quote is on the document. Most of these judgements settle without a person.

Can we change it to fit how we work?

Yes. Start from this workflow and describe your differences in plain words. The design assistant revises it, the validator checks it, your expert reviews it on the canvas, and your admin publishes it.

Does it read our files as they are?

Yes: spreadsheets and CSV in any layout, PDFs, bank formats and e-mail attachments. Sumarity suggests how each column maps, proves the mapping on a sample and remembers it once a person confirms it.

Where does our data go?

Sumarity runs in Zurich. Your data, backups and logs are stored in Switzerland.

How does it get better?

Your team's rulings become an answer key. Better questions and cutoffs are proposed, tested on data they haven't seen, and published only when your admin approves. It improves itself, with permission.

## Start from this workflow. Run it on your data.

A pilot runs alongside your own process for a few weeks, at our cost, and ends in a line-by-line comparison.

Talk to usBack to the library
