What accounting program is everyone using? How happy are you with it? Do you also use a accountant as well as the program? Thanks in advance for the insight.
- posted
16 years ago
What accounting program is everyone using? How happy are you with it? Do you also use a accountant as well as the program? Thanks in advance for the insight.
I'm using Quickbooks 2007 with HQ/RMS 2.0. DO NOT use this combo for the following reasons:
Despite those limitations, I've used QB for years and like it - it's really easy to use and fairly intuitive. It does have limitations, tho; especially when you get to multi-store scenarios. Get an accountant to get started, but once you get everything set up and running smoothly, you should be able to most of it on your own. I'm able to do my payroll, taxes, purchase orders, receivables and payables on my own. And that's
99% of that I do most of the day (> What accounting program is everyone using? How happy are you with it? Do youThis is another "do not use" recommendation.
Do not use QB Online Edition. It does not support import of .iif files.
I also agree with Jennifer. You can't create .iif files at HQ. This makes it very time consuming to create import files at each store to import to QB. Furthermore, it creates a LOT of journal entries, making it hard to track things down in the future.
The problem with creating the .iif files at HQ would be the account mapping. Each of my stores does deposits to seperate banks, and hence seperate accounts in QB. I do not want to waste time with using the undeposited funds account, so I have each store set up for closing cash to go directly to the appropriate bank account in QB. I think this would be very difficult to implement if the .iif files were done at HQ. All of the required data is right there at HQ, but the .iif files cannot be created.
So I do my journal entries manually with QBOE. It takes about 20 minutes each day for 6 locations. I use a Crystal Report within HQ to get the required data. Unfortunately, the Batch table does not have over/short, so I can't get all of the required information there. It's a hassle, but it works.
I also have same problem in importing transactions and journal entry of complete batch in QB for my client . So I make a small program in java that reads the data (which is stored in MS Access or it can be in excel or csv also) and creates another excel file that exactly have iif type data.
This solution works if we have input data in same structure. In case the structure changes we will have to alter fields in the program.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.