Forum Discussion

waymark's avatar
waymark
Contributing User
18 days ago
Solved

Correct allocation of BAS payment when GST refund offsets PAYG

I’m hoping someone can explain the correct way to record a BAS payment in MYOB Business when GST is in a refund position and offsets PAYG.

 

For example, suppose my BAS is:

  • GST on sales (1A): $1,000
  • GST on purchases (1B): $1,500
  • Net GST: -$500 (GST refund/credit)
  • PAYG Withholding (W2): $2,000

Therefore the net amount payable to the ATO is:

PAYG $2,000 less GST credit $500 = $1,500

 

The part I’m struggling with is recording the $1,500 Spend Money transaction.

 

If I allocate:

  • PAYG Withholding = $2,000
  • GST Balance = -$500

the transaction totals correctly ($1,500), but MYOB posts the negative GST amount as a credit to my GST Balance account, which increases the GST liability instead of reducing it.

 

If I instead enter:

  • PAYG Withholding = $500
  • GST Balance = $1,000

(or some other combination that totals $1,500), the payment balances, but it doesn’t appear to clear the actual BAS liabilities.

 

I only have one GST control account (GST Balance) in my chart of accounts. I don’t have separate GST Collected and GST Paid accounts.

 

So my questions are:

  1. How should this BAS payment actually be allocated in MYOB Business?
  2. Should the Spend Money transaction represent the BAS exactly, or is a journal entry required to offset the GST credit against PAYG before recording the cash payment?
  3. If a journal is required, what should the entries be?

I’m not asking about how the BAS is calculated - the BAS figures are correct. I’m only trying to understand the correct accounting treatment for recording the payment and ensuring both the PAYG and GST liability accounts are cleared out correctly.

  • waymark's avatar
    waymark
    17 days ago

    ok yeah it appears to reconcile on the bank transaction but it doesn't end up on the right side of the credits/debits in the GST / PAYG accounts which is annoying so I think a ledger entry to correct it is required which is stupid.

9 Replies

  • waymark's avatar
    waymark
    Contributing User
    16 days ago

    AmandaMYOB​ as you marked my reply as the solution are you saying that the only way to properly reconcile this particular transaction is via a ledger entry to correct it?

  • waymark's avatar
    waymark
    Contributing User
    17 days ago

    ok yeah it appears to reconcile on the bank transaction but it doesn't end up on the right side of the credits/debits in the GST / PAYG accounts which is annoying so I think a ledger entry to correct it is required which is stupid.

  • AndrewGFisher's avatar
    AndrewGFisher
    Experienced Cover User
    17 days ago

    I never get credits and debits the right way around. All I know is that when i use this method and reconcile correctly. 

  • waymark's avatar
    waymark
    Contributing User
    18 days ago

    Ok but if you look in the GST balance transaction list, that negative amount you have listed in the transaction list, has increased your GST liability. Find that record as see if its a credit or debit. That is what my issue is. Negative values increase the amount.

  • waymark's avatar
    waymark
    Contributing User
    18 days ago

    Yes, thanks that is exactly what I'm trying to do.

    The only issue is that when I enter a negative amount there, MYOB posts it as a credit to the GST Balance account, which increases the GST balance instead of reducing it.

    What I'm expecting after I reconcile this is that both PAYG and GST liabilities go to zero. But the negative value increases it.

    My GST Balance account is an Other Current Liability account.

    Could you confirm:

    • Is your GST Balance account also a liability account?
    • Does your negative GST line actually post as a debit in the journal?

  • AndrewGFisher's avatar
    AndrewGFisher
    Experienced Cover User
    18 days ago

    you should have a single line bank transaction for this. You allocate the correct amounts to the correct GL lines

     

  • waymark's avatar
    waymark
    Contributing User
    18 days ago

    Thanks. I do have a GST Balance account and a PAYG Withholding Payable account.

    Using the numbers above, I’m trying to understand how I would allocate that $1,500 bank transaction (I mis typed Spend Money)

    If I allocate:

    • PAYG Withholding Payable = $2,000
    • GST Balance = -$500

    the transaction totals correctly to $1,500, but MYOB posts the -$500 GST line as a credit, which increases my GST Balance account instead of reducing it.

    If I instead make both amounts positive, they total $2,500, so they obviously can’t both be allocated to a $1,500 payment.

    When you say “allocate GST to GST Balance and PAYG to PAYG Payable”, could you explain the exact allocation or the missing step? Is there a journal entry or another process that needs to happen first?

    I feel like I’m missing something and I've been on this all weekend!

  • AndrewGFisher's avatar
    AndrewGFisher
    Experienced Cover User
    18 days ago

    Do you have a GL account GST balance? You should also have an account PAYG payable.  This is not a spend money transaction its an allocation of a transaction. GST to gst balance payg to payg payable.