My client has a 40 unit SRO (Single Room Occupancy) Hotel. An SRO, for those who do not know, acts similar to a hotel except there are shared bathrooms and a shared kitchen. Some occupants are residential; some are tourists/transient. The rooms mostly come furnished (except for residential tenants who decide to bring their own). We have a cleaning staff who has supplies and we provide linens, etc. We are also not as formal as a hotel. I am familiar with QB and the way it works. I am looking for an app or a way to use QB online to my advantage. That is to somehow "track" (I use that loosely) the furniture, supplies, and linens. Supplies: We buy a bulk amount each month. It is not sold, and we use about 90% of whatever we buy each month. So it's not inventory. I could use the non-inventory item but is there a report or a way, even if I export and manipulate it some, to print what I purchased and use it to give to staff for quicker ordering? Right now we use an excel sheet. Would PO's work? Linen: We buy linens and store them every. Do any hospitality members have tips on how to keep track of them. For example, I purchased a bulk amount of blankets. They were received, and now I don't know which rooms have them, if I have any left to use, etc. Again, is there any way to use QB to help me with this? The value of these is not necessarily an inventory/asset item; more consumables that are fully expensed. Furniture: I'd like to keep track of what furniture we have. Not so much for Balance Sheet purposes as some of it is bought and expensed. But to assist in knowing where the furniture is located. Is there a way for QB to help with this? I realize this isn't really something QB does and the solution to my question is probably going to require some creativity. But that is why I am coming to the community. Thanks so much!
... View more
I have a lot of clients who for one reason or another don't link their bank accounts and can't seem to download a csv file. That or the banks/cc companies don't have it as an option. Thus, I too am often stuck with .pdfs to somehow convert. Most of the apps just don't work right for one reason or another (although I do use csv2qbo for desktop clients A LOT!) Since, I know a few developer friends, I have had them create a script that takes a .txt file (see below) and converts it to a csv. Since the statement has a lot of text that isn't necessary, I open the text file and delete that information. The script works good for formatting and recognizes dates and spacing in order to efficiently separate items into correct columns. I then open the csv and edit it some as it does occasionally miss things. But I am also updating the script as I find things. It works wonderfully for Bank of America Statements. And MOST DEF better than converting to Word. If anyone is interested in knowing more let me know. I could possibly have this created on the web and modified for each banks specific statements. Right now I just run it from my desktop.
... View more