I'd like to see two things come out of this thread. 1. give people a chance to share what they do so people can read and learn about an important business skill, and 2. try to improve the practices of independent game designers in this regard.

One of my gaming mentors, Steve Lortz (Quacktica) used to work for Dave Arneson back in the 70's and 80's. Oneof his skills was book keeping. His vantage point on the hobby allowed him to see how people were doing business back then. For the most part is was pretty sad. When a game seller tried to get him to invest in his venture - Steve looked at the books and then got the guy to hire him as a consultant to put the books in order. Once that was done the game seller learned that he was losing money every time he sold his most popular game!

Okay - the point of that story is that knowing where your money is going is VERY important. When I first thought to publish Matrix Games (in 1995) I realized that I knew knothing about this skill and that I should study it before I did more. I didn't want to be seen as non-professional or get a bad rep as a dishonest or incompetent businessman. So I studied and here is what I learned.

1. Most people ignore their finances. At best they throw their reciepts in a bag and never look at them. They dread the whole topic. This does not bode well for their business success.

2. Some people write down their information in their check book and balance it each month. This is better than 1. but doesn't tell them what is going on inside their business.

3. People who have heard of accounting and think that it is probably important, go to office supply stores and buy a "Dome Guide". This is "single entery accounting". In effect it is a glorified check book. Each transaction (a sale, or purchase) is recorded in a single account. Accounts are based on catagories like rent, book sales, utilities, entertainment, gas, etc. The columns are added up once a month and put onto a summary page in the Dome Guide so that you keep a running total an how much is coming in and going out. I used this method when I ran my psychotherapy practice back in the 90's. You can do it if you are a sole proprietor. The draw back is that if you mess up the math it is hard to spot the error later.

4. Few people use "double entery accounting". They teach it in business school. If you want to incorporate you have to use it. Basically you take each reciept (a purchase or sales slip and any other business papers you have) and record them in a journal. Each entry is made in two columns. The amount is the same in both columns (so the double enteries balance). So if I pay for materials my asset - materials goes up and my asset cash goes down. If I buy gas my expense- gas goes up and my asset cash goes down. If I sell a book cash goes up and income goes up, and my cost of sale goes up and my book inventory goes down. So you can see that this allows you to see what is going on inside your business. It's a bit complicated to learn but once you know it it is like playing a game in itself.

Okay - so don't just chime in and say how you do accounting! Say how you do it and why you do it that way. This will show a wide range of knowledge levels and (if you read what people say about "why") you'll see how people improved their skills.

I'll start...

I use double entry book keeping. In 95 I was in the "throw it in a bag" group and knew that wouldn't work. I needed to be able to accurately track my cost of sale so I'd know if I was losing money each sale! In the late 90's I had a private practice in which I used single entery book keeping. I read on double entery accounting but honestly it scared me. Doing the data entery was emotionally draining. It took many years of exposure and practice to become used to it. For a while my wife and I sold use books at SCA events (if gaming is not an industry - the SCA is not a market!) which taught me how to price books. As I've written before I do my own printing so I needed to track costs of materials as well as cost of books. There is a LOT more for me to learn but I can now understand my tax form and I know why I'm not making any money!

So lets here what other publishers are doing and why.

Chris Engle
Hamster Press

Thank you for posting this! :c)

I had not considered much about this since I'm still in the early stages of game development and there's a lot of stuff to go through yet before I even consider publishing. Funny thing for me is, I work currently as a Hotel's Night Auditor, and have to balance the books every night. The hotel I work for has no computers so I do it all by hand, in double entry format, which is precisely the method you are talking about. I just never knew the name for it. So the instant you mentioned it and explained it, it became crystal clear why I was doing this method for the hotel.

I can vouch for the wisdom here. It's very easy to do and to set up, but it's a bit tedious at times. Lord knows I've played "hunt the penny" for hours when reciepts don't match the totals I have, and you must figure them out, especially if some day you're going to be audited... and all businesses get audited. The more slop you allow in your books, the faster you end up losing money, or get cheated, or worse get in trouble with the law. Also, the more people involved in your venture, the more critical it is to track all of this.

So, yes indeedy! This is such a crucial skill. Even if you use this, you still need to file things in multiple folders, or in the case of my hotel, our "box archive" where they at least have things bundled and broken down by month and year. But if you get a ticked off retailer or customer who suddenly claims you cheated them, you can quickly find out who's right financially. And if you're dealing in credits to retailers, you have a papertrail to back up your claims for them owing you money if they contest your charges. (trust me, it happens more often than you think) :::rolls eyes:::

Once again, thank you for posting this wonderful little thread. I only hope that I added something of value to this advice that will save people a TON of trouble and keep them out of court, be it bankruptcy, small claims, civil or criminal. ;c)

Now, if I can only follow my own advice... ;c)

I use Quicken to track everything. It fakes its way through double entry book keeping by using an accounts (balance sheet items) and categories (income statement items). It also lets you assign a user defined class to each transaction which I use to identify each transaction by product line or general company expenses.

What's nice is you can set up the categories to match the Schedule C categories for Sole Proprietorship taxes so it becomes pretty easy to fill that out. What's also nice is that you don't really need to get a seperate business account. I can run all of my transactions through my normal personal checking account and credit cards and just sort them all out in Quicken by what category I assign it to.

IMO any computer savvy financially responsible person should make a point to use quicken (or similar) for their own personal finances whether they own a business or not. Its a pretty powerful tool.


Inventory is another matter entirely and a crucially important one. I have a feeling that many Indie Publishers run afoul of the Inventory related tax rules.

In a nut shell you can expense your office supplies. You can expense your GenCon fees. You can expense (usually) 50% of your travel and entertainment. But you CAN'T expense printing costs. Since printing costs are often the biggest expense Indie Publishers will have, doing this wrong can really screw you up.

Basically you can only expense your printing costs on a unit by unit basis AFTER the unit sells. So if you print 1000 copies for $6.00 apiece you've spent $6000. But you CAN'T write off a $6000 expense on your taxes. Rather you have to track an Inventory Account which starts with $6000 in it. If you then sell 400 copies of your game you reduce your inventory by $2400 (400 * $6). Your inventory is now $3600. On your schedule C you have to fill out your beginning and ending Inventory and the difference (the $2400) is your Cost of Goods sold. THAT'S what you actually get to deduct on your tax return. Next year your Inventory starts at $3600 and you repeat the process. When you print a supplement you increase your Inventory account by those printing expenses and as you sell either product you reduce your Inventory accordingly. Filling out the little worksheet on the tax return will tell you how much your Cost of Goods Sold is for the next year, and so on.

Clearly this requires a pretty dilligent tracking of Inventory. Not just sales but also promo copies, damaged copies, etc (all of which reduce your Inventory level and thus increase your deduction). If your beginning Inventory Balance on your tax return doesn't match your ending balance on the prior year's tax return you're in trouble. So you better keep good records.

I track my inventory on an Excel Spreadsheet. Its a little kludgy but its worked so far, and its saved me from having to invest in a more powerful accounting package like Quick Books.

I have a copy of Quick Books but don't use it (it goes back to that fear of data entery thing). As I understand it though Quick Books uses double entery book keeping but you don't see it. It works well for retail stores since is tracks inventory based on what you paid for it. If you are getting your printing done POD or by a regular printer this should work. If you manufacter though it falls flat. Since most people aren't doing this (I'm just weird that way) this shouldn't be a problem.

Right now I do my books on paper but this can't continue forever. I may switch to Excel as a transitional step to a better program.

I've done transitional steps a lot over the years. Progress not perfection!

***

This printing cost - not expense - is an odd notion to people who don't know about this.

I start off with cash - an asset - I buy paper - a asset I can turn into books - I print books which converts the asset paper into the asset book inventory - then (hopefully!) I sell the book. This converts the asset inventory into an expense I can take off on my taxes - cost of sale. As long as I can sell something its not an expense.

Mind you I've written off old stock as not sellable which changes it from an asset inventory to an expense - spoilage. At which time you're suppose to pulp them (or tear the cover off so they can't be sold). I guess you can give them away (to save you self the cost of garbage hauling) but you can't make money on them.

See what I mean about niggly little details. Is this a gamist wet dream or what?

Chris Engle
Hamster Press

This whole thing makes me glad I haven't gone indie yet... I'm not up for the diligence of this kind of bookkeeping.

I'll stick with writing manuscripts for other people.

Well, if you get paid for it you still have to file a schedule C with your tax return. You may also have to file any of a variety of other forms and such to show that you don't owe any employee witholding.

If you buy printer cartridges or reams of paper to print off any of the manuscripts you write you can likely deduct those. If you travel to see the person who hired you, or have dinner with them and talk shop you can likely deduct 50% of those expenses. If you have a website where you feature your work or advertise yourself you can deduct the hosting costs. If you wanted to get a little aggressive you could deduct the cost of games you bought for inspiration for your own work or any money you've donated to the Forge.

In other words. If anyone pays you money for any kind of service outside of a "payroll employer"...you technically need to track it and pay tax on it. And if you're going to pay tax on it, you might as well try to pay as little as possible. And if you're going to pay as little as possible you need good records. Ain't no way of getting around it...except tax evasion and hoping you're too small to get audited.

I declared the $150 I made last year writing games. I might have spent $40 on it, total... MAYBE.

Is it worth an hour of my time, to remove $10 from my taxes?

Vaxalon, on $140 I don't think you need to worry about it. But if you want to here is a good way to start.

1. Keep all the reciepts of things you buy for the business. (BTW you are a sole proprietor. You can do all this under your own social security number)

2. Write a sales slip for all the books you sell.

3. Deposit the cash in a bank account designated for the business (I have a separate account but I could have used a sub account in my existing account). Keep your deposit and withdraw slips.

That is basically all the "business papers" you need. If you just put them in a bag that is better than nothing!

What does these papers mean?

1. When you spend money you are either a) buying an asset (usually books to sell - inventory) or b) paying for something, an expense (that you can write off on your taxes).

2. When money comes in it is cash. That's income. Product goes out, which reduces your inventory. The cost of that inventory now becomes a special expense called "cost of sale" that you can now write off on your taxes. So sales slips do two things, they track cash/income and inventory/cost of sales.

3. When you deposit the cash in the bank it exchanges one asset for another. If you income does not equal your deposits it is a red flag for auditors that something is wrong. So run everything through your account.

If you do only this much you should be fine with the government. They are after all you silent partner. You do your work and they provide streets, police, courts, education for the work force, health care, etc.

Chris Engle
Hamster Press

I haven't had to worry about inventory, since I'm selling wholly via PDF currently. The only thing I need to track is the amount of money made (each sale) and where that money goes (if I need to use it for anything business-related, and the only expense I've had thus far is hosting). Hence, I've had no need (yet) to do anything fancy or frightening as an indie publisher.

My tech. consultancy business, OTOH...hoy...

Ok I do have a question. Accounting does not scare me but frankly it is something I know little about other then it is necessary.

What about if you use a POD service? Someone else prints the copy for you and sends it to the customer, you get your cut in a monthly check.

Do you still have to count THOSE books in your inventory? What if you have some real inventory and some POD?

I apologise if I sound like a goof :) but I will probably need someone to hold my hand once the two games I think will sell are ready to. So I may end up going to an accountant or consultant initially.

Sean

I believe that when I mentioned accounting it probably freaked out a lot of people (I know it used to freak me out!) So I thought it would be good to explain the basics of double entery book keeping so you can see that it really isn't that hard.

There are only six basic accounts: Assets, Expenses, Cost of Sales, Income, Liabilities and Equity.

When reciepts are recorded in an account book the numbers are place in one of two columns. The left column is the "Debit" column. The right side is the "Credit" column. Three of the accounts increase on the debit side and three increase on the credit side.

Account Debit Credit
Asset increase decrease
Expense increase decrease
COS increase decrease
Income decrease increase
Liabilities decrease increase
Equity decrease increase

Business is very repetitive so the same kind of transactions happen again and again.

1. You buy something: Debit side - Expense increases, Credit side -Asset (cash) decreases.

2. You buy something to sell: Debit side - Asset (inventory) increases, Credit side Asset (cash) decreases.

3. You sell something: Debit side - Asset (cash) increases, Credit side - Income increases.

4. You hand the goods over to the customer (likely right after you take their money!) Debit side - Cost of sale increases, Asset (inventory) decreases.

What expenses are most common? Postage, office supplies, travel and entertainment costs, advertising, web page.

What asset are most common? Cash, cash in the bank, inventory for sale, and money people owe you (also know as Accounts Recievable).

But what numbers do I write in the two columns? I hear you cry. Simple! Look at the reciept your recording. The amount there is written in both columns. It may be broken up sometimes (Say I spent $20. $10 for office supplies and $10 for a book I will resell. 20 would be on one side while 10+10 would be on the other. They balance.)

There are more details but they all just elaborate on these basic ideas. You now know the basics of accounting.

Chris Engle
Hamster Press

ADGBoss wrote: What about if you use a POD service? Someone else prints the copy for you and sends it to the customer, you get your cut in a monthly check.

Do you still have to count THOSE books in your inventory? What if you have some real inventory and some POD?

Thanks! Yes that does make a bit of sense.

Another question I would not mind seeing answered, more for curiosity sake, is how many hours a day / week / month does it take up for those who do their own accounting?

Again thats just curiosity more then anything.

Sean

Next look at a POD transaction. Say the person contacts the POD directly and they pay you monthly for the books they sold that month. This is just like selling PDFs. You never had possesion of the books. It will be recorded as Debit - cash, Credit - income. BUT there will be a fee to the POD guy that is recorded as Debit - expense (POD fee), Credit - cash (which decreases it).

Say the POD order comes to you, along with the cash and you forward it to the POD guy. If you send money to them and they send the book on without it ever coming into your posession then it's just like above. If you order it and they ship it to you and you ship it on, then it is in your inventory. This would be recorded as Debit - inventory increase, Credit - cash decreases. When you ship it out it is recorded as Debit - increase cost of sale, Credit - inventory. The cash - income entery would be as shown above.

ADGBoss wrote:

Another question I would not mind seeing answered, more for curiosity sake, is how many hours a day / week / month does it take up for those who do their own accounting?

I agree, it doesn't take long if you're organized. The trouble is learning how to get organized. In 1995, Terri and I started saving 10% of what we make (as recommended in the book "The richest man in Babylon"). Then I started keeping all my reciepts (in a bag). That taught me to write things down on the outside of the bag. Then we started using a written budget for house hold expenses - when I pay a bill I write the amount down in that months square. Then I started recording enteries into a journal. I'm slow so I eased into this over 8 years.

Ralph's point about reading your POD contract closely is well taken. I've not worked with POD places because I effectively and working to become one myself, but if you contract says they print 10 even if they sell only 2 the you do have 8 books in your inventory (with the likely hood that they'll charge you to warehouse them to boot!)

Chris Engle

This topic may be dead but before I give it up I would like to see if other people want to share how they do their accounting and how they learned to do what they do. I think people seeing the process makes it easier for them to do it for themselves.

Chris Engle
Hamster Press

>>Inventory is another matter entirely and a crucially important one. I have a feeling that many Indie Publishers run afoul of the Inventory related tax rules. <<

These days we have a part time accountant keeping our books, so I don't handle much of this info. I now she uses quicken to keep them though.

Inventory can be a tricky thing on the accounting issue. For instance, all sellable inventory is an "asset" and the cost of producing it can not be written off as an expense until the time it is actually sold. So if you spend $4,000 (art, editing, actual printing) on 1,000 books, then sell one hundred books directly on your website, here is what happens. Say you sold them for $20 each. So you have grossed $2,000. You only sold 100 books so you may now only write off the production expense for 100 of those 1000 books. At a $4.00 cost of goods sold, you get to write off $400. Therefore you still have an inventory asset of $3,600. Plus you now have a cash asset of $2,000. If you spent your last dime on production, this means you started with $4000 in invetory assets and now have assets of $5,600. Without other cost related deductables, you'll now have to pay profit taxes on the $1,500 difference. This is really important to note since, you only have $2,000 cash on hand and have only made back half your initial cash outlay, so you are still cash flow negative.

It gets even more complicated when you handle elements of your own productions like we do. Only "sellable" inventory has an asset value. So as we buy up "materials" that will go into the production of our board games, we have to keep a realistic resale value on those materials as assets in their own rights, since they are not yet fully produced game assets in their own right. Now, since things like paper, ink, digital printing plates, copier toner etc are commodity items and since our business has no realistic sales venues to sell this material, all such material we buy has a realistic "resale" value far less than the actual price we paid for it. Or in other words, almost all said materials is subject to depreciation, much like equipment is. For us, on the tax books, that means all materials bought for games production have an asset value far less than the expense value of cash spent on them. Technically speaking, we "could" value on our hand inventory the same way, but we don't because that would really foul up our own internal accounting. So once a set of materials is printed and produced into ready to sell games, we value to inventory value on those games as the actual prices paid for the materials that went into them. This helps us to insure we have an accurate accounting of cost of goods sold (once rolled into other costs that factor into the final CPGS figure anyway). However, since we do not keep a large stockpile of complete games (maybe between 40 to 100 of any given title) fully packaged and ready for shipping, our materials expenses versus assets on hands as an edn result of those materials works out very favorably for us come tax time every year.

Oh, and with regards to needing to keep accurate accounting to insure you have an accurate COGS so you know you are turning a profit on each sale. BUNK and double BUNK.

I will say this. Everyone here that is producing a game for sale should know 100% of the costs going into that production BEFORE it ever gets produced. And in knowing that, you should also have memorized, or at least accurately recorded somewhere you can access daily, what that cost translates into on a PER UNIT BASIS and what profit margin that allows you for your different sales venues. THIS INFORMATION IS CRITICAL if you have any hope of running a small publishing company for a profit.

For instance, we have a new edition of one of our current board games in the works. Our WWI board game. We are prepping the new artwork, game maps and other files right now, but have yet to spend a dime on production. However, even before we started work on the digital side, we figured out our production side and costs. Already I can tell you that:

1) It will carry a MSRP of $34.95

2) I have a detailed list of all components that need to be purchased for the game to be produced, in what quantities and at what costs.

3) I have a documented list of production steps we have to take to move those printing materials into the final game format that will be ready for sale.

4) I know our COGS on a per unit basis will be $3.54

5) I know our markup when sold at wholesale will be 395%

Yes, when we first started publishing, we didn't have such an accurate view of what our production we doing for us and what they were costing us. But I can also tell you, until we did get that organized, we also were not making anywhere near the profits that we do now. Because now we understand "exactly" where our money is going and how it is working for us. But I know this not because of a review of our accounting books. This information is figured long before the actual expenses of production ever hit as a ledger entry in the accounting books.

Every product you look to produce should have as detailed a spec sheet as possible. It is, in effect, like generating a small an informal business plan for each production. It will tell you were you plan to spend your money (production, freelance work, advertising and marketing programs), what your COGS is, what your cash flow break even points are, and frankly, where you should be focussing your sales efforts at.

I do a similar calculation about my cost of sales per unit. I don't go to my accounts for that information - but I get that number by looking at the cost of my materials (recorded in my accounts).

I had not considered that the market value of my materials is less than what I paid for them - that makes sense. Does that fly with property tax auditors?

Chris Engle
Hamster Press

>>that makes sense. Does that fly with property tax auditors? <<

I honestly don't know yet. The Guild of Blades is still run from the homes of the two principle partners, so it hasn't become an issue yet. Though it is something I ought to ask our accountant. We've been saving up so we can have an 11,000 square foot modular warehouse built so we can have room to expand.

At just a guess, I would say it will still be a non issue. Materials are assets that are separate from the property itself as is product and the machinery you use inside the building. So for valuation of the property itself, I would imagine only issues regarding actual upgrades to the property and building themselves would be at issue. And there are so many variables that go into that I could not really say. So much depends on location.

Ryan S. Johnson
Guild of Blades Publishing Group
http://www.guildofblades.com