Cash Basis Account Balances For GST Accounts Change Depending on Report Date

[sam81]

I use my GST Accounts similarily to clearing account, we report on a cash basis, thus meaning when I enter the BAS figures at the end of quarter date the cash basis report balance is $0 and the accurual basis report balance is those transaction paid during the next quarter.

I recently noticed, if I run the GL Detail report for my GST accounts under cash basis, the running balance changes dependent on the dates range I input for the report. While minor, it's driving me up the wall and I can't figure out whats happening.

E.G.

Report: 29/6/21 to 30/9/21 - shows running balance on 30/6/21 as $0.00

Report: 30/6/21 to 30/9/21 - shows running balance on 30/6/21 as -$0.01

These reports are being run consecutively at the same time, thus there shouldn't be anything affecting the balances

[sam81]

Further more, if I run the report from 1/7, the opening balance (which should be the same as the closing balance on the 30/6) shows as $51,928.06.

This report is sending me crazy.

Probably also worth mentioning that the previous bookkeeper had made quite a mess of the accounts, but at this point it has all been cleaned up.

[SamaraM]

Hi @sam81 

Thank you for your post. We have identified an issue with MYOB Essentials that affects the General Ledger details report wheras the previous year's closing balance of one financial year will not match the opening balance of the following year.

Can you check if you have any invoice or purchase which is directly coded to an asset or liability account? If this is the case as a workaround, deleting those invoice/purchase transactions that have been directly coded and recording as another type of transaction (Spend or Receive Money, Journal Entry) will resolve that discrepency. 

Let me know if you require further assistance, happy to help. 

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.