Tutorial: Create a P & L from monthly balances with a pivot table

David Carter's previous AccountingWEB pivot table tutorials show you how to create pivot tables from accounting transactions exported into Excel. However, you can also create pivot tables out of monthly balances. This tutorial shows you how.

Prior to this tutorial you have exported a Trial Balance report out of your accounts package into Excel.

To read the rest of the article you'll need to log in below

If you've forgotten your details click here for a reminder.

If you haven't got an account, it's free to set up and only takes a minute,
click here to register

1 comment

Create your free account

  • Access all articles in full
  • View multimedia
  • Receive email bulletins
  • Private messaging
Register now

Login

Forgotten your password?

Any Answers theme of the month

Latest questions on
Preparing for 2010/11
- payroll & tax planning advice:

Overseas director and PAYE / NIC

Directors and NIC

P46(Car) - what are the rules?

No PAYE scheme but P11d may be needed

IT Zone today

Apple iPhoneGadget blog
Latest news from CES

Snow strategy:
Work remotely

SA songs
Listen to our Spotify list!
 

Download library

Free downloads
Check out our library of podcasts and tutorials.