Keeping Books

[pollmille-5]

How do you all keep track of your books.

[femmefan1946]

My book inventory is in four bookcases ,down from ten since our move, but I need at least one more. Alphabetical by author.

My bookkeeping in on a paper spreadsheet, with columns for "

• Paid
• Title
• Canadian dollar sale
• US dollar sale
• Shipping charged
• Postage
• Procurment cost (includes supplies)
• source
• weight
• date shipped
• Notes.

[sweetcheaksboutique]

I keep my books on Google Drive, works just like Excel, and it free. 

[siayan]

I don't keep track of them anymore but the best I found was Homebase, the older version (free)

[thevintagesilvershop]

I have a business checking account and all sales $ go into it and all expenses come out of it. So, I use Quicken to track that activity and at ANY time, can pull a profit and loss statement which is the basis from which I file taxes every year or use to send in estimated tax payments. Has worked for me since 1992. 

Excel is used to track inventory. Excel is also used to project sales, expenses, and cash flow weekly so I know how much I can draw for personal use or how much I can put into my business savings account (this account is used to make tax payments and as a reserve for refunds/losses). 

[cinjamanbooks]

We use a combination of QuickBooks, Excel, and Google Sheets for inventory easy access on the go.

[audioarchive]

---

wrote:

How do you all keep track of your books.

---

Two spreadsheets.

One keeps track of daily individual sales and the breakdown of all credits and debits. It also projects my sales totals per item and dollar, based on the daily average.

The second one just takes the total of the daily sales and keeps track for the current month. On it, I can tell you my daily profit or loss, as well as a monthly and annular profit/loss.