Archive

Posts Tagged ‘transactions’

How to Track Your Business in MS Excel Part 2

November 11, 2009 1 comment

Click here to watch the webcast:

http://nerdenterprises.na6.acrobat.com/p20159112/

Bonus Web Cast (Too Long For YouTube) setting up your accounts:

http://nerdenterprises.na6.acrobat.com/p44179111/

MS Excel Info: http://www.msexcelguru.com (you’re here already)

QuickBooks Info: http://www.quickbooksnerd.com

In this part we show you how to set up your transaction register and show you how to set up your lists and then validate your Columns in your transaction register so you have drop-downs to choose from in your transaction register. There are two columns for accounts. In accounting terms it’s because every transaction needs a debit and a credit. In lay-person’s terms you need a source account and a destination account as shown here:

The source account is essentially how I paid for something (ie Bank account or Credit Card) or if I received money, which bank account that money went into (which bank account).

The destination account is where the money went or what the money went to pay for (ie office supplies, equipment, etc..)

We are going to show you how to set up lists in this web cast.

After that you will learn how to use those lists to populate drop-downs in the Excel Template.

It is important wherever possible to limit data entry to information that is populated in pre-set lists to ensure consistency. Eventually we want to run filters and pivot tables on the data and if there are variations on spellings this will take extra time in order to clean up for proper and accurate reporting.

In the next web cast we will begin to create some pivot tables and you will be able to see how powerful this is in terms of being able to use a simple template like this one created in Microsoft Excel to track your financial accounting information.

For a bonus web cast showing you how to set up your “Account List” click here:

http://nerdenterprises.na6.acrobat.com/p44179111/

This is too long for YouTube! Sorry

Advertisements