Homework You Downloaded GNUCASH correct? Name your file YourName - - PowerPoint PPT Presentation

homework you downloaded gnucash correct name your file
SMART_READER_LITE
LIVE PREVIEW

Homework You Downloaded GNUCASH correct? Name your file YourName - - PowerPoint PPT Presentation

Homework You Downloaded GNUCASH correct? Name your file YourName MBUS3000. Create a special Folder for this file on your desktop or someplace convenient. The program will generate lots of automatic backup files so it creates a lof of debris.


slide-1
SLIDE 1

Homework You Downloaded GNUCASH correct? Name your file YourNameMBUS3000. Create a special Folder for this file on your desktop or someplace convenient. The program will generate lots of automatic backup files so it creates a lof of debris. Your are going to be creating a chart of accounts for my two son’s band

  • dEaDbUg. Their names are Robert and Frank. Their drummer is named Max.

from here on out when i’m referring to these names i am talking about the members of dEaDbUg.

Thursday, March 20, 14

slide-2
SLIDE 2

Assets = Liabilities + Equity.

Thursday, March 20, 14

slide-3
SLIDE 3

Thursday, March 20, 14

slide-4
SLIDE 4

Thursday, March 20, 14

slide-5
SLIDE 5

Thursday, March 20, 14

slide-6
SLIDE 6

Thursday, March 20, 14

slide-7
SLIDE 7

Thursday, March 20, 14

slide-8
SLIDE 8

Thursday, March 20, 14

slide-9
SLIDE 9

Thursday, March 20, 14

slide-10
SLIDE 10

Thursday, March 20, 14

slide-11
SLIDE 11

Thursday, March 20, 14

slide-12
SLIDE 12

Thursday, March 20, 14

slide-13
SLIDE 13

Thursday, March 20, 14

slide-14
SLIDE 14

GNUCASH You are going to set up the Capital Accounts for each of the members of the band dEaDbUg Caplital accounts or Equity accounts (same thing) represent the owners financial interest in the business In particular this is where you record the owners money into and out of the business. Capital contributions and capital distributions. dEaDbUg has 3 owners. Robert, Frank and Max. when they formed the band they each contributed $100 dollars each. They deposited this money into their Athens First Bank account. You must first create 3 sub- accounts under equity. these will also have subaccounts under them. So be sure to checkt he “placeholder box.” Robert Capital Account Frank Capital Account Max Capital Account Under each of these accounts create 3 more accounts EG under Robert Capital Account create these three subaccounts Robert Capital Robert Contributions Robert Distributions. Do this for each to the partners see slides.

Thursday, March 20, 14

slide-15
SLIDE 15

Thursday, March 20, 14

slide-16
SLIDE 16

Thursday, March 20, 14

slide-17
SLIDE 17

Thursday, March 20, 14

slide-18
SLIDE 18

Thursday, March 20, 14

slide-19
SLIDE 19

Thursday, March 20, 14

slide-20
SLIDE 20

Thursday, March 20, 14

slide-21
SLIDE 21

Thursday, March 20, 14

slide-22
SLIDE 22

Thursday, March 20, 14

slide-23
SLIDE 23

Thursday, March 20, 14

slide-24
SLIDE 24

Thursday, March 20, 14

slide-25
SLIDE 25

Thursday, March 20, 14

slide-26
SLIDE 26

Repeat this for each of the partners

Thursday, March 20, 14

slide-27
SLIDE 27

Thursday, March 20, 14

slide-28
SLIDE 28

Now record each members contribution Assets = Liabilities + Equity Frank contributes $100 double click on frank contributions 100 dollars into the checking account (assets). The “transfer” account is Assets:Current Assets: Checking Account Assets (+100 in checking) = Liabilities ($0) + Equity( +100 in Frank Contributions) Do the same for Robert and Max. see slides.

Thursday, March 20, 14

slide-29
SLIDE 29

Oh and while we are at it change the description of th bank account to it’s proper name Athens First Bank and Trust. Click once on the checking account so it’s highlighted. then clicke the edit button on bar above.

Thursday, March 20, 14

slide-30
SLIDE 30

Thursday, March 20, 14

slide-31
SLIDE 31

Thursday, March 20, 14

slide-32
SLIDE 32

Thursday, March 20, 14

slide-33
SLIDE 33

Thursday, March 20, 14

slide-34
SLIDE 34

Thursday, March 20, 14

slide-35
SLIDE 35

Thursday, March 20, 14

slide-36
SLIDE 36

Thursday, March 20, 14

slide-37
SLIDE 37

Thursday, March 20, 14

slide-38
SLIDE 38

Thursday, March 20, 14

slide-39
SLIDE 39

Thursday, March 20, 14

slide-40
SLIDE 40

Thursday, March 20, 14

slide-41
SLIDE 41

Thursday, March 20, 14

slide-42
SLIDE 42

Gnucash. The band dEaDbUg borrows $10,000 from athens first to buy van right now they just deposit in checking. due 2/5

Thursday, March 20, 14

slide-43
SLIDE 43

Thursday, March 20, 14

slide-44
SLIDE 44

Thursday, March 20, 14

slide-45
SLIDE 45

Thursday, March 20, 14

slide-46
SLIDE 46

Thursday, March 20, 14

slide-47
SLIDE 47

Thursday, March 20, 14

slide-48
SLIDE 48

Thursday, March 20, 14

slide-49
SLIDE 49

Thursday, March 20, 14

slide-50
SLIDE 50

Thursday, March 20, 14

slide-51
SLIDE 51

Gnucash new accounts 2004 E-150 Van-Asset/Fixed Asset/Vehicles Petty Cash-Asset/Current Assets/Petty Cash Buy Van from athens Ford $9,000 from checking Take $100 from checking and put in petty cash

Thursday, March 20, 14

slide-52
SLIDE 52

Thursday, March 20, 14

slide-53
SLIDE 53

Thursday, March 20, 14

slide-54
SLIDE 54

Thursday, March 20, 14

slide-55
SLIDE 55

Thursday, March 20, 14

slide-56
SLIDE 56

Thursday, March 20, 14

slide-57
SLIDE 57

Thursday, March 20, 14

slide-58
SLIDE 58

Thursday, March 20, 14

slide-59
SLIDE 59

Thursday, March 20, 14

slide-60
SLIDE 60

Thursday, March 20, 14

slide-61
SLIDE 61

Thursday, March 20, 14

slide-62
SLIDE 62

now create some income and expense accounts

Performance Fees : Income/Performance fees Merchandise Sales- Retail: Placeholder account Income/Merchandise Sales- Retail Music CDs Vinyl Downloads: Income/Merchandise Sales-Retail/ Music CDs... Softgoods: Income/Merchandise Sales-Retail/ Softgoods expenses Touring/Performance Costs: Placeholder Expense/Touring Performance Costs ALL UNDER TOURING AND PERFORMANCE COSTS Fuel: Expense/Touring Performance Costs/Fuel Tolls and Parking: Expense/Touring Performance Costs/Toll and Parking Vehicle Repair and Maintenance: (you get the idea) Travel and Lodging: Per Diems: Supplies-Tour/Performance:

Thursday, March 20, 14

slide-63
SLIDE 63

Thursday, March 20, 14

slide-64
SLIDE 64

Thursday, March 20, 14

slide-65
SLIDE 65

First you need to add the following accounts

Expense: Commission - Management Expense: Commission- Agent Expenses: Touring Performance costs: Van Depreciation

Thursday, March 20, 14

slide-66
SLIDE 66

dEaDbUg goes on tour

The band goes to on tour. They play three shows feb 16 at the covered dish in gainesville florida, feb 17 at the Jinx in Savannah Georgia and feb 18th at Sky City in Augusta GA. Here are there expenses. All of these need to be in the petty cash ledger.

Thursday, March 20, 14

slide-67
SLIDE 67

Checking Ledger

Agent and Manager must be paid. The tour grossed $1500 The manager Red Light Management gets 15% or $225 The Agency High Road Touring gets 10% or $150 write checks for them

Thursday, March 20, 14

slide-68
SLIDE 68

Fixed Asset 2004 Van Ledger

But now we have to make an adjustment for depreciation. That is we “used up” some of the vans available life. For now don’t worry about how I calculated this.. but for this trip it’s $116.40

This is not the “correct” way to record this. But i do something very similar to keep track of our true touring profit. This is the way the band keeps track of money. The accountant has a different more professional and “correct” set of books. Two sets of books? isn’t that illegal? Well yes if you’re trying to cheat someone. But no. Most business small business operators are not accountants yet they have to do the day to day accounting. Oftentimes the accountant creates a simpler system for the business operators to

  • use. Then on a regular basis, weekly, monthly or at the end of each tour, the accountant takes the business operators books and translates it

into their more professional form that will satisfy other accountants, lawyers and especially the tax authorities. What good is accounting if the business operators don’t understand? Can’t make rational decisions about their company?

Thursday, March 20, 14

slide-69
SLIDE 69

What are the hidden costs? how often can you drive the van this far?

Thursday, March 20, 14

slide-70
SLIDE 70

Thursday, March 20, 14

slide-71
SLIDE 71

Create these new accounts. Assets: Current Assets: Agency Escrow Account Liabilities:Current Liabilities: Credit Cards:Chase Visa Credit Card Liabilities:Current Liabilities: Unearned Revenue: Unearned Perf Fees

Thursday, March 20, 14

slide-72
SLIDE 72

Thursday, March 20, 14

slide-73
SLIDE 73

Thursday, March 20, 14

slide-74
SLIDE 74

Thursday, March 20, 14

slide-75
SLIDE 75

Thursday, March 20, 14

slide-76
SLIDE 76
  • Thursday, March 20, 14
slide-77
SLIDE 77

Thursday, March 20, 14

slide-78
SLIDE 78

Create these new accounts. Assets: Current Assets: Agency Escrow Account Liabilities:Current Liabilities: Credit Cards:Chase Visa Credit Card Liabilities:Current Liabilities: Unearned Revenue: Unearned Perf Fees

Thursday, March 20, 14

slide-79
SLIDE 79

Thursday, March 20, 14

slide-80
SLIDE 80

Thursday, March 20, 14

slide-81
SLIDE 81

Thursday, March 20, 14

slide-82
SLIDE 82

Thursday, March 20, 14

slide-83
SLIDE 83
  • Thursday, March 20, 14
slide-84
SLIDE 84

Thursday, March 20, 14

slide-85
SLIDE 85

Principal reduces liability Interest is an expense.

In order to do this problem you must compute loan amortization schedule just as I’ve been showing New expense account Expenses: Interest expense Add a loan payment to checking account $327.39 (hint loan amout) “Split” between long term liabilities vehicle loan and Expense: Interest Expense

Homework

Thursday, March 20, 14

slide-86
SLIDE 86

Thursday, March 20, 14

slide-87
SLIDE 87

Thursday, March 20, 14

slide-88
SLIDE 88
  • Thursday, March 20, 14
slide-89
SLIDE 89
  • Thursday, March 20, 14
slide-90
SLIDE 90

Gnucash more touring turning unearned income into “real” income using the agency escrow account due march 6

Thursday, March 20, 14

slide-91
SLIDE 91

The band tours to Birmingham alabama then Atlanta feb 24-26 From Petty Cash 2/24 per diems of $25 frank suttree and robert 2/24 $250 cash from bottle tree 2/25 per diems of $25 frank suttree and robert 2/25 $250 cash from the earl

Thursday, March 20, 14

slide-92
SLIDE 92

Credit card expenses

2/24 Fuel Cheveron Birmingham AL $65 2/24 Courtyard Marriot Birmingham AL $84.10 2/26 Quik Stop Duluth GA $75

Thursday, March 20, 14

slide-93
SLIDE 93

Convert Unearned Income Liability to income. Open unearned per fees ledger

Thursday, March 20, 14

slide-94
SLIDE 94

2/26 Pay manager 15% checking account 15% of $1000 why aren’t we paying agent?

Thursday, March 20, 14

slide-95
SLIDE 95

2/27 High Road (agent) emails escrow statement wires $400 to check account

2/22 The Bottle Tree deposit received $250 2/22 The Earl deposit recieved $250 2/24 The Bottle Tree commission -$50 2/25 The Earl commision -$50 2/27 Net to artist $400

Thursday, March 20, 14

slide-96
SLIDE 96

Finally record the van depreciation approx 438 miles $65

Thursday, March 20, 14

slide-97
SLIDE 97
  • Thursday, March 20, 14
slide-98
SLIDE 98
  • Thursday, March 20, 14
slide-99
SLIDE 99

Gnucash Inventory really requires a separate inventory program

  • r sub module.

however we are only gonna have a small amount of inventory and separate items.

Thursday, March 20, 14

slide-100
SLIDE 100

dEaDbUg orders 50 t- shirts from satisfactory

  • merchandise. the total is $300 dollars.

paid with check 1004. Shipping from UPS is 25 dollars paid with check 1005 Need to keep track of the fact these shirts cost $325/50 or $6.5 each Cost of Goods Sold Things you buy to sale later have to be carried as asset until sold. you expense them when it’s sold.

Thursday, March 20, 14

slide-101
SLIDE 101

Thursday, March 20, 14

slide-102
SLIDE 102

Thursday, March 20, 14

slide-103
SLIDE 103

Thursday, March 20, 14

slide-104
SLIDE 104

Thursday, March 20, 14

slide-105
SLIDE 105

Thursday, March 20, 14

slide-106
SLIDE 106

Thursday, March 20, 14

slide-107
SLIDE 107

Thursday, March 20, 14

slide-108
SLIDE 108

Thursday, March 20, 14

slide-109
SLIDE 109

Now dEaDbUg plays house party in Athens They sell 15 shirts at $15 dollars each

  • r $225 cash.

Thursday, March 20, 14

slide-110
SLIDE 110

Thursday, March 20, 14

slide-111
SLIDE 111

Now we have to account for the decrease in value of inventory of t-shirts We also need to account for the cost of those 15 shirts. 15 shirts cost of goods was $6.5 x 15 = $97.5 Why do we do it this way? for tax purposes and other reasons you can not expense the cost of the shirts until they are sold.

  • pen inventory soft good ledger

Thursday, March 20, 14

slide-112
SLIDE 112

Thursday, March 20, 14

slide-113
SLIDE 113

Thursday, March 20, 14

slide-114
SLIDE 114
  • Thursday, March 20, 14
slide-115
SLIDE 115

Thursday, March 20, 14