Question

EXPORT PAYROLL TO DESKTOP MAC

Forum|Forum|4 years ago
July 17, 2021
3 replies
0 views

How do I export from online payroll to Mac desktop into my check register. It was very easy until I started using the new version. I can export payroll taxes easy but not the employee check into.

QuickBooks Online

Rubielyn_J

I'm here to ensure you're able to export employee checks from QuickBooks Online to Desktop for Mac, @jheselius.

In preparing your transactions in a spreadsheet file, make sure that the items on it match the template on QuickBooks. This way, you'll be able to export them successfully.

To do this, here's how:

Go to the File menu, then choose Import.
Select Transactions and the transaction type you want to import.
Choose the gear menu, then click Export Table Template.
Enter a name, then save the template. This downloads the template in a .CSV (spreadsheet) file.
Open the template on your spreadsheet application.
Attach your transactions to the template, then save your work.

When you’re ready, here’s how to import your transactions.

Open your spreadsheet file.
In QuickBooks, go to File, then select Import.
Choose Transactions, then the transaction type you want to import.
Copy the transactions from your spreadsheet and paste them on the import window.
If everything looks right, click Import.

If the same thing happens, you can use an IIF file as another option.

Go to the QuickBooks payroll website.
Choose the employees and then the paycheck list.
Click on the box to the left of the paycheck you want to export.
Look for 3 boxes Print/Export to Accounting/Void.
Click Export to Accounting.

For more insights, feel free to review this article: Import data into QuickBooks for Mac.

Can I also ask if you encounter an error message when trying to export transactions from Online to Desktop for Mac? I appreciate any extra information you can give and it will help me isolate the issue and provide the best solution.

Additionally, let me share this resource to guide you fix some issues in exporting data: QuickBooks Desktop export troubleshooting (Mac, IIF, & One-Click).

Keep me posted if you have other concerns managing your data in QuickBooks. I'll be more than happy to help you further. Have a wonderful day!

R

rtovinpainting

Not working and very frustrating. A simple task before is now nearly impossible to figure out. This needs to be addressed ASAP..

C

ChristieAnn 11

Hi there, rtovinpainting.

Welcome to QuickBooks Community. This isn't the kind of impression that I'd like you to have, and we know how much time it can take when something isn’t working the way you need it. With this, I'll be sharing different details about exporting Online Payroll to QuickBooks for Mac to ensure your matter be addressed.

Standalone Payroll Product, QuickBooks Online Payroll (QBOP), and QuickBooks Desktop (QBDT) for Mac have various platforms. The QBOP version is both payroll and accounting software combined. If you're using the said version, you'll have to manually export your file from QBO to start sending your payroll data. Then, import them to your QBDT for the Mac company file. While doing this, I suggest downloading and using import kits so you can easier transfer data to and from different platforms to better manage company records in QuickBooks.

Before you import, I suggest to back up your company file. This is to ensure that you’ll be able to restore your company file and get back to work in case you ever run into a problem with your data. Then, know the IIF import limitations to smoothly execute the process.

Once you're ready to import your IIF payroll data, please follow the steps below.

Sign in to your company file as an admin.
Go to the File menu.
Choose Import.
Select From IIF Files and export your IIF file.
Follow the on-screen instructions to complete the procedure.

However, if you are using our Standalone Payroll Product, you'll have to export first your payroll transactions into QuickBooks Desktop. Then, import them into your Quickbooks Desktop for Mac. To start with, you'll have to Download a trial of QuickBooks Desktop link to get the version of QBDT. It provides license and product numbers you can enter upon installing the sample file. Then, you can refer to and click each article below to see the steps on how to perform the process so you can begin exporting your payroll data and import them to your QBDT for Mac.

I'm also adding this article to view different improved features designed to benefit your business using QuickBooks Desktop for Mac 2021: What's new in QuickBooks Desktop for Mac 2021.

Place a reply in the comments below if you have other issues with your payroll data in QuickBooks. I'll get back to you as soon as I can.

Rubielyn_J

Hi, @jheselius.

Hope you’re doing great. I wanted to see how everything is going about exporting the employee check concern you had the other day. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

Looking forward to your reply. Have a pleasant day ahead!

J

jheseliusAuthor

Thanks

Could not export form Intuit online payroll into Quickbooks desk top. We hit the 14500 limit. We started merging names and can now export payroll as before.

G

GlinetteC

It's good to have you back here, jheselius.

I'm glad to hear that merging the names helps you get back on track with exporting your payroll. The information you've shared will surely help other users having the same issue.

If you have any other concerns or questions, feel free to drop a comment below. The Community is always here to help.

C

Chelsea123

Hi, Im not an accountant, I am a business owner of 30 years. I am a plastering contractor about to throw in the towel because Quickbooks stopped syncing checks written to my men into my quickbooks for Mac. I since have migrated my desktop to my online payroll, but the new platform is not so simple for me. I just want the bank transactions to show up in my desktop for Mac like they used to do. but since I purchased the online payroll six months ago the syncing stopped and I had to manually enter in every transaction painstakingly. Can you help me sync my desktop for Mac to my bank accounts?

MJoy_D

I can guide you with fixing the issue you're having to sync your bank transactions to your QuickBooks Desktop for Mac, @Chelsea123.

First, make sure that you have the latest release for your QuickBooks Desktop for Mac. You can install the update from the QuickBooks menu. Check this article for detailed guidance: Update QuickBooks Desktop to the latest release. Then, create a backup of your QuickBooks company file to use the file in case you run into some problems.

Once done, make sure the financial institutions' list is up-to-date. You can do it by deleting the fidir.txt file from the Library or Applications. See this article for detailed guidance: Fix online banking issues in QuickBooks Desktop for Mac. You can also follow the next solutions provided in this article if the first one didn't work.

After downloading transactions from your bank and you already have similar entries in your register, here's how you can add and match those transactions to avoid duplicates: Add and match transactions in QuickBooks Desktop for Mac.

Let me know if you need further help with syncing your bank and QuickBooks. I'm here to assist. Have a wonderful day!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded