Your NetSuite records show the supplier transactions your business has captured. A supplier statement gives you another view: what the supplier believes is outstanding.
Comparing the two helps your AP team find missing invoices, unapplied credits and differences that need investigating. But collecting statements, matching transactions and chasing documents can take hours, even when the underlying ledger data is readily available.
AP Accurate uses your NetSuite data to automate that reconciliation process. It requests supplier statements, compares them with your records and follows up on missing documents, leaving your team to handle the exceptions that need business knowledge.
What NetSuite data does AP Accurate use?
The starting point is an agreed set of supplier and transaction data from your NetSuite environment. The exact fields and transfer method depend on your configuration and the scope of the reconciliation.
| Data | Why it matters |
|---|---|
| Supplier identifiers and names | Connects each statement to the correct supplier account |
| Invoice and credit references | Matches statement entries to recorded transactions |
| Transaction dates | Helps distinguish similar entries and investigate timing differences |
| Original amounts and outstanding balances | Supports comparisons where transactions are partly settled |
| Currency | Keeps transactions in the correct currency context |
| Payment and allocation information, where available | Helps explain invoices that the supplier still shows as unpaid |
| Subsidiary or entity identifiers, where relevant | Preserves the business entity context when matching across companies |
Supplier contact details are also needed for statement requests and document chasing. These can come from an agreed contact source.
A useful reconciliation depends on knowing what the supplied data represents. An open-transactions extract, for example, provides a different view from a full transaction history. That scope is agreed before matching begins.
How the reconciliation works
1. Request and collect supplier statements
The process starts before matching.
AP Accurate requests statements from suppliers and follows up when they have not arrived. Statements received by email or upload, including PDF and Excel documents, are captured for reconciliation.
This reduces the time your team spends maintaining a statement request list and sending repeat reminders.
2. Match statements against NetSuite records
AP Accurate compares the transactions on each statement with the agreed NetSuite data.
Supplier identifiers, transaction references, dates and amounts provide the basis for matching. The process also needs to account for differences such as reference formatting, partial payments and credits.
The aim is to establish which items agree and which need attention, with a clear record of the outcome.
3. Identify missing invoices and credits
A statement may contain an invoice that is absent from the NetSuite data supplied for reconciliation.
That is a reason to investigate. It could mean the invoice has not been received or captured, but it could also reflect the extract’s scope, a timing difference or a transaction recorded against another supplier account.
AP Accurate flags the difference and can chase the supplier for the supporting document. The same principle applies to credit notes that appear on the statement but are missing from your records.
Your team then has the information needed to decide what action to take.
4. Follow up and track progress
Finding an unmatched item is only part of the job. Someone still needs to obtain the document, understand the difference and record what happened.
AP Accurate automates supplier follow-up and keeps a record of requests and responses. Your team can see which reconciliations are complete, which are waiting on suppliers and which need an internal decision.
How exceptions are handled
Some differences can be resolved by obtaining a missing document. Others need someone who understands the purchase, supplier relationship or payment history.
| Exception | What needs to happen |
|---|---|
| Invoice appears on the statement but not in the supplied NetSuite records | Check the data scope and request the invoice where needed |
| Credit appears on the statement but not in your records | Obtain the credit note and confirm how it should be processed |
| Supplier shows an invoice as unpaid after your records show payment | Investigate payment timing and allocation |
| Invoice amounts differ | Review the supporting documents, credits and any agreed adjustments |
| Supplier or subsidiary is unclear | Confirm the correct account and business entity |
| Invoice is disputed | Refer the commercial decision to the appropriate person |
AP Accurate handles the collection, comparison and chasing around these items. Your team retains responsibility for business decisions, accounting treatment and payment approval.
What about multiple subsidiaries and currencies?
Suppliers do not always organise their statements around your accounting structure. One statement might cover several subsidiaries, and the relevant transactions could sit across different systems.
AP Accurate supports cross-company and cross-system matching, allowing statement entries to be reconciled against records from multiple entities and finance systems, including NetSuite.
This helps your team reconcile the supplier’s full account without manually splitting statements between companies or assembling separate spreadsheets. Currency remains part of the matching context, and any differences that need investigation are flagged for review.
Does this replace your NetSuite processes?
AP Accurate adds supplier statement reconciliation around your existing finance system.
Your team continues to use NetSuite for its accounting processes. AP Accurate provides the comparison with the supplier’s records, together with the document collection, follow-up and reconciliation evidence.
How results are made available, and whether any information is returned to NetSuite, depends on the agreed implementation. The data connection and any write-back requirements should be confirmed at the outset.
What a proof of concept involves
A proof of concept tests the process using an agreed sample of your own data and supplier statements.
- Agreeing the scope. Select suppliers, subsidiaries, currencies and a reconciliation period.
- Reviewing the NetSuite data. Confirm the available fields, transaction coverage and transfer method.
- Collecting sample statements. Include a representative mix of suppliers and document formats.
- Running the reconciliation. Review matches, missing documents and other exceptions.
- Assessing the results together. Identify data gaps, confirm the follow-up process and agree what a wider rollout would require.
This gives your team a practical view of how AP Accurate would work with your NetSuite environment before extending the service.
Spend less time matching and chasing
Supplier statement reconciliation gives your AP team a valuable check on the completeness of its records. Doing it consistently should not depend on finding spare time at month-end.
AP Accurate uses your NetSuite data to take care of statement collection, matching and supplier follow-up, so your team can focus on resolving the differences that matter.
Explore 360° AP integrations, or read how AP Accurate works with Coupa data and an existing SAP data extract.