Skip to content
Workflow · Match two lists · Opening soon

CIS deductions reconciliation for subcontractors

Export your sales invoices from Xero, the monthly payment and deduction statement each contractor sends you, keyed into a sheet, and your bank receipts from QuickBooks. The workflow matches invoice lines, keeps one statement per invoice, and compares the expected 20% labour deduction with the amount deducted and the amount received.

Early access opens shortly. Check back soon.

Someone typed

“match the xero sales invoices to the contractor payment and deduction statements and our bank receipts, show invoice total, expected deduction, amount deducted, amount received and status: Agrees, No statement, Wrong deduction, Receipt differs”

The agent read it as

match the Xero sales invoices to the Payment and deduction statements (from your contractors) and QuickBooks bank receipts, show invoice total, expected deduction, amount deducted, amount received and status: Agrees, No statement, Wrong deduction, Receipt differs, using 20% of invoice labour

What the agent built

7 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Xero sales invoices
    CSV export · 24 rows
  2. File
    Payment and deduction statements (from your contractors)
    CSV export · 22 rows
  3. File
    QuickBooks bank receipts
    CSV export · 24 rows
  4. Step
    Number invoice lines
    Step 1
  5. Step
    Number statement lines
    Step 2
  6. Step
    Find receipt invoice numbers
    Step 3
  7. Join
    Match statement lines
    22 of 24 paired
  8. Step
    Keep one statement per invoice
    Step 5
  9. Join
    Match bank receipts
    24 of 24 paired
  10. Step
    Show invoice match status
    Step 7
  11. Result
    Invoice payment reconciliation
    24 rows · 4 flagged
  12. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 24 rows.

What you get back

The result of that run, the rows to look at first.

Invoice payment reconciliationSample data24 rows
20 agrees2 wrong deduction2 no statement
Invoice numberInvoice totalExpected deductionAmount deductedAmount receivedStatus
INV-100723038·192No statement
INV-101830037·258No statement
INV-10043604060323Wrong deduction
INV-10152503450200Wrong deduction
INV-10012403030210Agrees
INV-10023004444256Agrees
INV-10033003636264Agrees
INV-10052003535165Agrees
INV-10063604848312Agrees
INV-10083604141319Agrees
INV-10092403232208Agrees
INV-10103004242258Agrees
24 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Invoice payment reconciliation workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Invoice payment reconciliation: questions

How do you reconcile CIS deductions?
Export your sales invoices from Xero, the monthly payment and deduction statement each contractor sends you, keyed into a sheet, and your bank receipts from QuickBooks. The workflow matches invoice lines, keeps one statement per invoice, and compares the expected 20% labour deduction with the amount deducted and the amount received. It shows each invoice as Agrees, No statement, Wrong deduction, or Receipt differs.
Which export should you use?
Use the sales invoices export from Xero and the bank receipts export from QuickBooks. Each contractor sends you its monthly payment and deduction statement; key those into one sheet with a row per invoice, then upload all three files.
What happens when a row does not match?
Rows that do not match the expected invoice, statement, or receipt are shown with a status. They stay visible so you can see missing statements, wrong deductions, and receipts that differ from the invoice total less the deduction.
How do you change the rules?
You change the rules in plain words by changing what fields are matched and how amounts are compared. For this workflow, the rule is to use 20% of labour only, not materials or VAT, and to compare each invoice with one statement and one receipt.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.