C&R bound book template in Excel

[wilit]

I wanted to keep both a written and electronic copy of my bound book, so I made up a template based off the PDF listed on Surplusrifle.com website. I added some extra info that I thought the Surplusrifle.com form was lacking since I wanted to add all my firearms into the book for insurance purposes. Just thought I'd share this with anyone looking to keep an electronic copy too and you don't have a PDF editor.

Right Click and Save As for my Excel template

Here's the Surplusrifle.com example


Here's my file

[olhunter]

Hey, I like it!

May I make a suggestion?

Make everything wider so there's more room and will print landscape?

And make the 'non-licensee' box 3 titled rows instead of 3 columns since the columns are too narrow to write it all in.

Just my 2-cents...

Thanks for making this, very cool.


edit - oh, wait. I didn't even open it yet. Maybe it already is landscape....

[wilit]

Thanks for the suggestions. Hadn't thought about the non-licensee section. Edited and reposted for download.

Any other suggestions, post them up. This is an open source document, so improvements are welcomed.

[emcon5]

So is this form adequate/acceptable to use for a C&R bound book? Could you just print them out and stick them in a 3 ring binder?

Thanks,

[ke6guj]

yes.

(E1) What is a "bound book?" [Back]

A "bound book" is a permanently bound book or an orderly arrangement of loose-leaf pages which must be maintained on the business premises. The format must follow that prescribed in the regulations, and the pages must be numbered consecutively.

[27 CFR 478.121 and 478.125]

http://www.atf.gov/firearms/faq/faq2.htm#e1

[erblo]

Thanks for making this, very useful!

[00BuckShot]

Nice looking sheet.

[shmeare]

thanks dude! this saved me some $

[SideWinder11]

Awesome! Thank you!!

[Noonanda]

I like it except for the "reason for selling" it doesnt matter to ATF why I sold a firearm, and Im not looking to give them reason to question why I sold a firearm

[EOD Guy]

The main problem I see is that the form is not in the prescribed format in the regulation and so might not be legal. Section 478.125(f) of 27CFR is very specific about following the format in the regulation.


From the regulation:

The record required by this paragraph shall be maintained in bound form under the format prescribed below.

[Roccobro]

Three hole punch and put it in a binder. That has been an accepted practice since I started a decade ago.

OP- Why would you have a section titled : "C&R?" if this is for a C&R (FFL03) bound book? Are you listing your non-C&R purchased guns in it?

Justin

[Dr.Mauser]

wont need it for a year, but I'm saving it on my CPU lol

[wilit]

Three hole punch and put it in a binder. That has been an accepted practice since I started a decade ago.

OP- Why would you have a section titled : "C&R?" if this is for a C&R (FFL03) bound book? Are you listing your non-C&R purchased guns in it?

Justin

Yeah, I threw that in there because I keep track of all of my firearms for insurance purposes.

For the record, if there's a cell you don't want, by all means download the form and edit it to your liking. That's why I put it up in xls form instead of pdf, so people can tailor it to your own needs.

[tenpercentfirearms]

I too am concerned that the above sample doesn't meet the ATF format.

Here is a screen shot of what I use for my 01 FFL and it has gone through two audits.



I give copies of it away for free, but you can always kick down a few bucks if you like it.

http://www.tenpercentfirearms.com/index.php?main_page=product_info&cPath=93&products_id=768

or e-mail me at ad@tenpercentfirearms.com