nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

accrual v transaction

PRSquire

On a receivables reconciliation [Summary] I have a member who according to MYOB owes $10.01

Total Due	0 - 30	31 - 60	61 - 90	90+
$10.01	$0.00	$0.00	$0.00	$10.01

On the corresponding Card Transactions [Accrual] report he owes 1 cent

ID No.	Src	Date	Account	Debit	Credit
10071	SJ	10/09/2018	1-1400	$190.49
10174	SJ	27/04/2019	1-1400	$55.00
10360	SJ	5/04/2020	1-1400	$55.00
CR001008	CR	6/08/2020	1-1400		$44.99
CR001008	CR	6/08/2020	1-1400		$55.00
CR001008	CR	6/08/2020	2-1200		$10.00
CR001008	CR	6/08/2020	1-1400		$190.49
				$300.49	$300.48

but when I do a find transaction report it shows a $10 CR listing as a credit and debit. showing the $10.01

Find Transactions (Listing) 1/04/2018 - 16/08/2020

ID No.	Src	Date	Account	Debit	Credit
10071	SJ	10/09/2018	1-1400	$190.49
10174	SJ	27/04/2019	1-1400	$55.00
10360	SJ	5/04/2020	1-1400	$55.00
CR001008	CR	6/08/2020	1-1400		$44.99
CR001008	CR	6/08/2020	1-1400		$55.00
CR001008	CR	6/08/2020	2-1200		$10.00
CR001008	CR	6/08/2020	1-1400		$190.49
CR001008	CR	6/08/2020	2-1200	$10.00
				$310.49	$300.48

I know the member owes 1 cent but why is there a difference in MYOB. As far as I know I havent recorded anything any differently.

Find more posts tagged with

Reports

Sales

Accepted answers

Steven_M

Hi @PRSquire

The Recieve Payments window will show both open invoices and orders (and closed transactions if the option is enabled).

When you record an order no accounts are affected and thus the Find Transactions window will not show anything until that order is converted into an invoice. A user can make a payment on an order, however, it is placed into a deposit situation where the payment is placed into holding until the invoice is converted to an invoice.

Looking at the original screenshots you have provided, it looks like that deposit transaction hasn't quick carried across for one reason or another and thus leaving a difference. Deleting that transaction and redoing should bring across the transaction as intended. However, do let us know if you are still encountering that situation after re-doing that payment so we can investigate further.

All comments

PRSquire

I've produced a recievables reconciliation detail report showing the $10.01 owing

Receivables Reconciliation [Detail]
As of 25/08/2020

ID No.	Date	Total Due	0 - 30	31 - 60	61 - 90	90+

10360	5/04/2020	$10.01	$0.00	$0.00	$0.00	$10.01
	Total:	$10.01	$0.00	$0.00	$0.00	$10.01
	Grand Total:	$10.01	$0.00	$0.00	$0.00	$10.01
	Ageing Percent:		$0.00	$0.00	$0.00	$1.00
	Receivables Account:	$1,050.12
	Out of Balance Amount:	($1,040.11)

as you can see if I Print from the Find transaction screen the card transactions is 1 cent out

Card Transactions [Accrual]
1/08/2018 To 25/08/2020

	ID No.	Src	Date	Memo	Account	Debit	Credit
	10071	SJ	10/09/2018	Sale; Colin	1-1400	$190.49
	10174	SJ	27/04/2019	Sale; Colin	1-1400	$55.00
	10360	SJ	5/04/2020	Sale; Colin	1-1400	$55.00
	CR001008	CR	6/08/2020	Payment; , Colin	1-1400		$44.99
	CR001008	CR	6/08/2020	Payment; , Colin	1-1400		$55.00
	CR001008	CR	6/08/2020	Payment; , Colin	2-1200		$10.00
	CR001008	CR	6/08/2020	Payment; , Colin	1-1400		$190.49
						$300.49	$300.48

but if you look at the screen grab of the Find Transaction screen it show a $10.01 difference

now if I look for invoice 10027 in find transaction it shows 2 invoices as you can see from the screen grab inv 10071 - Colin H

If I click on the lower 10027 it brings up a completely different account

I must admit I'm confused

card - Colin H find transaction.jpg

inv 10071 - Colin H.jpg

inv 10071 - W M.jpg

Steven_M

Hi @PRSquire

If you run the Reports>>Sales>>Receiveables>>Receivables Reconciliation [Detail] report, this will list the individual transactions that are outstanding for that customer.

However, having a guess looking at the other values I would have it a guess that the $10 was paid through a deposit based transaction that has caused some problems within the system. My recommendation would be to review that transaction history to ensure that you do have the Transfer from Deposit transactions (should be two listed) - open the invoice, select the History button (right-hand side of the Edit Sales window).

If you still require assistance, we would need to see a copy of the Receivables Reconciliation [Detail] report, a screenshot of the associated transaction for that customer and one Find Transactions for that individual sale transaction to be investigated further. Also, getting the actual list balance on the card would be ideal.