Hello
Do any Squadrons use a digital system for keeping the asset register?
We’ve been looking at various systems but they all seem to complex or too simple. We want to track description, category, date purchased, purchased price, warranty, replacement value, storage location etc.
We were hoping to be able to label / tag assets with a barcode
Does anyone have any experience in something like this.
Many thanks
Keep it simple use a sharepoint list
Gear log is a good one. Plus then using tough tags
Hi, thanks for replying. I’m very interested in your experiences with GearLog. Can you give me anymore details of how you set it up and how you’re getting on with it please?
Many thanks
Tbh I didn’t. It was from someone who uses it for personal gear, but you could adapt it for sqn use.
Thanks for that. I noticed that they have a RAFAC badge on their website, someone must be using it.
I’ll dig deeper.
Many thanks
Please let me know, how you get on.
Our Wing has recently provided all Sqn CivCom’s with one (not sure if it came from further up the chain) whereby it auto-calculates the depreciation of any items included in the Asset Register, linked to original purchase price, how long since purchased etc… which is quite handy.
We’ve got to finalise ours now, as it’s required to be attached to Form60 Annual Account Returns ;
“It was decided at the last National Civilian Council that all completed Sqn and Wing Annual Accounts Forms and Asset Registers will be held in a Regional repository so that compliance can be seen, and the Air Cadet Charity will also have access to verify their existence before allocating any grants.”
Yet we’ve had so much on recently, that it has unfortunately been placed on the #ToDo, after making a good initial start.
#SoMuchToDoAndLittleTimeToDoIt
Let me redact our inputted data and then I’ll send it over.
Just for further info, this SQN of course has items from before we took the CivCom helm, and unfortunately the previous paper work, admin, record keeping was lacking to say the least, so we began with not much at all.
Therefore, we have various items with no paperwork, so the Asset Register is separated into x2 parts “with documentation = we have receipts, invoices etc” and “without documentation = where we research the approximate costs of those items, and try to ascertain an approximate age”.
Thanks so much!
Yeh, similar case here. I had to start by having a building full of stored stuff scrapped because I couldn’t do anything with it prior to the RFCA building being demolished, so we combed through it, salvaged what we could, and left the rest for dead.
Ours will be a bit of a do-over! It’s just a big job, so having a ready-made framework will be a really helpful push to get it all going.
I’ve removed the image for security due to showing location and listing high value items.
That and before @OC.1324 realises he needs to have an aneurysm over the badge.
@Ph0enixUK if you want to add a redacted version of the screenshot then you can.
It was instantaneous, but I appreciate the gesture. 
“Siri, enhance!”
head pops
@Giminion Indeed, thanks. Although, the items were just dummy data to show how it should be laid out.
As for the badge (and to @OC.1324), we’re already in the initial process. The one we currently have (already in place before the OC/CivCom even joined this sqn) went through an initial ‘short term phase agreement of use’ by our Wing, as I had long conversation’s with somebody dealing with it a few months back when we all received the “sort them or RAF will take them down” and modernising the branding guidelines etc.
Internal documents just have the badge.
Anything public facing, so social media accounts, and our website has the short term agreed one that encompasses the ‘Royal Air Force The Next Generation’ next to it, as you will see here: https://www.2353atcsquadron.org.uk/ (Incidentally we changed ours within hours of reading the requirement)
We currently have a Cadet Sgt IC of the sqn’s Media Flight, along with the CI of that Flight liaising with the OC to get the design principles/desires that meet all at this sqn, right for what they’d like to see on an official modern and that is meeting of the official requirements version that we’ll have done.
I had actually spent over an hour the other day reading the badge thread on here, took sometime to get through everybody’s replies, from the beginning but we had already begun the above before me reading that thread.
I’ll re-upload for context, with the redcated info of the screeenshot, thank you. 
If you require any support on the badge stuff, do drop me a message on teams and I’m happy to give you early steers.
It’s fraught with difficulty so I’m always happy to chat before people invest loads of time.
Edit: oh yes sorry, I’ve literally spoken to your team and added them to the list 
Thanks for that. I’ve no doubt it is fraught with difficulty, as that from my experience is many aspects of the system but lots of it has been handed down, and either not been modernised, or when it has sometimes it isn’t done very well.
I’ll get something together and come back to get in touch in the near future for sure.
Apologies for the delay, busy, busy here, there and everywhere I’m afraid.
It won’t let me attach a .xlsx spreadsheet here, so how can I get this to you please? It now has redacted sqn specific information, so is fine to be shared etc.
Let me know and I’ll then get it to you in that manner. 
No problem!
I’m on oc.1324@…
Afternoon.
I’ve only just seen this by chance and didn’t get notifications to say a reply had been made. Of course, I’ll email it over today no problem.
Regards,