Does Quicken For Mac Allow Custom Categories?

Posted on  by 



Quicken for Mac still trails Quicken for Windows in ease of use, interface (i.e., navigation), intuitiveness, versatility, and features. Quicken for Mac also falls a bit short when it comes to investment tools, especially in regard to its lack of automatic cost-basis calculations. Another area that people have complaints about is the interface. 1.3K discussions 6.4K comments Most recent: Quicken matching downloaded transactions to very old reconciled ones instead of current (Q Mac) by shannh10 6:00AM Expand for more options. Instructions To customize a report for a category, category group, or a tag: In Quicken, click the Reports menu and open the report you want to customize. Then, click the Customize gear icon on the upper-right. Quicken has been around for a long time. There are Quicken versions for Windows and Mac. Updates to Quicken for Mac were sporadic at best until Intuit sold the software to H.I.G. But now that the Quicken product line is under new ownership, the Mac side hasn't been neglected as much. Still, there are differences between the two products. For those with a Mac looking for software, Banktivity is an excellent choice. Much like Quicken, you can connect bank accounts, credit cards, mortgages, and even investment accounts.

Intuit is not a Mac friendly company. They make an OS X version of Quicken, but it is artificially crippled in order to try to get banks to pay them money. Intuit will only let you import files from banks that pay extra to let their customers download transactions into Quicken for Mac. The fact that you paid for Quicken and the bank paid for a Quicken server isn’t enough. They want the banks to pay another fee for their Mac users–even though there is no additional hardware or software involved. The end result is that Mac users get a product that will only work with a handful of banks. This article discusses a method to get around this limitation.

When I used a PC I was a heavy Microsoft Money user. When I switched to a Mac, I assumed that after all the good things I had heard about Quicken that I’d be better off. This did not turn out to be the case. I bought a copy of Quicken, installed it, headed over to my bank’s website and downloaded the QFX file using the WebConnect button and told Quicken to import it. I was greeted with the following error box.

“Unable to verify the financial institution information for this download” makes it sound as if there is a technical problem that should be cleared up soon. I waited 30 minutes and tried again with the same results. The next day I tried it again and got the same error message. After about a week of following the instructions telling me to “try again later”. I gave up and called tech support.

Me: Why can’t I import a QFX file into Quicken Mac.
Quicken: Because your bank doesn’t support Mac QFX files.
Me: But they are both text files based on the OFX standard.
Quicken: But banks decide which formats they want to support.
Me: Are you telling me that there is a difference between an QFX file for a Mac and one for a PC.
Quicken: Yes they are different.
Me: Why would people use OFX if it was limited to only one platform?
Quicken: I don’t know.
Me: Ok on a bank that supports the “Mac format” there is only one link to download. How can it be a different file?
Quicken: I don’t know, but banks have to support the Mac format for Mac users.
Me: I’m looking at a QFX file right now from a bank that supports Macs and one that doesn’t. The file format is identical.
Quicken: No they are different.

It was at this point that I realized I was not going to get anywhere with tech support. So I started trying to figure out what was causing the problem myself.

I don’t know what it is like to use their PC product, but from an OS X standpoint Quicken is Evil. It isn’t that their product is bad, it is that they follow absurd business practices that will make your life miserable if you are using something other than Windows. If you go to the Quicken site and look at their list of supported banks, it looks very good and reassuring. Most major banks are listed, so it should be no problem to download and import transactions. The problem is in the fine print. Very few of the banks support “Quicken for Mac”. This seems odd because the OFX, QFX and QIF file formats are completely independent of the operating system. In fact that is the whole point of OFX–to have a platform independent way of representing financial data. It should work on PalmOS, OS X, Windows, Linux, HPUX, anything.
In older versions of Quicken and other money management software, you’d simply download a .QIF file and import it. QFX can work the same way, but it contains additional information about your account and bank. Most banks have upgraded to using QFX (WebConnect) because it helps prevent repeat transactions so you don’t have to be as careful about selecting the exact dates for import.

It turns out that when you try to import a QFX file, Quicken looks at the ID of the banking institution in the file and then goes to the Intuit web site and asks if it should allow you to import the file. Intuit’s site sees that the request is coming from a Mac and then checks to see if the bank with that ID is listed as supporting the Macs. If they don’t Intuit sends back a message telling Quicken to not allow the file to be imported. Banks have to pay Intuit extra money to say that they support Mac. Since the number of Mac users is smaller than PC users, many banks don’t pay the extra fee. In my opinion this amounts to artificially crippling their product for Mac users. The files are identical for any type of computer.

There is a way around this stupid limitation. You simply tell the QFX file to use a different Bank ID number. If you choose a bank that supports “mac format”, Intuit will let you import the file.

First download the QFX (webconnect) file from your bank and then open it in a text editor. You should see a section that looks something that looks like:

INTU.BID stands for the Intuit Bank ID. and INTU.USERID is the bank’s user id. These two numbers function as the username and password to allow or disallow Mac users from importing files. Intuit allows Washington Mutual (shown above) to let their customers use Quicken on a Mac, so by replacing your INTU.BID and INTU.USERID sections with what is shown above you can import the file.

Quicken For Mac Reviews

It can be a little tricky to get the file imported because you’ll need to make sure Quicken associates it with the correct account. You may need to change the name of the bank on your account before you import the file. The easiest way is to create a new account when you import the file as shown in the image. You can then go in and edit the name of the account, but you’ll need to leave the name of the bank set to Washington Mutual.

I think it is stupid that you have to do a work around like this to do something as simple as importing a file of text data, but evidentally it is part of Intuit business model. It should be fairly easy to write an automator script or use folder actions to automatically replace the necessary lines. If you are interested in seeing a future article about how to setup automatic conversion, leave a note in the comments. (update: automated method article)

Does Quicken For Mac Allow Custom Categories Items

Another possible way to work around the limitation is to redirect all traffic to Intuit to your local machine and return the proper codes to authorize the transaction regardless of which bank a QFX file comes from. Ideally someone could setup their own server to act like Intuit’s server and return affirmitive responses to all requests.

Update: more information in a new article

Related articles:

Custom
Load more

Personal Finance Software For Mac

Quicken 2012 supplies categories to, well, categorize your spending. For example, you would probably use the Rent category to categorize all the checks you write to pay rent. The predefined categories list may be just what you want. Then again, it may not.

The Category List
CategoriesDescriptions
Income Categories
Div IncomeDividends earned from stocks you own
Interest IncInterest income on bank accounts, and so on
Net SalaryYour net-of-taxes income from a job
Net Salary SpouseYour spouse’s net-of-taxes income from a job
Other IncIncome that doesn’t fit into another category
Expense Categories
Auto & TransportThe big “catchall” category for auto and transportation
expenses
Auto InsuranceCar insurance premiums
Auto PaymentCar loan or lease payments
Car WashCar washes and (maybe) detailing?
Gas & FuelGas, diesel, biodiesel, and so on
ParkingParking and hopefully no parking tickets
Public TransportationBus, subway, elevated and commuter trains, and rickshaws (in
some areas)
RegistrationVehicle registration fees
Service & PartsServices and repairs expenses
TollsToll charges
Bills & UtilitiesThe big general category for regular bills and utilities
expenses
Credit Card PaymentAmounts paid on your credit card when you’re not tracking this
stuff in granular detail
Home PhoneLand line phone
InternetInternet service provider
Mobile PhoneCell phone (and text messaging?)
TelevisionCable television
UtilitiesWater, sewer, electricity, and gas
Cash & ATMPocket spending via ATM and mad money
Deposit to SavingsNot a real spending category, but a shortcut for people who
don’t want to set up a savings account
EducationThe general category for education
Books & SuppliesBooks and other school supplies
Student LoanStudent loan payments
TuitionTuition and lab fees
EntertainmentCatchall “parent” category for entertainment spending
AmusementHey, whatever spins your propeller
ArtsCatchall “subcategory” for stuff that follows
Movies & DVDsMovie rentals and purchases as well as cinema tickets
MusicMusic CDs, music downloads, street musician payments
Newspaper & MagazinesPeriodical subscriptions
Fees & ChargesCatchall “parent” category for bank, credit card, and similar
fees
ATM FeeCash machine charges
Bank FeeBank fees, penalties, and service charges
Late FeeLate fees charged by vendors
Service FeeMiscellaneous service charges
Trade CommissionsBroker commissions
FinancialCatchall “parent” category for financial services and
products
Financial AdvisorInvestment advisor fees
Life InsuranceLife insurance premiums
Food & DiningAnother “catchall” parent category
Alcohol & BarsYeah, I wanted to talk to you about this
Coffee ShopsCaffeine expenditures
Fast FoodWhat you should eat less of
GroceriesWhat you should eat more of
RestaurantsRestaurant charges, including gratuities
Gifts & DonationsThe giving “parent” category
CharityGifts to nonprofit, religious, and similar organizations
GiftUsually for gifts to family members and friends
Health & FitnessThe parent category for all your medical and fitness related
expenses
DentistDentistry expenses
DoctorPhysician’s fees
EyecareOptometrist fees, eyeglasses, contacts, and similar items
GymFitness club and gym expenses and fees
PharmacyPrescriptions and over-the-counter expenses
SportsSporting expenses and similar activities
HomeHousehold expenses “parent” category
FurnishingsFurniture and accessories
HOA DuesHomeowners association dues
Home ImprovementHome repairs and improvements
Home InsuranceHomeowners & Renters insurance
Home ServicesHome cleaning and maintenance services
Home SuppliesHome cleaning and maintenance supplies
Lawn & GardenLandscaping-type expenses
Mortgage & RentMortgage principal payments (for people not tracking mortgage
loan balances) and rent payments
Mortgage InterestInterest component of a home mortgage payment
Interest ExpInterest expense on personal lines of credit and other
non-mortgage debts
IRA ContributionIndividual retirement account contribution
KidsCatchall “parent” category for Kids-related subcategories
AllowanceKids’ allowance money
Baby SuppliesDiapers, and so forth
Babysitter & DaycareCosts of childcare
Kids ActivitiesLittle League, dance classes, Karate summer camp, and so
forth
ToysToys, games, computer games
Misc.Stuff you can’t categorize someplace else
Not SureStuff you can’t categorize someplace else and yet oddly feel
uncomfortable putting into the Misc. category
Personal CareThe catchall “parent” category for the personal care
subcategories
HairHaircuts, colorings, extensions, weaves, and other
what-have-you’s
LaundryDry cleaning and other laundry services
Spa & MassageSpa treatments, massage therapy
PetsThe catchall “parent” category for pet-related expenses
Pet Food & SuppliesWhat you feed Rover and Twinkle the cat
Pet GroomingDog shampoos, cat shampoos, nail clippings
VetVeterinarian bills
ShoppingThe catchall “shopping” category
BooksMy personal weakness
ClothingWork and casual clothing, including shoes
Electronics & SoftwareElectronics (including computer) gear and software
HobbiesHobby and craft expenses and activity costs
Sporting GoodsSporting and recreational equipment
TaxPersonal tax expenses “parent” category
PropertyReal estate and personal property taxes
TravelPersonal travel expenses
Air TravelAirplane tickets
HotelHotel and other lodging charges
Rental Car & TaxiRental cars, taxis, and similar costs (including airport
transfers)
VacationPersonal and family vacation expenses




Coments are closed