Blog

Supplier statement reconciliation in MYOB: Exo Business and Acumatica

How to reconcile a supplier statement against the creditor balance in MYOB Exo Business and MYOB Acumatica: the screens and reports to use, how to clear each difference, and a worked example.

2026-11-19 · Invoreg · 7 min read

Short answer: MYOB has no screen that reconciles a supplier's statement, in either Exo Business or Acumatica. You do it from the creditor enquiry screens: the Transactions tab in Exo, Vendor Details (AP402000) in Acumatica. Set both sides to the statement date and tick off every invoice, credit and payment that appears on both. What is left is a timing item, or an error to correct in MYOB or query with the supplier.

For the method with no software in mind, see supplier statement reconciliation, step by step. Screen and report names below come from MYOB's help pages on 19 November 2026.

What MYOB reconciles for you, and what it does not

Both products use the word reconciliation, but not for this job. In MYOB Exo Business the reconciliation screens cover bank accounts. In MYOB Acumatica the documented period end account reconciliation compares the payables subledger with the general ledger, by running AP Balance by GL Account (AP632000) against Trial Balance Summary (GL632000). Neither tells you whether the supplier agrees with you, which is what a statement answers.

MYOB Acumatica: the screens and reports you need

What you need Where to get it
Balance for every supplier Vendor Summary (AP655000) report
One supplier's open documents at a period Vendor Details (AP402000) enquiry
Documents behind a balance, in bulk AP Balance by Vendor (AP632500), Open Documents format
Unpaid amounts grouped by age AP Aging (AP631000)
Ageing fixed to a closed period AP Aged Period-Sensitive (AP630500)
Entering the corrections Bills and Adjustments (AP301000)

One parameter decides whether the numbers mean anything: AP Aging takes an Age as of Date, while AP Aged Period-Sensitive takes a Financial Period, which is the one to use when the statement falls in a month end that is now closed.

How to reconcile a supplier statement in MYOB Acumatica

  1. Fix the cut-off. Set the Period on every screen to the period the statement date falls in. Most puzzling differences are a date mismatch.
  2. Open Vendor Details (AP402000) and select the vendor, leaving Show All Documents clear. A gap between Current Balance and Balance by Documents shows as Balance Discrepancy and is worth settling first.
  3. Tick Include Unreleased Documents once, to see anything On Hold or Balanced. A bill entered but never released is invisible on the balance, and is a common reason a statement shows more.
  4. Tick off the invoices. A bill matches when the Vendor Invoice Nbr. and the amount both agree. If the supplier's number is not in that field, nothing will match cleanly next month either. Then tick off payments and adjustments by date and amount, using the Type and Reference Nbr. columns.
  5. List the one-sided items. On the statement only: invoices never entered, credit notes never recorded, bills posted to the wrong vendor. In MYOB only: payments in transit and duplicates.
  6. Correct MYOB on Bills and Adjustments (AP301000), note each correction, and query the rest with the supplier.
  7. Rerun the enquiry and check that the corrected balance plus the timing items equals the supplier's balance exactly. "Close enough" is how a duplicate survives to next month.

MYOB Exo Business: the creditor Transactions tab

In Exo the work happens on one screen: Accounts > Creditors, open the creditor, Transactions tab.

  • Group by Period groups transactions by period and gives each an Age, where 0 is the current period. Its summary line carries Invoices, Credits, Payments, Refunds, Dr Adjustments, Cr adjustments and Balance, the quickest way to find the month where you and the supplier parted company.
  • Show only unallocated strips the list back to what is still open, and the Outstanding column gives the amount left on each transaction.
  • The Status column reads Unallocated, Partly Allocated or Allocated. Partly Allocated against an invoice the supplier shows as paid usually means a payment was split wrongly, not that money is missing.
  • The Actions menu has Allocate, the right-click menu has View Allocation Info and Reverse Allocation, which needs the "Allow reversal of debtor/creditor allocations" profile setting, and the New menu covers New Invoice, New Payment and Generate Credit.

One setting on the creditor's Details 1 tab matters here: the Open Item flag decides whether all outstanding items appear on statements or only a balance brought forward, and the open item account is the one you can reconcile line by line. The Creditors Aged Balances dashboard gives the portfolio view, in Current, 1 Month, 2 Month and 3 Month buckets.

How to clear each difference

  • Invoice on the statement, nothing in MYOB. Ask the supplier for a copy and enter the bill from that. Never enter it from the statement line: a statement is a list of invoices, not an invoice, and carries no tax detail you can rely on.
  • Credit note on the statement, nothing in MYOB. In Acumatica this is a debit adjustment on Bills and Adjustments (AP301000): MYOB's help says it decreases the amount you owe, accounts for a vendor's credit memo, and once released applies against open bills. A credit adjustment does the opposite, so the wrong one moves the balance the wrong way twice. In Exo, use Generate Credit.
  • Invoice entered twice. Reverse the duplicate rather than journalling it out, so the invoice number appears once. Duplicates are the difference most likely to cost real money, because the second copy gets paid, and how duplicate invoices happen covers the intake side.
  • Invoice posted to the wrong supplier. It shows up twice, as a missing invoice here and an unexplained balance there.
  • Payment made but not on the statement. Timing, so list it and leave it. If it is more than a few days old, chase the allocation: an unapplied payment is what puts an account on stop while you have in fact paid.

A worked example

A supplier statement at 31 October shows $6,195. MYOB shows $3,920. The $2,275 difference is five things, not one.

What it is Where it appears Action Effect on the MYOB balance
Invoice 10412, $1,260, still in an inbox Statement only Enter the bill from a copy of the invoice +$1,260
Credit note CN-118, $340, for a short delivery Statement only Debit adjustment, applied to the open bill -$340
Invoice 10388, $615, entered twice MYOB only Reverse the duplicate -$615
Invoice 10401, $870, posted to a sister company's account Statement only Move it to the right supplier +$870
Payment of $1,100 sent 29 October MYOB only None, timing none

The reconciliation then reads:

$
Balance in MYOB, 31 October 3,920
Add: invoice 10412 not entered 1,260
Less: credit note CN-118 not recorded (340)
Less: invoice 10388 duplicate (615)
Add: invoice 10401 under the wrong supplier 870
Corrected balance in MYOB 5,095
Add: payment in transit, 29 October 1,100
Balance per supplier statement 6,195

Without the reconciliation the client pays invoice 10388 twice, misses a $340 credit, lets invoice 10412 run overdue, and carries an $870 overstatement on the sister company too.

A monthly routine for firms

  • Run Vendor Summary, or the Creditors Aged Balances dashboard, at month end and pick the accounts to reconcile: largest balances, weekly suppliers, anyone sending reminders. Ask those suppliers for statements at the same date.
  • Reconcile the rest quarterly, and every supplier with a balance at year end. Keep each reconciliation with its statement, so next month starts from the open items.
  • Put statements in the same queue as the bills, so whoever enters a client's invoices spots a missing one in seconds. The multi-client invoice workflow guide shows one way to run that across a portfolio, and the same job is covered for Zoho Books and QuickBooks.

Four of the five differences above started when an invoice was entered, or was not. Fix the intake and statements start agreeing on their own.

Where Invoreg fits

Invoreg does not reconcile supplier statements. It works on the step that creates most of the differences: it reads every supplier invoice, including scans and phone photos, line by line with the tax rate on each line, suggests the coding from the client's history, checks for duplicates against the workspace and the bills already in the accounting software, and registers nothing without a person approving it.

Zoho Books is the live connector today, so for a MYOB file the route is an import file the software already accepts, usually within days, or an API connector in one to three weeks after a technical review. Either way invoices arrive coded, de-duplicated and approved, which is what makes a statement agree: try it on your own invoices, the first 20 invoices are free.

Sources

  1. MYOB, MYOB Exo Business help: Viewing the Transaction History of an Account, accessed 19 Nov 2026
  2. MYOB, MYOB Exo Business Clarity: Creditors Aged Balances dashboard, accessed 19 Nov 2026
  3. MYOB, MYOB Acumatica help: Vendor Details (AP402000), accessed 19 Nov 2026
  4. MYOB, MYOB Acumatica help: To Run AP Aging Reports, accessed 19 Nov 2026
  5. MYOB, MYOB Acumatica help: Debit and Credit Adjustments, General Information, accessed 19 Nov 2026

Questions accountants ask

How do I reconcile supplier statements in MYOB Exo?

Open the creditor under Accounts > Creditors and use the Transactions tab. Tick Group by Period to line the account up with the statement month, read the Outstanding and Status columns, then tick off every invoice, credit and payment that appears on both. What is left is either a timing item or an error to correct in Exo or query with the supplier.

How do I reconcile supplier statements in MYOB Acumatica?

Use Vendor Details (AP402000) for one supplier, with the Period set to the statement month, or run AP Balance by Vendor (AP632500) in the Open Documents format. Compare the listed documents with the statement line by line, then correct the differences on Bills and Adjustments (AP301000).

Does MYOB have a supplier statement reconciliation screen?

No. In MYOB Exo the reconciliation screens cover bank accounts, and in MYOB Acumatica the documented account reconciliation compares the AP subledger with the general ledger. Reconciling a supplier's own statement is a separate job done with the creditor enquiry screens and the AP reports.

Which MYOB report shows what I owe each supplier?

In MYOB Acumatica, Vendor Summary (AP655000) lists every vendor with its current balance, AP Aging (AP631000) groups past due balances by age, and AP Balance by Vendor (AP632500) shows the documents behind a balance. In MYOB Exo, the Creditors Aged Balances dashboard splits what you owe into Current, 1 Month, 2 Month and 3 Month.

How do I record a supplier credit note in MYOB Acumatica?

As a debit adjustment on Bills and Adjustments (AP301000). MYOB's help says you create a debit adjustment to decrease the amount you owe to a vendor, and that it can account for a vendor's credit memo. Once released it can be applied against open bills for the same vendor and stays Open until its unapplied balance is zero.