Quicken for Windows Quicken for Mac Upgrading? With Quicken, you can view your banking, investment, retirement, and credit card accounts - all in one place.*. Stay on top of your spending by tracking what's left after the bills are paid. For someone like me who likes to track my investments in detail, this is a deal breaker, though it’s better than Banktivity’s investment section. Quicken for Mac is currently the best investment monitoring tool on the market for a Macintosh. Though that’s not saying much.

Change the width of columns so that you can see all the data in cells. Excel for mac step by step. Use the Paste Special command to copy and paste special cell contents or attributes. Prevent unauthorized changes, moves, or deletions of important data. Keep column headings visible while you scroll.

If you’ve been a Quicken user for any length time you’re well aware that the look and feel of the app has gone through some considerable changes over the last several years. Not to mention a brief name change from Quicken to Quicken Essentials and back to Quicken again., the application resulting from this mini-morphing over the years, is a solid tool for managing your personal finances that remains as easy to use as was its predecessors, but it’s no longer the only personal financial player in the game. Quick on the setup The setup of Quicken 2016 is a little uncomfortable from the jump, as it requires that you use a Quicken ID in order to set the app up. While I understand the purpose of using a Quicken ID—it’s used to sync Quicken data on your Mac with iOS devices—I don’t like that this is a requirement for using Quicken. Being able to save data in a local file seems, to me, to be something I should be able to do without linking to Intuit’s back-end, particularly if I have no plans to sync Quicken with any of my mobile devices.

Also, once you log in you’re also required to complete a survey before you can begin using the app. Another unnecessary required step. After signing in to your banking account, Quicken 2016 lets you select which accounts you want to sync. Once you complete those initial steps you’re off to the races. Quicken is designed to sync with your bank’s online banking services, but you do have the option of creating manual entry accounts if you want. I was easily able to create a link to accounts I had with two banks, but was unable to link to a credit union account because of the way that bank’s authorization system works.

In short, that bank’s website requires that you enter answers to personal questions from a drop down menu. Quicken would only allow me to enter an answer by typing into into a field, which my banking site would not accept. Once you log in to your banking site, Quicken lets you to select the accounts you want the app to automatically download transactions from. When selecting accounts to sync, you also have the option of customizing the names of those accounts.

Quicken downloads transactions for the accounts you link—typically three months worth of data, depending on your bank—as soon as you add them. Quicken ships with a pre-defined collection of categories and does a great job of linking imported transactions to existing categories, although you’ll likely want to double check to make sure everything matches up correctly the first few times you import transactions. I found that I needed to refine or edit categories to make them work for my specific needs. The quick report One of the benefits of automatically mapped categories is that you have instant access to a reasonably good set of reports. Quicken 2016 ships with nine reports, such as account and category summaries, net worth, and monthly spending, six of which can be customized and saved for later use. There’s also a Spending Cloud report, which is a vestige of Quicken Essentials and is more of a toy than a useful tool.

Quicken 2016’s Overview screen helps you keep tabs on your income, expenses, and upcoming bills. Oddly, there is no way to create a custom report using any of Quicken’s menus. Instead you have to open one of the pre-defined reports, such as the Category Summary, select the date range, accounts, categories, and tags you want to use in your report and then select the “Save as custom report” checkbox before you click the OK button to run the report. Once saved, you can run or customize the report by selecting it from Quicken 2016’s sidebar. In addition to Quicken’s standard set of reports the app also provides a quick overview of your transactions, income, and assets, and lets you see whether or not you’re meeting the budgets you’ve created for yourself. The quick track on investments and budgets Existing Quicken 2016 reports can be customized and saved for reuse. As mentioned in the previous paragraph, Quicken 2016 can track investment income and help you set budgets for every spending category.