Forum Discussion

Jade79's avatar
Jade79
Contributing User
9 days 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

  • 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.

  • Jade79's avatar
    Jade79
    Contributing User
    7 days 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.

  • Jade79's avatar
    Jade79
    Contributing User
    7 days 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...

  • Ok thanks Jade, how do you record the sales for each month?

  • Jade79's avatar
    Jade79
    Contributing User
    7 days 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).

  • 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.