Archive
How to track your business in excel part 3
For a better quality version of the video web cast:
http://nerdenterprises.na6.acrobat.com/p84834671/
Visit our Excel blog for more: http://www.msexcelguru.com
Here we really complete the picture for you by showing you how to enter and then report on your financial transactions.
We show you how to set up the hyperlinks so that if you expand upon this concept you will be able to incorporate any new items in the ‘Home’ or ‘Menu’ Tab.
We review the setup of a list and data validation to update the way the source account works, because that account really needs to represent sources of payments and deposits. This also makes it possible to rely on the “Destination” accounts for tracking all income, expenses, asset purchases and payments on liabilities.
Now that the template is set up we can show you how to enter your transaction data:
This is what the template looks like with everything entered. If there was a deposit to be entered the Source account would be the bank account where the money was deposited and the destination account would be the appropriate income account. This is not set up to show invoices to and payments on accounts receivable. This can be done but would have to be done on a private consult because it would be very involved.
Once we have data in we can begin to report on it. We show you in the last 3 minutes of the web cast how to create a pivot table on this data reporting on expense by category and then expanding upon that by showing you how to further report the expenses daily based on the date of the transaction.
Figure 1 – Pivot Table – Daily Expenses click for larger image
We will post a bonus web cast going into more detail on these pivot tables and how you can use them to report quickly on the information in the sales and transactions.
Have all of our video tutorials delivered right to your inbox!
Join our online community
Topics
Recent Posts
Our Sites
- Nerd Enterprises, Inc. QuickBooks, Excel, Cash Flow and Technology – these are a few of our favorite things!
- QuickBooks Blog QuickBooks Tips and Information
- Real Estate Accounting The E-Book comes out Jan 2, 2010
- Seth David's Personal blog Seth David’s Personal Blog
Monthly Archive
- June 2010 (1)
- April 2010 (1)
- March 2010 (2)
- February 2010 (1)
- January 2010 (1)
- December 2009 (3)
- November 2009 (4)
- October 2009 (1)
- September 2009 (4)
- August 2009 (3)
- July 2009 (2)
- June 2009 (2)
Twitter Updates
- I felt like I needed some rest, so I went to bed really early. Now it's 1am and I'm awake! Oops! https://t.co/vSjlphJxUv 10 hours ago
- @TotallyBookedNY Nice. Where's the new office at? 11 hours ago
- @TotallyBookedNY Life is good. How are you? 18 hours ago
- @TotallyBookedNY Yo! 19 hours ago
- @LauraSabbaghCPA Hey! How's it going? You busy? What are you doing right now? 21 hours ago