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
- 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.
- 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.
- 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.
- 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.
- 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.
- Correct MYOB on Bills and Adjustments (AP301000), note each correction, and query the rest with the supplier.
- 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.