Hi, I have tried several times to make the adjustments as per the attached instructions to the trial balance and I still can't get it to balance.

Cannot anyone suggest how I should work through it logically.

Thanks.

Start by setting up a trial balance by getting your accounts with the given amounts into the correct debit or credit balance. i.e. assets and expenses should have debit amounts, while payables, owners equity and revenue accounts should have a credit balance. Note your trial balance will not be in balance at this point). You already did this in your Excel file.

Now you are ready to correct your trial balance.

Number 1, add 1,100 to your sales account balance.

Number 2, You have to add 1,050 to your bank balance to reverse the credit posting(deduction from cash), then add another 1,050 to your bank balance. This removes the deduction from your account then adds the amount to your balance.

Number 3, Corrected at start of this process in the beginning of my post.

Number 4, subtract 2,100 from your Wages account, then add 1,200 to your Wages account. This removes the wrong amount and puts the correct amount into your Wages account.

Number 5, Subtract 1,000 from your Accounts Payable account and subtract 1,000 from your Accounts Receivable account. This removes the amount you owe (Payable) and reduces the amount that is still owed (Receivable) to you by 1,000.

Number 6, You have to add 1,000 to Plant and Machinery account and add 1,000 to your Repairs account. This corrects the balances in both of these accounts.

Your debits and credits after your transactions 1 through 6 should equal 351,400