Calguns.net  

Home My iTrader Join the NRA Donate to CGSSA Sponsors CGN Google Search
CA Semiauto Ban(AW)ID Flowchart CA Handgun Ban ID Flowchart CA Shotgun Ban ID Flowchart
Go Back   Calguns.net > SPECIALTY FORUMS > FFL's Forum
Register FAQ Members List Calendar Mark Forums Read

FFL's Forum For open discussion between FFLs and polite questions for FFLs.

Reply
 
Thread Tools Display Modes
  #1  
Old 04-13-2009, 9:57 PM
rbetts's Avatar
rbetts rbetts is offline
CGN/CGSSA Contributor - Lifetime
CGN Contributor - Lifetime
 
Join Date: Jan 2009
Location: Sacramento, CA
Posts: 906
iTrader: 7 / 100%
Default Good A & D Bound Book Software??

I am somewhat of a computer guy, and I think a computer version of the A & D "Bound Book" would suit me well. Even though the ATF still wants us to print out lists and send them in with the software, I still think that this might be an option. Anyone gone this route yet?

What about the DROS paperwork? Taxes etc. I'm looking for workable solutions. All Ideas are welcome.

http://www.goldenstatetactical.com
Reply With Quote
  #2  
Old 04-14-2009, 7:52 AM
remington's Avatar
remington remington is offline
Vendor/Retailer
 
Join Date: Nov 2008
Location: Corona
Posts: 646
iTrader: 19 / 100%
Default

I have tried to find some good software as well, I use RK's book now. I have found some but it is very expensive. Blue Book has a good program for personal collections, but I still use the the RK bound for that as well.

If you find anything let me know. Thank you.
__________________

Corona, Ca
NRA Life Member
FFL




Gun Control is like treating the symptom, not the disease. Gun laws only restrict people who obey the law.
Reply With Quote
  #3  
Old 04-14-2009, 10:38 PM
FortCourageArmory's Avatar
FortCourageArmory FortCourageArmory is offline
Senior Member
 
Join Date: Apr 2007
Location: Simi Valley, CA
Posts: 1,002
iTrader: 6 / 100%
Default

I just set up mine in an Excel spreasdsheet. I can add as many pages as I need and can search for any combination of input....serial #, description, 4473 #, etc. Works for me.
__________________
NRA Life Member
Tim & the gang
Fort Courage Armory
1518-B Los Angeles Avenue
Simi Valley, CA 93065
(805) 526-6563
www.fortcouragearmory.com
Reply With Quote
  #4  
Old 04-28-2009, 11:18 AM
halifax's Avatar
halifax halifax is offline
Veteran Member
 
Join Date: Oct 2005
Location: Mendocino County
Posts: 4,420
iTrader: 11 / 100%
Default

I've been getting email from this company but it looks like much more than I need. Maybe a bigger shop could use it.

AIMI

www.g7usa.com
__________________
Jim


Reply With Quote
  #5  
Old 04-28-2009, 4:07 PM
Matt@EntrepriseArms
Guest
 
Posts: n/a
iTrader: / %
Default

We use Ebound here. When we first got the software, they were one of the only ATF approved electronic versions of the bound book. I like it a lot, and as a matter of fact they recently did a customized version for us for our manufacturing side. It has a cool feature that allows you to "bulk add" receiver serial numbers, which saves you a lot of typing as you can enter a range of numbers rather than entering each one seperately!

We had thought about going the spreadsheet route, but I like the Ebound version because it allows you to do searches, print reports for inventory, A & D, etc. I highly recommend it.

http://www.gundersonsoftware.com/ebound.htm
Reply With Quote
  #6  
Old 04-30-2009, 7:46 PM
denz denz is offline
Junior Member
 
Join Date: Mar 2009
Location: Riverside, CA
Posts: 2
iTrader: 0 / 0%
Default

I am giving away Aimi eBook Pro, just pay for shipping.
__________________
Firearms Software

Mdtcs, Inc
951-817-0858

http://www.gun-software.com

Gun Software
Reply With Quote
  #7  
Old 05-01-2009, 2:03 AM
remington's Avatar
remington remington is offline
Vendor/Retailer
 
Join Date: Nov 2008
Location: Corona
Posts: 646
iTrader: 19 / 100%
Default

Ill take it
__________________

Corona, Ca
NRA Life Member
FFL




Gun Control is like treating the symptom, not the disease. Gun laws only restrict people who obey the law.
Reply With Quote
  #8  
Old 09-20-2009, 3:21 PM
Gottlieb Gottlieb is offline
Junior Member
 
Join Date: Sep 2009
Posts: 20
iTrader: 0 / 0%
Default Firearms Records Pro

I would like to offer my review of software offered for sale by http://www.firearmsrecordpro.com. I purchased the software because it appeared to be the most professional package for sale on the net. However, after I received my download instructions, it was problems from square one. First of all, the temporary username and password they give in the online user manual is incorrect. You'd think that after paying $99 for something, they'd have an accurate user manual.

Second, once I did get it installed, several buttons in the user interface were hovering over other buttons, and cound not be moved.

Third, I am now getting database errors. The company suggests I reinstall the software, but guess what - for $99 bucks, I don't think it's worth fooling with. I have generated an Excel spreadsheet which now works very well. I would avoid this software from Firearmsrecordspro. They say they are very popular, but I didn't find the software to be polished or functional at all. And I'm not a computer novice either.

I consider the $99 I spent on this software wasted money.
Reply With Quote
  #9  
Old 09-20-2009, 8:25 PM
jksupplyco jksupplyco is offline
Vendor/Retailer
 
Join Date: Jan 2008
Location: Ione, Ca
Posts: 1,630
iTrader: 16 / 100%
Default

+1 for Excel
Reply With Quote
  #10  
Old 09-20-2009, 8:39 PM
freakshow10mm freakshow10mm is offline
Veteran Member
 
Join Date: Jun 2008
Location: Michigan
Posts: 3,078
iTrader: 15 / 89%
Default

I've got a Mac but I run my stuff on Numbers (spreadsheet). Copy on the HD, external backup, and a paper copy. Took 10 minutes.
Reply With Quote
  #11  
Old 09-21-2009, 9:40 PM
JandJArmory's Avatar
JandJArmory JandJArmory is offline
Vendor/Retailer
 
Join Date: Sep 2007
Location: SANTA ANA
Posts: 63
iTrader: 2 / 100%
Default

+1 for excel
No varience required.
Reply With Quote
  #12  
Old 09-21-2009, 9:45 PM
freakshow10mm freakshow10mm is offline
Veteran Member
 
Join Date: Jun 2008
Location: Michigan
Posts: 3,078
iTrader: 15 / 89%
Default

Asking the ATF for a variance of any kind is like askinga chick for butt sex on a first date.
Reply With Quote
  #13  
Old 09-21-2009, 11:22 PM
djbooya's Avatar
djbooya djbooya is offline
Senior Member
 
Join Date: Apr 2008
Location: PRK
Posts: 784
iTrader: 12 / 100%
Default

Quote:
Originally Posted by freakshow10mm View Post
Asking the ATF for a variance of any kind is like askinga chick for butt sex on a first date.
some chicks dig that, no?
__________________
DJBooya
"Try Not! Do or Do Not. There is no Try..."
Reply With Quote
  #14  
Old 09-22-2009, 5:47 AM
tenpercentfirearms's Avatar
tenpercentfirearms tenpercentfirearms is offline
Vendor/Retailer
 
Join Date: Apr 2005
Location: Taft, CA
Posts: 12,830
iTrader: 10 / 100%
Default

I made a spread sheet using Excel and I will send a copy to anyone who asks.

My ATF auditors just told me the variance is no longer required. You just need to print out your records like once a year. I always kept it on Excel and printed it out whenever I added guns.

Why pay money when there is Excel and it is easy to use and search.

edit: Send an e-mail to ad@tenpercentfirearms.com and it will auto send you a copy and instructions.
__________________
For superior customer service and good prices visit www.tenpercentfirearms.com. We are Kern County's leader in black rifle sales.

The Calguns Foundation - Board Member. DONATE NOW! Your dollars go DIRECTLY to front-line legal activism in CA.
Opinions posted in this account are my own and not the approved position of The Calguns Foundation

Last edited by tenpercentfirearms; 04-11-2011 at 7:04 PM..
Reply With Quote
  #15  
Old 09-23-2009, 4:13 AM
customizedcreationz customizedcreationz is offline
Member
 
Join Date: Jul 2008
Location: Michigan
Posts: 182
iTrader: 2 / 100%
Default

Quote:
Originally Posted by tenpercentfirearms View Post
I made a spread sheet using Excel and I will send a copy to anyone who asks.

My ATF auditors just told me the variance is no longer required. You just need to print out your records like once a year. I always kept it on Excel and printed it out whenever I added guns.

Why pay money when there is Excel and it is easy to use and search.
I would be interested in seeing the excel version you setup please.

Thanks
Todd

guns@customizedcreationz.com
__________________
http://i103.photobucket.com/albums/m142/customizedcreations/CustCreationsLogo2finalblackback-1.jpg

Custom Licensed FFL Gunsmithing, Polishing, Parts productions, Custom CNC Machining, Custom Refinishing Chrome Plating and more
~~~Cerakote, Black Chrome, Nickel Cobalt Plating,Hot Black Oxide. Factory Certified Sig and Glock Armorer , Significant Sig Dealer 586.232.3422 9am-6pm Eastern~~~
Reply With Quote
  #16  
Old 09-23-2009, 5:55 AM
tenpercentfirearms's Avatar
tenpercentfirearms tenpercentfirearms is offline
Vendor/Retailer
 
Join Date: Apr 2005
Location: Taft, CA
Posts: 12,830
iTrader: 10 / 100%
Default

e-mail me. ad@tenpercentfirearms.com
__________________
For superior customer service and good prices visit www.tenpercentfirearms.com. We are Kern County's leader in black rifle sales.

The Calguns Foundation - Board Member. DONATE NOW! Your dollars go DIRECTLY to front-line legal activism in CA.
Opinions posted in this account are my own and not the approved position of The Calguns Foundation

Last edited by tenpercentfirearms; 04-11-2011 at 7:04 PM..
Reply With Quote
  #17  
Old 01-18-2010, 8:52 PM
kpmp4ever93 kpmp4ever93 is offline
Junior Member
 
Join Date: Jan 2010
Location: Atlanta, Georgia
Posts: 1
iTrader: 0 / 0%
Default A&D book software

I would love to see this Excel Spreed sheet you did up! I am new to the FFL business and have tried some software and its POS stuff so far. Excel appears to be the way to go. If you can shoot me over a copy or where to e mail I would appreciate it!
Reply With Quote
  #18  
Old 01-19-2010, 10:11 PM
tenpercentfirearms's Avatar
tenpercentfirearms tenpercentfirearms is offline
Vendor/Retailer
 
Join Date: Apr 2005
Location: Taft, CA
Posts: 12,830
iTrader: 10 / 100%
Default

ad@tenpercentfirearms.com and I will send you a clean copy.
__________________
For superior customer service and good prices visit www.tenpercentfirearms.com. We are Kern County's leader in black rifle sales.

The Calguns Foundation - Board Member. DONATE NOW! Your dollars go DIRECTLY to front-line legal activism in CA.
Opinions posted in this account are my own and not the approved position of The Calguns Foundation

Last edited by tenpercentfirearms; 04-11-2011 at 7:04 PM..
Reply With Quote
  #19  
Old 02-21-2010, 12:39 PM
docplez docplez is offline
Junior Member
 
Join Date: Feb 2010
Posts: 2
iTrader: 0 / 0%
Angry Firearms Record Pro

I own a small gun shop in Nevada and received Firearms Record Pro v2.0 from Brownells two days ago to try and get away from pen and ink A&D. Paid full price of $105.20 (with shipping) it's now on sale for $69.99 but not worth a dime in my opinion. Have had nothing but problems and errors trying to install on computers with XP, Vista and Windows 7. Finally managed to install on Vista machine but it still doesn't work right ... if you open and close the program and attempt to reopen it won't recognize user name / password. I don't see any reason to even enter data I may never get back. Support team at software manufacturer says it's all of my computers faults not their software. They never once said "try this or try that" ... just that all my computers are having problems. Haven't heard anything back from Brownells but they also said "neither we nor Brownells refunds for software due to piracy issues." Why would anyone pirate software that doesn't work? If they don't refund I'll just quit buying from Brownells and make sure everyone gun shop owner I deal with knows not to buy this software. Wish I'd have read this forum before ....

So is anyone using anything that actually works? I used to just use my own Excel but latest ATF Rul. 2008-2 has made that obsolete in a number of ways.
Reply With Quote
  #20  
Old 02-21-2010, 1:49 PM
Serpentine Serpentine is offline
Senior Member
 
Join Date: Mar 2007
Location: Santa Clara County
Posts: 1,023
iTrader: 24 / 100%
Default

Quote:
Originally Posted by docplez View Post
I own a small gun shop in Nevada and received Firearms Record Pro v2.0 from Brownells two days ago to try and get away from pen and ink A&D. Paid full price of $105.20 (with shipping) it's now on sale for $69.99 but not worth a dime in my opinion. Have had nothing but problems and errors trying to install on computers with XP, Vista and Windows 7. Finally managed to install on Vista machine but it still doesn't work right ... if you open and close the program and attempt to reopen it won't recognize user name / password. I don't see any reason to even enter data I may never get back. Support team at software manufacturer says it's all of my computers faults not their software. They never once said "try this or try that" ... just that all my computers are having problems. Haven't heard anything back from Brownells but they also said "neither we nor Brownells refunds for software due to piracy issues." Why would anyone pirate software that doesn't work? If they don't refund I'll just quit buying from Brownells and make sure everyone gun shop owner I deal with knows not to buy this software. Wish I'd have read this forum before ....

So is anyone using anything that actually works? I used to just use my own Excel but latest ATF Rul. 2008-2 has made that obsolete in a number of ways.
We are still using the pen and ink method, but it would be great to have a software program to save time and to assure best accuracy.

What do you think about contacting some of the larger distributors and asking what inventory software system they are using? Perhaps some have written their own code, but possibly they are using third party software that would work for dealers as well?

We should continue to work on this collectively as a 'committee' effort to reach a good, solid, supported solution, even if it may cost a few dollars more than going with a piece-meal or start-up software package.

I'll make a few calls to some distributors this week when I have some time.



.
Reply With Quote
  #21  
Old 02-21-2010, 2:04 PM
Serpentine Serpentine is offline
Senior Member
 
Join Date: Mar 2007
Location: Santa Clara County
Posts: 1,023
iTrader: 24 / 100%
Default

I left inquiry messages with with our major distributor reps. Will follow up here on any information I receive.

Also, this company RK Enterprises (http://www.rkffl.com/) has been a godsend for helping FFL's understand the laws and be in compliance with ATF and DOJ. I will speak to Bob tomorrow and see what his input is on this.


.
Reply With Quote
  #22  
Old 02-21-2010, 4:42 PM
docplez docplez is offline
Junior Member
 
Join Date: Feb 2010
Posts: 2
iTrader: 0 / 0%
Default

Thanks ... I've seen a few after searching on the net but no one seems to have a review. Also most all are fairly pricey but given the cost of developing and writing code and security concerns, keeping up with the changes in operating systems (MS Vista, MS XP, MS 7, MAC, Linux, etc), and given the fact they won't sell millions of copies I can understand.

One issue I have noticed after my problems with Firearms Records Pro is now Excel doesn't work and I get ODBC errors (Open Data Base Connectivity). Doesn't make sense as they use SQL 2005 but who knows what that software did to my computers. Oh well ... back to pen and ink for now I guess.
Reply With Quote
  #23  
Old 02-21-2010, 4:49 PM
djbooya's Avatar
djbooya djbooya is offline
Senior Member
 
Join Date: Apr 2008
Location: PRK
Posts: 784
iTrader: 12 / 100%
Default

Quote:
Originally Posted by docplez View Post
I own a small gun shop in Nevada and received Firearms Record Pro v2.0 from Brownells two days ago to try and get away from pen and ink A&D. Paid full price of $105.20 (with shipping) it's now on sale for $69.99 but not worth a dime in my opinion. Have had nothing but problems and errors trying to install on computers with XP, Vista and Windows 7. Finally managed to install on Vista machine but it still doesn't work right ... if you open and close the program and attempt to reopen it won't recognize user name / password. I don't see any reason to even enter data I may never get back. Support team at software manufacturer says it's all of my computers faults not their software. They never once said "try this or try that" ... just that all my computers are having problems. Haven't heard anything back from Brownells but they also said "neither we nor Brownells refunds for software due to piracy issues." Why would anyone pirate software that doesn't work? If they don't refund I'll just quit buying from Brownells and make sure everyone gun shop owner I deal with knows not to buy this software. Wish I'd have read this forum before ....

So is anyone using anything that actually works? I used to just use my own Excel but latest ATF Rul. 2008-2 has made that obsolete in a number of ways.
How was using a spreadsheet made obsolete by Ruling 2008-2?
__________________
DJBooya
"Try Not! Do or Do Not. There is no Try..."
Reply With Quote
  #24  
Old 02-21-2010, 8:47 PM
TripleT's Avatar
TripleT TripleT is offline
Member
 
Join Date: Dec 2008
Posts: 336
iTrader: 3 / 100%
Default

I've been using Wes's excel spreadsheet for at least six months after talking to my ATF contact who thought it looked great...

Not sure why somebody would think they couldn't use excel.

Heck, I have modified versions for a repair log, personal inventory as well as a high cap mag log.

I love excel...
Reply With Quote
  #25  
Old 02-21-2010, 9:05 PM
dirtyJ's Avatar
dirtyJ dirtyJ is offline
Senior Member
 
Join Date: Oct 2008
Location: Elk Grove
Posts: 1,003
iTrader: 29 / 100%
Default

My question about just using an excel type log is if all the special things the ATF used to require for electronic logs still apply. Are we required to print it out daily, or is that just good practice etc?
__________________
My posts are my own opinion and reflect no official positions of anyone other than myself.
Reply With Quote
  #26  
Old 02-22-2010, 5:28 AM
tenpercentfirearms's Avatar
tenpercentfirearms tenpercentfirearms is offline
Vendor/Retailer
 
Join Date: Apr 2005
Location: Taft, CA
Posts: 12,830
iTrader: 10 / 100%
Default

If you are going to solely use software, you no longer must apply for a variance, however, your software must comply with this document.

http://www.atf.gov/regulations-rulin...ing-2008-2.pdf

Quote:
Several firearms industry members have asked whether computerized records may be
maintained without obtaining written approval from ATF if they contain all the required
information specified in the regulations and are maintained in a permanent form.
Additionally, industry members have questioned whether computer records in combination
with paper records may be maintained if they are permanent and contain all the
information required by the regulations.
ATF has determined that acquisition and disposition records required by 27 CFR Part 478,
Subpart H, and 478.121, 478.122, 478.123, and 478.125(e), in computerized form,
satisfy the standard of permanency and are substantially equivalent to paper records if they
meet the following criteria:
1. All data entered into the computer system must be recorded into the database and
cannot be capable of being edited or modified at a later date without generating an
audit trail. The software system must retain any correction of errors as an entirely
new entry, without deleting or modifying the original entry. The system may allow
for entries in a notes column to explain any correction.
2. The system must have a reliable daily memory backup capability to protect the data
from accidental deletion or other system failure.
3. The system must meet the regulatory requirements for recording pertinent
information.
4. The system must allow queries by serial number, acquisition date, and name of the
manufacturer or importer. Commonly recognized trade names may be used when
recording the manufacturer/importer in the firearm description.
5. The FFL must periodically print all records from the system. Specifically, the
records must be printed:
(a) at least semiannually,
(b) upon request of an ATF officer,
(c) when the database is purged, and
(d) when the license is terminated
Printouts must be retained until the next printout is prepared.
The printouts must be limited to only the information required and specified by
regulation.
6. The FFL may download the required acquisition and disposition records to portable
storage devices such as Compact Discs (CDs), Digital Versatile Discs (DVDs), and
USB Flash Drives, instead of conducting the periodic printout of those records,
provided that the FFL presents the records in a printed format at ATF’s request. ATF
recognizes that printed records take up space and are not as easy to search as records
maintained in a digital format.
7. The computer printouts must contain firearms in inventory as well as all firearms
transferred during the period covered, sequentially by date of acquisition.
8. The system must record both the manufacturer and the importer of foreign-made
firearms.
9. Printouts may include antique firearms, but cannot include other merchandise.
However, antique firearms must be identified as “ANT” in the “firearm type” column.
10. The name and FFL number (if licensee) or name and address (if non-licensee) of the
supplier/consigner and the purchaser/transferee must be included in the computer
data. An ATF Form 4473 transaction number may be used in lieu of the address for
recording the transfer of a firearm to a non-licensee if the Forms 4473 are filed
numerically.
11. The system cannot rely upon invoices or other paper/manual systems to provide any
of the required information.
12. All required records including acquisition and disposition records, must remain at the
licensed premises.
13. Upon termination of a license, the FFL must provide an American Standard Code for
Information Interchange (ASCII) text file (in conformity with industry standards) and
a file description, in addition to printouts of all records, to the ATF Out-of-Business
Records Center. The printout and ASCII text file must contain the information as
prescribed by regulation. All records must be forwarded to the ATF Out-of-Business
Records Center in accordance with 27 CFR 478.127, including complete printouts,
and ASCII text file (and file description) of the A&D records, and all ATF Forms
4473.
As indicated above, FFLs must provide complete printouts and an ASCII text file (and file
description) of A/D records and all ATF Forms 4473 to the ATF Out-of-Business Records
Center upon discontinuance of business. The records should be submitted to the following
location:
ATF Out of Business Records Center
244 Needy Road
Martinsburg, West Virginia 25405
ATF Rul. 2007-4, which allowed a FFL who had an approved variance to use
computerized acquisition and disposition records to periodically download the required
records to portable storage devices instead of printing out such records, is superseded by
this ruling.
ATF finds that good cause exists for authorizing the use of a computers and portable
storage devices to create and maintain the records required by 27 CFR Part 478, Subpart H,
as the use of computers is accepted throughout the business community as a reliable, costefficient
means of maintaining business records. ATF also finds that the use of a computer
to maintain required records, contingent upon the requirements outlined above, is
consistent with the effect intended by the requirements of Subpart H, as it will result in a
permanent, reliable record that will accurately indicate acquisitions and dispositions of
firearms. Finally, ATF finds that the use of computer records properly containing all the
required information should not hinder the effective administration of the Federal firearms
laws or regulations – use of such records generally makes it easier for ATF to conduct
inventories of firearms on hand and to audit required records. Accordingly, ATF
concludes that the requirements for approval of an alternate method or procedure in
accordance with 27 CFR 478.22 are met.
Held, licensed manufacturers, licensed importers, and licensed dealers may use
computers to create and maintain acquisition and disposition records required by 18 U.S.C.
923(g)(1)(A) and 27 CFR 478.121, 478.122, 478.123, and 478.125(e), Subpart H, if the
system meets the above stated criteria.
Held further, licensees who wish to use computers to create and maintain their
acquisition and disposition firearms records in accordance with the requirements set forth
in this ruling are not required to obtain advance approval in accordance with 27 CFR
478.22.
Held further, if administrative difficulties arise through the use of portable storage
media instead of printouts, the FFL will be required to provide periodic paper printouts of
such records at the request of the Director, Industry Operations.
ATF Rul. 2007-4, approved June 26, 2007, is hereby superseded.
Date approved: August 25, 2008
Michael J. Sullivan
Acting Director
So Excel does not meet the ATF approval because there is no audit trail and it clearly fails #1.

So we only use Excel to print out our AD pages as we go. So officially, I am still on paper, but it is printed paper. It makes the records look nice and clean. I can also use my Excel file as back up should my paper copies get destroyed. More importantly I can use it to search my records and find guns by serial number immediately and know what page they are on in the bound book.

If you are still writing everything out by hand to start, stop! Go to Excel. Now when we sign guns out, we do it by hand and we also go back and manually type them in as well. This actually isn't so bad for three reasons. First, if you sit in front of the computer as you are signing guns out of the book, you can easily find what page they are on by searching for the serial number. No more flipping through pages looking for a gun. This actually is worth its weight in gold. Second, by then inputting the information in manually, you can also instantly know without having to look at the book who purchased a firearm. And finally, if you need to go back and reprint out some sheets for some reason, the data is there and ready to go.

I have been audited using this system and as TripleT stated he has also been audited using this system. Both sets of auditors (they were different) seemed rather happy with the set up. My auditors liked it because I just copy the main tab at the bottom during our audit. In effect I now have a brand new copy of the book to sort it how I please. So I sort it by deposition date, then by manufacturer and serial number and print out the pages with no deposition. I hand that to the auditor and as the other auditor reads out manufacturer and serial numbers, she checks them off. Makes an audit go through real quick. The easier you can make it on your auditors, the better in my opinion.

When the audit is all through, I just delete that new tab at the bottom I made and I am good to go. Just remember if you find mistakes as they go, you will need to fix them on the original tab that is still there, not the audit copy.

More importantly, we got nailed for having a bunch of missing guns. Well actually, 47 missing guns. However, they weren't missing, we just were failing to double check the deposition process. Using my POS software during the audit, I was finding these errors in less than a minute and get the bound book updated. Still the auditors still ding us for each one, so that is no good. In the end it is just a failure to log out, still a frowned upon situation.

So now we are going to to trimester audits in house. We use the same process the ATF uses. And we can do an audit in a day using the Excel print outs. We had to audit about 500-600 guns on our last audit. I also have a new tab at the bottom that tracks my audits too.

Best of all it was free and I am sending out free copies from ad@tenpercentfirearms.com.
__________________
For superior customer service and good prices visit www.tenpercentfirearms.com. We are Kern County's leader in black rifle sales.

The Calguns Foundation - Board Member. DONATE NOW! Your dollars go DIRECTLY to front-line legal activism in CA.
Opinions posted in this account are my own and not the approved position of The Calguns Foundation

Last edited by tenpercentfirearms; 04-11-2011 at 7:05 PM..
Reply With Quote
  #27  
Old 02-22-2010, 6:34 PM
Capt. Speirs's Avatar
Capt. Speirs Capt. Speirs is offline
Senior Member
 
Join Date: Oct 2008
Location: Orange County
Posts: 1,232
iTrader: 5 / 100%
Default

Slightly off topic; what do you use for a transaction serial number? My ATF agent said to use the month and year with a sequential number to make it easier to find specific guns. For Feb this year it would be; 0210xxx, xxx = sequential number 001, 002, 003, etc.
__________________
_____________________________________________
South Coast Outdoorsman
2736 E Chapman Ave
Orange CA 92869
714-532-4867
T - F (11 - 7pm) Sat (10 - 5pm) - closed Sun & Mon
_____________________________________________
Reply With Quote
  #28  
Old 02-22-2010, 10:24 PM
tenpercentfirearms's Avatar
tenpercentfirearms tenpercentfirearms is offline
Vendor/Retailer
 
Join Date: Apr 2005
Location: Taft, CA
Posts: 12,830
iTrader: 10 / 100%
Default

Quote:
Originally Posted by Capt. Speirs View Post
Slightly off topic; what do you use for a transaction serial number? My ATF agent said to use the month and year with a sequential number to make it easier to find specific guns. For Feb this year it would be; 0210xxx, xxx = sequential number 001, 002, 003, etc.
My problem with that system is it is too easy to end up duplicating numbers. So we now use our point of sale receipt number. What is nice about that is it makes referencing back and forth from the A&D to the POS really easy and since it keeps assigning numbers as I sell them, no duplicates.

Now your ATF agent might not like the idea that your number system has gaps. For example, if I sell you a gun on 14567, some ammo on 14568, and then another gun on 14569, then I have a one number gap. Nothing in the regs says that you have to use control numbers, nothing says they can't have gaps in your number system, and more importantly, you can organize them in three different ways: alphabetical, chronological, or by control number. When the area rep kind of didn't like my gap sequence, I simply told her I wasn't organizing them by control number, but by chronological order. She accepted that and we moved on.
__________________
For superior customer service and good prices visit www.tenpercentfirearms.com. We are Kern County's leader in black rifle sales.

The Calguns Foundation - Board Member. DONATE NOW! Your dollars go DIRECTLY to front-line legal activism in CA.
Opinions posted in this account are my own and not the approved position of The Calguns Foundation
Reply With Quote
  #29  
Old 02-23-2010, 3:07 PM
kemasa's Avatar
kemasa kemasa is offline
Calguns Addict
 
Join Date: Jun 2005
Location: Ventura County, CA
Posts: 7,189
iTrader: 5 / 100%
Default

If you are going to use the year and month, I would suggest having the year first so that the numbers always get larger, rather than being all over the place. It also helps if you sort by that field since otherwise all the same month will sort together for each different year.
__________________
Kemasa.
FFL Transfer/Special Order Dealer since 1993.
Net-FFL list maintainer.

Never try to teach a pig to sing. You waste your time and you annoy the pig. - Robert A. Heinlein
Reply With Quote
  #30  
Old 02-23-2010, 3:16 PM
ugimports's Avatar
ugimports ugimports is online now
Vendor/Retailer
 
Join Date: Jun 2009
Location: Fremont, CA
Posts: 2,442
iTrader: 18 / 100%
Default

Quote:
Originally Posted by Capt. Speirs View Post
Slightly off topic; what do you use for a transaction serial number? My ATF agent said to use the month and year with a sequential number to make it easier to find specific guns. For Feb this year it would be; 0210xxx, xxx = sequential number 001, 002, 003, etc.
I use:
YYYYMMDD-HHmm

right now would be:
20100223-1615

long, yes, but i use a computer to generate it. And I'll never have duplicates because if I have 2 people doing paperwork at the same time I just shift one by a minute.

Conceivably you could have duplicates, but that's not a scenario a 1 man shop will run into.
__________________
us on facebook
UG Imports - Fremont, CA FFL - Transfers, New Gun Sales
Closure Schedule: http://ugimports.com/closed
web: http://ugimports.com/calguns / email: sales@ugimports.com
twitter: http://twitter.com/ugimports / phone: (510) 371-GUNS (4867)
G+: http://google.com/+UGImportsLLCFremont / FB: http://facebook.com/ugimports
New Stock Announced on G+ and Facebook.
Reply With Quote
  #31  
Old 02-23-2010, 5:20 PM
PIRATE14 PIRATE14 is offline
Vendor/Retailer
 
Join Date: Dec 2005
Posts: 3,193
iTrader: 12 / 100%
Default

Well we jus use the DROS number to sequence our 4473s---same thing and it's easy to look up the same number instead of inventing a new one.

We used to use EXCEL and it worked for our first Audit but got hammered on it for the second.....

We are converting to AMIPRO and so far it hasn't had any hiccups but we need it too do more for us....but so far it seems good and it's not too expensive.....
__________________
CHECKOUT...http://cwstactical.com FOR ALL YOUR CALIFORNIA LEGAL AR-AK-HK RIFLES and BUILDS...

CWS....WE CAN GO HOT ANYTIME....

CALIFORNICATION AT IT'S BEST...

BRD....BLACK RIFLE DISEASE.......SPREAD IT!!!!!!!!!

Last edited by PIRATE14; 02-23-2010 at 5:23 PM..
Reply With Quote
  #32  
Old 02-23-2010, 5:25 PM
PIRATE14 PIRATE14 is offline
Vendor/Retailer
 
Join Date: Dec 2005
Posts: 3,193
iTrader: 12 / 100%
Default

Quote:
Originally Posted by denz View Post
I am giving away Aimi eBook Pro, just pay for shipping.
Lets chat....
__________________
CHECKOUT...http://cwstactical.com FOR ALL YOUR CALIFORNIA LEGAL AR-AK-HK RIFLES and BUILDS...

CWS....WE CAN GO HOT ANYTIME....

CALIFORNICATION AT IT'S BEST...

BRD....BLACK RIFLE DISEASE.......SPREAD IT!!!!!!!!!
Reply With Quote
  #33  
Old 03-01-2010, 10:29 AM
NewFrontierArmory's Avatar
NewFrontierArmory NewFrontierArmory is offline
Vendor/Retailer
 
Join Date: Dec 2009
Location: North Las Vegas, NV
Posts: 834
iTrader: 25 / 100%
Default

I use EBound by Gunderson Software.

It has its little quirks like any other program, but nothing huge.

Runs a good inventory and multiple handgun sale report, and stores all the info from other FFLS / Vendors for quick log ins when you re-buy from the same vendors.

You can also maintain a list of popular firearms and it will enter everything but the serial number into the "A" side for you when you type in something like "G19"

The search feature is great and has saved me **** tons of time pulling 4473's

What makes up for all the little quirks is the customer service. I screwed up while switching it from one pc to another at the office and they stayed on the phone with me for 2 hours until we got it all squared away.

Great folks and a great program.
__________________
Reply With Quote
  #34  
Old 03-01-2010, 10:45 AM
PolishMike's Avatar
PolishMike PolishMike is offline
Calguns Addict
 
Join Date: Nov 2007
Location: Tracy
Posts: 5,715
iTrader: 24 / 96%
Default

Didn't see it mentioned here.. I use cervelle software's POS system and it includes a a/d book. I like it because everything is tied to inventory. As soon as you get something it adds it to the book then when you complete the sale it fills out the rest automatically.

Their support has been extremely helpful as well.
Reply With Quote
  #35  
Old 04-28-2010, 9:33 PM
Lone Star Firearms Lone Star Firearms is offline
Junior Member
 
Join Date: Apr 2010
Posts: 1
iTrader: 0 / 0%
Default

Don't waste your money or time with Firearms Record Pro from Wolf Precision.
I have version 1.5. I now know why Wolf Precision does not offer a trial version to test the software. The software does not allow you to store Vendors or Customers. Unless you NEVER purchase more than one firearm from a distributor or sell more than one to an individual this will not be a problem. If you purchase 10 guns from a distributor, you will have to enter the distributor information 10 times, pretty advanced huh. They claim to be thinking of adding a Vendor database to it but replied that they will not do so for customers becuase of the possibility two people could share the same name. This does not seem to be an issue to the Social Security Administration, Department Of Motor Vehicles, offices of Vital Records (Birth Certificates), etc but Wolf Precision can not figure out that if two people have the same name, one is probably a Sr. and the other is a Jr. There are other products available that will do what this will not. Save yourself the money, this product is NOT ready for use in an FFL business... unless you like to repeadedly enter the same data unneccesarily.

Not to plug them but I will be continuing to use the free Firearms Management System provided by Sports South (distributor). You can enter other distributors in the database, it's not exclusive to them. The only reason I bought Wolf's crap was the backup. I was granted a variance by the Ft. Worth ATF office based on the screenshots I gave them from the Sports South software, it just does not offer a backup.

If any of you are comfortable with computers and have access to copies of XP, you can make sure you have backups by running a virtual machine within your current machine. Virtualbox is a free virtualization product from Sun. VMware workstation is pretty costly but does have a more polished look and feature set. You install VMware or VirtualBox, setup a guest with your Win XP disk and install the A/D software there. It is very easy to backup a virtual machine on a regular basis and should something happen to your Host machine (the OS you boot to) you can just copy the virtual image to a new computer running the same software (VMware/VirtualBox) and start the backed up image as if nothing ever happened. My ATF rep loved that idea since there would be redundancy with the electronic records (the virtual machine backups).
Reply With Quote
  #36  
Old 05-06-2010, 8:18 PM
gunenvy gunenvy is offline
Member
 
Join Date: Jan 2010
Location: Central Ohio
Posts: 171
iTrader: 0 / 0%
Default

We ended up writing our own, and had to take some strange things into account due to the ATF rules. Its web based, so we had to discuss with the ATF the fact that technically the data is not at the premises (its at our data center) etc.... fun so far and we have ways around that need anyway.

Its been fun putting it together, building the audit trail functions, attachment functions, automated printing etc... will probably publish it in time once we have all the requirements nailed down.
__________________
Watch our
Facebook Page for our giveaways and offers!
NRA Instructor and owner of The Gun Envy Store - 12,000+ Accessories.

Contact us if you need a Middle Man for transfers into CA.
Reply With Quote
  #37  
Old 05-07-2010, 8:02 AM
hegunshop's Avatar
hegunshop hegunshop is offline
Junior Member
 
Join Date: Apr 2010
Posts: 3
iTrader: 0 / 0%
Default Computer generated Bound Books

I like the idea of a computer generated bound book but doubt the ATF would like the idea. I have used a computer with a program I wrote in a database program called filepro about 10 years ago. I love it and would be lost without it. So I use the record number in my actual bound book that I use (I have gone through about 10 volums now and am using the Brownells books which seem to be nice and meet the ATF requirements) however I add one item on each entry and that is the record number in the software program for the 4473 form, the record number for the customer, and the record number for the gun. This allows me to put a lot more detail information regarding the gun, customer, and the sale to refer back to. It is not as complex as it sounds here and only takes seconds to do. So I guess I am blending both worlds and it works very well for me as out of hundreds of transactions both for gunsmith work and gun sales I have a lot of detail. I guess you could do a similiar thing in excel but I found that a relational database where it links everything together works really nice and smooth. My ATF agent is very happy each time he has dropped by and never a ding on the records so I guess if they are happy I am happy and can lay my hands on any 4473 in seconds instead of sorting through them for hours looking for one.
Dave HE Gunshop

Quote:
Originally Posted by rbetts View Post
I am somewhat of a computer guy, and I think a computer version of the A & D "Bound Book" would suit me well. Even though the ATF still wants us to print out lists and send them in with the software, I still think that this might be an option. Anyone gone this route yet?

What about the DROS paperwork? Taxes etc. I'm looking for workable solutions. All Ideas are welcome.

http://www.goldenstatetactical.com
Reply With Quote
  #38  
Old 12-10-2010, 5:48 AM
tenpercentfirearms's Avatar
tenpercentfirearms tenpercentfirearms is offline
Vendor/Retailer
 
Join Date: Apr 2005
Location: Taft, CA
Posts: 12,830
iTrader: 10 / 100%
Default

Did you guys know I get e-mails requesting this Excel sheet from all over the country? About one a week, sometimes more. Crazy.
__________________
For superior customer service and good prices visit www.tenpercentfirearms.com. We are Kern County's leader in black rifle sales.

The Calguns Foundation - Board Member. DONATE NOW! Your dollars go DIRECTLY to front-line legal activism in CA.
Opinions posted in this account are my own and not the approved position of The Calguns Foundation
Reply With Quote
  #39  
Old 12-10-2010, 6:21 AM
TripleT's Avatar
TripleT TripleT is offline
Member
 
Join Date: Dec 2008
Posts: 336
iTrader: 3 / 100%
Default

The Ten Percent Excel Bound Book has gone viral,,, nice !

It sure makes it easy to find a customer, firearm, vendor, etc.

As I said before, I asked my ATF contact about using it and we exchanged the format three times until it was how he wanted to see it. He then told me I would need to print out a copy at regular intervals (I'm printing it every six months) and store it for audit.

Thanks Again Wes !

Last edited by TripleT; 12-10-2010 at 6:28 AM..
Reply With Quote
  #40  
Old 12-10-2010, 12:05 PM
tenpercentfirearms's Avatar
tenpercentfirearms tenpercentfirearms is offline
Vendor/Retailer
 
Join Date: Apr 2005
Location: Taft, CA
Posts: 12,830
iTrader: 10 / 100%
Default

If you are printing it once a month you are in violation (assuming you didn't mod it to track changes and self back up). You in theory should be printing the last page every time you make a new acquisition.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT -8. The time now is 1:11 PM.




Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2016, vBulletin Solutions, Inc.
Proudly hosted by GeoVario the Premier 2A host.
Calguns.net, the 'Calguns' name and all associated variants and logos are ® Trademark and © Copyright 2002-2016, Calguns.net an Incorporated Company All Rights Reserved.