Forum Discussion

Jade79's avatar
Jade79
Contributing User
10 months ago

Recording one transaction into two different dates

Hi there

 

We need to separate one bank deposit amount into two different months as the cash sales are deposited on a weekly basis. So at the end and beginning of each month, we manually record these transactions by "receiving money" two times with different amount and dates. (one in previous month and one in current month).

 

In this way, when we do profit and loss report, cash sales amounts show up into the correct month(into the relevant month). However, when we do the bank reconciliation, those transactions always seem to be double counted in one month or another. Do you have procedure to record bank deposits like this (month end and beginning)?

 

We have several MYOB files, mostly use MYOB Business and some Account Rights.

Appreciate if you could provide us solution for MYOB Business version.

 

Thank you

 

6 Replies

  • Another suggestion is to create a cash sale invoice or monthly journal for total cash sales of the month and make payment to the cash drawer

    CR Cash Sales
    DR cash drawer

    On receipt of the actual cash, allocated to cash drawer

    DR Bank
    CR Cash Drawer

    This option helps the accountant view the cash sales for the month.


  • Jade79's avatar
    Jade79
    Contributing User
    10 months ago

    We need to separate one bank deposit amount into two different months as the cash sales are deposited on a weekly basis. So at the end and beginning of each month, we manually record these transactions by "receiving money" two times with different amount and dates. (one in previous month and one in current month).

  • Jade79's avatar
    Jade79
    Contributing User
    10 months ago

    We are actually having trouble with bank reconciliation step.. Recording the sales into the right month has already been done by the way we record...

  • Jade79's avatar
    Jade79
    Contributing User
    10 months ago

    Hi Chris

    Thanks for your recommendation. Actually the cash is deposited into the bank account we set up, so I am not quite sure what you mean by "post all sales this account instead of the bank"? Would you kindly explain me step by step? thank you in advance.

  • Hi Jade
    Recommend to setup an asset Cash on Hand or similar and post all sales this account instead of the bank.
    When you deposit the cash/money to bank, the entry is DR Bank and CR cash on hand.
    This will ensure your Sales are recorded in the right month.

Looking for something else?

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

Community home

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.