Forum Discussion

MatheusToledo's avatar
MatheusToledo
Contributing User
1 year ago

Matching bank statement lines to cheques

Hey,

 

In one of my pay runs, I created a check to pay an employee $1,210.00, but I actually paid him in two payments of $605.00 each, and now I can't match two bank statement lines with the same check in my bank reconciliation. How to fix this?

2 Replies

  • Shella_A's avatar
    Shella_A
    MYOB Moderator
    1 year ago

    Hi MatheusToledo,

     

    Since reversing and reprocessing the pay run isn't a suitable option for you, there's another workaround to help match the pay run with the bank feed transactions:

     

    • Create a Payroll Clearing Account. Go to Accounting > Chart of Accounts > Create account. If you already have one, you can skip this step.
    • Set Up the Account. Create a detail account with the necessary settings as per the screenshot below.

    • Allocate Transactions. In Bank Transactions, allocate the separate wage payments to the clearing account.
    • Check General Ledger Report. Run a General Ledger Report (Reporting > Reports) to confirm that the payroll clearing account has a debit balance matching the allocations.
    • Create General Journal Entry. In Accounting > General Journal, transfer the full pay amount between the bank account and the payroll clearing account.
    • Verify the Balances. Run the General Ledger Report again to confirm that the journal offsets the payroll clearing account balance.

    Just a reminder, when completing the next bank reconciliation, make sure to reconcile the spend money allocations, the initial pay run and the general journal to balance.

     

     

    Regards,

    Shella

  • MatheusToledo's avatar
    MatheusToledo
    Contributing User
    1 year ago
     DEBITCREDIT
    Bank Acc 605
      605
    Payroll Clearing1210 
       
    Payroll clearing 1210
    Bank Acc1210 

     

    These would be the journal entries then?

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.