Keeping Books

[pollmille-5]

How do you all keep track of your books.

[sam9876]

I just put my books in a bookcase.

[7606dennis]

Sam gave a great answer.  However, if you're talking about accounting, I suggest Quickbooks or having you accountant set up a customized program for you.

[southern*sweet*tea]

Books as in the books that I sell? Bookcases and baskets.

Books as in accounting? A ledger book and a pencil.

[kensgiftshop]

I use Quicken to keep track of everything.

At tax time, I click a few buttons and have it ready to print.

[professor-t]

I keep my inventory on a series of Excel pages.  My physical inventory is stored in either containers or drawers which are all labeled by content.  I have a bunch of DVDs for sale and this morning I woke up to one of them having been sold.  I went into the basement and got out the storage box labeled DVDs, pulled it out, and prepared for shipping.  I then went into Excel and entered the iformation 9day sold, invoice, shipping) on the row where it was already entered.  I then went to the beginning of the row and changed the background color to my "sold" color, to make it easier to find later on.

[buyselljack2016]

ledger book, red pen, black pen.

[southern*sweet*tea]

---

wrote:

ledger book, red pen, black pen.

---

You're brave! I don't dare use ink lol

[pollmille-5]

I was speaking of keeping track of sales and purchases.

[professor-t]

Excel works great for me.

[the*dog*ate*my*tablecloth]

I have a sales spreadsheet and an inventory spreadsheet. From the inventory spreadsheet I can find everything I need to determine Cost Of Goods Sold.

I also have an expense spreadsheet but I am hopeless at maintaining it.

[professor-t]

In my excel spreadsheet I have the following sheets:

Beginning Year Inventory

Non-Inventory Expenses (Milage, eBay fees, PayPal fees, etc...

Purchases (one sheet per month)

Sales (One sheet per month)

Year End Inventory

I'll add a sheet to compile profit for the year in December.

I will then copy the entire file and rename it for 2018 and edit it to conftine on.

[dbmm-media]

 i put my books on a shelf, very easy to keep track of them. 

[dbmm-media]

---

wrote:

I was speaking of keeping track of sales and purchases.

---

oh....

  purchases with a credit card only for purchases of inventory.  that way you will always know what you spent. / end of year purchase summary 

sales, paypal monthly sales reports / end of year sales reports

[the*dog*ate*my*tablecloth]

My items are unique and somewhat hard to differentiate so each gets their own inventory number. I actually keep a single page printout of everything I buy but you could save it in a file on the computer too.

Of course that's not necessary if you sell commodity items where all you have to do is keep an accurate count.