extended Trial Balance

wilson2008
wilson2008 Registered Posts: 2 New contributor 🐸
in AAT student discussion
could anyone please forward me an excel Format of the Extended Balance?

Comments

  • wilson2008
    wilson2008 Registered Posts: 2 New contributor 🐸
    extended trial balance

    please forwardmea copy of the EXTENDED TRIAL BALANCE - EXCEL FORMAT,
    wilsona@cmsnetwork.com
  • coocoocadgoo
    coocoocadgoo Registered Posts: 39 Regular contributor ⭐
    wilson2008 wrote: »
    please forwardmea copy of the EXTENDED TRIAL BALANCE - EXCEL FORMAT,
    wilsona@cmsnetwork.com

    Hi Wilson,
    It's fairly easy to do one on excel yourself - just copy one that you have in your textbook?!? The formulae are easy - it's just adding up columns.
    Good luck,
    Erin
  • Shortbread64
    Shortbread64 Registered Posts: 8 New contributor 🐸
    Extended Trial Balance

    With depreciation in the extended trial balance I am a bit unsure of where to put it. The b/f figure is a CR as say £300. Then there is the adjustment figure of £450 in the CR. Then this all goes into the Balance sheet as £750 as a CR. Then the P & L is DR of £450. What happens to the £300 on the DR side? Does it go on as a CR also on the P & L? As my ETB is out by £450 on the CR side on the P & L

Categories

Privacy Policy