Filtering and Downloading Your Food Inventory History

Posted on November 11, 2019 by

Whenever you make an update to your inventory in ReciPal's food inventory management tool, whether it's for a raw material or finished good, the change is recorded in what we call an inventory transaction that gives you a record of:

  • Any receipt of raw materials,
  • Usage of an ingredient in a production run,
  • And shipment of a finished good to your clients,
  • Or other change like a spoilage, return, or physical count of inventory.

You can view all these transactions on the history page of an inventory item by clicking on it's Name or Last Updated links on the Raw Materials or Finished Goods page.

What Was

You could always view the full history of transactions for an inventory item on its history page, where you could also see some summary information on recent usage, suppliers, and lot codes.

What Is

Now you can do a bit more with both raw materials and finished goods. You can:

  • Filter transactions by date to see changes over a certain period of time (e.g. a fiscal quarter)
  • Download and export those transactions to a spreadsheet (so you can do your own further analysis)
  • And batch download all your transactions across all your inventory to a spreadsheet instead of exporting information for just one item.

Inventory History Filters and Downloads

It's easy to filter and download what you need for any inventory item.

What's Next

We added these features because a few of our customers wanted to more easily reconcile their inventory for accounting and bookkeeping purposes, but maybe you'll come up with your own uses. Some things that might be worthwhile would be to analyze spoilage, determine your most popular products, and find inconsistencies over time.

Try it out for yourself, and let us know if you have any questions, feedback, or other suggestions. One thing we're thinking about adding is filtering transactions by type so you can look, for example, at all the inventory receipts, usage in a production run, spoilage, or physical counts. That way you can glean some insights into ingredients, products, and ultimately your business. Sound good? Let us know!


About Lev Berlin

Lev Berlin ReciPal SlantShack Author Bio

Lev Berlin is the founder & CEO of ReciPal. Having previously been a founder of SlantShack Jerky, he needed nutrition labels and simple tools to start and run the business. He's read the FDA food labeling code countless times in the process of creating ReciPal and helping small food businesses with their labels. He's reviewed and created thousands of food labels, and been a mentor and guest speaker at food incubators, food business courses, and regulatory conferences, like Brooklyn Foodworks and ICE.

After graduating from Princeton with an engineering degree, Lev was a management consultant, then founder or early employee at half a dozen startups. He loves nothing more than helping other small businesses get off the ground and achieve their goals.


Learn something? Check out similar posts:

Features Tips And Tricks Inventory Management
Learn why hundreds of food entrepreneurs already use ReciPal to manage their recipes, costs, and create nutrition labels.

Just want lessons on growing a food business?

We're learning a lot and so will you.

Your information will not be shared.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Sevice apply.

Search the Blog

Want To Grow Your Food Business?

Food folks just like you have had great experiences making nutrition fact labels, costing recipes, and managing inventory with our web app. It was designed by food entrepreneurs for food entrepreneurs, so it makes sense.

Popular Posts


Tags

Private Labeling FoodGetting Started With Food LabelsCopackingFood MarketingGetting Into RetailFood Label NewsInventory ManagementTips And TricksDatabase Nutrition AnalysisLabeling Rules And GuidelinesContestsGuest PostsFeaturesFood PackagingEngineeringPressResourcesFundraisingPricing Your ProductEntrepreneur Interviews

ReciPal: Simple Software for Food Businesses

Join some of the most successful food brands
in creating nutrition labels, costing your products, and tracking inventory on ReciPal.

Start your free trial now!