For Australian accounts payable teams who want each supplier statement to agree with NetSuite before the month closes.
Last reviewed: 22 November 2026. Product details reflect this review date. Availability and behavior can vary by account, role and release.
NetSuite supplier statement reconciliation means matching a supplier's statement to what NetSuite shows you owe that supplier on the same date. Run A/P Aging Detail for the vendor, compare each invoice and credit line by line, enter what is missing and note anything still in transit. The remaining gap should match the items you can explain.
A supplier statement is the supplier's own list of what you owe them. It shows invoices, credit notes and payments they have recorded, with a closing balance.
NetSuite holds your side of the same story. A/P Aging Detail shows open amounts by vendor as of the report date. It reflects posting activity, so check whether a missing bill is still awaiting approval.
A difference can come from a missing document, a payment recorded on different dates or a bill entered for the wrong amount.
Gather four things first:
Open Reports > Vendors/Payables > A/P Aging > Detail. Use the detail report to match items and the summary to scan balances by vendor. The Accounts Payable Register helps trace posted bills, credits and payments.
Oracle documents a separate shortcut in NetSuite QuickStart. On the vendor record, select More actions > View vendor statement to see charges, payments and a running balance.
Follow these steps for each supplier:
For more than a handful of suppliers, build a saved search to triage currently open bills. Keep A/P Aging Detail as the comparison for a past statement date. Use a Transaction search with Type set to Bill, Main Line set to true and Amount Remaining greater than zero.
Sort by vendor and include the due date, open amount and supplier reference. Check the reference column against Reference No. on a known bill. Main Line gives you one row per bill.
Use the Audience subtab to share the search with your accounts payable (AP) team if you have Publish Search permission.
A hypothetical packaging supplier sends a statement dated November 30. The statement closing balance is A$18,420.00. A/P Aging Detail for the same vendor and date shows A$15,050.00. The difference is A$3,370.00.
Working through the lines finds three items:
| Item | Where it is | Effect on the difference |
|---|---|---|
| Invoice INV 4471 for A$2,200.00 including A$200.00 GST | On the statement, not yet entered in NetSuite | Statement is higher by A$2,200.00 |
| Credit note CN 0318 for A$330.00 including A$30.00 GST | On the statement, not yet entered in NetSuite | Statement is lower by A$330.00 |
| Payment of A$1,500.00 recorded in NetSuite on November 28 | Supplier banked it on December 2 | Statement is higher by A$1,500.00 |
A$2,200.00 less A$330.00 plus A$1,500.00 equals A$3,370.00.
Under Transactions > Payables, the AP clerk opens Enter Bills for INV 4471 and Enter Vendor Credits for CN 0318. On the credit's Apply subtab, the clerk selects the bill the credit belongs to and saves. Once both entries are posted for the statement date, NetSuite shows A$16,920.00. The only gap is the A$1,500.00 payment, which the clerk logs to check against the December statement.
Reconcile your largest suppliers every month, before the period closes. These are the ones with the most invoices and the most credit notes. For suppliers with fewer transactions, set a review schedule based on the balance and how often you see differences.
Give each open item an owner and a follow up date. Carry unresolved items into the next review so a payment in transit from last month does not disappear from the list.
This week:
CuriousRubik's NetSuite reporting team can build the saved searches and role access that make this a routine monthly job. See how we support NetSuite customers in Australia.
What to settle in NetSuite before 30 June, from open payables to BAS and STP.
How bank feeds and payment files match up with vendor payments in NetSuite.
A reconciliation routine for super liabilities that agrees with the ledger each quarter.