Posts with the worksheet tag

QuickBooks

Weighted Average Periodic System

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

In this presentation we will discuss the weighted average inventory method using a periodic system. The weighted average method as opposed to a first in first out or last In First Out method, the periodic system as opposed to a perpetual system. We want to keep the other systems in mind as we work through this comparing and contrasting. We’re going to be working with this worksheet entering this information here. It’s important to note that this worksheet is a worksheet that can typically be used with any of these inventory flow type problems of which there are many. We have first out last in first out the average method. And then we have a perpetual and periodic system which can be used with any of those methods. It’s also possible for questions to ask for just one component such as cost of goods sold or Indian inventory, and therefore it can seem like there’s more types of problems that we can have in that format as well. If we set up everything in a standard way, even if that weighs a little bit longer for some types of problems, it may be easier because we can just memorize that one format to set things up, this would be a format to do that.

(more…)

QuickBooks

Last In First Out LIFO Periodic

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

In this presentation we will discuss the lastin first out inventory system on a periodic basis rather than a perpetual basis. As we go through this process, we want to always be comparing those to one, the LIFO or lastin first out system to other systems such as first in first out and average, as well as comparing the perpetual system to the periodic system. We’re going to go through this by looking at a problem the problem going into a worksheet such as this, I do recommend learning this worksheet. This worksheet should look repetitive if you seen the first in first out presentation as well as presentations for the perpetual system.

(more…)

QuickBooks

First In First Out (FIFO) Periodic System

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

In this presentation we will discuss first in first out or FIFO using a periodic system as compared to a perpetual system. As we go through this, we want to keep that in mind all the time that been that we are using first in first out as opposed to some other systems lastin first out, for example, or average cost, and we’re doing so using a periodic system rather than a perpetual system. Best way to demonstrate is with examples. So we’ll go through an example problem. We’re going to be using this worksheet for our example problem. It looks like an extended worksheet or large worksheet, but it really is the best worksheet to go through in order to figure out all the components of problems that deal with these cost flow assumptions, including a first in first out lastin first out, or an average method, and using a periodic or perpetual for any of them.

(more…)

QuickBooks

Cash Journal Entries with Cash 225

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

Hello in this presentation we are going to record business transactions involving cash using debits and credits. At the end of this, we will be able to list transactions involving cash record transactions involving cash using debits and credits and explain the effect of transactions on assets, liabilities, equity, revenue, expenses and net income. We’re going to record these transactions on the left hand side in accordance with our thought process. We’re then going to post them to a worksheet format, not necessarily or in this case, not a general ledger. But in a similar way, we will post it to this worksheet in order to see what is happening to each of these accounts individually as well as the groups of accounts in terms of assets, liabilities, equity, revenue and expenses, notes the order of the trial balance, always in the order of acids in this case in green liabilities in orange, and then we have the equity and revenue and expenses, the income statement accounts and net income at the bottom calculated as revenue minus expenses.

(more…)