Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
Hi MYOB community,
I noticed that my trade creditors account is out of balance - and it looks like it has something to do with the Job numbers but I am not sure how.
These are the following features of the extra transactions (please see attached spreadsheet examples):
Example 1 - The GST free transactions are comprised of a PJ # with both a credit and a debit (with the associated job number) PLUS a CD debit. (total 3 entries)
Example 2 - The GSTable transactions are comprised of a PJ # with 2 credits (1 for GST free component, 1 for GST) and a debit with the associated job number (GST free component) PLUS a CD debit. (total 4 entries)
No other transactions in my trade creditors account are showing up with Job numbers.
There are a total of 7 of these transactions with the job numbers listed (all the same job number) and they all happen to be from a secondary Bank Account. However there are also many other transaction with the same Job number (but it doesnt appear in the trade creditors account window), and many other transactions are also from the same secondary Bank account. These other transactions dont come up with the extra PJ GST fre debit.
I am using Account edge for Mac.
Can anyone please help?
Okay I feel like a fool - sorry - the solution is that I posted those 7 transactions directly to the trade creditors account when they should have been posted to an expense account.
It is however interesting that now there are no Job numbers appearing in the trade creditors account even though many of the transactions are related to particular job numbers (I suppose this is because it is a linked account and MYOB want to avoid double ups when we print the Job Activity statements?)
Fantastic to hear that you have been able to get the out of balance and unusual transactions resolved. We don’t recommend posting directly to any linked account as it can produce situations like this.
In terms of the job numbers not showing, it will be because job numbers are only recorded on income and expense accounts. So, when you are recording a purchase and assigning a job number to it, only the expense part of that transaction will allocate to the job. The amount that goes to the Creditors won’t be allocated to the job as it isn’t an income or expense.
Do feel free to post any other questions that you may have.