MYOB Groups · Track 4 · Tutorial 2 of 2

Work with payments and settlements

Available on ProPremium

An invoice marked paid doesn’t say how. BrizoConsol reads the customer and supplier payments recorded in MYOB and matches them to the invoices and bills they paid, so you can answer “how was this settled?” from one place.

You will needWattle Pty Ltd connected to MYOB, with its invoices and bills loaded, as in Connect each MYOB company file. Free, Pro or Premium edition.

By the endAn invoice traced to the two receipts that paid it, and a part-credited invoice read correctly.

1Know what is read

Customer payments and supplier payments are read from MYOB and matched to each invoice and bill: invoice 00001051 settled by two receipts; a credit applied in MYOB shows only in the balance due — MYOB records each settlement on the payment, so BrizoConsol reads the payments.

Customer payments	Money received against one or more invoices. Each part of a payment is matched to the invoice it paid.
Supplier payments	Money paid against one or more bills.
Credits	MYOB doesn’t give BrizoConsol the credit notes and returns applied to an invoice or bill. A credit lowers the document’s balance due, but isn’t listed as a row — see step 3.

The payments are read with each month’s Invoices and Bills: the payments made in that month, matched to the documents they paid, whatever month those are dated in. A payment for a document whose month isn’t loaded yet is kept and applied when that month is loaded. There is no separate switch, and the nightly read keeps the last 3 months current.

2See how an invoice was paid

Wattle Pty Ltd invoiced Harbour Dental AUD 12,000.00 on 2 October 2026 (invoice 00001051). It is paid. Here is how:

Select Wattle Pty Ltd, and search for 00001051 in Global Search. The Invoices page opens on it.
Click the row to open it.

Invoice 00001051 from Wattle Pty Ltd to Harbour Dental opened to its payments: AUD 12,000 received, nothing due, and two dated receipts — How much was received and is due (1), the position at the time shown (2), and each dated receipt (3).

Received / Credits applied / Balance due	In the invoice’s own currency. Balance due is MYOB’s own balance for the invoice. Credits applied stays 0.00 for MYOB, because MYOB gives no credit rows.
Received by / Balance due at	The position as at the date and time shown, when this record last changed in MYOB, worked out from the receipts listed — or from MYOB’s own balance when a credit was applied, as in step 3.
The table	One row per allocation, dated. Money shows as Receipt on an invoice and Payment on a bill. A negative row is a payment reversed in MYOB.

Here, 7,000.00 was received on 10 October and the last 5,000.00 on 22 October.

Check

Received plus Balance due equals the invoice total — 12,000.00 + 0.00 = 12,000.00 — and the invoice’s payment history in MYOB shows the same two receipts.

On an invoice in a foreign currency, the payment is converted at the invoice’s own rate, so the panel shows it at that rate only and notes that no exchange difference is measured there. The realised exchange difference is in MYOB’s ledger: drill the currency gain or loss account, as in Follow a figure to the MYOB posting.

3Read an invoice that was part credited

Invoice 00001058 to Coastal Builders Pty Ltd was for 8,800.00. In MYOB, a credit of 800.00 for returned materials was applied to it, and the customer paid the other 8,000.00. Open it the same way:

Received	8,000.00 — the one receipt, listed in the table.
Credits applied	0.00. The 800.00 credit isn’t listed.
Balance due	0.00 — MYOB’s balance, which already takes the credit into account.
Received by / Balance due at	8,800.00 settled and 0.00 due — taken from MYOB’s own balance, so the credit is counted as settled.

Below them, the panel says MYOB records no payment, credit or write-off for 800.00 (AUD) of this invoice. Its own balance is what the position above states. That 800.00 is the credit applied in MYOB.

4Bills work the same way

Open a bill on the Bills page and its panel says Paid instead of Received. Supplier payments show as Payment rows. A supplier credit applied in MYOB lowers the bill’s balance due, as in step 3.

5If something goes wrong

No payments, credits or debits recorded for this document.	Nothing has been received against it — or the month the payment was made in isn’t loaded. Load that month with Invoices and Bills ticked. An invoice paid in instalments keeps every month’s payments once each month is loaded.
MYOB accounting detail requires the Free, Pro or Premium edition.	Payment detail isn’t included in the Standard edition.
The invoice still shows a balance after it was paid	The payment month hasn’t been read since. If it is in the last 3 months, it clears after the next nightly read; otherwise load the month.
MYOB records no payment, credit or write-off for … of this invoice.	A credit was applied in MYOB, as in step 3. MYOB’s own balance is the one shown.

Want more detail? See the documentation

Invoices & Bills List Data Loading Connecting an Entity to MYOB

All tutorials