You don’t generally need to track all your stock on a day to day basis within QuickFile. I run a retail shop and what I do is:
- when I buy goods to sell, those go as purchases to the “general purchases” category
- when I sell goods, those go as sales to the “general sales” category
- once a year at my year end date I count up the value of all the stock I have in hand on that day and make a journal
- credit “closing stock” (a P&L code)
- debit “stock” (a balance sheet code)
- in the second and subsequent years this journal will also have two more lines to credit “stock” and debit “opening stock” for the amount of stock I held at the end of the previous year
This makes my overall cost of sales for any given year equal to
- the value of the stock I held at the start of the year
- plus the cost of everything I bought during the year
- minus the value of anything I had left at the end of the year
and the year end balance sheet includes the value of whatever stock I hold at that time.
If you wanted to keep your dog food sales figures separate from your other income you could create separate sales and purchase codes for that rather than using general sales/purchases.