Inventory Program and Advice

I use Excel

Second vote for excel. allows you to customize and organize based on any characteristic you wish. It's a job

Mike

Third for Excel. Super simple... even I can do it!

I use Excel as well

I do as well. I also link the entry to pictures of the item.

Excel as others have said.

I use Yard Office and really like it for the capability to add images which makes it more enjoyable to flip through. There is a free version available and to get the premium version is a modest one time cost. It also exports to excel which is great. I upload the excel files to google drive for viewing when I'm out and about away from my desktop computer ie at a train show.

https://www.musicmixradio.com/yardoffice/

I use a database which is just a fancy spreadsheet.  If I want to know how many beer themed reefers I have, it is an easy search.  If I want to know how many beer themed Atlas 36' reefers with a primarily red body I have, it is just as easy.

The issue for the OP (as he knows) will be putting his large collection into the inventory program.  A lot of data for each item will take time.  Maybe build the inventory sheet with all the data points you want to define the item (I have 18), but initially fill in the main ones like manufacturer, product name, type, etc.

Having many data points is not an issue when you buy a new item and put it into the spreadsheet as soon as you buy it.

I use a simple list on MS Word.  I can just write what info I want and not have to keep up with columns.

Charlie

I use spreadsheets in  OpenOffice or LibreOffice -- both are free alternatives to Microsoft Office and are compatible with MS Office 99.99% of the time (I've only run into incompatibility with some very complex Excel spreadsheets with tons of macros).  Before you start, it is best to make a list of the data points or information you wish to track.  Common things are manufacturer, SKU #, description, item type, road name, road number, price paid, date of purchase, place of purchase, condition, current/replacement value.  There are many more things you may wish to track.

Andy

Search the forum for "inventory" - there are several recent threads discussing pros and cons of various methods.

I started my inventory of HO models back in the late 1980 using EXCEL. I've been very happy with it and it gives me a lot of flexibility. I can sort by road name, engine type, freight cars by road or type or size (40' or 50'), manufacturer, list price, my costs, current value, etc. It's almost endless on how one can search and sort - all depends on how much data one loads into the spread sheet.

I did the same thing with my railroadiana collection of lanterns, china, timetables, calendars, passes, photographs, silverware, etc.

When I got into O Gauge some 15 years ago, I just copied the same format.

I know there are software programs that better address this and includes adding photos. But for me, Excel worked great and it was free with my computer.

RAY

I use Apache Open Office for my non-train inventories; if I start a train one, I will continue using Open Office. As stated above, it free to download. I have been using it for years since I lost access to Lotus at work and have no complaints.

I use Google Sheets.  It the same as Excel, but I'm able to use it on my phone, which makes it nice when I'm at a show and want to make sure I'm not buying something I already have.

If you need to, you can open an Excel workbook in Google Sheets.

Open a blank Google Sheet and select  “File” > “Open.”

Select “Upload” tab from the “Open a file” menu.

Click & drag your Excel file into the space and click “Open.”

When the Excel file opens in a new window, click “Open with” and choose “Google Sheets.”

This subject again!

I looked for a program that would give me what I wanted, but found none. Each model train inventory program contained different data so I decided to create my own using Access.

Before using Access, I created a spreadsheet with the data I wanted on each item.

Now that I've got Access up and running, I am slowly moving everything to Acces. But I still enter everything in my spreadsheet and then when I have a bunch of spreadsheet entries that aren't in Access, I enter them periodically.

Here's the columns I have on my spreadsheet:

Seq # ( I use this so I can sort according my my own desire)
Cat No
MA (I used this colum to indicate which items are now in Access)
Description
Color(s)
Series / Set
Manufacturer
Scale
Group (this is my own grouping)
Road Name Code
Road Name Description
Road Logo
Reporting Mark
Category (from Yard Office)
Type (from Yard Office)
Min Curve
Length
Built
Status (from Yard Office?)
Config (from Yard Office?)
Years Cataloged
MSRP
Purch Date
Sold by
Purch Price
S & H / Tax
Calc. Total
% MSRP Purch Price
Item Cond
Best Value
% MSRP Best Value
CY Greenberg Value
% MSRP CY Greenburg Value
MITrains Value Date (this program is no longer available but I still use it to give me a guide on an item's worth and enter the date of the program)
MITrains Value Price (this program is no longer available but I still use it to give me a guide on an item's worth)
% MSRP MITrains Value Price
Qty
Box Type
Box Cond
Images (up to 8)
Notes

I would love to make this database more efficient by eliminating some of the info that could be used in tables,, i.e., when I enter the road name code it would link to the name in a table and then when I print it would print the code and the name as opposed to having both entries in the main database table. I just don't know how to do that.

Thank you so much to everyone for your helpful advice and recommendations