Sales figure in reports not matching profit and loss

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
jennifer6
Contributing User
5 Posts
Contributing User
Contributing User

5Posts

0Kudos

0Solutions

Solved: Go to Solution

Sales figure in reports not matching profit and loss

Hi, I am really hoping someone could explain this to me as I am not sure if this has been done correctly.

 

We have been doing a simplified version of just spending and receiving money.

 

When we receive money in from the sales we would dr bank and cr sales income.

When someone returns the sales or money bounced bank, it would be cr bank dr sales income.

 

For instance, I have a total sales of $50,000 and sales income bounced back totally $4,000.

When I run my GST report it will shows a total sales of $50,000 but in my profit and loss, it shows $46,000. (which is basically the adjustment of cr bank and dr sales income.)

 

However, this sales figure in the GST report is not reflecting the returns of $4,000 and everytime I am to lodge the BAS I need to manually deduct the $4,000 from the GST report.

 

Anybody could advise on a better and correct way of accounting it? As mentioned, I am only using spend money and receive money so no invoice or sales return,etc.

 

Many thanks.

5 REPLIES 5
Maddie_G
45 Posts
Former Staff
Former Staff

45Posts

0Kudos

1Solutions

Re: Sales figure in reports not matching profit and loss

Hi @jennifer6 

When you processed the $4000 of credit which tax type have you used on those transactions?
Also is it Essentials you are using? 
Sorry it might be obvious but what are you referring to when you said 'dr sales'? assuming 'cr bank' is credit bank 

Kind regards,
Maddie

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

jennifer6
Contributing User
5 Posts
Contributing User
Contributing User

5Posts

0Kudos

0Solutions

Re: Sales figure in reports not matching profit and loss

Hi Maddie,

 

For all sales are actually sales gst free that we are talking about so yes gst free. I am using account right at the moment. 

 

And dr sales means dr sales income(which previously was recorded under sales income account) and yes cr bank account.

 

Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

Accepted Solution Solved

Re: Sales figure in reports not matching profit and loss

Hi @jennifer6 

 

How are you recording that bounced back amount, as a negative Receive Money or a Spend Money? As the type of transaction will determine where it appears on the GST reports, if you are recording it as a Spend Money transaction it will be appearing in the Purchase Value column in the GST summary report. 

 

If you are recording it as a negative Receive Money transaction it should be reducing the Sale Value figure in the GST summary report.

 

Please do let me know if you need further assistance with this.

 

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

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

jennifer6
Contributing User
5 Posts
Contributing User
Contributing User

5Posts

0Kudos

0Solutions

Re: Sales figure in reports not matching profit and loss


Hi @Tracey_H ,

I have been recording it as an expense because under the bank feed and on withdrawal side, you can only do spend money and not receive money. 

Can you advise how to do that from the bank feed itself?

Thank you!

 


 

jennifer6
Contributing User
5 Posts
Contributing User
Contributing User

5Posts

0Kudos

0Solutions

Re: Sales figure in reports not matching profit and loss

Hi @Tracey_H 

 

I have tried again and manually entered it and match it with the bank feed again and it works!

 

Many thanks!!!!

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post