Part 1 - Continue studying Tutorials 3-6.

Retake the quizzes until you have  a good handle on them.

________________________________________________

Part 2 - Analyze and Record Joe Potter's Transactions

Attached is an Excel Workbook with 2 worksheets.  The first is a list of transactions and the accounts affected by those transactions.  The second has a list of detail accounts and T accounts set up for each. The T accounts have the existing transactions listed.

Your first task for the week is to verify that the entries are correct and then confirm that the totaled transactions will balance when brought back to the accounting equation.

On Thursday evening I will add new entries to the list of transactions and you will spread them to their  T accounts and recheck the balances after you've finished. We will discuss this in our chat session on Sunday

For those of you who do not have Excel, I have converted the file to pdf format so you can print it out and fill it in by hand.  If you copy the Excel file to to your computer, I believe you can open and work on it online, using a google docs spreadsheet. It would be great if one of you could do that and then reply with the steps to do that. 

 

I know it will be very foolish to have a chat session next Sunday, but we are known to be foolhardy sometimes.


Note the 2 files place here on Monday have been removed and replaced with these two updated and improved versions. If you use excel or google docs the T accounts will automatically recalculate their balances. The Account numbers are now expanded to give you room to add your own account numbers in the appropriate range.

------------------------------------------------------------------------------------

Note as of Friday evening 3/30/2012 11:10 EDT the files attached below (C6P group corrected trxs) have the transactions through number 17 all clarified, corrected and balanced to the accounting equation which is included as a final page. This would be the best version to use to complete the transactions listed for the week without having to search for the errors that I made in the earlier versions.  :-) You might have to create a T-account to accomodate one of the transactions. If you are using Excel or google docs, just copy the whole range of an appropriate T-account and paste it to a blank area of the page.  Then change the account number, account name, and delete any existing transactions.  Test with a couple debits and credits to make sure the formulas are working correctly.

Views: 170

Attachments:

Replies to This Discussion

Google docs is a free online application that works very much like Microsoft Office.  You need to set up a google ID for yourself (It works for many google processes and can be used to sign in to third party online activities as well.) Once you have your ID, just go to the google docs home page and click the 'Create' button, then the Spreadsheet icon.  Once the blank spreadsheet grid is displayed click the 'File' menu then 'Import'. With the 'Create new' spreadsheet radio button selected click the 'Choose file' button.  Navigate to the excel file you want to open and click 'Open'.  The file will open in the online application and is completely usable.  It saves every change you make, and is available to you from anywhere where you have an internet connection. Totally cool!

George you'er the best!

Thanks for taking the time and making it easy for me to understand.

I am reading and rereading, I am determined to complete this and understand it.

Thanks,

Troy

Don't let all of the work involved in what we have already done along with the work of posting to journals, then general ledger scare you.  You don't have to do all that with a computer accounting system. Most entries will only be made once by hand to get a transaction into the system. Some will just involve verifying  which accounts the computer should debit or credit as it imports new kinds of transactions directly from bank accounts or from uploaded statements.

You may find the T-accounts a very easy way to consolidate activity for one account at a time.

What a brain cruncher. If I had only known what I was getting into I would have stayed in my corner!

Have no fear.  It is going to get a lot easier when we start using the accounting software. And you will know what is happening behind the curtain.

Attached are the ending files for this week's exercises.  The chat session that discusses the exercise is listed as a separate discussion. Those who participated had a good grasp of debiting and crediting transactions to the proper accounts. 

Attachments:

RSS

Videos

  • Add Videos
  • View All

Use These Links to Support Us

Low cost flat lapping disc can be used on you potters wheel if you, drill bat pin holes in it, and provide a trickle of water to cool it. At amazon.com, 120 grit for aggressive material removal. Click the image to purchase 

Members have had great things to say about John Britt's new book, Mid-Range Glazes. Click the image to buy from Amazon.com

Purchase Glazes Cone 6 by Michael Bailey, The Potters Book of Glaze Recipes by Emmanuel Cooper, or Making Marks by Robin Hopper, all available at amazon.comMastering Cone 6 Glazes by John Hesselberth & Ron Roy is now out of print.

Harbor Freight is a great place to find unbeatable prices for better HVLP spray guns with stainless steel parts and serviceable economy models, as well as detail guns, all tested by our members for spraying glazes, as well as compressors to power the guns. As yet no one has tested and commented on the remarkably inexpensive air brushes at harbor freight.

The critter siphon gun is a spray alternative that is well liked by some of our members, and is available at amazon.

Amazon is also a competitive source for photo light tents for shooting professional quality pictures of your work. They also have the EZ Cube brand favored by several of our members. You might also want to purchase the book Photographing Arts, Crafts and Collectibles . . .

If you are up to creating videos of your work or techniques you might want to invest in a flip video camera

Following are a few scales useful for potters. Your final price could be less or more - things change.

American Weigh Black Blade Digital Scale, 1000g X 0.1g $11.08 

For the non-digitally inclined the old standard Ohaus Triple Pro Mechanical Triple Beam Balance, 2610g x 0.1g, with Tare $169.00

And finally a low cost clone of the OHaus. The Adam Equipment TBB2610T Triple Beam Mechanical Balance With Tare Beam $99.62

ebay is a great alternative for many tools and the equipment used in the ceramics studio - kilns, wheels, extruders, slab rollers are often listed there both new and used.

Tips for Members

If you just want to spout off, it is best accomplished as a blog posting. If you want to get more guidance and ideas from other members, ask a question as a new discussion topic. In the upper right corner of the lists for both types of posting, you will find an "+Add " button. Clicking it will open an editor where you create your posting. 4/16/2014

© 2021   Created by George Lewter.   Powered by

Badges  |  Report an Issue  |  Terms of Service