Year End Journal Adjustments HELP PLEASE!

Hi Everyone, I am desperately after some help.

Our year end is 30th June. Our accountants have sent us over a " journal adjustment" sheet for period 30/6/18

Normally our bookkeeper would make these adjustments but she left at Christmas time.

I am now under pressure to do these! whilst I am happy running on Sage day to day things like this scare me. I am Only 3 Months into my AATs. Our accountant isn't helpful in guiding me so I am hoping someone can point me in the right direction of how to make these adjustments.

Table is example of how sheet is set out.

Nominal Code IRIS TB SAGE TB Difference Debit Credit
Plant & Machinery 0020 59,311.00 9,002.00 50,309.00 50,309.00      -
Acc Dep'n Plant & Machinery 0021 (15,0044.13) (,3,904.96) (11,099.17)      - 11,099.17
Motor Vehicle's 0050 46,994.50 18,833.33 28,161.17 28,161.17     -
Bank Account 1200 (3,117.92) (125,921.98) 122,084.06 122,804.06      -
Loan 2300 (140,493.74) 806.92 (141,300.66)      - 141,300.66

I am just sat here head in hands wondering why am I doing this haha

Any help please!!!

Apologises for seeming so thick. 

Thanks

                                       

  • 0

    Hi Rebecca

    Don't worry, you are wise to seek advice.  The journals you describe are out of balance by £48,874.40, so you will need to know where to put that.  Take a look at the Suspense account 9998.  Ideally that would show a debit balance of £48,874.40 and if so you can post the journal as above, ending with a credit to 9998.  To post it, go to Nominals then Journal Entry.  Date the journal 30/6/18 - Sage will throw up a warning that it's in the wrong year but you can override that.  Sage won't let you post a journal that doesn't balance, so you are unlikely to mess things up, but it's always good practice to back up before doing anything you're not sure of.

    I'm inclined to think it might not be that simple, though, as there is a big change to your bank balance. Have you been able to reconcile the bank account? It makes me think you may have some very old transactions lurking on the bank reconciliation screen so you may need more information.

    So this isn't really an answer, it's a pointer to some where you need to be looking next.  I'm happy to help further if you want to post back on here.