Home > Tracking Your Business In Excel > How to track your business in excel part 4

How to track your business in excel part 4

The template for this web cast is available in our Learning Center for $11

This is the final chapter in the 4 part saga (with one bonus in part 2).

Here is the link to watch this web cast (Video):

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

In part 3 we were not able to get into pivot tables too deeply so I wanted to devote another web cast to that part.

We show you how to use the transaction data to run pivot tables so that you can quickly and concisely report on the data to give you really meaningful information.

If you’ve missed the first 3 parts, be sure and get caught up here:

How to track your business in excel – part 1 – http://nerdenterprises.na6.acrobat.com/p30305366/

How to track your business in excel – part 2 – http://nerdenterprises.na6.acrobat.com/p20159112/

How to track your business in excel – part 2 – Bonus – http://nerdenterprises.na6.acrobat.com/p44179111/

How to track your business in excel – part 3 – http://nerdenterprises.na6.acrobat.com/p84834671/

And this one again

How to track your business in excel – part 4 – http://nerdenterprises.na6.acrobat.com/p74667017/

The pivot tables are the key to this when it is all said and done because this is how you accomplish what any accounting system should be designed to do – take what you’ve put into it and give you something valuable that you can take out of it. This is what any system’s reporting feature is all about. You won’t be able to do a well formatted P&L and Balance sheet with this, but you can get close by running the pivot table on the transactions and then adding the destination account to the filter, then filter for all Balance sheet accounts. Keep in mind it won’t be perfect. If, for example you have payments to “Accounts Payable” then this will show up on your report, but does not represent what is “Due” in accounts payable. Instead it represents what has been “Paid” on accounts payable. So you may want to exclude that one. You can enter bills in your transaction register and then you would have an accurate payable, because the bills would go in as a negative (credit) to Accounts Payable and the payments on accounts payable would be entered as a positive number. Then you could pivot on accounts payable to get an accurate balance.

Next week we’re back on to QuickBooks so visit us there at http://www.qiuckbooksnerd.com

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: