Started By
Message

re: Accounting for arbitrary/abstract "commodities" (tickets, memberships, etc)

Posted on 9/3/20 at 3:20 pm to
Posted by Korkstand
Member since Nov 2003
28730 posts
Posted on 9/3/20 at 3:20 pm to
I appreciate the suggestion and thought, and trust me when I say that I understand the effort put into all of these programs and the value that they provide. And I know that for the majority of people, this type of purpose-built tool with automation and integrations with other programs is absolutely ideal.

But for me, I am considering more than strictly financial or time costs (though these things are important given the shoestring budget). My decision includes philosophical and other, uh, unconventional factors. For instance, something that is important to me is ownership of my data. And while your QuickBooks file is "yours" and your membership data in a cloud service is "yours", if you have to rely on software or a service controlled by a 3rd party in order to use that data, it's not really yours. So maybe this is philosophy, or maybe it just stems from me being IT-minded, or both, I'm not sure.

Posted by Korkstand
Member since Nov 2003
28730 posts
Posted on 9/18/20 at 1:34 am to
Update for anyone who cares:


I ended up just doing the simplest thing I could think of. Instead of thinking of tickets as physical things to pass around, I'm moving the service/liability that they represent between accounts. So I just made a couple of generic accounts for "virtual" commodities, called literally Expenses:Virtual and Assets:Virtual.

So when a member registers for an event, Expenses:Virtual gets 1 EventX and Members:John gets -1 EventX (a liability, he is owed a service). Maybe a couple dozen members register and pay, then on the day of the event I make a transaction that "pays" off all the EventX's owed to members from Assets:Virtual.

Maybe it doesn't make perfect sense, or maybe it's totally arse-backwards from how this should be handled. But I understand it and it serves the purpose, I know at all times total tickets sold by event and to which members. If a member has a non-zero balance, I know he is owed services. And the concept extends to things like memberships, where a member may be owed 1 year of membership and I can automate monthly transactions of fractional memberships.

And of course it handles all the cash too.

As I mentioned, it is all plain text files, so I have it checked into a git repository. This is typically used for software development version control, but it's a great solution for any text files. I can see exactly which lines of which files changed and when, what it looked like before and after the changes, every step of the way back to their creation. It gives me unlimited undo/revert to any point in any file's history.



I'm sure you guys couldn't care less about all this, but to me this is very exciting. There is already a robust set of tools to handle all of the typical accounting reports, queries, and exports, but more importantly this system makes my accounting data programmable. There is no limit to the ways I can enter, manipulate, or view the data. Accounting is fun for me now.
first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram