3-Way Reconciliation in QuickBooks

3-way reconciliation in QuickBooks is the process of comparing purchase orders, goods received records, and supplier invoices to confirm that the amounts, quantities, and references all align. For finance teams, this is a critical control in accounts payable, vendor reconciliation, and month-end close.

When the process is handled in spreadsheets, it can become slow, repetitive, and difficult to audit. Cointab helps finance teams replace manual file comparisons with a structured reconciliation workflow that can be reused every period.

What 3-way reconciliation means

In a typical 3-way reconciliation process, finance teams compare three source documents:

• Purchase order: the amount and terms agreed with the supplier
• Receipt or goods received note: confirmation that goods or services were delivered
• Invoice: the amount billed by the supplier

The objective is to make sure the invoice matches what was ordered and what was received. If one document differs, the team needs to review the reason before payment is approved or closed in the books.

This workflow is especially useful when teams need to control duplicate invoices, short shipments, pricing differences, missing receipts, or unapplied credits.

Why manual matching becomes difficult

Manual 3-way reconciliation often starts with exported reports, Excel formulas, and repeated cross-checks between files. That works for small volumes, but it becomes harder as supplier count, invoice count, and exception cases increase.

Common challenges include:

• Different file formats across purchasing, receiving, and AP systems
• Missing or inconsistent identifiers such as PO numbers or invoice references
• Partial deliveries that create amount differences
• Credit notes, discounts, and tax adjustments
• Duplicate rows or unusable records that need to be skipped
• Inconsistent review methods across team members
• Repeating the same setup every period

These issues slow down the close process and make it difficult to see what is fully matched, what still needs review, and what should be excluded.

How Cointab supports 3-way reconciliation

Cointab is a flexible reconciliation platform that helps finance teams compare internal records with external records, identify discrepancies, and review matched, partially matched, unmatched, and skipped transactions.

For 3-way reconciliation, teams can configure a custom workflow that brings together the relevant purchase, receipt, and invoice files. Once the setup is defined, it can be reused for future periods instead of being rebuilt from scratch.

Typical workflow:

1. Upload the required files or configure automated data input.
2. Map the required columns such as date, amount, PO number, invoice number, or supplier reference.
3. Add optional supporting data for lookup, enrichment, or preparation.
4. Create derived columns if the data needs cleaning or calculation.
5. Run the reconciliation manually or on a schedule.
6. Review the report and focus on the exceptions.
7. Download the Excel report for internal review or audit support.

What the setup usually looks like

A 3-way reconciliation workflow can include multiple files and supporting datasets. Cointab lets users map the fields that matter most to the business process.

Common fields

• Purchase order number
• Invoice number
• Supplier code
• Receipt or GRN number
• Item or SKU reference
• Quantity
• Amount
• Tax amount
• Delivery or service date

Supporting data that can help

Supporting data is optional, but it can make matching more useful. Finance teams often use it to enrich the primary files before reconciliation.

Examples include:

• Vendor master data
• Product master data
• Tax mapping file
• Fee or discount file
• Receipt or order status data
• Any reference file used for lookup or merging

Derived columns

If the raw data needs cleanup, Cointab can create derived columns from existing fields. This can help normalize references, calculate net amounts, or create matching fields.

Examples:

• Clean PO number
• Normalized invoice reference
• Net amount after tax
• Amount excluding fees
• Combined supplier reference

How Cointab handles exceptions

Not every transaction will match neatly. Finance teams need a clear view of what matched, what needs attention, and what was excluded from the run.

Cointab separates records into four outcomes:

This structure helps AP and accounting teams focus on real exceptions instead of reviewing every line item manually.

Common discrepancy scenarios in 3-way reconciliation

3-way matching is useful because it reveals the reasons an invoice should not move forward exactly as submitted. Typical exception scenarios include:

• Invoice amount is higher than the purchase order
• Goods were received in part, but the invoice is for the full quantity
• Supplier reference is missing or inconsistent
• A receipt exists, but the invoice has not arrived yet
• A credit note or deduction changes the final payable amount
• Duplicate documents create confusion in the workflow
• A file is missing and needs to be uploaded later

In Cointab, these open items remain visible so the team can investigate them with context instead of losing them in spreadsheets.

Why this is better than spreadsheet-based reconciliation

Excel is often the starting point for reconciliation, but it can be difficult to maintain as the workflow grows. Formula-heavy files are harder to audit, and different people may build slightly different versions of the same process.

Cointab gives teams a more structured approach:

• Reuse the same reconciliation setup for future periods
• Apply matching logic consistently
• Review exceptions in one place
• Keep matched, partially matched, unmatched, and skipped records separate
• Download audit-ready Excel reports
• Support team-based workspaces with roles and access control

This reduces repeated setup work and makes the process easier to explain during internal review or audit preparation.

Manual match and missed-file handling

Sometimes a transaction cannot be matched automatically because the source file is incomplete or the partner data is not clean enough. Cointab supports manual match for those cases, allowing finance teams to match records when they have the necessary business context.

If a file was missed in the original run, the user can upload it under the same reconciliation and refresh the report. That is useful in finance operations where reports may arrive later than expected from suppliers or internal systems.

Recurring reconciliation for month-end close

Once a 3-way reconciliation is configured, the same workflow can be reused for monthly, quarterly, yearly, or custom periods. That is especially helpful for teams that need a repeatable AP control process.

Cointab also supports automation through email, SFTP, and API-based flows. In a recurring setup, finance teams can receive files, run reconciliation on a schedule, and keep the output available for downstream review or reporting.

This makes the workflow more suitable for daily or period-end operations, not just one-off analysis.

When finance teams use this workflow

3-way reconciliation is commonly used in:

• Accounts payable review
• Supplier invoice validation
• Purchase-to-pay controls
• Vendor reconciliation
• Month-end close support
• Audit preparation
• Finance operations reporting

It is most valuable when the team needs clear transaction matching, controlled exception handling, and repeatable reporting across periods.

FAQs

What is the difference between 3-way reconciliation and bank reconciliation?

3-way reconciliation compares purchase orders, receipts, and invoices. Bank reconciliation compares bank statement entries with book records. They solve different finance control problems, although both rely on matching and exception review.

Can Cointab handle more than one file in a reconciliation workflow?

Yes. Cointab supports custom reconciliation setups that can use multiple files and supporting datasets within the same workflow, depending on how the business process is structured.

What happens if invoice data does not match the purchase order amount?

The transaction is not treated as fully matched. It may appear as partially matched or unmatched depending on the reconciliation rules and available identifiers, so the finance team can review the difference.

Can recurring 3-way reconciliation be automated?

Yes. Once a reconciliation is configured, Cointab can support recurring runs with automated data input and scheduled reconciliation workflows using supported delivery methods such as email, SFTP, or API.

Can the same setup be reused every month?

Yes. Reuse is a key part of the workflow. Finance teams can configure the reconciliation once and run it again for future periods with updated files or automation.