Forum Discussion

SMM's avatar
SMM
Experienced Cover User
7 years ago
Solved

GST Paid doesn't match Balance Sheet

Hi My GST Paid report (cash) report is different to my Balance Sheet figure as at 30.6.18. It's a small difference of $12.08 There is no tax on outstanding creditors - everything is paid via Spend $ Previous periods BAS payments have been properly accounted for. Can anyone shed any light on this please? Thanks
  • Steven_M's avatar
    Steven_M
    7 years ago

    Hi SMM

     

    So, in theory, assuming all transactions were recorded as Spend Money transactions (which record the payment at the time of recording the transaction) you could run the General Ledger Detail report for that particular account. You could compare this with the GST [Detail - Cash] for the same period and identify transactions that are not recorded in the General Ledger Detail report that are in the GST Detail report or vice versa.

     

    Although, it should be noted that you are comparing an accrual basis and a cash basis reports so you are comparing two different accounting method based report. As such other considerations do need to be taken into account for example transactions recorded outside of the period that are impacting the account balance.

4 Replies

Replies have been turned off for this discussion
  • SMM's avatar
    SMM
    Experienced Cover User
    7 years ago

    Thanks Steven. I'm aware of that. As I said though, we only use spend Money to pay bills. So the 2 figures should match.

  • Steven_M's avatar
    Steven_M
    Former Staff
    7 years ago

    Hi SMM

     

    You mentioned that the GST report you are using is a cash-based report, the Balance Sheet report is an accrual-based report. As these are two different accounting methods you are likely going to find a difference in values as it is like you are comparing apples and oranges.

  • Steven_M's avatar
    Steven_M
    Former Staff
    7 years ago

    Hi SMM

     

    So, in theory, assuming all transactions were recorded as Spend Money transactions (which record the payment at the time of recording the transaction) you could run the General Ledger Detail report for that particular account. You could compare this with the GST [Detail - Cash] for the same period and identify transactions that are not recorded in the General Ledger Detail report that are in the GST Detail report or vice versa.

     

    Although, it should be noted that you are comparing an accrual basis and a cash basis reports so you are comparing two different accounting method based report. As such other considerations do need to be taken into account for example transactions recorded outside of the period that are impacting the account balance.

  • SMM's avatar
    SMM
    Experienced Cover User
    7 years ago

    Thanks Steven. I'll give that a go.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Learn:

 

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content