How do I export payroll taxes to quick books?

Hello caro6!

I understand that you need to bring in your payroll taxes into QuickBooks Online. I'm here to help you.

You can add your prior payroll if you're a new user of QuickBooks Online Payroll. Note that you only need to enter the data from the current calendar year.

When setting up the payroll account, you'll see the How much did you pay [employee] this year? page. Simply select +Enter [year] prior pay details to add the data. Please check this link for the detailed steps: Set up a prior payroll for QuickBooks Online Payroll.

If you're subscribed to QuickBooks Online without a payroll service, you can record them using a journal entry. You'll want to seek some help from your accountant on how to use this method if you're unfamiliar. We also have an article for your reference: Manually enter payroll paychecks in QuickBooks Online.

QuickBooks Online Payroll allows you to settle your taxes online. If you want to use this service, you can check these links for more details:

• Pay and file payroll taxes online

• Get answers to your payroll tax payment and filing questions

Keep on posting here and we'll assist you. Take care!

Thank for the reply but this didn't help. I need to export payroll taxes paid to my quickbooks on mac (not online). I need to select two payments and export. How do I do that and why is this not an automatic option like before?

Let me guide you on how to export payroll taxes to QuickBooks for Mac, caro6.

But before we start, you'll want to make sure that item fields on your spreadsheet match with QuickBooks. Then, here's how to get a QuickBooks template for your transactions:

1. Go to File, then Import.
2. Select Transactions, then the transaction type you want to import.
3. Select the gear menu, then Export Table Template.
4. Enter a name, then save the template. This downloads the template in a .CSV (spreadsheet) file.
5. Open the template on your spreadsheet application. There are many columns on the template, and you may need to scroll to see all of them.
6. Add your transactions to the template, then save your work.

   (For sales receipts) On the Deposit To column, be sure to specify the bank account type in your company file.

Next, you can now import your transactions.

1. Open your spreadsheet file.
2. In QuickBooks, go to File, then Import.
3. Select Transactions, then the transaction type you want to import.
4. Copy the transactions from your spreadsheet and paste them on the import window. QuickBooks will highlight rows that have the same info to alert you on transactions with multiple line items.
5. (For sales receipts) Select the bank you would like to deposit the receipts.
6. If everything looks right, select Import.

Sometimes, QuickBooks leaves a blank row if it can't add transactions. To fix this, you can go to Step 3 of this article: Import Data Into QuickBooks for Mac.

In addition, I've added this article to guide you in case you have some issues in exporting data: QuickBooks Desktop export troubleshooting (Mac, IIF, & One-Click).

Feel free to let me know if you have any concerns in importing your data. I'm always right here to assist you further. 

Thank you again for your response. But why is this now such a long and complicated task when before in Intuit you just pressed export and it download a file that you then clicked on and, boom, that was it. I don't want to create spread sheets and all that stuff and go through a million steps. Why is export not automatically an option after you've made the tax payments or paid employees?

Thanks for your prompt reply, caro6.

Let me clear things up regarding the export process. 

It seems that you are using the standalone version of QuickBooks Online. You don't have to create a spreadsheet to export the tax payments. Just like the Intuit version, you can export the data by following these steps:

1. Go to the Gear > Payroll settings.
2. In the Export section, click the Export transactions link. This will download an IIF file which you can use to import into your QuickBooks Desktop for Mac. Make sure to save the file where you can easily find it. 

After saving the file, you can now import it by following the steps below. Before doing so, please make sure to create a back up copy of your company file.

1. In your QuickBooks Desktop for Mac, go to the File menu.
2. Select Import.
3. Click From IIF Files, choose the downloaded IIF file.

For reference on the steps above, you can read this article: Export into QuickBooks Online or Desktop from Core, Premium, or Elite Standalone Payroll.

Please let me know in your reply if you have any follow-up questions or other concerns. I'd be glad to help you out again. Keep safe.