Agility by Design - eprentise Blog

Basic Accounting for IT - Part II

PDFPrintE-mail

This is the second in a series of articles designed to help the more technical people understand the business. They are intended as general reference material. A copy of the first article, Basics of Accounting: General Ledger and Account Types, can be found here.

Closing the books is the process that a corporation uses to reconcile, consolidate, and report financial information on a periodic basis. The process usually involves the transfer of account balances from nominal (or temporary) accounts to real (or permanent) accounts and generally involves five steps: 

  1. Closing each of the subledger modules (such as accounts payable or accounts receivable) and posting the detailed transaction information from each module to the general ledger (for more information on the general ledger, please see Basics of Accounting: General Ledger and Account Types).
  2. Running trial balance reports to confirm that transactions from all modules have been posted correctly.
  3. Reconciling to the general ledger and making adjusting entries.
  4. Posting all adjusting entries to the general ledger.
  5. Running standard financial reports.

As we noted in Basics of Accounting: General Ledger and Account Types, transactions create either a debit or a credit entry to an account depending on the type of transaction made. Furthermore, debits and credits are treated differently depending on the type of account the transaction is posted to. The following table outlines some common accounts found on financial statements and how they are treated.

 

Basic Accounting for IT - Part I

PDFPrintE-mail

This is the first in a series of articles designed to help the more technical people understand the business. They are intended as general reference material.

The general ledger (GL) is the repository and reporting vehicle for all financial subledger transactions. Subledgers include the Oracle Applications modules such as: Accounts Payable (AP), Accounts Receivable (AR), Order Management (OE), Human Resources (HR), Inventory (INV), etc.

A general ledger stores a transaction as either a debit or a credit. Debits and credits perform different functions depending on the account types of the different transactions. There are five account types that are set up in Oracle Applications for the natural account segment of the accounting flexfield:

Asset: Assets are things of value used by a business and its operations and are usually classified as either tangible (cash, receivables, land, etc.) or intangible (patents, copyrights, and other nonphysical rights). A debit increases assets, while a credit decreases assets.

Liability: Liabilities are existing debts and obligations such a wages payable, mortgage taxes payable, and real estate taxes payable. Such obligations are generally termed accounts payable. A debit decreases liabilities, while a credit increases liabilities.

Revenue: Revenues are cash or other asset inflows to the business. However, revenues may take the form of a decrease in a liability as well as the increase in an asset. Sales, services, and royalties are examples of common forms of revenue. A debit decreases revenue, while a credit increases revenue.

Expense: Expense is the cost of assets consumed or services used in the process of earning revenue, and they can represent actual or expected outflows. Common expense accounts include wages, rent, and interest expense. A debit increase expenses, while a credit increases expenses.

Owner’s Equity: Owner’s equity is equal to total assets minus total liabilities. When an investment is made in a business, capital and owner’s equity are increased. If an owner withdraws money from a business, total owner’s equity is decreased. A debit decreases owner’s equity, while a credit increases owner’s equity.

Basic Accounting Chart 

   

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Enter your email address to sign up for our Newsletter

Sign up now

captcha
TEChanges - Agility by Design

May Puzzle

David is often referred to as Rainman due to his peculiar ability to effortlessly figure out a certain date's day of the week. He recently displayed this talent when I asked him if there was a conflict with the upcoming Fuzzy Dice Conference and our weekly court-ordered community service. He asked the date of the convention. It was April 20th, 2012.

"Oh, that’s a Friday," he said, effortlessly. "And your sentences have you committed for the next few dozen Wednesdays so you'll be able to go." And of course he was right.

One day a few weeks ago I asked out loud in the office about the date June 5th. And of all people, my brother Tommy piped up and said "Oh, that's a Tuesday."

"That's right," said David.

Well how about Otcober 3rd?

"That's a Wednesday," said Tommy. Then I asked about Christmas Day 2012.

"Oh, that's a Tuesday." David nodded in agreement.

Do we now have two rainmen? Or had Tommy figured something out?

Show solution...

Solution

Here's what was going on. Tommy was using something called anchor dates. And these dates apply to each and every year. April 4th, or 4/4 we’ll call it from now on, June 6th or 6/6, 8/8, 10/10, 12/12, are all the same day of the week, each and every year.

So too are 5/9 and 9/5, May 9th and September 5th. So too are 7/11 and 11/7, and all the above dates are the same day of the week, as is the last day in February, Leap Year or not. And they’re all the same day as January 4th, it would otherwise be January 3rd, but this was a leap year, and that’s changes the anchor day from January 3rd to January 4th.

Tommy also knew that New Year's Day was a Sunday. He was sobered up by then. And he knew it was a Sunday because Christmas was a Sunday in 2011, so New Year's Day is a Sunday, so the Anchor Day for 2012, January 4th, has to be a Wednesday!

So if that's a Wednesday, then 4/4, 6/6, 8/8, 10/10, 12/12, 5/9, 9/5, 7/11, 11/7, and February 29th are all the same day of the week, and they're all Wednesdays. So when I ask for example, about October 3rd, he knew October 10th was a Wednesday, 10/10. So 10/3 must also be a Wednesday. 12/12 is a Wednesday in 2012, so it’s 12/26, which is two weeks later. So 12/25, or Christmas Day, must be a Tuesday.

Success Tips for Oracle Project Management

  • Create a standard for documentation at the beginning of your project, and hold team members accountable for completing documentation requirements as well as keeping them at and above the standards required.
  • Before promulgating user documentation or training, it’s also a good idea to choose a representative from the among the business users base to review materials first.
  • If you are not sure about the resources and budget required, obtain several estimates from people that have experience with the same size and scope of your project.
  • Be explicit, before beginning the project, what internal resources are required for execution. This includes people, infrastructure, hardware, and software.
  • Help the project champion understand the impact your project will have on the organization and how its successful completion will make him or her an internal hero or heroine for supporting it.
  • Break up your project into smaller projects (try for projects that can be completed in 4-6 months, especially early on) to get success and demonstrate momentum.
  • Make sure that your testing includes reports, upstream and downstream interfaces, customizations, enhancements, and workflows.
  • Ensure that comprehensive transition reports and meetings between departing and incoming personnel are completed.
  • Instead of spending time and resources implementing third-party reporting, consider consolidating multiple instances, moving to a global chart of accounts (CoA), and/or standardizing on a consistent calendar.
  • Include governance, risk, and compliance management as part of the project plan.
  • Finally, celebrate the successes. Too many projects focus on defects, failures, or small cost over-runs without looking at the big picture and what was accomplished.

The Analyst Corner

John Van Decker, Research VP of Gartner, states:

"A single chart of accounts allows consistency in financial reporting across the enterprise by standardizing on common metrics and reporting structures, reduces dependencies on a separate financial consolidation system, and significantly reduces the costs incurred with ongoing, complex conversions and translations."