How To Input Paystub In Quicken For Mac

Posted on  by 

Quicken is the most powerful money management software on the market. Learn more.For more Tips and Tricks, visit:https://www.quicken.

How
  • Quicken offers tiered pricing options based on the features you use, as well as the product you choose. Quicken, like many other personal finance software applications, has shifted to a subscription model. You pay every year. Quicken for PC: Minimum = $34.99, Maximum = $99.99; Quicken for Mac: Minimum = $34.99, Maximum = $74.99.
  • Bill Pay Quicken For Mac Is anyone here regularly using the Bill Pay on Quicken for Mac? I've been evaluating features of Quicken and Banktivity and Quicken's bill pay seems to be one of the big standout features, however, I've always used my bank's bill pay service and it's been great.
  • Quicken does a lot. That's partly how it's remained one of the most popular financial software tools for decades. But all the features it offers can be overwhelming to newcomers, and even regular users can feel like they aren't using Quicken to its full potential.

When Apple launched the Apple Card, it came without any way to export your transactions such that you could import the data into a personal finance app—all you could get out was a PDF. Apple started to rectify that glaring lapse at the beginning of the year by adding the capability to export transaction data in CSV (Comma Separated Values) format (see “Apple Card (Finally) Gains CSV Statement Export,” 23 January 2020).

However, CSV format wasn’t sufficient for many personal finance apps. In February 2020, Apple added support for OFX (Open Financial Exchange) format. It was a somewhat troubled release, with TidBITS Talk participants trading tips on how to edit exported files to get them to import properly into various apps. Apple worked out the kinks over the next few months, and the complaints died down.

Now Apple has extended the formats available to Apple Card users even further by adding support for Quicken’s proprietary QFX (Quicken Financial Exchange) format, which is an extension of OFX, and the QBO format used by Intuit’s QuickBooks. Here’s how you export those formats:

  1. Open the Wallet app on your iPhone.
  2. Tap your card balance.
  3. Under Statements, tap the desired month.
  4. Tap Export Transactions.
  5. Choose either Quicken Financial Exchange or QuickBooks. Comma Separated Values and Open Financial Exchange are still options.
  6. Choose the destination from the share sheet. The easiest ways to get them to your Mac are probably AirDrop (your Mac might be an AirDrop shortcut at the top of the share sheet), which will send the exported file to your `~/Downloads` folder, or Save to Files (pick a location in iCloud Drive).

For something that’s human-readable, you can still download your statement as a PDF. In Step 4 above, instead of tapping Export Transactions, tap Download PDF Statement.

Here’s how you can use the various formats Apple Card can now export:

  • QFX: Import into Quicken by choosing File > Import > Bank or Brokerage File.
  • QBO: In QuickBooks, choose File > Utilities > Import and then Web Connect Files.
  • OFX: Import into any app that supports this format, like Banktivity, Moneydance, and You Need a Budget.
  • CSV: Open in any spreadsheet or import into an app that supports CSV import and lets you map import fields appropriately.
  • PDF: File for later reference or print; it’s not structured data that you can import.

If anyone has figured out how to automate this process with Shortcuts, let us know!

Now if only Apple would let multiple people in a family share an Apple Card. Other common requests include the capability to download transaction data without waiting for a statement and support for other countries. How else would you like to see Apple improve the Apple Card experience?

To do payroll in Quicken 2013 or 2014, you need to set up a couple of payroll expense categories. Fortunately, doing so is not particularly difficult. This information is specific to setting up U.S. federal income and payroll taxes.

If you employ people in a state that has a state income tax — California, say — you may also have to deal with state payroll taxes. But you can track and process these the same way you process the federal taxes. (Some counties and cities even have income taxes, but these should also work the same way.)

Set up the wages expense category

You need to set up a payroll expense category for tracking the wages you pay employees:

How To Input Pay Stub In Quicken For Mac Os

How to input pay stub in quicken for mac 2020
  1. Choose Tools→Category List.

    Quicken, with no hesitation, displays the Category List window.

  2. Click the New button.

    Quicken displays the Set Up Category dialog box.

  3. Enter Wages as the category name by moving the cursor to the Category Name text box and typing Wages.

    If you told Quicken during the setup that you’ll use Quicken to track a business, Quicken may have automatically set up the Wages category.

  4. (Optional) Enter a description of the category.

    If you want, you can type a description in the Description text box.

  5. Select the Expense option button.

    This choice tells Quicken that you’re setting up an expense category.

  6. (Optional) Describe the tax characteristics of this category.

    To further describe taxable income and tax deduction categories, click the Tax Reporting tab and then select the Tax-Related check box.

  7. Click OK.

    Quicken adds the category to the category list and redisplays the Category List window.

Set up the payroll tax expense category

Mac

You also need to set up a payroll tax category to track payroll taxes that the employer pays, including the company’s share of Social Security taxes, the company’s share of Medicare taxes, and any other employer payroll taxes (such as federal unemployment tax or the equivalent state employer taxes).

Request an employer ID number

First, you need to file an SS-4, or Request for Employer Identification Number form, with the Internal Revenue Service (IRS) so that you can get an Employer Identification Number. You can get this form by calling the IRS.

In one of its cooler moves, the IRS allows you to apply for and receive an Employer Identification Number right online. Visit the website, and then click the Apply for an Employer Identification Number (EIN) Online link located on the left side of the page.

Social Security, Medicare, and withholding taxes

You need to do two things before you can figure out how to handle all those taxes. First, you need your employees to fill out W-4 forms to let you know what filing status they’ll use and how many withholding allowances, or personal exemptions, they’ll claim. You can get blank W-4 forms from the IRS, too.

While you’re visiting the IRS website, you also need to get a Circular E Employer’s Tax Guide publication. The Circular E publication is the pamphlet that tells you how much you should withhold in federal income taxes, Social Security, and Medicare from employees’ salaries based on what they say about their filing statuses and the number of withholding allowances they claim on the W-4 forms.

Pay someone for a job well done

After you set up the two needed expense categories within Quicken and after you collect the necessary tax information, you’re ready to pay someone.

Figure out the gross wages figure

Determining how much to pay your employees should be pretty easy. Does Raoul make $15 per hour? Did he work 40 hours? Then you owe him $600 because $15 times 40 equals $600. Is Betty’s salary $400 per week? Then you owe her $400 for the week.

Calculate that deductions stuff

Your next step — after you know how much you’re supposed to pay Raoul and Betty — is to figure out what Uncle Sam says you must withhold.

To determine this amount, you need both Raoul’s and Betty’s W-4s to find out their filing statuses and personal exemptions. Then just flip to the page in the Circular E that describes withholding for persons claiming those filing statuses and weekly pay.

If Raoul is single and claims just one personal exemption, for example, you need to flip to the page that shows appropriate withholding amounts for single people receiving weekly payroll checks. That page shows a table that will clearly indicate what you’re supposed to withhold from Raoul’s check for federal income taxes.

How To Input Pay Stub In Quicken For Mac Download

Fictional Betty’s pay is $400 per week. If Betty’s filing status is married, she is filing jointly, and has three personal exemptions, you’d need to need to flip to the page in the Circular E that shows withholding amounts for a married person filing a joint return when the person claims three withholding allowances.

You determine Social Security and Medicare amounts by multiplying the gross wage figure by a set percentage. Social Security is probably 6.2 percent of the gross wages up to roughly $110,000. The Medicare tax is 1.45 percent of the gross wages with no wage limit. Be sure to check your faithful Circular E if you think limits come into play for a particular employee.

Figure out someone’s net wages

The table summarizes the payroll calculations based on the examples.

Payroll for Raoul and Betty
ItemRaoulBettyExplanation
Gross Wages$600$400Their pay
Withholding$79$18From Circular E
Social Security$37.20$24.806.2% of gross wages
Medicare$8.70$5.801.45% of gross wages
Net Wages$475.10$351.40What’s left over

Other taxes and deductions

If you have other taxes and deductions to make and you know how the federal income taxes, Social Security taxes, and Medicare taxes work, you won’t have any problem working with other taxes — whatever they are.

In general, you treat other taxes and the amounts the employee pays similarly.

Record a payroll check

How To Input Pay Stub In Quicken For Mac 2020

After you make the tax deduction and net wages calculation, you’re ready to record the check. Suppose that you’re going to record the check by using the Write Checks window. After you display the window, follow these steps:

How To Input Pay Stub In Quicken For Mac Free

  1. Enter the date of the payroll check in the Date field.

  2. Enter the payroll check number in the Num field.

  3. Enter the employee name in the Payee field.

  4. Enter the net wages amount in the Payment field.

  5. Categorize the payroll tax as wages.

    Specify the expense category as Wages.

  6. To record the payroll check, click Record Check.

Coments are closed